Import File: JCBC0001.CSV (Comma) or JCBC0001.TXT (Tab)
Warehouse File: JC_Billing_Codes_MSTR_IMP_WHSE
Destination File: JC_Billing_Codes_MSTR (JC00601)
- 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
*Bill Code Description
String
30
32
3
C
*Bill Code Number
String
26
28
4
D
*Cost Element
Integer
3
3
5
E
*Total Billable Amount
Currency
14
14
6
F
Bill %
Integer
5
5