Updating the jxJobServiceCall View to Only Display Job Name for the Description
To edit what your users see in the Clock Time Entry or Expense Activity drop-down list for the Job Description, you will need to edit the jxJobServiceCall view (Job UNION query only). In the table below, the left column is the standard jxJobServiceCall view with the red bolded text indicating what needs to be removed. The right column's bolded text shows what the modified jxJobServiceCall view should look like to only return JC00102.WS_Job_Name as the Description.
SELECT
'JC - ' + RTRIM(JC00102.WS_Job_Number) AS 'Name',
ISNULL(RTRIM(SV00200.LOCATNNM),JC00102.WS_Job_Name) AS 'Description',
'All Jobs, Job Cost Jobs' AS 'Group',
RTRIM(JC00102.CUSTNMBR) AS 'Customer Number',
RTRIM(JC00102.Job_Address_Code) AS 'Location Number',
RTRIM(JC00102.WS_Job_Number) AS 'Job Number',
'1900-01-01 00:00:00' AS 'Date of Call',
RTRIM(JC00102.WS_Manager_ID) AS 'Project Manager',
0 AS 'Account Index',
'JOB COST' AS 'TrxType',
RTRIM(JC00102.WS_Job_Number) AS 'GP ID'
FROM JC00102
LEFT OUTER JOIN SV00200
ON SV00200.CUSTNMBR = JC00102.CUSTNMBR
AND SV00200.ADRSCODE = JC00102.Job_Address_Code
WHERE JC00102.WS_Inactive = 0 | SELECT
'JC - ' + RTRIM(JC00102.WS_Job_Number) AS 'Name',
RTRIM(JC00102.WS_Job_Name) AS 'Description',
'All Jobs, Job Cost Jobs' AS 'Group',
RTRIM(JC00102.CUSTNMBR) AS 'Customer Number',
RTRIM(JC00102.Job_Address_Code) AS 'Location Number',
RTRIM(JC00102.WS_Job_Number) AS 'Job Number',
'1900-01-01 00:00:00' AS 'Date of Call',
RTRIM(JC00102.WS_Manager_ID) AS 'Project Manager',
0 AS 'Account Index',
'JOB COST' AS 'TrxType',
RTRIM(JC00102.WS_Job_Number) AS 'GP ID'
FROM JC00102
LEFT OUTER JOIN SV00200
ON SV00200.CUSTNMBR = JC00102.CUSTNMBR
AND SV00200.ADRSCODE = JC00102.Job_Address_Code
WHERE JC00102.WS_Inactive = 0 |
