Table 955 "Time Sheet Line Archive"

Base Application · Microsoft.Projects.TimeSheet · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Time Sheet Line Archive
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Time Sheet No.	Code[20]	—	TableRelation Table 954 “Time Sheet Header Archive” (Time Sheet Header Archive)
2	Line No.	Integer	—
3	Time Sheet Starting Date	Date	—	not editable
5	Type Δ BC28	Enum “Time Sheet Line Type”	Specifies information about the type of resource that the time sheet line applies to.	enum Enum 952 “Time Sheet Line Type”
6	Job No. Δ BC24 Δ BC28	Code[20]	Specifies the number for the project that is associated with the time sheet line.	TableRelation Table 167 “Job”
7	Job Task No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the related project task.	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
9	Cause of Absence Code Δ BC28	Code[10]	Specifies the codes that you can use to describe the type of absence from work.	TableRelation Table 5206 “Cause of Absence” (Cause of Absence)
10	Description Δ BC28	Text[100]	Specifies a description of the archived time sheet line.
11	Work Type Code Δ BC28	Code[10]	Specifies which work type the resource applies to. Prices are updated based on this entry.	TableRelation Table 200 “Work Type” (Work Type)
12	Approver ID	Code[50]	—	TableRelation Table 91 “User Setup” (User Setup); not editable; DataClassification EndUserIdentifiableInformation
13	Service Order No. Δ BC25	Code[20]	Specifies the service order number that is associated with an archived time sheet line. via Page extension 6477 “Serv. Timesheet Archive”
15	Total Quantity Δ BC28	Decimal	Specifies the total number of hours that have been entered on an archived time sheet.	FlowField: sum(“Time Sheet Detail Archive”.Quantity where(“Time Sheet No.” = field(“Time Sheet No.”), “Time Sheet Line No.” = field(“Line No.”))); not editable
17	Chargeable Δ BC28	Boolean	Specifies whether the time associated with an archived time sheet is chargeable.
18	Assembly Order No. Δ BC28	Code[20]	Specifies the assembly order number that is associated with the time sheet line.	TableRelation Table 900 “Assembly Header” (if (Posted = const(false)) “Assembly Header”.“No.” where(“Document Type” = const(Order)))
19	Assembly Order Line No.	Integer	—
20	Status Δ BC28	Enum “Time Sheet Status”	Specifies information about the status of an archived time sheet.	enum Enum 950 “Time Sheet Status”; not editable
21	Approved By	Code[50]	—	TableRelation Table 91 “User Setup” (User Setup); not editable; DataClassification EndUserIdentifiableInformation
22	Approval Date	Date	—	not editable
23	Posted	Boolean	—	not editable
26	Comment	Boolean	—	FlowField: exist(“Time Sheet Comment Line” where(“No.” = field(“Time Sheet No.”), “Time Sheet Line No.” = field(“Line No.”))); not editable

Keys

Key1: Time Sheet No., Line No. (clustered)

Events published

OnAfterSetExclusionTypeFilter(var TimeSheetLineArchive: Record "Time Sheet Line Archive") + BC25 (integration)
- subscribers: Codeunit 6451 “Serv. Time Sheet Mgt.” TimeSheetLineArchiveOnAfterSetExclusionTypeFilter

Procedures

SetExclusionTypeFilter() + BC25

Triggers

OnDelete

Relations

Job Task No.: TableRelation Table 1001 “Job Task”
Job No.: TableRelation Table 167 “Job”
Work Type Code: TableRelation Table 200 “Work Type”
Cause of Absence Code: TableRelation Table 5206 “Cause of Absence”
Assembly Order No.: TableRelation Table 900 “Assembly Header”
Approved By: TableRelation Table 91 “User Setup”
Approver ID: TableRelation Table 91 “User Setup”
Comment: CalcFormula Table 953 “Time Sheet Comment Line”
Time Sheet No.: TableRelation Table 954 “Time Sheet Header Archive”
Total Quantity: CalcFormula Table 956 “Time Sheet Detail Archive”

Pages and codeunits on this table

Page 959 “Time Sheet Archive” (source table)
Page 961 “Manager Time Sheet Archive” (source table)
Page 976 “Time Sheet Archive Subform” (source table)

Extended by

Table extension 6465 “Serv. Time Sheet Line Arch.”

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Time Sheet Line Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.