Detailed Data Mapping
Overview
PROCORE | Exports data from Procore to Viewpoint® Spectrum® | Imports data from Viewpoint® Spectrum® to Procore | Viewpoint® Spectrum® |
|---|---|---|---|
|
| JOBS | |
PROJECT COST CODES 1 COST TYPES |
|
| PHASES |
STANDARD COST CODES 1,2 STANDARD COST TYPE |
| PHASE CATEGORY > PHASES | |
|
| VENDORS | |
BUDGETS 5 |
|
| ESTIMATES |
| REVISIONS | ||
| JOB COST PROJECTIONS | ||
| SUBCONTRACTS | ||
| SUBCONTRACT CHANGE ORDERS | ||
| JOB COSTS | ||
| PRIME CONTRACT | ||
| AR CHANGE REQUESTS |
1 Custom WBS Segments are NOT supported.
2 Project 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.
3 The Integration by Procore syncs budget modifications created in Procore to Viewpoint® Spectrum®. See Can I export Procore budget modifications to an integrated ERP system?
4 Exports 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?
5 Budgets containing line items with $0 values can be exported from Procore to Viewpoint® Spectrum®.
6 Import 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 Number 1 |
|
| Job Code |
Project Name |
|
| Job Description |
Address |
|
| Job Address |
Job Template 2 |
|
| Division |
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 Type 1 |
|
| Vendor Type |
Vendor ID 1 |
|
| 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 |
| Estimate Amount | |
Budget Modification Notes |
| Notes |

