Service Order Allocation #5950

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

24
Fields
0
Records
1
Primary key
2
FlowFields
6
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (24)

Service Order Allocation — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Status Option Normal
3 Document No. 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 #5901
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
14 Posted Boolean Normal
15 Service Item Description ⚡ FLOW Text FlowField
16 Service Item Serial No. Code Normal
17 Repair Status ⚡ FLOW Code FlowField
18 Service Started Boolean Normal
19 Document Type Option 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 (5)

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

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