Service Order Allocat. Archive #6014

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

24
Fields
0
Records
5
Primary key
0
FlowFields
7
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No., Document No., Document Type, Version No., Doc. No. Occurrence.

All fields (24)

Service Order Allocat. Archive — FIELDS
NO.FIELDTYPECLASSRELATION
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

Related tables (6)

Tables referenced by fields on the Service Order Allocat. Archive table through TableRelation properties.

Resource
#156 · Other · via Resource No.
Resource Group
#152 · Other · via Resource Group No.
Service Item Line Archive
#6011 · Other · via Service Item Line No.
Reason Code
#231 · Other · via Reason Code
Service Item
#5940 · Service · via Service Item No.