Location Master File

Import File: SVCU0002.CSV (Comma) or SVCU0002.TXT (Tab)
Warehouse File: SV_Location_IMP_WHSE
Destination Files: RM_Customer_MSTR_ADDR (RM00102), SV_Location_MSTR (SV00200)

*Indicates validated fields, and must contain data.

**Indicates validated fields, 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	Salesperson ID	String	15	16
4	D	UPS Zone	String	3	4
5	E	Shipping Method	String	15	16
6	F	Tax Schedule ID	String	15	16
7	G	Contact Person	String	30	32
8	H	Address 1	String	30	32
9	I	Address 2	String	30	32
10	J	Country	String	20	22
11	K	City	String	30	32
12	L	State	String	4	30
13	M	Zip	String	10	12
14	N	Phone 1	String	14	22
15	O	Phone 2	String	14	22
16	P	Fax	String	14	22
17	Q	**Signature Affiliate	String	15	16
18	R	**Signature Region	String	15	16
19	S	**Signature Branch	String	15	16
20	T	User ID	String	15	16
21	U	Technician ID	String	15	16
22	V	Technician Team	String	15	16
23	W	Customer Name	String	64	66
24	X	Map Grid	String	15	16
25	Y	Service Area	String	15	16
26	Z	*Location Name	String	30	32
27	AA	*Labor Group Name	String	15	16
28	AB	*Pricing Matrix Name	String	15	16
29	AC	Technician	String	10	12
30	AD	Technician 2	String	10	12
31	AE	Technician ID2	String	15	16
32	AF	Contact Name	String	15	16
33	AG	Hold Transaction ID	Long Integer	7	4
34	AH	User Define 1a	String	30	32
35	AI	User Define 2a	String	30	32
36	AJ	User Define 3a	String	30	32
37	AK	User Define 4a	String	30	32
38	AL	User Define 5a	String	30	32
39	AM	User Define 6a	String	30	32
40	AN	PO Required	Check Box	1	2
41	AO	Out of Service Flag	Check Box	1	2
42	AP	Alarm Flag	Check Box	1	2
43	AQ	Supervisors ID	String	15	16
44	AR	Supervisors Hold Flag	Check Box	1	2
45	AS	Corporate Customer Number	String	15	16
46	AT	Time Zone Tag	String	4	6
47	AU	SV Language ID	Integer	2	2
48	AV	Base Currency ID	String	15	16
49	AW	Billing Currency ID	String	15	16
50	AX	Local Currency ID	String	15	16
51	AY	Priority of Call	String	1	2
52	AZ	Divisions	String	15	16
53	BA	SV Service Level ID	String	10	12
54	BB	Safety Flag	Tiny Integer
55	BC	Blanket PO Check Box	Tiny Integer
56	BD	Blanket PO Number	String	17	17
57	BE	Blanket PO Amount	String
58	BF	Blanket PO Amount Spent	Currency
59	BG	Blanket PO Amount Remaining	Currency
60	BH	Blanket PO Expiration Date	Date
61	BI	*Bill Customer Number	String	15	16
62	BJ	*Bill Address Code	String	15	16