Dynamics GP 2010 Database SDK – Company Database Details Uploaded
As a follow up to my post titled āDynamics GP 2010 SDKā, I have updated the SDK section with the details of the company database as well, as I had mentioned in the earlier post.
You should now see a section in the SDK page as shown below for the company database, from where you can access the company database SQL objects and their details.
I have built this SDK from the sample company (Fabricam, Inc. aka. TWO database). Please keep in mind that the GP installation from where I prepared this SDK was based on an account framework which had 10 segments with 7 characters for each segment. Hence you would note that there would be 10 segments for account numbers in all the tables where account numbers are present. The number of segments for the account number field in the table will vary based on the account framework which you have used when installing Dynamics GP. So please keep this in mind when you try to copy a script from here into your environment as the account framework might differ between installations. The account framework which I have used is as given below.
Account Framework Setup
Total Framework Length: 66
Total Number of Segments: 10
|Segment ID||Segment Name||Max Length||Sort Position|
So now this SDK is complete for both the system database and the company database.
Hope the community finds this helpfulā¦
Until next post!
March 30, 2012
Ā· veeyeskay Ā· No Comments
Tags: company database, database info, database sdk, dynamics, gp2010, sdk, stored procedures, system database, tables, triggers, views Ā· Posted in: Documentation, Dynamics, Great Plains, SQL Server Total Views: 3,137