Table and Field Structure

dabel

Is there a document that exists that lists all of the tables and fields such that one would be able to reference this in order to create reports?

Luc_VanDyck

No there isn't, but there are some tools that can help you:

tBrowser v1.2
Visio Data Modeler v. 2.1
NaviTools ER Diagram v1.2 for Microsoft Navision

Shenpen

Navision Developer's Toolkit has something like that.

However, by understanding naming conventions you can pretty guess that for yourself:

Useful transaction information is in tables that are called Entry - simply filter for *Entry* and you will see. Document tables usually called Header and Line.
For most master data, primary key is No. For most settings-like data (categories etc.) primary key is Code. Foreign keys in Entry tables tend to be called master data name + No. : so wherever you see a Vendor No. you can be sure there is a Vendor table with primary key No. and where you see an Item Category Code field then there is an Item Category table with primary key Code.

Documents sometimes have a primary key No. in other times, a composite primary key such as Document Type, No. Primary key of Lines tables also contain Document Type etc. such fields of the header, also have Document No. which always relates to the No. of the header, and have a Line No. also in the primary key.

If in doubt, find the data in the user interface, Ctrl+F2, Shift+F4 and look at the SourceTable property.