Job Detail Master File

Import File: JCJD0001.CSV (Comma) or JCJD0001.TXT (Tab)
Warehouse File: JC_Job_Detail_MSTR_IMP_WHSE
Destination File: JC_Job_Detail_MSTR (JC00701)

*Indicates validated fields, and must contain data.

**Indicates validated, but can be left empty.

'Labor Group Name' (42, AP) must be validated if a 'Profit Type Number' (9,I) of 9 is entered.

'WS Account Index 1' (43, AQ) must be validated if using the Cost Code posting option.
The Change Order Estimate Cost (U) and Change Order Estimate Units (AC) should be empty when importing this file.

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	*Cost Code Number 1	Composite	4	4
4	D	*Cost Code Number 2	Composite	4	4
5	E	*Cost Code Number 3	Composite	4	4
6	F	*Cost Code Number 4	Composite	4	4
7	G	*Cost Code Description	String	30	32
8	H	*Cost Element	Integer	3	3
9	I	*Profit Type Number	Integer	2	2
10	J	*Profit Amount	Currency	14	14
11	K	WS Manager ID	String	15	16
12	L	Estimated Measure Code	String	6	8
13	M	Production Measure Code	String	6	8
14	N	*Type of Transaction	Drop-Down List 1 = All 2 = Inventory Item 3 = Vendor ID 4 = Purchase Order	1	1
15	O	Workers Comp	String	6	8
16	P	Track Production Qty	Check Box	1	2
17	Q	Production Estimate Qty	Currency	14	14
18	R	Production Qty/Unit	Currency	14	14
19	S	Production Best	Currency	12	12
20	T	Cost Code Estimated Cost	Currency	14	14
21	U	Change Order Estimated Cost	Currency	14	14
22	V	Cost Code Rvsd Estimated Cost	Currency	14	14
23	W	Original Estimate Units	Currency	14	14
24	X	Cost Code Estimated Units	Currency	14	14
25	Y	Estimated Amt/Units	Currency	14	14
26	Z	Scheduled Completion Date	Date	6	6
27	AA	Scheduled Start Date	Date	6	6
28	AB	Field % Complete	Integer	5	5
29	AC	Change Order Estimated Units	Currency	14	14
30	AD	User Define 1	String	30	32
31	AE	User Define 2	String	30	32
32	AF	User Defined 1	String	20	22
33	AG	User Defined 2	String	20	22
34	AH	User Defined Dollar 1	Currency	14	14
35	AI	User Defined Dollar 2	Currency	14	14
36	AJ	User Defined Date 1	Date	8	8
37	AK	User Defined Date 2	Date	8	8
38	AL	Vendor Number	String	25	26
39	AM	Item Number	String	30	32
40	AN	Purchase Order Number	String	20	22
41	AO	Rate Per Unit	Currency	14	14
42	AP	**Labor Group Name	String	15	16
43	AQ	WS Account Index 1	Long Integer	14	14