Service Item #5940

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

The Service Item table (ID 5940) is part of the Service area in Microsoft Dynamics 365 Business Central. It contains 87 fields, with a primary key of No., and includes 39 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (87)

Service Item — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	No. PK	Code	Normal
2	Serial No.	Code	Normal
3	Service Item Group Code	Code	Normal	→ Service Item Group #5904
4	Description	Text	Normal
5	Description 2	Text	Normal
6	Status	Option	Normal
7	Priority	Option	Normal
8	Customer No.	Code	Normal	→ Customer #18
9	Ship-to Code	Code	Normal	→ Ship-to Address #222
10	Item No.	Code	Normal	→ Item #27
11	Unit of Measure Code	Code	Normal
12	Location of Service Item	Text	Normal
13	Sales Unit Price	Decimal	Normal
14	Sales Unit Cost	Decimal	Normal
15	Warranty Starting Date (Labor)	Date	Normal
16	Warranty Ending Date (Labor)	Date	Normal
17	Warranty Starting Date (Parts)	Date	Normal
18	Warranty Ending Date (Parts)	Date	Normal
19	Warranty % (Parts)	Decimal	Normal
20	Warranty % (Labor)	Decimal	Normal
21	Response Time (Hours)	Decimal	Normal
22	Installation Date	Date	Normal
23	Sales Date	Date	Normal
24	Last Service Date	Date	Normal
25	Default Contract Value	Decimal	Normal
26	Default Contract Discount %	Decimal	Normal
28	No. of Active Contracts ⚡ FLOW	Integer	FlowField
33	Vendor No.	Code	Normal	→ Vendor #23
34	Vendor Item No.	Code	Normal
40	Blocked	Option	Normal
47	No. Series	Code	Normal	→ No. Series #308
48	Item Description ⚡ FLOW	Text	FlowField
49	Name ⚡ FLOW	Text	FlowField
50	Address ⚡ FLOW	Text	FlowField
51	Address 2 ⚡ FLOW	Text	FlowField
52	Post Code ⚡ FLOW	Code	FlowField
53	City ⚡ FLOW	Text	FlowField	→ Post Code #225
54	Contact ⚡ FLOW	Text	FlowField
55	Phone No. ⚡ FLOW	Text	FlowField
56	Ship-to Name ⚡ FLOW	Text	FlowField
57	Ship-to Address ⚡ FLOW	Text	FlowField
58	Ship-to Address 2 ⚡ FLOW	Text	FlowField
59	Ship-to Post Code ⚡ FLOW	Code	FlowField
60	Ship-to City ⚡ FLOW	Text	FlowField	→ Post Code #225
61	Ship-to Contact ⚡ FLOW	Text	FlowField
62	Ship-to Phone No. ⚡ FLOW	Text	FlowField
63	Usage (Cost) ⚡ FLOW	Decimal	FlowField
64	Usage (Amount) ⚡ FLOW	Decimal	FlowField
65	Invoiced Amount ⚡ FLOW	Decimal	FlowField
66	Total Quantity ⚡ FLOW	Decimal	FlowField
67	Total Qty. Invoiced ⚡ FLOW	Decimal	FlowField
68	Resources Used ⚡ FLOW	Decimal	FlowField
69	Parts Used ⚡ FLOW	Decimal	FlowField
70	Cost Used ⚡ FLOW	Decimal	FlowField
71	Vendor Name ⚡ FLOW	Text	FlowField
72	Vendor Item Name	Text	Normal
73	Comment ⚡ FLOW	Boolean	FlowField
74	Service Item Components ⚡ FLOW	Boolean	FlowField
75	Preferred Resource	Code	Normal	→ Resource #156
76	Variant Code	Code	Normal	→ Item Variant #5401
77	County ⚡ FLOW	Text	FlowField
78	Ship-to County ⚡ FLOW	Text	FlowField
79	Contract Cost ⚡ FLOW	Decimal	FlowField
81	Country/Region Code ⚡ FLOW	Code	FlowField
82	Ship-to Country/Region Code ⚡ FLOW	Code	FlowField
83	Name 2 ⚡ FLOW	Text	FlowField
84	Ship-to Name 2 ⚡ FLOW	Text	FlowField
85	Service Price Group Code	Code	Normal	→ Service Price Group #6080
86	Default Contract Cost	Decimal	Normal
87	Prepaid Amount ⚡ FLOW	Decimal	FlowField
88	Search Description	Code	Normal
89	Service Contracts ⚡ FLOW	Boolean	FlowField
90	Total Qty. Consumed ⚡ FLOW	Decimal	FlowField
100	Date Filter	Date	FlowFilter
101	Type Filter	Option	FlowFilter
102	Contract Filter	Code	FlowFilter	→ Service Contract Header #5965
103	Service Order Filter	Code	FlowFilter	→ Service Header #5900
104	Sales/Serv. Shpt. Document No.	Code	Normal
105	Sales/Serv. Shpt. Line No.	Integer	Normal
106	Shipment Type	Option	Normal
211	Ship-to Email ⚡ FLOW	Text	FlowField
721	Coupled to Dynamics 365 Sales ⚡ FLOW	Boolean	FlowField
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