List of Dynamics NAV 2015 or + tables

(0) Share

Report

Posted on by PMS

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

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Check this link

msdn.microsoft.com/.../hh174014(v=nav.90).aspx

On the left hand side for each module it will list the tables, if you need excel sheet then from development environment select all the tables copy and paste to the excel.

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

go to microsoft dynamics nav development environment

you can take this all

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

As Suresh suggested you can get tablss list from given link

Or

You can install demo version of NAV and you can avail it

Was this reply helpful? Yes No
Maneesha 5,891 on at

Like (0)

Report

Refer also this link you can make it as you want

saurav-nav.blogspot.com/.../nav-2013-r2-later-table-information.html

Was this reply helpful? Yes No
PMS on at

Like (0)

Report

Hi, thanks for your answers, but I can access to SQL tables and I need to create a picture with the table relationships.

Does it exist any documentation that reports number and name of the NAV tables.

Thanks

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

use this app

mibuso.com/.../the-big-picture-of-nav-v2

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
PMS on at

Like (0)

Report

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

Was this reply helpful? Yes No
PMS on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

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

Was this reply helpful? Yes No