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  
payment_account_number_scrubbed tinyint 0 0 53   0  

Return to index of tables

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.