Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales SalesReason (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 17:48


wikibot

TableSales.SalesReason
DescriptionLookup table of customer purchase reasons.

ColumnData TypeNullableDefaultDescription / PK / Index
SalesReasonIDintnot null Primary key for SalesReason records.
PK_SalesReason_SalesReasonID
Namedbo.Namenot null Sales reason description.
ReasonTypedbo.Namenot null Category the sales reason belongs to.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



Detail TableColumnReferencing Column
Sales.SalesOrderHeaderSalesReasonSalesReasonIDSalesReasonID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name

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