Sales.SalesOrderHeaderSalesReason

Table: 'Sales.SalesOrderHeaderSalesReason'

3 fields. 24 bytes.

Cross-reference table mapping sales orders to sales reason codes.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
SalesOrderID	int				Not null	Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
SalesReasonID	int				Not null	Primary key. Foreign key to SalesReason.SalesReasonID.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SalesOrderHeaderSalesReason'

Primary Key Name	Field Names
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID	SalesOrderID, SalesReasonID

Foreign keys for table 'Sales.SalesOrderHeaderSalesReason', 2 items

Foreign	Primary	Key Name
SalesOrderHeaderSalesReason.SalesOrderID	SalesOrderHeader.SalesOrderID	FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID
SalesOrderHeaderSalesReason.SalesReasonID	SalesReason.SalesReasonID	FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID

Indexes for table 'Sales.SalesOrderHeaderSalesReason', 1 item

Index Name	Description	Clustered	Unique	Fields
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID	Clustered index created by a primary key constraint.	Yes	Yes	SalesOrderID, SalesReasonID

Triggers for table 'Sales.SalesOrderHeaderSalesReason', 1 item

Name	Description	Type	Enabled
uSalesOrderHeaderSalesReason	AFTER UPDATE trigger setting the ModifiedDate column in the SalesOrderHeaderSalesReason table to the current date.	after Update	Yes

Dependencies for table 'Sales.SalesOrderHeaderSalesReason', 1 item

Object Name	Type	Field Name
Sales.uSalesOrderHeaderSalesReason	trigger	N/A