Accountlink Business Sync - Database Views
Name | Physical Object Name | Type | Description |
|---|---|---|---|
| ServiceCallEquipment | jxServiceCallEquipment | View | Comma-separated list of equipment by service call |
| ServiceCallEmployees | jxServiceCallEmployees | View | A list of assigned employees by service call appointment |
| PayCodeLabor | jxPayCodeLabor | View | All active non-expense pay codes |
| PayCodeExpense | jxPayCodeExpense | View | All active expense pay codes |
| JobCostCodes | jxJobCostCodes | View | A list of assigned cost codes by job |
| Equipment | jxEquipmentGLAccount | View | All open Service Call Equipment |
| EmployeePayCodeLabor | jxEmployeePayCodeLabor | View | All active employee non-expense pay codes |
| EmployeePayCodeExpense | jxEmployeePayCodeExpense | View | All active employee expense pay codes |
| Employee | jxEmployee | View | All active GP employees setup as TT_Active under TimeTrack Registered Users |
| CostCodeLabor | jxCostCodeLabor | View | All active labor cost codes |
| CostCodeExpense | jxCostCodeExpense | View | All active expense cost codes |
| Activities | jxJobServiceCall | View | All active Jobs, open Service Calls OR completed Service Calls within the last 90 days, and Activities |