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 (.txt file) |
Excel Column (.csv file) |
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
|
|
|
|
7 |
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 |