Skip to main content
Procore

CMiC Detailed Data Mapping

Overview


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC

STANDARD COST CODES & COST TYPES

 

tri-left-arrow-green.png

MASTER COST CODES & CATEGORIES

COMPANIES

tri-right-arrow-orange.png

tri-left-arrow-green.png

BUSINESS PARTNERS/VENDORS

PROJECTS

 

tri-left-arrow-green.png

CONTROL JOBS

SUB JOBS

 

tri-left-arrow-green.png

JOBS


BUDGET

BUDGET MODIFICATIONS

ESTIMATED COST AT COMPLETION

tri-right-arrow-orange.png

tri-right-arrow-orange.png

tri-right-arrow-orange.png

tri-left-arrow-green.png


BUDGETED COST AMOUNT

UPDATES CURRENT BUDGET AMOUNT

PROJECTED COST

COMMITMENTS

tri-right-arrow-orange.png

 

SUBCONTRACTS

COMMITMENT CHANGE ORDERS

tri-right-arrow-orange.png

 

SUBCONTRACT CHANGE ORDERS

SUBCONTRACTOR INVOICES

tri-right-arrow-orange.png

 

REQUEST FOR PAYMENT

PRIME CONTRACT

 

tri-left-arrow-green.png

PRIME CONTRACT

PRIME CONTRACT CHANGE ORDERS

tri-right-arrow-orange.png

 

POTENTIAL CHANGE ITEM (PCI)

JOB-TO-DATE COSTS

 

tri-left-arrow-green.png

JOB COSTS

 

 

Projects/Jobs


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC
CMIC ID   tri-left-arrow-green.png Project Code
Project Name   tri-left-arrow-green.png Project Name
Address   tri-left-arrow-green.png Address 1
City   tri-left-arrow-green.png City
State   tri-left-arrow-green.png State
ZIP   tri-left-arrow-green.png Zip
Cost Code
Code/Description
  tri-left-arrow-green.png Cost Code
Code/Description
Cost Type
Code/Description
  tri-left-arrow-green.png Category
Code/Description
Start Date   tri-left-arrow-green.png Begin Date
Completion Date   tri-left-arrow-green.png End Date

Sub Jobs


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC
Sub Job Code   tri-left-arrow-green.png Project Code
Sub Job Name   tri-left-arrow-green.png Project Name
Cost Code
 
  tri-left-arrow-green.png Cost Code
 
Cost Type
 
  tri-left-arrow-green.png Category
 

Vendors

When Companies in Procore are exported to CMiC they will create a Business Partner and Vendor record. Below is a table that displays the field mapping between these records. 


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC

ERP Vendor ID1

tri-right-arrow-orange.png tri-left-arrow-green.png Vendor Code/Business Partner Code
Name tri-right-arrow-orange.png tri-left-arrow-green.png Vendor Name/Business Partner Code
Address tri-right-arrow-orange.png tri-left-arrow-green.png Street/Address
City tri-right-arrow-orange.png tri-left-arrow-green.png City
State tri-right-arrow-orange.png tri-left-arrow-green.png State/Province
ZIP tri-right-arrow-orange.png tri-left-arrow-green.png Zip/Post Code
Business Phone tri-right-arrow-orange.png tri-left-arrow-green.png Phone
Business Fax tri-right-arrow-orange.png tri-left-arrow-green.png Fax
Email Address tri-right-arrow-orange.png tri-left-arrow-green.png E-mail
Website tri-right-arrow-orange.png tri-left-arrow-green.png Web Site

1 Export note: The ERP Vendor ID is entered manually by an accounting approver when a company is exported from Procore to CMiC. This is stored as the ERP Vendor ID (you can view it in the company-level ERP Integrations tool  under Vendors or in the company-level Directory tool) and is then used on other vendor related exports (Commitments, Commitment CO’s).

Budgets


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC
Original Budget tri-right-arrow-orange.png tri-left-arrow-green.png Original Estimate
Cost Code tri-right-arrow-orange.png tri-left-arrow-green.png Cost Code
Cost Type tri-right-arrow-orange.png tri-left-arrow-green.png Cost Type

Budget Modifications

 


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC
Project tri-right-arrow-orange.png   Job
Project Name tri-right-arrow-orange.png   Job Name
From/To tri-right-arrow-orange.png   Cost Code ID
From/To tri-right-arrow-orange.png   Cost Code Name
From/To tri-right-arrow-orange.png   Cost Type ID
From/To tri-right-arrow-orange.png   Cost Type Name
Amount tri-right-arrow-orange.png   Transfer Amount

 

Forecasting/Projections


PROCORE
Exports data from Procore to CMiC Imports data from CMiC to Procore

CMiC

Cost Code tri-right-arrow-orange.png   Phase
Cost Type tri-right-arrow-orange.png   Cost Type
Estimated Cost at Completion1 tri-right-arrow-orange.png   Projected Cost

To export Estimated Cost at Completion values you must first enable the feature. See Integration by Procore: How do I export cost forecast data from a Procore budget to CMiC?

Commitments


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC
Commitment Header     Commitment Header
External ID tri-right-arrow-orange.png   Document Number
Commitment Type1 tri-right-arrow-orange.png   Transaction Type
Contract Company2 tri-right-arrow-orange.png   Vendor
Date Created tri-right-arrow-orange.png   Date
Title tri-right-arrow-orange.png   Message
Default Retainage tri-right-arrow-orange.png   Default Retainage Percentage
Commitment Item (Purchase Orders)     Commitment Item
Qty tri-right-arrow-orange.png   Quantity
UOM tri-right-arrow-orange.png   Unit
Unit Cost tri-right-arrow-orange.png   Price
Contract Amount or Subtotal tri-right-arrow-orange.png   Amount
Commitment Item (Subcontracts)     Commitment Item
Job ID tri-right-arrow-orange.png   Project
Cost Code tri-right-arrow-orange.png   Tasks
Type tri-right-arrow-orange.png   Category
UOM4 tri-right-arrow-orange.png   Unit
Unit Cost4 tri-right-arrow-orange.png   Price
Contract Amount or Subtotal tri-right-arrow-orange.png   Amount

1 When a commitment is created in Procore you must select a type, Purchase Order or Subcontract. This is used as the commitment type for CMiC.

2 The ERP Vendor ID associated with the Contract Company is used on the import file for CMiC. You cannot export a commitment for a Contract Company that does not have an ERP Vendor ID.

4 Subcontracts that are using the Accounting Method of "Unit/Quantity Based" will have these on the Schedule Of Values.

Commitment Change Orders

When entering the SOV for a Commitment Change Order in Procore, you have the option of selecting an existing line item, or entering a new line item.


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC
Commitment Change Order Header     Commitment Change Order Header
Title tri-right-arrow-orange.png   Message
System Date at Time of Export tri-right-arrow-orange.png   Date
Change Order Number tri-right-arrow-orange.png   External Reference No
Commitment Change Order Item
(Purchase Order or Unit/Quantity Based Subcontract)
    Commitment Change Order Item
Item ID1      
Qty tri-right-arrow-orange.png   Unit
Contract Amount or Subtotal tri-right-arrow-orange.png   Extended Price
Commitment Change Order Item
(When New Line Item is Selected Entering the SOV on the CCO)
    Commitment Change Order Item
CMiC ID tri-right-arrow-orange.png   Item ID
Qty2 tri-right-arrow-orange.png   Quantity
Unit Cost2 tri-right-arrow-orange.png   Unit Cost
UOM2 tri-right-arrow-orange.png   Unit
Contract Amount or Subtotal3 tri-right-arrow-orange.png   Extended Price

1 This field gets pulled from the Cost Type.

2Typically Quantity, Units and Unit Cost are only used on Purchase Orders.

3The field is titled Contract Amount when working in a Subcontract, and it is titled Subtotal when working in a Purchase Order.

Job Costs

Import from CMiC only. Cost information is retrieved from CMiC for each Cost Code/Type on Synced projects for use in 2 locations in Procore, the Budget and the Job Costs report. Job Cost information can be synced in either the ERP Integrations tool under the Job Costs sub-tab or within the Project Admin tool under Work Breakdown Structure, within Cost Codes there is a "Refresh Cost Codes" button. 


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC
Budget      
JTD Cost   tri-left-arrow-green.png JTD Cost
Direct Costs   tri-left-arrow-green.png JTD Cost - Commitment Invoiced1
Job Costs Report      
Cost Code   tri-left-arrow-green.png Cost Code
Cat.   tri-left-arrow-green.png Cost Type
Original Budget   tri-left-arrow-green.png Original Budget
Commitment Invoiced   tri-left-arrow-green.png Commitment Invoiced
Job to Date Cost   tri-left-arrow-green.png JTD Cost

1This is a calculated column that displays the difference between the two database fields in CMiC.

 

Subcontractor Invoices

PROCORE

Exports data from Procore to CMiC 

Imports data from CMiC  to Procore

CMiC

Subcontractor Invoice     Invoice Header

Contract Company

tri-right-arrow-orange.png

 

Vendor Name

ERP ID1

tri-right-arrow-orange.png

 

Invoice Code

Description2

tri-right-arrow-orange.png  

Description

Billing Date

tri-right-arrow-orange.png

 

Invoice Date

Total Completed and Stored to Date

tri-right-arrow-orange.png

 

Original Invoice Amount

Total Retainage

tri-right-arrow-orange.png  

Retainage Amt

Accounting Date3

tri-right-arrow-orange.png

 

Post Date

      Distributions

Commitment #

tri-right-arrow-orange.png

 

Contract

Project #

tri-right-arrow-orange.png

 

Job/EQP/WO

Sub Job #

tri-right-arrow-orange.png

 

Job/EQP/WO

Cost Code

tri-right-arrow-orange.png

 

Phase/Component/WI

Category

tri-right-arrow-orange.png  

Cat/Component/WI

Description of Work

tri-right-arrow-orange.png

 

Description

Work Completed this Period

tri-right-arrow-orange.png  

Amount

Work Retainage

tri-right-arrow-orange.png  

Retainage

1 The Invoice Number from the Subcontractor Invoice entered in Procore will prefill into the ERP ID field on the Ready to Export screen in the ERP Integrations tool under Subcontractor Invoices, however the accounting approver can modify this before the Invoice is exported from Procore to CMiC. The value that was entered in the ERP ID field at the time of export is stored as the CMiC ID (you can view it in the Synced section under in the ERP Integrations tool under  Subcontractor Invoices).

The description for an invoice that will be created in CMiC can be entered  into the Description field by an accounting approver on the Ready to Export screen in the ERP Integrations tool under Subcontractor Invoices. If no description is entered at the time of export the Description field will be blank on the invoice created in CMiC. 

3 This is filled automatically based on the Billing Date of the Invoice in Procore, but can be overridden at the time of export on the Ready to Export screen in the ERP Integrations tool under Subcontractor Invoices.

Prime Contracts


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC
Prime Contract     Job/Contract/Budget
Title   tri-left-arrow-green.png Job Code + Prime Contract
#   tri-left-arrow-green.png Job #
Status   tri-left-arrow-green.png Approved
Description   tri-left-arrow-green.png Job Code + Message
Original Contract Amount   tri-left-arrow-green.png Total Budgeted Revenue Amount
Prime Contract Schedule of Values     Contract/Enter Budget
Budget Code (Cost Code)   tri-left-arrow-green.png Cost Code
Budget Code (Cost Type)   tri-left-arrow-green.png Category
Description   tri-left-arrow-green.png Cost Code Description
Amount   tri-left-arrow-green.png Budgeted Revenue Amount
       

Prime Contract Change Orders


PROCORE
Exports data from Procore to CMiC  Imports data from CMiC  to Procore
CMiC
PCCO     PCI/OBO
Project Number tri-right-arrow-orange.png   Job Code
Title tri-right-arrow-orange.png   Name
Transaction Date tri-right-arrow-orange.png   Reference Date
PCCO Number tri-right-arrow-orange.png   PCI Code
Description tri-right-arrow-orange.png   Scope Description
Amount tri-right-arrow-orange.png   Bill Amount
Cost Code tri-right-arrow-orange.png   Code
Unit of Measurement tri-right-arrow-orange.png   Budget WM Code
Line Item Type tri-right-arrow-orange.png   Category Code
Ext Amount tri-right-arrow-orange.png   Budget Amount

See Also