Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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