Sales.vIndividualCustomer

View: 'Sales.vIndividualCustomer', Individual customers (names and addresses) that purchase Adventure Works Cycles products online.

Field NameType and Size
CustomerIDint NOT NULL
Titlenvarchar(8) NULL
FirstNameName NOT NULL
MiddleNameName NULL
LastNameName NOT NULL
Suffixnvarchar(10) NULL
PhonePhone NULL
EmailAddressnvarchar(50) NULL
EmailPromotionint NOT NULL
AddressTypeName NOT NULL
AddressLine1nvarchar(60) NOT NULL
AddressLine2nvarchar(60) NULL
Citynvarchar(30) NOT NULL
StateProvinceNameName NOT NULL
PostalCodenvarchar(15) NOT NULL
CountryRegionNameName NOT NULL
Demographicsxml NULL