Chapter 2. Tables
"Sometimes the questions are complicated and the answers are simple." | ||
| --Dr. Seuss (Theodor Seuss Geisel) | ||
"The loftier the building, the deeper must the foundation be laid." | ||
| --Thomas à Kempis | ||
The foundation of any system is the data structure definition. In NAV, the building blocks of this foundation are the Tables and the individual data fields that the tables contain. Once the functional analysis and process definition has been completed, any new design work must begin with the data structure. For NAV, that means the tables and their contents.
A NAV table includes much more than just the data fields and keys. A NAV table definition also includes data validation rules, processing rules, business rules, and logic to ensure referential integrity. The rules are in the form of properties and C/AL code.
In this chapter, we will learn about the structure and creation of tables. Details about fields, the components...
