14.1 sp110_job_equipment

This table contains details of the spares required at a customer site.

HouseKeeping

This table is tidied by sp_dbtidy's Job group.

Table Definition

Field	Type	Default
job_no	number(9)
job_equip_no	number(3)
resource_no	number(9)
quantity	number(2)	1
activity_no	number(9)
source_no	number(1)
holding_ref	varchar2(25)

primary key (job_no, job_equip_no)

Field	Description
job_no	Job identifier.
job_equip_no	Equipment requirement number (value between 1 and 30).
resource_no	Identifier of resource to be allocated (i.e. it may be the 'first choice' spare or it may be a substitute).
quantity	Quantity required.
activity_no	Where equipment is to be pre-delivered to the customer site, this is the identifier of the delivery activity.
source_no	Identifies where the equipment will be sourced from - 0 - Initial allocation 1 - spare satisfied from van stock 2 - spare obtained from pickup point - allocated by scheduler 3 - spare obtained from pickup point - allocated manually (gantt) 4 - spare obtained from pickup point - allocated manually (gantt) 5 - 3rd party delivery - either specified from the gantt or where the scheduler has failed to allocate an appropriate source 6 - Externally Resourced - not to be allocated by ServiceOptimizer 7 - spare not used
holding_ref	Either: postcode of the equipment source, i.e. depot (not currently used) Or: employee_ref of the employee carrying the spare (following a call to SP_SetJobCleared)