Table 5942 Service Item Log
src/Layers/W1/BaseApp/Service/Item/ServiceItemLog.Table.al118 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.Item;using Microsoft.Service.Contract;using Microsoft.Service.Document;using System.Security.AccessControl;table 5942 "Service Item Log"{ Caption = 'Service Item Log'; DataCaptionFields = "Service Item No."; DrillDownPageID = "Service Item Log"; LookupPageID = "Service Item Log"; ReplicateData = true; DataClassification = CustomerContent; fields { field(1; "Service Item No."; Code[20]) { Caption = 'Service Item No.'; ToolTip = 'Specifies the number of the event associated with the service item.'; NotBlank = true; TableRelation = "Service Item"; } field(2; "Entry No."; Integer) { Caption = 'Entry No.'; ToolTip = 'Specifies the number of the entry, as assigned from the specified number series when the entry was created.'; } field(3; "Event No."; Integer) { Caption = 'Event No.'; } field(4; "Document No."; Code[20]) { Caption = 'Document No.'; ToolTip = 'Specifies the document number of the event associated with the service item.'; TableRelation = if ("Document Type" = const(Quote)) "Service Header"."No." where("Document Type" = const(Quote)) else if ("Document Type" = const(Order)) "Service Header"."No." where("Document Type" = const(Order)) else if ("Document Type" = const(Contract)) "Service Contract Header"."Contract No." where("Contract Type" = const(Contract)); } field(5; After; Text[50]) { Caption = 'After'; ToolTip = 'Specifies the value of the field modified after the event takes place.'; } field(6; Before; Text[50]) { Caption = 'Before'; ToolTip = 'Specifies the previous value of the field, modified after the event takes place.'; } field(7; "Change Date"; Date) { Caption = 'Change Date'; ToolTip = 'Specifies the date of the event.'; } field(8; "Change Time"; Time) { Caption = 'Change Time'; ToolTip = 'Specifies the time of the event.'; } field(9; "User ID"; Code[50]) { Caption = 'User ID'; ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } field(10; "Document Type"; Option) { Caption = 'Document Type'; ToolTip = 'Specifies the document type of the service item associated with the event, such as contract, order, or quote.'; OptionCaption = ' ,Quote,Order,Contract'; OptionMembers = " ",Quote,"Order",Contract; } } keys { key(Key1; "Service Item No.", "Entry No.") { Clustered = true; } key(Key2; "Change Date") { } } fieldgroups { } trigger OnInsert() begin ServItemLog.LockTable(); ServItemLog.Reset(); ServItemLog.SetRange("Service Item No.", "Service Item No."); if ServItemLog.FindLast() then "Entry No." := ServItemLog."Entry No." + 1 else "Entry No." := 1; "Change Date" := Today; "Change Time" := Time; "User ID" := CopyStr(UserId(), 1, MaxStrLen("User ID")); end; var ServItemLog: Record "Service Item Log";}