Objects/Tables/Table 5970 Filed Service Contract Header

Table 5970 Filed Service Contract Header in 25

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

App: Base Application
Namespace: Microsoft.Service.Contract

Fields, 103 Keys, 3 Procedures, 6 Events, 3

Versions17 18 19 20 21 22 23 242526 27 28 latest

Source29

Fields, 103

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	Option	-
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	-
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	Entry No.	Integer	-
101	File Date	Date	-
102	File Time	Time	-
103	Filed By	Code[50]	-
104	Reason for Filing	Option	-
105	Contract Type Relation	Enum Service Contract Type	-
106	Contract No. Relation	Code[20]	-
109	No. of Filed Versions	Integer	-
110	Restorable	Boolean	-
111	Source Contract Exists	Boolean	-
112	Last Filed DateTime	DateTime	-
204	Payment Method Code	Code[10]	-
210	Ship-to Phone No.	Text[30]	-
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, 3

Name	Fields	Obsolete
Key1, clustered	Entry No.	-
Key2	Contract Type Relation, Contract No. Relation, File Date, File Time	-
Key3	Contract Type, Contract No.	-

Procedures, 6

Name	Parameters	Returns	Access	Obsolete
GetLastEntryNo	()	Integer	public	-
FileContract	(Record Service Contract Header)		public	-
FileQuotationBeforeSigning	(Record Service Contract Header)		public	-
FileContractBeforeCancellation	(Record Service Contract Header)		public	-
NextInvoicePeriod	()	Text[250]	public	-
SetSecurityFilterOnResponsibilityCenter	()		internal	-

Events, 3

Kind	Name	Parameters	Obsolete
Integration event	OnAfterFileContract	(var Record Filed Service Contract Header, Record Service Contract Header)	-
Integration event	OnFileContractOnBeforeFiledServContractHeaderInsert	(var Record Service Contract Header, var Record Filed Service Contract Header)	-
Integration event	OnFileContractOnBeforeFiledContractLineTransferFields	(var Record Service Contract Line)	-