AL Development in Business Central – Part 5 How to create a table extension

To create a table extension you need to define the following things:

• The TableExtension ID and Name
• Which table to extend
• The new field ID and Name, DataType, Caption and DataClassification

More information about the DataClassification property can be found on Microsoft Docs: https://docs.microsoft.com/nl-be/dynamics-nav/dataclassification-property

An example:

tableextension 50100 "Customer Extension" extends Customer
{
    fields
    {
        field(50000; Skilled; Boolean)
        {
            DataClassification = ToBeClassified;
        }
    }
}

Don’t forget to extend the relevant pages with the new fields so that users can also see this new field when they open the customer card or customer list. In the post post I will show how to extends the pages and demonstrate how this will look to the user.