Import File: JCJD0001.CSV (Comma) or JCJD0001.TXT (Tab)
Warehouse File: JC_Job_Detail_MSTR_IMP_WHSE
Destination File: JC_Job_Detail_MSTR (JC00701)
- Indicates validated fields, and must contain data.
- Indicates validated, but can be left empty.
Note: 'Labor Group Name' (42, AP) must be validated if a 'Profit Type Number' (9,I) of 9 is entered.
'WS Account Index 1' (43, AQ) must be validated if using the Cost Code posting option.
The Change Order Estimate Cost (U) and Change Order Estimate Units (AC) should be empty when importing this file.Tab Position
Excel Column
Field Name
Storage Type
Keyable
Storage
1
A
*WS Job Number
String
17
18
2
B
Project Number
String
17
18
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
*Profit Type Number
Integer
2
2
10
J
*Profit Amount
Currency
14
14
11
K
WS Manager ID
String
15
16
12
L
Estimated Measure Code
String
6
8
13
M
Production Measure Code
String
6
8
14
N
*Type of Transaction
Drop-Down List
1 = All
2 = Inventory Item
3 = Vendor ID
4 = Purchase Order1
1
15
O
Workers Comp
String
6
8
16
P
Track Production Qty
Check Box
1
2
17
Q
Production Estimate Qty
Currency
14
14
18
R
Production Qty/Unit
Currency
14
14
19
S
Production Best
Currency
12
12
20
T
Cost Code Estimated Cost
Currency
14
14
21
U
Change Order Estimated Cost
Currency
14
14
22
V
Cost Code Rvsd Estimated Cost
Currency
14
14
23
W
Original Estimate Units
Currency
14
14
24
X
Cost Code Estimated Units
Currency
14
14
25
Y
Estimated Amt/Units
Currency
14
14
26
Z
Scheduled Completion Date
Date
6
6
27
AA
Scheduled Start Date
Date
6
6
28
AB
Field % Complete
Integer
5
5
29
AC
Change Order Estimated Units
Currency
14
14
30
AD
User Define 1
String
30
32
31
AE
User Define 2
String
30
32
32
AF
User Defined 1
String
20
22
33
AG
User Defined 2
String
20
22
34
AH
User Defined Dollar 1
Currency
14
14
35
AI
User Defined Dollar 2
Currency
14
14
36
AJ
User Defined Date 1
Date
8
8
37
AK
User Defined Date 2
Date
8
8
38
AL
Vendor Number
String
25
26
39
AM
Item Number
String
30
32
40
AN
Purchase Order Number
String
20
22
41
AO
Rate Per Unit
Currency
14
14
42
AP
**Labor Group Name
String
15
16
43
AQ
WS Account Index 1
Long Integer
14
14
- Indicates validated, but can be left empty.