Table 8 Language in 26

App
System Application
Namespace
System.Globalization

Fields, 4Keys, 2

Versions171819202122232425262728latest

Source242526272829

Source in 26

src/System Application/App/Language/src/Language.Table.al67 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------

namespace System.Globalization;

/// <summary>
/// Table that contains the available application languages.
/// </summary>
table 8 Language
{
    Access = Public;
    LookupPageId = Languages;
    InherentEntitlements = RX;
    InherentPermissions = RX;

    fields
    {
        field(1; "Code"; Code[10])
        {
            DataClassification = SystemMetadata;
            NotBlank = true;
        }
        field(2; Name; Text[50])
        {
            DataClassification = SystemMetadata;
        }
        field(6; "Windows Language ID"; Integer)
        {
            DataClassification = SystemMetadata;
            BlankZero = true;
            TableRelation = "Windows Language";

            trigger OnValidate()
            begin
                CalcFields("Windows Language Name");
            end;
        }
        field(7; "Windows Language Name"; Text[80])
        {
            CalcFormula = lookup("Windows Language".Name where("Language ID" = field("Windows Language ID")));
            Editable = false;
            FieldClass = FlowField;
        }
    }

    keys
    {
        key(Key1; "Code")
        {
            Clustered = true;
        }
        key(Key2; "Windows Language ID")
        {
        }
    }

    fieldgroups
    {
        fieldgroup(Brick; Name)
        {
        }
    }
}

Fields, 4

IdNameTypeObsolete
1CodeCode[10]-
2NameText[50]-
6Windows Language IDInteger-
7Windows Language NameText[80]-

Keys, 2

NameFieldsObsolete
Key1, clusteredCode-
Key2Windows Language ID-