RA_CUSTOMER_TRX_LINES_ALL Table OverView

RA_CUSTOMER_TRX_LINES_ALL
customer_trx_line_id	customer_trx_id	link_to_cust_trx_line_id	line_type	extended_amount

The RA_CUSTOMER_TRX_LINES_ALL table stores invoice, debit memo, commitment and credit memo line level information. Each transaction line is stored as a unique record, based on the primary key, customer_trx_line_id column. The customer_trx_id column is a foreign key to the RA_CUSTOMER_TRX_ALL table.

The line_type column identifies the type of data contained in the record. Valid line types are CHARGES, FREIGHT, LINE and TAX. Any record with a line type of TAX or FREIGHT refers to the original invoice line via the link_to_cust_trx_line_id column, except for header freight transactions. The total amount for each transaction line is stored in the column extended_amount.