What tables contain AR invoices?
AR Invoice Tables
Oracle Fusion · Financials · AR
RA_CUSTOMER_TRX_ALL is the transaction header (invoice, credit memo, debit memo); lines, GL distribution, and settlement live in related tables.
Grounded in: Curated Oracle knowledge layer — AR
Key Tables
RA_CUSTOMER_TRX_ALL
AR transaction header — invoice, credit memo, or debit memo issued to a customer.
Common Joins
RA_CUSTOMER_TRX_LINES_ALL via CUSTOMER_TRX_ID
The revenue, tax and freight line detail that makes up this transaction — one row per line, tied to the header by CUSTOMER_TRX_ID.
AR_RECEIVABLE_APPLICATIONS_ALL via CUSTOMER_TRX_ID = APPLIED_CUSTOMER_TRX_ID
How a customer's cash receipt was applied against this transaction — links the payment side back to the invoice.
RA_CUSTOMER_TRX_LINES_ALL
Transaction line detail — revenue, tax, freight, and rounding lines.
Common Joins
RA_CUSTOMER_TRX_ALL via CUSTOMER_TRX_ID
The transaction header this line belongs to — customer, transaction number, and date.
RA_CUST_TRX_LINE_GL_DIST_ALL via CUSTOMER_TRX_LINE_ID
The GL accounting distribution generated from this line once Create Accounting runs.
RA_CUST_TRX_LINE_GL_DIST_ALL
GL distribution generated from transaction lines for accounting.
Common Joins
GL_CODE_COMBINATIONS via CODE_COMBINATION_ID
The GL account (segment combination) this distribution posted to.
AR_CASH_RECEIPTS_ALL
Customer receipt header — amount received and receipt method.
Common Joins
AR_RECEIVABLE_APPLICATIONS_ALL via CASH_RECEIPT_ID
How this receipt was applied — to which transaction(s) and for how much.
AR_RECEIVABLE_APPLICATIONS_ALL
Links a cash receipt to the transaction(s) it pays, closing the AR balance.
Common Joins
AR_CASH_RECEIPTS_ALL via CASH_RECEIPT_ID
The customer receipt this application was made from.
RA_CUSTOMER_TRX_ALL via APPLIED_CUSTOMER_TRX_ID = CUSTOMER_TRX_ID
The AR transaction (invoice/credit memo) this receipt was applied against.
Technical Flow
Relationships
RA_CUSTOMER_TRX_ALL
└── RA_CUSTOMER_TRX_LINES_ALL
└── RA_CUST_TRX_LINE_GL_DIST_ALL
AR_CASH_RECEIPTS_ALL
└── AR_RECEIVABLE_APPLICATIONS_ALLRelated Questions
Have a follow-up, or a different question?
Continue in Ask Oracle AI