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.