JDBC Driver for SAP Concur

Build 24.0.9062

Locations

Retrieve details of locations that are used by Concur and that are valid at the company of the user.

テーブル固有の情報

Select

本製品 はSAP Concur API を使用して、Id またはCity_p を参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。 例えば、本製品 はSAP Concur API に次のクエリの処理をオフロードします。

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062