ExchangeRates
Provides daily or periodic exchange rate data used by QuickBooks Online to convert multicurrency transactions into the home currency for reporting and compliance.
View Specific Information
Select
By default this view will only list rates about today's exchange rates. You can change the date by specifying a valid date for the column AsOfDate.
SELECT * FROM ExchangeRates WHERE AsOfDate = '2018/01/01' SELECT * FROM ExchangeRates WHERE SourceCurrencyCode = 'USD'
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| SourceCurrencyCode | String | False | True | False |
Specifies the source currency from which the exchange rate is defined. Provide this value as a three-letter string that represents the ISO 4217 currency code. | |
| TargetCurrencyCode | String | False | False | False |
Specifies the target currency against which the exchange rate is defined. Provide this value as a three-letter string that represents the ISO 4217 currency code. | |
| Rate | Double | False | False | False |
Specifies the exchange rate between the source currency and the target currency on the AsOfDate value. | |
| AsOfDate | Date | False | True | False |
Specifies the date on which this exchange rate was set. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
Specifies the date and time when the exchange-rate record was last updated. | |
| MetaData_CreateTime | Datetime | True | True | True |
Specifies the date and time when the exchange-rate record was created. | |
| SyncToken | String | True | False | False |
Specifies the version number that is used to lock the exchange-rate object for use by one application at a time. When an application modifies an object, its sync token is incremented. Attempts to modify an object with an older sync token fail. | |
| CustomFieldAggregate | String | False | False | False |
Specifies an XML aggregate of custom field information for the exchange-rate record. This field groups all user-defined or application-defined custom fields that are associated with the exchange rate into a single XML payload so that you can retrieve, parse, and process the custom data programmatically. |