Sales SalesReason (table)

Modified on 2011/08/27 11:19 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| Sales.SalesReason
|- valign="top"
| '''Description'''
| Lookup table of customer purchase reasons.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| SalesReasonID
| int
| not null
| &nbsp;
| Primary key for SalesReason records.
|- valign="top"
| Name
| dbo.Name
| not null
| &nbsp;
| Sales reason description.
|- valign="top"
| ReasonType
| dbo.Name
| not null
| &nbsp;
| Category the sales reason belongs to.
|- valign="top"
| ModifiedDate
| datetime
| not null
| (getdate())
| Date and time the record was last updated.
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| PK_SalesReason_SalesReasonID
| SalesReasonID
|}

=== Detail Tables ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[Sales SalesOrderHeaderSalesReason (table)|Sales.SalesOrderHeaderSalesReason]]
| SalesReasonID
| SalesReasonID
|}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type'''
| '''Object Type'''
| '''Referenced Object'''

|- valign="top"
| Data Type
| Type
| [[dbo Name (type)|dbo.Name]]

|- valign="top"
| Schema
| Schema
| [[Sales (schema)|Sales]]

|}


== wikivalues ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table Values'''
| Sales.SalesReason
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"

| '''SalesReasonID'''

| '''Name'''

| '''ReasonType'''

|- valign="top"

| 1
| Price
| Other
|- valign="top"

| 2
| On Promotion
| Promotion
|- valign="top"

| 3
| Magazine Advertisement
| Marketing
|- valign="top"

| 4
| Television  Advertisement
| Marketing
|- valign="top"

| 5
| Manufacturer
| Other
|- valign="top"

| 6
| Review
| Other
|- valign="top"

| 7
| Demo Event
| Marketing
|- valign="top"

| 8
| Sponsorship
| Marketing
|- valign="top"

| 9
| Quality
| Other
|- valign="top"

| 10
| Other
| Other
|}
devio dbscript ScrewTurn Wiki

Navigation¶

Sales SalesReason (table)
