Table 954 "Time Sheet Header Archive"

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

Properties

Property	Value
Caption	Time Sheet Header 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	No. Δ BC28	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.
3	Starting Date Δ BC28	Date	Specifies the start date for the archived time sheet.
4	Ending Date Δ BC28	Date	Specifies the end date for an archived time sheet.
5	Resource No. Δ BC28	Code[20]	Specifies the list of resource numbers associated with an archived time sheet.	TableRelation Table 156 “Resource”
7	Owner User ID	Code[50]	—	TableRelation Table 91 “User Setup” (User Setup); DataClassification EndUserIdentifiableInformation
8	Approver User ID Δ BC28	Code[50]	Specifies the ID of the time sheet approver.	TableRelation Table 91 “User Setup” (User Setup); DataClassification EndUserIdentifiableInformation
10	Description Δ BC28	Text[100]	Specifies the description for a time sheet.
11	Unit of Measure Δ BC24	Code[10]	—	FlowField: lookup(Resource.“Base Unit of Measure” where(“No.” = field(“Resource No.”))); not editable
20	Quantity Δ BC28	Decimal	—	FlowField: sum(“Time Sheet Detail Archive”.Quantity where(“Time Sheet No.” = field(“No.”), Status = field(“Status Filter”), “Job No.” = field(“Job No. Filter”), “Job Task No.” = field(“Job Task No. Filter”), Date = field(“Date Filter”), Posted = field(“Posted Filter”), Type = field(“Type Filter”)))
26	Comment	Boolean	—	FlowField: exist(“Time Sheet Comment Line” where(“No.” = field(“No.”), “Time Sheet Line No.” = const(0))); not editable
30	Status Filter	Enum “Time Sheet Status”	—	FlowFilter; enum Enum 950 “Time Sheet Status”
31	Job No. Filter Δ BC24	Code[20]	Project No. Filter caption	FlowFilter
32	Job Task No. Filter Δ BC24	Code[20]	Project Task No. Filter caption	FlowFilter
33	Date Filter	Date	—	FlowFilter
34	Posted Filter	Boolean	—	FlowFilter
35	Type Filter	Enum “Time Sheet Line Type”	—	FlowFilter; enum Enum 952 “Time Sheet Line Type”

Keys

Key1: No. (clustered)
Key2: Resource No., Starting Date

Procedures

FindLastTimeSheetArchiveNo(FilterFieldNo: Integer): Code[20]

Triggers

OnDelete

Relations

Resource No.: TableRelation Table 156 “Resource”
Approver User ID: TableRelation Table 91 “User Setup”
Owner User ID: TableRelation Table 91 “User Setup”
Comment: CalcFormula Table 953 “Time Sheet Comment Line”
Quantity: CalcFormula Table 956 “Time Sheet Detail Archive”

Referenced by

2 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 955 “Time Sheet Line Archive”: Time Sheet No.
Table 956 “Time Sheet Detail Archive”: Time Sheet No.

Pages and codeunits on this table

Page 960 “Time Sheet Archive List” (source table)
Page 962 “Manager Time Sheet Arc. List” (source table)
Page 975 “Time Sheet Archive Card” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 950 “Time Sheet Management” (1 call: FindLastTimeSheetArchiveNo → FilterTimeSheetsArchive)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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 Header Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.