Generated using SQL Data Dictionary demo version.


View Sales.vSalesPerson


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


Column Data Type Nullable
BusinessEntityID int
Title nvarchar(8) X
FirstName Name(nvarchar(50))
MiddleName Name(nvarchar(50)) X
LastName Name(nvarchar(50))
Suffix nvarchar(10) X
JobTitle nvarchar(50)
PhoneNumber Phone(nvarchar(25)) X
PhoneNumberType Name(nvarchar(50)) X
EmailAddress nvarchar(50) X
EmailPromotion int
AddressLine1 nvarchar(60)
AddressLine2 nvarchar(60) X
City nvarchar(30)
StateProvinceName Name(nvarchar(50))
PostalCode nvarchar(15)
CountryRegionName Name(nvarchar(50))
TerritoryName Name(nvarchar(50)) X
TerritoryGroup nvarchar(50) X
SalesQuota money X
SalesYTD money
SalesLastYear money

Uses: