Shipping Method Table in GP

If you are trying to get a list of all the shipping methods in GP they are stored in the [SY03000] table.

SELECT [SHIPMTHD]
,[SHMTHDSC]
,[PHONNAME]
,[CONTACT]
,[CARRACCT]
,[CARRIER]
,[SHIPTYPE]
,[NOTEINDX]
,[LSTUSRED]
,[CREATDDT]
,[MODIFDT]
,[DEX_ROW_ID]
FROM [PRICE].[dbo].[SY03000]

Found a blog with list of tables for GP
http://vstoolsforum.com/blogs/dynamicsgp/archive/2009/03/19/dynamics-gp-10-company-tables.aspx

Tags: ,

Leave a Reply

CAPTCHA Image CAPTCHA Audio
Refresh Image

© 2009-2010 iCRM Blog All Rights Reserved -- Copyright notice by Blog Copyright