AR Transaction to SLA Link

AR Transaction to SLA Link R12

Important columns in the RA_CUST_TRX_LINE_GL_DIST table include:

CUST_TRX_LINE_GL_DIST_ID column

CODE_COMBINATION_ID column

CUSTOMER_TRX_LINE_ID column

ACCOUNT_CLASS column

AMOUNT column

The RA_CUST_TRX_LINE_GL_DIST table stores the accounting distribution for invoice, debit memo, and credit memo transactions. Each distribution is stored as a unique record, based on the primary key cust_trx_line_gl_dist_id. The customer_trx_line_id column is a foreign key to the RA_CUSTOMER_TRX_LINES table.

The account_class column describes the account type, while the code_combination_id column identifies the general ledger account. Valid account classes are CHARGES, FREIGHT, REC, REV, SUSPENSE, TAX, UNBILL, and UNEARN. The account_class REC represents the receivable account distribution. The amount column for REC records is equal to the sum of all invoice lines. Therefore, there is no link to the RA_CUSTOMER_TRX_LINES table and the column customer_trx_line_id is null for these records. The REC record is linked to the RA_CUSTOMER_TRX table from the customer_trx_id column. For all other account classes, credits are represented by positive numbers and debits are represented by negative numbers.