Designing the table structure

NAV table objects are mapped to actual database tables; for each table in NAV, there is a corresponding table in the SQL Server database, and the NAV table designer is an interface for constructing table metadata that will be represented in database table fields.

The first table we will create is the contract header containing general information related to the contract: contract number, customer, and starting and ending dates.

Creating tables

To create a table, open the Object Designer and switch to the Table view; press the Table button in the left pane of the designer window. In the Table Designer, we create the new table by describing its fields line by line with the following metadata values...