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