Detailed Data Mapping

Overview

PROCORE

Exports data from Procore to Viewpoint® Spectrum®

Imports data from Viewpoint® Spectrum® to Procore

Viewpoint® Spectrum®

PROJECTS

Erp Orange Arrows

Erp Green Arrows

JOBS

PROJECT COST CODES 1
COST TYPES

Erp Orange Arrows

Erp Green Arrows

PHASES
COST TYPES

STANDARD COST CODES 1,2
STANDARD COST TYPE

Erp Green Arrows

PHASE CATEGORY > PHASES
COST TYPE

COMPANIES 6

Erp Orange Arrows

Erp Green Arrows

VENDORS

BUDGETS 5

Erp Orange Arrows

Erp Green Arrows

ESTIMATES

BUDGET CHANGES (NEW) 3

BUDGET MODIFICATIONS (LEGACY) 3

Erp Orange Arrows

REVISIONS

FORECASTING 4

Erp Orange Arrows

JOB COST PROJECTIONS

COMMITMENTS

Erp Orange Arrows

SUBCONTRACTS

COMMITMENT CHANGE ORDERS

Erp Orange Arrows

SUBCONTRACT CHANGE ORDERS

JOB COSTS

Erp Green Arrows

JOB COSTS

PRIME CONTRACT

Erp Green Arrows

PRIME CONTRACT

PRIME CONTRACT CHANGE ORDERS

Erp Orange Arrows

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

Erp Orange Arrows

Erp Green Arrows

Job Code

Project Name

Erp Orange Arrows

Erp Green Arrows

Job Description

Address
City
State
ZIP

Erp Orange Arrows

Erp Green Arrows

Job Address

Job Template 2

Erp Orange Arrows

Erp Green Arrows

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

Erp Orange Arrows

Erp Green Arrows

Phase

Project Code Code Description

Erp Orange Arrows

Erp Green Arrows

Phase Description

Cost Type

Erp Orange Arrows

Erp Green Arrows

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

Erp Orange Arrows

Erp Green Arrows

Name

Company Address

Erp Orange Arrows

Erp Green Arrows

Address

Company Business Phone

Erp Orange Arrows

Erp Green Arrows

Telephone

Company Business Fax

Erp Orange Arrows

Erp Green Arrows

Fax

Company Email Address

Erp Orange Arrows

Erp Green Arrows

Vendor E-mail

Vendor Type 1

Erp Orange Arrows

Erp Green Arrows

Vendor Type

Vendor ID 1

Erp Orange Arrows

Erp Green Arrows

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

Erp Orange Arrows

Erp Green Arrows

Phase

Cost Type

Erp Orange Arrows

Erp Green Arrows

Cost Type

Original Budget Amount

Erp Orange Arrows

Erp Green Arrows

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

Erp Orange Arrows

Phase

Category

Erp Orange Arrows

Cost Type

Budget Modification
Amount

Erp Orange Arrows

Estimate Amount

Budget Modification Notes

Erp Orange Arrows

Notes

Forecasting/Projections

PROCORE

Exports data from Procore to Viewpoint® Spectrum®

Imports data from Viewpoint® Spectrum® to Procore

Viewpoint® Spectrum®

Project Number 1

Erp Orange Arrows

Job Code

Cost Code

Erp Orange Arrows

Phase

Cost Type

Erp Orange Arrows

Cost Type

Estimated Cost at Completion 2

Erp Orange Arrows

Projected Cost

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 Estimated Cost at Completion. Import note: If the job is imported from Viewpoint® Spectrum®, the job ID will automatically populate in the project number field.

2 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 Viewpoint® Spectrum®?

Commitments

When a Commitment (Subcontract or Purchase Order) is exported from Procore, a Subcontract is automatically created in Viewpoint® Spectrum®.

PROCORE

Exports data from Procore to Viewpoint® Spectrum®

Imports data from Viewpoint® Spectrum® to Procore

Viewpoint® Spectrum®

Commitment

Subcontract

Contract Company

Erp Orange Arrows

Vendor Code

Commitment #

Erp Orange Arrows

Subcontract Number

Commitment Accounting Method 1

Erp Orange Arrows

Unit Price Contract?

Default Retainage 2

Erp Orange Arrows

Retention %

Commitment Line Item

Subcontract Item

Cost Code

Erp Orange Arrows

Phase

Cost Type

Erp Orange Arrows

Cost Type

Description

Erp Orange Arrows

Description

Unit Cost

Erp Orange Arrows

Unit Price

Qty 3

Erp Orange Arrows

Orig Quantity

Contract Amount 3

Erp Orange Arrows

Orig Contract

1 If the Accounting Method is set to Unit/Quantity Based, the Unit Price Contract? field in Viewpoint® Spectrum® will be checked.

2 Default Retainage (Ret?) is enabled in the Phase Details tab of the Subcontract and the Retention % is populated within the Invoice Defaults under the Default Tab on the Subcontract in Viewpoint® Spectrum®.

3 If the Accounting Method is set to Unit/Quantity Based, the Qty field in Procore will be exported to the Orig Quantity field. If the Accounting Method is set to Amount Based, then the Contract Amount will be exported to the Orig Contract field instead.

Commitment Change Orders

When Commitment Change Orders are exported to Viewpoint® Spectrum®, a Change Request is created in Viewpoint® Spectrum® using a Change Request Status Code of 'C'.

PROCORE

Exports data from Procore to Viewpoint® Spectrum®

Imports data from Viewpoint® Spectrum® to Procore

Viewpoint® Spectrum®

Project #

Erp Orange Arrows

Job ID

Change Request Number 1

Erp Orange Arrows

Change Request Number

Description

Erp Orange Arrows

Change Request Description

Budget Code

Erp Orange Arrows

Phase

Budget Code

Erp Orange Arrows

Cost Type

Qty

Erp Orange Arrows

Quantity

Contract Company

Erp Orange Arrows

Subcontractor

Commitment #

Erp Orange Arrows

Subcontract #

Amount

Erp Orange Arrows

Sub CO Amount

CCO #

Erp Orange Arrows

Sub CO #

Change Order Date

Erp Orange Arrows

Sub CO Date

1 The Change Request number in Procore is entered at the time the ERP Accounting Approver is ready to export the CCO to Viewpoint® Spectrum®.

Job Costs

Import from Viewpoint® Spectrum® only. Cost information is retrieved from Viewpoint® Spectrum® for each PhaseType on Synced projects for use in 2 locations in Procore, the Budget and the Job Costs report. Procore does not sync any AP Invoice or Payroll costs that have a status of In Progress.

PROCORE

Exports data from Procore to Viewpoint® Spectrum®

Imports data from Viewpoint® Spectrum® to Procore

Viewpoint® Spectrum®

Job Cost Report

Job To Date Costs

Erp Green Arrows

JTD Cost

Job To Date Actual Units

Erp Green Arrows

WTD Quantity

Prime Contract

Import from Viewpoint® Spectrum® only. Contracts are created in the Viewpoint® Spectrum® Accounts Receivable module. The contract can be imported into the Prime Contracts tool in Procore as long as the contract in Viewpoint® Spectrum® is not a Unit Price Contract, and the contract contains at least one Schedule of Values item with an amount.

PROCORE

Exports data from Procore to Viewpoint® Spectrum®

Imports data from Viewpoint® Spectrum® to Procore

Viewpoint® Spectrum®

Prime Contract

Contract

Contract #

Erp Green Arrows

Job Code-Customer Code

Title

Erp Green Arrows

Job Code & "Prime Contract"

Default Retainage

Erp Green Arrows

Retention Percentage

Description

Erp Green Arrows

Internal Comments

Start Date

Erp Green Arrows

Contract Date

Schedule of Values

Contract

Description

Erp Green Arrows

Additional Description

Amount

Erp Green Arrows

Orig Contract

Prime Contract Change Orders

When Prime Contract Change Orders are exported to Viewpoint® Spectrum®, a Change Request is created in Viewpoint® Spectrum® using a Change Request Status Code that is provided by the customer at the time of enabling the connector.

PROCORE

Exports data from Procore to Viewpoint® Spectrum®

Imports data from Viewpoint® Spectrum® to Procore

Viewpoint® Spectrum®

Project #

Erp Orange Arrows

Job ID

Change Request Number 1

Erp Orange Arrows

Change Request Number

Description

Erp Orange Arrows

Change Request Description

Change Order Date

Erp Orange Arrows

Approved Date

Cost Code

Erp Orange Arrows

Phase

Cost Type

Erp Orange Arrows

Cost Type

Estimate Change Amount

Erp Orange Arrows

Estimate Amount

Billing Item Code

Erp Orange Arrows

Billing Item

Contract Change Amount

Erp Orange Arrows

Amount

1 The Change Request number in Procore is entered at the time the ERP Accounting Approver is ready to export the PCCO to Viewpoint® Spectrum®.