ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

PoweredBy

Discuss (0)View Page Code History

Sales.SalesPerson_(table)

Modified: 2011/08/27 10:14 by wikibot - Uncategorized

(5) » Production.ProductDescription_(table) » OE.XDBPO_LINEITEMS_TYPE_(type) » Sales.SalesPerson_(table)

wikibot

Table	Sales.SalesPerson
Description	Sales representative current information.

Columns

Column	Data Type	Nullable	Default	Description
SalesPersonID	int	not null		Primary key for SalesPerson records.
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.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_SalesPerson_SalesPersonID	SalesPersonID

Indexes

Index	Type	Columns
AK_SalesPerson_rowguid	Unique	rowguid

Check Constraints

Check Constraint	Expression	Description
CK_SalesPerson_Bonus	(Bonus>=(0.00))	Check constraint Bonus >= (0.00)
CK_SalesPerson_CommissionPct	(CommissionPct>=(0.00))	Check constraint CommissionPct >= (0.00)
CK_SalesPerson_SalesLastYear	(SalesLastYear>=(0.00))	Check constraint SalesLastYear >= (0.00)
CK_SalesPerson_SalesQuota	(SalesQuota>(0.00))	Check constraint SalesQuota > (0.00)
CK_SalesPerson_SalesYTD	(SalesYTD>=(0.00))	Check constraint SalesYTD >= (0.00)

Foreign Keys

Relation	Column	Referenced Column
HumanResources.Employee	SalesPersonID	EmployeeID
Sales.SalesTerritory	TerritoryID	TerritoryID

Detail Tables

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

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

Dependencies

Reference Type	Object Type	Referencing Object	Child Type	Child Object
Select	View	Sales.vSalesPerson
Select	View	Sales.vSalesPersonSalesByFiscalYears
Update	Table	Sales.SalesOrderHeader	Trigger	uSalesOrderHeader

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

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

Reference Type	Object Type	Referencing Object	Child Type	Child Object
Select	View	Sales.vSalesPerson
Select	View	Sales.vSalesPersonSalesByFiscalYears
Update	Table	Sales.SalesOrderHeader	Trigger	uSalesOrderHeader

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.