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

I have the same question (0)

All responses (4)

Answers (3)

Verified answer

Alexander Ermakov 28,096 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Thanks You ;)

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (1)

Report

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/

Was this reply helpful? Yes No