Comment on page

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.

Estimates

InvoiceLineItems

Last modified 1yr ago

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.