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.
Problems that run through this table