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