ExchangeRatesCData BizTalk Adapter for QuickBooks Online 2019 - Build 19.0.7354
Retrieves QuickBooks exchange rates.
View Specific Information
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'
The source currency from which the exchange rate is specified. Specify as a three letter string representing the ISO 4217 code for the currency.
The target currency against which the exchange rate is specified. Specify as a three letter string representing the ISO 4217 code for the currency.
The exchange rate between SourceCurrencyCode and TargetCurrencyCode on the AsOfDate date.
Date on which this exchange rate was set.
The time the record was last updated.