Sales CurrencyRate (table)

wikibot

TableSales.CurrencyRate
DescriptionCurrency exchange rates.

Columns

ColumnData TypeNullableDefaultDescription
CurrencyRateIDintnot null Primary key for CurrencyRate records.
CurrencyRateDatedatetimenot null Date and time the exchange rate was obtained.
FromCurrencyCodenchar(3)not null Exchange rate was converted from this currency code.
ToCurrencyCodenchar(3)not null Exchange rate was converted to this currency code.
AverageRatemoneynot null Average exchange rate for the day.
EndOfDayRatemoneynot null Final exchange rate for the day.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_CurrencyRate_CurrencyRateIDCurrencyRateID

Indexes

IndexTypeColumns
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCodeUniqueCurrencyRateDate, FromCurrencyCode, ToCurrencyCode

Foreign Keys

RelationColumnReferenced Column
Sales.CurrencyFromCurrencyCodeCurrencyCode
Sales.CurrencyToCurrencyCodeCurrencyCode

Detail Tables

Detail TableColumnReferencing Column
Sales.SalesOrderHeaderCurrencyRateIDCurrencyRateID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales