Sales.CurrencyRate - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Sales
Name	CurrencyRate
Module	Sales

Currency exchange rates.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		CurrencyRateID	int		Identity		Primary key for CurrencyRate records.
Primary key for CurrencyRate records. Identity
	2		CurrencyRateDate	datetime				Date and time the exchange rate was obtained.
Date and time the exchange rate was obtained.
	3		FromCurrencyCode	nchar(3)			Sales.Currency	Exchange rate was converted from this currency code.
Exchange rate was converted from this currency code. References: Sales.Currency
	4		ToCurrencyCode	nchar(3)			Sales.Currency	Exchange rate was converted to this currency code.
Exchange rate was converted to this currency code. References: Sales.Currency
	5		AverageRate	money				Average exchange rate for the day.
Average exchange rate for the day.
	6		EndOfDayRate	money				Final exchange rate for the day.
Final exchange rate for the day.
	7		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Sales.CurrencyRate		Sales.Currency	Sales.CurrencyRate.FromCurrencyCode = Sales.Currency.CurrencyCode	FK_CurrencyRate_Currency_FromCurrencyCode Foreign key constraint referencing Currency.FromCurrencyCode.
Sales.CurrencyRate.FromCurrencyCode = Sales.Currency.CurrencyCode Name: FK_CurrencyRate_Currency_FromCurrencyCode Foreign key constraint referencing Currency.FromCurrencyCode.
Sales.CurrencyRate		Sales.Currency	Sales.CurrencyRate.ToCurrencyCode = Sales.Currency.CurrencyCode	FK_CurrencyRate_Currency_ToCurrencyCode Foreign key constraint referencing Currency.FromCurrencyCode.
Sales.CurrencyRate.ToCurrencyCode = Sales.Currency.CurrencyCode Name: FK_CurrencyRate_Currency_ToCurrencyCode Foreign key constraint referencing Currency.FromCurrencyCode.
Sales.SalesOrderHeader		Sales.CurrencyRate	Sales.SalesOrderHeader.CurrencyRateID = Sales.CurrencyRate.CurrencyRateID	FK_SalesOrderHeader_CurrencyRate_CurrencyRateID Foreign key constraint referencing CurrencyRate.CurrencyRateID.
Sales.SalesOrderHeader.CurrencyRateID = Sales.CurrencyRate.CurrencyRateID Name: FK_SalesOrderHeader_CurrencyRate_CurrencyRateID Foreign key constraint referencing CurrencyRate.CurrencyRateID.

Unique keys

	Key name	Columns	Description
	PK_CurrencyRate_CurrencyRateID	CurrencyRateID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode	CurrencyRateDate, FromCurrencyCode, ToCurrencyCode	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Sales.CurrencyRate
Sales.Currency
Sales.Currency

Used by

Name
Sales.CurrencyRate
Sales.SalesOrderHeader

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56