Databases > AdventureWorks2019 > Views > Sales.vStoreWithAddresses

AdventureWorks2019

Sales.vStoreWithAddresses

//
Stores (including store addresses) that sell Adventure Works Cycles products to consumers.

Created: Modified:

Columns

Definition

Sample Data

BusinessEntityID
Name
AddressType
AddressLine1
AddressLine2
City
StateProvinceName
PostalCode
CountryRegionName
292
Next-Door Bike Store
Main Office
Mall Of Memphis
NULL
Memphis
Tennessee
38103
United States
294
Professional Sales and Service
Main Office
57251 Serene Blvd
NULL
Van Nuys
California
91411
United States
296
Riders Company
Main Office
Tanger Factory
NULL
Branch
Minnesota
55056
United States
298
The Bike Mechanics
Main Office
Johnny Appleseed Shop.center
NULL
Mansfield
Ohio
44903
United States
300
Nationwide Supply
Main Office
4250 Concord Road
NULL
Rhodes
New South Wales
2138
Australia
302
Area Bike Accessories
Main Office
6900 Sisk Road
NULL
Modesto
California
95354
United States
304
Bicycle Accessories and Kits
Main Office
Lewiston Mall
NULL
Lewiston
Idaho
83501
United States
306
Clamps & Brackets Co.
Main Office
Leesburg Premium Outlet Centre
NULL
Leesburg
Virginia
20176
United States
308
Valley Bicycle Specialists
Main Office
Blue Ridge Mall
NULL
Kansas City
Missouri
64106
United States
310
New Bikes Company
Main Office
Hilton Head Factory Outlets No. 25
NULL
Bluffton
South Carolina
29910
United States
312
Vinyl and Plastic Goods Corporation
Main Office
No. 25800-130 King Street West
NULL
Toronto
Ontario
M4B 1V5
Canada
314
Top of the Line Bikes
Main Office
Knaackstr 7
NULL
Paderborn
Hamburg
33041
Germany
316
Fun Toys and Bikes
Main Office
6500 East Grant Road
NULL
Tucson
Arizona
85701
United States
318
Great Bikes
Main Office
Eastridge Mall
NULL
Casper
Wyoming
82601
United States
320
Metropolitan Sales and Rental
Main Office
Granite State Marketplace
NULL
Hooksett
New Hampshire
03106
United States
322
Irregulars Outlet
Main Office
Pappelallee 19
NULL
Dresden
Hessen
01071
Germany
324
Valley Toy Store
Main Office
252851 Rowan Place
NULL
Richmond
British Columbia
V6B 3P7
Canada
326
Worthwhile Activity Store
Main Office
Flagler Park Plaza
NULL
Miami
Florida
33127
United States
328
Purchase Mart
Main Office
Wrentham Village
NULL
Wrentham
Massachusetts
02093
United States
330
Major Sport Suppliers
Main Office
White Mountain Mall
NULL
Rock Springs
Wyoming
82901
United States
332
Family's Favorite Bike Shop
Main Office
25981 College Street
NULL
Montreal
Quebec
H1Y 2H5
Canada
334
Global Plaza
Main Office
Belz Factory Outlet
NULL
Pigeon Forge
Tennessee
37863
United States
336
Imported and Domestic Cycles
Main Office
22589 West Craig Road
NULL
North Las Vegas
Nevada
89030
United States
338
Systematic Sales
Main Office
2551 East Warner Road
NULL
Gilbert
Arizona
85233
United States
340
eCommerce Bikes
Main Office
Gulfport Factory Shops
NULL
Gulfport
Mississippi
39501
United States