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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SalesReason |- |} {| border="1" cellpadding="5" cellspacing="0" style=...)
 
Line 60: Line 60:
 
| SalesReasonID
 
| SalesReasonID
 
| SalesReasonID
 
| SalesReasonID
 +
|}
 +
 +
== wikivalues ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table Values
 +
| Sales.SalesReason
 +
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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
 
|}
 
|}

Revision as of 14:53, 3 January 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
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.SalesReason_(table)&oldid=303"