Other table in Microsoft Dynamics 365 Business Central. 24 fields, 0 records in Cronus demo.
The Service Order Allocat. Archive table (ID 6014) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 24 fields, with a primary key of Entry No., Document No., Document Type, Version No., Doc. No. Occurrence. 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: Entry No., Document No., Document Type, Version No., Doc. No. Occurrence.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Entry No. PK | Integer | Normal | |
| 2 | Status | Option | Normal | |
| 3 | Document No. PK | Code | Normal | |
| 4 | Allocation Date | Date | Normal | |
| 5 | Resource No. | Code | Normal | → Resource #156 |
| 6 | Resource Group No. | Code | Normal | → Resource Group #152 |
| 7 | Service Item Line No. | Integer | Normal | → Service Item Line Archive #6011 |
| 8 | Allocated Hours | Decimal | Normal | |
| 9 | Starting Time | Time | Normal | |
| 10 | Finishing Time | Time | Normal | |
| 11 | Description | Text | Normal | |
| 12 | Reason Code | Code | Normal | → Reason Code #231 |
| 13 | Service Item No. | Code | Normal | → Service Item #5940 |
| 14 | Posted | Boolean | Normal | |
| 16 | Service Item Serial No. | Code | Normal | |
| 18 | Service Started | Boolean | Normal | |
| 19 | Document Type PK | Option | Normal | |
| 5047 | Version No. PK | Integer | Normal | |
| 5048 | Doc. No. Occurrence PK | Integer | 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 Service Order Allocat. Archive table through TableRelation properties.