SQL Stored Guidelines. Obviously you have unlimited control and possibilities with SQL queries. You should consider Great Plains tables structure and data flow. Launch Great Plains and check out Tools->Resource Description->Tables. Find the table on the inside proper series. If you are looking for the customers - it should be RM00101 - customer master file. Should you require historical Sales Order Processing documents - they can be found in SOP30200 - Sales History Header file, etc. Do not change existing tables - do not create new fields, for When you loved this informative article and you want to receive more details with regards to Noise Pollution Consultants kindly visit our page. instance. Also you need to notice that each GP table has DEX_ROW_ID - identity line. Sometimes it is good idea to use inbound/outbound XML in the parameters - then you'll be able to deploy web service for a middle party between two systems.