Creating a table

Tables are the building blocks for all other NAV objects. They store the data that the business needs to access. This recipe will show you how to create a basic table and save it in the system.

How to do it...

1. Create a new table object from Object Designer.

2. Add the following fields in the Table Designer window:

   Field No.	Field Name	Data Type	Length
   1	Entry No.	Integer
   2	Document No.	Code	20
   3	Description	Text	30
   4	Value	Decimal
   5	Posting Date	Date

3. It should look like the following window:

   

4. Save and close the Table.

How it works...

Each field is just like a variable. These variables, however, are grouped together to form a new type of variable called a Record. The field definitions provide the structure for all of the tables, as well as the data in them, inside the system. The data type of your fields can be almost anything. In this example, we have created five fields of the most common types.

There's more...

If you do not specify a key manually, the...