Table 310 No. Series Relationship
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") { } }}