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