14.1 sp118_work_locations
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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)
Primary Key Referenced From
Column Descriptions
| 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. |