ExchangeRates
Retrieves QuickBooks exchange rates.
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 |
The source currency from which the exchange rate is specified. Specify as a three letter string representing the ISO 4217 code for the currency. | |
| TargetCurrencyCode | String | False | False | False |
The target currency against which the exchange rate is specified. Specify as a three letter string representing the ISO 4217 code for the currency. | |
| Rate | Double | False | False | False |
The exchange rate between SourceCurrencyCode and TargetCurrencyCode on the AsOfDate date. | |
| AsOfDate | Date | False | True | False |
Date on which this exchange rate was set. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
The time the record was last updated. |