This is an updated version of an article I wrote a while back for the Microsoft Dynamics GP community website. The links to the original article, as well as the associated Knowledge Base (KB) article are provided at the bottom of this post.
The idea was to provide as many tools and techniques as possible to help people work with the Microsoft Dynamics GP data model. Please read all the methods before selecting the ones that work best for you. To avoid confusion I have left the ten original methods in the same order and added some new techniques at the end of the list. I have also added links to additional resources and articles.
Techniques for Finding Table and Field Information in Microsoft Dynamics GP
To get information about tables and fields in Microsoft Dynamics GP, you can use any of the following methods:
Load the SDK (Software Developer's Kit). The kit contains transaction flow documents that show which tables to use for specific transactions. It also contains PDF E-R (Entity-Relationship) diagrams that show the tables and their relationships.Links for the SDK can be found on the Developer Articles & Links page.
Select Tools >> Resources >> Tables, and use the Table Resource window to look up tables.
Use a tool such as SnapShot for Microsoft Dynamics GP. This tool can display and export information about tables. However, its main function is to provide platform and account framework independent data transfer, backup, and migration.
* = New methods for this posting.
Originally published at Finding Table and Field Information in Microsoft Dynamics GP and also as the following KB article:
How to obtain the table and field information for windows in Microsoft Dynamics GP (KB 894335)
Victoria Yudin has provided table information for each of the series in the product. Look at http://victoriayudin.com/gp-reports/
Mark Polino has Table Reference spreadsheet on his blog. Look at http://msdynamicsgp.blogspot.com/, look at GP Downloads section on the right hand side.
Steve Gray on VSToolsForum.com has provided a number of articles on this blog. Look at http://vstoolsforum.com/, look at the Resources section for Dynamics GP Table Structures.
File Lists for all files in all products for v9.0 & v10.0 are attached at the bottom of the article.
Please post a comment and let me know if this article is useful to you.
Amazing collection of information!
Posting from the Dynamics GP Blogster
Posting from Vaidy Mohan's blog
Posting from DynamicAccounting.net
Exceptional post-thanks so much!
New Rule: If you tell me that you can't find table resources for Dynamics GP I will hit you. Well
Posting on Rose Business Systems Blog
So, you're saying no translation from meaningful names to XXNNNNN is anywhere else in the database? Then where does it come from?
The tables are defined using Dexterity and are stored in the application dictionaries, such as Dynamics.dic. The table definitions include the Technical Name (the name used be developers), the Display Name (the name shown to users) and the Physical Name (the name used at the database level).
The information shown in the Table Resources window or the Support Debugging Tools, Resource Information and Resource Explorer windows are all read directly from the Dynamics.dic using Dexterity commands.
It is not stored in any SQL tables.
Thanks for the great post! I've been trying to find table info for GP Manufacturing without much luck. If you have any resources on that that you could point me towards,I'd be very greatful!
There's a pretty good table reference here:
Where is the information
What information specifically are you looking for?
This article does not contain the information, but gives multiple methods for you to find the information.
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.