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.