Components of a table

A table is made up of Fields, Properties, Triggers (some of which may contain C/AL code) and Keys. Fields also have Properties and Triggers. Keys also have Properties:

A table definition that takes full advantage of these capabilities reduces the effort required to construct other parts of the application. Good table design can significantly enhance the application's processing speed, efficiency, and flexibility.

A table can have the following:

• Up to 500 fields
• A defined record size of up to 8,000 bytes (with each field sized at its maximum)
• Up to 40 different keys