ScrewTurn Wiki

Edit

wikibot

TableSales.SalesReason
DescriptionLookup table of customer purchase reasons.

Edit

Columns

ColumnData TypeNullableDefaultDescription
SalesReasonIDintnot null Primary key for SalesReason records.
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.

Edit

Primary Key

Primary KeyColumns
PK_SalesReason_SalesReasonIDSalesReasonID

Edit

Detail Tables

Detail TableColumnReferencing Column
Sales.SalesOrderHeaderSalesReasonSalesReasonIDSalesReasonID

Edit

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaSales

Edit

wikivalues

Table ValuesSales.SalesReason

SalesReasonIDNameReasonType
1PriceOther
2On PromotionPromotion
3Magazine AdvertisementMarketing
4Television AdvertisementMarketing
5ManufacturerOther
6ReviewOther
7Demo EventMarketing
8SponsorshipMarketing
9QualityOther
10OtherOther

Edit

automatically generated

TableSales.SalesReason
DescriptionLookup table of customer purchase reasons.

ColumnData TypeNullableDefaultDescription / PK / Index
SalesReasonIDintnot null Primary key for SalesReason records.
PK_SalesReason_SalesReasonID
NameNamenot null Sales reason description.
ReasonTypeNamenot 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
SchemaSchemaSales

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