Table 5125 Purch. Comment Line Archive
src/Layers/W1/BaseApp/Purchases/Archive/PurchCommentLineArchive.Table.al86 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.Purchases.Archive;using Microsoft.Purchases.Comment;table 5125 "Purch. Comment Line Archive"{ Caption = 'Purch. Comment Line Archive'; DrillDownPageID = "Purch. Archive Comment Sheet"; LookupPageID = "Purch. Archive Comment Sheet"; DataClassification = CustomerContent; fields { field(1; "Document Type"; Enum "Purchase Comment Document Type") { Caption = 'Document Type'; } field(2; "No."; Code[20]) { Caption = 'No.'; } field(3; "Line No."; Integer) { Caption = 'Line No.'; } field(4; Date; Date) { Caption = 'Date'; ToolTip = 'Specifies the version number of the archived document.'; } field(5; "Code"; Code[10]) { Caption = 'Code'; ToolTip = 'Specifies the document line number of the quote or order to which the comment applies.'; } field(6; Comment; Text[80]) { Caption = 'Comment'; ToolTip = 'Specifies the line number for the comment.'; } field(7; "Document Line No."; Integer) { Caption = 'Document Line No.'; } field(8; "Doc. No. Occurrence"; Integer) { Caption = 'Doc. No. Occurrence'; } field(9; "Version No."; Integer) { Caption = 'Version No.'; } } keys { key(Key1; "Document Type", "No.", "Doc. No. Occurrence", "Version No.", "Document Line No.", "Line No.") { Clustered = true; } } fieldgroups { } procedure SetUpNewLine() var PurchCommentLine: Record "Purch. Comment Line Archive"; begin PurchCommentLine.SetRange("Document Type", "Document Type"); PurchCommentLine.SetRange("No.", "No."); PurchCommentLine.SetRange("Doc. No. Occurrence", "Doc. No. Occurrence"); PurchCommentLine.SetRange("Version No.", "Version No."); PurchCommentLine.SetRange("Document Line No.", "Line No."); PurchCommentLine.SetRange(Date, WorkDate()); if not PurchCommentLine.FindFirst() then Date := WorkDate(); end;}