Table 5401 Item Variant

Base Application, Microsoft.Inventory.Item

src/Layers/W1/BaseApp/Inventory/Item/ItemVariant.Table.al365 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;using Microsoft.Assembly.Document;using Microsoft.Inventory.BOM;using Microsoft.Inventory.Item.Attribute;using Microsoft.Inventory.Item.Catalog;using Microsoft.Inventory.Item.Substitution;using Microsoft.Inventory.Journal;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Inventory.Planning;using Microsoft.Inventory.Requisition;using Microsoft.Inventory.Transfer;using Microsoft.Purchases.Document;using Microsoft.Sales.Document;using Microsoft.Warehouse.ADCS;using Microsoft.Warehouse.Structure;table 5401 "Item Variant"{    Caption = 'Item Variant';    DataCaptionFields = "Item No.", "Code", Description;    LookupPageID = "Item Variants";    DataClassification = CustomerContent;    fields    {        field(1; "Code"; Code[10])        {            Caption = 'Code';            ToolTip = 'Specifies a code to identify the variant.';            OptimizeForTextSearch = true;            NotBlank = true;        }        field(2; "Item No."; Code[20])        {            Caption = 'Item No.';            ToolTip = 'Specifies the number of the item card from which you opened the Item Variant Translations window.';            TableRelation = Item;            trigger OnValidate()            var                Item: Record Item;            begin                if "Item No." = '' then                    Clear("Item Id")                else                    if Item.Get("Item No.") then                        "Item Id" := Item.SystemId;            end;        }        field(3; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies text that describes the item variant.';            OptimizeForTextSearch = true;        }        field(4; "Description 2"; Text[50])        {            Caption = 'Description 2';            ToolTip = 'Specifies the item variant in more detail than the Description field.';            OptimizeForTextSearch = true;        }        field(5; "Item Id"; Guid)        {            Caption = 'Item Id';            TableRelation = Item.SystemId;            trigger OnValidate()            var                Item: Record Item;            begin                Item.SetLoadFields("No.");                if IsNullGuid("Item Id") then                    "Item No." := ''                else                    if Item.GetBySystemId("Item Id") then                        "Item No." := Item."No.";            end;        }        field(54; Blocked; Boolean)        {            Caption = 'Blocked';            ToolTip = 'Specifies that the related record is blocked from being posted in transactions, for example an item variant that is placed in quarantine.';            DataClassification = CustomerContent;        }        field(92; Picture; MediaSet)        {            Caption = 'Picture';            ToolTip = 'Specifies the picture that has been inserted for the item variant.';            DataClassification = CustomerContent;        }        field(8003; "Sales Blocked"; Boolean)        {            Caption = 'Sales Blocked';            ToolTip = 'Specifies that the item variant cannot be entered on sales documents, except return orders and credit memos, and journals.';            DataClassification = CustomerContent;        }        field(8004; "Purchasing Blocked"; Boolean)        {            Caption = 'Purchasing Blocked';            ToolTip = 'Specifies that the item variant cannot be entered on purchase documents, except return orders and credit memos, and journals.';            DataClassification = CustomerContent;        }        field(8010; "Service Blocked"; Boolean)        {            Caption = 'Service Blocked';            ToolTip = 'Specifies that the item variant cannot be entered on service items, service contracts and service documents, except credit memos.';            DataClassification = CustomerContent;        }    }    keys    {        key(Key1; "Item No.", "Code")        {            Clustered = true;        }        key(Key2; "Code")        {        }        key(Key3; Description)        {        }        key(Key4; "Item Id", "Code")        {        }    }    fieldgroups    {        fieldgroup(DropDown; "Item No.", "Code", Description)        {        }        fieldgroup(Brick; "Code", Description, Picture)        {        }    }    trigger OnInsert()    var        ItemAttributeManagement: Codeunit "Item Attribute Management";    begin        if not IsTemporary then            ItemAttributeManagement.InheritAttributesFromItem(Rec, Rec."Item No.");    end;    trigger OnRename()    var        SalesLine: Record "Sales Line";        PurchaseLine: Record "Purchase Line";        ItemVariantAttributeValueMapping: Record "Item Var. Attr. Value Mapping";    begin        if xRec."Item No." <> "Item No." then begin            SalesLine.SetRange(Type, SalesLine.Type::Item);            SalesLine.SetRange("No.", xRec."Item No.");            SalesLine.SetRange("Variant Code", xRec.Code);            if not SalesLine.IsEmpty() then                Error(CannotRenameItemUsedInSalesLinesErr, FieldCaption("Item No."), TableCaption());            PurchaseLine.SetRange(Type, PurchaseLine.Type::Item);            PurchaseLine.SetRange("No.", xRec."Item No.");            PurchaseLine.SetRange("Variant Code", xRec.Code);            if not PurchaseLine.IsEmpty() then                Error(CannotRenameItemUsedInPurchaseLinesErr, FieldCaption("Item No."), TableCaption());        end;        ItemVariantAttributeValueMapping.RenameItemVariantAttributeMapping(xRec."Item No.", xRec.Code, "Item No.", Code);    end;    trigger OnDelete()    var        ItemTranslation: Record "Item Translation";        StockkeepingUnit: Record "Stockkeeping Unit";        ItemIdentifier: Record "Item Identifier";        ItemReference: Record "Item Reference";        BOMComponent: Record "BOM Component";        ItemJournalLine: Record "Item Journal Line";        RequisitionLine: Record "Requisition Line";        PurchaseLine: Record "Purchase Line";        SalesLine: Record "Sales Line";        TransferLine: Record "Transfer Line";        AssemblyHeader: Record "Assembly Header";        ItemSubstitution: Record "Item Substitution";        ItemVendor: Record "Item Vendor";        PlanningAssignment: Record "Planning Assignment";        BinContent: Record "Bin Content";        ItemLedgerEntry: Record "Item Ledger Entry";        ValueEntry: Record "Value Entry";        AssemblyLine: Record "Assembly Line";    begin        BOMComponent.SetCurrentKey(Type, "No.");        BOMComponent.SetRange(Type, BOMComponent.Type::Item);        BOMComponent.SetRange("No.", "Item No.");        BOMComponent.SetRange("Variant Code", Code);        if not BOMComponent.IsEmpty() then            Error(Text001, Code, BOMComponent.TableCaption());        AssemblyHeader.SetCurrentKey("Document Type", "Item No.");        AssemblyHeader.SetRange("Item No.", "Item No.");        AssemblyHeader.SetRange("Variant Code", Code);        if not AssemblyHeader.IsEmpty() then            Error(Text001, Code, AssemblyHeader.TableCaption());        AssemblyLine.SetCurrentKey("Document Type", Type, "No.");        AssemblyLine.SetRange("No.", "Item No.");        AssemblyLine.SetRange("Variant Code", Code);        if not AssemblyLine.IsEmpty() then            Error(Text001, Code, AssemblyLine.TableCaption());        BinContent.SetCurrentKey("Item No.");        BinContent.SetRange("Item No.", "Item No.");        BinContent.SetRange("Variant Code", Code);        if not BinContent.IsEmpty() then            Error(Text001, Code, BinContent.TableCaption());        TransferLine.SetCurrentKey("Item No.");        TransferLine.SetRange("Item No.", "Item No.");        TransferLine.SetRange("Variant Code", Code);        if not TransferLine.IsEmpty() then            Error(Text001, Code, TransferLine.TableCaption());        RequisitionLine.SetCurrentKey(Type, "No.");        RequisitionLine.SetRange(Type, RequisitionLine.Type::Item);        RequisitionLine.SetRange("No.", "Item No.");        RequisitionLine.SetRange("Variant Code", Code);        if not RequisitionLine.IsEmpty() then            Error(Text001, Code, RequisitionLine.TableCaption());        PurchaseLine.SetCurrentKey(Type, "No.");        PurchaseLine.SetRange(Type, PurchaseLine.Type::Item);        PurchaseLine.SetRange("No.", "Item No.");        PurchaseLine.SetRange("Variant Code", Code);        if not PurchaseLine.IsEmpty() then            Error(Text001, Code, PurchaseLine.TableCaption());        SalesLine.SetCurrentKey(Type, "No.");        SalesLine.SetRange(Type, SalesLine.Type::Item);        SalesLine.SetRange("No.", "Item No.");        SalesLine.SetRange("Variant Code", Code);        if not SalesLine.IsEmpty() then            Error(Text001, Code, SalesLine.TableCaption());        ItemJournalLine.SetCurrentKey("Item No.");        ItemJournalLine.SetRange("Item No.", "Item No.");        ItemJournalLine.SetRange("Variant Code", Code);        if not ItemJournalLine.IsEmpty() then            Error(Text001, Code, ItemJournalLine.TableCaption());        ItemLedgerEntry.SetCurrentKey("Item No.");        ItemLedgerEntry.SetRange("Item No.", "Item No.");        ItemLedgerEntry.SetRange("Variant Code", Code);        if not ItemLedgerEntry.IsEmpty() then            Error(Text001, Code, ItemLedgerEntry.TableCaption());        ValueEntry.SetCurrentKey("Item No.");        ValueEntry.SetRange("Item No.", "Item No.");        ValueEntry.SetRange("Variant Code", Code);        if not ValueEntry.IsEmpty() then            Error(Text001, Code, ValueEntry.TableCaption());        OnDeleteOnAfterCheck(Rec);        ItemTranslation.SetRange("Item No.", "Item No.");        ItemTranslation.SetRange("Variant Code", Code);        ItemTranslation.DeleteAll();        ItemIdentifier.SetCurrentKey("Item No.");        ItemIdentifier.SetRange("Item No.", "Item No.");        ItemIdentifier.SetRange("Variant Code", Code);        ItemIdentifier.DeleteAll();        ItemReference.SetRange("Item No.", "Item No.");        ItemReference.SetRange("Variant Code", Code);        ItemReference.DeleteAll();        ItemSubstitution.SetRange(Type, ItemSubstitution.Type::Item);        ItemSubstitution.SetRange("No.", "Item No.");        ItemSubstitution.SetRange("Substitute Type", ItemSubstitution."Substitute Type"::Item);        ItemSubstitution.SetRange("Variant Code", Code);        ItemSubstitution.DeleteAll();        ItemVendor.SetCurrentKey("Item No.");        ItemVendor.SetRange("Item No.", "Item No.");        ItemVendor.SetRange("Variant Code", Code);        ItemVendor.DeleteAll();        StockkeepingUnit.SetRange("Item No.", "Item No.");        StockkeepingUnit.SetRange("Variant Code", Code);        StockkeepingUnit.DeleteAll(true);        PlanningAssignment.SetRange("Item No.", "Item No.");        PlanningAssignment.SetRange("Variant Code", Code);        PlanningAssignment.DeleteAll();        DeleteItemVariantAttributes();        OnAfterOnDelete(Rec);    end;    var#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label 'You cannot delete item variant %1 because there is at least one %2 that includes this Variant Code.';#pragma warning restore AA0470#pragma warning restore AA0074        CannotRenameItemUsedInSalesLinesErr: Label 'You cannot rename %1 in a %2, because it is used in sales document lines.', Comment = '%1 = Item No. caption, %2 = Table caption.';        CannotRenameItemUsedInPurchaseLinesErr: Label 'You cannot rename %1 in a %2, because it is used in purchase document lines.', Comment = '%1 = Item No. caption, %2 = Table caption.';    procedure UpdateReferencedIds()    var        Item: Record Item;    begin        if "Item No." = '' then begin            Clear("Item Id");            exit;        end;        Item.SetLoadFields(SystemId);        if not Item.Get("Item No.") then            exit;        "Item Id" := Item.SystemId;    end;    local procedure DeleteItemVariantAttributes()    var        ItemVariantAttributeValueMapping: Record "Item Var. Attr. Value Mapping";    begin        ItemVariantAttributeValueMapping.SetRange("Item No.", "Item No.");        ItemVariantAttributeValueMapping.SetRange("Variant Code", Code);        ItemVariantAttributeValueMapping.DeleteAll();    end;    [IntegrationEvent(false, false)]    local procedure OnAfterOnDelete(ItemVariant: Record "Item Variant")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteOnAfterCheck(var ItemVariant: Record "Item Variant")    begin    end;    [IntegrationEvent(false, false)]    internal procedure OnAfterDeleteItemVariantPicture(var ItemVariant: Record "Item Variant")    begin    end;    [IntegrationEvent(false, false)]    internal procedure OnAfterTakeNewPicture(var ItemVariant: Record "Item Variant"; IsPictureAdded: Boolean)    begin    end;    [IntegrationEvent(false, false)]    internal procedure OnImportFromDeviceOnAfterModify(var ItemVariant: Record "Item Variant")    begin    end;}