Sales.CurrencyRate (table)

wikibot

Table	Sales.CurrencyRate
Description	Currency exchange rates.

Columns

Column	Data Type	Nullable	Default	Description
CurrencyRateID	int	not null		Primary key for CurrencyRate records.
CurrencyRateDate	datetime	not null		Date and time the exchange rate was obtained.
FromCurrencyCode	nchar(3)	not null		Exchange rate was converted from this currency code.
ToCurrencyCode	nchar(3)	not null		Exchange rate was converted to this currency code.
AverageRate	money	not null		Average exchange rate for the day.
EndOfDayRate	money	not null		Final exchange rate for the day.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_CurrencyRate_CurrencyRateID	CurrencyRateID

Indexes

Index	Type	Columns
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode	Unique	CurrencyRateDate, FromCurrencyCode, ToCurrencyCode

Foreign Keys

Relation	Column	Referenced Column
Sales.Currency	FromCurrencyCode	CurrencyCode
Sales.Currency	ToCurrencyCode	CurrencyCode

Detail Tables

Detail Table	Column	Referencing Column
Sales.SalesOrderHeader	CurrencyRateID	CurrencyRateID

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

automatically generated

Table	Sales.CurrencyRate
Description	Currency exchange rates.

Column	Data Type	Nullable	Default	Description / PK / Index
CurrencyRateID	int	not null		Primary key for CurrencyRate records. PK_CurrencyRate_CurrencyRateID
CurrencyRateDate	datetime	not null		Date and time the exchange rate was obtained. AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
FromCurrencyCode	nchar(3)	not null		Exchange rate was converted from this currency code. AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
ToCurrencyCode	nchar(3)	not null		Exchange rate was converted to this currency code. AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
AverageRate	money	not null		Average exchange rate for the day.
EndOfDayRate	money	not null		Final exchange rate for the day.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Sales.Currency	FromCurrencyCode	CurrencyCode
Sales.Currency	ToCurrencyCode	CurrencyCode

Detail Table	Column	Referencing Column
Sales.SalesOrderHeader	CurrencyRateID	CurrencyRateID

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales