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
Excel Column
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
- Indicates validated fields, but can be left empty.