Hi,
likely this request is recurrent, but for reporting goal I need to have a list (on Excel?) that reports all the tables (and the related number) for Dynamics NAV 2015 or +.
Does it exist any documentations about the NAV data model?
Many thanks
*This post is locked for comments
You may want to take a look at this: dynamicsdocs.com/.../w1
HI PMS,
for various reasons (business,performance,security etc) Microsoft NAV doesn't create relationships between tables in SQL level,for that reason you cannot see any relationships when you create a diagram and bring Sales Header - Sales Line tables. All these relationships are kept and maintained though NAV dlls,and the only way to see them is through NAV development environment
Kind regards
Hi,
Would you please share the Master Tables List.
Have you know the relationship among tables concept?
If it should exists a relationship between table1 and table2 (f.e. table2 has a foreign key refers to the primary key of the table1) when I select table1 and table2 in a SQL Server diagram I could see two boxes linked between them.
Below I report a sample diagram where I select Sales Header and Sales Line tables:
I don't see any relationships between Sales Header and Sales Line as I expected.
Thanks
i dont think there are axcact relationship diagrams are available for your requirement
Refer this
community.dynamics.com/.../msd-nav-table-field-relationship-part-i
I repeat my request.
I'm not a NAV developer and so I don't want to install the NAV software.
I need to read data from several NAV tables and so I need to have the number of each NAV tables and create the entity-relationship diagrams respect to the tables exposed in SQL Server environment.
In order to simplify this task, does it exist any documentations to help me?
Moreover, I've tried to create a diagram using SSMS putting MASTER$Dimension table, MASTER$Dimension Value table and MASTER$Dimension Set Entry table, but I don't see any relations among these tree tables. So, in NAV do the related tables have a relationship among them?
I hope that my request is more simple and clear.
Thanks
As I said, I need to obtain a list of all Nav tables and the corresponding number.
I'm not a Nav developer and, preferable without installing NAV.
As a last thing, if possible, does it exist any documentation that shows the Nav table relationships without I must do any works to obtain it?
Thanks
Quick question what are you trying to accomplish ? What is your requirement ? All the tables you see in the Navision database are NAV tables and you can use in built database diagram in SQL Server Managment Studio to create diagrams.
Share
Report
All responses (
Answers (
5
