| Column | Data Type | Nullable | Default | Description |
| SalesPersonID | int | not null | | Primary key for SalesPerson records. |
| TerritoryID | int | null | | Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. |
| SalesQuota | money | null | | Projected yearly sales. |
| Bonus | money | not null | ((0.00)) | Bonus due if quota is met. |
| CommissionPct | smallmoney | not null | ((0.00)) | Commision percent received per sale. |
| SalesYTD | money | not null | ((0.00)) | Sales total year to date. |
| SalesLastYear | money | not null | ((0.00)) | Sales total of previous year. |
| 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. |