sp218_booking_locations

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 sp056_time_zones (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.