Share via


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

Help and Information

Getting SQL Server 2005 Assistance