Sales.SpecialOffer (table)

wikibot

Table	Sales.SpecialOffer
Description	Sale discounts lookup table.

Columns

Column	Data Type	Nullable	Default	Description
SpecialOfferID	int	not null		Primary key for SpecialOffer records.
Description	nvarchar(255)	not null		Discount description.
DiscountPct	smallmoney	not null	((0.00))	Discount precentage.
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	((0))	Minimum discount percent allowed.
MaxQty	int	null		Maximum discount percent allowed.
rowguid	uniqueidentifier	not null	(newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_SpecialOffer_SpecialOfferID	SpecialOfferID

Indexes

Index	Type	Columns
AK_SpecialOffer_rowguid	Unique	rowguid

Check Constraints

Check Constraint	Expression	Description
CK_SpecialOffer_DiscountPct	([DiscountPct]>=(0.00))	Check constraint [DiscountPct] >= (0.00)
CK_SpecialOffer_EndDate	([EndDate]>=[StartDate])	Check constraint [EndDate] >= [StartDate]
CK_SpecialOffer_MaxQty	([MaxQty]>=(0))	Check constraint [MaxQty] >= (0)
CK_SpecialOffer_MinQty	([MinQty]>=(0))	Check constraint [MinQty] >= (0)

Detail Tables

Detail Table	Column	Referencing Column
Sales.SpecialOfferProduct	SpecialOfferID	SpecialOfferID

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales

automatically generated

Table	Sales.SpecialOffer
Description	Sale discounts lookup table.

Column	Data Type	Nullable	Default	Description / PK / Index
SpecialOfferID	int	not null		Primary key for SpecialOffer records. PK_SpecialOffer_SpecialOfferID
Description	nvarchar(255)	not null		Discount description.
DiscountPct	smallmoney	not null	(0.00)	Discount precentage.
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	(0)	Minimum discount percent allowed.
MaxQty	int	null		Maximum discount percent allowed.
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_SpecialOffer_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Sales.SpecialOfferProduct	SpecialOfferID	SpecialOfferID

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales