Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Contains current customer information. Customers are categorized by type: individual consumer or retail store.
Customer Table Definition
The Customer table is contained in the Sales schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
CustomerID |
int |
Not null |
Primary key for Customer rows. |
TerritoryID |
int |
Null |
ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID. |
AccountNumber |
int |
Not null |
Unique number that identifies the customer. |
CustomerType |
nchar(1) |
Not null |
Customer type: I = Individual S = Store |
rowguid |
uniqueidentifier ROWGUIDCOL |
Not null |
ROWGUIDCOL number that uniquely identifies the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
CustomerAddress Table (AdventureWorks)
Individual Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)
SalesPerson Table (AdventureWorks)
SalesTerritory Table (AdventureWorks)
Store Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary