Difference between revisions of "Sales.CurrencyRate (table)"

From dbscript Online Help
Jump to: navigation, search
Line 66: Line 66:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Sales.Currency_(table)|Sales.Currency]]
 +
| FromCurrencyCode
 +
| CurrencyCode
 +
|-
 +
| [[Sales.Currency_(table)|Sales.Currency]]
 +
| ToCurrencyCode
 +
| CurrencyCode
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 +
| CurrencyRateID
 +
| CurrencyRateID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Sales.CurrencyRate
 +
|-
 +
 +
| '''Description
 +
| Currency exchange rates.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:26, 27 November 2009

wikibot

Table Sales.CurrencyRate


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())


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


Detail Table Column Referencing Column
Sales.SalesOrderHeader CurrencyRateID CurrencyRateID

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.


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


Detail Table Column Referencing Column
Sales.SalesOrderHeader CurrencyRateID CurrencyRateID