Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

Version 1 Current »

Name

Physical Object Name

Type

Description

Script

ServiceCallEquipmentjxServiceCallEquipmentViewComma separated list of equipment by service calljxServiceCallEquipment.sql
ServiceCallEmployeesjxServiceCallEmployeesViewA list of assigned employees by service call appointmentjxServiceCallEmployees.sql
PCEXTRAS (LONG Building)PCEXTRASView*Sample data needed to support the jxPayCodeLabor (LONG Building) viewPCEXTRAS-view.sql
PayCodeLabor (LONG Building)jxPayCodeLaborView* All active non-expense pay codes with Activity Type mappingjxPayCodeLabor-LONG-Building.sql
PayCodeLaborjxPayCodeLaborViewAll active non-expense pay codesjxPayCodeLabor.sql
PayCodeExpensejxPayCodeExpenseViewAll active expense pay codesjxPayCodeExpense.sql
JobProjectManagersjxJobProjectManagersViewv2 A list of Job assigned Project ManagersjxJobProjectManagers.sql
JobEmployeesjxJobEmployeesViewv2 A list of assigned employees by job appointmentjxJobEmployees.sql
JobCostCodesjxJobCostCodesViewA list of assigned cost codes by jobjxJobCostCodes.sql
EquipmentjxEquipmentGLAccountViewAll open Service Call EquipmentjxEquipmentGLAccount.sql
EmployeePayCodeLaborjxEmployeePayCodeLaborViewAll active employee non-expense pay codesjxEmployeePayCodeLabor.sql
EmployeePayCodeExpensejxEmployeePayCodeExpenseViewAll active employee expense pay codesjxEmployeePayCodeExpense.sql
EmployeejxEmployeeViewAll active GP employees setup as TT_Active under TimeTrack Registered UsersjxEmployee.sql
CostCodeLaborjxCostCodeLaborViewAll active labor cost codesjxCostCodeLabor.sql
CostCodeExpensejxCostCodeExpenseViewAll active expense cost codesjxCostCodeExpense.sql
Activities (Appointments)jxActivity (v2.5)ViewAll active Job Appointments, open Service Call Appointments OR completed Service Calls within the last 90 days, and ActivitiesjxActivity.sql
ActivitiesjxJobServiceCallViewAll active Jobs, open Service Calls OR completed Service Calls within the last 90 days, and ActivitiesjxJobServiceCall.sql
  • No labels