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