Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales SalesOrderHeaderSalesReason (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:48


wikibot

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

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