| 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.
|