Table 5716 Substitution Condition
src/Layers/W1/BaseApp/Inventory/Item/Substitution/SubstitutionCondition.Table.al72 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.Inventory.Item.Substitution;table 5716 "Substitution Condition"{ Caption = 'Substitution Condition'; DataClassification = CustomerContent; fields { field(1; "No."; Code[20]) { Caption = 'No.'; TableRelation = "Item Substitution"."No." where("No." = field("No.")); } field(2; "Variant Code"; Code[10]) { Caption = 'Variant Code'; TableRelation = "Item Substitution"."Variant Code" where("No." = field("No."), "Variant Code" = field("Variant Code")); } field(3; "Substitute No."; Code[20]) { Caption = 'Substitute No.'; TableRelation = "Item Substitution"."Substitute No." where("No." = field("No."), "Variant Code" = field("Variant Code"), "Substitute No." = field("Substitute No.")); } field(4; "Substitute Variant Code"; Code[10]) { Caption = 'Substitute Variant Code'; TableRelation = "Item Substitution"."Substitute Variant Code" where("No." = field("No."), "Variant Code" = field("Variant Code"), "Substitute No." = field("Substitute No."), "Substitute Variant Code" = field("Substitute Variant Code")); } field(5; "Line No."; Integer) { Caption = 'Line No.'; } field(6; Condition; Text[80]) { Caption = 'Condition'; ToolTip = 'Specifies the condition for item substitution.'; } field(100; Type; Enum "Item Substitution Type") { Caption = 'Type'; } field(101; "Substitute Type"; Enum "Item Substitute Type") { Caption = 'Substitute Type'; } } keys { key(Key1; Type, "No.", "Variant Code", "Substitute Type", "Substitute No.", "Substitute Variant Code", "Line No.") { Clustered = true; } } fieldgroups { }}