Sales.Customer (table) - Revision history

Bot at 08:56, 27 August 2011

2011-08-27T08:56:18Z

Bot at 22:17, 23 June 2010

2010-06-23T22:17:30Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:18Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:21Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:08Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:30Z

Bot at 05:33, 30 November 2009

2009-11-30T05:33:21Z

Bot at 05:31, 30 November 2009

2009-11-30T05:31:48Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:25Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:38Z

@@ Line 74: / Line 74: @@
 | '''Columns
 |- valign="top"
 | AK_Customer_rowguid
 | Unique
 | rowguid
 |- valign="top"
 | IX_Customer_TerritoryID

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.Customer
@@ Line 8: / Line 8: @@
 | '''Description
 | Current customer information. Also see the Individual and Store tables.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | CustomerID
@@ Line 64: / Line 62: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_Customer_CustomerID
 | CustomerID
@@ Line 75: / Line 73: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_Customer_rowguid
 | Unique
 | rowguid
-|-
+|- valign="top"
 | AK_Customer_AccountNumber
 | Unique
 | AccountNumber
-|-
+|- valign="top"
 | IX_Customer_TerritoryID
+|
@@ Line 96: / Line 94: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_Customer_CustomerType
 | (upper([CustomerType])='I' OR upper([CustomerType])='S')
@@ Line 109: / Line 107: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 | TerritoryID
@@ Line 122: / Line 120: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]]
 | CustomerID
 | CustomerID
-|-
+|- valign="top"
 | [[Sales.Individual_(table)|Sales.Individual]]
 | CustomerID
 | CustomerID
-|-
+|- valign="top"
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | CustomerID
 | CustomerID
-|-
+|- valign="top"
 | [[Sales.Store_(table)|Sales.Store]]
 | CustomerID
@@ Line 148: / Line 146: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 162: / Line 160: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
 | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
-|-
+|- valign="top"
 | Select
 | View

@@ 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 Customer records.<br />PK_Customer_CustomerID
+| Primary key for Customer records.
 |- valign="top"
 | TerritoryID
@@ Line 31: / Line 32: @@
 | null
+|
-| ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.<br />IX_Customer_TerritoryID
+| ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
 |- valign="top"
 | AccountNumber
@@ Line 37: / Line 38: @@
+|
+|
-| Unique number identifying the customer assigned by the accounting system.<br />AK_Customer_AccountNumber
+| Unique number identifying the customer assigned by the accounting system.
 |- valign="top"
 | CustomerType
@@ Line 43: / Line 44: @@
 | not null
+|
-| Customer type: I = Individual, S = Store<br />
+| Customer type: I = Individual, S = Store
 |- valign="top"
 | rowguid
@@ Line 49: / Line 50: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Customer_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 55: / Line 56: @@
 | 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 72: / Line 116: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 97: / Line 141: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 115: / Line 173: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Sales.Customer
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | CustomerID
 | int
 | not null
+|
-| PK_Customer_CustomerID
+| Primary key for Customer records.<br />PK_Customer_CustomerID
+|- valign="top"
 | TerritoryID
 | int
 | null
+|
+| ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.<br />IX_Customer_TerritoryID
-| IX_Customer_TerritoryID
+|- valign="top"
 | AccountNumber
+|
+|
+|
+| Unique number identifying the customer assigned by the accounting system.<br />AK_Customer_AccountNumber
-| AK_Customer_AccountNumber
+|- valign="top"
 | CustomerType
 | nchar(1)
 | not null
+|
+| Customer type: I = Individual, S = Store<br />
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Customer_rowguid
-| AK_Customer_rowguid
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 100: / Line 96: @@
 | CustomerID
 |}
 == automatically generated ==

@@ Line 107: / Line 107: @@
 | Sales.Customer
 |- valign="top"
 | '''Description
 | Current customer information. Also see the Individual and Store tables.
 |-
 |}

@@ Line 210: / Line 210: @@
 | Schema
 | Schema
-| [[Sales_(schema)|false.Sales]]
+| [[Sales_(schema)|Sales]]
 |}
@@ Line 224: / Line 224: @@
 | Select
 | View
-| [[Sales.vIndividualCustomer_(view)|true.vIndividualCustomer]]
+| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 |-
 | Select
 | View
-| [[Sales.vStoreWithDemographics_(view)|true.vStoreWithDemographics]]
+| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 |}

@@ Line 198: / Line 198: @@
 | CustomerID
 | CustomerID
 |}
@@ Line 206: / Line 219: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]