Table 5416 Prod. Order Comp. Cmt Line

Base Application, Microsoft.Manufacturing.Document

src/Layers/W1/BaseApp/Manufacturing/Document/ProdOrderCompCmtLine.Table.al145 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.Document;using Microsoft.Manufacturing.ProductionBOM;table 5416 "Prod. Order Comp. Cmt Line"{    Caption = 'Prod. Order Comp. Cmt Line';    DrillDownPageID = "Prod. Order BOM Cmt List";    LookupPageID = "Prod. Order BOM Cmt List";    DataClassification = CustomerContent;    fields    {        field(2; "Prod. Order BOM Line No."; Integer)        {            Caption = 'Prod. Order BOM Line No.';            NotBlank = true;            TableRelation = "Prod. Order Component"."Line No." where(Status = field(Status),                                                                      "Prod. Order No." = field("Prod. Order No."),                                                                      "Prod. Order Line No." = field("Prod. Order Line No."));        }        field(3; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(10; Date; Date)        {            Caption = 'Date';            ToolTip = 'Specifies the date.';        }        field(12; Comment; Text[80])        {            Caption = 'Comment';            ToolTip = 'Specifies the actual comment text.';        }        field(13; "Code"; Code[10])        {            Caption = 'Code';            ToolTip = 'Specifies a code for the comments.';        }        field(22; Status; Enum "Production Order Status")        {            Caption = 'Status';        }        field(23; "Prod. Order No."; Code[20])        {            Caption = 'Prod. Order No.';            NotBlank = true;            TableRelation = "Production Order"."No." where(Status = field(Status));        }        field(24; "Prod. Order Line No."; Integer)        {            Caption = 'Prod. Order Line No.';            NotBlank = true;            TableRelation = "Prod. Order Line"."Line No." where(Status = field(Status),                                                                 "Prod. Order No." = field("Prod. Order No."));        }    }    keys    {        key(Key1; Status, "Prod. Order No.", "Prod. Order Line No.", "Prod. Order BOM Line No.", "Line No.")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    begin        if Status = Status::Finished then            Error(Text000, Status, TableCaption);    end;    trigger OnInsert()    begin        if Status = Status::Finished then            Error(Text000, Status, TableCaption);    end;    trigger OnModify()    begin        if Status = Status::Finished then            Error(Text000, Status, TableCaption);    end;    var#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'A %1 %2 cannot be inserted, modified, or deleted.';#pragma warning restore AA0470#pragma warning restore AA0074    procedure SetupNewLine()    var        ProdOrderBOMComment: Record "Prod. Order Comp. Cmt Line";    begin        ProdOrderBOMComment.SetRange(Status, Status);        ProdOrderBOMComment.SetRange("Prod. Order No.", "Prod. Order No.");        ProdOrderBOMComment.SetRange("Prod. Order Line No.", "Prod. Order Line No.");        ProdOrderBOMComment.SetRange(          "Prod. Order BOM Line No.", "Prod. Order BOM Line No.");        ProdOrderBOMComment.SetRange(Date, WorkDate());        if not ProdOrderBOMComment.FindFirst() then            Date := WorkDate();    end;    procedure Caption(): Text    var        ProdOrder: Record "Production Order";        ProdOrderComp: Record "Prod. Order Component";    begin        if GetFilters = '' then            exit('');        if not ProdOrder.Get(Status, "Prod. Order No.") then            exit('');        if not ProdOrderComp.Get(Status, "Prod. Order No.", "Prod. Order Line No.", "Prod. Order BOM Line No.") then            Clear(ProdOrderComp);        exit(          StrSubstNo('%1 %2 %3 %4 %5',            Status, "Prod. Order No.", ProdOrder.Description, ProdOrderComp."Item No.", ProdOrderComp.Description));    end;    [Scope('OnPrem')]    procedure CopyFromProdBOMComponent(ProductionBOMCommentLine: Record "Production BOM Comment Line"; ProdOrderComponent: Record "Prod. Order Component")    begin        TransferFields(ProductionBOMCommentLine);        Status := ProdOrderComponent.Status;        "Prod. Order No." := ProdOrderComponent."Prod. Order No.";        "Prod. Order Line No." := ProdOrderComponent."Prod. Order Line No.";        "Prod. Order BOM Line No." := ProdOrderComponent."Line No.";    end;}