Cost Code Master File
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 | 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 |