Import File: JCVM0001.CSV (Comma) or JCVM0001.TXT (Tab)
Warehouse File: JC_Vendor_MSTR_IMP_WHSE
Destination File: JC_Vendor_MSTR (JC01501)
- Indicates validated fields, and must contain data.
Tab Position
Excel Column
Field Name
Storage Type
Keyable
Storage
1
A
*WS Job Number
String
17
18
2
B
Project Number
String
17
18
3
C
*Vendor ID
String
15
16
4
D
Vendor Name
String
64
66
5
E
*Address Code
String
15
16
6
F
*Vendor Contract Type
Drop-Down List
1 = NTE
2 = Lump Sum
3 = Unit Price7
G
*Original Contract Amount
Currency
14
14
8
H
Retention %
Currency
14
14
9
I
Mod Rate
Integer
3
3
10
J
Purchase Order Number
String
14
16
11
K
Contract Date
Date
8
8
12
L
Insurance Certificate on File
Date
8
8
13
M
Insurance Expiration Date
Date
8
8
14
N
Submit Date
Date
8
8
15
O
Resubmit Date
Date
8
8
16
P
Approved Date
Date
8
8
17
Q
Disapproved Date
Date
8
8
18
R
User Define 1
String
30
32
19
S
User Define 2
String
30
32
20
T
User Defined 1
String
20
22
21
U
User Defined 2
String
20
22
22
V
User Defined Dollar 1
Currency
14
14
23
W
User Defined Dollar 2
Currency
14
14
24
X
User Defined Date 1
Date
6
6
25
Y
User Defined Date 2
Date
6
6