Order Detail

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

Back

Order Fields

Old order ID28747 DateJun 9, 2024 ParentKelley Caine Emailkelleyringland@yahoo.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Katherine CaineBirmingham ACT Standard Prep Course (MS) (for July 13th, 2024 Test)Birmingham ACT Standard Prep Course (MS) (for July 13th, 2024 Test)$395.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal4HB23982749300908$395.002024-06-09 11:07:0129256

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid898
created_at2024-06-09 18:06:14
date1717956374
finish0
id28747
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id48433
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\\":47029868,\\"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 A21AAP7iXx0uKXg7yWr_7AWLtHioiNSAU87tUv6wTvw0z5wWzDHWzG6jMJR6XTbFXgqRpIZtwBv346gnYb1HuBANxYQr5WNvA\\",\\"Content-Length: 540\\"]\"}
paypal_response{\"id\":\"4HB23982749300908\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"kelleyringland@yahoo.com\",\"account_id\":\"JEBS4QLLMZKAE\",\"account_status\":\"VERIFIED\",\"name\":{\"given_name\":\"Kelley\",\"surname\":\"Caine\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"47029868\",\"shipping\":{\"name\":{\"full_name\":\"Kelley Caine\"},\"address\":{\"address_line_1\":\"3336 Dell Road\",\"address_line_2\":\"null\",\"admin_area_2\":\"Mountain Brk\",\"admin_area_1\":\"AL\",\"postal_code\":\"35223\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"1KP31586G5985254G\",\"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\/1KP31586G5985254G\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/1KP31586G5985254G\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/4HB23982749300908\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2024-06-09T18:07:00Z\",\"update_time\":\"2024-06-09T18:07:00Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Kelley\",\"surname\":\"Caine\"},\"email_address\":\"kelleyringland@yahoo.com\",\"payer_id\":\"JEBS4QLLMZKAE\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/4HB23982749300908\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2024-06-09 18:06:14
userid19299
video_access_date0000-00-00