Generated using SQL Data Dictionary demo version.


Table Sales.SpecialOffer (16 rows)


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.

Indexes:


Referenced by: