Integrated Data
Integrated Data Types
By integrating your Vista On-Premise data with Mosaic, you will be able to import the following:
- Employees
- Clients
- Projects
- Phases
- Time Entries
As Mosaic works on adding more data points to our integration with Vista On-Premise, this list may change. When a new feature is added to Mosaic, you can expect your Customer Success Manager to reach out requesting access to your server to update your replication.
Integrated Data Fields
Data Sources
| Vista Data Types | Mosaic Data Types |
|---|---|
| Payroll Module → PR Employees - Name | Employee - Name |
| Accounts Receivable → Customer Master - Name | Clients - Title |
| Job Cost → Job Master - Description - Job Total - Customer - Job Job Cost → Job Phases - Description - Phase - Phase Total - Contract | Projects - Title - Fee - Client - Project Number Phases - Title - Phase Number - Fee - Project Number |
| Job Cost → Cost Detail - Date - Hours - Job - Phase - Description - Employee | Time Entry - Date - Hours - Project - Phase - Description - Employee |
Mosaic is constantly working on adding more features to our integrations; you can expect additional data points to be added to your integration in the near future!
Please Note:
Mosaic only syncs posted time entries from Vista.
Unsupported Data Sources
- Changing field names in Mosaic to match custom labelling in Vista
- Integrating Data Types that are not explicitly listed in the Vista Integration Documentation
Please Note:
If there is a data endpoint not listed in this documentation and it is required for your integration, it will be a customization, charged at an hourly rate.
Extended Data Fields
Replicated Data
Mosaic replicates a subset of the data tables that are available in Vista On-Premise. The following tables will be included in your replication:
| Table Name | Use in Mosaic |
|---|---|
| JCJM | Project integration |
| JCCM | Project integration |
| JCJP | Phase integration |
| JCCP | Phase integration |
| JCCD | Time Entry integration |
| ARCM | Client integration |
| PREH | Employee integration |
| budEmpRates | Employee integration |
For more information on what these tables contain, you can reference the Vista by Viewpoint Product Help documentation.
Updated about 1 month ago