ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
Sales.SalesOrderHeaderSalesReason_(table)
Print
RSS
Modified: 2011/08/27 10:14 by
wikibot
-
Uncategorized
»
OE.XDBPO_ACTIONS_TYPE_(type)
»
Sales.SalesOrderHeaderSalesReason_(table)
[X]
»
OE.XDBPO_ACTIONS_TYPE_(type)
»
Sales.SalesOrderHeaderSalesReason_(table)
Edit
wikibot
Table
Sales.SalesOrderHeaderSalesReason
Description
Cross-reference table mapping sales orders to sales reason codes.
Edit
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.
Edit
Primary Key
Primary Key
Columns
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
SalesOrderID, SalesReasonID
Edit
Foreign Keys
Relation
Column
Referenced Column
Sales.SalesOrderHeader
SalesOrderID
SalesOrderID
Sales.SalesReason
SalesReasonID
SalesReasonID
Edit
References
Dependency Type
Object Type
Referenced Object
Schema
Schema
Sales
Edit
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
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.