Sales.SalesPersonQuotaHistory

Table: 'Sales.SalesPersonQuotaHistory'

Field Name Data Type Size Original Type Default Nullable Description Check

SalesPersonID int Not null Sales person identification number. Foreign key to SalesPerson.SalesPersonID.

QuotaDate datetime Not null Sales quota date.

SalesQuota money 19,4 decimal(19,4) Not null Sales quota amount. ([SalesQuota]>(0.00))

rowguid uniqueidentifier newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
SalesPersonID	int				Not null	Sales person identification number. Foreign key to SalesPerson.SalesPersonID.
QuotaDate	datetime				Not null	Sales quota date.
SalesQuota	money	19,4	decimal(19,4)		Not null	Sales quota amount.	([SalesQuota]>(0.00))
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SalesPersonQuotaHistory'

Primary Key Name Field Names

PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate SalesPersonID, QuotaDate

Primary Key Name	Field Names
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate	SalesPersonID, QuotaDate

Foreign keys for table 'Sales.SalesPersonQuotaHistory', 1 item

Foreign Primary Key Name

SalesPersonQuotaHistory.SalesPersonID SalesPerson.SalesPersonID FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID

Foreign	Primary	Key Name
SalesPersonQuotaHistory.SalesPersonID	SalesPerson.SalesPersonID	FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID

Indexes for table 'Sales.SalesPersonQuotaHistory', 2 items

Index Name Description Clustered Unique Fields

PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate Clustered index created by a primary key constraint. Yes Yes SalesPersonID, QuotaDate

AK_SalesPersonQuotaHistory_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

Index Name	Description	Clustered	Unique	Fields
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate	Clustered index created by a primary key constraint.	Yes	Yes	SalesPersonID, QuotaDate
AK_SalesPersonQuotaHistory_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid

Triggers for table 'Sales.SalesPersonQuotaHistory', 1 item

Name Description Type Enabled

uSalesPersonQuotaHistory AFTER UPDATE trigger setting the ModifiedDate column in the SalesPersonQuotaHistory table to the current date. after Update Yes

Name	Description	Type	Enabled
uSalesPersonQuotaHistory	AFTER UPDATE trigger setting the ModifiedDate column in the SalesPersonQuotaHistory table to the current date.	after Update	Yes

Dependencies for table 'Sales.SalesPersonQuotaHistory', 2 items

Object Name Type Field Name

Sales.CK_SalesPersonQuotaHistory_SalesQuota check cns N/A

Sales.uSalesPersonQuotaHistory trigger N/A