Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales SalesPersonQuotaHistory (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:05


wikibot

TableSales.SalesPersonQuotaHistory
DescriptionSales performance tracking.

ColumnData TypeNullableDefaultDescription / PK / Index
SalesPersonIDintnot null Sales person identification number. Foreign key to SalesPerson.SalesPersonID.
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
QuotaDatedatetimenot null Sales quota date.
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
SalesQuotamoneynot null Sales quota amount.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_SalesPersonQuotaHistory_rowguid
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Sales.SalesPersonSalesPersonIDSalesPersonID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.