Table Schema: mf_order_payment

This topic describes the columns in the mf_order_payment_methods 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 To
order_payment_method_guid	uniqueidentifier	1	0	1
order_guid	uniqueidentifier	0	0	2	Primary Key	mf_orders.order_guid
payment_account_guid	uniqueidentifier	0	1	3		mf_payment_accounts.payment_account_guid
payment_guid	uniqueidentifier	0	1	4
payment_method_id	int	0	1	5	Payment method-F-mf_payment_methods
order_payment_method_amount	money	0	1	6
order_payment_method_name	varchar (50)	0	1	7	Payment name
order_payment_method_address	varchar (80)	0	1	8	Payment address
order_payment_method_postal_code	varchar (50)	0	1	9	Payment postal code
order_payment_method_number	varchar (200)	0	1	10	Payment number(credit card, bank account etc)
order_payment_method_number_masked	varchar (200)	0	1	11	Payment number(credit card, bank account etc)
order_payment_method_number_ext	varchar (10)	0	1	12	Payment credit card cvv number
order_payment_method_start	varchar (15)	0	1	13
order_payment_method_expiration	varchar (15)	0	1	14	Payment credit card expiration
order_payment_method_number_scrubbed	tinyint	0	0	17

Table Schema: mf_order_payment_methods