# CurrencyCurrentExchangeRates Get all current exchange rates Retrieve all current exchange rates for all currency pairs. - Catalog: `MultiCurrency` - Schema: `ExchangeRates` This is a read-only table. The HubSpot API may not support changing the data or the Invantive UniversalSQL driver for HubSpot does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the HubSpot API. ## Table Columns The columns of the table `CurrencyCurrentExchangeRates` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `conversionRate` | `decimal` | | ☐ | The conversion rate between the to and from currency code of this exchange rate. | | `createdAt` | `datetime` | Created at | ☐ | The date the exchange rate was created. | | `effectiveAt` | `datetime` | | ☐ | The date the exchange rate is in effect. | | `fromCurrencyCode` | `varchar2` | | ☐ | This represents the three-letter currency code (such as USD for US Dollar) of the currency you are converting from. | | `id` | `varchar2` | ID | ☐ | A unique identifier for the exchange rate | | `toCurrencyCode` | `varchar2` | | ☐ | This represents the three-letter currency code (such as USD for US Dollar) of the currency you are converting to. | | `updatedAt` | `datetime` | Updated at | ☐ | The date the exchange rate was last updated. | | `visibleInUI` | `char` | | ☐ | This indicates if the exchange rate is shown in the MultiCurrency settings page. |