AR Invoice Tables
RA_CUSTOMER_TRX_ALL is the transaction header (invoice, credit memo, debit memo); lines, GL distribution, and settlement live in related tables.
Key tables
RA_CUSTOMER_TRX_ALL
CuratedAR transaction header — invoice, credit memo, or debit memo issued to a customer.
Key columns
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
CuratedTransaction line detail — revenue, tax, freight, and rounding lines.
Key columns
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
CuratedGL distribution generated from transaction lines for accounting.
Key columns
Common joins
GL_CODE_COMBINATIONS via CODE_COMBINATION_ID
The GL account (segment combination) this distribution posted to.
AR_CASH_RECEIPTS_ALL
CuratedCustomer receipt header — amount received and receipt method.
Key columns
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
CuratedLinks a cash receipt to the transaction(s) it pays, closing the AR balance.
Key columns
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.
Key columns
| Table | Key columns |
|---|---|
| RA_CUSTOMER_TRX_ALL | CUSTOMER_TRX_IDTRX_NUMBERBILL_TO_CUSTOMER_IDTRX_DATE |
| RA_CUSTOMER_TRX_LINES_ALL | CUSTOMER_TRX_IDCUSTOMER_TRX_LINE_IDLINE_TYPE |
| RA_CUST_TRX_LINE_GL_DIST_ALL | CUSTOMER_TRX_LINE_IDCODE_COMBINATION_IDAMOUNT |
| AR_CASH_RECEIPTS_ALL | CASH_RECEIPT_IDRECEIPT_NUMBERCUSTOMER_IDAMOUNT |
| AR_RECEIVABLE_APPLICATIONS_ALL | RECEIVABLE_APPLICATION_IDCASH_RECEIPT_IDAPPLIED_CUSTOMER_TRX_IDAMOUNT_APPLIED |
Relationships
- RA_CUSTOMER_TRX_ALLAR transaction headerCUSTOMER_TRX_ID
- RA_CUSTOMER_TRX_LINES_ALLTransaction line detailCUSTOMER_TRX_LINE_ID
- RA_CUST_TRX_LINE_GL_DIST_ALLGL distribution generated from transaction lines for accounting.
- AR_CASH_RECEIPTS_ALLCustomer receipt headerCASH_RECEIPT_ID
- AR_RECEIVABLE_APPLICATIONS_ALLLinks a cash receipt to the transaction(s) it pays, closing the AR balance.
Technical flow
Related questions
Model-generated, grounded against the curated knowledge layer. Check specifics against your instance.