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 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.