14.1 sp218_booking_locations
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table provides a mapping between a booking location number and a location name. A booking location is any external system from which appointment bookings (or other jobs) may originate. The location name is used to enable ServiceOptimizer to send responses (or requests for information) to the appropriate system.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| bkg_location_no | number(2) |  | |
| name | varchar2(50) | | |
| bkg_location_ref | varchar2(4) | | |
| tz_no | number(2) |  |
Keys
primary key (bkg_location_no)
foreign key (tz_no) references /wiki/spaces/SCH141/pages/27100425 (tz_no)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| bkg_location_no | ServiceOptimizer location number. |
| name | The booking location name. |
| bkg_location_ref | User booking location identifier. |
| tz_no | The time zone associated with a booking location. If the location has no time zone, sp083 'tz_Default' is used. |