Locations
Retrieve details of locations that are used by Concur and that are valid at the company of the user.
Table Specific Information
Select
The connector uses the SAP Concur APIs to process filters that refer to Id or City_p. The connector processes other filters client-side within the connector.
For example, the connector will offload the processing of the following queries to the SAP Concur APIs:
SELECT * FROM Locations WHERE Id = '123456' SELECT * FROM Locations WHERE City_p = 'London'
Columns
| Name | Type | Description |
| ID [KEY] | String | The unique identifier of the resource. |
| AdministrativeRegion | String | The administrative region of the location. |
| Country | String | The 2-letter ISO 3166-1 country code for the location. |
| CountrySubdivision | String | The ISO 3166-2:2007 country subdivision code for the location. Example: US-WA |
| IATACode | String | The International Air Transport Association (IATA) airport code of the location. |
| IsAirport | Boolean | Indicates whether the location is an airport. Format: true or false |
| IsBookingTool | Boolean | Indicates whether the location is used by the booking tool. Format: true or false |
| Latitude | String | The latitude of the geocode for the location. |
| Longitude | String | The longitude of the geocode for the location. |
| Name | String | The location name. Maximum length: 64 characters |
| URI | String | The URI to the resource. |