Generated using SQL Data Dictionary demo version.

Table Sales.SalesPerson (17 rows)

Sales representative current information.

  Column Data Type Identity Nullable Default
PK, FK BusinessEntityID int
Primary key for SalesPerson records. Foreign key to Employee.BusinessEntityID
FK TerritoryID int X
Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
SalesQuota money X
Projected yearly sales.
Bonus money 0.00
Bonus due if quota is met.
CommissionPct smallmoney 0.00
Commision percent received per sale.
SalesYTD money 0.00
Sales total year to date.
SalesLastYear money 0.00
Sales total of previous year.
UK rowguid uniqueidentifier newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime getdate()
Date and time the record was last updated.



Referenced by:

Used by: