Contract Master File

Import File: SVCT0002.CSV (Comma) or SVCT0002.TXT (Tab)
Warehouse File: SV_Maint_MSTR_IMP_WHSE
Destination File: SV_Maint_MSTR (SV00500)
Quicksearch File: SV_Contract_Quicksearch (SV00053)

*Indicates validated fields, and must contain data.

**Indicates validated, but can be left empty.

***Indicates calculated field. If value is entered, it will be overwritten.

Set 'Escalation Date' (89,CK) with the anniversary date.

'Last Review User ID' (97,CS) specifies the Master Tax Schedule used.
If 'Contract Billing Date' (57,BE) is empty, it will be set to 1.
If 'Contract Service Date' (58,BF) is empty, it will be set to 1.
If 'Escalation Frequency' (88,CJ) is empty, it will be set to 'AT ANNIVERSARY'.
If 'Anniversary Date' (93,CO) is empty, it will be set to 'Contract Expiration Date'.

Tab Position (.txt file)	Excel Column (.csv file)	Field Name	Storage Type	Keyable	Storage
1	A	*Customer Number	String	15	16
2	B	*Address Code	String	15	16
3	C	*Contract Number	String	10	12
4	D	User ID	String	15	16
5	E	Technician ID	String	15	16
6	F	Technician Team	String	15	16
7	G	Technician	String	10	12
8	H	Corporate Customer Number	String	15	16
9	I	Corporate Contract Number	String	20	22
10	J	Corporate Invoice Number	String	17	18
11	K	*Contract Amount	Currency	14	10
12	L	*Bill Freq	Drop-Down List 1 = Monthly 2 = Quarterly 3 = Annual 4 = Semi-annual 5 = Other 6 = Every Other Month	1	2
13	M	Signature Close Date	Date	8	4
14	N	Amount Billed	Currency	19	10
15	O	Salesperson ID	String	15	16
16	P	Annual Contract Value	Currency	14	10
17	Q	Revenue Recognition Method ID	Integer	2	2
18	R	Invoice Style	Integer	2	2
19	S	Multiyear Contract Flag	Boolean	1	2
20	T	*Contract Start Date	Date	8	4
21	U	*Contract Expiration Date	Date	8	4
22	V	Estimate Equipment	Currency	14	10
23	W	Estimate Labor	Currency	14	10
24	X	Estimate Material	Currency	14	10
25	Y	Estimate Subs	Currency	14	10
26	Z	Estimate Other	Currency	14	10
27	AA	***Estimate Total Cost	Currency	14	10
28	AB	Estimate Hours	Long Integer	6	4
29	AC	Estimate Labor 1	Currency	14	10
30	AD	Estimate Labor 1 Hours	Long Integer	6	4
31	AE	Estimate Labor 2	Currency	14	10
32	AF	Estimate Labor 2 Hours	Long Integer	6	4
33	AG	Estimate Labor 3	Currency	14	10
34	AH	Estimate Labor 3 Hours	Long Integer	6	4
35	AI	Estimate Labor 4	Currency	14	10
36	AJ	Estimate Labor 4 Hours	Long Integer	6	4
37	AK	Estimate Labor 5	Currency	14	10
38	AL	Estimate Labor 5 Hours	Long Integer	6	4
39	AM	Estimate Total Labor	Currency	14	10
40	AN	Estimate Total Labor Hrs	Long Integer	6	4
41	AO	Budget Group	Radio Group	0	2
42	AP	Contract Description	String	30	32
43	AQ	User Define 1a	String	30	32
44	AR	User Define 2a	String	30	32
45	AS	User Define 3a	String	30	32
46	AT	User Define 4a	String	30	32
47	AU	Service User Define 3	String	30	32
48	AV	Service User Define 5	Long Integer	6	4
49	AW	Service User Define 6	Long Integer	6	4
50	AX	Service User Define 9	Date	8	4
51	AY	Service User Define 10	Date	8	4
52	AZ	Service User Define 18	Check Box	1	2
53	BA	Service User Define 19	Check Box	1	2
54	BB	Service User Define 22	Currency	14	10
55	BC	Service User Define 23	Currency	14	10
56	BD	Service User Define 24	Currency	14	10
57	BE	Contract Billing Date	Integer	2	2
58	BF	Contract Service Date	Integer	2	2
59	BG	Closed	Boolean	1	2
60	BH	Auto Bill	Check Box	1	2
61	BI	Purchase Order	String	15	16
62	BJ	Last Fiscal Day	Date	6	4
63	BK	*Divisions	String	15	16
64	BL	Auto Date	Date	6	4
65	BM	Cancel Box	Check Box	1	2
66	BN	Hold	Check Box	1	2
67	BO	Contract NTE Units	Long Integer	8	4
68	BP	Contract Annual Units	Long Integer	8	4
69	BQ	Equipment ID	String	10	12
70	BR	Warranty Check Box	Check Box	1	2
71	BS	Time Zone	String	3	4
72	BT	SV Language ID	Integer	2	2
73	BU	Base Currency ID	String	15	16
74	BV	Billing Currency ID	String	15	16
75	BW	Local Currency ID	String	15	16
76	BX	Hold Reason ID	Integer	4	2
77	BY	Billing Equipment	Currency	14	10
78	BZ	Billing Material	Currency	14	10
79	CA	Billing Labor	Currency	14	10
80	CB	Billing Subs	Currency	14	10
81	CC	Billing Other	Currency	14	10
82	CD	Billing Percentage Equip	Currency	8	10
83	CE	Billing Percentage Material	Currency	8	10
84	CF	Billing Percentage Labor	Currency	8	10
85	CG	Billing Percentage Subs	Currency	8	10
86	CH	Billing Percentage Other	Currency	8	10
87	CI	Current Billing Amount	Currency	14	10
88	CJ	Escalation Frequency	String	15	16
89	CK	Escalation Date	Date	6	4
90	CL	Escalation Notification Days	Integer	3	2
91	CM	Next Escalation Date	Date	6	4
92	CN	Begin Date CY	Date	6	4
93	CO	Anniversary Date	Date	6	4
94	CP	Evergreen Contract Flag	Boolean	1	2
95	CQ	Contract Units Measure	String	15	16
96	CR	Last Review Date	Date	6	4
97	CS	Last Review User ID	String	15	16
98	CT	Contract Internal Name Note: This represents the Contract Type field.	String	15	16
99	CU	Automatic Escalation Flag	Boolean	1	2
100	CV	*Bill Customer Number	String	15	16
101	CW	*Bill Address Code	String	15	16