SalesPerson Table (AdventureWorks)

Contains current sales information for the sales representatives.

SalesPerson Table Definition

The SalesPerson table is contained in the Sales schema.

Column	Data type	Nullability	Description
SalesPersonID	int	Not null	Primary key for SalesPerson rows.
TerritoryID	int	Null	Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
SalesQuota	money	Null	Projected yearly sales.
Bonus	money	Not null	Bonus due if quota is met.
CommissionPct	smallmoney	Not null	Commission percent received per sale.
SalesYTD	money	Not null	Sales total year to date.
SalesLastYear	money	Not null	Sales total of previous year.
rowguid	uniqueidentifier	Not null	ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
ModifiedDate	datetime	Not null	Date and time the row was last updated.

See Also

Reference

Employee Table (AdventureWorks)

SalesOrderHeader Table (AdventureWorks)

SalesPersonQuotaHistory Table (AdventureWorks)

SalesTerritory Table (AdventureWorks)

SalesTerritoryHistory Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary