Objects/Tables/Table 5965 Service Contract Header

Table 5965 Service Contract Header in 23

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

App: Base Application
Namespace: Microsoft.Service.Contract

Fields, 105 Keys, 11 Procedures, 19 Events, 59

Versions17 18 19 20 21 222324 25 26 27 28 latest

Source29

Fields, 105

Id	Name	Type	Obsolete
1	Contract No.	Code[20]	-
2	Contract Type	Enum Service Contract Type	-
3	Description	Text[100]	-
4	Description 2	Text[50]	-
5	Status	Enum Service Contract Status	-
6	Change Status	Enum Service Contract Change Status	-
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]	-
49	Format Region	Text[80]	-
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	Enum Service Contract Quote Type	-
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	Enum Service Ledger Entry Type	-
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, 19

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	-
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	-
CalculateEndPeriodDate	(Boolean, Date)	Date	public	-
CreateDim	(List)		public	-
CreateDimFromDefaultDim	(Integer)		public	-

Events, 59

Kind	Name	Parameters	Obsolete
Integration event	OnAfterAssistEdit	(var Record Service Contract Header)	-
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	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	OnBeforeValidateShortcutDimCode	(var Record Service Contract Header, var Record Service Contract Header, Integer, var Code[20])	-
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)	-
Integration event	OnAfterReturnNoOfPer	(Enum Service Contract Header Invoice Period, var Integer)	-
Integration event	OnAfterUpdateBillToCont	(var Record Service Contract Header, Record Customer, Record Contact)	-
Integration event	OnBeforeApplyServiceContractQuoteTemplate	(var Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeValidateNextInvoicePeriod	(var Record Service Contract Header, var Boolean, Record Service Contract Header)	-
Integration event	OnBeforeValidateNextInvoiceDate	(var Record Service Contract Header, Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeValidateLastInvoiceDate	(var Record Service Contract Header, var Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeValidateInvoicePeriod	(var Record Service Contract Header, var Boolean)	-
Integration event	OnValidateNextInvoiceDateOnBeforeCheck	(var Record Service Contract Header, var Boolean)	-
Integration event	OnValidateNextInvoiceDateOnBeforeValidateNextInvoicePeriod	(var Record Service Contract Header)	-
Integration event	OnValidateStartingDateOnAfterServContractLineSetFilters	(var Record Service Contract Header, var Record Service Contract Line)	-
Integration event	OnCalculateEndPeriodDateOnPrepaidCaseElse	(var Record Service Contract Header, var Date)	-
Integration event	OnCalculateEndPeriodDateCaseElse	(var Record Service Contract Header, var Date)	-
Integration event	OnUpdateBillToCustOnBeforeContBusinessRelationFindByContact	(var Record Service Contract Header, Record Customer, Record Contact)	-
Integration event	OnValidateBillToCustomerNoOnAfterCopyFieldsFromCust	(var Record Service Contract Header, Record Customer, Boolean)	-
Integration event	OnAfterCreateDim	(var Record Service Contract Header, Integer)	-
Integration event	OnBeforeSetSecurityFilterOnRespCenter	(var Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeCheckExpirationDate	(var Boolean, var Record Service Contract Header)	-
Integration event	OnAfterInitDefaultDimensionSources	(var Record Service Contract Header, var List, Integer)	-
Integration event	OnAfterUpdateShiptoCode	(var Record Service Contract Header)	-
Integration event	OnBeforeInitNoSeries	(var Record Service Contract Header, Record Service Contract Header, Record Service Mgt. Setup, var Boolean)	-
Integration event	OnBeforeValidatePrepaid	(var Record Service Contract Header, Record Service Contract Header, var Record Service Ledger Entry, var Boolean)	-
Integration event	OnCalcInvPeriodDurationCaseElse	(var Record Service Contract Header, var DateFormula)	-
Integration event	OnAfterUpdateCont	(var Record Service Contract Header, Code[20])	-
Integration event	OnBeforeChangeContractStatus	(var Record Service Contract Header, Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeCheckChangeStatus	(var Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeAskContractAmountDistribution	(var Record Service Contract Header, var Boolean, var Integer, var Boolean)	-
Integration event	OnValidateBillToCustomerNoOnBeforePrivacyBlockedCheck	(var Record Service Contract Header, Record Customer, var Boolean)	-
Integration event	OnValidateBillToCustomerNoOnBeforeBlockedCheck	(var Record Service Contract Header, Record Customer, var Boolean)	-
Integration event	OnBeforeValidateSalesPersonOnServiceContractHeader	(var Record Service Contract Header, Boolean, Boolean, var Boolean)	-
Integration event	OnBeforeValidateBillToCustomerNo	(var Record Service Contract Header, var Record Service Contract Header, Boolean, var Boolean, Boolean, var Boolean)	-
Integration event	OnBeforeValidateCustomerNo	(var Record Service Contract Header, var Record Service Contract Header, var Boolean, var Boolean, var Boolean)	-
Integration event	OnBeforeValidateShipToCode	(var Record Service Contract Header, var Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeValidateStartingDate	(var Record Service Contract Header, var Record Service Contract Line, var Boolean)	-
Integration event	OnUpdateContOnAfterUpdateContFromCust	(var Record Service Contract Header)	-
Integration event	OnBeforeValidateCurrencyCode	(var Record Service Contract Header, Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeChangeCustomerNo	(var Record Service Contract Header, Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeChangeExpirationDate	(var Record Service Contract Header, Record Service Contract Header, var Boolean)	-
Integration event	OnValidateShipToCodeOnBeforeContractLinesExist	(var Record Service Contract Header, var Boolean)	-
Integration event	OnAfterUpdateZone	(var Record Service Contract Header)	-
Integration event	OnBeforeCreateDim	(var Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeConfirmChangeContactNo	(var Record Service Contract Header, var Boolean)	-
Integration event	OnBeforeConfirmChangeBillToContactNo	(var Record Service Contract Header, var Boolean)	-
Integration event	OnAfterShowDocDim	(var Record Service Contract Header)	-
Integration event	OnChangeContractStatusOnBeforeConfirmCancelTheContractQst	(var Record Service Contract Header, var Boolean)	-
Integration event	OnChangeContractStatusOnBeforeModifyServContractLines	(var Record Service Contract Line, Record Service Contract Header, Record Service Contract Header)	-
Integration event	OnCheckChangeStatusOnBeforeSetBillToCustomerNo	(var Record Service Contract Header, var Boolean)	-
Integration event	OnCheckChangeStatusOnBeforeCheckContractLinesExist	(var Record Service Contract Header, var Boolean)	-
Integration event	OnChangeExpirationDateOnBeforeValidateInvoicePeriod	(var Record Service Contract Header, var Boolean)	-