JC Vendor Master File

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 1 = NTE 2 = Lump Sum 3 = Unit Price
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