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 (.txt file) |
Excel Column (.csv file) |
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 |