JDBC Driver for QuickBooks Online

Build 20.0.7587

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587