Order Detail

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

Order Fields

Old order ID31896 DateOct 28, 2025 ParentMandy Kelly Emailmandywkelly@gmail.com Payment modecard Payment status Transaction ID

Items

Student	Course	Product	Amount	Status
Luke Kelly	Birmingham ACT Foundations Prep Course (for Dec 13th, 2025 Test)	Birmingham ACT Foundations Prep Course (for Dec 13th, 2025 Test)	$415.00	enrolled

Payment Rows

Provider	Transaction / Payment ID	Amount	Status	Date	Old Payment ID
paypal	1S078372TC2030615	$415.00	paid	2025-10-28 11:23:37	32405

Raw Old Order Fields

Old Field	Imported Value
comment_date
courseid	1002
created_at	2025-10-28 18:21:37
date	1761675697
finish	0
id	31896
is_deleted	0
is_new_order	1
live	0
onlineclass
ord_comments
order_type	0
paid	1
paid_resp
paid_status	0
parent_id	48705
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=435&CREDITCARDTYPE=Visa&ACCT=4355460260950943&EXPDATE=032028&CVV2=700&FIRSTNAME=Mandy&LASTNAME=Kelly&STREET=st.peter burg&CITY=france&STATE=Arkansas&ZIP=01010&COUNTRYCODE=US&CURRENCYCODE=USD&DESC=\ [0] Luke Kelly Course :- Birmingham ACT Foundations Prep Course (for Dec 13th, 2025 Test) Price :- 415\ [1] Luke Kelly \"}
paypal_response	{\"TIMESTAMP\":\"2025-10-28T18:23:37Z\",\"CORRELATIONID\":\"aa95f739b5aa5\",\"ACK\":\"Success\",\"VERSION\":\"85.0\",\"BUILD\":\"56068150\",\"AMT\":\"435.00\",\"CURRENCYCODE\":\"USD\",\"AVSCODE\":\"N\",\"CVV2MATCH\":\"M\",\"TRANSACTIONID\":\"1S078372TC2030615\"}
paypal_token	[redacted]
pu_date
sent	1
start	0
transid
updated_at	2025-10-28 18:21:37
userid	20587
video_access_date	0000-00-00