Oracle Fusion · Data dictionary
RA_CUSTOMER_TRX_ALL
ReceivablesUsed in 16 subject areas58 reporting columns
Receivables (RA) — customer transaction headers. One row per invoice, credit memo, debit memo, or chargeback.
Primary key: CUSTOMER_TRX_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BILLING_DATE | ● | Billing date. | |
| BR_AMOUNT | ● | Br amount. | |
| BR_ON_HOLD_FLAG | ● | Indicator (Y/N) for the br on hold. | |
| COMMENTS | ● | Comments. | |
| COMPLETE_FLAG | ● | Indicator (Y/N) for the complete. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CREDIT_METHOD_FOR_INSTALLMENTS | ● | Credit method for installments. | |
| CREDIT_METHOD_FOR_RULES | ● | Credit method for rules. | |
| CT_REFERENCE | ● | Ct reference. | |
| CUSTOMER_REFERENCE | ● | Customer reference. | |
| CUSTOMER_REFERENCE_DATE | ● | Customer reference date. | |
| CUSTOMER_TRX_ID | PK | ○ | Identifier for the customer transaction. |
| DEFAULT_TAX_EXEMPT_FLAG | ● | Indicator (Y/N) for the default tax exempt. | |
| DOC_SEQUENCE_VALUE | ● | Doc sequence value. | |
| EXCHANGE_DATE | ● | Exchange date. | |
| EXCHANGE_RATE | ● | Exchange rate. | |
| EXCHANGE_RATE_TYPE | ● | Type of exchange rate. | |
| FINANCE_CHARGES | ● | Finance charges. | |
| FOB_POINT | ● | Fob point. | |
| INTERCOMPANY_FLAG | ● | Indicator (Y/N) for the intercompany. | |
| INTERFACE_HEADER_ATTRIBUTE1 | ● | Interface header attribute1. | |
| INTERFACE_HEADER_ATTRIBUTE10 | ● | Interface header attribute10. | |
| INTERFACE_HEADER_ATTRIBUTE11 | ● | Interface header attribute11. | |
| INTERFACE_HEADER_ATTRIBUTE12 | ● | Interface header attribute12. | |
| INTERFACE_HEADER_ATTRIBUTE13 | ● | Interface header attribute13. | |
| INTERFACE_HEADER_ATTRIBUTE14 | ● | Interface header attribute14. | |
| INTERFACE_HEADER_ATTRIBUTE15 | ● | Interface header attribute15. | |
| INTERFACE_HEADER_ATTRIBUTE2 | ● | Interface header attribute2. | |
| INTERFACE_HEADER_ATTRIBUTE3 | ● | Interface header attribute3. | |
| INTERFACE_HEADER_ATTRIBUTE4 | ● | Interface header attribute4. | |
| INTERFACE_HEADER_ATTRIBUTE5 | ● | Interface header attribute5. | |
| INTERFACE_HEADER_ATTRIBUTE6 | ● | Interface header attribute6. | |
| INTERFACE_HEADER_ATTRIBUTE7 | ● | Interface header attribute7. | |
| INTERFACE_HEADER_ATTRIBUTE8 | ● | Interface header attribute8. | |
| INTERFACE_HEADER_ATTRIBUTE9 | ● | Interface header attribute9. | |
| INTERFACE_HEADER_CONTEXT | ● | Interface header context. | |
| INTERNAL_NOTES | ● | Internal notes. | |
| INVOICE_CURRENCY_CODE | ● | Currency code for the invoice. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LATE_CHARGES_ASSESSED | ● | Late charges assessed. | |
| PRINTING_COUNT | ● | Printing count. | |
| PRINTING_LAST_PRINTED | ● | Printing last printed. | |
| PRINTING_ORIGINAL_DATE | ● | Printing original date. | |
| PRINTING_PENDING | ● | Printing pending. | |
| PURCHASE_ORDER | ● | Purchase order. | |
| PURCHASE_ORDER_DATE | ● | Purchase order date. | |
| PURCHASE_ORDER_REVISION | ● | Purchase order revision. | |
| REASON_CODE | ● | Code identifying the reason. | |
| REQUIRES_MANUAL_SCHEDULING | ● | Requires manual scheduling. | |
| SHIP_DATE_ACTUAL | ● | Shipment date actual. | |
| SHIP_VIA | ● | Shipment via. | |
| SPECIAL_INSTRUCTIONS | ● | Special instructions. | |
| TERM_DUE_DATE | ● | Term due date. | |
| TRX_BUSINESS_CATEGORY | ● | Transaction business category. | |
| TRX_CLASS | ● | Transaction class. | |
| TRX_DATE | ● | Transaction date. | |
| TRX_NUMBER | ● | Transaction number. | |
| USER_DEFINED_FISC_CLASS | ● | User defined fisc class. | |
| WAYBILL_NUMBER | ● | Waybill number. |
48 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_ALL.
- Greece Daily Journal Book - Line Descriptions Report
- Libro Partitario Report
- Spain SII Report
- Intercompany Invoiced Reconciliation Report
- AR Aging Detail Report
- AR Transaction Register Summary and Detail Report
- Cash Settlement Report
- Customer Statement of Open Balance Report
- Golden Tax Reconciliation Report
- Greece Customer Balance by Account Report
- Greece Notes Receivable - Post Dated Checks and Drafts Report
- Invoice Settlement Report
- Receipt History Report
- Transaction Resolution Report
- Audit Report for France
- UK Audit File (SAF-T)
- Receivables to General Ledger Reconciliation Report
- Receivables Aging Report
- Netting Settlement Report
- Netting Settlement Listing
- Netting Settlement Letter
- Netting Reversal Letter
- Bad Debt Provision Report
- Invoices Posted to Suspense Report
- Potential Reconciling Items Report
- Billing History Report
- Import AutoInvoice Execution Report
- Print Adjustments Report
- Transaction Details Report
- Receivables Aging by General Ledger Account 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.
- Budgetary Control - Transactions Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Payables Invoices - Holds Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Procurement - Spend Real Time
- Receivables - Adjustments Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Credit Memo Requests Real Time
- Receivables - Receipts Details Real Time
- Receivables - Revenue Adjustments Real Time
- Receivables - Standard Receipts Application Details Real Time
- Receivables - Transactions Real Time
- Subledger Accounting - Journals Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for RA_CUSTOMER_TRX_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.