RA_CUST_TRX_LINE_GL_DIST_ALL table Overview

RA_CUST_TRX_LINE_GL_DIST_ALL
cust_trx_line_gl_dist_id	code_combination_id	customer_trx_line_id	account_class	amount
CUST_TRX_LINE_SALESREP_ID

RA_CUST_TRX_LINE_GL_DIST_ALL stores the accounting distribution for invoice, debit memo, commitment, 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_ALL 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 RA_CUSTOMER_TRX_LINES_ALL and the column customer_trx_line_id is null for these records. The REC record is linked to the table, RA_CUSTOMER_TRX_ALL, via the customer_trx_id column. For all other account classes, credits are represented by positive numbers and debits are represented by negative numbers.