RA_CUSTOMER_TRX_LINES_ALL

     RA_CUSTOMER_TRX_LINES_ALL stores information about invoice,debit memo,credit memo,and commitment lines.For example,an invoice can have one line for Product A another line for Product B.You need one row for each line.

     Invoice,debit memo,credit memo,and commitment lines are distinguished by the transaction type of the corresponding

     RA_CUSTOMER_TEX_ALL record. Also,credit memo are required to have a value in PREVIOUS_CUSTOMER_TRX_LINE_ID,except on account credits which are not related to specific invoices/invoice lines at creation time, will not have values in this column.

     QUANTITY_ORDERED stores the amount of product ordered.

     QUANTITY_INVOICED stores the amount of Product invoiced. For invoices enter through the window, QUANTITY_ORDERED and QUANTITY_INVOICED must be the same. For invoices imported through AutoInvoice,QUANTITY_ORDERED and QUANTITY_INVOICED can be different.

      If you enter a credit memo,QUANTITY_CREDITED stores the amount of product credited.

      UOM_CODE stores the unit of measure code as defined in MTL_UNITS_OF_MEASURE.

      UNIT_STARDARD_PRICE stores the list price per unit for this transaction line.UNIT_SELLING_PRICE stores the selling price per unit for this transaction line.For transaction imported through AutoInvoice,UNIT_STARDARD_PRICE and UNIT_SELLING_PRICE can be different.

      DESCRIPTION,TAXING_RULE,QUANTITY_ORDERED,UNIT_STANDARD_PRICE,UOM_CODE,and UNIT_SELLING_PRICE are required event though they are null allowed.

     

      LINE_TYPE differentiates between the different types of line that are stored in this table.LINE points to regular invoice lines that normally refer to an item.TAX singifies that this is a tax line. The column LINK_TO_CUST_TRX_LINE_ID references another row in this table that is the invoice line associated with the row of type TAX.FREIGHT works the same way as TAX  but there you can have at most one FREIGHT type line per invoice line of type LINE. You can also have one line of type FREIGHT that has a null LINK_TO_CUST_TRX_LINE_ID(and this referred to as header level freight). CHARGES works just like the LINE type. A line_type of 'CB' is created for a Chargeback line.

 

     The primary key for this tbale is CUSTOMER_TRX_LINE_ID.

 

     For every row in this table that belongs to a complete transaction (where RA_CUSTOMER_TRX.COMLETE_FLAG='Y'),there must be at least one row in the table RA_CUST_TRX_LINE_GL_DIST (which stores accounting information),even for non-postable transactions.