Time Sheet Line Archive #955

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

26
Fields
0
Records
2
Primary key
2
FlowFields
9
Relations
Open in Data Explorer →

Primary key

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

All fields (26)

Time Sheet Line Archive — FIELDS
NO.FIELDTYPECLASSRELATION
1 Time Sheet No. PK Code Normal → Time Sheet Header Archive #954
2 Line No. PK Integer Normal
3 Time Sheet Starting Date Date Normal
5 Type Option Normal
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
10 Description Text Normal
11 Work Type Code Code Normal → Work Type #200
12 Approver ID Code Normal → User Setup #91
13 Service Order No. Code Normal
14 Service Order Line No. Integer Normal
15 Total Quantity ⚡ FLOW Decimal FlowField
17 Chargeable Boolean Normal
18 Assembly Order No. Code Normal
19 Assembly Order Line No. Integer Normal
20 Status Option Normal
21 Approved By Code Normal → User Setup #91
22 Approval Date Date Normal
23 Posted Boolean Normal
26 Comment ⚡ FLOW Boolean FlowField
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 (7)

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

Time Sheet Header Archive
#954 · Other · via Time Sheet No.
Job
#167 · Other · via Project No.
Job Task
#1001 · Jobs · via Project Task No.
Cause of Absence
#5206 · Human Resources · via Cause of Absence Code
Work Type
#200 · Other · via Work Type Code
User Setup
#91 · Other · via Approver ID, Approved By