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. |
See Also