Implementing Microsoft Dynamics 365 Business Central On-Premise - Fourth Edition

Snippet table

Typing the shortcut table will create the basic layout for a table object when using the AL language extension.

The following is an example of a table that stores address information and has two fields: Address and Locality:

table 50104 Address
{
    caption = 'Sample table';
    DataPerCompany = true;

    fields
    {
        field(1; Address; Text[50])
        {
            Description = 'Address retrieved by Service';
        }
        field(2; Locality; Text[30])
        {
            Description = 'Locality retrieved by Service';
        }        
    }
    keys
    {
        key(PrimaryKey; Address)
        {
            Clustered = TRUE;
        }
    }
      
    trigger OnInsert();
    begin
    end;

    procedure MyMethod();
    begin
        Message(Msg);
    end;
}