Sales.SalesOrderHeaderSalesReason (table)

wikibot

Table

Sales.SalesOrderHeaderSalesReason

Column	Data Type	Nullable	Default	PK	Index
SalesOrderID	int	not null		PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
SalesReasonID	int	not null		PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Sales.SalesOrderHeader	SalesOrderID	SalesOrderID
Sales.SalesReason	SalesReasonID	SalesReasonID

automatically generated

Table	Sales.SalesOrderHeaderSalesReason
Description	Cross-reference table mapping sales orders to sales reason codes.

Column	Data Type	Nullable	Default	Description / PK / Index
SalesOrderID	int	not null		Primary key. Foreign key to SalesOrderHeader.SalesOrderID.PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
SalesReasonID	int	not null		Primary key. Foreign key to SalesReason.SalesReasonID.PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Sales.SalesOrderHeader	SalesOrderID	SalesOrderID
Sales.SalesReason	SalesReasonID	SalesReasonID