CurrencyExchangeRates
Retrieves list of exchange rates configured for the currency.
Table Specific Information
Select
The add-in 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 add-in.
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. | ||
| RateFormatted | String | Rate of exchange for the currency with respect to base currency including currency symbol. |
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. |