CMiC Detailed Data Mapping

Overview

Projects/Jobs

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

Sub Jobs

PROCORE	Exports data from Procore to CMiC	Imports data from CMiC  to Procore	CMiC
Sub Job Code			Project Code
Sub Job Name			Project Name
Cost Code			Cost Code
Cost Type			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			Vendor Code/Business Partner Code
Name			Vendor Name/Business Partner Code
Address			Street/Address
City			City
State			State/Province
ZIP			Zip/Post Code
Business Phone			Phone
Business Fax			Fax
Email Address			E-mail
Website			Web Site

¹ 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			Original Estimate
Cost Code			Cost Code
Cost Type			Cost Type

Budget Modifications

PROCORE	Exports data from Procore to CMiC	Imports data from CMiC  to Procore	CMiC
Project			Job
Project Name			Job Name
From/To			Cost Code ID
From/To			Cost Code Name
From/To			Cost Type ID
From/To			Cost Type Name
Amount			Transfer Amount

Forecasting/Projections

PROCORE	Exports data from Procore to CMiC	Imports data from CMiC to Procore	CMiC
Cost Code			Phase
Cost Type			Cost Type
Estimated Cost at Completion1			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			Document Number
Commitment Type1			Transaction Type
Contract Company2			Vendor
Date Created			Date
Title			Message
Default Retainage			Default Retainage Percentage
Commitment Item (Purchase Orders)			Commitment Item
Qty			Quantity
UOM			Unit
Unit Cost			Price
Contract Amount or Subtotal			Amount
Commitment Item (Subcontracts)			Commitment Item
Job ID			Project
Cost Code			Tasks
Type			Category
UOM4			Unit
Unit Cost4			Price
Contract Amount or Subtotal			Amount

¹ 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.

² 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.

⁴ 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			Message
System Date at Time of Export			Date
Change Order Number			External Reference No
Commitment Change Order Item (Purchase Order or Unit/Quantity Based Subcontract)			Commitment Change Order Item
Item ID1
Qty			Unit
Contract Amount or Subtotal			Extended Price
Commitment Change Order Item (When New Line Item is Selected Entering the SOV on the CCO)			Commitment Change Order Item
CMiC ID			Item ID
Qty2			Quantity
Unit Cost2			Unit Cost
UOM2			Unit
Contract Amount or Subtotal3			Extended Price

¹ This field gets pulled from the Cost Type.

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

³The 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			JTD Cost
Direct Costs			JTD Cost - Commitment Invoiced1
Job Costs Report
Cost Code			Cost Code
Cat.			Cost Type
Original Budget			Original Budget
Commitment Invoiced			Commitment Invoiced
Job to Date Cost			JTD Cost

¹This 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			Vendor Name
ERP ID1			Invoice Code
Description2			Description
Billing Date			Invoice Date
Total Completed and Stored to Date			Original Invoice Amount
Total Retainage			Retainage Amt
Accounting Date3			Post Date
			Distributions
Commitment #			Contract
Project #			Job/EQP/WO
Sub Job #			Job/EQP/WO
Cost Code			Phase/Component/WI
Category			Cat/Component/WI
Description of Work			Description
Work Completed this Period			Amount
Work Retainage			Retainage

¹ 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. 

³ 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			Job Code + Prime Contract
#			Job #
Status			Approved
Description			Job Code + Message
Original Contract Amount			Total Budgeted Revenue Amount
Prime Contract Schedule of Values			Contract/Enter Budget
Budget Code (Cost Code)			Cost Code
Budget Code (Cost Type)			Category
Description			Cost Code Description
Amount			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			Job Code
Title			Name
Transaction Date			Reference Date
PCCO Number			PCI Code
Description			Scope Description
Amount			Bill Amount
Cost Code			Code
Unit of Measurement			Budget WM Code
Line Item Type			Category Code
Ext Amount			Budget Amount

See Also 

• About Procore + CMiC