Order Detail

Order, class registration, and linked PayPal/payment import rows.

Back

Order Fields

Old order ID30411 DateMar 27, 2025 ParentKimberly Poole Emailbkbpoole@att.net Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Barrett PooleBirmingham ACT Foundations Prep Course (AS) (for June 14th, 2025 Test)Birmingham ACT Foundations Prep Course (AS) (for June 14th, 2025 Test)$395.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal6RF80795YT304080C$395.002025-03-27 17:31:4830920

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid987
created_at2025-03-28 00:30:54
date1743121854
finish0
id30411
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id48938
payment_mode4
paypal_post_request{\"CURLOPT_URL\":\"https:\/\/api-m.paypal.com\/v2\/checkout\/orders\",\"CURLOPT_RETURNTRANSFER\":1,\"CURLOPT_POST\":1,\"CURLOPT_POSTFIELDS\":\"{\\"intent\\":\\"CAPTURE\\",\\"application_context\\":{\\"return_url\\":\\"https:\\\/\\\/www.allpencilsdown.com\\\/api\\\/doPayment\\",\\"cancel_url\\":\\"https:\\\/\\\/www.allpencilsdown.com\\\/api\\\/cancelPayment\\"},\\"purchase_units\\":[{\\"reference_id\\":62382777,\\"payee\\":{\\"email_address\\":\\"gmizzell@bellsouth.net\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":20},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"gmizzell@bellsouth.net\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":1.95999999999999996447286321199499070644378662109375}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}},{\\"reference_id\\":78344127,\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":395},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":3.08499999999999996447286321199499070644378662109375}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AAPHud56qSe6FSPPh2q91a1eWO2M3AqA4um5_Gjf3Dn3TTII5UdPTRzAs4z3K-CuDBs95owMN3CnH6B89tnHP6y6GyhlRg\\",\\"Content-Length: 878\\"]\"}
paypal_response{\"id\":\"6RF80795YT304080C\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"bkbpoole@att.net\",\"account_id\":\"J43XX49RN4UQ6\",\"account_status\":\"VERIFIED\",\"name\":{\"given_name\":\"Bryant\",\"surname\":\"Poole\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"62382777\",\"shipping\":{\"name\":{\"full_name\":\"Kimberly Poole\"},\"address\":{\"address_line_1\":\"3500 WESTCHESTER RD\",\"admin_area_2\":\"Mountain Brook\",\"admin_area_1\":\"AL\",\"postal_code\":\"35223-2122\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"74H85785E9549443R\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"20.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"20.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"1.19\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"18.81\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/74H85785E9549443R\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/74H85785E9549443R\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/6RF80795YT304080C\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2025-03-28T00:31:43Z\",\"update_time\":\"2025-03-28T00:31:43Z\"}]}},{\"reference_id\":\"78344127\",\"shipping\":{\"name\":{\"full_name\":\"Kimberly Poole\"},\"address\":{\"address_line_1\":\"3500 WESTCHESTER RD\",\"admin_area_2\":\"Mountain Brook\",\"admin_area_1\":\"AL\",\"postal_code\":\"35223-2122\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"9BP304608P1051723\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"395.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"395.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"14.28\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"380.72\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/9BP304608P1051723\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/9BP304608P1051723\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/6RF80795YT304080C\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2025-03-28T00:31:44Z\",\"update_time\":\"2025-03-28T00:31:44Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Bryant\",\"surname\":\"Poole\"},\"email_address\":\"bkbpoole@att.net\",\"payer_id\":\"J43XX49RN4UQ6\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/6RF80795YT304080C\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2025-03-28 00:30:54
userid19971
video_access_date0000-00-00