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

From dbscript Online Help
Jump to: navigation, search
 
(5 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Sales.CurrencyRate
 
| Sales.CurrencyRate
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Currency exchange rates.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| CurrencyRateID
 
| CurrencyRateID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_CurrencyRate_CurrencyRateID
+
| Primary key for CurrencyRate records.
−
|
+
|- valign="top"
−
|-
 
 
| CurrencyRateDate
 
| CurrencyRateDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Date and time the exchange rate was obtained.
−
| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
+
|- valign="top"
−
|-
 
 
| FromCurrencyCode
 
| FromCurrencyCode
 
| nchar(3)
 
| nchar(3)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Exchange rate was converted from this currency code.
−
| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
+
|- valign="top"
−
|-
 
 
| ToCurrencyCode
 
| ToCurrencyCode
 
| nchar(3)
 
| nchar(3)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Exchange rate was converted to this currency code.
−
| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
+
|- valign="top"
−
|-
 
 
| AverageRate
 
| AverageRate
 
| money
 
| money
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Average exchange rate for the day.
−
|
+
|- valign="top"
−
|-
 
 
| EndOfDayRate
 
| EndOfDayRate
 
| money
 
| money
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Final exchange rate for the day.
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date and time the record was last updated.
−
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_CurrencyRate_CurrencyRateID
 +
| CurrencyRateID
 
|}
 
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
 +
| Unique
 +
| CurrencyRateDate, FromCurrencyCode, ToCurrencyCode
 +
|}
  
 +
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 76: Line 92:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Sales.Currency_(table)|Sales.Currency]]
 
| [[Sales.Currency_(table)|Sales.Currency]]
 
| FromCurrencyCode
 
| FromCurrencyCode
 
| CurrencyCode
 
| CurrencyCode
−
|-
+
|- valign="top"
 
| [[Sales.Currency_(table)|Sales.Currency]]
 
| [[Sales.Currency_(table)|Sales.Currency]]
 
| ToCurrencyCode
 
| ToCurrencyCode
Line 87: Line 103:
 
|}
 
|}
  
−
 
+
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 93: Line 109:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 
| CurrencyRateID
 
| CurrencyRateID
 
| CurrencyRateID
 
| CurrencyRateID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 +
|}
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  
Line 106: Line 138:
 
| Sales.CurrencyRate
 
| Sales.CurrencyRate
 
|- valign="top"
 
|- valign="top"
−
 
 
| '''Description
 
| '''Description
 
| Currency exchange rates.
 
| Currency exchange rates.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 207: Line 237:
 
| Schema
 
| Schema
 
| Schema
 
| Schema
−
| [[Sales_(schema)|.Sales]]
+
| [[Sales_(schema)|Sales]]
  
 
|}
 
|}

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

Table Sales.CurrencyRate
Description Currency exchange rates.

Columns[edit]

Column Data Type Nullable Default Description
CurrencyRateID int not null Primary key for CurrencyRate records.
CurrencyRateDate datetime not null Date and time the exchange rate was obtained.
FromCurrencyCode nchar(3) not null Exchange rate was converted from this currency code.
ToCurrencyCode nchar(3) not null Exchange rate was converted to this currency code.
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.

Primary Key[edit]

Primary Key Columns
PK_CurrencyRate_CurrencyRateID CurrencyRateID

Indexes[edit]

Index Type Columns
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode Unique CurrencyRateDate, FromCurrencyCode, ToCurrencyCode

Foreign Keys[edit]

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

Detail Tables[edit]

Detail Table Column Referencing Column
Sales.SalesOrderHeader CurrencyRateID CurrencyRateID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

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


Dependency Type Object Type Referenced Object
Schema Schema Sales
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.CurrencyRate_(table)&oldid=2663"