ODBC Driver for Zoho Books

Build 22.0.8479

CurrencyExchangeRates

Retrieves list of exchange rates configured for the currency.

Table Specific Information

Select

The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • FromDate supports the '=' comparison.
  • IsCurrentDate supports the '=' comparison.
  • CurrencyId supports the '=' comparison.
For example:
    SELECT * FROM CurrencyExchangeRates WHERE CurrencyId = '1894553000000000089'

    SELECT * FROM CurrencyExchangeRates WHERE CurrencyId = '1894553000000000087' AND IsCurrentDate = true

Columns

Name Type References SupportedOperators Description
CurrencyId [KEY] String

Currencies.CurrencyId

Currency ID of the customer's currency.
CurrencyCode String Currency code of the customer's currency.
EffectiveDate Date Effective date for currency exchange.
IsMarketClosedRates Boolean Check if the rates are closed to markets.
Rate Decimal Rate of exchange for the currency with respect to base currency.

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
FromDate Date Returns the exchange rate details from the given date or from previous closest match in the absence of the exchange rate on the given date.
IsCurrentDate Boolean To return the exchange rate only if available for current date.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479