Table Schema: mf_order_payment_methods

This topic describes the columns in the mf_order_payment_methods table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
order_payment_method_guid uniqueidentifier 1 0 1   0  
order_guid uniqueidentifier 0 0 2 Primary Key 0 mf_orders.order_guid
payment_account_guid uniqueidentifier 0 1 3   0 mf_payment_accounts.payment_account_guid
payment_guid uniqueidentifier 0 1 4   0  
payment_method_id int 0 1 5 Payment method-F-mf_payment_methods 0  
order_payment_method_amount money 0 1 6   0  
order_payment_method_name varchar (50) 0 1 7 Payment name 0  
order_payment_method_address varchar (80) 0 1 8 Payment address 0  
order_payment_method_postal_code varchar (50) 0 1 9 Payment postal code 0  
order_payment_method_number varchar (200) 0 1 10 Payment number(credit card, bank account etc) 0  
order_payment_method_number_masked varchar (200) 0 1 11 Payment number(credit card, bank account etc) 0  
order_payment_method_number_ext varchar (10) 0 1 12 Payment credit card cvv number 0  
order_payment_method_start varchar (15) 0 1 13   0  
order_payment_method_expiration varchar (15) 0 1 14 Payment credit card expiration 0  

Return to index of tables