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.