Service Shipment Item Line #5989

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

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

Primary key

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

All fields (57)

Service Shipment Item Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal → Service Shipment Header #5990
2 Line No. PK Integer Normal
3 Service Item No. Code Normal → Service Item #5940
4 Service Item Group Code Code Normal → Service Item Group #5904
5 Item No. Code Normal → Item #27
6 Serial No. Code Normal
7 Description Text Normal
8 Description 2 Text Normal
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
39 Accessory Comment ⚡ FLOW Boolean FlowField
40 Variant Code Code Normal → Item Variant #5401
42 Actual Response Time (Hours) Decimal Normal
44 Service 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
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
95 Resource Group Filter Code FlowFilter → Resource Group #152
97 Responsibility Center Code Normal → Responsibility Center #5714
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 Shipment Item Line table through TableRelation properties.

Service Shipment Header
#5990 · Service · via No.
Service Item
#5940 · Service · via Service Item No.
Service Item Group
#5904 · Service · via Service Item Group Code
Item
#27 · Inventory · via Item No.
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
Item Variant
#5401 · Other · via Variant Code
Service Price Adjustment Group
#6082 · Other · via Service Price Adjmt. Gr. Code
Ship-to Address
#222 · Other · via Ship-to Code
Customer
#18 · Sales · via Customer No.
Resource
#156 · Other · via Resource Filter
Resource Group
#152 · Other · via Resource Group Filter
Responsibility Center
#5714 · Other · via Responsibility Center
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID