Mastering Microsoft Dynamics 365 Business Central

Table definition

By using the ttable snippet, we define the Vendor Quality table as follows:

table 50102 "Vendor Quality_PKT"{ Caption = 'Vendor Quality'; DataClassification = CustomerContent; fields {     field(1; "Vendor No."; Code[20])     {         Caption = 'Vendor No.';         DataClassification = CustomerContent;         TableRelation = Vendor;     }     field(2; "Vendor Name"; Text[50])     {         Caption = 'Vendor Name';         FieldClass = FlowField;         CalcFormula = lookup (Vendor.Name where ("No." = field ("Vendor No.")));     }     field(3; "Vendor Activity Description"; Text[250])     {         Caption = 'Vendor Activity Description';         DataClassification = CustomerContent;     }     field(4; ScoreItemQuality; Integer)     {         Caption = 'Item Quality Score';         DataClassification = CustomerContent;         MinValue = 1; MaxValue ...