Time Sheet Detail #952

Other table in Microsoft Dynamics 365 Business Central. 24 fields, 0 records in Cronus demo.

24
Fields
0
Records
3
Primary key
0
FlowFields
8
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Time Sheet No., Time Sheet Line No., Date.

All fields (24)

Time Sheet Detail — FIELDS
NO.FIELDTYPECLASSRELATION
1 Time Sheet No. PK Code Normal → Time Sheet Header #950
2 Time Sheet Line No. PK Integer Normal
3 Date PK Date Normal
4 Type Option Normal
5 Resource No. Code Normal → Resource #156
6 Project No. Code Normal → Job #167
7 Project Task No. Code Normal → Job Task #1001
9 Cause of Absence Code Code Normal → Cause of Absence #5206
13 Service Order No. Code Normal
14 Service Order Line No. Integer Normal
15 Quantity Decimal Normal
16 Posted Quantity Decimal Normal
18 Assembly Order No. Code Normal
19 Assembly Order Line No. Integer Normal
20 Status Option Normal
23 Posted Boolean Normal
480 Dimension Set ID Integer Normal
8001 Last Modified DateTime DateTime Normal
8002 Project Id GUID Normal → Job #167
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (6)

Tables referenced by fields on the Time Sheet Detail table through TableRelation properties.

Time Sheet Header
#950 · Other · via Time Sheet No.
Resource
#156 · Other · via Resource No.
Job
#167 · Other · via Project No., Project Id
Job Task
#1001 · Jobs · via Project Task No.
Cause of Absence
#5206 · Human Resources · via Cause of Absence Code