Sales.SalesReason (table)

wikibot

Table

Sales.SalesReason

Column	Data Type	Nullable	Default	PK	Index
SalesReasonID	int	not null		PK_SalesReason_SalesReasonID
Name	dbo.Name	not null
ReasonType	dbo.Name	not null
ModifiedDate	datetime	not null	(getdate())

Detail Table	Column	Referencing Column
Sales.SalesOrderHeaderSalesReason	SalesReasonID	SalesReasonID

wikivalues

Table Values

Sales.SalesReason

SalesReasonID	Name	ReasonType
1	Price	Other
2	On Promotion	Promotion
3	Magazine Advertisement	Marketing
4	Television Advertisement	Marketing
5	Manufacturer	Other
6	Review	Other
7	Demo Event	Marketing
8	Sponsorship	Marketing
9	Quality	Other
10	Other	Other