Sales.CurrencyRate (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:28Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:54Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:19Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:06Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:28Z

Bot at 05:33, 30 November 2009

2009-11-30T05:33:19Z

Bot at 05:31, 30 November 2009

2009-11-30T05:31:47Z

Bot at 05:23, 30 November 2009

2009-11-30T05:23:44Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:36Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:00Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.CurrencyRate
@@ Line 8: / Line 8: @@
 | '''Description
 | Currency exchange rates.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | CurrencyRateID
@@ Line 70: / Line 68: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_CurrencyRate_CurrencyRateID
 | CurrencyRateID
@@ Line 81: / Line 79: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
 | Unique
@@ Line 94: / Line 92: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Sales.Currency_(table)|Sales.Currency]]
 | FromCurrencyCode
 | CurrencyCode
-|-
+|- valign="top"
 | [[Sales.Currency_(table)|Sales.Currency]]
 | ToCurrencyCode
@@ Line 111: / Line 109: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | CurrencyRateID
@@ Line 125: / Line 123: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for CurrencyRate records.<br />PK_CurrencyRate_CurrencyRateID
+| Primary key for CurrencyRate records.
 |- valign="top"
 | CurrencyRateDate
@@ Line 31: / Line 32: @@
 | 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"
 | FromCurrencyCode
@@ Line 37: / Line 38: @@
 | 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"
 | ToCurrencyCode
@@ Line 43: / Line 44: @@
 | 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"
 | AverageRate
@@ Line 49: / Line 50: @@
 | not null
+|
-| Average exchange rate for the day.<br />
+| Average exchange rate for the day.
 |- valign="top"
 | EndOfDayRate
@@ Line 55: / Line 56: @@
 | not null
+|
-| Final exchange rate for the day.<br />
+| Final exchange rate for the day.
 |- valign="top"
 | ModifiedDate
@@ Line 61: / Line 62: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 82: / Line 105: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 95: / Line 118: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Sales.CurrencyRate
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | CurrencyRateID
 | int
 | not null
+|
-| PK_CurrencyRate_CurrencyRateID
+| Primary key for CurrencyRate records.<br />PK_CurrencyRate_CurrencyRateID
+|- valign="top"
 | CurrencyRateDate
 | datetime
 | not null
+|
+| Date and time the exchange rate was obtained.<br />AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
-| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
+|- valign="top"
 | FromCurrencyCode
 | nchar(3)
 | not null
+|
+| Exchange rate was converted from this currency code.<br />AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
-| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
+|- valign="top"
 | ToCurrencyCode
 | nchar(3)
 | not null
+|
+| Exchange rate was converted to this currency code.<br />AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
-| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
+|- valign="top"
 | AverageRate
 | money
 | not null
+|
+| Average exchange rate for the day.<br />
+|- valign="top"
 | EndOfDayRate
 | money
 | not null
+|
+| Final exchange rate for the day.<br />
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 99: / Line 94: @@
 | CurrencyRateID
 |}
 == automatically generated ==

@@ Line 106: / Line 106: @@
 | Sales.CurrencyRate
 |- valign="top"
 | '''Description
 | Currency exchange rates.
 |-
 |}

@@ Line 207: / Line 207: @@
 | Schema
 | Schema
-| [[Sales_(schema)|false.Sales]]
+| [[Sales_(schema)|Sales]]
 |}