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

erp-green-arrows.png

JOBS

PROJECT COST CODES 1 COST TYPES

erp-orange-arrows.png

erp-green-arrows.png

PHASES COST TYPES

STANDARD COST CODES 1,2 STANDARD COST TYPE

erp-green-arrows.png

PHASE CATEGORY > PHASES COST TYPE

COMPANIES 6

erp-orange-arrows.png

erp-green-arrows.png

VENDORS

BUDGETS 5

erp-orange-arrows.png

erp-green-arrows.png

ESTIMATES

BUDGET CHANGES (NEW) 3 BUDGET MODIFICATIONS (LEGACY) 3

erp-orange-arrows.png

REVISIONS

FORECASTING 4

erp-orange-arrows.png

JOB COST PROJECTIONS

COMMITMENTS

erp-orange-arrows.png

SUBCONTRACTS

COMMITMENT CHANGE ORDERS

erp-orange-arrows.png

SUBCONTRACT CHANGE ORDERS

JOB COSTS

erp-green-arrows.png

JOB COSTS

PRIME CONTRACT

erp-green-arrows.png

PRIME CONTRACT

PRIME CONTRACT CHANGE ORDERS

erp-orange-arrows.png

**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.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 Number1

erp-orange-arrows.png

erp-green-arrows.png

Job Code

Project Name

erp-orange-arrows.png

erp-green-arrows.png

Job Description

Address City State ZIP

erp-orange-arrows.png

erp-green-arrows.png

Job Address

Job Template2

erp-orange-arrows.png

erp-green-arrows.png

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

erp-green-arrows.png

Phase

Project Code Code Description

erp-orange-arrows.png

erp-green-arrows.png

Phase Description

Cost Type

erp-orange-arrows.png

erp-green-arrows.png

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

erp-green-arrows.png

Name

Company Address

erp-orange-arrows.png

erp-green-arrows.png

Address

Company Business Phone

erp-orange-arrows.png

erp-green-arrows.png

Telephone

Company Business Fax

erp-orange-arrows.png

erp-green-arrows.png

Fax

Company Email Address

erp-orange-arrows.png

erp-green-arrows.png

Vendor E-mail

Vendor Type1

erp-orange-arrows.png

erp-green-arrows.png

Vendor Type

Vendor ID1

erp-orange-arrows.png

erp-green-arrows.png

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

erp-green-arrows.png

Phase

Cost Type

erp-orange-arrows.png

erp-green-arrows.png

Cost Type

Original Budget Amount

erp-orange-arrows.png

erp-green-arrows.png

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

Detailed Data Mapping Content Reuse for ERP Budget Changes

Beta icon 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.png

Phase

Category

erp-orange-arrows.png

Cost Type

Budget Modification Amount

erp-orange-arrows.png

Estimate Amount

Budget Modification Notes

erp-orange-arrows.png

Notes

Forecasting/Projections

PROCORE

Exports data from Procore to Viewpoint® Spectrum®

Imports data from Viewpoint® Spectrum® to Procore

Viewpoint® Spectrum®

Project Number1

erp-orange-arrows.png

Job Code

Cost Code

erp-orange-arrows.png

Phase

Cost Type

erp-orange-arrows.png

Cost Type

Estimated Cost at Completion2

erp-orange-arrows.png

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

Vendor Code

Commitment #

erp-orange-arrows.png

Subcontract Number

Commitment Accounting Method1

erp-orange-arrows.png

Unit Price Contract?

Default Retainage2

erp-orange-arrows.png

Retention %

Commitment Line Item

Subcontract Item

Cost Code

erp-orange-arrows.png

Phase

Cost Type

erp-orange-arrows.png

Cost Type

Description

erp-orange-arrows.png

Description

Unit Cost

erp-orange-arrows.png

Unit Price

Qty3

erp-orange-arrows.png

Orig Quantity

Contract Amount3

erp-orange-arrows.png

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

Job ID

Change Request Number1

erp-orange-arrows.png

Change Request Number

Description

erp-orange-arrows.png

Change Request Description

Budget Code

erp-orange-arrows.png

Phase

Budget Code

erp-orange-arrows.png

Cost Type

Qty

erp-orange-arrows.png

Quantity

Contract Company

erp-orange-arrows.png

Subcontractor

Commitment #

erp-orange-arrows.png

Subcontract #

Amount

erp-orange-arrows.png

Sub CO Amount

CCO #

erp-orange-arrows.png

Sub CO #

Change Order Date

erp-orange-arrows.png

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

JTD Cost

Job To Date Actual Units

erp-green-arrows.png

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 that 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.png

Job Code-Customer Code

Title

erp-green-arrows.png

Job Code & "Prime Contract"

Default Retainage

erp-green-arrows.png

Retention Percentage

Description

erp-green-arrows.png

Internal Comments

Start Date

erp-green-arrows.png

Contract Date

Schedule of Values

Contract

Description

erp-green-arrows.png

Additional Description

Amount

erp-green-arrows.png

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

Job ID

Change Request Number1

erp-orange-arrows.png

Change Request Number

Description

erp-orange-arrows.png

Change Request Description

Change Order Date

erp-orange-arrows.png

Approved Date

Cost Code

erp-orange-arrows.png

Phase

Cost Type

erp-orange-arrows.png

Cost Type

Estimate Change Amount

erp-orange-arrows.png

Estimate Amount

Billing Item Code

erp-orange-arrows.png

Billing Item

Contract Change Amount

erp-orange-arrows.png

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