Customer Table (AdventureWorks)

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.