Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
CurrencyRate Table (AdventureWorks)
Collapse the table of content
Expand the table of content

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.

Community Additions

ADD
Show:
© 2015 Microsoft