Export (0) Print
Expand All
Expand Minimize

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.

Community Additions

ADD
Show:
© 2014 Microsoft