Sales.CurrencyRate (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table Sales.CurrencyRate
Description Currency exchange rates.

Columns[edit]

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[edit]

Primary Key Columns
PK_CurrencyRate_CurrencyRateID CurrencyRateID

Indexes[edit]

Index Type Columns
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode Unique CurrencyRateDate, FromCurrencyCode, ToCurrencyCode

Foreign Keys[edit]

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

Detail Tables[edit]

Detail Table Column Referencing Column
Sales.SalesOrderHeader CurrencyRateID CurrencyRateID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

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