Filed Service Contract Header #5970

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

108

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: Entry No..

All fields (108)

Filed Service Contract Header — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Contract No.	Code	Normal
2	Contract Type	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	Text	Normal
9	Address	Text	Normal
10	Address 2	Text	Normal
11	Post Code	Code	Normal	→ Post Code #225
12	City	Text	Normal	→ Post Code #225
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	Text	Normal
18	Bill-to Address	Text	Normal
19	Bill-to Address 2	Text	Normal
20	Bill-to Post Code	Code	Normal	→ Post Code #225
21	Bill-to City	Text	Normal	→ Post Code #225
22	Ship-to Code	Code	Normal	→ Ship-to Address #222
23	Ship-to Name	Text	Normal
24	Ship-to Address	Text	Normal
25	Ship-to Address 2	Text	Normal
26	Ship-to Post Code	Code	Normal	→ Post Code #225
27	Ship-to City	Text	Normal	→ Post Code #225
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	Decimal	Normal
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
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	Text	Normal
90	County	Text	Normal
91	Ship-to County	Text	Normal
92	Country/Region Code	Code	Normal	→ Country/Region #9
93	Bill-to Country/Region Code	Code	Normal	→ Country/Region #9
94	Ship-to Country/Region Code	Code	Normal	→ Country/Region #9
95	Name 2	Text	Normal
96	Bill-to Name 2	Text	Normal
97	Ship-to Name 2	Text	Normal
98	Next Invoice Period Start	Date	Normal
99	Next Invoice Period End	Date	Normal
100	Entry No. PK	Integer	Normal
101	File Date	Date	Normal
102	File Time	Time	Normal
103	Filed By	Code	Normal
104	Reason for Filing	Option	Normal
105	Contract Type Relation	Option	Normal
106	Contract No. Relation	Code	Normal	→ Service Contract Header #5965
109	No. of Filed Versions ⚡ FLOW	Integer	FlowField
110	Restorable	Boolean	Normal
111	Source Contract Exists ⚡ FLOW	Boolean	FlowField
112	Last Filed DateTime ⚡ FLOW	DateTime	FlowField
204	Payment Method Code	Code	Normal	→ Payment Method #289
210	Ship-to Phone No.	Text	Normal
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