Sales.CountryRegionCurrency (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:24Z

2010-02-02T22:05:51Z

2010-02-02T21:36:55Z

2009-12-28T21:54:13Z

2009-11-30T05:58:57Z

2009-11-30T05:34:20Z

2009-11-30T05:33:10Z

2009-11-30T05:31:37Z

2009-11-30T05:23:35Z

2009-11-26T23:12:28Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.CountryRegionCurrency
@@ Line 8: / Line 8: @@
 | '''Description
 | Cross-reference table mapping ISO currency codes to a country or region.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | CountryRegionCode
@@ Line 46: / Line 44: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
 | CountryRegionCode, CurrencyCode
@@ Line 57: / Line 55: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_CountryRegionCurrency_CurrencyCode
+|
@@ Line 70: / Line 68: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Person.CountryRegion_(table)|Person.CountryRegion]]
 | CountryRegionCode
 | CountryRegionCode
-|-
+|- valign="top"
 | [[Sales.Currency_(table)|Sales.Currency]]
 | CurrencyCode
@@ Line 88: / Line 86: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 40: / Line 41: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 49: / Line 51: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 61: / Line 64: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 77: / Line 81: @@
 |}

@@ Line 18: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 25: @@
 | not null
+|
-| ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.<br />PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
+| ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
 |- valign="top"
 | CurrencyCode
@@ Line 31: / Line 31: @@
 | not null
+|
-| ISO standard currency code. Foreign key to Currency.CurrencyCode.<br />PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
+| ISO standard currency code. Foreign key to Currency.CurrencyCode.
 |- valign="top"
 | ModifiedDate
@@ Line 37: / Line 37: @@
 | 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"

@@ Line 5: / Line 5: @@
 | '''Table
 | Sales.CountryRegionCurrency
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | CountryRegionCode
 | nvarchar(3)
 | not null
+|
-| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
+| ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.<br />PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
+|- valign="top"
 | CurrencyCode
 | nchar(3)
 | not null
+|
-| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
+| ISO standard currency code. Foreign key to Currency.CurrencyCode.<br />PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
-| IX_CountryRegionCurrency_CurrencyCode
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 58: / Line 57: @@
 | CurrencyCode
 |}
 == automatically generated ==

@@ Line 65: / Line 65: @@
 | Sales.CountryRegionCurrency
 |- valign="top"
 | '''Description
 | Cross-reference table mapping ISO currency codes to a country or region.
 |-
 |}

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