Table 5883 Phys. Invt. Comment Line

Base Application, Microsoft.Inventory.Counting.Comment

src/Layers/W1/BaseApp/Inventory/Counting/Comment/PhysInvtCommentLine.Table.al104 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.Inventory.Counting.Comment;using Microsoft.Inventory.Counting.Document;using Microsoft.Inventory.Counting.History;using Microsoft.Inventory.Counting.Recording;table 5883 "Phys. Invt. Comment Line"{    Caption = 'Phys. Invt. Comment Line';    DrillDownPageID = "Phys. Inventory Comment List";    LookupPageID = "Phys. Inventory Comment List";    DataClassification = CustomerContent;    fields    {        field(1; "Document Type"; Option)        {            Caption = 'Document Type';            OptionCaption = 'Order,Recording,Posted Order,Posted Recording';            OptionMembers = "Order",Recording,"Posted Order","Posted Recording";        }        field(2; "Order No."; Code[20])        {            Caption = 'Order No.';            ToolTip = 'Specifies the document number of the physical inventory order to which the comment applies.';            TableRelation = if ("Document Type" = const(Order)) "Phys. Invt. Order Header"            else            if ("Document Type" = const(Recording)) "Phys. Invt. Record Header"."Order No."            else            if ("Document Type" = const("Posted Order")) "Pstd. Phys. Invt. Order Hdr"            else            if ("Document Type" = const("Posted Recording")) "Pstd. Phys. Invt. Record Hdr"."Order No.";        }        field(3; "Recording No."; Integer)        {            Caption = 'Recording No.';            ToolTip = 'Specifies the document number of the physical inventory recording to which the comment applies.';            TableRelation = if ("Document Type" = const(Recording)) "Phys. Invt. Record Header"."Recording No." where("Order No." = field("Order No."))            else            if ("Document Type" = const("Posted Recording")) "Pstd. Phys. Invt. Record Hdr"."Recording No." where("Order No." = field("Order No."));        }        field(4; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(10; Date; Date)        {            Caption = 'Date';            ToolTip = 'Specifies the date when the comment was created.';        }        field(11; "Code"; Code[10])        {            Caption = 'Code';            ToolTip = 'Specifies a code for the comment.';        }        field(12; Comment; Text[80])        {            Caption = 'Comment';            ToolTip = 'Specifies the comment itself.';        }    }    keys    {        key(Key1; "Document Type", "Order No.", "Recording No.", "Line No.")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnInsert()    begin        if "Document Type" in ["Document Type"::Order, "Document Type"::"Posted Order"] then            TestField("Recording No.", 0);    end;    procedure SetUpNewLine()    var        PhysInvtCommentLine: Record "Phys. Invt. Comment Line";    begin        PhysInvtCommentLine.SetRange("Document Type", "Document Type");        PhysInvtCommentLine.SetRange("Order No.", "Order No.");        PhysInvtCommentLine.SetRange("Recording No.", "Recording No.");        if not PhysInvtCommentLine.FindFirst() then            Date := WorkDate();        OnAfterSetUpNewLine(Rec, PhysInvtCommentLine);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetUpNewLine(var PhysInvtCommentLineRec: Record "Phys. Invt. Comment Line"; var PhysInvtCommentLineFilter: Record "Phys. Invt. Comment Line")    begin    end;}