This option will create a roadmap from your Dynamics NAV database to provide information about tables, fields, indexes, datatypes and possible joins. When the Excel format box is checked, the information will be displayed in an Excel document instead of a web page.
When you click the “OK” button, all information is shown about the chosen connection.
Click on a tablename to see the details about that table.
| Column | Description |
|---|---|
| Column 1 | Row 1 holds the tablename. The other rows are the fieldnames in that table. |
| Column 2 | The field numbers. These can be used to find a table when creating a dynamic download or function. |
| Type | The field’s datatype. |
| Size | Maximum field length. |
| Class | This defines if a field must contain a value or can be left blank. |
| Index | The indexes as defined for this table. |
| SumFields | The SUM fields as defined for this table. |