| Column Name | Data Type | Is Key | Short description |
| PromotionKey | smallint | | Surrogate primary key |
| BKSpecialOfferID | int | | Natural key from source system |
| PromotionName | varchar | | Promotion Name |
| PromotionType | varchar | | Promo type |
| PromotionCategory | varchar | | Is promotion offered to resellers or directly to customers? |
| DiscountPct | smallmoney | | Promotion discount percent |
| PromotionStartDate | datetime | | Promotion start date |
| PromotionEndDate | datetime | | Promotion end date |
| MinQty | int | | Minimum quantity required for promotion |
| MaxQty | int | | Maximum quantity permitted for promotion |
| AuditKey | int | | What process loaded this row? |