SalesReason Table (AdventureWorks)
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

SalesReason Table (AdventureWorks)

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

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.

Show:
© 2016 Microsoft