Oracle Fusion/Financials/AR

RA_CUSTOMER_TRX_LINES_ALL

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

Key Columns

CUSTOMER_TRX_IDCUSTOMER_TRX_LINE_IDLINE_TYPE

Parent Table

RA_CUSTOMER_TRX_ALL

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

Child Tables

RA_CUST_TRX_LINE_GL_DIST_ALL

GL distribution generated from transaction lines for accounting.

Common Joins

RA_CUSTOMER_TRX_ALLvia CUSTOMER_TRX_ID

The transaction header this line belongs to — customer, transaction number, and date.

RA_CUST_TRX_LINE_GL_DIST_ALLvia CUSTOMER_TRX_LINE_ID

The GL accounting distribution generated from this line once Create Accounting runs.

Used In

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.