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

From dbscript Online Help
Jump to: navigation, search
 
(14 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Sales.SalesReason
 
| Sales.SalesReason
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Lookup table of customer purchase reasons.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| SalesReasonID
 
| SalesReasonID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_SalesReason_SalesReasonID
+
| Primary key for SalesReason records.
−
|
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Sales reason description.
−
|
+
|- valign="top"
−
|-
 
 
| ReasonType
 
| ReasonType
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Category the sales reason belongs to.
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (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"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 55: Line 61:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]]
 
| [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]]
 
| SalesReasonID
 
| SalesReasonID
 
| 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 ==
 
== wikivalues ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table Values
 
| '''Table Values
 
| Sales.SalesReason
 
| Sales.SalesReason
−
|-
 
 
|}
 
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
  
−
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 
−
|- style="background:silver"
 
 
| '''SalesReasonID
 
| '''SalesReasonID
 
| '''Name
 
| '''Name
 
| '''ReasonType
 
| '''ReasonType
−
|-  
+
|- valign="top"
−
| 1
+
 
−
| Price
+
| 1
−
| Other
+
| Price
−
|-  
+
| Other
−
| 2
+
|- valign="top"
−
| On Promotion
+
 
−
| Promotion
+
| 2
−
|-  
+
| On Promotion
−
| 3
+
| Promotion
−
| Magazine Advertisement
+
|- valign="top"
−
| Marketing
+
 
−
|-  
+
| 3
−
| 4
+
| Magazine Advertisement
−
| Television  Advertisement
+
| Marketing
−
| Marketing
+
|- valign="top"
−
|-  
+
 
−
| 5
+
| 4
−
| Manufacturer
+
| Television  Advertisement
−
| Other
+
| Marketing
−
|-  
+
|- valign="top"
−
| 6
+
 
−
| Review
+
| 5
−
| Other
+
| Manufacturer
−
|-  
+
| Other
−
| 7
+
|- valign="top"
−
| Demo Event
+
 
−
| Marketing
+
| 6
−
|-  
+
| Review
−
| 8
+
| Other
−
| Sponsorship
+
|- valign="top"
−
| Marketing
+
 
−
|-  
+
| 7
−
| 9
+
| Demo Event
−
| Quality
+
| Marketing
−
| Other
+
|- valign="top"
−
|-  
+
 
−
| 10
+
| 8
−
| Other
+
| Sponsorship
−
| Other
+
| Marketing
 +
|- valign="top"
 +
 
 +
| 9
 +
| Quality
 +
| Other
 +
|- valign="top"
 +
 
 +
| 10
 +
| Other
 +
| Other
 
|}
 
|}
  
Line 124: Line 160:
 
| '''Table
 
| '''Table
 
| Sales.SalesReason
 
| Sales.SalesReason
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Lookup table of customer purchase reasons.
 
| Lookup table of customer purchase reasons.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 139: Line 173:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''Description / PK / Index
−
| '''PK / Index
 
 
 
−
|-
+
|- valign="top"
 
| SalesReasonID
 
| SalesReasonID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for SalesReason records.
+
| Primary key for SalesReason records.<br />PK_SalesReason_SalesReasonID
−
| PK_SalesReason_SalesReasonID
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| Name
 
| Name
 
| not null
 
| not null
 
|  
 
|  
−
| Sales reason description.
+
| Sales reason description.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ReasonType
 
| ReasonType
 
| Name
 
| Name
 
| not null
 
| not null
 
|  
 
|  
−
| Category the sales reason belongs to.
+
| Category the sales reason belongs to.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 184: Line 213:
 
| SalesReasonID
 
| SalesReasonID
 
| SalesReasonID
 
| SalesReasonID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 
|}
 
|}

Latest revision as of 09:56, 27 August 2011

wikibot[edit]

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

Columns[edit]

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[edit]

Primary Key Columns
PK_SalesReason_SalesReasonID SalesReasonID

Detail Tables[edit]

Detail Table Column Referencing Column
Sales.SalesOrderHeaderSalesReason SalesReasonID SalesReasonID

References[edit]

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


wikivalues[edit]

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[edit]

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