Objects/Tables/Table 5965 Service Contract Header

Fields, 106

Jonas Paprotka, Base Application 28.5.54151.54365, versions 17-28, checked 2026-09-20

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