Table Schema: mf_payment

This topic describes the columns in the mf_payment_accounts table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	Comment	Reference Count
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

Table Schema: mf_payment_accounts