Table Schema: mf_giftcards

This topic describes the columns in the mf_giftcards table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
giftcard_guid uniqueidentifier 1 0 1   2  
company_guid uniqueidentifier 0 0 2   0  
customer_guid uniqueidentifier 0 1 3   0 mf_customers.customer_guid
giftcard_code_guid uniqueidentifier 0 1 4   0  
payment_account_guid uniqueidentifier 0 1 5   0  
iso_currency_cd char (3) 0 1 6   0  
giftcard_id varchar (50) 0 1 7   0  
giftcard_number varchar (200) 0 1 8   0  
giftcard_number_masked varchar (25) 0 1 9   0  
giftcard_pin varchar (10) 0 1 10   0  
giftcard_tag varchar (255) 0 1 11   0  
giftcard_starting_balance money 0 0 12   0  
giftcard_balance money 0 0 13   0  
giftcard_expiration datetime 0 1 14   0  
giftcard_card_holder_name varchar (255) 0 1 15   0  
giftcard_attention varchar (255) 0 1 16   0  
giftcard_address varchar (80) 0 1 17   0  
giftcard_address2 varchar (80) 0 1 18   0  
giftcard_address3 varchar (80) 0 1 19   0  
giftcard_city varchar (50) 0 1 20   0  
giftcard_country_region_id smallint 0 1 21   0  
giftcard_country_region_name nvarchar (50) 0 1 22   0  
giftcard_country_id smallint 0 1 23   0  
giftcard_postal_code varchar (50) 0 1 24   0  
giftcard_email varchar (80) 0 1 25   0  
giftcard_phone varchar (25) 0 1 26   0  
giftcard_approved tinyint 0 0 27   0  
giftcard_approved_date datetime 0 1 28   0  
giftcard_authorized tinyint 0 0 29   0  
giftcard_authorized_date datetime 0 1 30   0  
giftcard_catalog_specific tinyint 0 0 31   0  
giftcard_void tinyint 0 0 32   0  
giftcard_flag tinyint 0 0 33   0  
giftcard_alert tinyint 0 0 34   0  
giftcard_visible tinyint 0 0 35   0  
giftcard_suspended tinyint 0 0 36   0  
giftcard_locked tinyint 0 0 37   0  
giftcard_closed tinyint 0 0 38   0  
giftcard_filed tinyint 0 0 39 Workflow flag- if set indicates that the record is filed 0  
lu_dt datetime 0 0 40   0  
cr_dt datetime 0 0 41   0  
lu_guid uniqueidentifier 0 1 42   0  
cr_guid uniqueidentifier 0 1 43   0  
cr_object_type_id smallint 0 1 44   0  
cr_object_guid uniqueidentifier 0 1 45   0  

Return to index of tables