Other table in Microsoft Dynamics 365 Business Central. 24 fields, 0 records in Cronus demo.
The Time Sheet Detail table (ID 952) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 24 fields, with a primary key of Time Sheet No., Time Sheet Line No., Date. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Time Sheet No., Time Sheet Line No., Date.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Time Sheet Detail table through TableRelation properties.