Objects/Tables/Table 5965 Service Contract Header

Table 5965 Service Contract Header in 17

Jonas Paprotka, Base Application 17.5.22499.32099, checked 2026-09-20

App: Base Application

Fields, 104 Keys, 11 Procedures, 17 Events, 19

Versions1718 19 20 21 22 23 24 25 26 27 28 latest

Source29

Fields, 104

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

Keys, 11

Name	Fields	Obsolete
Key1, clustered	Contract Type, Contract No.	-
Key2	Contract No., Contract Type	-
Key3	Customer No., Ship-to Code	-
Key4	Bill-to Customer No., Contract Type, Combine Invoices, Next Invoice Date	-
Key5	Next Price Update Date	-
Key6	Responsibility Center, Service Zone Code, Status, Contract Group Code	-
Key7	Salesperson Code, Status	-
Key8	Template No.	-
Key9	Customer No., Bill-to Customer No.	-
Key10	Customer No., Currency Code, Ship-to Code	-
Key11	Expiration Date	-

Procedures, 17

Name	Parameters	Returns	Access	Obsolete
UpdContractChangeLog	(Record Service Contract Header)		public	-
AssistEdit	(Record Service Contract Header)	Boolean	public	-
ReturnNoOfPer	(Enum Service Contract Header Invoice Period)	Integer	public	-
UpdateServZone	()		public	-
UpdateShiptoCode	()		public	-
NextInvoicePeriod	()	Text[250]	public	-
ValidateNextInvoicePeriod	()		public	-
ValidateShortcutDimCode	(Integer, var Code[20])		public	-
CreateDim	(Integer, Code[20], Integer, Code[20], Integer, Code[20], Integer, Code[20], Integer, Code[20])		public	-
SuspendStatusCheck	(Boolean)		public	-
UpdateCont	(Code[20])		public	-
UpdateCust	(Code[20])		public	-
SetHideValidationDialog	(Boolean)		public	-
SetSecurityFilterOnRespCenter	()		public	-
ShowDocDim	()		public	-
ValidateSalesPersonOnServiceContractHeader	(Record Service Contract Header, Boolean, Boolean)		public	-
IsInvoicePeriodInTimeSegment	()	Boolean	public	-

Events, 19

Kind	Name	Parameters	Obsolete
Integration event	OnAfterAssistEdit	(var Record Service Contract Header)	-
Integration event	OnAfterCreateDimTableIDs	(var Record Service Contract Header, Integer, var Integer, var Code[20])	-
Integration event	OnAfterUpdContractChangeLog	(var Record Service Contract Header, Record Service Contract Header)	-
Integration event	OnAfterValidateShortcutDimCode	(var Record Service Contract Header, var Record Service Contract Header, Integer, var Code[20])	-
Integration event	OnBeforeApplyServiceContractQuoteTemplate	(Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeGetServiceContractNos	(Record Service Contract Header, var Code[20], var Boolean)	-
Integration event	OnBeforeCalculateEndPeriodDate	(var Record Service Contract Header, Boolean, Date, var Date, var Boolean)	-
Integration event	OnBeforeValidateNextInvoicePeriod	(var Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeValidateShortcutDimCode	(var Record Service Contract Header, var Record Service Contract Header, Integer, var Code[20])	-
Integration event	OnValidateNextInvoiceDateOnBeforeCheck	(Record Service Contract Header, var Boolean)	-
Integration event	OnCalculateEndPeriodDateOnPrepaidCaseElse	(Record Service Contract Header, var Date)	-
Integration event	OnCalculateEndPeriodDateCaseElse	(Record Service Contract Header, var Date)	-
Integration event	OnCalcInvPeriodDurationCaseElse	(Record Service Contract Header, DateFormula)	-
Integration event	OnBeforeCheckExpirationDate	(var Boolean)	-
Integration event	OnBeforeUpdateCust	(var Record Service Contract Header, Code[20], var Boolean)	-
Integration event	OnIsInvoicePeriodInTimeSegment	(Record Service Contract Header, var Boolean)	-
Integration event	OnAfterContractLinesExist	(var Record Service Contract Line, var Boolean)	-
Integration event	OnBeforeSetSalespersonCode	(var Record Service Contract Header, Code[20], var Code[20], var Boolean)	-
Integration event	OnBeforeSetAmountPerPeriod	(var Record Service Contract Header, Date, Date, Integer, Integer, var Boolean)	-