Page 1 of 1

fields in table ra_interface_lines_all

Posted: Wed May 30, 2007 7:49 am
by prema
hi all

can anybody tell me wich fields represent the
sales order number
line item

in the table ra_interface_lines_all?

thanks
prema

Posted: Thu May 31, 2007 10:54 pm
by ramkic
Hi,
There is a column called "SALES_ORDER" in ra_interface_lines_all table which is the "Sales Order Number" for the transaction.
The Validation goes like this:
****
If LINE_TYPE = ?LINE?, ?CHARGES?, or you are passing header freight, this column is
optional.
If LINE_TYPE = ?TAX? or you are passing freight for a specific line, do not enter a value
in this column.
For credit memos do not enter a value in this column. AutoInvoice uses the sales order
number from the transaction you are crediting.
*****
This column will be imported to ra_customer_trx_lines_all.sales_order column.

Thanks
Best Regards
ramkic