Table 99000786 Routing Version

Base Application, Microsoft.Manufacturing.Routing

src/Layers/W1/BaseApp/Manufacturing/Routing/RoutingVersion.Table.al217 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.Routing;using Microsoft.Foundation.NoSeries;table 99000786 "Routing Version"{    Caption = 'Routing Version';    DrillDownPageID = "Routing Version List";    LookupPageID = "Routing Version List";    DataClassification = CustomerContent;    fields    {        field(1; "Routing No."; Code[20])        {            Caption = 'Routing No.';            NotBlank = true;            TableRelation = "Routing Header";        }        field(2; "Version Code"; Code[20])        {            Caption = 'Version Code';            ToolTip = 'Specifies the version code of the routing.';        }        field(3; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies a description for the routing version.';        }        field(10; "Starting Date"; Date)        {            Caption = 'Starting Date';            ToolTip = 'Specifies the starting date for this routing version.';        }        field(20; Status; Enum "Routing Status")        {            Caption = 'Status';            ToolTip = 'Specifies the status of this routing version.';            trigger OnValidate()            var                RoutingHeader: Record "Routing Header";                SkipCommit: Boolean;            begin                if (Status <> xRec.Status) and (Status = Status::Certified) then begin                    RoutingHeader.Get("Routing No.");                    CheckRouting.Calculate(RoutingHeader, "Version Code");                end;                Modify(true);                SkipCommit := false;                OnValidateStatusBeforeCommit(Rec, SkipCommit);                if not SkipCommit then                    Commit();            end;        }        field(21; Type; Option)        {            Caption = 'Type';            ToolTip = 'Specifies in which order operations in the routing are performed.';            OptionCaption = 'Serial,Parallel';            OptionMembers = Serial,Parallel;            trigger OnValidate()            begin                if Status = Status::Certified then                    FieldError(Status);            end;        }        field(22; "Last Date Modified"; Date)        {            Caption = 'Last Date Modified';            Editable = false;        }        field(50; "No. Series"; Code[20])        {            Caption = 'No. Series';            Editable = false;            TableRelation = "No. Series";        }    }    keys    {        key(Key1; "Routing No.", "Version Code")        {            Clustered = true;        }        key(Key2; "Routing No.", "Starting Date")        {        }    }    fieldgroups    {    }    trigger OnDelete()    var        RtngLine: Record "Routing Line";    begin        RtngLine.LockTable();        RtngLine.SetRange("Routing No.", "Routing No.");        RtngLine.SetRange("Version Code", "Version Code");        RtngLine.DeleteAll(true);    end;    trigger OnInsert()    var        NoSeries: Codeunit "No. Series";    begin        if "Version Code" = '' then begin            RoutingHeader.Get("Routing No.");            RoutingHeader.TestField("Version Nos.");                "No. Series" := RoutingHeader."Version Nos.";                if NoSeries.AreRelated("No. Series", xRec."No. Series") then                    "No. Series" := xRec."No. Series";                VersionCode := NoSeries.GetNextNo("No. Series");            if StrLen(VersionCode) > MaxStrLen("Version Code") then                Error(Text000,                  FieldCaption("Version Code"),                  NoSeriesLine.FieldCaption("Starting No."),                  RoutingHeader."Version Nos.",                  NoSeriesRec.TableCaption(),                  MaxStrLen("Version Code"));            "Version Code" := VersionCode;        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        NoSeriesRec: Record "No. Series";        NoSeriesLine: Record "No. Series Line";        RoutingHeader: Record "Routing Header";        RtngVersion: Record "Routing Version";        CheckRouting: Codeunit "Check Routing Lines";#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'The new %1 cannot be generated by default\because the %2 for %3 %4 contains more than %5 characters.';#pragma warning restore AA0470#pragma warning restore AA0074        VersionCode: Code[20];#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    procedure AssistEdit(OldRoutVersion: Record "Routing Version"): Boolean    var        NoSeries: Codeunit "No. Series";    begin        RtngVersion := Rec;        RoutingHeader.Get(RtngVersion."Routing No.");        RoutingHeader.TestField("Version Nos.");        if NoSeries.LookupRelatedNoSeries(RoutingHeader."Version Nos.", OldRoutVersion."No. Series", RtngVersion."No. Series") then begin            VersionCode := NoSeries.GetNextNo(RtngVersion."No. Series");            if StrLen(VersionCode) > MaxStrLen(RtngVersion."Version Code") then                Error(Text000,                  RtngVersion.FieldCaption(RtngVersion."Version Code"),                  NoSeriesLine.FieldCaption("Starting No."),                  RoutingHeader."Version Nos.",                  NoSeriesRec.TableCaption(),                  MaxStrLen(RtngVersion."Version Code"));            RtngVersion."Version Code" := VersionCode;            Rec := RtngVersion;            exit(true);        end;    end;    procedure Caption(): Text    var        RtngHeader: Record "Routing Header";    begin        if GetFilters = '' then            exit('');        if "Routing No." = '' then            exit('');        RtngHeader.Get("Routing No.");        exit(          StrSubstNo(            '%1 %2 %3', RtngHeader."No.", RtngHeader.Description, "Version Code"));    end;    procedure RoutingLinesExist(): Boolean    var        RoutingLine: Record "Routing Line";    begin        RoutingLine.SetRange("Routing No.", Rec."Routing No.");        RoutingLine.SetRange("Version Code", Rec."Version Code");        exit(not RoutingLine.IsEmpty());    end;    [IntegrationEvent(false, false)]    local procedure OnValidateStatusBeforeCommit(var RoutingVersion: Record "Routing Version"; var SkipCommit: Boolean)    begin    end;}