Sales.SalesOrderHeaderSalesReason (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

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

Columns[edit]

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[edit]

Primary Key Columns
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID SalesOrderID, SalesReasonID

Foreign Keys[edit]

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

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

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