| 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.
|