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

Help and Information

Getting SQL Server 2005 Assistance