Get list of currencies configured. Also, get the details of a currency.
Table Specific Information
The connector 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 connector.
- CurrencyFilter supports the '=' comparison.
- CurrencyId supports the '=' comparison.
SELECT * FROM Currencies WHERE CurrencyId = '1894553000000000099' SELECT * FROM Currencies WHERE CurrencyFilter = 'Currencies.ExcludeBaseCurrency'
|CurrencyId [KEY]||String||Currency Id of the customer's currency.|
|CurrencyName||String||Name of a currency.|
|CurrencyCode||String||Code of a currency.|
|CurrencyFormat||String||Format of a currency.|
|CurrencySymbol||String||Symbol of a currency.|
|EffectiveDate||Date||Date which the exchange rate is applicable for the currency.|
|ExchangeRate||Decimal||Exchange rate of the currency.|
|IsBaseCurrency||Boolean||Check of it is a base currency.|
|PricePrecision||Integer||The precision for the price.|
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.
|CurrencyFilter||String||Filter currencies excluding base currency.
The allowed values are Currencies.ExcludeBaseCurrency.