Difference between revisions of "Sales.SalesPerson (table)"
| Line 153: | Line 153: | ||
| not null | | not null | ||
| | | | ||
| − | | Primary key for SalesPerson records.PK_SalesPerson_SalesPersonID | + | | Primary key for SalesPerson records.<br />PK_SalesPerson_SalesPersonID |
|- valign="top" | |- valign="top" | ||
| TerritoryID | | TerritoryID | ||
| Line 159: | Line 159: | ||
| null | | null | ||
| | | | ||
| − | | Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. | + | | Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.<br /> |
|- valign="top" | |- valign="top" | ||
| SalesQuota | | SalesQuota | ||
| Line 165: | Line 165: | ||
| null | | null | ||
| | | | ||
| − | | Projected yearly sales. | + | | Projected yearly sales.<br /> |
|- valign="top" | |- valign="top" | ||
| Bonus | | Bonus | ||
| Line 171: | Line 171: | ||
| not null | | not null | ||
| (0.00) | | (0.00) | ||
| − | | Bonus due if quota is met. | + | | Bonus due if quota is met.<br /> |
|- valign="top" | |- valign="top" | ||
| CommissionPct | | CommissionPct | ||
| Line 177: | Line 177: | ||
| not null | | not null | ||
| (0.00) | | (0.00) | ||
| − | | Commision percent received per sale. | + | | Commision percent received per sale.<br /> |
|- valign="top" | |- valign="top" | ||
| SalesYTD | | SalesYTD | ||
| Line 183: | Line 183: | ||
| not null | | not null | ||
| (0.00) | | (0.00) | ||
| − | | Sales total year to date. | + | | Sales total year to date.<br /> |
|- valign="top" | |- valign="top" | ||
| SalesLastYear | | SalesLastYear | ||
| Line 189: | Line 189: | ||
| not null | | not null | ||
| (0.00) | | (0.00) | ||
| − | | Sales total of previous year. | + | | Sales total of previous year.<br /> |
|- valign="top" | |- valign="top" | ||
| rowguid | | rowguid | ||
| Line 195: | Line 195: | ||
| not null | | not null | ||
| (NEWID()) | | (NEWID()) | ||
| − | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_SalesPerson_rowguid | + | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesPerson_rowguid |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
| Line 201: | Line 201: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
| − | | Date and time the record was last updated. | + | | Date and time the record was last updated.<br /> |
|} | |} | ||
Revision as of 01:10, 27 November 2009
wikibot
| Table | Sales.SalesPerson |
| Column | Data Type | Nullable | Default | PK | Index |
| SalesPersonID | int | not null | PK_SalesPerson_SalesPersonID | ||
| TerritoryID | int | null | |||
| SalesQuota | money | null | |||
| Bonus | money | not null | ((0.00)) | ||
| CommissionPct | smallmoney | not null | ((0.00)) | ||
| SalesYTD | money | not null | ((0.00)) | ||
| SalesLastYear | money | not null | ((0.00)) | ||
| rowguid | uniqueidentifier | not null | (newid()) | AK_SalesPerson_rowguid | |
| ModifiedDate | datetime | not null | (getdate()) |
| Relation | Column | Referenced Column |
| HumanResources.Employee | SalesPersonID | EmployeeID |
| Sales.SalesTerritory | TerritoryID | TerritoryID |
| Detail Table | Column | Referencing Column |
| Sales.SalesOrderHeader | SalesPersonID | SalesPersonID |
| Sales.SalesPersonQuotaHistory | SalesPersonID | SalesPersonID |
| Sales.SalesTerritoryHistory | SalesPersonID | SalesPersonID |
| Sales.Store | SalesPersonID | SalesPersonID |
automatically generated
| Table | Sales.SalesPerson |
| Description | Sales representative current information. |
| Column | Data Type | Nullable | Default | Description / PK / Index |
| SalesPersonID | int | not null | Primary key for SalesPerson records. PK_SalesPerson_SalesPersonID | |
| 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. AK_SalesPerson_rowguid |
| ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated. |
| Relation | Column | Referenced Column |
| HumanResources.Employee | SalesPersonID | EmployeeID |
| Sales.SalesTerritory | TerritoryID | TerritoryID |
| Detail Table | Column | Referencing Column |
| Sales.SalesOrderHeader | SalesPersonID | SalesPersonID |
| Sales.SalesPersonQuotaHistory | SalesPersonID | SalesPersonID |
| Sales.SalesTerritoryHistory | SalesPersonID | SalesPersonID |
| Sales.Store | SalesPersonID | SalesPersonID |
| Referencing Object | Object Type | Reference Type |
| Sales.vSalesPerson | View | Select |
| Sales.vSalesPersonSalesByFiscalYears | View | Select |
| Sales.SalesOrderHeader | Table | Update |
