cmn_location
Maintains location records for offices, sites, and branches within the organization.
Columns
| Name | Type | ReadOnly | References | Description |
| parent | String | False |
References the parent location if this record is part of a hierarchical structure, such as a campus or regional office network. | |
| lat_long_error | String | False |
Indicates any errors detected when validating the latitude and longitude coordinates of the location. | |
| state | String | False |
Specifies the state or province where the location is situated. | |
| sys_created_by | String | False |
Lists the user or process that originally created the location record in the Common Location (cmn_location) table. | |
| fax_phone | String | False |
Provides the fax number associated with the location, if applicable. | |
| phone_territory | String | False |
Specifies the regional or telephonic territory associated with the location's phone number. | |
| contact | String | False |
Lists the primary contact person responsible for managing or maintaining the location. | |
| full_name | String | False |
Displays the complete formatted name of the location, often combining the building, city, and country for clarity. | |
| name | String | False |
Specifies the official name of the location as recognized in organizational or facility records. | |
| sys_id [KEY] | String | False |
Provides the system identifier (sys_id) that uniquely identifies the location record in ServiceNow. | |
| zip | String | False |
Contains the postal or ZIP code corresponding to the location's address. | |
| sys_created_on | Datetime | False |
Displays the date and time when the location record was first created in the system. | |
| country | String | False |
Specifies the country where the location resides. | |
| sys_mod_count | String | False |
Tracks the total number of times the location record has been modified. | |
| stock_room | String | False |
Indicates whether the location includes an associated stockroom or storage area. | |
| latitude | String | False |
Provides the latitude coordinate used to map the physical location. | |
| street | String | False |
Specifies the street address or detailed location description. | |
| sys_updated_by | String | False |
Lists the user or process that last updated the location record. | |
| time_zone | String | False |
Specifies the time zone for the location, used for scheduling and reporting consistency. | |
| city | String | False |
Specifies the city or municipality where the location is based. | |
| sys_updated_on | Datetime | False |
Displays the date and time when the location record was last updated in ServiceNow. | |
| phone | String | False |
Lists the main phone number associated with the location. | |
| company | String | False |
Specifies the company or organizational entity responsible for or associated with the location. | |
| longitude | String | False |
Provides the longitude coordinate used to map the physical location. | |
| ItemURL | String | True |
Displays the web address (URL) where the location record can be accessed from the ServiceNow user interface (UI). |