Mastering Microsoft Dynamics 365 Business Central

The tableextension definition

We need to create a new field in the Customer table to handle the Customer Category assignment and, in order to do that, we need to create a tableextension object. This can be done in AL by using the ttableext snippet.

The tableextension object for the Customer table is defined as follows:

tableextension 50100 "CustomerTableExtensions_PKT" extends Customer //18 { fields {     field(50100; "Customer Category Code_PKT"; Code[20])     {         TableRelation = "Customer Category_PKT".No;         Caption = 'Customer Category Code';         DataClassification = CustomerContent;         trigger OnValidate()         var             CustomerCategory: Record "Customer Category_PKT";             ErrBlocked: Label 'This category is Blocked.';         begin             CustomerCategory.Get("Customer Category Code_PKT" ...