SpecialOffer Table (AdventureWorks)
Is a lookup table that contains the sales discounts.
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. |
