Import File: JCJM0001.CSV (Comma) or JCJM0001.TXT (Tab)
Warehouse File: JC_Job_MSTR_IMP_WHSE
Destination File: JC_Job_MSTR (JC00102)
Note: The 'WS Job Number' field has a maximum length of 17 characters. Job numbers longer than this will be cut off.
Note: If you are importing a certified payroll job, enter "1" in the 'Certified Payroll' field. If the job is not certified payroll, leave this field blank.
- Indicates validated fields, and must contain data.
Tab Position
Excel Column
Field Name
Storage Type
Keyable
Storage
1
A
*WS Job Number
String
17
18
2
B
*WS Job Name
String
30
32
3
C
Project Number
String
17
18
4
D
*Divisions
String
15
16
5
E
*Customer Number
String
15
16
6
F
*Job Address Code
String
15
16
7
G
*Job Billto Address Code
String
15
16
8
H
Estimator ID
String
15
16
9
I
WS Manager ID
String
15
16
10
J
Contract Type
Drop-Down List
1 = Fixed Amount
2 = Cost Plus
3 = Cost Plus NTE1
1
11
K
WS Billing Type
Drop-Down List
1 = Standard
2 = User Defined
3 = Cost Code
4 = Trx. Level
5 = Project Billing
6 = SOP
7 = Project Bill Code
8 = Project Trx. Level
9 = Project Allocated Revenue1
1
12
L
*Tax Schedule ID
String
15
16
13
M
Suta State
String
2
4
14
N
Local Tax
String
6
8
15
O
Rate Class
String
15
16
16
P
Bid Due Date
Date
6
6
17
Q
Schedule Start Date
Date
6
6
18
R
Scheduled Completion Date
Date
6
6
19
S
JC Contract Number
String
15
16
20
T
Original Contract Amount
Currency
14
14
21
U
Contract Maximum Bill Amount
Currency
14
14
22
V
Retention %
Currency
14
14
23
W
Tax Exempt Number
String
15
16
24
X
Certified Payroll
Check Box
1
2
25
Y
WS Inactive
Check Box
1
2
26
Z
User Define 1
String
30
32
27
AA
User Define 2
String
30
32
28
AB
User Defined 1
String
20
22
29
AC
User Defined 2
String
20
22
30
AD
User Defined Dollar 1
Currency
14
14
31
AE
User Defined Dollar 2
Currency
14
14
32
AF
User Defined Date 1
Date
8
8
33
AG
User Defined Date 2
Date
8
8