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())

Detail Table	Column	Referencing Column
Sales.SalesOrderHeader	SalesPersonID	SalesPersonID
Sales.SalesPersonQuotaHistory	SalesPersonID	SalesPersonID
Sales.SalesTerritoryHistory	SalesPersonID	SalesPersonID
Sales.Store	SalesPersonID	SalesPersonID

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.

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