Change Order Detail Master File

Import File: JCCOD0001.CSV (Comma) or JCCOD0001.TXT (Tab)
Warehouse File: JC_Chg_Ord_Detail_MSTR_IMP_WHSE
Destination File: JC_Chg_Ord_Detail_MSTR (JC01002)

*Indicates validated fields, and must contain data.

'Posting Status' (12,L) must have a value of 2, or be empty.

Cost codes applied to a change order must already exist on the job record.

Tab Position (.txt file)	Excel Column (.csv file)	Field Name	Storage Type	Keyable	Storage
1	A	*WS Job Number	String	17	18
2	B	*Change Order #	String	14	16
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	Estimated Measure Code	String	6	8
10	J	WS Manager ID	String	15	16
11	K	*Type of Transaction	Drop-Down List 1 = All 2 = Inventory Item 3 = Vendor ID 4 = Purchase Order	1	1
12	L	Posting Status	Integer	5	5
13	M	Change Order Estimated Units	Currency	14	14
14	N	CO Estimated Amt/Units	Currency	14	14
15	O	Change Order Estimated Costs	Currency	14	14
16	P	Scheduled Completion Date	Date	6	6
17	Q	Schedule Start Date	Date	6	6
18	R	Vendor Number	String	25	26
19	S	Inventory Item Number	String	20	22
20	T	Purchase Order Number	String	20	22