SalesOrderHeaderSalesReason Table (AdventureWorks)
Is a cross-reference table that maps the sales orders to the sales-reason codes.
SalesOrderHeaderSalesReason Table Definition
The SalesOrderHeaderSalesReason table is contained in the Sales schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
SalesOrderID |
int |
Not null |
Primary key. Foreign key to SalesOrderHeader.SalesOrderID. |
SalesReasonID |
int |
Not null |
Primary key. Foreign key to SalesReason.SalesReasonID. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
SalesOrderHeader Table (AdventureWorks)
SalesReason Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary