Sales.SalesPersonQuotaHistory (table)

wikibot

Table

Sales.SalesPersonQuotaHistory

Column	Data Type	Nullable	Default	PK	Index
SalesPersonID	int	not null		PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
QuotaDate	datetime	not null		PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
SalesQuota	money	not null
rowguid	uniqueidentifier	not null	(newid())		AK_SalesPersonQuotaHistory_rowguid
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Sales.SalesPerson	SalesPersonID	SalesPersonID

Table	Sales.SalesPersonQuotaHistory
Description	Sales performance tracking.

Column	Data Type	Nullable	Default	Description / PK / Index
SalesPersonID	int	not null		Sales person identification number. Foreign key to SalesPerson.SalesPersonID. PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
QuotaDate	datetime	not null		Sales quota date. PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
SalesQuota	money	not null		Sales quota amount.
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_SalesPersonQuotaHistory_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Sales.SalesPerson	SalesPersonID	SalesPersonID