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 |
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 |