From dbscript Online Help
wikibot
| 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())
|
|
|
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.
|
|
