Currencies
Get list of currencies configured. Also, get the details of a 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 本製品.
- CurrencyFilter supports the '=' comparison.
- CurrencyId supports the '=' comparison.
SELECT * FROM Currencies WHERE CurrencyId = '1894553000000000099'
SELECT * FROM Currencies WHERE CurrencyFilter = 'Currencies.ExcludeBaseCurrency'
Columns
| Name | Type | References | SupportedOperators | Description |
| 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-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 | |
| CurrencyFilter | String | Filter currencies excluding base currency.
使用できる値は次のとおりです。Currencies.ExcludeBaseCurrency |