Sales.SalesPersonQuotaHistory
| Documentation | AdventureWorks |
| Schema | Sales |
| Name | SalesPersonQuotaHistory |
| Module | Sales |
Sales performance tracking.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | BusinessEntityID | int | Sales.SalesPerson | Sales person identification number. Foreign key to SalesPerson.BusinessEntityID. | ||||
| Sales person identification number. Foreign key to SalesPerson.BusinessEntityID. References: Sales.SalesPerson |
||||||||
| 2 | QuotaDate | datetime | Sales quota date. | |||||
| Sales quota date. |
||||||||
| 3 | SalesQuota | money | Sales quota amount. | |||||
| Sales quota amount. |
||||||||
| 4 | rowguid | uniqueidentifier | Default: newid() | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | ||||
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid() |
||||||||
| 5 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
| Date and time the record was last updated. Default: getdate() |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| Sales.SalesPersonQuotaHistory | Sales.SalesPerson | Sales.SalesPersonQuotaHistory.BusinessEntityID = Sales.SalesPerson.BusinessEntityID | FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID Foreign key constraint referencing SalesPerson.SalesPersonID. |
|
|
Sales.SalesPersonQuotaHistory.BusinessEntityID = Sales.SalesPerson.BusinessEntityID Name: FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityIDForeign key constraint referencing SalesPerson.SalesPersonID. |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate | BusinessEntityID, QuotaDate | Primary key (clustered) constraint | |
| Primary key (clustered) constraint | |||
| AK_SalesPersonQuotaHistory_rowguid | rowguid | Unique nonclustered index. Used to support replication samples. | |
| Unique nonclustered index. Used to support replication samples. | |||
Uses
| Name |
|---|
|
Sales.SalesPersonQuotaHistory
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56