Table Schema: mf_promotions

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  

Return to index of tables