GP discounts, freights data in SOP tables

[rkiss]

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

 

[Adionne]

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.

 

[rkiss]

Hi Adionne,

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

- Discounts
- Freight
- Miscellaneous charges

Thank you,

Roman

 

[jazgeek]

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