Shipping Method Table in GP
Monday, January 18th, 2010If 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