Sales.CurrencyRate (table)

wikibot

Table

Sales.CurrencyRate

Column	Data Type	Nullable	Default	PK	Index
CurrencyRateID	int	not null		PK_CurrencyRate_CurrencyRateID
CurrencyRateDate	datetime	not null			AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
FromCurrencyCode	nchar(3)	not null			AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
ToCurrencyCode	nchar(3)	not null			AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
AverageRate	money	not null
EndOfDayRate	money	not null
ModifiedDate	datetime	not null	(getdate())

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

Detail Table	Column	Referencing Column
Sales.SalesOrderHeader	CurrencyRateID	CurrencyRateID