Import File: SVCT0002.CSV (Comma) or SVCT0002.TXT (Tab)
Warehouse File: SV_Maint_MSTR_IMP_WHSE
Destination File: SV_Maint_MSTR (SV00500)
Quicksearch File: SV_Contract_Quicksearch (SV00053)
- Indicates validated fields, and must contain data.
- Indicates validated, but can be left empty.
- Indicates calculated field. If value is entered, it will be overwritten.
Note: Set 'Escalation Date' (89,CK) with the anniversary date.
'Last Review User ID' (97,CS) specifies the Master Tax Schedule used.
If 'Contract Billing Date' (57,BE) is empty, it will be set to 1.
If 'Contract Service Date' (58,BF) is empty, it will be set to 1.
If 'Escalation Frequency' (88,CJ) is empty, it will be set to 'AT ANNIVERSARY'.
If 'Anniversary Date' (93,CO) is empty, it will be set to 'Contract Expiration Date'.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
*Contract Number
String
10
12
4
D
User ID
String
15
16
5
E
Technician ID
String
15
16
6
F
Technician Team
String
15
16
7
G
Technician
String
10
12
8
H
Corporate Customer Number
String
15
16
9
I
Corporate Contract Number
String
20
22
10
J
Corporate Invoice Number
String
17
18
11
K
*Contract Amount
Currency
14
10
12
L
*Bill Freq
Drop-Down List
1 = Monthly
2 = Quarterly
3 = Annual
4 = Semi-annual
5 = Other
6 = Every Other Month1
2
13
M
Signature Close Date
Date
8
4
14
N
Amount Billed
Currency
19
10
15
O
Salesperson ID
String
15
16
16
P
Annual Contract Value
Currency
14
10
17
Q
Revenue Recognition Method ID
Integer
2
2
18
R
Invoice Style
Integer
2
2
19
S
Multiyear Contract Flag
Boolean
1
2
20
T
*Contract Start Date
Date
8
4
21
U
*Contract Expiration Date
Date
8
4
22
V
Estimate Equipment
Currency
14
10
23
W
Estimate Labor
Currency
14
10
24
X
Estimate Material
Currency
14
10
25
Y
Estimate Subs
Currency
14
10
26
Z
Estimate Other
Currency
14
10
27
AA
***Estimate Total Cost
Currency
14
10
28
AB
Estimate Hours
Long Integer
6
4
29
AC
Estimate Labor 1
Currency
14
10
30
AD
Estimate Labor 1 Hours
Long Integer
6
4
31
AE
Estimate Labor 2
Currency
14
10
32
AF
Estimate Labor 2 Hours
Long Integer
6
4
33
AG
Estimate Labor 3
Currency
14
10
34
AH
Estimate Labor 3 Hours
Long Integer
6
4
35
AI
Estimate Labor 4
Currency
14
10
36
AJ
Estimate Labor 4 Hours
Long Integer
6
4
37
AK
Estimate Labor 5
Currency
14
10
38
AL
Estimate Labor 5 Hours
Long Integer
6
4
39
AM
Estimate Total Labor
Currency
14
10
40
AN
Estimate Total Labor Hrs
Long Integer
6
4
41
AO
Budget Group
Radio Group
0
2
42
AP
Contract Description
String
30
32
43
AQ
User Define 1a
String
30
32
44
AR
User Define 2a
String
30
32
45
AS
User Define 3a
String
30
32
46
AT
User Define 4a
String
30
32
47
AU
Service User Define 3
String
30
32
48
AV
Service User Define 5
Long Integer
6
4
49
AW
Service User Define 6
Long Integer
6
4
50
AX
Service User Define 9
Date
8
4
51
AY
Service User Define 10
Date
8
4
52
AZ
Service User Define 18
Check Box
1
2
53
BA
Service User Define 19
Check Box
1
2
54
BB
Service User Define 22
Currency
14
10
55
BC
Service User Define 23
Currency
14
10
56
BD
Service User Define 24
Currency
14
10
57
BE
Contract Billing Date
Integer
2
2
58
BF
Contract Service Date
Integer
2
2
59
BG
Closed
Boolean
1
2
60
BH
Auto Bill
Check Box
1
2
61
BI
Purchase Order
String
15
16
62
BJ
Last Fiscal Day
Date
6
4
63
BK
*Divisions
String
15
16
64
BL
Auto Date
Date
6
4
65
BM
Cancel Box
Check Box
1
2
66
BN
Hold
Check Box
1
2
67
BO
Contract NTE Units
Long Integer
8
4
68
BP
Contract Annual Units
Long Integer
8
4
69
BQ
Equipment ID
String
10
12
70
BR
Warranty Check Box
Check Box
1
2
71
BS
Time Zone
String
3
4
72
BT
SV Language ID
Integer
2
2
73
BU
Base Currency ID
String
15
16
74
BV
Billing Currency ID
String
15
16
75
BW
Local Currency ID
String
15
16
76
BX
Hold Reason ID
Integer
4
2
77
BY
Billing Equipment
Currency
14
10
78
BZ
Billing Material
Currency
14
10
79
CA
Billing Labor
Currency
14
10
80
CB
Billing Subs
Currency
14
10
81
CC
Billing Other
Currency
14
10
82
CD
Billing Percentage Equip
Currency
8
10
83
CE
Billing Percentage Material
Currency
8
10
84
CF
Billing Percentage Labor
Currency
8
10
85
CG
Billing Percentage Subs
Currency
8
10
86
CH
Billing Percentage Other
Currency
8
10
87
CI
Current Billing Amount
Currency
14
10
88
CJ
Escalation Frequency
String
15
16
89
CK
Escalation Date
Date
6
4
90
CL
Escalation Notification Days
Integer
3
2
91
CM
Next Escalation Date
Date
6
4
92
CN
Begin Date CY
Date
6
4
93
CO
Anniversary Date
Date
6
4
94
CP
Evergreen Contract Flag
Boolean
1
2
95
CQ
Contract Units Measure
String
15
16
96
CR
Last Review Date
Date
6
4
97
CS
Last Review User ID
String
15
16
98
CT
Contract Internal Name
Note: This represents the Contract Type field.String
15
16
99
CU
Automatic Escalation Flag
Boolean
1
2
100
CV
*Bill Customer Number
String
15
16
101
CW
*Bill Address Code
String
15
16
- Indicates calculated field. If value is entered, it will be overwritten.
- Indicates validated, but can be left empty.