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. |