Sales.SpecialOffer (table)

wikibot

Table

Sales.SpecialOffer

Column	Data Type	Nullable	Default	PK	Index
SpecialOfferID	int	not null		PK_SpecialOffer_SpecialOfferID
Description	nvarchar(255)	not null
DiscountPct	smallmoney	not null	((0.00))
Type	nvarchar(50)	not null
Category	nvarchar(50)	not null
StartDate	datetime	not null
EndDate	datetime	not null
MinQty	int	not null	((0))
MaxQty	int	null
rowguid	uniqueidentifier	not null	(newid())		AK_SpecialOffer_rowguid
ModifiedDate	datetime	not null	(getdate())

Detail Table	Column	Referencing Column
Sales.SpecialOfferProduct	SpecialOfferID	SpecialOfferID