This table contains address details for each office or depot.

Table Definition

Field	Type	Default	Nullable
location_no	number(4)
name	varchar2(20)
address1	varchar2(50)
address2	varchar2(50)
address3	varchar2(50)
address4	varchar2(50)
postcode	varchar2(30)
region_no	number(9)
region_ref	varchar2(26)
printer	varchar2(10)

Keys

primary key (location_no)
unique (name)
foreign key (region_no, region_ref) references sp057_regions (region_no, region_ref)

Field	Description
location_no	ServiceOptimizer-generated unique identifier
name	Depot / office name
address1	Address ...
address2
address3
address4
postcode	... and postcode
region_no	ServiceOptimizer region identifier
region_ref	End user's region reference
printer	Printer identifier.