Sales.vSalesPerson

View: 'Sales.vSalesPerson', Sales representiatives (names and addresses) and their sales-related information.

Field NameType and Size
SalesPersonIDint NOT NULL
Titlenvarchar(8) NULL
FirstNameName NOT NULL
MiddleNameName NULL
LastNameName NOT NULL
Suffixnvarchar(10) NULL
JobTitlenvarchar(50) NOT NULL
PhonePhone NULL
EmailAddressnvarchar(50) NULL
EmailPromotionint NOT NULL
AddressLine1nvarchar(60) NOT NULL
AddressLine2nvarchar(60) NULL
Citynvarchar(30) NOT NULL
StateProvinceNameName NOT NULL
PostalCodenvarchar(15) NOT NULL
CountryRegionNameName NOT NULL
TerritoryNameName NULL
TerritoryGroupnvarchar(50) NULL
SalesQuotamoney(19,4) NULL
SalesYTDmoney(19,4) NOT NULL
SalesLastYearmoney(19,4) NOT NULL