Sales.SpecialOffer

Generated using SQL Data Dictionary demo version.

Sale discounts lookup table.

	Column	Data Type	Identity	Nullable	Default
PK	SpecialOfferID	int	X
Primary key for SpecialOffer records.
	Description	nvarchar(255)
Discount description.
	DiscountPct	smallmoney			0.00
Discount precentage.
	Type	nvarchar(50)
Discount type category.
	Category	nvarchar(50)
Group the discount applies to such as Reseller or Customer.
	StartDate	datetime
Discount start date.
	EndDate	datetime
Discount end date.
	MinQty	int			0
Minimum discount percent allowed.
	MaxQty	int		X
Maximum discount percent allowed.
UK	rowguid	uniqueidentifier			newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
	ModifiedDate	datetime			getdate()
Date and time the record was last updated.

PK_SpecialOffer_SpecialOfferID
- (Primary Key)
- (Clustered)
Primary key (clustered) constraint
- SpecialOfferID

AK_SpecialOffer_rowguid
- (Unique)
Unique nonclustered index. Used to support replication samples.
- rowguid