Detailed Data Mapping
Overview
PROCORE | Exports data from Procore to Viewpoint® Spectrum® | Imports data from Viewpoint® Spectrum® to Procore | Viewpoint® Spectrum® |
|---|---|---|---|
PROJECTS |
|
| JOBS |
PROJECT COST CODES 1 COST TYPES |
|
| PHASES COST TYPES |
STANDARD COST CODES 1,2 STANDARD COST TYPE |
| PHASE CATEGORY > PHASES COST TYPE | |
COMPANIES 6 |
|
| VENDORS |
BUDGETS 5 |
|
| ESTIMATES |
BUDGET CHANGES (NEW) 3 BUDGET MODIFICATIONS (LEGACY) 3 |
| REVISIONS | |
FORECASTING 4 |
| JOB COST PROJECTIONS | |
COMMITMENTS |
| SUBCONTRACTS | |
COMMITMENT CHANGE ORDERS |
| SUBCONTRACT CHANGE ORDERS | |
JOB COSTS |
| JOB COSTS | |
PRIME CONTRACT |
| PRIME CONTRACT | |
PRIME CONTRACT CHANGE ORDERS |
| AR CHANGE REQUESTS |
1Custom WBS Segments are NOT supported.
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.
3The Integration by Procore syncs budget modifications created in Procore to Viewpoint® Spectrum®. See Can I export Procore budget modifications to an integrated ERP system?
4Exports the 'Estimated Cost at Completion' values from a Procore budget to Viewpoint® Spectrum®. See How do I export cost forecast data from a Procore Budget to ERP?
5Budgets containing line items with $0 values can be exported from Procore to Viewpoint® Spectrum® .
6Import companies by type, including those without a specified company type from Viewpoint® Spectrum® to Procore.
Projects/Jobs
PROCORE | Exports data from Procore to Viewpoint® Spectrum® | Imports data from Viewpoint® Spectrum® to Procore | Viewpoint® Spectrum® |
|---|---|---|---|
Project Number1 |
|
| Job Code |
Project Name |
|
| Job Description |
Address City State ZIP |
|
| Job Address |
Job Template2 |
|
| Division Cost Center Customer Price Type Taxable |
1 Export note: The Spectrum Job ID is entered manually by an accounting approver when a project is exported from Procore to Viewpoint® Spectrum®. This may, or may not, depending on what the accounting approver has entered, match the Job Number found in Procore under the project-level Admin tool. This is stored as the Spectrum Job ID (you can view it in the company-level ERP Integrations tool under the Synced section of Jobs) and is then used on other project related exports such as Budgets, commitments etc... Import note: If the job is imported from Viewpoint® Spectrum®, the job ID will automatically populate in the project number field.
2 When exporting a job to Viewpoint® Spectrum®, the accounting approver must select a job template. Job templates are projects that have been setup in Viewpoint® Spectrum® that contain the word 'Template' in the job description.
Cost Codes
PROCORE | Exports data from Procore to Viewpoint® Spectrum® | Imports data from Viewpoint® Spectrum® to Procore | Viewpoint® Spectrum® |
|---|---|---|---|
Project Code Code |
|
| Phase |
Project Code Code Description |
|
| Phase Description |
Cost Type |
|
| Cost Type |
Note: Custom WBS Segments are NOT supported.
Companies/Vendors
PROCORE | Exports data from Procore to Viewpoint® Spectrum® | Imports data from Viewpoint® Spectrum® to Procore | Viewpoint® Spectrum® |
|---|---|---|---|
Company Name |
|
| Name |
Company Address |
|
| Address |
Company Business Phone |
|
| Telephone |
Company Business Fax |
|
| Fax |
Company Email Address |
|
| Vendor E-mail |
Vendor Type1 |
|
| Vendor Type |
Vendor ID1 |
|
| Vendor Code |
1 The ERP Vendor Type and the ERP Vendor ID are entered manually by an accounting approver when a company is exported from Procore to Viewpoint® Spectrum®. The Vendor ID entered during export is stored as the ERP Vendor ID (you can view it under Company > ERP Integrations > Vendors > Synced, or under Company > Directory) and is then used on other vendor related exports (Commitments, Commitment CO’s).
Budgets
When a Budget is exported from Procore to Viewpoint® Spectrum®, the Original Estimated Cost on Viewpoint® Spectrum® is updated.
PROCORE | Exports data from Procore to Viewpoint® Spectrum® | Imports data from Viewpoint® Spectrum® to Procore | Viewpoint® Spectrum® |
|---|---|---|---|
Code Code |
|
| Phase |
Cost Type |
|
| Cost Type |
Original Budget Amount |
|
| Original Cost |
Budget Modifications
When a Budget Modification is exported from Procore to Viewpoint® Spectrum®, a Change Request (using your Change Request Status Code 'C' ) is created in Viewpoint® Spectrum® and a Change Request Number is automatically created within Viewpoint® Spectrum®.
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 Viewpoint® Spectrum® | Imports data from Viewpoint® Spectrum® to Procore | Viewpoint® Spectrum® |
|---|---|---|---|
Cost Code |
| Phase | |
Category |
| Cost Type | |
Budget Modification Amount |
| Estimate Amount | |
Budget Modification Notes |
| Notes |

