Table 955 Time Sheet Line Archive
src/Layers/W1/BaseApp/Projects/TimeSheet/TimeSheetLineArchive.Table.al177 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.Projects.TimeSheet;using Microsoft.Assembly.Document;using Microsoft.HumanResources.Absence;using Microsoft.Projects.Project.Job;using Microsoft.Utilities;using System.Security.User;table 955 "Time Sheet Line Archive"{ Caption = 'Time Sheet Line Archive'; DataClassification = CustomerContent; fields { field(1; "Time Sheet No."; Code[20]) { Caption = 'Time Sheet No.'; TableRelation = "Time Sheet Header Archive"; } field(2; "Line No."; Integer) { Caption = 'Line No.'; } field(3; "Time Sheet Starting Date"; Date) { Caption = 'Time Sheet Starting Date'; Editable = false; } field(5; Type; Enum "Time Sheet Line Type") { Caption = 'Type'; ToolTip = 'Specifies information about the type of resource that the time sheet line applies to.'; } field(6; "Job No."; Code[20]) { Caption = 'Project No.'; ToolTip = 'Specifies the number for the project that is associated with the time sheet line.'; TableRelation = Job; } field(7; "Job Task No."; Code[20]) { Caption = 'Project Task No.'; ToolTip = 'Specifies the number of the related project task.'; TableRelation = "Job Task"."Job Task No." where("Job No." = field("Job No.")); } field(9; "Cause of Absence Code"; Code[10]) { Caption = 'Cause of Absence Code'; ToolTip = 'Specifies the codes that you can use to describe the type of absence from work.'; TableRelation = "Cause of Absence"; } field(10; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies a description of the archived time sheet line.'; } field(11; "Work Type Code"; Code[10]) { Caption = 'Work Type Code'; ToolTip = 'Specifies which work type the resource applies to. Prices are updated based on this entry.'; TableRelation = "Work Type"; } field(12; "Approver ID"; Code[50]) { Caption = 'Approver ID'; DataClassification = EndUserIdentifiableInformation; Editable = false; TableRelation = "User Setup"; } field(13; "Service Order No."; Code[20]) { Caption = 'Service Order No.'; } field(15; "Total Quantity"; Decimal) { AutoFormatType = 0; CalcFormula = sum("Time Sheet Detail Archive".Quantity where("Time Sheet No." = field("Time Sheet No."), "Time Sheet Line No." = field("Line No."))); Caption = 'Total Quantity'; ToolTip = 'Specifies the total number of hours that have been entered on an archived time sheet.'; Editable = false; FieldClass = FlowField; } field(17; Chargeable; Boolean) { Caption = 'Chargeable'; ToolTip = 'Specifies whether the time associated with an archived time sheet is chargeable.'; InitValue = true; } field(18; "Assembly Order No."; Code[20]) { Caption = 'Assembly Order No.'; ToolTip = 'Specifies the assembly order number that is associated with the time sheet line.'; TableRelation = if (Posted = const(false)) "Assembly Header"."No." where("Document Type" = const(Order)); } field(19; "Assembly Order Line No."; Integer) { Caption = 'Assembly Order Line No.'; } field(20; Status; Enum "Time Sheet Status") { Caption = 'Status'; ToolTip = 'Specifies information about the status of an archived time sheet.'; Editable = false; } field(21; "Approved By"; Code[50]) { Caption = 'Approved By'; DataClassification = EndUserIdentifiableInformation; Editable = false; TableRelation = "User Setup"; } field(22; "Approval Date"; Date) { Caption = 'Approval Date'; Editable = false; } field(23; Posted; Boolean) { Caption = 'Posted'; Editable = false; } field(26; Comment; Boolean) { CalcFormula = exist("Time Sheet Comment Line" where("No." = field("Time Sheet No."), "Time Sheet Line No." = field("Line No."))); Caption = 'Comment'; Editable = false; FieldClass = FlowField; } } keys { key(Key1; "Time Sheet No.", "Line No.") { Clustered = true; } } fieldgroups { } trigger OnDelete() var TimeSheetDetailArchive: Record "Time Sheet Detail Archive"; TimeSheetCmtLineArchive: Record "Time Sheet Cmt. Line Archive"; begin TimeSheetDetailArchive.SetRange("Time Sheet No.", "Time Sheet No."); TimeSheetDetailArchive.SetRange("Time Sheet Line No.", "Line No."); TimeSheetDetailArchive.DeleteAll(); TimeSheetCmtLineArchive.SetRange("No.", "Time Sheet No."); TimeSheetCmtLineArchive.SetRange("Time Sheet Line No.", "Line No."); TimeSheetCmtLineArchive.DeleteAll(); end; procedure SetExclusionTypeFilter() begin SetFilter(Type, '<>%1', Type::"Assembly Order"); OnAfterSetExclusionTypeFilter(Rec); end; [IntegrationEvent(false, false)] local procedure OnAfterSetExclusionTypeFilter(var TimeSheetLineArchive: Record "Time Sheet Line Archive") begin end;}