Other table in Microsoft Dynamics 365 Business Central. 23 fields, 0 records in Cronus demo.
The Time Sheet Detail Archive table (ID 956) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 23 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 Archive #954 |
| 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 | |
| 24 | Document No. | Code | Normal | |
| 25 | Posting Date | Date | Normal | |
| 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 Archive table through TableRelation properties.