Table Schema: mf_customer_payment_methods

This topic describes the columns in the mf_customer_payment_methods table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
customer_payment_method_guid uniqueidentifier 1 0 1   1  
customer_guid uniqueidentifier 0 0 2   0 mf_customers.customer_guid
payment_account_guid uniqueidentifier 0 1 3   0 mf_payment_accounts.payment_account_guid
payment_method_id int 0 1 4   0  
payment_method_default bit 0 0 5   0  
customer_payment_description varchar (50) 0 1 6   0  
customer_payment_last_name varchar (255) 0 1 7   0  
customer_payment_first_name varchar (255) 0 1 8   0  
customer_payment_cardholder varchar (100) 0 1 9   0  
customer_payment_address varchar (100) 0 1 10   0  
customer_payment_postal_code varchar (100) 0 1 11   0  
customer_payment_card_number varchar (200) 0 1 12   0  
customer_payment_card_number_masked varchar (50) 0 1 13   0  
customer_payment_card_number_cvv varchar (100) 0 1 14   0  
customer_payment_card_start varchar (15) 0 1 15   0  
customer_payment_card_expiration varchar (15) 0 1 16   0  
customer_payment_deleted tinyint 0 0 17   0  
lu_dt datetime 0 0 18   0  
cr_dt datetime 0 0 19   0  
lu_guid uniqueidentifier 0 1 20   0  
cr_guid uniqueidentifier 0 1 21   0  

Return to index of tables