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=...)
 
 
(19 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"
 +
|- 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
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Sales.SalesReason
 +
|- valign="top"
 +
| '''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
 +
 +
|- valign="top"
 +
| SalesReasonID
 +
| int
 +
| not null
 
|  
 
|  
 +
| Primary key for SalesReason records.<br />PK_SalesReason_SalesReasonID
 +
|- valign="top"
 +
| Name
 +
| Name
 +
| not null
 +
|
 +
| Sales reason description.<br />
 +
|- valign="top"
 +
| ReasonType
 +
| Name
 +
| not null
 
|  
 
|  
 +
| Category the sales reason belongs to.<br />
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (GETDATE())
 +
| Date and time the record was last updated.<br />
 
|}
 
|}
  
Line 60: 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"