Table 7500 Item Attribute

Base Application, Microsoft.Inventory.Item.Attribute

src/Layers/W1/BaseApp/Inventory/Item/Attribute/ItemAttribute.Table.al303 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.Attribute;using System.Globalization;table 7500 "Item Attribute"{    Caption = 'Item Attribute';    DataCaptionFields = Name;    LookupPageID = "Item Attributes";    DataClassification = CustomerContent;    fields    {        field(1; ID; Integer)        {            AutoIncrement = true;            Caption = 'ID';            NotBlank = true;        }        field(2; Name; Text[250])        {            Caption = 'Name';            ToolTip = 'Specifies the name of the item attribute.';            NotBlank = true;            trigger OnValidate()            begin                if xRec.Name = Name then                    exit;                TestField(Name);                if HasBeenUsed() then                    if not Confirm(RenameUsedAttributeQst) then                        Error('');                CheckNameUniqueness(Rec, Name);                DeleteValuesAndTranslationsConditionally(xRec, Name);            end;        }        field(6; Blocked; Boolean)        {            Caption = 'Blocked';            ToolTip = 'Specifies that the attribute cannot be assigned to an item. Items to which the attribute is already assigned are not affected.';        }        field(7; Type; Option)        {            Caption = 'Type';            ToolTip = 'Specifies the type of the item attribute.';            InitValue = Text;            OptionCaption = 'Option,Text,Integer,Decimal,Date';            OptionMembers = Option,Text,"Integer",Decimal,Date;            trigger OnValidate()            var                ItemAttributeValue: Record "Item Attribute Value";            begin                if xRec.Type <> Type then begin                    ItemAttributeValue.SetRange("Attribute ID", ID);                    if not ItemAttributeValue.IsEmpty() then                        Error(ChangingAttributeTypeErr, Name);                end;            end;        }        field(8; "Unit of Measure"; Text[30])        {            Caption = 'Unit of Measure';            ToolTip = 'Specifies the name of the item or resource''s unit of measure, such as piece or hour.';            trigger OnValidate()            begin                if (xRec."Unit of Measure" <> '') and (xRec."Unit of Measure" <> "Unit of Measure") then                    if HasBeenUsed() then                        if not Confirm(ChangeUsedAttributeUoMQst) then                            Error('');            end;        }    }    keys    {        key(Key1; ID)        {            Clustered = true;        }        key(Key2; Name)        {        }    }    fieldgroups    {        fieldgroup(DropDown; Name)        {        }        fieldgroup(Brick; ID, Name)        {        }    }    trigger OnDelete()    begin        if HasBeenUsed() then            if not Confirm(DeleteUsedAttributeQst) then                Error('');        DeleteValuesAndTranslations();    end;    trigger OnRename()    var        ItemAttributeValue: Record "Item Attribute Value";    begin        ItemAttributeValue.SetRange("Attribute ID", xRec.ID);        if ItemAttributeValue.FindSet() then            repeat                ItemAttributeValue.Rename(ID, ItemAttributeValue.ID);            until ItemAttributeValue.Next() = 0;    end;    trigger OnInsert()    begin        TestField(Name);    end;    var        ItemAttributeTranslation: Record "Item Attribute Translation";        NameAlreadyExistsErr: Label 'The item attribute with name ''%1'' already exists.', Comment = '%1 - arbitrary name';        ReuseValueTranslationsQst: Label 'There are values and translations for item attribute ''%1''.\\Do you want to reuse them after changing the item attribute name to ''%2''?', Comment = '%1 - arbitrary name,%2 - arbitrary name';        ChangingAttributeTypeErr: Label 'You cannot change the type of item attribute ''%1'', because it is either in use or it has predefined values.', Comment = '%1 - arbirtrary text';        DeleteUsedAttributeQst: Label 'This item attribute has been assigned to at least one item or item variant.\\Are you sure you want to delete it?';        RenameUsedAttributeQst: Label 'This item attribute has been assigned to at least one item or item variant.\\Are you sure you want to rename it?';        ChangeUsedAttributeUoMQst: Label 'This item attribute has been assigned to at least one item or item variant.\\Are you sure you want to change its unit of measure?';        ChangeToOptionQst: Label 'Predefined values can be defined only for item attributes of type Option.\\Do you want to change the type of this item attribute to Option?';    procedure GetTranslatedName(LanguageID: Integer) TranslatedName: Text[250]    var        Language: Codeunit Language;        LanguageCode: Code[10];        IsHandled: Boolean;    begin        OnBeforeGetTranslatedName(Rec, LanguageID, TranslatedName, IsHandled);        if IsHandled then            exit(TranslatedName);        LanguageCode := Language.GetLanguageCode(LanguageID);        if LanguageCode <> '' then begin            GetAttributeTranslation(LanguageCode);            exit(ItemAttributeTranslation.Name);        end;        exit(Name);    end;    procedure GetNameInCurrentLanguage(): Text[250]    begin        exit(GetTranslatedName(GlobalLanguage));    end;    local procedure GetAttributeTranslation(LanguageCode: Code[10])    begin        if (ItemAttributeTranslation."Attribute ID" <> ID) or (ItemAttributeTranslation."Language Code" <> LanguageCode) then            if not ItemAttributeTranslation.Get(ID, LanguageCode) then begin                ItemAttributeTranslation.Init();                ItemAttributeTranslation."Attribute ID" := ID;                ItemAttributeTranslation."Language Code" := LanguageCode;                ItemAttributeTranslation.Name := Name;                OnGetAttributeTranslationOnAfterCreateNewTranslation(Rec, ItemAttributeTranslation);            end;    end;    procedure GetValues() Values: Text    var        ItemAttributeValue: Record "Item Attribute Value";    begin        if Type <> Type::Option then            exit('');        ItemAttributeValue.SetRange("Attribute ID", ID);        if ItemAttributeValue.FindSet() then            repeat                if Values <> '' then                    Values += ',';                Values += ItemAttributeValue.Value;            until ItemAttributeValue.Next() = 0;    end;    procedure HasBeenUsed() AttributeHasBeenUsed: Boolean    var        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";        ItemVariantAttributeValueMapping: Record "Item Var. Attr. Value Mapping";    begin        ItemAttributeValueMapping.SetRange("Item Attribute ID", ID);        AttributeHasBeenUsed := not ItemAttributeValueMapping.IsEmpty();        if not AttributeHasBeenUsed then begin            ItemVariantAttributeValueMapping.SetRange("Item Attribute ID", ID);            AttributeHasBeenUsed := not ItemVariantAttributeValueMapping.IsEmpty();        end;        OnAfterHasBeenUsed(Rec, AttributeHasBeenUsed);    end;    procedure RemoveUnusedArbitraryValues()    var        ItemAttributeValue: Record "Item Attribute Value";    begin        if Type = Type::Option then            exit;        ItemAttributeValue.SetRange("Attribute ID", ID);        if ItemAttributeValue.FindSet() then            repeat                if not ItemAttributeValue.HasBeenUsed() then                    ItemAttributeValue.Delete();            until ItemAttributeValue.Next() = 0;    end;    procedure OpenItemAttributeValues()    var        ItemAttributeValue: Record "Item Attribute Value";    begin        ItemAttributeValue.SetRange("Attribute ID", ID);        if (Type <> Type::Option) and ItemAttributeValue.IsEmpty() then            if Confirm(ChangeToOptionQst) then begin                Validate(Type, Type::Option);                Modify();            end;        if Type = Type::Option then            PAGE.Run(PAGE::"Item Attribute Values", ItemAttributeValue);    end;    local procedure CheckNameUniqueness(ItemAttribute: Record "Item Attribute"; NameToCheck: Text[250])    begin        OnBeforeCheckNameUniqueness(ItemAttribute, Rec);        ItemAttribute.SetRange(Name, NameToCheck);        ItemAttribute.SetFilter(ID, '<>%1', ItemAttribute.ID);        if not ItemAttribute.IsEmpty() then            Error(NameAlreadyExistsErr, NameToCheck);    end;    local procedure DeleteValuesAndTranslationsConditionally(ItemAttribute: Record "Item Attribute"; NameToCheck: Text[250])    var        ItemAttributeTranslation: Record "Item Attribute Translation";        ItemAttributeValue: Record "Item Attribute Value";        ValuesOrTranslationsExist: Boolean;    begin        if (ItemAttribute.Name <> '') and (ItemAttribute.Name <> NameToCheck) then begin            ItemAttributeValue.SetRange("Attribute ID", ID);            ItemAttributeTranslation.SetRange("Attribute ID", ID);            ValuesOrTranslationsExist := not (ItemAttributeValue.IsEmpty() and ItemAttributeTranslation.IsEmpty);            if ValuesOrTranslationsExist then                if not Confirm(StrSubstNo(ReuseValueTranslationsQst, ItemAttribute.Name, NameToCheck)) then                    DeleteValuesAndTranslations();        end;    end;    local procedure DeleteValuesAndTranslations()    var        ItemAttributeValue: Record "Item Attribute Value";        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";        ItemVariantAttributeValueMapping: Record "Item Var. Attr. Value Mapping";        ItemAttrValueTranslation: Record "Item Attr. Value Translation";    begin        ItemAttributeValueMapping.SetRange("Item Attribute ID", ID);        ItemAttributeValueMapping.DeleteAll();        ItemVariantAttributeValueMapping.SetRange("Item Attribute ID", ID);        ItemVariantAttributeValueMapping.DeleteAll();        ItemAttributeValue.SetRange("Attribute ID", ID);        ItemAttributeValue.DeleteAll();        ItemAttributeTranslation.SetRange("Attribute ID", ID);        ItemAttributeTranslation.DeleteAll();        ItemAttrValueTranslation.SetRange("Attribute ID", ID);        ItemAttrValueTranslation.DeleteAll();    end;    [IntegrationEvent(false, false)]    local procedure OnAfterHasBeenUsed(var ItemAttribute: Record "Item Attribute"; var AttributeHasBeenUsed: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckNameUniqueness(var NewItemAttribute: Record "Item Attribute"; ItemAttribute: Record "Item Attribute")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetTranslatedName(var ItemAttribute: Record "Item Attribute"; LanguageID: Integer; var TranslatedName: Text[250]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetAttributeTranslationOnAfterCreateNewTranslation(ItemAttribute: Record "Item Attribute"; var ItemAttributeTranslation: Record "Item Attribute Translation")    begin    end;}