This topic describes the columns in the mf_payments table.
| Column Name | Data Type | Primary Key | Is Nullable | Column ID | Comment | Reference Count | Reference To |
|---|---|---|---|---|---|---|---|
| payment_guid | uniqueidentifier | 1 | 0 | 1 | 7 | ||
| company_guid | uniqueidentifier | 0 | 1 | 2 | 0 | ||
| catalog_guid | uniqueidentifier | 0 | 1 | 3 | 0 | ||
| site_guid | uniqueidentifier | 0 | 1 | 4 | 0 | ||
| customer_guid | uniqueidentifier | 0 | 1 | 5 | 0 | mf_customers.customer_guid | |
| order_guid | uniqueidentifier | 0 | 1 | 6 | 0 | mf_orders.order_guid | |
| user_guid | uniqueidentifier | 0 | 1 | 7 | 0 | mf_users.user_guid | |
| company_payment_processor_guid | uniqueidentifier | 0 | 1 | 8 | 0 | mf_company_payment_processors.company_payment_processor_guid | |
| company_payment_processor_token | varchar (200) | 0 | 1 | 9 | 0 | ||
| attached_object_guid | uniqueidentifier | 0 | 1 | 10 | 0 | ||
| attached_object_type_id | int | 0 | 1 | 11 | 0 | ||
| payment_code_guid | uniqueidentifier | 0 | 1 | 12 | 0 | ||
| payment_account_guid | uniqueidentifier | 0 | 1 | 13 | 0 | mf_payment_accounts.payment_account_guid | |
| iso_currency_cd | char (3) | 0 | 1 | 14 | 0 | mf_iso_currencies.iso_currency_cd | |
| payment_id | varchar (50) | 0 | 1 | 15 | 0 | ||
| payment_reference_id | varchar (50) | 0 | 1 | 16 | 0 | ||
| payment_method_id | int | 0 | 1 | 17 | 0 | mf_payment_methods.payment_method_id | |
| payment_amount | money | 0 | 0 | 18 | 0 | ||
| payment_amount_attached | money | 0 | 0 | 19 | 0 | ||
| payment_amount_applied | money | 0 | 0 | 20 | 0 | ||
| payment_amount_authorized | money | 0 | 0 | 21 | 0 | ||
| payment_amount_authorized_fee | money | 0 | 0 | 22 | 0 | ||
| payment_amount_captured | money | 0 | 0 | 23 | 0 | ||
| payment_amount_captured_fee | money | 0 | 0 | 24 | 0 | ||
| payment_amount_refunded | money | 0 | 0 | 25 | 0 | ||
| payment_amount_refunded_fee | money | 0 | 0 | 26 | 0 | ||
| payment_total | money | 0 | 0 | 27 | 0 | ||
| payment_total_fee | money | 0 | 0 | 28 | 0 | ||
| payment_date | datetime | 0 | 0 | 29 | 0 | ||
| payment_transaction_cd | varchar (50) | 0 | 1 | 30 | 0 | ||
| payment_transaction_description | varchar (200) | 0 | 1 | 31 | 0 | ||
| payment_approval_cd | varchar (50) | 0 | 1 | 32 | 0 | ||
| payment_tag | varchar (50) | 0 | 1 | 33 | 0 | ||
| payment_description | varchar (200) | 0 | 1 | 34 | 0 | ||
| payment_card_holder_name | varchar (255) | 0 | 1 | 35 | 0 | ||
| payment_card_number | varchar (200) | 0 | 1 | 36 | 0 | ||
| payment_card_number_masked | varchar (50) | 0 | 1 | 37 | 0 | ||
| payment_card_start_month | varchar (2) | 0 | 1 | 38 | 0 | ||
| payment_card_start_year | varchar (4) | 0 | 1 | 39 | 0 | ||
| payment_card_exp_month | varchar (2) | 0 | 1 | 40 | 0 | ||
| payment_card_exp_year | varchar (4) | 0 | 1 | 41 | 0 | ||
| payment_customer_id | varchar (50) | 0 | 1 | 42 | 0 | ||
| payment_customer_first_name | varchar (255) | 0 | 1 | 43 | 0 | ||
| payment_customer_last_name | varchar (255) | 0 | 1 | 44 | 0 | ||
| payment_customer_address | varchar (50) | 0 | 1 | 45 | 0 | ||
| payment_customer_city | varchar (50) | 0 | 1 | 46 | 0 | ||
| payment_customer_state | varchar (50) | 0 | 1 | 47 | 0 | ||
| payment_customer_postal_code | varchar (50) | 0 | 1 | 48 | 0 | ||
| payment_customer_country | varchar (50) | 0 | 1 | 49 | 0 | ||
| payment_customer_email | varchar (50) | 0 | 1 | 50 | 0 | ||
| payment_customer_phone | varchar (50) | 0 | 1 | 51 | 0 | ||
| payment_ip_address | varchar (50) | 0 | 1 | 52 | 0 | ||
| payment_attached | tinyint | 0 | 0 | 53 | 0 | ||
| payment_applied | tinyint | 0 | 0 | 54 | 0 | ||
| payment_authorized | tinyint | 0 | 0 | 55 | 0 | ||
| payment_captured | tinyint | 0 | 0 | 56 | 0 | ||
| payment_settled | tinyint | 0 | 0 | 57 | 0 | ||
| payment_refunded | tinyint | 0 | 0 | 58 | 0 | ||
| payment_orphaned | tinyint | 0 | 0 | 59 | 0 | ||
| payment_error | tinyint | 0 | 0 | 60 | 0 | ||
| payment_void | tinyint | 0 | 0 | 61 | 0 | ||
| payment_force_closed | tinyint | 0 | 0 | 62 | 0 | ||
| payment_alert | tinyint | 0 | 0 | 63 | 0 | ||
| payment_visible | tinyint | 0 | 0 | 64 | 0 | ||
| payment_new | tinyint | 0 | 0 | 65 | 0 | ||
| payment_approved | tinyint | 0 | 0 | 66 | 0 | ||
| payment_suspended | tinyint | 0 | 0 | 67 | 0 | ||
| payment_locked | tinyint | 0 | 0 | 68 | 0 | ||
| payment_closed | tinyint | 0 | 0 | 69 | 0 | ||
| payment_filed | tinyint | 0 | 0 | 70 | 0 | ||
| payment_flag | tinyint | 0 | 0 | 71 | 0 | ||
| lu_dt | datetime | 0 | 0 | 72 | 0 | ||
| cr_dt | datetime | 0 | 0 | 73 | 0 | ||
| lu_guid | uniqueidentifier | 0 | 1 | 74 | 0 | ||
| cr_guid | uniqueidentifier | 0 | 1 | 75 | 0 | ||
| payment_data | text | 0 | 1 | 76 | 0 | ||
| payment_transaction_data | text | 0 | 1 | 77 | 0 | ||
| payment_pending | tinyint | 0 | 1 | 80 | 0 | ||
| payment_amount_captured_pending | money | 0 | 1 | 81 | 0 | ||
| payment_amount_refunded_pending | money | 0 | 1 | 82 | 0 | ||
| payment_scrub_scheduled_date | datetime | 0 | 1 | 83 | 0 | ||
| payment_scrub_completed_date | datetime | 0 | 1 | 84 | 0 | ||
| payment_card_number_scrubbed | tinyint | 0 | 0 | 85 | 0 |