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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed 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