The ToolWatch CMiC integration will periodically deliver CSV files for the customer to import into CMiC. For each batch of posted, tool-related Job Costs in ToolWatch, two files are delivered: the main job-cost import file described below, and a second "unmapped charges" file listing any postings that could not be sent to CMiC (for example, because their Cost Center was not mapped to a CMiC Job). The files are delivered via download links in an email, which is automatically sent out after each ToolWatch posting.
The CSV file contains all the relevant ToolWatch and CMiC data necessary in order to bring the charges back into CMiC. Specifically, the CSV file corresponds to CMiC's Job Transaction Multi Company Import utility (control file JCFBCHLM.ctl).
Field Number | Field | Description |
1 | FBH_JC_COMP_CODE | Company Code. Configurable during integration setup |
2 | FBH_JC_DSRC_COMP_CODE | Source Company. Same as Company Code |
3 | FBH_JC_DIST_TYPE_CODE | Disbursement Type. 'J' for Job Cost. 'G' for GL Offset 'E' for Equipment |
4 | FBH_JC_SRC_CODE | Source Code. For Job Cost (type 'J') entries, this will be set to the ToolWatch Tool, Equipment or Material Item Number. For equipment (type 'E') transactions, this will be set to the equipment code. |
5 | FBH_JC_SRC_DESC | Source Description. For Job Cost (type 'J') entries, this will be set to the ToolWatch Tool, Equipment or Material Model Description. For equipment (type 'E') transactions, this will be set to the equipment description. |
6 | FBH_JC_REF_CODE | Left Blank |
7 | FBH_JC_REF_DESC | Used for GL Offset only. Will be 'ToolWatch JC Foreign Batch Offset' |
8 | FBH_JC_JOB_CODE | Job Code. Will be matching CMiC Job Code for Job linked to ToolWatch Cost Center by integration |
9 | FBH_JC_PHS_CODE | Phase Code. The matching CMiC Phase code for the Phase linked to the ToolWatch Cost Code. This may be a job-linked Phase Code or a CMiC master/global phase code (see Master (Global) Phase Codes in the Data Mapping). |
10 | FBH_JC_CAT_CODE | Category Code. Configurable during integration setup for tools and materials. |
11 | FBH_JC_DEPT_CODE | Used for GL Offset only. Configurable during integration setup. |
12 | FBH_JC_ACC_CODE | Used for GL Offset only. Configurable during integration setup. |
13 | FBH_JC_REF_DATE | Left blank |
14 | FBH_JC_AMT | The total amount of the transaction. |
15 | FBH_JC_UNIT | The quantity for the item billed |
16 | FBH_JC_WM_CODE | Weight/Measure Code. <br><br> If a Weight/Measure code is provided, then that value will used here, and furthermore the FBH_JC_UNIT field will be populated with the total quantity of "units" represented in the total FBH_JC_AMT amount. <br> <br> If a Weight/Measure code is not provided, then the FBH_JC_UNIT field will be set to 1, and this field in the export will be populated with the value "NA". |
17 | FBH_JC_WBSV_CODE1 | Left blank |
18 | FBH_JC_WBSV_CODE2 | Left blank |
19 | FBH_JC_WBSV_CODE3 | Left blank |
20 | FBH_JC_WBSV_CODE4 | Left blank |
21 | FBH_JC_EQP_CODE | Used for equipment holds the CMIC equipment code |
22 | FBH_JC_TRANCODE_CODE | Used for equipment export, transaction type "E". Configurable during integration setup. |
23 | FBH_JC_COMPON_CODE | Used for equipment export, transaction type "E". Configurable during integration setup. |
24 | FBH_JC_TAV_CODE1 | Left blank |
25 | FBH_JC_TAV_CODE2 | Left blank |
26 | FBH_JC_TAV_CODE3 | Left blank |
27 | FBH_JC_TAV_CODE4 | Left blank |
28 | FBH_JC_JOB_LONG_CODE | Left blank |
29 | FBH_OVERRIDE_BILL_AMT | Left blank |
30 | FBH_OVERRIDE_BILL_RATE | Left blank (amount calculated in ToolWatch) |
31 | FBH_OVERRIDE_TRADE_CODE | Left blank (amount calculated in ToolWatch) |
32 | FBH_POST_DATE | Post Date of the transaction in ToolWatch DD-MON-YYYY |
33 | FBH_JC_PHASE_NAME | Left blank |
34 | FBH_JC_PHS_CTRL_CODE | Left blank |