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.