Table: 'Sales.SalesReason'

4 fields. 220 bytes.

Lookup table of customer purchase reasons.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
SalesReasonIDint identity int Not nullPrimary key for SalesReason records. 
NameName nvarchar(50) Not nullSales reason description. 
ReasonTypeName nvarchar(50) Not nullCategory the sales reason belongs to. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SalesReason'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'Sales.SalesReason', 1 item

Index NameDescriptionClusteredUniqueFields
PK_SalesReason_SalesReasonIDClustered index created by a primary key constraint.YesYesSalesReasonID

Triggers for table 'Sales.SalesReason', 1 item

uSalesReasonAFTER 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 NameTypeField Name