Share via


SpecialOffer Table (AdventureWorks)

Is a lookup table that contains the sales discounts.

SpecialOffer Table Definition

The SpecialOffer table is contained in the Sales schema.

Column Data type Nullability Description

SpecialOfferID

int

Not null

Primary key for SpecialOffer rows.

Description

nvarchar(255)

Not null

Discount description.

DiscountPct

smallmoney

Not null

Discount percentage.

Type

nvarchar(50)

Not null

Discount type category.

Category

nvarchar(50)

Not null

Group the discount applies to such as Reseller or Customer.

StartDate

datetime

Not null

Discount start date.

EndDate

datetime

Not null

Discount end date.

MinQty

int

Not null

Minimum discount percent allowed.

MaxQty

int

Null

Maximum discount percent allowed.

rowguid

uniqueidentifier

Not null

ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

Product Table (AdventureWorks)
SpecialOfferProduct Table (AdventureWorks)
SalesOrderDetail Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance