Table 310 No. Series Relationship

Business Foundation, Microsoft.Foundation.NoSeries

src/Business Foundation/App/NoSeries/src/Setup/NoSeriesRelationship.Table.al71 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 Microsoft.Foundation.NoSeries;table 310 "No. Series Relationship"{    Caption = 'No. Series Relationship';    DataClassification = CustomerContent;    DrillDownPageId = "No. Series Relationships";    LookupPageId = "No. Series Relationships";#if not CLEANSCHEMA27    MovedFrom = '437dbf0e-84ff-417a-965d-ed2bb9650972';#endif    InherentEntitlements = rX;    InherentPermissions = rX;    fields    {        field(1; "Code"; Code[20])        {            Caption = 'Code';            NotBlank = true;            TableRelation = "No. Series";            trigger OnValidate()            begin                CalcFields(Description);            end;        }        field(2; "Series Code"; Code[20])        {            Caption = 'Series Code';            NotBlank = true;            TableRelation = "No. Series";            trigger OnValidate()            begin                CalcFields("Series Description");            end;        }        field(3; Description; Text[100])        {            CalcFormula = lookup("No. Series".Description where(Code = field(Code)));            Caption = 'Description';            Editable = false;            FieldClass = FlowField;        }        field(4; "Series Description"; Text[100])        {            CalcFormula = lookup("No. Series".Description where(Code = field("Series Code")));            Caption = 'Series Description';            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "Code", "Series Code")        {            Clustered = true;        }        key(Key2; "Series Code", "Code")        {        }    }}