Service Call Master File

Import File: SVSC001.CSV (Comma) or SVSC001.TXT (Tab)
Warehouse File: SV_Service_MST_IMP_WHSE
Destination Files: SV_Service_MSTR (SV00300)

*Indicates validated fields, and must contain data.

**Indicates validated fields, but can be left empty.

***Indicates required (and validated) if using Global Filtering.

Tab Position (.txt file)	Excel Column (.csv file)	Field Name	Storage Type	Keyable	Storage
1	A	*Customer Number	String	15	15
2	B	*Service Call Description	String	30	31
3	C	*Service Call ID (required only if system is set up to manually create service call Id's)	String	17	17
4	D	*Address Code	String	15	15
5	E	***Signature Affiliate	String	15	15
6	F	***Signature Region	String	15	15
7	G	***Signature Branch	String	15	15
8	H	Technician	String	10	11
9	I	Type of Problem	String	30	31
10	J	**Resolution ID	String	3	3
11	K	Type Call Short Note:** If call type is MC or MCC, Contract Number is required.	String	3	3
12	L	User Define 1a	String	30	31
13	M	User Define 2a Note:** Will be validated if the corresponding checkbox is marked in Service Options window,	String	30	31
14	N	User Define 3a	String	30	31
15	O	User Define 4a	String	30	31
16	P	*Purchase Order (required only if location requires a PO number)	String	15	15
17	Q	*Date of Service Call	Date	8	8
18	R	**Salesperson ID	String	15	15
19	S	Priority of Call	String	1	1
20	T	Status of Call	String	10	11
21	U	Completion Date Note: If Status of Call is complete, Completion Date is required.	Date	8	8
22	V	*WS Time 1	Date	8	8
23	W	Time Zone	String	3	3
24	X	DATE	Date	8	8
25	Y	*Divisions	String	15	15
26	Z	Call Time	Integer	4	4
27	AA	Corporate Contract Number	String	20	21
28	AB	**Contract Number	String	10	11
29	AC	Caller Email Address	String	40	41
30	AD	Caller Name	String	30	31
31	AE	Caller Phone	String	20	21
32	AF	Callback	Tiny Integer	1	1
33	AG	WS Job Number	String	17	17
34	AH	**SV Service Level ID	String	10	11
35	AI	PO Outstanding Status	String		15
36	AJ	Service User Define 2	String	20	21
37	AK	Service User Define 3	String	30	31
38	AL	Service User Define 4	String	30	31
39	AM	Service User Define 5	Integer	6	4
40	AN	Service User Define 6	Integer	6	4
41	AO	Service User Define 7	Integer	6	4
42	AP	Service User Define 8	Integer	6	4
43	AQ	Service User Define 9	Date	8	8
44	AR	Service User Define 10	Date	8	8
45	AS	Service User Define 11	Date	8	8
46	AT	Service User Define 12	Date	8	8
47	AU	Service User Define 18	Tiny Integer	1	1
48	AV	Service User Define 19	Tiny Integer	1	1
49	AW	Service User Define 20	Tiny Integer	1	1
50	AX	Service User Define 21	Tiny Integer	1	1
51	AY	Service User Define 22	Numeric	14	9
52	AZ	Service User Define 23	Numeric	14	9
53	BA	Service User Define 24	Numeric	14	9
54	BB	Service User Define 25	Numeric	14	9
55	BC	Added Rate	Tiny Integer
56	BD	WCA Originating Call	String	17	17
57	BE	WCA Technician	String	15	15
58	BF	SV Call Source	Integer	3	3
59	BG	SV Call Source ID1	String	40	40
60	BH	SV Call Source ID2	String	40	40