Order Detail

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

Back

Order Fields

Old order ID28975 DateJul 1, 2024 ParentLaura Davis Emailldavis0613@yahoo.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
William DavisIndividual TutoringIndividual Tutoring$100.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal48C90444DK9384136$90.002024-07-01 08:36:4829484

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid609
created_at2024-07-01 15:36:15
date1719848175
finish0
id28975
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id46293
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\\":95756442,\\"payee\\":{\\"email_address\\":\\"gmizzell@bellsouth.net\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":90},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"gmizzell@bellsouth.net\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":2.1699999999999999289457264239899814128875732421875}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AAPjLcuKrsRj_Ry8LMJ5DpKDeezF67hIapK-IN_n2Wb29Bb-wN4oCN3zmN8NqnwvBFjt9gH4xxNOXqRMdYHqY3_uV7ea5A\\",\\"Content-Length: 532\\"]\"}
paypal_response{\"id\":\"48C90444DK9384136\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"ldavis0613@yahoo.com\",\"account_id\":\"LVNVBWQKZUR56\",\"account_status\":\"UNVERIFIED\",\"name\":{\"given_name\":\"Laura\",\"surname\":\"DAvis\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"95756442\",\"shipping\":{\"name\":{\"full_name\":\"Laura Davis\"},\"address\":{\"address_line_1\":\"3519 Tanglecreek Cir\",\"admin_area_2\":\"Birmingham\",\"admin_area_1\":\"AL\",\"postal_code\":\"35243-2004\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"5E667730VF978324G\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"90.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"90.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"3.63\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"86.37\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/5E667730VF978324G\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/5E667730VF978324G\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/48C90444DK9384136\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2024-07-01T15:36:46Z\",\"update_time\":\"2024-07-01T15:36:46Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Laura\",\"surname\":\"DAvis\"},\"email_address\":\"ldavis0613@yahoo.com\",\"payer_id\":\"LVNVBWQKZUR56\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/48C90444DK9384136\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2024-07-01 15:36:15
userid18718
video_access_date0000-00-00