sp930_cancelled_jobs

This table stores details of cancelled jobs.

Table Definition

Field	Type	Default
`JOB_NO`	`NUMBER(9)`
`JOB_REF`	`varchar2(50)`
`CANCEL_DATE`	`date`	`sysdate`
`JOB_TYPE`	`number(2)`
`CUSTOMER_REF`	`varchar2(30)`
`CUSTOMER_NAME`	`varchar2(50)`
`ADDRESS1`	`varchar2(50)`
`ADDRESS2`	`varchar2(50)`
`ADDRESS3`	`varchar2(50)`
`ADDRESS4`	`varchar2(50)`
`POSTCODE`	`varchar2(30)`
`PHONE1`	`varchar2(40)`
`PHONE2`	`varchar2(40)`
`CONTACT_NAME`	`varchar2(50)`
`DESCRIPTION1`	`varchar2(500)`
`DESCRIPTION2`	`varchar2(500)`
`DESCRIPTION3`	`varchar2(500)`
`DESCRIPTION4`	`varchar2(500)`
`PRIORITY`	`number(2)`
`REGION`	`number(9)`
`CONTRACT_START`	`date`
`CONTRACT_COMPLETION`	`date`
`APPOINTMENT_EARLIEST`	`date`
`APPOINTMENT_LATEST`	`date`
`JOB_STATUS`	`number(2)`
`notes`	`clob`
`STATUS`	`number(2)`
`cancelReasonId`	`number`
`cancelDescription`	`varchar2(500)`
`vwdlLocationType`	`number(9)`

Field	Description
`JOB_NO`	`sp111_jobs.job_no`
`JOB_REF`	`sp111_jobs.job_ref`
`CANCEL_DATE`	The date and time at which the record was created. Uses the time zone of the DBMS server machine.
`JOB_TYPE`	`sp111_jobs.job_type`
`CUSTOMER_REF`	`sp111_jobs.customer_ref`
`CUSTOMER_NAME`	`sp111_jobs.customer_name`
`ADDRESS1`	`sp111_jobs.address1`
`ADDRESS2`	`sp111_jobs.address2`
`ADDRESS3`	`sp111_jobs.address3`
`ADDRESS4`	`sp111_jobs.address4`
`POSTCODE`	sp111_jobs.postcode
`PHONE1`	`sp111_jobs.phone1`
`PHONE2`	`sp111_jobs.phone2`
`CONTACT_NAME`	`sp111_jobs.contact_name`
`DESCRIPTION1`	`sp111_jobs.description1`
`DESCRIPTION2`	`sp111_jobs.description2`
`DESCRIPTION3`	`sp111_jobs.description3`
`DESCRIPTION4`	`sp111_jobs.description4`
`PRIORITY`	`sp111_jobs.priority`
`REGION`	`sp100_activities.region_no`
`CONTRACT_START`	`sp108_job_details.contract_start`
`CONTRACT_COMPLETION`	`sp108_job_details.contract_completion`
`APPOINTMENT_EARLIEST`	`sp108_job_details.appointment_earliest`
`APPOINTMENT_LATEST`	`sp108_job_details.appointment_latest`
`JOB_STATUS`	`sp111_jobs.job_status`
`notes`	`sp100_activities.notes`
`STATUS`	`sp108_job_details.status`
`cancelReasonId`	Cancel ID
`cancelDescription`	Description of cancel
`vwdlLocationType`	`sp108_job_details.vwdlLocationType`