ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

PoweredBy

Discuss (0)View Page Code History

Sales.SalesReason_(table)

Modified: 2011/08/27 10:14 by wikibot - Uncategorized

» Sales.SalesReason_(table)

wikibot

Table	Sales.SalesReason
Description	Lookup table of customer purchase reasons.

Columns

Column	Data Type	Nullable	Default	Description
SalesReasonID	int	not null		Primary key for SalesReason records.
Name	dbo.Name	not null		Sales reason description.
ReasonType	dbo.Name	not null		Category the sales reason belongs to.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_SalesReason_SalesReasonID	SalesReasonID

Detail Tables

Detail Table	Column	Referencing Column
Sales.SalesOrderHeaderSalesReason	SalesReasonID	SalesReasonID

References

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Sales

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

automatically generated

Table	Sales.SalesReason
Description	Lookup table of customer purchase reasons.

Column	Data Type	Nullable	Default	Description / PK / Index
SalesReasonID	int	not null		Primary key for SalesReason records. PK_SalesReason_SalesReasonID
Name	Name	not null		Sales reason description.
ReasonType	Name	not null		Category the sales reason belongs to.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Sales.SalesOrderHeaderSalesReason	SalesReasonID	SalesReasonID

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Sales

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