Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales CurrencyRate (table)

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: 2010/06/24 01:10


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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.