Sales SalesReason (table)

wikibot

TableSales.SalesReason
DescriptionLookup table of customer purchase reasons.

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.

Primary Key

Primary KeyColumns
PK_SalesReason_SalesReasonIDSalesReasonID

Detail Tables

Detail TableColumnReferencing Column
Sales.SalesOrderHeaderSalesReasonSalesReasonIDSalesReasonID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaSales

wikivalues

Table ValuesSales.SalesReason

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