Service Contract Header #5965

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

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

111

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: Contract No., Contract Type.

All fields (111)

Service Contract Header — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Contract No. PK	Code	Normal
2	Contract Type PK	Option	Normal
3	Description	Text	Normal
4	Description 2	Text	Normal
5	Status	Option	Normal
6	Change Status	Option	Normal
7	Customer No.	Code	Normal	→ Customer #18
8	Name ⚡ FLOW	Text	FlowField
9	Address ⚡ FLOW	Text	FlowField
10	Address 2 ⚡ FLOW	Text	FlowField
11	Post Code ⚡ FLOW	Code	FlowField
12	City ⚡ FLOW	Text	FlowField
13	Contact Name	Text	Normal
14	Your Reference	Text	Normal
15	Salesperson Code	Code	Normal	→ Salesperson/Purchaser #13
16	Bill-to Customer No.	Code	Normal	→ Customer #18
17	Bill-to Name ⚡ FLOW	Text	FlowField
18	Bill-to Address ⚡ FLOW	Text	FlowField
19	Bill-to Address 2 ⚡ FLOW	Text	FlowField
20	Bill-to Post Code ⚡ FLOW	Code	FlowField
21	Bill-to City ⚡ FLOW	Text	FlowField
22	Ship-to Code	Code	Normal	→ Ship-to Address #222
23	Ship-to Name ⚡ FLOW	Text	FlowField
24	Ship-to Address ⚡ FLOW	Text	FlowField
25	Ship-to Address 2 ⚡ FLOW	Text	FlowField
26	Ship-to Post Code ⚡ FLOW	Code	FlowField
27	Ship-to City ⚡ FLOW	Text	FlowField
28	Serv. Contract Acc. Gr. Code	Code	Normal	→ Service Contract Account Group #5973
32	Invoice Period	Option	Normal
33	Last Invoice Date	Date	Normal
34	Next Invoice Date	Date	Normal
35	Starting Date	Date	Normal
36	Expiration Date	Date	Normal
38	First Service Date	Date	Normal
39	Max. Labor Unit Price	Decimal	Normal
40	Calcd. Annual Amount ⚡ FLOW	Decimal	FlowField
42	Annual Amount	Decimal	Normal
43	Amount per Period	Decimal	Normal
44	Combine Invoices	Boolean	Normal
45	Prepaid	Boolean	Normal
46	Next Invoice Period	Text	Normal
47	Service Zone Code	Code	Normal	→ Service Zone #5957
48	Language Code	Code	Normal	→ Language #8
49	Format Region	Text	Normal
50	Cancel Reason Code	Code	Normal	→ Reason Code #231
51	Last Price Update Date	Date	Normal
52	Next Price Update Date	Date	Normal
53	Last Price Update %	Decimal	Normal
55	Response Time (Hours)	Decimal	Normal
56	Contract Lines on Invoice	Boolean	Normal
57	No. of Posted Invoices ⚡ FLOW	Integer	FlowField
58	No. of Unposted Invoices ⚡ FLOW	Integer	FlowField
59	Service Period	DateFormula	Normal
60	Payment Terms Code	Code	Normal	→ Payment Terms #3
62	Invoice after Service	Boolean	Normal
63	Quote Type	Option	Normal
64	Allow Unbalanced Amounts	Boolean	Normal
65	Contract Group Code	Code	Normal	→ Contract Group #5966
66	Service Order Type	Code	Normal	→ Service Order Type #5903
67	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
68	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
69	Accept Before	Date	Normal
71	Automatic Credit Memos	Boolean	Normal
74	Template No.	Code	Normal
75	Price Update Period	DateFormula	Normal
79	Price Inv. Increase Code	Code	Normal	→ Standard Text #7
80	Print Increase Text	Boolean	Normal
81	Currency Code	Code	Normal	→ Currency #4
82	No. Series	Code	Normal	→ No. Series #308
83	Probability	Decimal	Normal
84	Comment ⚡ FLOW	Boolean	FlowField
85	Responsibility Center	Code	Normal	→ Responsibility Center #5714
86	Phone No.	Text	Normal
87	Fax No.	Text	Normal
88	Email	Text	Normal
89	Bill-to County ⚡ FLOW	Text	FlowField
90	County ⚡ FLOW	Text	FlowField
91	Ship-to County ⚡ FLOW	Text	FlowField
92	Country/Region Code ⚡ FLOW	Code	FlowField
93	Bill-to Country/Region Code ⚡ FLOW	Code	FlowField
94	Ship-to Country/Region Code ⚡ FLOW	Code	FlowField
95	Name 2 ⚡ FLOW	Text	FlowField
96	Bill-to Name 2 ⚡ FLOW	Text	FlowField
97	Ship-to Name 2 ⚡ FLOW	Text	FlowField
98	Next Invoice Period Start	Date	Normal
99	Next Invoice Period End	Date	Normal
100	Contract Invoice Amount ⚡ FLOW	Decimal	FlowField
101	Contract Prepaid Amount ⚡ FLOW	Decimal	FlowField
102	Contract Discount Amount ⚡ FLOW	Decimal	FlowField
103	Contract Cost Amount ⚡ FLOW	Decimal	FlowField
104	Contract Gain/Loss Amount ⚡ FLOW	Decimal	FlowField
106	No. of Posted Credit Memos ⚡ FLOW	Integer	FlowField
107	No. of Unposted Credit Memos ⚡ FLOW	Integer	FlowField
140	Type Filter	Option	FlowFilter
141	Reason Code Filter	Code	FlowFilter	→ Reason Code #231
142	Posted Service Order Filter	Code	FlowFilter	→ Service Shipment Header #5990
143	Date Filter	Date	FlowFilter
144	Item Filter	Code	FlowFilter	→ Item #27
204	Payment Method Code	Code	Normal	→ Payment Method #289
210	Ship-to Phone No. ⚡ FLOW	Text	FlowField
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
1200	Direct Debit Mandate ID	Code	Normal	→ SEPA Direct Debit Mandate #1230
5050	Contact No.	Code	Normal	→ Contact #5050
5051	Bill-to Contact No.	Code	Normal	→ Contact #5050
5052	Bill-to Contact	Text	Normal
5053	Last Invoice Period End	Date	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