Sales.SalesReason (table)

From dbscript Online Help
Revision as of 23:06, 2 February 2010 by Bot (talk | contribs)
Jump to: navigation, search

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