How tables are structured

Tables are the most fundamental objects among any databases. They store records that are collected through pages; for example, customers, sales, and inventories. These records are then presented to the users through pages and reports.

The table's structure is the base of the structure of the whole application. We have already covered the table structure in Chapter 3, Dynamics NAV – General Considerations, but we will go a bit deeper in this section. In the standard application, we find different kinds of tables that are used for different purposes:

• Master tables: We will find master tables in each area of the application; they are the ones that are used to store the more important information of each module. In the sales area, the most important table is the Customer table; in the purchase area, it is the Vendor table; and in the warehouse management module, the Item table is the most important table. Therefore, they are called master tables.
• Secondary...