Detailed Data Mapping
Overview
PROCORE | Exports data from Procore to Vista® | Imports data from Vista® to Procore | Vista® |
|---|---|---|---|
PROJECTS |
|
| JC JOBS |
COMPANIES |
|
| AP VENDORS |
STANDARD COST CODES 1 COST TYPES |
| JC PHASE MASTER JC COST TYPE | |
COST CODES 1 COST TYPES |
|
| JOB PHASES JOB COST TYPES |
BUDGETS 5 |
|
| JC ORIGINAL ESTIMATES |
BUDGET MODIFICATIONS 2 |
| INTERNAL JC CHANGE ORDERS | |
COMMITMENTS |
| SUBCONTRACTS/PURCHASE ORDERS | |
COMMITMENT CHANGE ORDERS |
| SL/PO CHANGE ORDERS | |
JOB COSTS |
| JOB TO DATE COSTS | |
FORECASTING/PROJECTIONS 3 |
| PROJECTED COST | |
DIRECT COSTS |
| JTD COST DETAIL | |
PRIME CONTRACT |
| JC CONTRACTS | |
PRIME CONTRACT CHANGE ORDERS (PCCO's) |
| EXTERNAL JC CHANGE ORDERS | |
SUBCONTRACTOR INVOICES |
| AP TRANSACTION ENTRY or AP UNAPPROVED INVOICES | |
SUBCONTRACT INVOICE PAYMENTS 4 |
|
| PAYMENTS |
1 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. Custom WBS Segments are NOT supported.
2Budget modifications sync with estimate changes in Vista® .
3Exports the 'Estimated Cost at Completion' values from a Procore budget to Vista® .
4Export of payment records from Procore to Vista® is only available in the US to customers who license Procore Pay at this time. Import of payment records from Vista® is only available for US customers at this time.
5Budgets containing line items with $0 values can be exported from Procore to Vista® .
Projects/Jobs
When a project is exported from Procore to Viewpoint® Vista™, Ryvit takes the data and inserts into the various Forms (SQL tables) within the Viewpoint® Vista™ database. The data that is inserted for projects, populates to the JC Job Master (JCJM) and JC Job Phases (JCJP) forms.
PROCORE | Exports data from Procore to Viewpoint® Vista™ | Imports data from Viewpoint® Vista™ to Procore | Viewpoint® Vista™ |
|---|---|---|---|
Vista Job ID |
|
| Job ID1 |
Project Name |
|
| Description |
Active Project |
|
| Status |
Job Phone |
|
| Mailing Phone |
Address |
|
| Mailing Address |
City |
|
| Mailing City |
State |
|
| Mailing State |
ZIP |
|
| Mailing Zip |
Cost Code Code Description |
|
| Cost Code2 Phase Description |
Cost Type3 |
|
| Cost Type |
1 Export Note: The Viewpoint Job ID is entered manually by an accounting approver when a project is exported from Procore to Vista. This may, or may not, depending on what the accounting approver has entered, match the Job Number found in Procore under Project > Admin. This is stored as the Viewpoint Job ID (you can view it under Company > ERP Integrations > Jobs > Synced) and is then used on other project related exports (Budgets, Commitments, Commitment CO’s, etc)
2 Both Standard and Project specific cost codes (which can be created in Viewpoint® Vista™ manually under JC Job Phases) are synced up to the Project Cost Code list in Procore. Project specific codes are displayed in blue.
3 To add cost codes to a previously synced ERP project in Procore , click 'Refresh Cost Codes 'in the project level Admin tool or export the budget.
Companies/Vendors
When a Vendor is exported from Procore to Viewpoint® Vista™, a new AP Vendor Master record in the Accounts Payable module in Viewpoint® Vista™. The vendor setup can be found in AP Vendor Master Form.
PROCORE | Exports data from Procore to Viewpoint® Vista™ | Imports data from Viewpoint® Vista™ to Procore | Viewpoint® Vista™ |
|---|---|---|---|
ERP Vendor ID 1 |
|
| Vendor |
Company Name |
|
| Name |
Address 2 |
|
| Payment Address: Address |
City 2 |
|
| Payment Address: City |
State 2 |
|
| Payment Address: State |
ZIP 2 |
|
| Payment Address: Zip |
Country 2 |
|
| Payment Address: Country |
1 Export note: The ERP Vendor ID is entered manually by an accounting approver when a company is exported from Procore to Viewpoint® Vista™. This 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).
2 During implementation, you can select whether to sync the payment address or the purchasing address of vendors in Viewpoint® Vista™. The selected address will be used during the import of Viewpoint® Vista™ vendors into the Procore directory.
Budgets
PROCORE | Exports data from Procore to Viewpoint® Vista™ | Imports data from Viewpoint® Vista™ to Procore | Viewpoint® Vista™ |
|---|---|---|---|
Original Budget |
|
| JC Original Estimate |
Vista Job ID |
|
| Job ID |
Cost Code |
|
| Phase |
Cost Type |
|
| Cost Type |
Budget Modifications
A Budget Modification will create a JC Change Order in Viewpoint® Vista™.
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® Vista™ | Imports data from Viewpoint® Vista™ to Procore | Viewpoint® Vista™ |
|---|---|---|---|
Vista Job ID |
| Job ID | |
Budget Modification Description (in export screen) |
| Description | |
From/To1 |
| Phase/CostType | |
Transfer Amount |
| Est Cost |
1 Typically Budget Modifications are used to move money from one budget line item to another, usually with a zero sum effect.

