Sales.SalesPerson (table)

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