Locations are used by various applications to locate users, facilities, or configuration
You can configure different levels of location in a parent-child hierarchy. For example, an
email server might be associated with a location of Second Floor, whereas the email business
service might be associated with New York City.
Each level of this hierarchy contains a separate location record, with the next higher level
specified as a parent. In this example each location is selectable as a hierarchy from reference
Figure 1. Location hierarchy
The location is also used to generate a full identifier in the
field, which is available by configuring the form as follows.
Figure 2. Location Full name
Locations are stored in the Location [cmn_location] table.
Define a location
To create a location, navigate to
Table 1. Define a location
The name of the location. This name is the display value that the system uses when
referencing this location on a form.
The street address of the location.
The city of the location.
State / Province
State or province of the location.
Zip / Postal Code
The zip or postal code of the location.
The country of the location.
Name of a user who is the contact for this location.
The phone number for the location.
The fax number for the location.
Name of the parent location for this location. Location hierarchies are described
The latitude of the location.
This field and the
field described below are populated automatically by the get_lat_long
business rule when the form contains enough information, such as an address or city name
and a postal code.
Deactivate this business rule to prevent the system from
overwriting any values entered manually into these fields.
The longitude of the location.
Fields that can be added by
configuring the form:
A reference field to the
A read-only, calculated field that assembles the parent hierarchy of the location
into a full name.
A boolean field that identifies whether the location is being used as a stock
The location's time zone. By default, the location uses the system time zone.
The latitude and longitude fields are populated by a business rule
get_lat_long) which queries the Google Map service. The more specific the
location is, the more accurate the latitude and longitude are.
After the latitude and longitude are populated, Map Pages can be defined that display
locations in an interactive map. For more information, see
Latitude and longitude are expressed as a floating point data type. Previous releases
expressed this information as a string. During an upgrade, the system converts the data where