ScrewTurn Wiki

Edit

wikibot

TableSales.SalesOrderHeaderSalesReason
DescriptionCross-reference table mapping sales orders to sales reason codes.

Edit

Columns

ColumnData TypeNullableDefaultDescription
SalesOrderIDintnot null Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
SalesReasonIDintnot null Primary key. Foreign key to SalesReason.SalesReasonID.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Edit

Primary Key

Primary KeyColumns
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonIDSalesOrderID, SalesReasonID

Edit

Foreign Keys

RelationColumnReferenced Column
Sales.SalesOrderHeaderSalesOrderIDSalesOrderID
Sales.SalesReasonSalesReasonIDSalesReasonID

Edit

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales

Edit

automatically generated

TableSales.SalesOrderHeaderSalesReason
DescriptionCross-reference table mapping sales orders to sales reason codes.

ColumnData TypeNullableDefaultDescription / PK / Index
SalesOrderIDintnot null Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
SalesReasonIDintnot null Primary key. Foreign key to SalesReason.SalesReasonID.
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



RelationColumnReferenced Column
Sales.SalesOrderHeaderSalesOrderIDSalesOrderID
Sales.SalesReasonSalesReasonIDSalesReasonID

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.