Order Detail

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

Back

Order Fields

Old order ID31456 DateJul 29, 2025 ParentRoderick Jones EmailRoderick.jones2009@gmail.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Roderick JonesBirmingham ACT Foundations Prep Course (for September 6th, 2025 Test)Birmingham ACT Foundations Prep Course (for September 6th, 2025 Test)$415.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal5YA94744X99156414$415.002025-07-30 08:30:3531965

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid999
created_at2025-07-29 11:47:14
date1753789634
finish0
id31456
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id49229
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\\":31174826,\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":415},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":3.145000000000000017763568394002504646778106689453125}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AAOU5B5RiMBEdAC2suf3sUXhY_uQrvCQ5Q_LYhZck_wni7pAIf0gmv5OHYb5kVY9a3afEkwoHhwnCa8DnrABa7dl12bptQ\\",\\"Content-Length: 541\\"]\"}
paypal_response{\"id\":\"5YA94744X99156414\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"roderick.henderson09@gmail.com\",\"account_id\":\"RS3T6XSXX2YH2\",\"account_status\":\"UNVERIFIED\",\"name\":{\"given_name\":\"Roderick\",\"surname\":\"Jones\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"31174826\",\"shipping\":{\"name\":{\"full_name\":\"Roderick Jones\"},\"address\":{\"address_line_1\":\"1520 Bancroft Ave\",\"admin_area_2\":\"Anniston \",\"admin_area_1\":\"AL\",\"postal_code\":\"36201\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"2HB17160RV230201C\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"415.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"415.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"14.97\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"400.03\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/2HB17160RV230201C\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/2HB17160RV230201C\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/5YA94744X99156414\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2025-07-30T15:30:34Z\",\"update_time\":\"2025-07-30T15:30:34Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Roderick\",\"surname\":\"Jones\"},\"email_address\":\"roderick.henderson09@gmail.com\",\"payer_id\":\"RS3T6XSXX2YH2\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/5YA94744X99156414\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2025-07-29 11:47:14
userid20408
video_access_date0000-00-00