Order Detail

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

Order Fields

Old order ID29977 DateJan 10, 2025 ParentDaphne Self EmailDaphneself@gmail.com Payment modecard Payment status Transaction ID

Items

Student	Course	Product	Amount	Status
Juniper Self	ACT Intensive Course (for April 5th, 2025 test)	ACT Intensive Course (for April 5th, 2025 test)	$295.00	enrolled

Payment Rows

Provider	Transaction / Payment ID	Amount	Status	Date	Old Payment ID
paypal	0B9799958G574923J	$295.00	paid	2025-01-22 09:51:57	30486

Raw Old Order Fields

Old Field	Imported Value
comment_date
courseid	979
created_at	2025-01-11 03:54:45
date	1736567685
finish	0
id	29977
is_deleted	0
is_new_order	1
live	0
onlineclass
ord_comments
order_type	0
paid	1
paid_resp
paid_status	0
parent_id	48791
payment_mode	1
paypal_post_request	{\"CURLOPT_URL\":\"https:\/\/api-3t.paypal.com\/nvp\",\"CURLOPT_VERBOSE\":1,\"CURLOPT_SSL_VERIFYPEER\":false,\"CURLOPT_SSL_VERIFYHOST\":false,\"CURLOPT_RETURNTRANSFER\":1,\"CURLOPT_POST\":1,\"CURLOPT_POSTFIELDS\":\"METHOD=DoDirectPayment&VERSION=85.0&PWD=KE3X5F2SXF6344RP&USER=george_api1.allpencilsdown.com&SIGNATURE=AFcWxV21C7fd0v3bYYYRCpSSRl31AIdmsvyasldglfPBaLi8kZLtS5Cp&PAYMENTACTION=Sale&AMT=295&CREDITCARDTYPE=Visa&ACCT=4355451261838963&EXPDATE=032027&CVV2=921&FIRSTNAME=Daphne&LASTNAME=Self&STREET=st.peter burg&CITY=france&STATE=Arkansas&ZIP=01010&COUNTRYCODE=US&CURRENCYCODE=USD&DESC=\ [0] Juniper Self Course :- ACT Intensive Course (for April 5th, 2025 test) Price :- 295\"}
paypal_response	{\"TIMESTAMP\":\"2025-01-22T17:51:57Z\",\"CORRELATIONID\":\"988eb970e62be\",\"ACK\":\"Success\",\"VERSION\":\"85.0\",\"BUILD\":\"000000\",\"AMT\":\"295.00\",\"CURRENCYCODE\":\"USD\",\"AVSCODE\":\"N\",\"CVV2MATCH\":\"M\",\"TRANSACTIONID\":\"0B9799958G574923J\"}
paypal_token	[redacted]
pu_date
sent	1
start	0
transid
updated_at	2025-01-11 03:54:45
userid	19785
video_access_date	0000-00-00