Billing Codes Master File
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 |