Database SDK

This page provides a detailed documentation of both the system and company databases in GP. This SDK has been built for  Dynamics GP 2010 R2 11.00.1914.

I will try my best to keep this SDK updated for major releases of GP which has table structural changes.

Note: For the purpose of this documentation, I have installed GP with all the modules installed and SQL objects created for completeness. The code available for each objects is just provided for informational purposes. It is NOT recommended to change them in your environments and is could potentially bring down your GP environment, and you will not be able to get support from Microsoft to fix issues caused by such changes.

Update 03/30/2012 – Now with the SDK for company database completed, 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
1 Segment 1 7 0
2 Segment 2 7 1
3 Segment 3 7 2
4 Segment 4 7 3
5 Segment 5 7 4
6 Segment 6 7 5
7 Segment 7 7 6
8 Segment 8 7 7
9 Segment 9 7 8
10 Segment 10 7 9

SYSTEM DATABASE

Database Info
Tables
Views
Stored Procedures
Functions
Database Triggers
Database Roles
Database Users
Defaults

COMPANY DATABASE

Database Info
Tables
Views
Stored Procedures
Functions
Database Triggers
Database Roles
Database Users
Defaults

Hope this database information is useful to the community. Please feel free to drop in your feedback/comments/suggestions on the same so that I can try to enhance this more to suit the community.

VN:F [1.9.22_1171]
Rating: 9.8/10 (5 votes cast)
VN:F [1.9.22_1171]
Rating: +2 (from 2 votes)
Database SDK, 9.8 out of 10 based on 5 ratings