Sales.SalesOrderHeaderSalesReason (table)

wikibot

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

Columns

Column	Data Type	Nullable	Default	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	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID	SalesOrderID, SalesReasonID

Foreign Keys

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

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

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

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales