Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

CurrencyRate Table (AdventureWorks)

Contains currency exchange rates.

The CurrencyRate table is contained in the Sales schema.

Column

Data type

Nullability

Description

CurrencyRateID

int

Not null

Primary key for CurrencyRate rows.

CurrencyRateDate

datetime

Not null

Date and time the exchange rate was obtained.

FromCurrencyCode

nchar(3)

Not null

Currency code from which the exchange rate was converted.

ToCurrencyCode

nchar(3)

Not null

Currency code to which the exchange rate was converted.

AverageRate

money

Not null

Average exchange rate for the day.

EndOfDayRate

money

Not null

Final exchange rate for the day.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.