Table Schema: mf_payment_transactions

This topic describes the columns in the mf_payment_transactions table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
payment_transaction_guid uniqueidentifier 1 0 1   1  
company_guid uniqueidentifier 0 1 2   0  
payment_guid uniqueidentifier 0 0 3   0 mf_payments.payment_guid
parent_payment_transaction_guid uniqueidentifier 0 1 4   0  
payment_transaction_type_id smallint 0 0 5   0 mf_payment_transaction_types.payment_transaction_type_id
object_guid uniqueidentifier 0 1 6   0  
object_type_id int 0 1 7   0  
payment_transaction_id varchar (100) 0 1 8   0  
payment_transaction_reference_id varchar (100) 0 1 9   0  
payment_transaction_date datetime 0 0 10   0  
payment_transaction_amount money 0 0 11   0  
payment_transaction_amount_fee money 0 0 12   0  
payment_transaction_response_approval_code varchar (50) 0 1 13   0  
payment_transaction_response_avs varchar (50) 0 1 14   0  
payment_transaction_response_cvv2 varchar (50) 0 1 15   0  
payment_transaction_response_code varchar (50) 0 1 16   0  
payment_transaction_response_description varchar (500) 0 1 17   0  
payment_transaction_response_data varchar (max) 0 1 18   0  
payment_transaction_tag varchar (50) 0 1 19   0  
payment_transaction_success bit 0 0 20   0  
lu_dt datetime 0 0 21   0  
cr_dt datetime 0 0 22   0  
lu_guid uniqueidentifier 0 1 23   0  
cr_guid uniqueidentifier 0 1 24   0  
payment_transaction_data varchar (max) 0 1 25   0  
payment_transaction_idempotent_status varchar (50) 0 1 30   0  
payment_transaction_idempotent_id varchar (50) 0 1 31   0  

Return to index of tables