Returns all supported currencies in given account which should be used when saving monetary values with other objects.

View-Specific Information

SELECT

The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.

Column	Supported Operators
Term	=

For example, the following queries are processed server-side.

SELECT * FROM Currencies WHERE Term = 'Armenian Dram'  
SELECT * FROM Currencies WHERE Term = 'AFN'             

Note: Term can be Currencies.Name or Currencies.Code.

Columns

Name	Type	References	Description
Id [KEY]	Integer		The unique identifier of the currency.
ActiveFlag	Boolean		Indicates whether the currency is currently active and available for use in the account.
Code	String		The ISO 4217 currency code, such as USD or EUR.
DecimalPoints	Integer		The number of decimal places used when displaying monetary values in this currency.
IsCustomFlag	Boolean		Indicates whether the currency is a custom currency added by the account, rather than a standard ISO currency.
Name	String		The full display name of the currency, such as US Dollar.
Symbol	String		The currency symbol used in monetary displays, such as $ or €.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
Term	String		Optional search term that is searched for from currency's name and/or code.