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.
Note: 'WS Account Index 1' (20,T) must be validated if using the Cost Code posting option.Tab Position
Excel Column
Field Name
Storage Type
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 Order1
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