Table 6013 Service Comment Line Archive

Base Application, Microsoft.Service.Archive

src/Layers/W1/BaseApp/Service/Archive/ServiceCommentLineArchive.Table.al77 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.Service.Archive;using Microsoft.Service.Comment;using Microsoft.Service.Contract;table 6013 "Service Comment Line Archive"{    Caption = 'Service Comment Line Archive';    DataCaptionFields = Type, "No.", "Doc. No. Occurrence", "Version No.";    DrillDownPageID = "Service Archive Comment Sheet";    LookupPageID = "Service Archive Comment Sheet";    DataClassification = CustomerContent;    fields    {        field(1; Type; Enum "Service Comment Line Type")        {            Caption = 'Type';        }        field(2; "No."; Code[20])        {            Caption = 'No.';            NotBlank = true;            TableRelation = if ("Table Name" = const("Service Contract")) "Service Contract Header"."Contract No."            else            if ("Table Name" = const("Service Header")) "Service Header Archive"."No." where("Document Type" = field("Table Subtype"),                                                                                             "Doc. No. Occurrence" = field("Doc. No. Occurrence"),                                                                                             "Version No." = field("Version No."));        }        field(3; "Table Line No."; Integer)        {            Caption = 'Table Line No.';        }        field(4; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(6; Comment; Text[80])        {            Caption = 'Comment';            ToolTip = 'Specifies the service comment.';        }        field(7; "Comment Date"; Date)        {            Caption = 'Comment Date';            ToolTip = 'Specifies the date when the comment was entered.';        }        field(8; "Table Subtype"; Enum "Service Comment Table Subtype")        {            Caption = 'Table Subtype';        }        field(9; "Table Name"; Enum "Service Comment Table Name")        {            Caption = 'Table Name';        }        field(10; "Doc. No. Occurrence"; Integer)        {            Caption = 'Doc. No. Occurrence';        }        field(11; "Version No."; Integer)        {            Caption = 'Version No.';        }    }    keys    {        key(Key1; "Table Name", "Table Subtype", "No.", Type, "Doc. No. Occurrence", "Version No.", "Table Line No.", "Line No.")        {            Clustered = true;        }    }}