Comment on page
ExchangeRates
Retrieves QuickBooks exchange rates.
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 SELECT * FROM ExchangeRates WHERE AsOfDate='2018/01/01' SELECT * FROM ExchangeRates WHERE SourceCurrencyCode='USD' |
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. |
Last modified 1yr ago