Other table in Microsoft Dynamics 365 Business Central. 23 fields, 0 records in Cronus demo.
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.