Sales.vSalesPerson
Field Name | Type and Size |
SalesPersonID | int NOT NULL |
Title | nvarchar(8) NULL |
FirstName | Name NOT NULL |
MiddleName | Name NULL |
LastName | Name NOT NULL |
Suffix | nvarchar(10) NULL |
JobTitle | nvarchar(50) NOT NULL |
Phone | Phone NULL |
EmailAddress | nvarchar(50) NULL |
EmailPromotion | int NOT NULL |
AddressLine1 | nvarchar(60) NOT NULL |
AddressLine2 | nvarchar(60) NULL |
City | nvarchar(30) NOT NULL |
StateProvinceName | Name NOT NULL |
PostalCode | nvarchar(15) NOT NULL |
CountryRegionName | Name NOT NULL |
TerritoryName | Name NULL |
TerritoryGroup | nvarchar(50) NULL |
SalesQuota | money(19,4) NULL |
SalesYTD | money(19,4) NOT NULL |
SalesLastYear | money(19,4) NOT NULL |