Table 956 "Time Sheet Detail Archive"

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

Properties

Property	Value
Caption	Time Sheet Detail 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	Time Sheet Line No.	Integer	—
3	Date	Date	—
4	Type	Enum “Time Sheet Line Type”	—	enum Enum 952 “Time Sheet Line Type”
5	Resource No.	Code[20]	—	TableRelation Table 156 “Resource”
6	Job No. Δ BC24	Code[20]	Project No. caption	TableRelation Table 167 “Job”
7	Job Task No. Δ BC24	Code[20]	Project Task No. caption	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
9	Cause of Absence Code	Code[10]	—	TableRelation Table 5206 “Cause of Absence” (Cause of Absence)
15	Quantity Δ BC28	Decimal	—	not editable
16	Posted Quantity Δ BC28	Decimal	—
18	Assembly Order No.	Code[20]	—	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	Enum “Time Sheet Status”	—	enum Enum 950 “Time Sheet Status”
23	Posted	Boolean	—
24	Document No.	Code[20]	—
25	Posting Date	Date	—

Keys

Key1: Time Sheet No., Time Sheet Line No., Date (clustered)
Key2: Type, Job No., Job Task No., Status, Posted

Relations

Job Task No.: TableRelation Table 1001 “Job Task”
Resource No.: TableRelation Table 156 “Resource”
Job No.: TableRelation Table 167 “Job”
Cause of Absence Code: TableRelation Table 5206 “Cause of Absence”
Assembly Order No.: TableRelation Table 900 “Assembly Header”
Time Sheet No.: TableRelation Table 954 “Time Sheet Header Archive”

Referenced by

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

Table 954 “Time Sheet Header Archive”: Quantity
Table 955 “Time Sheet Line Archive”: Total Quantity

Extended by

Table extension 6463 “Serv. Time Sheet Detail 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 Detail Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.