Detailed Data Mapping
Overview
PROCORE | Exports data from Procore to CMiC | Imports data from CMiC to Procore | CMiC |
|---|---|---|---|
COMPANY LEVEL WBS CODES 1,2 COST CODES & COST TYPES |
| MASTER COST CODES & CATEGORIES | |
PROJECT WBS CODES1,2 COST CODES & COST TYPES |
|
| COST CODES & CATEGORIES |
COMPANIES6 CUSTOMERS |
|
| BUSINESS PARTNERS/VENDORS CUSTOMERS |
PROJECTS |
|
| CONTROL JOBS |
SUB JOBS |
| JOBS | |
BUDGET 5 |
|
| BUDGETED COST AMOUNT |
BUDGET MODIFICATIONS (LEGACY) OR BUDGET CHANGES (NEW) |
| UPDATES CURRENT BUDGET AMOUNT POTENTIAL CHANGE ITEM (PCI) | |
**COST FORECAST DATA3 |
| PROJECTED COST | |
COMMITMENTS |
| SUBCONTRACTS | |
COMMITMENT CHANGE ORDERS |
| SUBCONTRACT CHANGE ORDERS | |
SUBCONTRACTOR INVOICES |
| REQUEST FOR PAYMENT | |
SUBCONTRACT INVOICE PAYMENTS4 |
|
| PAYMENTS |
PRIME CONTRACT |
| PRIME CONTRACT | |
PRIME CONTRACT CHANGE ORDERS7,8 |
| POTENTIAL CHANGE ITEM (PCI) OR OWNER CHANGE ORDER (OCO) | |
JOB-TO-DATE COSTS |
| JOB COSTS |
1Custom WBS segments are NOT supported at this time
2Project level cost codes must be added to the project from the Company level ERP Standard Cost Code List. New cost codes must be created in your ERP system, and cannot be created in Procore.
3Exports the ‘Estimated Cost at Completion' and ‘Forecast to Complete' values from a Procore budget to CMiC
4Export of payment records from Procore to CMiC is only supported for customers in the United States who license Procore Pay.
5Budgets containing line items with $0 values can be exported from Procore to CMiC .
6Import companies by type, including those without a specified company type from CMiC to Procore.
7PCCO with multiple linked PCOs can be exported as individual PCIs to CMiC. See Export a PCCO with Multiple PCOs as Individual PCIs to CMiC.
18PCCOs can be exported as OCOs to CMiC. See Export a PCCO as an OCO to CMiC.
Projects/Jobs
Exporting a Procore project to CMiC creates a 'project' in CMiC, but not a 'job'. You must create a job manually in CMiC after exporting your Procore project through the integration.
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 Code1,2,5 Code/Description |
| Cost Code Code/Description | |
Cost Type5 Code/Description |
| Category Code/Description | |
Start Date |
|
| Begin Date |
Completion Date |
|
| End Date |
Company ID 3, 4 |
|
| Company ID |
1Project level cost codes must be added to the project from the Company level ERP Standard Cost Code List. New cost codes must be created in your ERP system, and cannot be created in Procore.
2Cost codes added to a job in CMiC after the job is synced with Procore can be added to the project in Procore by clicking 'Refresh Cost Codes' in the Project level Admin tool's Work Breakdown Structure (WBS) cost code section. If multicompany is enabled, a specific company ID will be assigned to multicompany projects during the import and export of jobs in Procore.
3If multicompany is enabled, a specific company ID will be assigned to multicompany projects during the import and export of jobs in Procore.
4Once a project is synced as a multicompany project, all downstream transactions such as contracts, invoices, and more will automatically sync with the specific company.
5Cost codes and cost types are synced with Procore projects when importing jobs to Procore, exporting jobs from Procore, resending projects to CMiC, and exporting budgets to Procore.
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. Additionally, when companies identified as a Customer in CMiC are imported to Procore, the integration will create a Company record in the Company Directory. 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 Code2 |
Address |
|
| Street/Address |
City |
|
| City |
State |
|
| State/Province |
ZIP |
|
| Zip/Post Code |
Business Phone |
|
| Phone |
Business Fax |
|
| Fax |
Email Address |
|
| |
Website |
|
| Web Site |
EIN 5 |
| Registration Code | |
Customers | Customers | ||
ERP Vendor ID3,4 |
| Customer 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 |
| ||
Website |
| 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).2 If a Vendor has a masked Vendor Class or masked JcdtSrcCode in Boomi, it will not appear in the Ready to Import filter list.
3 Import note: 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).
4 Export note: When Companies in Procore are exported to CMiC they will create a Business Partner and Vendor record. Business partner records must be manually assigned as a Customer in CMiC.
5 Include the Employer Identification Number (EIN) of a vendor when importing their record to the Procore directory. Note: Procore currently supports CMiC Registration Codes in US EIN format only.
Budgets
Original Budget Amounts/Pending Original Budget edits are exported to CMiC as a PCI Type. The PCI will export over with an "Approved" status and will need to be posted in CMiC.
PROCORE | Exports data from Procore to CMiC | Imports data from CMiC to Procore | CMiC |
|---|---|---|---|
Original Budget |
|
| Original Estimate |
Cost Code 1 |
|
| Cost Code |
Cost Type 1 |
|
| Categories |
1To sync previously unused project level cost codes to CMiC, you must add a cost budget line item to the Budget in Procore using that code. Syncing is automatic following addtion of cost budget line items.
Budget Modifications (Legacy)
Phased Release: Budget Changes
Some ERP integrated clients may have already transitioned from Budget Modifications (Legacy) to the new Budget Changes experience. The legacy experience will continue to be available until November 2024. To learn more about the timeline for migration, see Common Questions.
Choosing to use the new Budget Changes experience will not impact the function of your ERP integration. You should still thoroughly review the available documentation before migrating to the new experience. We recommend you also discuss any concerns or questions about migrating your Budget Modifications to Budget Changes with your Procore point of contact.
To learn more about the new Budget Changes experience, see About Budget Changes.
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 |


