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
| Column | Key | In reports | Description (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_ID | PK | ○ | 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.
- AR Transaction Register Summary and Detail Report
- Transaction Resolution Report
- Invoices Posted to Suspense Report
- Transaction Details Report
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.
- Costing - New COGS and Gross Margin Details Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Receipts Details Real Time
- Receivables - Revenue Adjustments Real Time
- Receivables - Transactions Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for RA_CUSTOMER_TRX_LINES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.