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

From dbscript Online Help
Jump to: navigation, search
 
(One intermediate revision 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
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Currency exchange rates.
 
| 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 18: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
−
+
 
 
|- valign="top"
 
|- valign="top"
 
| CurrencyRateID
 
| CurrencyRateID
Line 25: Line 24:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for CurrencyRate records.<br />PK_CurrencyRate_CurrencyRateID
+
| Primary key for CurrencyRate records.
 
|- valign="top"
 
|- valign="top"
 
| CurrencyRateDate
 
| CurrencyRateDate
Line 31: Line 30:
 
| not null
 
| not null
 
|  
 
|  
−
| Date and time the exchange rate was obtained.<br />AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
+
| Date and time the exchange rate was obtained.
 
|- valign="top"
 
|- valign="top"
 
| FromCurrencyCode
 
| FromCurrencyCode
Line 37: Line 36:
 
| not null
 
| not null
 
|  
 
|  
−
| Exchange rate was converted from this currency code.<br />AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
+
| Exchange rate was converted from this currency code.
 
|- valign="top"
 
|- valign="top"
 
| ToCurrencyCode
 
| ToCurrencyCode
Line 43: Line 42:
 
| not null
 
| not null
 
|  
 
|  
−
| Exchange rate was converted to this currency code.<br />AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
+
| Exchange rate was converted to this currency code.
 
|- valign="top"
 
|- valign="top"
 
| AverageRate
 
| AverageRate
Line 49: Line 48:
 
| not null
 
| not null
 
|  
 
|  
−
| Average exchange rate for the day.<br />
+
| Average exchange rate for the day.
 
|- valign="top"
 
|- valign="top"
 
| EndOfDayRate
 
| EndOfDayRate
Line 55: Line 54:
 
| not null
 
| not null
 
|  
 
|  
−
| Final exchange rate for the day.<br />
+
| Final exchange rate for the day.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 61: Line 60:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| 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 71: 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 82: 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 88: Line 109:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 
| CurrencyRateID
 
| CurrencyRateID
Line 95: Line 116:
 
|}
 
|}
  
 +
=== 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]]
 +
 +
|}
  
  

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"