Cost Code Master File | WennSoft Documentation

Import File: JCCC0001.CSV (Comma) or JCCC0001.TXT (Tab)
Warehouse File: JC_Cost_Codes_MSTR_IMP_WHSE
Destination File: JC_Cost_Codes_MSTR (JC40202)

*Indicates validated fields, and must contain data.

'WS Account Index 1' (20,T) must be validated if using the Cost Code posting option.

Tab Position (.txt file)	Excel Column	Field Name	Storage Typ	Keyable	Storage
1	A	*Cost Code Number1	Composite
2	B	*Cost Code Number 2	Composite
3	C	*Cost Code Number 3	Composite
4	D	*Cost Code Number 4	Composite
5	E	*Cost Code Description	String	30	32
6	F	*Cost Element	Integer	2	2
7	G	*Profit Type Number	Integer	2	2
8	H	*Profit Amount	Currency	14	16
9	I	Estimated Measure Code	String	6	8
10	J	Production Measure Code	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	Workers Comp	String	6	8
13	M	Estimated Amt/Units	Currency	14	14
14	N	Cost Code Estimated Cost	Currency	14	14
15	O	Cost Code Rvsd Estimated Cost	Currency	14	14
16	P	Production Estimate Qty	Currency	14	14
17	Q	Production Qty/Unit	Currency	14	14
18	R	Vendor Number	String	25	26
19	S	Item Number	String	30	32
20	T	WS Account Index 1	Long Integer	14	14