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
Reference
SalesOrderHeader Table (AdventureWorks)
SalesOrderHeaderSalesReason Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary