CurrencyRate Table (AdventureWorks)
Contains currency exchange rates.
CurrencyRate Table Definition
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. |
See Also
Reference
CountryRegionCurrency Table
Currency Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary