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