Table 5414 Prod. Order Comment Line, source in 29
Source29
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;
}