Contract Task Master File

Import File: SVCT0001.CSV (Comma) or SVCT0001.TXT (Tab)
Warehouse File: SV_Contract_Task_MSTR_IMP_WHSE
Destination Files: SV_Contract_Task_MSTR (SV00582), SV_Contract_Task_Schedule (SV00585

*Indicates validated fields, and must contain data.

**Indicates validated, but can be left empty.

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	Customer Contract Number	String	15	16
4	D	User ID	String	15	16
5	E	Technician ID	String	15	16
6	F	Technician Team	String	15	16
7	G	Subcontractor ID (not used)	String	15	16
8	H	*Contract Number	String	10	12
9	I	*Equipment ID	String	10	12
10	J	Equipment Type	String	30	32
11	K	*Task Code	String	10	12
12	L	Contract Task List ID	String	10	12
13	M	System	String	15	16
14	N	Major	String	15	16
15	O	Sub 1	String	15	16
16	P	Sub 2	String	15	16
17	Q	Sub 3	String	15	16
18	R	Sub 4	String	15	16
19	S	Task Description	String	60	62
20	T	Signature Close Date	Date	8	4
21	U	Inactive	Check Box	1	2
22	V	Estimate Hours	Long Integer	6	4
23	W	Estimate Labor	Currency	14	10
24	X	Estimate Labor 1	Currency	14	10
25	Y	Estimate Labor 1 Hours	Long Integer	6	4
26	Z	Estimate Labor 2	Currency	14	10
27	AA	Estimate Labor 2 Hours	Long Integer	6	4
28	AB	Estimate Labor 3	Currency	14	10
29	AC	Estimate Labor 3 Hours	Long Integer	6	4
30	AD	Estimate Labor 4	Currency	14	10
31	AF	Estimate Labor 4 Hours	Long Integer	6	4
32	AG	Estimate Labor 5	Currency	14	10
33	AH	Estimate Labor 5 Hours	Long Integer	6	4
34	AI	Estimate Equipment	Currency	14	10
35	AJ	Estimate Material	Currency	14	10
36	AK	Estimate Subs	Currency	14	10
37	AL	Estimate Other	Currency	14	10
38	AM	Estimate Total Cost	Currency	14	10
39	AN	Billable Equipment	String	15	16
40	AO	Billable Material	Currency	14	10
41	AP	Billable Subs	Currency	14	10
42	AQ	Billable Other	Currency	14	10
43	AR	Billable Labor 1	Currency	14	10
44	AS	Billable Labor 2	Currency	14	10
45	AT	Billable Labor 3	Currency	14	10
46	AU	Billable Labor 4	Currency	14	10
47	AV	Billable Labor 5	Currency	14	10
48	AW	Frequency	String	15	16
49	AX	*Schedule	Integer	2	2
50	AY	Optional	Check Box	1	2
51	AZ	*Skill Level	String	15	16
52	BA	Material Kit Required	String	30	32
53	BB	Material Kit Quantity	Long Integer	7	4
54	BC	Tool Kit Required	String	15	16
55	BD	Coverage Code	Integer	5	2
56	BE	Task User Define1	String	20	22
57	BF	Task User Define2	String	20	22
58	BG	Task User Define3	String	30	32
59	BH	Task User Define4	String	30	32
60	BI	Task User Define5	Long Integer	6	4
61	BJ	Task User Define6	Long Integer	6	4
62	BK	Task User Define7	Long Integer	6	4
63	BL	Task User Define8	Long Integer	6	4
64	BM	Task User Define9	Date	8	4
65	BN	Task User Define10	Date	8	4
66	BO	Task User Define11	Date	8	4
67	BP	Task User Define12	Date	8	4
68	BQ	Task User Define13	Currency	14	10
69	BR	Task User Define14	Currency	14	10
70	BS	Task User Define15	Currency	14	10
71	BT	Task User Define16	Currency	14	10
72	BU	Task User Define17	Currency	14	10
73	BV	Task User Define18	Check Box	1	2
74	BW	Task User Define19	Check Box	1	2
75	BX	Task User Define20	Check Box	1	2
76	BY	Task User Define21	Check Box	1	2
77	BZ	Task Hours	Long Integer	6	4
78	CA	Week 1	Check Box	1	2
79	CB	Week 2	Check Box	1	2
80	CC	Week 3	Check Box	1	2
81	CD	Week 4	Check Box	1	2
82	CE	Week 5	Check Box	1	2
83	CF	Time Zone	String	3	4
84	CG	SV Language ID	Integer	2	2
85	CH	Base Currency ID	String	15	16
86	CI	Billing Currency ID	String	15	16
87	CJ	Local Currency ID	String	15	16
88	CK	PM Group	String	3	4
89	CL	ID 1	String	10	12
90	CM	ID 2	String	10	12
91	CN	YR MOD	Integer	2	2
92	CO	YR REM	Integer	2	2