Tue, 21 Oct 2014 14:02:43 -0700

Array
(
    [action] => done
    [Transaction_Approved] => YES
    [x_response_code] => 1
    [x_zip] => 
    [Transaction_Tag] => 1382616044
    [x_fax] => 
    [x_MD5_Hash] => ca801cfabe711bbfafe290264e54a318
    [MerchantCountry] => Canada
    [CAVV_Algorithm] => 0
    [x_duty] => 
    [exact_issconf] => 
    [x_cust_id] => 
    [CAVV_Response] => 
    [Tax2Number] => 
    [x_reference_3] => 
    [x_response_subcode] => S
    [Bank_Resp_Code_2] => 
    [x_ship_to_address] => 
    [x_currency_code] => CAD
    [x_address] => 
    [CVD_Presence_Ind] => 0
    [Transaction_Error] => false
    [x_po_num] => 
    [x_login] => WSP-ELEME-G1pRIAAFfA
    [Card_Number] => ############4295
    [x_phone] => 
    [MerchantProvince] => Ontario
    [EXact_Resp_Code] => 00
    [XID] => 
    [x_freight] => 
    [x_test_request] => FALSE
    [exact_issname] => 
    [x_type] => 
    [x_description] => 
    [Retrieval_Ref_No] => 00000057
    [Tax2Amount] => 
    [x_ship_to_country] => 
    [Bank_Message] => APPROVED
    [CardHoldersName] => Lori Lewis
    [x_ship_to_company] => 
    [TransactionCardType] => MASTERCARD
    [Client_Email] => 
    [x_company] => 
    [SurchargeAmount] => 0
    [MerchantCity] => KITCHENER
    [Ecommerce_Flag] => 7
    [x_trans_id] => 1382616044
    [x_tax] => 
    [exact_ctr] => =========== TRANSACTION RECORD ==========
ELEMENTARY SCHOOL NUTRITI
891 GUELPH ST #209
KITCHENER, ON N2H5Z2
Canada
WWW.ESNS.CA

TYPE: Purchase

ACCT: Mastercard  $ 10.20 CAD

CARD NUMBER : ############4295
DATE/TIME   : 21 Oct 14 17:02:40
REFERENCE # : 001 222398 M
AUTHOR. #   : 07259Z
TRANS. REF. : 000000056887

    Approved - Thank You 000


Please retain this copy for your records.

Cardholder will pay above amount to card
issuer pursuant to cardholder agreement.
=========================================
    [x_fp_timestamp] => 1413925310
    [CVV2] => 
    [Tax1Number] => 
    [x_ship_to_zip] => 
    [Bank_Resp_Code] => 000
    [merchant_cookie_2] => 259177
    [x_country] => 
    [Expiry_Date] => 1015
    [x_ship_to_last_name] => 
    [x_response_reason_text] => Transaction has been approved
    [Client_IP] => 
    [Customer_Ref] => 
    [x_method] => 
    [DollarAmount] => 10.2
    [x_last_name] => 
    [x_invoice_num] => 000000056887
    [MerchantAddress] => 891 GUELPH ST #209
    [Secure_AuthResult] => 0
    [x_avs_code] => 
    [x_amount] => 10.20
    [x_cavv_response] => 
    [AVS] => 
    [x_email] => 
    [Tax1Amount] => 
    [x_ship_to_state] => 
    [EXact_Message] => Transaction Normal
    [Reference_3] => 
    [x_response_reason_code] => 1
    [x_state] => 
    [x_show_form] => PAYMENT_FORM
    [Authorization_Num] => 07259Z
    [x_ship_to_first_name] => 
    [x_fp_sequence] => 56887
    [MerchantPostal] => N2H5Z2
    [Reference_No] => 000000056887
    [exact_wsp_version] => 1.7
    [Transaction_Type] => 00
    [x_first_name] => 
    [x_tax_exempt] => 
    [MerchantName] => ELEMENTARY SCHOOL NUTRITI
    [Language] => 0
    [Secure_AuthRequired] => 0
    [x_auth_code] => 07259Z
    [x_cvv2_resp_code] => 
    [SequenceNo] => 222398
    [merchant_cookie_1] => 543
    [x_city] => 
    [ZipCode] => 
    [x_ship_to_city] => 
)



Insert ID: 38030

SELECT hloh.* FROM hotlunch_order_header as hloh, people as p WHERE hloh.school_num = 543 AND ordered_by_num = p.record_num AND ordered_by_type = p.people_type AND p.user_num = 259177 AND hloh.status NOT IN ('Paid','Complimentary','Concession')
Orders Found: 1
 - Order Paid: 1031830

Payment processed ok


