fields in table ra_interface_lines_all

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
prema
Posts: 15
Joined: Tue May 22, 2007 9:22 am
Location: Mauritius

fields in table ra_interface_lines_all

Post 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
ramkic
Posts: 34
Joined: Fri Sep 15, 2006 3:41 pm
Location: USA

Post 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
Post Reply

Who is online

Users browsing this forum: Google Adsense [Bot], Majestic-12 [Bot] and 20 guests