SalesReason Table (AdventureWorks)

Is a lookup table that contains the reasons why a customer may purchase a particular product.

SalesReason Table Definition

The SalesReason table is contained in the Sales schema.

Column	Data type	Nullability	Description
SalesReasonID	int	Not null	Primary key for SalesReason rows.
Name	Name (user-defined type) nvarchar(50)	Not null	Sales reason description.
ReasonType	Name (user-defined type) nvarchar(50)	Not null	Category to which the sales reason belongs.
ModifiedDate	datetime	Not null	Date and time the row was last updated.