Analytics Catalog/Data dictionary/RA_CUSTOMER_TRX_LINES_ALL
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

RA_CUSTOMER_TRX_LINES_ALL

ReceivablesUsed in 7 subject areas56 reporting columns

Receivables (RA), customer transaction lines (item, tax, freight).

Primary key: CUSTOMER_TRX_LINE_ID

Columns

ColumnKeyIn reportsDescription (inferred)
ACCOUNTING_RULE_DURATION●Accounting rule duration.
AMOUNT_INCLUDES_TAX_FLAG●Indicator (Y/N) for the amount includes tax.
ASSESSABLE_VALUE●Assessable value.
AUTOTAX●Autotax.
CUSTOMER_TRX_LINE_IDPK○Identifier for the customer transaction line.
DEFERRAL_EXCLUSION_FLAG●Indicator (Y/N) for the deferral exclusion.
DESCRIPTION●Description.
EXTENDED_ACCTD_AMOUNT●Extended acctd amount.
EXTENDED_AMOUNT●Extended amount.
GROSS_EXTENDED_AMOUNT●Gross extended amount.
GROSS_UNIT_SELLING_PRICE●Gross unit selling price.
INTERFACE_LINE_ATTRIBUTE1●Interface line attribute1.
INTERFACE_LINE_ATTRIBUTE10●Interface line attribute10.
INTERFACE_LINE_ATTRIBUTE11●Interface line attribute11.
INTERFACE_LINE_ATTRIBUTE12●Interface line attribute12.
INTERFACE_LINE_ATTRIBUTE13●Interface line attribute13.
INTERFACE_LINE_ATTRIBUTE14●Interface line attribute14.
INTERFACE_LINE_ATTRIBUTE15●Interface line attribute15.
INTERFACE_LINE_ATTRIBUTE2●Interface line attribute2.
INTERFACE_LINE_ATTRIBUTE3●Interface line attribute3.
INTERFACE_LINE_ATTRIBUTE4●Interface line attribute4.
INTERFACE_LINE_ATTRIBUTE5●Interface line attribute5.
INTERFACE_LINE_ATTRIBUTE6●Interface line attribute6.
INTERFACE_LINE_ATTRIBUTE7●Interface line attribute7.
INTERFACE_LINE_ATTRIBUTE8●Interface line attribute8.
INTERFACE_LINE_ATTRIBUTE9●Interface line attribute9.
INTERFACE_LINE_CONTEXT●Interface line context.
LINE_INTENDED_USE●Line intended use.
LINE_NUMBER●Line number.
LINE_RECOVERABLE●Line recoverable.
LINE_TYPE●Type of line.
LINK_TO_CUST_TRX_LINE_ID●Identifier for the link to customer transaction line.
PRODUCT_CATEGORY●Product category.
PRODUCT_FISC_CLASSIFICATION●Product fisc classification.
PRODUCT_TYPE●Type of product.
QUANTITY_CREDITED●Quantity credited.
QUANTITY_INVOICED●Quantity invoiced.
QUANTITY_ORDERED●Quantity ordered.
REASON_CODE●Code identifying the reason.
REVENUE_AMOUNT●Revenue amount.
RULE_END_DATE●Rule end date.
RULE_START_DATE●Rule start date.
SALES_ORDER●Sales order.
SALES_ORDER_DATE●Sales order date.
SALES_ORDER_LINE●Sales order line.
SALES_ORDER_SOURCE●Sales order source.
TAX_CLASSIFICATION_CODE●Code identifying the tax classification.
TAX_EXEMPT_FLAG●Indicator (Y/N) for the tax exempt.
TAX_EXEMPT_NUMBER●Tax exempt number.
TAX_EXEMPT_REASON_CODE●Code identifying the tax exempt reason.
TAX_PRECEDENCE●Tax precedence.
TAX_RATE●Tax rate.
TAX_RECOVERABLE●Tax recoverable.
TRX_BUSINESS_CATEGORY●Transaction business category.
UNIT_SELLING_PRICE●Unit selling price.
UOM_CODE●Code identifying the unit of measure.
USER_DEFINED_FISC_CLASS●User defined fisc class.

4 reports read from this table

Change a column here and these are the reports that move with it, the blast radius for any change to RA_CUSTOMER_TRX_LINES_ALL.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.

Need the extract + dbt staging for RA_CUSTOMER_TRX_LINES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
Aging as of any date · Reporting without memory · The export ceiling