SalesPersonQuotaHistory Table (AdventureWorks)

Contains the historical sales information for the sales representatives.

SalesPersonQuotaHistory Table Definition

The SalesPersonQuotaHistory table is contained in the Sales schema.

Column	Data type	Nullability	Description
SalesPersonID	int	Not null	Sales person identification number. Foreign key to SalesPerson.SalesPersonID.
QuotaDate	datetime	Not null	Sales quota date.
SalesQuota	money	Not null	Sales quota amount.
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)
SalesPerson Table (AdventureWorks)
SalesTerritory Table (AdventureWorks)
SalesTerritoryHistory Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance