ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Sales.SalesPerson_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | Sales.SalesPerson |- valign="top" | '''Description''' | Sales representative current information. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | SalesPersonID | int | not null | | Primary key for SalesPerson records. |- valign="top" | TerritoryID | int | null | | Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. |- valign="top" | SalesQuota | money | null | | Projected yearly sales. |- valign="top" | Bonus | money | not null | ((0.00)) | Bonus due if quota is met. |- valign="top" | CommissionPct | smallmoney | not null | ((0.00)) | Commision percent received per sale. |- valign="top" | SalesYTD | money | not null | ((0.00)) | Sales total year to date. |- valign="top" | SalesLastYear | money | not null | ((0.00)) | Sales total of previous year. |- valign="top" | rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |- valign="top" | ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PK_SalesPerson_SalesPersonID | SalesPersonID |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | AK_SalesPerson_rowguid | Unique | rowguid |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | CK_SalesPerson_Bonus | ([Bonus]>=(0.00)) | Check constraint [Bonus] >= (0.00) |- valign="top" | CK_SalesPerson_CommissionPct | ([CommissionPct]>=(0.00)) | Check constraint [CommissionPct] >= (0.00) |- valign="top" | CK_SalesPerson_SalesLastYear | ([SalesLastYear]>=(0.00)) | Check constraint [SalesLastYear] >= (0.00) |- valign="top" | CK_SalesPerson_SalesQuota | ([SalesQuota]>(0.00)) | Check constraint [SalesQuota] > (0.00) |- valign="top" | CK_SalesPerson_SalesYTD | ([SalesYTD]>=(0.00)) | Check constraint [SalesYTD] >= (0.00) |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[HumanResources.Employee_(table)|HumanResources.Employee]] | SalesPersonID | EmployeeID |- valign="top" | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] | TerritoryID | TerritoryID |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | SalesPersonID | SalesPersonID |- valign="top" | [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]] | SalesPersonID | SalesPersonID |- valign="top" | [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]] | SalesPersonID | SalesPersonID |- valign="top" | [[Sales.Store_(table)|Sales.Store]] | SalesPersonID | SalesPersonID |} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Schema | Schema | [[Sales_(schema)|Sales]] |} === Dependencies === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' | '''Child Type''' | '''Child Object''' |- valign="top" | Select | View | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] | | |- valign="top" | Select | View | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] | | |- valign="top" | Update | Table | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | Trigger | uSalesOrderHeader |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Sales.SalesPerson |- valign="top" | '''Description''' | Sales representative current information. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | SalesPersonID | int | not null | | Primary key for SalesPerson records.<br />PK_SalesPerson_SalesPersonID |- | TerritoryID | int | null | | Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.<br /> |- | SalesQuota | money | null | | Projected yearly sales.<br /> |- | Bonus | money | not null | (0.00) | Bonus due if quota is met.<br /> |- | CommissionPct | smallmoney | not null | (0.00) | Commision percent received per sale.<br /> |- | SalesYTD | money | not null | (0.00) | Sales total year to date.<br /> |- | SalesLastYear | money | not null | (0.00) | Sales total of previous year.<br /> |- | rowguid | uniqueidentifier | not null | (NEWID()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesPerson_rowguid |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- | [[HumanResources.Employee_(table)|HumanResources.Employee]] | SalesPersonID | EmployeeID |- | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] | TerritoryID | TerritoryID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | SalesPersonID | SalesPersonID |- | [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]] | SalesPersonID | SalesPersonID |- | [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]] | SalesPersonID | SalesPersonID |- | [[Sales.Store_(table)|Sales.Store]] | SalesPersonID | SalesPersonID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Schema | Schema | [[Sales_(schema)|Sales]] |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' | '''Child Type''' | '''Child Object''' |- | Select | View | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] |- | Select | View | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] |- | Update | Table | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | Trigger | uSalesOrderHeader |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.