Order Detail

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

Back

Order Fields

Old order ID29147 DateJul 24, 2024 ParentLeann Walker Emailw_leann@bellsouth.net Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Katelyn WalkerBirmingham ACT Foundations Prep Course (for September 14th, 2024 Test)Birmingham ACT Foundations Prep Course (for September 14th, 2024 Test)$395.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal0WN45071GB2441208$395.002024-07-24 10:20:1729656

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid959
created_at2024-07-24 17:18:42
date1721841522
finish0
id29147
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id43938
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\\":78239587,\\"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 A21AANXLuZJpRziO3lVCNNliNjoW4jCQUdr0fUHlQSme1tM1jX4_mautpmWjF0bq_pTEis1bUwFV0vOM9HMmlHWEO1NY-56Vw\\",\\"Content-Length: 540\\"]\"}
paypal_response{\"id\":\"0WN45071GB2441208\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"w_leann@bellsouth.net\",\"account_id\":\"DGH8ZLTPKQ33G\",\"account_status\":\"UNVERIFIED\",\"name\":{\"given_name\":\"Leann\",\"surname\":\"Walker\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"78239587\",\"shipping\":{\"name\":{\"full_name\":\"Leann Walker\"},\"address\":{\"address_line_1\":\"4061 POWDER MILL RD\",\"admin_area_2\":\"MOUNT OLIVE\",\"admin_area_1\":\"AL\",\"postal_code\":\"35117\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"2X464329AU462580K\",\"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\/2X464329AU462580K\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/2X464329AU462580K\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/0WN45071GB2441208\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2024-07-24T17:20:17Z\",\"update_time\":\"2024-07-24T17:20:17Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Leann\",\"surname\":\"Walker\"},\"email_address\":\"w_leann@bellsouth.net\",\"payer_id\":\"DGH8ZLTPKQ33G\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/0WN45071GB2441208\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2024-07-24 17:18:42
userid19437
video_access_date0000-00-00