Job Master File

Import File: JCJM0001.CSV (Comma) or JCJM0001.TXT (Tab)
Warehouse File: JC_Job_MSTR_IMP_WHSE
Destination File: JC_Job_MSTR (JC00102)

The 'WS Job Number' field has a maximum length of 17 characters. Job numbers longer than this will be cut off.
If you are importing a certified payroll job, enter "1" in the 'Certified Payroll' field. If the job is not certified payroll, leave this field blank.

*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	*WS Job Name	String	30	32
3	C	Project Number	String	17	18
4	D	*Divisions	String	15	16
5	E	*Customer Number	String	15	16
6	F	*Job Address Code	String	15	16
7	G	*Job Billto Address Code	String	15	16
8	H	Estimator ID	String	15	16
9	I	WS Manager ID	String	15	16
10	J	Contract Type	Drop-Down List 1 = Fixed Amount 2 = Cost Plus 3 = Cost Plus NTE	1	1
11	K	WS Billing Type	Drop-Down List 1 = Standard 2 = User Defined 3 = Cost Code 4 = Trx. Level 5 = Project Billing 6 = SOP 7 = Project Bill Code 8 = Project Trx. Level 9 = Project Allocated Revenue	1	1
12	L	*Tax Schedule ID	String	15	16
13	M	Suta State	String	2	4
14	N	Local Tax	String	6	8
15	O	Rate Class	String	15	16
16	P	Bid Due Date	Date	6	6
17	Q	Schedule Start Date	Date	6	6
18	R	Scheduled Completion Date	Date	6	6
19	S	JC Contract Number	String	15	16
20	T	Original Contract Amount	Currency	14	14
21	U	Contract Maximum Bill Amount	Currency	14	14
22	V	Retention %	Currency	14	14
23	W	Tax Exempt Number	String	15	16
24	X	Certified Payroll	Check Box	1	2
25	Y	WS Inactive	Check Box	1	2
26	Z	User Define 1	String	30	32
27	AA	User Define 2	String	30	32
28	AB	User Defined 1	String	20	22
29	AC	User Defined 2	String	20	22
30	AD	User Defined Dollar 1	Currency	14	14
31	AE	User Defined Dollar 2	Currency	14	14
32	AF	User Defined Date 1	Date	8	8
33	AG	User Defined Date 2	Date	8	8