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 - Newer Revision »


Page Revision: 2010/01/09 17:02


wikibot

TableSales.CurrencyRate
DescriptionCurrency exchange rates.

ColumnData TypeNullableDefaultDescription / PK / Index
CurrencyRateIDintnot null Primary key for CurrencyRate records.
PK_CurrencyRate_CurrencyRateID
CurrencyRateDatedatetimenot null Date and time the exchange rate was obtained.
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
FromCurrencyCodenchar(3)not null Exchange rate was converted from this currency code.
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
ToCurrencyCodenchar(3)not null Exchange rate was converted to this currency code.
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
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.



RelationColumnReferenced Column
Sales.CurrencyFromCurrencyCodeCurrencyCode
Sales.CurrencyToCurrencyCodeCurrencyCode

Detail TableColumnReferencing Column
Sales.SalesOrderHeaderCurrencyRateIDCurrencyRateID

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