Difference between revisions of "Sales.SalesReason (table)"

From dbscript Online Help
Jump to: navigation, search
Line 116: Line 116:
 
| Other
 
| Other
 
| Other
 
| Other
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Sales.SalesReason
 +
|-
 +
 +
| '''Description
 +
| Lookup table of customer purchase reasons.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]]
 +
| SalesReasonID
 +
| SalesReasonID
 
|}
 
|}

Revision as of 00:27, 27 November 2009

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

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.SalesReason_(table)&oldid=1121"