Difference between revisions of "Sales.SalesReason (table)"
(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 15: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 |