Database Schema - Navision 3.7

Gavin.Collins

I have just started using Jet Reports, but the user guide does not provide a comprehensive explaination of the relationships between the Tables in Navision 3.7.

Where can I find a table schema? Or am I asking the wrong question? :-s

Edward_Bloomfield

Hi Gavin,

There is no official table schema/ER diagram, however you might want to look at this download:
http://www.mibuso.com/dlinfo.asp?FileID=398

Hope this is of help!

Gavin.Collins

Many Thanks :!:

The schema is very useful, although I understand it is impossible to represent all the relationships between tables in a diagram without completely obscuring it.

I am shocked that such a schema is not show in any of the product documentation, or is available on the Navision website, although maybe Navsion's developers are probably concerned that by they might be giving revealing their database designs to their competitors.

Is there some sort of table (or spreadsheet) with a comprehensive list of the relationships between the tables?

Again, let me know if I am asking the wrong question.

Luc_VanDyck

You can have a look at the code in this download, which gets some data right out of the Navision database:
Visio Data Modeler v. 2.1

Edward_Bloomfield

Hello Gavin,

The Navision community has been asking for years for such a schema, hence the add-ons here, but as yet nothing official has been forthcoming.

Having worked with Navision since 1998, I have now got my head around the way Navision is structured, so that even when I look at an area I am unfamiliar with, I have a good idea how it will logically hang together, but when you start it can be a frustration... ](*,)