The structure of the Dynamics 2015 database and the relationships between the tables

(0) Share

Report

Posted on by Community Member

Hi Guys, I'm going to venture into the development of power BI and Dynamics 2015, and I wanted to know if any of you have a diagram with the structure of the Dynamics database and the relationships between the tables.
thanks for the support.

*This post is locked for comments

All responses (4)

Answers (3)

Verified answer

Tharanga Chandrasekara 23,116 on at

Like (1)

Report

RE: The structure of the Dynamics 2015 database and the relationships between the tables

There is no official diagram or documentation provided. However you can follow below URL to create a small module to check the table relationships: https://moxie4nav.wordpress.com/2016/10/12/dynamics-nav-show-table-relations/
Verified answer

Community Member on at

Like (0)

Report

RE: The structure of the Dynamics 2015 database and the relationships between the tables

Thanks You ;)
Suggested answer

Community Member on at

Like (2)

Report

RE: The structure of the Dynamics 2015 database and the relationships between the tables

Hi Nube,

If you can have access to a NAV 2016 database, you may run a virtual table named "Table Relations Metadata". It looks like this:

Of course, you can extend it with virtual tables "AllObjWithCaption" and "Field" in order to get more useful information (Table Name, Field Name, Field Class, Field Length...).

P.S: of course there is some differences between NAV 2015 and NAV 2016 tables structure; but this workaround remains useful.
Verified answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: The structure of the Dynamics 2015 database and the relationships between the tables

Here is a good post about that: forum.mibuso.com/.../all-table-relations-from-nav

There are also tools similar to http://www.navitools.com/

http://mibuso.com/downloads/navitools-er-diagram-v1.2-for-microsoft-navision

Also, this: https://moxie4nav.wordpress.com/2016/10/12/dynamics-nav-show-table-relations/

Otherwise, there are no official guides of full entity relations for NAV. If you would have specific questions, you are very welcome to ask them here.