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 check box 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
- Indicates required (and validated) if using Global Filtering.
- Indicates validated fields, but can be left empty.