CurrencyExchangeRates
Retrieves list of exchange rates configured for the currency.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- FromDate supports the '=' comparison.
- IsCurrentDate supports the '=' comparison.
- CurrencyId supports the '=' comparison.
The rest of the filter is executed client-side in the connector.
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 | Return the exchange rate only if available for current date. |