Table 99000779 Production BOM Version

Base Application, Microsoft.Manufacturing.ProductionBOM

src/Layers/W1/BaseApp/Manufacturing/ProductionBOM/ProductionBOMVersion.Table.al257 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.Manufacturing.ProductionBOM;using Microsoft.Foundation.NoSeries;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Planning;table 99000779 "Production BOM Version"{    Caption = 'Production BOM Version';    DataCaptionFields = "Production BOM No.", "Version Code", Description;    DrillDownPageID = "Prod. BOM Version List";    LookupPageID = "Prod. BOM Version List";    DataClassification = CustomerContent;    fields    {        field(1; "Production BOM No."; Code[20])        {            Caption = 'Production BOM No.';            NotBlank = true;            TableRelation = "Production BOM Header";        }        field(2; "Version Code"; Code[20])        {            Caption = 'Version Code';            ToolTip = 'Specifies the version code of the production BOM.';        }        field(3; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies a description for the production BOM version.';        }        field(10; "Starting Date"; Date)        {            Caption = 'Starting Date';            ToolTip = 'Specifies the starting date for this production BOM version.';        }        field(21; "Unit of Measure Code"; Code[10])        {            Caption = 'Unit of Measure Code';            ToolTip = 'Specifies the manufacturing batch unit of measure.';            TableRelation = "Unit of Measure";            trigger OnValidate()            var                Item: Record Item;                ItemUnitOfMeasure: Record "Item Unit of Measure";            begin                if (Status = Status::Certified) and ("Unit of Measure Code" <> xRec."Unit of Measure Code") then                    FieldError(Status);                Item.SetRange("Production BOM No.", "Production BOM No.");                if Item.FindSet() then                    repeat                        ItemUnitOfMeasure.Get(Item."No.", "Unit of Measure Code");                    until Item.Next() = 0;            end;        }        field(22; "Last Date Modified"; Date)        {            Caption = 'Last Date Modified';            ToolTip = 'Specifies when the production BOM version card was last modified.';            Editable = false;        }        field(45; Status; Enum "BOM Status")        {            Caption = 'Status';            ToolTip = 'Specifies the status of this production BOM version.';            trigger OnValidate()            var                PlanningAssignment: Record "Planning Assignment";                ProdBOMHeader: Record "Production BOM Header";                ProdBOMCheck: Codeunit "Production BOM-Check";                IsHandled: Boolean;                SkipCommit: Boolean;            begin                IsHandled := false;                OnBeforeOnValidateStatus(Rec, xRec, IsHandled);                if IsHandled then                    exit;                if (Status <> xRec.Status) and (Status = Status::Certified) then begin                    CheckVariantMandatoryOnLines();                    ProdBOMCheck.ProdBOMLineCheck("Production BOM No.", "Version Code");                    TestField("Unit of Measure Code");                    ProdBOMHeader.Get("Production BOM No.");                    ProdBOMHeader."Low-Level Code" := 0;                    ProdBOMCheck.Code(ProdBOMHeader, "Version Code");                    PlanningAssignment.NewBOM("Production BOM No.");                end;                OnValidateStatusBeforeModify(Rec, xRec, CurrFieldNo);                Modify(true);                SkipCommit := false;                OnValidateStatusBeforeCommit(Rec, SkipCommit);                if not SkipCommit then                    Commit();            end;        }        field(50; "No. Series"; Code[20])        {            Caption = 'No. Series';            Editable = false;            TableRelation = "No. Series";        }    }    keys    {        key(Key1; "Production BOM No.", "Version Code")        {            Clustered = true;        }        key(Key2; "Production BOM No.", "Starting Date")        {        }    }    fieldgroups    {    }    trigger OnDelete()    var        ProdBOMLine: Record "Production BOM Line";    begin        ProdBOMLine.SetRange("Production BOM No.", "Production BOM No.");        ProdBOMLine.SetRange("Version Code", "Version Code");        ProdBOMLine.DeleteAll(true);    end;    trigger OnInsert()    var        NoSeries: Codeunit "No. Series";    begin        ProdBOMHeader.Get("Production BOM No.");        if "Version Code" = '' then begin            ProdBOMHeader.TestField("Version Nos.");            if NoSeries.AreRelated(ProdBOMHeader."Version Nos.", xRec."No. Series") then                "No. Series" := xRec."No. Series"            else                "No. Series" := ProdBOMHeader."Version Nos.";            "Version Code" := NoSeries.GetNextNo("No. Series");        end;    end;    trigger OnModify()    begin        "Last Date Modified" := Today;    end;    trigger OnRename()    begin        if Status = Status::Certified then            Error(Text001, TableCaption(), FieldCaption(Status), Format(Status));    end;    var        ProdBOMHeader: Record "Production BOM Header";        ProdBOMVersion: Record "Production BOM Version";#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label 'You cannot rename the %1 when %2 is %3.';#pragma warning restore AA0470#pragma warning restore AA0074    local procedure CheckVariantMandatoryOnLines()    var        ProdBOMLineRec: Record "Production BOM Line";    begin        ProdBOMLineRec.SetLoadFields("Production BOM No.", "Version Code", "Line No.", Type, "No.", "Variant Code");        ProdBOMLineRec.SetRange("Production BOM No.", "Production BOM No.");        ProdBOMLineRec.SetRange("Version Code", "Version Code");        if ProdBOMLineRec.FindSet() then            repeat                CheckVariantIfMandatory(ProdBOMLineRec);            until ProdBOMLineRec.Next() = 0;    end;    local procedure CheckVariantIfMandatory(var ProductionBOMLine: Record "Production BOM Line")    var        Item: Record Item;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckVariantIfMandatory(Rec, xRec, ProductionBOMLine, IsHandled);        if IsHandled then            exit;        if Item.IsVariantMandatory(ProductionBOMLine.Type = ProductionBOMLine.Type::Item, ProductionBOMLine."No.") then            ProductionBOMLine.TestField("Variant Code");    end;    procedure AssistEdit(OldProdBOMVersion: Record "Production BOM Version"): Boolean    var        NoSeries: Codeunit "No. Series";    begin        ProdBOMVersion := Rec;        ProdBOMHeader.Get(ProdBOMVersion."Production BOM No.");        ProdBOMHeader.TestField("Version Nos.");        if NoSeries.LookupRelatedNoSeries(ProdBOMHeader."Version Nos.", OldProdBOMVersion."No. Series", ProdBOMVersion."No. Series") then begin            ProdBOMVersion."Version Code" := NoSeries.GetNextNo(ProdBOMVersion."No. Series");            Rec := ProdBOMVersion;            exit(true);        end;    end;    procedure Caption(): Text    var        ProdBOMHeader: Record "Production BOM Header";    begin        if GetFilters = '' then            exit('');        if not ProdBOMHeader.Get("Production BOM No.") then            exit('');        exit(          CopyStr(StrSubstNo('%1 %2 %3',            "Production BOM No.", ProdBOMHeader.Description, "Version Code"), 1, 100));    end;    procedure ProductionBOMLinesExist(): Boolean    var        ProductionBOMLine: Record "Production BOM Line";    begin        ProductionBOMLine.SetRange("Production BOM No.", Rec."Production BOM No.");        ProductionBOMLine.SetRange("Version Code", Rec."Version Code");        exit(not ProductionBOMLine.IsEmpty());    end;    [IntegrationEvent(false, false)]    local procedure OnValidateStatusBeforeModify(var ProductionBOMVersion: Record "Production BOM Version"; var xProductionBOMVersion: Record "Production BOM Version"; CallingFieldNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnValidateStatusBeforeCommit(var ProductionBOMVersion: Record "Production BOM Version"; var SkipCommit: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeOnValidateStatus(var ProductionBOMVersion: Record "Production BOM Version"; var xProductionBOMVersion: Record "Production BOM Version"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckVariantIfMandatory(var ProductionBOMVersion: Record "Production BOM Version"; xProductionBOMVersion: Record "Production BOM Version"; var ProductionBOMLine: Record "Production BOM Line"; var IsHandled: Boolean)    begin    end;}