Table Schema: mf_coupons

This topic describes the columns in the mf_coupons table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
coupon_guid uniqueidentifier 1 0 1   2  
company_guid uniqueidentifier 0 0 2   0  
coupon_id varchar (50) 0 0 3   0  
coupon_label varchar (50) 0 1 4   0  
coupon_label_short varchar (50) 0 1 5   0  
coupon_description varchar (255) 0 1 6   0  
coupon_use_per_code smallint 0 1 7   0  
coupon_use_per_customer smallint 0 1 8   0  
coupon_use_per_period smallint 0 1 9   0  
coupon_period smallint 0 1 10   0  
coupon_flag tinyint 0 0 11   0  
coupon_alert tinyint 0 0 12   0  
coupon_visible tinyint 0 0 13   0  
coupon_new tinyint 0 0 14 Status flag- Indicates whether the order is new 0  
coupon_approved tinyint 0 0 15 Work Flow flag- Indicates whether the order is approved 0  
coupon_suspended tinyint 0 0 16   0  
coupon_locked tinyint 0 0 17   0  
coupon_closed tinyint 0 0 18   0  
coupon_filed tinyint 0 0 19 Workflow flag- if set indicates that the record is filed 0  
lu_dt datetime 0 0 20   0  
cr_dt datetime 0 0 21   0  
lu_guid uniqueidentifier 0 1 22   0  
cr_guid uniqueidentifier 0 1 23   0  

Return to index of tables