Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

MS Dynamics GP V18R2 database schema

(0) ShareShare
ReportReport
Posted on by 15

I was wondering if anyone knows where to get the full database schema and field information for MS Dynamics GP Version 18R2

Thank you,

Categories:
  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: MS Dynamics GP V18R2 database schema

    Hi Quartz,

    As @Derek mentioned, your best bet to get a diagram of the table relationships for the various modules is to install the Dynamics GP SDK (can be found on the DVD image), but that hasn't been updated since GP 2013 or 2015.. Still very pertinent since not much of the structure has changed in the last years and versions of GP. The references about table changes should fill the gap.

  • Verified answer
    RE: MS Dynamics GP V18R2 database schema

    Are you looking for more table changes from version to version or a type of schematic that shows how each window works with each other in the application?

    The schematic, we do not have that I'm aware, that shows how each window flows from each window and each process, but if you're looking for table changes and related information that we used to put in SDKs, we now put that information in blogs such as the following:

    After GP 2013 or 2015, we’re no longer putting out an actual SDK for newer versions of Dynamics GP.

    Instead, we’re putting this information into blogs that state the table changes, new tables and column name changes, such as these:

    >>Table, Column, and Parameter Changes in Microsoft Dynamics GP October 2020 Release & 2020 Year-End (18.3)
    https://community.dynamics.com/gp/b/dynamicsgp/posts/table-column-and-parameter-changes-in-microsoft-dynamics-gp-october-2020-release-2020-year-end

    >>Table, Column, and Parameter Changes in Microsoft Dynamics GP October 2019 Release & 2019 Year-End (18.2)
    https://community.dynamics.com/gp/b/dynamicsgp/posts/table-column-and-parameter-changes-in-microsoft-dynamics-gp-october-2019-release-2019-year-end

    >>Table, Column, and Parameter Changes in Microsoft Dynamics GP 2018 R2 and Year-End Update
    https://community.dynamics.com/gp/b/dynamicsgp/posts/table-column-and-parameter-changes-in-microsoft-dynamics-gp-2018-r2-and-year-end-update

    >>Table, Column, and Parameter Changes in Microsoft Dynamics GP 2018 and Year-End Update
    https://community.dynamics.com/gp/b/dynamicsgp/posts/table-column-and-parameter-changes-in-microsoft-dynamics-gp-2018-and-year-end-update

    >>Table and Column Changes in Microsoft Dynamics GP 2016
    https://community.dynamics.com/gp/b/dynamicsgp/posts/table-and-column-changes-in-microsoft-dynamics-gp-2016

    >>Table and Column Changes in Dynamics GP 2015
    https://community.dynamics.com/gp/b/dynamicsgp/posts/table-and-column-changes-in-dynamics-gp-2015



    >>Table and Column Changes in Dynamics GP 2013 R2
    https://community.dynamics.com/gp/b/dynamicsgp/posts/table-and-column-changes-in-dynamics-gp-2013-r2

    Thanks

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans