VARIABLE
|
DESCRIPTION
|
\CEXPERT_NAME\
|
Name of employee.
|
\CEXPERT_CODE\
|
Code of employee.
|
\CEXPERT_EMAIL1\
|
Employee email 1.
|
\CEXPERT_EMAIL2\
|
Employee email 2.
|
\CEXPERT_PHONE1\
|
Employee phone number 1.
|
\CEXPERT_PHONE2\
|
Employee phone number 2.
|
\CEXPERT_FAX\
|
Employee fax number.
|
\CEXPERT_AHC\
|
Employee average hourly cost.
|
\CEXPERT_INFO\
|
Employee information.
|
\JOB_NAME\
|
Job name.
|
\JOB_CODE\
|
Job code.
|
\CLIENT_PO\
|
Purchase order Client issued for this Job.
|
\CLIENT_REF\
|
Client reference number in accounting system of Client.
|
\JA_CODE\
|
Job Assignment code.
|
\SERVICE\
|
Service name.
|
\INSTRUCTIONS\
|
Job instructions.
|
\WORK_NOTES\
|
Work notes.
|
\VOLUME\
|
Job volume.
|
\TYPE\
|
Job type (for example: per unit, flat fee, free)
|
\AHC\
|
Average Hourly Cost of the expert Job is assigned to.
|
\PRICE\
|
Job price.
|
\UNITS\
|
Job units.
|
\TOTAL\
|
Job total.
|
\ASSIGNED\
|
Date Job was assigned in following format: 10/4/2006.
|
\ASSIGNED_LONG\
|
Date Job was assigned in following format: Monday, October 04, 2006.
|
\DEADLINE\
|
Job deadline in following format: 10/4/2006.
|
\DEADLINE_LONG\
|
Job deadline in following format: Monday, October 04, 2006.
|
\COMPLETED\
|
Completion date in following format: 10/4/2006.
|
\COMPLETED_LONG\
|
Completion date in following format: Monday, October 04, 2006.
|
\TIME_SPENT\
|
Time spent on Job completion.
|
\HOURS_SPENT\
|
Hours spent on Job completion.
|
\MINUTES_SPENT\
|
Minutes spent on Job completion.
|
\COUNT_NOTES\
|
CATCount or AnyCount notes.
|
\INVOICE_CODE\
|
Invoice code.
|
\JOB_QUALITY\
|
Quality of Completed Job (set by project manager).
|
\NET_JOBS_TOTAL\
\NETJOBSTOTAL\
|
Net Jobs Total number.
|