Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GP discounts, freights data in SOP tables

Status
Not open for further replies.

rkiss

Programmer
Jun 2, 2006
9
Hi,

Could someone please direct to the table names and column names where discounts, freights and other SOP header information is stored.

Thank you very much

Roman
 
SOP10100 for non posted documents and sop30200 for posted documents.

If you go into Tools - Resources description - tables you will find that kind of informations.
 
Hi Adionne,

Would you happen to know the field names for the following items in the database

- Discounts
- Freight
- Miscellaneous charges

Thank you,

Roman
 
discounts - there are many but try DISAVTKN or ORDATKN (originating currency)
freight - FRTAMNT or ORFRTAMT (originating currency)
misc - MISCAMNT or ORMISCAMT (originating currency


-----------
and they wonder why they call it Great Pains!

jaz
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top