Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
Sales SalesOrderHeaderSalesReason (table)
Print
RSS
Modified on 2011/08/27 11:19
by
wikibot
Categorized as
Uncategorized
Sales (schema)
Sales SalesOrderHeader (table)
Sales SalesReason (table)
Sales (schema)
Sales SalesOrderHeader (table)
Sales SalesReason (table)
»
Sales SalesOrderHeaderSalesReason (table)
[X]
»
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
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.