Databases > AdventureWorks2019 > Views > Sales.vSalesPerson

AdventureWorks2019

Sales.vSalesPerson

//
Sales representiatives (names and addresses) and their sales-related information.

Created: Modified:

Columns

Definition

Sample Data

BusinessEntityID
Title
FirstName
MiddleName
LastName
Suffix
JobTitle
PhoneNumber
PhoneNumberType
EmailAddress
EmailPromotion
AddressLine1
AddressLine2
City
StateProvinceName
PostalCode
CountryRegionName
TerritoryName
TerritoryGroup
SalesQuota
SalesYTD
SalesLastYear
274
NULL
Stephen
Y
Jiang
NULL
North American Sales Manager
238-555-0197
Cell
stephen0@adventure-works.com
NULL
2427 Notre Dame Ave.
NULL
Redmond
Washington
98052
United States
NULL
NULL
NULL
559697.5639
NULL
275
NULL
Michael
G
Blythe
NULL
Sales Representative
257-555-0154
Cell
michael9@adventure-works.com
1
8154 Via Mexico
NULL
Detroit
Michigan
48226
United States
Northeast
North America
300000
3763178.1787
1750406.4785
276
NULL
Linda
C
Mitchell
NULL
Sales Representative
883-555-0116
Work
linda3@adventure-works.com
NULL
2487 Riverside Drive
NULL
Nevada
Utah
84407
United States
Southwest
North America
250000
4251368.5497
1439156.0291
277
NULL
Jillian
NULL
Carson
NULL
Sales Representative
517-555-0117
Work
jillian0@adventure-works.com
1
80 Sunview Terrace
NULL
Duluth
Minnesota
55802
United States
Central
North America
250000
3189418.3662
1997186.2037
278
NULL
Garrett
R
Vargas
NULL
Sales Representative
922-555-0165
Work
garrett1@adventure-works.com
NULL
10203 Acorn Avenue
NULL
Calgary
Alberta
T2P 2G8
Canada
Canada
North America
250000
1453719.4653
1620276.8966
279
NULL
Tsvi
Michael
Reiter
NULL
Sales Representative
664-555-0112
Work
tsvi0@adventure-works.com
1
8291 Crossbow Way
NULL
Memphis
Tennessee
38103
United States
Southeast
North America
300000
2315185.611
1849640.9418
280
NULL
Pamela
O
Ansman-Wolfe
NULL
Sales Representative
340-555-0193
Cell
pamela0@adventure-works.com
1
636 Vine Hill Way
NULL
Portland
Oregon
97205
United States
Northwest
North America
250000
1352577.1325
1927059.178
281
NULL
Shu
K
Ito
NULL
Sales Representative
330-555-0120
Cell
shu0@adventure-works.com
2
5725 Glaze Drive
NULL
San Francisco
California
94109
United States
Southwest
North America
250000
2458535.6169
2073505.9999
282
NULL
José
Edvaldo
Saraiva
NULL
Sales Representative
185-555-0169
Work
josé1@adventure-works.com
NULL
9100 Sheppard Avenue North
NULL
Ottawa
Ontario
K4B 1T7
Canada
Canada
North America
250000
2604540.7172
2038234.6549
283
NULL
David
R
Campbell
NULL
Sales Representative
740-555-0182
Work
david8@adventure-works.com
NULL
2284 Azalea Avenue
NULL
Bellevue
Washington
98004
United States
Northwest
North America
250000
1573012.9383
1371635.3158
284
Mr.
Tete
A
Mensa-Annan
NULL
Sales Representative
615-555-0153
Work
tete0@adventure-works.com
1
3997 Via De Luna
NULL
Cambridge
Massachusetts
02139
United States
Northwest
North America
300000
1576562.1966
NULL
285
Mr.
Syed
E
Abbas
NULL
Pacific Sales Manager
926-555-0182
Work
syed0@adventure-works.com
NULL
7484 Roundtree Drive
NULL
Bothell
Washington
98011
United States
NULL
NULL
NULL
172524.4512
NULL
286
NULL
Lynn
N
Tsoflias
NULL
Sales Representative
1 (11) 500 555-0190
Cell
lynn0@adventure-works.com
2
34 Waterloo Road
NULL
Melbourne
Victoria
3000
Australia
Australia
Pacific
250000
1421810.9242
2278548.9776
287
NULL
Amy
E
Alberts
NULL
European Sales Manager
775-555-0164
Work
amy0@adventure-works.com
1
5009 Orange Street
NULL
Renton
Washington
98055
United States
NULL
NULL
NULL
519905.932
NULL
288
NULL
Rachel
B
Valdez
NULL
Sales Representative
1 (11) 500 555-0140
Cell
rachel0@adventure-works.com
NULL
Pascalstr 951
NULL
Berlin
Hamburg
14111
Germany
Germany
Europe
250000
1827066.7118
1307949.7917
289
NULL
Jae
B
Pak
NULL
Sales Representative
1 (11) 500 555-0145
Work
jae0@adventure-works.com
NULL
Downshire Way
NULL
Cambridge
England
BA5 3HX
United Kingdom
United Kingdom
Europe
250000
4116871.2277
1635823.3967
290
NULL
Ranjit
R
Varkey Chudukatil
NULL
Sales Representative
1 (11) 500 555-0117
Cell
ranjit0@adventure-works.com
NULL
94, rue Descartes
NULL
Bordeaux
Gironde
33000
France
France
Europe
250000
3121616.3202
2396539.7601