OracleOps AI
← All tables
Oracle Fusion/Financials/AR

RA_CUSTOMER_TRX_ALL

AR transaction header — invoice, credit memo, or debit memo issued to a customer.

Key Columns

CUSTOMER_TRX_IDTRX_NUMBERBILL_TO_CUSTOMER_IDTRX_DATE

Child Tables

RA_CUSTOMER_TRX_LINES_ALL

Transaction line detail — revenue, tax, freight, and rounding lines.

Common Joins

RA_CUSTOMER_TRX_LINES_ALLvia 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_ALLvia 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.

Used In

AROrder-to-CashSubledger Accounting

Related

Creating an AR invoice

Manual AR invoices are created from Receivables > Billing > Create Transaction, generating a header in RA_CUSTOMER_TRX_ALL with lines in RA_CUSTOMER_TRX_LINES_ALL.

Ask Oracle AI about RA_CUSTOMER_TRX_ALL