Sales.SalesPerson

Table: 'Sales.SalesPerson'

9 fields. 136 bytes.

Sales representative current information.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
SalesPersonIDint   Not nullPrimary key for SalesPerson records. 
TerritoryIDint   NullTerritory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. 
SalesQuotamoney19,4decimal(19,4) NullProjected yearly sales.([SalesQuota]>(0.00))
Bonusmoney19,4decimal(19,4)(0.00)Not nullBonus due if quota is met.([Bonus]>=(0.00))
CommissionPctsmallmoney10,4decimal(10,4)(0.00)Not nullCommision percent received per sale.([CommissionPct]>=(0.00))
SalesYTDmoney19,4decimal(19,4)(0.00)Not nullSales total year to date.([SalesYTD]>=(0.00))
SalesLastYearmoney19,4decimal(19,4)(0.00)Not nullSales total of previous year.([SalesLastYear]>=(0.00))
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SalesPerson'

Primary Key NameField Name
PK_SalesPerson_SalesPersonIDSalesPersonID

Foreign keys for table 'Sales.SalesPerson', 2 items

ForeignPrimaryKey Name
SalesPerson.SalesPersonIDEmployee.EmployeeIDFK_SalesPerson_Employee_SalesPersonID
SalesPerson.TerritoryIDSalesTerritory.TerritoryIDFK_SalesPerson_SalesTerritory_TerritoryID

Indexes for table 'Sales.SalesPerson', 2 items

Index NameDescriptionClusteredUniqueFields
PK_SalesPerson_SalesPersonIDClustered index created by a primary key constraint.YesYesSalesPersonID
AK_SalesPerson_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid

Triggers for table 'Sales.SalesPerson', 1 item

NameDescriptionTypeEnabled
uSalesPersonAFTER UPDATE trigger setting the ModifiedDate column in the SalesPerson table to the current date.after Update Yes

Dependencies for table 'Sales.SalesPerson', 9 items

Object NameTypeField Name
Sales.CK_SalesPerson_Bonuscheck cnsN/A
Sales.CK_SalesPerson_CommissionPctcheck cnsN/A
Sales.CK_SalesPerson_SalesLastYearcheck cnsN/A
Sales.CK_SalesPerson_SalesQuotacheck cnsN/A
Sales.CK_SalesPerson_SalesYTDcheck cnsN/A
Sales.uSalesOrderHeadertriggerN/A
Sales.uSalesPersontriggerN/A
Sales.vSalesPersonviewN/A
Sales.vSalesPersonSalesByFiscalYearsviewN/A