View: 'Sales.vStoreWithDemographics', Stores (names and addresses) that sell Adventure Works Cycles products to consumers.

Field NameType and Size
CustomerIDint NOT NULL
ContactTypeName 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
AnnualSalesmoney(19,4) NULL
AnnualRevenuemoney(19,4) NULL
BankNamenvarchar(50) NULL
BusinessTypenvarchar(5) NULL
YearOpenedint NULL
Specialtynvarchar(50) NULL
SquareFeetint NULL
Brandsnvarchar(30) NULL
Internetnvarchar(30) NULL
NumberEmployeesint NULL