Sales.SalesPerson - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Sales
Name	SalesPerson
Module	Sales

Sales representative current information.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int			HumanResources.Employee	Primary key for SalesPerson records. Foreign key to Employee.BusinessEntityID
Primary key for SalesPerson records. Foreign key to Employee.BusinessEntityID References: HumanResources.Employee
	2		TerritoryID	int			Sales.SalesTerritory	Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. References: Sales.SalesTerritory
	3		SalesQuota	money				Projected yearly sales.
Projected yearly sales.
	4		Bonus	money		Default: 0.00		Bonus due if quota is met.
Bonus due if quota is met. Default: 0.00
	5		CommissionPct	smallmoney		Default: 0.00		Commision percent received per sale.
Commision percent received per sale. Default: 0.00
	6		SalesYTD	money		Default: 0.00		Sales total year to date.
Sales total year to date. Default: 0.00
	7		SalesLastYear	money		Default: 0.00		Sales total of previous year.
Sales total of previous year. Default: 0.00
	8		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()
	9		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.SalesPerson		HumanResources.Employee	Sales.SalesPerson.BusinessEntityID = HumanResources.Employee.BusinessEntityID	FK_SalesPerson_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
Sales.SalesPerson.BusinessEntityID = HumanResources.Employee.BusinessEntityID Name: FK_SalesPerson_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
Sales.SalesPerson		Sales.SalesTerritory	Sales.SalesPerson.TerritoryID = Sales.SalesTerritory.TerritoryID	FK_SalesPerson_SalesTerritory_TerritoryID Foreign key constraint referencing SalesTerritory.TerritoryID.
Sales.SalesPerson.TerritoryID = Sales.SalesTerritory.TerritoryID Name: FK_SalesPerson_SalesTerritory_TerritoryID Foreign key constraint referencing SalesTerritory.TerritoryID.
Sales.SalesOrderHeader		Sales.SalesPerson	Sales.SalesOrderHeader.SalesPersonID = Sales.SalesPerson.BusinessEntityID	FK_SalesOrderHeader_SalesPerson_SalesPersonID Foreign key constraint referencing SalesPerson.SalesPersonID.
Sales.SalesOrderHeader.SalesPersonID = Sales.SalesPerson.BusinessEntityID Name: FK_SalesOrderHeader_SalesPerson_SalesPersonID Foreign key constraint referencing SalesPerson.SalesPersonID.
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_BusinessEntityID Foreign key constraint referencing SalesPerson.SalesPersonID.
Sales.SalesTerritoryHistory		Sales.SalesPerson	Sales.SalesTerritoryHistory.BusinessEntityID = Sales.SalesPerson.BusinessEntityID	FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID Foreign key constraint referencing SalesPerson.SalesPersonID.
Sales.SalesTerritoryHistory.BusinessEntityID = Sales.SalesPerson.BusinessEntityID Name: FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID Foreign key constraint referencing SalesPerson.SalesPersonID.
Sales.Store		Sales.SalesPerson	Sales.Store.SalesPersonID = Sales.SalesPerson.BusinessEntityID	FK_Store_SalesPerson_SalesPersonID Foreign key constraint referencing SalesPerson.SalesPersonID
Sales.Store.SalesPersonID = Sales.SalesPerson.BusinessEntityID Name: FK_Store_SalesPerson_SalesPersonID Foreign key constraint referencing SalesPerson.SalesPersonID

Unique keys

	Key name	Columns	Description
	PK_SalesPerson_BusinessEntityID	BusinessEntityID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_SalesPerson_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Uses

Name
Sales.SalesPerson
HumanResources.Employee
Sales.SalesTerritory

Used by

Name
Sales.SalesPerson
Sales.vSalesPerson
Sales.vSalesPersonSalesByFiscalYears
Sales.uSalesOrderHeader
Sales.SalesOrderHeader
Sales.SalesPersonQuotaHistory
Sales.SalesTerritoryHistory
Sales.Store

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56