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 add-in uses the SAP Concur APIs to process filters that refer to Id or City_p. The add-in processes other filters client-side within the add-in.
For example, the add-in 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 | References | 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 | Bool | Indicates whether the location is an airport. Format: true or false | |
IsBookingTool | Bool | Indicates whether the location is used by the booking tool. Format: true or false | |
Latitude | Decimal | The latitude of the geocode for the location. | |
Longitude | Decimal | The longitude of the geocode for the location. | |
Name | String | The location name. Maximum length: 64 characters | |
URI | String | The URI to the resource. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description | |
City_p | String | The city name of the location. |