Sales.SalesReason

Field Name Data Type Size Original Type Default Nullable Description Check

SalesReasonID int identity int Not null Primary key for SalesReason records.

Name Name nvarchar(50) Not null Sales reason description.

ReasonType Name nvarchar(50) Not null Category the sales reason belongs to.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Original Type	Default	Nullable	Description
SalesReasonID	int identity	int		Not null	Primary key for SalesReason records.
Name	Name	nvarchar(50)		Not null	Sales reason description.
ReasonType	Name	nvarchar(50)		Not null	Category the sales reason belongs to.
ModifiedDate	datetime		getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SalesReason'

Primary Key Name Field Name

PK_SalesReason_SalesReasonID SalesReasonID

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_SalesReason_SalesReasonID	SalesReasonID

Indexes for table 'Sales.SalesReason', 1 item

Index Name Description Clustered Unique Fields

PK_SalesReason_SalesReasonID Clustered index created by a primary key constraint. Yes Yes SalesReasonID

Index Name	Description	Clustered	Unique	Fields
PK_SalesReason_SalesReasonID	Clustered index created by a primary key constraint.	Yes	Yes	SalesReasonID

Triggers for table 'Sales.SalesReason', 1 item

Name Description Type Enabled

uSalesReason AFTER UPDATE trigger setting the ModifiedDate column in the SalesReason table to the current date. after Update Yes

Name	Description	Type	Enabled
uSalesReason	AFTER UPDATE trigger setting the ModifiedDate column in the SalesReason table to the current date.	after Update	Yes

Dependencies for table 'Sales.SalesReason', 1 item

Object Name Type Field Name

Sales.uSalesReason trigger N/A