Generated using SQL Data Dictionary demo version.
Sales representative current information.
| Column | Data Type | Identity | Nullable | Default | |
|---|---|---|---|---|---|
| PK, FK | BusinessEntityID | int | |||
| Primary key for SalesPerson records. Foreign key to Employee.BusinessEntityID | |||||
| FK | TerritoryID | int | X | ||
| Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. | |||||
| SalesQuota | money | X | |||
| Projected yearly sales. | |||||
| Bonus | money | 0.00 | |||
| Bonus due if quota is met. | |||||
| CommissionPct | smallmoney | 0.00 | |||
| Commision percent received per sale. | |||||
| SalesYTD | money | 0.00 | |||
| Sales total year to date. | |||||
| SalesLastYear | money | 0.00 | |||
| Sales total of previous year. | |||||
| UK | rowguid | uniqueidentifier | newid() | ||
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | |||||
| ModifiedDate | datetime | getdate() | |||
| Date and time the record was last updated. | |||||
Primary key (clustered) constraint
Unique nonclustered index. Used to support replication samples.