From dbscript Online Help
wikibot
| 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())
|
|
|
automatically generated
| 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.
|
|
