web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Schema Diagram for Ver...
Microsoft Dynamics GP (Archived)

Schema Diagram for Version 9.00?

(0) ShareShare
ReportReport
Posted on by richlocus 320

Hello:  I'm trying to find a diagram that shows the relationship of tables in the 9.00 version of Great Plains.  With over 900 tables, it would certainly help to know how foreign keys relate to their parent.  Is there any such documentation?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    steveendow Profile Picture
    steveendow 2,281 on at

    Hi,

    The answer to your question is technically Yes.  But the practical answer is No.

    The Dynamics GP SDK has provided table diagrams for each of the GP modules since way back (although I haven't bothered to check if they are still maintaining them with GP 2010 and 2013).  

    They are Visio files with nice pretty colorful tables, listing all of the fields, and with lines connecting the tables for the relationships.  But there are so many tables and fields that they are very difficult to actually use--they are massive.  Once you see one, your eyes will likely glaze over.

    I have posted the GP 9 table diagram Visio files on my web site in case you are interested in looking at them.  

    http://www.precipioservices.com/gp/schemas/

    But, instead of looking at a visual diagram, I would strongly recommend using the Table Descriptions under Tools -> Resource Descriptions -> Tables.

    Open the Table Names window, choose your Series, then View By Table Physical Name.

    Then check out Leslie Vail's excellent article on the GP table naming convention.

    http://dynamicsconfessions.blogspot.com/2010/07/dynamics-gp-table-names.html

    Once you understand how the tables are named, the names will no longer be random numbers, and you will typically be able to find data much faster and quickly understand the relationships.

    Finally, Victoria Yudin has a blog post dedicated to GP table resources.

    http://victoriayudin.com/gp-tables/

    With those references and a few minutes of reading, you will have far more knowledge than a massive Visio diagram will be able to impart.

    But let me know what you think and whether the diagrams are helpful.

  • richlocus Profile Picture
    richlocus 320 on at

    Steve.. Thanks!!  I'm not sure how many foreign keys they use, but hopefully with the information you provided and can patch it together for the data sets that I need.  Kindest regards, Rich Locus

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans