Table 952 "Time Sheet Detail"

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

Properties

Property	Value
Caption	Time Sheet Detail
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 950 “Time Sheet Header” (Time Sheet Header)
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	—
480	Dimension Set ID	Integer	—	not editable; DataClassification SystemMetadata
8001	Last Modified DateTime	DateTime	—
8002	Job Id Δ BC24	Guid	Project Id caption	TableRelation Job.SystemId; DataClassification SystemMetadata

Keys

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

Events published

OnAfterCopyFromTimeSheetLine(var TimeSheetDetail: Record "Time Sheet Detail"; TimeSheetLine: Record "Time Sheet Line") (integration)
- subscribers: Codeunit 6451 “Serv. Time Sheet Mgt.” OnAfterCopyFromTimeSheetLine

Procedures

CopyFromTimeSheetLine(TimeSheetLine: Record "Time Sheet Line")
SetDimension()
GetMaxQtyToPost(): Decimal

Plus 1 local procedures.

Triggers

OnInsert, OnModify, OnRename

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 950 “Time Sheet Header”

Referenced by

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

Table 950 “Time Sheet Header”: Quantity, Quantity Approved, Quantity Open, Quantity Rejected, Quantity Submitted
Table 207 “Res. Journal Line”: Time Sheet Date
Table 210 “Job Journal Line”: Time Sheet Date
Table 5902 “Service Line”: Time Sheet Date
Table 5991 “Service Shipment Line”: Time Sheet Date
Table 6012 “Service Line Archive”: Time Sheet Date
Table 951 “Time Sheet Line”: Total Quantity

Extended by

Table extension 6462 “Serv. Time Sheet Detail”

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” (2 calls: OnInsert → CheckAccPeriod, OnModify → CheckAccPeriod)

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 Detail"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.