Databases > AdventureWorks2019 > Tables > Sales.SalesReason

AdventureWorks2019

Sales.SalesReason

//
Lookup table of customer purchase reasons.

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    SalesReasonID
    [int] IDENTITY (1,1) NOT NULL
  • //
    ${escapify(column.description)}
    Name
    [Name] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [nvarchar](50) NULL
  • //
    ${escapify(column.description)}
    ReasonType
    [Name] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [nvarchar](50) NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_SalesReason_SalesReasonID
    UNIQUE CLUSTERED
    SalesReasonID

Sample Data

SalesReasonID
Name
ReasonType
ModifiedDate
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