Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

SalesOrderHeaderSalesReason Table (AdventureWorks)

Is a cross-reference table that maps the sales orders to the sales-reason codes.

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.

Community Additions

ADD
Show:
© 2015 Microsoft