Databases > AdventureWorks2019 > Views > Sales.vStoreWithContacts

AdventureWorks2019

Sales.vStoreWithContacts

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

Created: Modified:

Columns

Definition

Sample Data

BusinessEntityID
Name
ContactType
Title
FirstName
MiddleName
LastName
Suffix
PhoneNumber
PhoneNumberType
EmailAddress
EmailPromotion
292
Next-Door Bike Store
Owner
Mr.
Gustavo
NULL
Achong
NULL
398-555-0132
Cell
gustavo0@adventure-works.com
2
294
Professional Sales and Service
Owner
Ms.
Catherine
R.
Abel
NULL
747-555-0171
Cell
catherine0@adventure-works.com
1
296
Riders Company
Owner
Ms.
Kim
NULL
Abercrombie
NULL
334-555-0137
Work
kim2@adventure-works.com
NULL
298
The Bike Mechanics
Owner
Sr.
Humberto
NULL
Acevedo
NULL
599-555-0127
Cell
humberto0@adventure-works.com
2
300
Nationwide Supply
Owner
Sra.
Pilar
NULL
Ackerman
NULL
1 (11) 500 555-0132
Cell
pilar1@adventure-works.com
NULL
302
Area Bike Accessories
Owner
Ms.
Frances
B.
Adams
NULL
991-555-0183
Work
frances0@adventure-works.com
1
304
Bicycle Accessories and Kits
Owner
Ms.
Margaret
J.
Smith
NULL
959-555-0151
Cell
margaret0@adventure-works.com
NULL
306
Clamps & Brackets Co.
Owner
Ms.
Carla
J.
Adams
NULL
107-555-0138
Cell
carla0@adventure-works.com
NULL
316
Fun Toys and Bikes
Owner
Mr.
Robert
E.
Ahlering
NULL
678-555-0175
Cell
robert1@adventure-works.com
NULL
318
Great Bikes
Owner
Mr.
François
NULL
Ferrier
NULL
571-555-0128
Cell
françois1@adventure-works.com
1
320
Metropolitan Sales and Rental
Owner
Ms.
Kim
NULL
Akers
NULL
440-555-0166
Cell
kim3@adventure-works.com
2
322
Irregulars Outlet
Owner
Ms.
Lili
J.
Alameda
NULL
1 (11) 500 555-0150
Cell
lili0@adventure-works.com
1
324
Valley Toy Store
Owner
Ms.
Amy
E.
Alberts
NULL
727-555-0115
Work
amy1@adventure-works.com
1
326
Worthwhile Activity Store
Owner
Ms.
Anna
A.
Albright
NULL
197-555-0143
Work
anna0@adventure-works.com
1
332
Family's Favorite Bike Shop
Owner
Mr.
Gregory
F.
Alderson
NULL
968-555-0153
Work
gregory0@adventure-works.com
NULL
334
Global Plaza
Owner
Mr.
J. Phillip
L.
Alexander
NULL
845-555-0187
Cell
jphillip0@adventure-works.com
1
336
Imported and Domestic Cycles
Owner
Ms.
Michelle
NULL
Alexander
NULL
115-555-0175
Work
michelle0@adventure-works.com
2
342
Mountain Toy Store
Owner
Mr.
Marvin
N.
Allen
NULL
447-555-0110
Cell
marvin0@adventure-works.com
NULL
344
Retail Sales and Service
Owner
Mr.
Michael
NULL
Allen
NULL
607-555-0193
Cell
michael10@adventure-works.com
2
350
Twin Cycles
Owner
Ms.
Sandra
J.
Altamirano
NULL
1 (11) 500 555-0190
Cell
sandra1@adventure-works.com
NULL
352
Tiny Bike Boutique
Owner
Ms.
Selena
R.
Alvarado
NULL
781-555-0199
Cell
selena0@adventure-works.com
NULL
370
Resale Services
Owner
Mr.
Thomas
B.
Armstrong
Jr.
226-555-0146
Cell
thomas1@adventure-works.com
NULL
372
The Gear Store
Owner
Mr.
John
NULL
Arthur
NULL
149-555-0113
Cell
john6@adventure-works.com
NULL
382
Work and Play Association
Owner
Mr.
Stephen
M.
Ayers
NULL
818-555-0171
Work
stephen1@adventure-works.com
NULL
384
Seaside Bike Works
Owner
Mr.
Phillip
M.
Bacalzo
NULL
1 (11) 500 555-0187
Work
phillip0@adventure-works.com
NULL