AdventureWorks2019
Purchasing.vVendorWithContacts
//
Vendor (company) names and the names of vendor employees to contact.
Created: Modified:
Columns
-
BusinessEntityID[int] NOT NULL
-
Name[Name] NOT NULL
-
ContactType[Name] NOT NULL
-
Title[nvarchar](8) NULL
-
FirstName[Name] NOT NULL
-
MiddleName[Name] NULL
-
LastName[Name] NOT NULL
-
Suffix[nvarchar](10) NULL
-
PhoneNumber[Phone] NULL
-
PhoneNumberType[Name] NULL
-
EmailAddress[nvarchar](50) NULL
-
EmailPromotion[int] NOT NULL
Definition
Sample Data
BusinessEntityID
Name
ContactType
Title
FirstName
MiddleName
LastName
Suffix
PhoneNumber
PhoneNumberType
EmailAddress
EmailPromotion
1510
International
Assistant Sales Agent
Ms.
Julia
NULL
Moseley
NULL
432-555-0100
Work
julia0@adventure-works.com
NULL
1518
International Trek Center
Assistant Sales Agent
Mr.
Albert
NULL
Mungin
NULL
439-555-0100
Cell
albert0@adventure-works.com
1
1522
First National Sport Co.
Assistant Sales Agent
Ms.
Billie Jo
NULL
Murray
NULL
923-555-0100
Work
billiejo0@adventure-works.com
NULL
1528
Image Makers Bike Center
Assistant Sales Agent
Ms.
Suzanne
NULL
Nelson
NULL
314-555-0100
Cell
suzanne0@adventure-works.com
1
1536
Cruger Bike Company
Assistant Sales Agent
Ms.
Lorraine
NULL
Nay
NULL
669-555-0100
Work
lorraine1@adventure-works.com
NULL
1542
Hill's Bicycle Service
Assistant Sales Agent
Mr.
Amir
T.
Netz
NULL
362-555-0100
Work
amir0@adventure-works.com
NULL
1568
Custom Frames, Inc.
Assistant Sales Agent
Mr.
Fred
A.
Ortiz
NULL
275-555-0100
Cell
fred2@adventure-works.com
NULL
1582
Inner City Bikes
Assistant Sales Agent
Ms.
Jyothi
NULL
Pai
NULL
433-555-0100
Cell
jyothi0@adventure-works.com
NULL
1594
Fitness Association
Assistant Sales Agent
Ms.
Trish
E.
Pederson
NULL
550-555-0100
Work
trish0@adventure-works.com
NULL
1596
A. Datum Corporation
Assistant Sales Agent
Mr.
Frank
NULL
Pellow
NULL
941-555-0100
Cell
frank7@adventure-works.com
NULL
1600
Federal Sport
Assistant Sales Agent
Ms.
Elizabeth
M.
Peoples
NULL
614-555-0100
Cell
elizabeth3@adventure-works.com
NULL
1630
Indiana Bicycle Center
Assistant Sales Agent
NULL
Alma
B.
Poorbaugh
NULL
153-555-0100
Work
alma0@adventure-works.com
NULL
1636
Integrated Sport Products
Assistant Sales Agent
Mr.
Josh
NULL
Pollock
NULL
117-555-0100
Cell
josh1@adventure-works.com
1
1642
Electronic Bike Co.
Assistant Sales Agent
Mr.
Jeff
NULL
Price
NULL
927-555-0100
Work
jeff3@adventure-works.com
2
1644
International Sport Assoc.
Assistant Sales Agent
Mr.
Milton
M.
Pugh
NULL
164-555-0100
Cell
milton1@adventure-works.com
1
1646
Electronic Bike Repair & Supplies
Assistant Sales Agent
Mr.
Sean
NULL
Purcell
NULL
130-555-0100
Cell
sean5@adventure-works.com
NULL
1648
Wide World Importers
Assistant Sales Agent
Ms.
Monica
L.
Quintana
NULL
207-555-0100
Work
monica0@adventure-works.com
NULL
1670
Holiday Skate & Cycle
Assistant Sales Agent
Mr.
Russell
A.
Reed
NULL
115-555-0100
Cell
russell3@adventure-works.com
2
1492
Australia Bike Retailer
Sales Agent
Ms.
Jo
J.
Zimmerman
NULL
816-555-0100
Work
jo3@adventure-works.com
1
1494
Allenson Cycles
Sales Agent
Ms.
Suchitra
NULL
Mohan
NULL
298-555-0100
Cell
suchitra1@adventure-works.com
NULL
1496
Advanced Bicycles
Sales Agent
Mr.
Eugene
NULL
Zabokritski
NULL
762-555-0100
Cell
eugene3@adventure-works.com
1
1502
Cycling Master
Sales Agent
Ms.
Hillaine
N.
Montera
NULL
920-555-0100
Cell
hillaine0@adventure-works.com
NULL
1508
Compete Enterprises, Inc
Sales Agent
Ms.
Carla
J.
Zubaty
NULL
516-555-0100
Cell
carla2@adventure-works.com
NULL
1512
Light Speed
Sales Agent
Ms.
Marie
E.
Moya
NULL
114-555-0100
Work
marie0@adventure-works.com
NULL
1514
Training Systems
Sales Agent
Mr.
Zheng
NULL
Mu
NULL
945-555-0100
Cell
zheng1@adventure-works.com
NULL