Service Item Line #5901

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

68
Fields
0
Records
3
Primary key
7
FlowFields
27
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Document No., Line No., Document Type.

All fields (68)

Service Item Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document No. PK Code Normal → Service Header #5900
2 Line No. PK Integer Normal
3 Service Item No. Code Normal
4 Service Item Group Code Code Normal → Service Item Group #5904
5 Item No. Code Normal
6 Serial No. Code Normal
7 Description Text Normal
8 Description 2 Text Normal
9 Repair Status Code Code Normal → Repair Status #5927
10 Priority Option Normal
11 Response Time (Hours) Decimal Normal
12 Response Date Date Normal
13 Response Time Time Normal
14 Starting Date Date Normal
15 Starting Time Time Normal
16 Finishing Date Date Normal
17 Finishing Time Time Normal
18 Service Shelf No. Code Normal → Service Shelf #5929
19 Warranty Starting Date (Parts) Date Normal
20 Warranty Ending Date (Parts) Date Normal
21 Warranty Boolean Normal
22 Warranty % (Parts) Decimal Normal
23 Warranty % (Labor) Decimal Normal
24 Warranty Starting Date (Labor) Date Normal
25 Warranty Ending Date (Labor) Date Normal
26 Contract No. Code Normal → Service Contract Header #5965
27 Location of Service Item ⚡ FLOW Text FlowField
28 Loaner No. Code Normal → Loaner #5913
29 Vendor No. Code Normal → Vendor #23
30 Vendor Item No. Text Normal
31 Fault Reason Code Code Normal → Fault Reason Code #5917
32 Service Price Group Code Code Normal → Service Price Group #6080
33 Fault Area Code Code Normal → Fault Area #5915
34 Symptom Code Code Normal → Symptom Code #5916
35 Fault Code Code Normal → Fault Code #5918
36 Resolution Code Code Normal → Resolution Code #5919
37 Fault Comment ⚡ FLOW Boolean FlowField
38 Resolution Comment ⚡ FLOW Boolean FlowField
40 Variant Code Code Normal
41 Service Item Loaner Comment ⚡ FLOW Boolean FlowField
42 Actual Response Time (Hours) Decimal Normal
43 Document Type PK Option Normal
44 Serv. Price Adjmt. Gr. Code Code Normal → Service Price Adjustment Group #6082
45 Adjustment Type Option Normal
46 Base Amount to Adjust Decimal Normal
60 No. of Active/Finished Allocs ⚡ FLOW Integer FlowField
61 No. of Allocations ⚡ FLOW Integer FlowField
62 No. of Previous Services ⚡ FLOW Integer FlowField
63 Contract Line No. Integer Normal → Service Contract Line #5964
64 Ship-to Code Code Normal → Ship-to Address #222
65 Customer No. Code Normal → Customer #18
91 Date Filter Date FlowFilter
92 Resource Filter Code FlowFilter → Resource #156
93 Allocation Date Filter Date FlowFilter
94 Repair Status Code Filter Code FlowFilter → Repair Status #5927
96 Allocation Status Filter Option FlowFilter
97 Responsibility Center Code Normal → Responsibility Center #5714
98 Service Order Filter Code FlowFilter → Service Header #5900
99 Resource Group Filter Code FlowFilter → Resource Group #152
100 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
101 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
130 Release Status Option Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
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 (23)

Tables referenced by fields on the Service Item Line table through TableRelation properties.

Service Header
#5900 · Service · via Document No., Service Order Filter
Service Item Group
#5904 · Service · via Service Item Group Code
Repair Status
#5927 · Service · via Repair Status Code, Repair Status Code Filter
Service Shelf
#5929 · Service · via Service Shelf No.
Service Contract Header
#5965 · Service · via Contract No.
Loaner
#5913 · Service · via Loaner No.
Vendor
#23 · Purchasing · via Vendor No.
Fault Reason Code
#5917 · Service · via Fault Reason Code
Service Price Group
#6080 · Other · via Service Price Group Code
Fault Area
#5915 · Service · via Fault Area Code
Symptom Code
#5916 · Service · via Symptom Code
Fault Code
#5918 · Service · via Fault Code
Resolution Code
#5919 · Service · via Resolution Code
Service Price Adjustment Group
#6082 · Other · via Serv. Price Adjmt. Gr. Code
Service Contract Line
#5964 · Service · via Contract Line No.
Ship-to Address
#222 · Other · via Ship-to Code
Customer
#18 · Sales · via Customer No.
Resource
#156 · Other · via Resource Filter
Responsibility Center
#5714 · Other · via Responsibility Center
Resource Group
#152 · Other · via Resource Group Filter
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID