Sales.SalesOrderHeaderSalesReason (table)

wikibot

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

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