Clock
Breadcrumbs

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