Array
(
[id] => 76
[magicpayUsername] => zF3sK2MIq1gwW+YutrloPw==
[magicpayPassword] => XucSMjbbi6PxAW9Nquf1UJd4CPZQmqcBq+vCRI+jWXP9pJlF2rwDaClEIkwbr/vI
[data_file_name] => 61.txt
[user_type] => nmi
[allow] => 1
[full_sync] => 0
[payment_sync] => 1
[cust_sync] => 0
[execute_status] => 0
[execute_status_done] => 1
[deposit_to_sync] =>
[invoice_no_from_doc] => 0
[payment_amount_manually] => 0
[user_id] => 61
[refreshtoken_expiry] =>
)
UPDATE quickbook_info SET execute_status=1,execute_status_done=0 where user_id=61Array
(
[0] => Array
(
[transaction_id] => 8174593381
[partial_payment_id] => Array
(
)
[partial_payment_balance] => Array
(
)
[platform_id] => Array
(
)
[transaction_type] => cc
[condition] => complete
[order_id] => 24312
[authorization_code] => 02777Z
[ponumber] => Array
(
)
[order_description] => Lead Heroes - Order 24312 (T65 Leads Promo x 2)
[first_name] => Paul
[last_name] => Morada
[address_1] => Array
(
)
[address_2] => Array
(
)
[company] => Array
(
)
[city] => Array
(
)
[state] => NA
[postal_code] => Array
(
)
[country] => Array
(
)
[email] => moradainsuranceservices@gmail.com
[phone] => 6238537770
[fax] => Array
(
)
[cell_phone] => Array
(
)
[customertaxid] => Array
(
)
[customerid] => Array
(
)
[website] => Array
(
)
[shipping_first_name] => Array
(
)
[shipping_last_name] => Array
(
)
[shipping_address_1] => Array
(
)
[shipping_address_2] => Array
(
)
[shipping_company] => Array
(
)
[shipping_city] => Array
(
)
[shipping_state] => Array
(
)
[shipping_postal_code] => Array
(
)
[shipping_country] => Array
(
)
[shipping_email] => Array
(
)
[shipping_carrier] => Array
(
)
[tracking_number] => Array
(
)
[shipping_date] => Array
(
)
[shipping] => 0.00
[shipping_phone] => Array
(
)
[cc_number] => 5xxxxxxxxxxx3473
[cc_hash] => 053070bb34dbc741cad9c9e4a02611e1
[cc_exp] => 1127
[cavv] => Array
(
)
[cavv_result] => Array
(
)
[xid] => Array
(
)
[eci] => Array
(
)
[directory_server_id] => Array
(
)
[three_ds_version] => Array
(
)
[avs_response] => 0
[csc_response] => M
[cardholder_auth] => Array
(
)
[cc_start_date] => Array
(
)
[cc_issue_number] => Array
(
)
[check_account] => Array
(
)
[check_hash] => Array
(
)
[check_aba] => Array
(
)
[check_name] => Array
(
)
[account_holder_type] => Array
(
)
[account_type] => Array
(
)
[sec_code] => Array
(
)
[drivers_license_number] => Array
(
)
[drivers_license_state] => Array
(
)
[drivers_license_dob] => Array
(
)
[social_security_number] => Array
(
)
[processor_id] => ems
[tax] => 0.00
[currency] => USD
[surcharge] => Array
(
)
[cash_discount] => Array
(
)
[tip] => Array
(
)
[card_balance] => Array
(
)
[card_available_balance] => Array
(
)
[entry_mode] => Keyed
[cc_bin] => 521307
[cc_type] => Mastercard
[signature_image] => Array
(
)
[duty_amount] => Array
(
)
[discount_amount] => Array
(
)
[national_tax_amount] => Array
(
)
[summary_commodity_code] => Array
(
)
[vat_tax_amount] => Array
(
)
[vat_tax_rate] => Array
(
)
[alternate_tax_amount] => Array
(
)
[action] => Array
(
[amount] => 1250.00
[action_type] => sale
[date] => 20230322034758
[success] => 1
[ip_address] => 97.124.225.106
[source] => api
[api_method] => direct_post
[tap_to_mobile] => false
[username] => LeadHeroes
[response_text] => Approved
[batch_id] => 0
[processor_batch_id] => Array
(
)
[response_code] => 100
[processor_response_text] => APPROVAL 02777Z
[processor_response_code] => 00
[requested_amount] => 1250.00
[device_license_number] => Array
(
)
[device_nickname] => Array
(
)
)
)
[1] => Array
(
[transaction_id] => 8176307327
[partial_payment_id] => Array
(
)
[partial_payment_balance] => Array
(
)
[platform_id] => Array
(
)
[transaction_type] => cc
[condition] => complete
[order_id] => 8176307327
[authorization_code] => 006055
[ponumber] => Array
(
)
[order_description] => 25 T-65 leads. Price Per Lead: $25 (Promo Price). Total: $625
[first_name] => Herbert
[last_name] => Lambert
[address_1] => 7196 Millers Glen Way
[address_2] => Array
(
)
[company] => Array
(
)
[city] => Memphis
[state] => TN
[postal_code] => 38125
[country] => US
[email] => hlambmemphis@att.net
[phone] => 9014972151
[fax] => 9017538067
[cell_phone] => Array
(
)
[customertaxid] => Array
(
)
[customerid] => Array
(
)
[website] => Array
(
)
[shipping_first_name] => Herbert
[shipping_last_name] => Lambert
[shipping_address_1] => 7196 Millers Glen Way
[shipping_address_2] => Array
(
)
[shipping_company] => Array
(
)
[shipping_city] => Memphis
[shipping_state] => TN
[shipping_postal_code] => 38125
[shipping_country] => US
[shipping_email] => hlambmemphis@att.net
[shipping_carrier] => Array
(
)
[tracking_number] => Array
(
)
[shipping_date] => Array
(
)
[shipping] => 0.00
[shipping_phone] => Array
(
)
[cc_number] => 4xxxxxxxxxxx8689
[cc_hash] => 3af7768ffa3aafda17499219f67179d2
[cc_exp] => 1226
[cavv] => Array
(
)
[cavv_result] => Array
(
)
[xid] => Array
(
)
[eci] => Array
(
)
[directory_server_id] => Array
(
)
[three_ds_version] => Array
(
)
[avs_response] => Y
[csc_response] => M
[cardholder_auth] => Array
(
)
[cc_start_date] => Array
(
)
[cc_issue_number] => Array
(
)
[check_account] => Array
(
)
[check_hash] => Array
(
)
[check_aba] => Array
(
)
[check_name] => Array
(
)
[account_holder_type] => Array
(
)
[account_type] => Array
(
)
[sec_code] => Array
(
)
[drivers_license_number] => Array
(
)
[drivers_license_state] => Array
(
)
[drivers_license_dob] => Array
(
)
[social_security_number] => Array
(
)
[processor_id] => payarc
[tax] => 0.00
[currency] => USD
[surcharge] => Array
(
)
[cash_discount] => Array
(
)
[tip] => Array
(
)
[card_balance] => Array
(
)
[card_available_balance] => Array
(
)
[entry_mode] => Keyed
[cc_bin] => 415978
[cc_type] => Visa
[signature_image] => Array
(
)
[duty_amount] => Array
(
)
[discount_amount] => 0.00
[national_tax_amount] => Array
(
)
[summary_commodity_code] => Array
(
)
[vat_tax_amount] => Array
(
)
[vat_tax_rate] => Array
(
)
[alternate_tax_amount] => Array
(
)
[action] => Array
(
[amount] => 625.00
[action_type] => sale
[date] => 20230322193042
[success] => 1
[ip_address] => 73.91.243.236
[source] => quickclick
[api_method] => Array
(
)
[tap_to_mobile] => false
[username] => LeadHeroes
[response_text] => Approved
[batch_id] => 0
[processor_batch_id] => Array
(
)
[response_code] => 100
[processor_response_text] => EXACT MATCH
[processor_response_code] => 00
[requested_amount] => 625.00
[device_license_number] => Array
(
)
[device_nickname] => Array
(
)
)
)
[2] => Array
(
[transaction_id] => 8176876378
[partial_payment_id] => Array
(
)
[partial_payment_balance] => Array
(
)
[platform_id] => Array
(
)
[transaction_type] => cc
[condition] => complete
[order_id] => 8176876378
[authorization_code] => 05637G
[ponumber] => Array
(
)
[order_description] => PPA For The Last 12 Months: 24. Price Per PPA: $100. Total: $2,400.
[first_name] => andrew
[last_name] => Eachon
[address_1] => 25 nw 23rd pl
[address_2] => 6156
[company] => Century Benefits
[city] => Portland
[state] => OR
[postal_code] => 97210
[country] => US
[email] => andrewe@centurybenefits.com
[phone] => 5036087768
[fax] => Array
(
)
[cell_phone] => Array
(
)
[customertaxid] => Array
(
)
[customerid] => Array
(
)
[website] => Array
(
)
[shipping_first_name] => andrew
[shipping_last_name] => Eachon
[shipping_address_1] => 25 nw 23rd pl
[shipping_address_2] => 6156
[shipping_company] => Century Benefits
[shipping_city] => Portland
[shipping_state] => OR
[shipping_postal_code] => 97210
[shipping_country] => US
[shipping_email] => andrewe@centurybenefits.com
[shipping_carrier] => Array
(
)
[tracking_number] => Array
(
)
[shipping_date] => Array
(
)
[shipping] => 0.00
[shipping_phone] => Array
(
)
[cc_number] => 4xxxxxxxxxxx4486
[cc_hash] => 08b09e416e8348095b42b027c75d6874
[cc_exp] => 1025
[cavv] => Array
(
)
[cavv_result] => Array
(
)
[xid] => Array
(
)
[eci] => Array
(
)
[directory_server_id] => Array
(
)
[three_ds_version] => Array
(
)
[avs_response] => Z
[csc_response] => M
[cardholder_auth] => Array
(
)
[cc_start_date] => Array
(
)
[cc_issue_number] => Array
(
)
[check_account] => Array
(
)
[check_hash] => Array
(
)
[check_aba] => Array
(
)
[check_name] => Array
(
)
[account_holder_type] => Array
(
)
[account_type] => Array
(
)
[sec_code] => Array
(
)
[drivers_license_number] => Array
(
)
[drivers_license_state] => Array
(
)
[drivers_license_dob] => Array
(
)
[social_security_number] => Array
(
)
[processor_id] => ems
[tax] => 0.00
[currency] => USD
[surcharge] => Array
(
)
[cash_discount] => Array
(
)
[tip] => Array
(
)
[card_balance] => Array
(
)
[card_available_balance] => Array
(
)
[entry_mode] => Keyed
[cc_bin] => 400390
[cc_type] => Visa
[signature_image] => Array
(
)
[duty_amount] => Array
(
)
[discount_amount] => 0.00
[national_tax_amount] => Array
(
)
[summary_commodity_code] => Array
(
)
[vat_tax_amount] => Array
(
)
[vat_tax_rate] => Array
(
)
[alternate_tax_amount] => Array
(
)
[action] => Array
(
[amount] => 2400.00
[action_type] => sale
[date] => 20230322231033
[success] => 1
[ip_address] => 193.29.61.7
[source] => quickclick
[api_method] => Array
(
)
[tap_to_mobile] => false
[username] => LeadHeroes
[response_text] => Approved
[batch_id] => 0
[processor_batch_id] => Array
(
)
[response_code] => 100
[processor_response_text] => ZIP MATCH
[processor_response_code] => 00
[requested_amount] => 2400.00
[device_license_number] => Array
(
)
[device_nickname] => Array
(
)
)
)
[3] => Array
(
[transaction_id] => 8179337904
[partial_payment_id] => Array
(
)
[partial_payment_balance] => Array
(
)
[platform_id] => Array
(
)
[transaction_type] => cc
[condition] => complete
[order_id] => 24328
[authorization_code] => 023317
[ponumber] => Array
(
)
[order_description] => Lead Heroes - Order 24328 (Final Expense Leads (Promo) x 1)
[first_name] => Tracey
[last_name] => Runte
[address_1] => Array
(
)
[address_2] => Array
(
)
[company] => Array
(
)
[city] => Array
(
)
[state] => NA
[postal_code] => Array
(
)
[country] => Array
(
)
[email] => tracey@harboradvantage.com
[phone] => 888-626-9887
[fax] => Array
(
)
[cell_phone] => Array
(
)
[customertaxid] => Array
(
)
[customerid] => Array
(
)
[website] => Array
(
)
[shipping_first_name] => Array
(
)
[shipping_last_name] => Array
(
)
[shipping_address_1] => Array
(
)
[shipping_address_2] => Array
(
)
[shipping_company] => Array
(
)
[shipping_city] => Array
(
)
[shipping_state] => Array
(
)
[shipping_postal_code] => Array
(
)
[shipping_country] => Array
(
)
[shipping_email] => Array
(
)
[shipping_carrier] => Array
(
)
[tracking_number] => Array
(
)
[shipping_date] => Array
(
)
[shipping] => 0.00
[shipping_phone] => Array
(
)
[cc_number] => 4xxxxxxxxxxx4878
[cc_hash] => 100af359d92337b0c2dce176c6ece495
[cc_exp] => 0227
[cavv] => Array
(
)
[cavv_result] => Array
(
)
[xid] => Array
(
)
[eci] => Array
(
)
[directory_server_id] => Array
(
)
[three_ds_version] => Array
(
)
[avs_response] => 0
[csc_response] => M
[cardholder_auth] => Array
(
)
[cc_start_date] => Array
(
)
[cc_issue_number] => Array
(
)
[check_account] => Array
(
)
[check_hash] => Array
(
)
[check_aba] => Array
(
)
[check_name] => Array
(
)
[account_holder_type] => Array
(
)
[account_type] => Array
(
)
[sec_code] => Array
(
)
[drivers_license_number] => Array
(
)
[drivers_license_state] => Array
(
)
[drivers_license_dob] => Array
(
)
[social_security_number] => Array
(
)
[processor_id] => ems
[tax] => 0.00
[currency] => USD
[surcharge] => Array
(
)
[cash_discount] => Array
(
)
[tip] => Array
(
)
[card_balance] => Array
(
)
[card_available_balance] => Array
(
)
[entry_mode] => Keyed
[cc_bin] => 414718
[cc_type] => Visa
[signature_image] => Array
(
)
[duty_amount] => Array
(
)
[discount_amount] => Array
(
)
[national_tax_amount] => Array
(
)
[summary_commodity_code] => Array
(
)
[vat_tax_amount] => Array
(
)
[vat_tax_rate] => Array
(
)
[alternate_tax_amount] => Array
(
)
[action] => Array
(
[amount] => 625.00
[action_type] => sale
[date] => 20230323204646
[success] => 1
[ip_address] => 24.196.75.42
[source] => api
[api_method] => direct_post
[tap_to_mobile] => false
[username] => LeadHeroes
[response_text] => Approved
[batch_id] => 0
[processor_batch_id] => Array
(
)
[response_code] => 100
[processor_response_text] => APPROVAL 023317
[processor_response_code] => 00
[requested_amount] => 625.00
[device_license_number] => Array
(
)
[device_nickname] => Array
(
)
)
)
[4] => Array
(
[transaction_id] => 8179898292
[partial_payment_id] => Array
(
)
[partial_payment_balance] => Array
(
)
[platform_id] => Array
(
)
[transaction_type] => cc
[condition] => pendingsettlement
[order_id] => 24329
[authorization_code] => 203440
[ponumber] => Array
(
)
[order_description] => Lead Heroes - Order 24329 (T65 Leads Promo x 1)
[first_name] => RICHARD
[last_name] => MORRIS
[address_1] => Array
(
)
[address_2] => Array
(
)
[company] => Array
(
)
[city] => Array
(
)
[state] => NA
[postal_code] => Array
(
)
[country] => Array
(
)
[email] => richard@insuranceproaz.com
[phone] => 4802270172
[fax] => Array
(
)
[cell_phone] => Array
(
)
[customertaxid] => Array
(
)
[customerid] => Array
(
)
[website] => Array
(
)
[shipping_first_name] => Array
(
)
[shipping_last_name] => Array
(
)
[shipping_address_1] => Array
(
)
[shipping_address_2] => Array
(
)
[shipping_company] => Array
(
)
[shipping_city] => Array
(
)
[shipping_state] => Array
(
)
[shipping_postal_code] => Array
(
)
[shipping_country] => Array
(
)
[shipping_email] => Array
(
)
[shipping_carrier] => Array
(
)
[tracking_number] => Array
(
)
[shipping_date] => Array
(
)
[shipping] => 0.00
[shipping_phone] => Array
(
)
[cc_number] => 3xxxxxxxxxx4009
[cc_hash] => e28fb6a55ac4bdb0b2d6aff682194fe2
[cc_exp] => 1123
[cavv] => Array
(
)
[cavv_result] => Array
(
)
[xid] => Array
(
)
[eci] => Array
(
)
[directory_server_id] => Array
(
)
[three_ds_version] => Array
(
)
[avs_response] => 0
[csc_response] => M
[cardholder_auth] => Array
(
)
[cc_start_date] => Array
(
)
[cc_issue_number] => Array
(
)
[check_account] => Array
(
)
[check_hash] => Array
(
)
[check_aba] => Array
(
)
[check_name] => Array
(
)
[account_holder_type] => Array
(
)
[account_type] => Array
(
)
[sec_code] => Array
(
)
[drivers_license_number] => Array
(
)
[drivers_license_state] => Array
(
)
[drivers_license_dob] => Array
(
)
[social_security_number] => Array
(
)
[processor_id] => payarc
[tax] => 0.00
[currency] => USD
[surcharge] => Array
(
)
[cash_discount] => Array
(
)
[tip] => Array
(
)
[card_balance] => Array
(
)
[card_available_balance] => Array
(
)
[entry_mode] => Keyed
[cc_bin] => 377231
[cc_type] => American Express
[signature_image] => Array
(
)
[duty_amount] => Array
(
)
[discount_amount] => Array
(
)
[national_tax_amount] => Array
(
)
[summary_commodity_code] => Array
(
)
[vat_tax_amount] => Array
(
)
[vat_tax_rate] => Array
(
)
[alternate_tax_amount] => Array
(
)
[action] => Array
(
[amount] => 625.00
[action_type] => sale
[date] => 20230324003640
[success] => 1
[ip_address] => 72.223.114.50
[source] => api
[api_method] => direct_post
[tap_to_mobile] => false
[username] => LeadHeroes
[response_text] => Approved
[batch_id] => 0
[processor_batch_id] => Array
(
)
[response_code] => 100
[processor_response_text] => APPROVAL 203440
[processor_response_code] => 00
[requested_amount] => 625.00
[device_license_number] => Array
(
)
[device_nickname] => Array
(
)
)
)
)
Invoice entry push in past. 8174593381