Table 6236 Sust. Item Mat. Comp. Header

Sustainability, Microsoft.Sustainability.EPR

src/Apps/W1/Sustainability/app/src/EPR/SustItemMatCompHeader.Table.al154 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.Sustainability.EPR;using Microsoft.Foundation.NoSeries;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Sustainability.Setup;table 6236 "Sust. Item Mat. Comp. Header"{    Caption = 'Item Material Composition Header';    DataCaptionFields = "No.", Description;    DrillDownPageID = "Sust. Item Mat. Comp. List";    LookupPageID = "Sust. Item Mat. Comp. List";    DataClassification = CustomerContent;    fields    {        field(1; "No."; Code[20])        {            Caption = 'No.';        }        field(10; Description; Text[100])        {            Caption = 'Description';        }        field(21; "Unit of Measure Code"; Code[10])        {            Caption = 'Unit of Measure Code';            TableRelation = "Unit of Measure";            trigger OnValidate()            var                Item: Record Item;                ItemUnitOfMeasure: Record "Item Unit of Measure";            begin                if Status = Status::Certified then                    FieldError(Status);                Item.SetCurrentKey("Material Composition No.");                Item.SetRange("Material Composition No.", "No.");                if Item.FindSet() then                    repeat                        ItemUnitOfMeasure.Get(Item."No.", "Unit of Measure Code");                    until Item.Next() = 0;            end;        }        field(40; "Creation Date"; Date)        {            Caption = 'Creation Date';            Editable = false;        }        field(43; "Last Date Modified"; Date)        {            Caption = 'Last Date Modified';            Editable = false;        }        field(45; Status; Enum "Sust. Item Mat. Comp. Status")        {            Caption = 'Status';        }        field(51; "No. Series"; Code[20])        {            Caption = 'No. Series';            Editable = false;            TableRelation = "No. Series";        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }    }    fieldgroups    {        fieldgroup(DropDown; "No.", Description, Status)        {        }    }    trigger OnDelete()    var        Item: Record Item;    begin        Item.SetRange("Material Composition No.", "No.");        if not Item.IsEmpty() then            Error(ItemMaterialCompositionIsAlreadyBeingUsedOnItemsErr);        ItemMaterialCompositionLine.SetRange("Item Material Composition No.", "No.");        ItemMaterialCompositionLine.DeleteAll(true);    end;    trigger OnInsert()    var        NoSeries: Codeunit "No. Series";    begin        SustainabilitySetup.Get();        if "No." = '' then begin            SustainabilitySetup.TestField("Item Material Composition Nos.");            if NoSeries.AreRelated(SustainabilitySetup."Item Material Composition Nos.", xRec."No. Series") then                "No. Series" := xRec."No. Series"            else                "No. Series" := SustainabilitySetup."Item Material Composition Nos.";            "No." := NoSeries.GetNextNo("No. Series");        end;        "Creation Date" := Today;    end;    trigger OnModify()    begin        "Last Date Modified" := Today;    end;    trigger OnRename()    begin        if Status = Status::Certified then            Error(CannotRenameItemMaterialCompErr, TableCaption(), FieldCaption(Status), Format(Status));    end;    var        SustainabilitySetup: Record "Sustainability Setup";        ItemMaterialCompositionHeader: Record "Sust. Item Mat. Comp. Header";        ItemMaterialCompositionLine: Record "Sust. Item Mat. Comp. Line";        ItemMaterialCompositionIsAlreadyBeingUsedOnItemsErr: Label 'This Item Material Composition is being used on Items.';        CannotRenameItemMaterialCompErr: Label 'You cannot rename the %1 when %2 is %3.', Comment = '%1 = Table Caption , %2 = Field Caption , %3 = Status';    procedure AssistEdit(OldItemMatCompHeader: Record "Sust. Item Mat. Comp. Header"): Boolean    var        NoSeries: Codeunit "No. Series";    begin        ItemMaterialCompositionHeader := Rec;        SustainabilitySetup.Get();        SustainabilitySetup.TestField("Item Material Composition Nos.");        if NoSeries.LookupRelatedNoSeries(SustainabilitySetup."Item Material Composition Nos.", OldItemMatCompHeader."No. Series", ItemMaterialCompositionHeader."No. Series") then begin            ItemMaterialCompositionHeader."No." := NoSeries.GetNextNo(ItemMaterialCompositionHeader."No. Series");            Rec := ItemMaterialCompositionHeader;            exit(true);        end;    end;    procedure ItemMaterialCompositionExist(): Boolean    var        ItemMatCompLine: Record "Sust. Item Mat. Comp. Line";    begin        ItemMatCompLine.SetRange("Item Material Composition No.", Rec."No.");        exit(not ItemMatCompLine.IsEmpty());    end;}