Table 5414 Prod. Order Comment Line
src/Layers/W1/BaseApp/Manufacturing/Document/ProdOrderCommentLine.Table.al117 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;table 5414 "Prod. Order Comment Line"{ Caption = 'Prod. Order Comment Line'; DrillDownPageID = "Prod. Order Comment List"; LookupPageID = "Prod. Order Comment List"; DataClassification = CustomerContent; fields { field(1; Status; Enum "Production Order Status") { Caption = 'Status'; } field(2; "Prod. Order No."; Code[20]) { Caption = 'Prod. Order No.'; ToolTip = 'Specifies the number of the related production order.'; NotBlank = true; TableRelation = "Production Order"."No." where(Status = field(Status)); } field(3; "Line No."; Integer) { Caption = 'Line No.'; } field(4; Date; Date) { Caption = 'Date'; ToolTip = 'Specifies a date.'; } field(5; "Code"; Code[10]) { Caption = 'Code'; ToolTip = 'Specifies a code for the comment.'; } field(6; Comment; Text[80]) { Caption = 'Comment'; ToolTip = 'Specifies the comment.'; } } keys { key(Key1; Status, "Prod. Order No.", "Line No.") { Clustered = true; } } fieldgroups { } trigger OnDelete() begin CheckFinishedOrder(); end; trigger OnInsert() begin CheckFinishedOrder(); end; trigger OnModify() begin CheckFinishedOrder(); 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 ProdOrderCommentLine: Record "Prod. Order Comment Line"; begin ProdOrderCommentLine.SetRange(Status, Status); ProdOrderCommentLine.SetRange("Prod. Order No.", "Prod. Order No."); ProdOrderCommentLine.SetRange(Date, WorkDate()); if not ProdOrderCommentLine.FindFirst() then Date := WorkDate(); OnAfterSetUpNewLine(Rec, ProdOrderCommentLine); end; local procedure CheckFinishedOrder() var IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckFinishedOrder(Rec, IsHandled); if not IsHandled then if Status = Status::Finished then Error(Text000, Status, TableCaption); end; [IntegrationEvent(false, false)] local procedure OnAfterSetUpNewLine(var ProdOrderCommentLineRec: Record "Prod. Order Comment Line"; var ProdOrderCommentLineFilter: Record "Prod. Order Comment Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckFinishedOrder(ProdOrderCommentLine: Record "Prod. Order Comment Line"; var IsHandled: Boolean) begin end;}