This topic describes the columns in the mf_promotions table.
| Column Name | Data Type | Primary Key | Is Nullable | Column ID | Comment | Reference Count | Reference To |
|---|---|---|---|---|---|---|---|
| promotion_guid | uniqueidentifier | 1 | 0 | 1 | 4 | ||
| company_guid | uniqueidentifier | 0 | 0 | 2 | 0 | mf_companies.company_guid | |
| catalog_guid | uniqueidentifier | 0 | 1 | 3 | 0 | mf_catalogs.catalog_guid | |
| addin_guid | uniqueidentifier | 0 | 1 | 4 | 0 | ||
| reference_guid | uniqueidentifier | 0 | 1 | 5 | 0 | ||
| promotion_handler_guid | uniqueidentifier | 0 | 1 | 6 | 0 | ||
| item_price_level_guid | uniqueidentifier | 0 | 1 | 7 | 0 | mf_item_price_levels.item_price_level_guid | |
| promotion_id | varchar (50) | 0 | 1 | 8 | 0 | ||
| promotion_label | varchar (50) | 0 | 1 | 9 | 0 | ||
| promotion_label_short | varchar (50) | 0 | 1 | 10 | 0 | ||
| promotion_description | varchar (500) | 0 | 1 | 11 | 0 | ||
| promotion_tag | varchar (1000) | 0 | 1 | 12 | 0 | ||
| promotion_configuration_id | varchar (50) | 0 | 1 | 13 | 0 | ||
| promotion_configuration_label | varchar (255) | 0 | 1 | 14 | 0 | ||
| promotion_configuration_data | varchar (max) | 0 | 1 | 15 | 0 | ||
| promotion_configuration_version | varchar (25) | 0 | 1 | 16 | 0 | ||
| promotion_visible | tinyint | 0 | 0 | 17 | 0 | ||
| promotion_closed | tinyint | 0 | 0 | 18 | 0 | ||
| lu_dt | datetime | 0 | 0 | 19 | 0 | ||
| cr_dt | datetime | 0 | 0 | 20 | 0 | ||
| lu_guid | uniqueidentifier | 0 | 1 | 21 | 0 | ||
| cr_guid | uniqueidentifier | 0 | 1 | 22 | 0 | ||
| promotion_code | varchar (50) | 0 | 1 | 23 | 0 | ||
| promotion_code_cd_expression | varchar (100) | 0 | 1 | 24 | 0 | ||
| promotion_calc_basis_id | smallint | 0 | 0 | 25 | 0 | ||
| promotion_calc_method_id | smallint | 0 | 0 | 26 | 0 | ||
| promotion_value | float | 0 | 1 | 27 | 0 | ||
| promotion_discount | float | 0 | 1 | 28 | 0 | ||
| promotion_free_ship | bit | 0 | 0 | 29 | 0 | ||
| promotion_start | datetime | 0 | 1 | 30 | 0 | ||
| promotion_end | datetime | 0 | 1 | 31 | 0 | ||
| promotion_min | money | 0 | 1 | 32 | 0 | ||
| promotion_max | money | 0 | 1 | 33 | 0 | ||
| promotion_order | smallint | 0 | 0 | 34 | 0 | ||
| promotion_sort | smallint | 0 | 0 | 35 | 0 | ||
| promotion_global | tinyint | 0 | 0 | 36 | 0 | ||
| promotion_private | tinyint | 0 | 0 | 37 | 0 | ||
| promotion_restricted | tinyint | 0 | 0 | 38 | 0 | ||
| promotion_singleuse | tinyint | 0 | 0 | 39 | 0 | ||
| promotion_singleuse_customer | tinyint | 0 | 0 | 40 | 0 | ||
| promotion_configuration_key | varchar (50) | 0 | 1 | 41 | Deprecated in favor of _id column. Will be removed in a future release. | 0 |