Sales.SalesPersonQuotaHistory (table)

wikibot

Table	Sales.SalesPersonQuotaHistory
Description	Sales performance tracking.

Columns

Column	Data Type	Nullable	Default	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	(newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate	SalesPersonID, QuotaDate

Indexes

Index	Type	Columns
AK_SalesPersonQuotaHistory_rowguid	Unique	rowguid

Check Constraints

Check Constraint	Expression	Description
CK_SalesPersonQuotaHistory_SalesQuota	([SalesQuota]>(0.00))	Check constraint [SalesQuota] > (0.00)

Foreign Keys

Relation	Column	Referenced Column
Sales.SalesPerson	SalesPersonID	SalesPersonID

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

automatically generated

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

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales