Table Schema: mf_payment_accounts

This topic describes the columns in the mf_payment_accounts table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
payment_account_guid uniqueidentifier 1 0 1   4  
company_guid uniqueidentifier 0 0 2   0  
catalog_guid uniqueidentifier 0 1 3   0  
customer_guid uniqueidentifier 0 1 4   0  
payment_account_code_guid uniqueidentifier 0 1 5   0  
provider_instance_guid uniqueidentifier 0 1 6   0  
provider_instance_configuration_id varchar (50) 0 1 7   0  
provider_instance_configuration_label varchar (255) 0 1 8   0  
provider_instance_configuration_data varchar (max) 0 1 9   0  
provider_instance_configuration_serialization_type_id smallint 0 1 10   0  
provider_instance_configuration_version varchar (25) 0 1 11   0  
payment_method_id int 0 0 12   0  
payment_account_id varchar (50) 0 0 13   0  
payment_account_label varchar (50) 0 1 14   0  
payment_account_label_short varchar (50) 0 1 15   0  
payment_account_description varchar (255) 0 1 16   0  
payment_account_provider_instance_token varchar (200) 0 1 17   0  
payment_account_number varchar (200) 0 1 18   0  
payment_account_number_masked varchar (50) 0 1 19   0  
payment_account_number_search varchar (25) 0 1 20   0  
payment_account_start_date datetime 0 1 21   0  
payment_account_expiration_date datetime 0 1 22   0  
payment_account_holder_attention varchar (255) 0 1 23   0  
payment_account_holder_company_name varchar (255) 0 1 24   0  
payment_account_holder_address varchar (50) 0 1 25   0  
payment_account_holder_address2 varchar (50) 0 1 26   0  
payment_account_holder_address3 varchar (50) 0 1 27   0  
payment_account_holder_city varchar (50) 0 1 28   0  
payment_account_holder_country varchar (50) 0 1 29   0  
payment_account_holder_country_region varchar (50) 0 1 30   0  
payment_account_holder_postal_code varchar (50) 0 1 31   0  
payment_account_holder_email varchar (50) 0 1 32   0  
payment_account_holder_phone varchar (50) 0 1 33   0  
payment_account_holder_ip_address varchar (50) 0 1 34   0  
payment_account_order smallint 0 0 35   0  
payment_account_alert tinyint 0 0 36   0  
payment_account_visible tinyint 0 0 37   0  
payment_account_new tinyint 0 0 38   0  
payment_account_approved tinyint 0 0 39   0  
payment_account_suspended tinyint 0 0 40   0  
payment_account_locked tinyint 0 0 41   0  
payment_account_closed tinyint 0 0 42   0  
payment_account_filed tinyint 0 0 43   0  
payment_account_flag tinyint 0 0 44   0  
lu_dt datetime 0 0 45   0  
cr_dt datetime 0 0 46   0  
lu_guid uniqueidentifier 0 1 47   0  
cr_guid uniqueidentifier 0 1 48   0  
payment_account_token varchar (50) 0 1 49   0  
provider_instance_configuration_key varchar (50) 0 1 50 Deprecated in favor of new _id column. Will be removed in a future release. 0  

Return to index of tables