Order Detail

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

Old order ID30623 DateApr 21, 2025 ParentParent Email Payment modecard Payment status Transaction ID

Student	Course	Product	Amount	Status
	Birmingham ACT Foundations Prep Course (MS) (for July 12th, 2025 Test)	Birmingham ACT Foundations Prep Course (MS) (for July 12th, 2025 Test)	$395.00	enrolled

Provider	Transaction / Payment ID	Amount	Status	Date	Old Payment ID
paypal	3UN60009YF081153H	$395.00	paid	2025-04-21 08:33:59	31132

Old Field	Imported Value
comment_date
courseid	992
created_at	2025-04-21 15:31:27
date	1745249487
finish	0
id	30623
is_deleted	0
is_new_order	1
live	0
onlineclass
ord_comments
order_type	0
paid	1
paid_resp
paid_status	0
parent_id	48227
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=395&CREDITCARDTYPE=Visa&ACCT=4147202579134196&EXPDATE=122027&CVV2=985&FIRSTNAME=Margaret&LASTNAME=Stewart&STREET=st.peter burg&CITY=france&STATE=Arkansas&ZIP=01010&COUNTRYCODE=US&CURRENCYCODE=USD&DESC=\ [0] Michael Stewart Course :- Birmingham ACT Foundations Prep Course (MS) (for July 12th, 2025 Test) Price :- 395\"}
paypal_response	{\"TIMESTAMP\":\"2025-04-21T15:33:59Z\",\"CORRELATIONID\":\"dd97f9e9f54f7\",\"ACK\":\"Success\",\"VERSION\":\"85.0\",\"BUILD\":\"56068150\",\"AMT\":\"395.00\",\"CURRENCYCODE\":\"USD\",\"AVSCODE\":\"N\",\"CVV2MATCH\":\"M\",\"TRANSACTIONID\":\"3UN60009YF081153H\"}
paypal_token	[redacted]
pu_date
sent	1
start	0
transid
updated_at	2025-04-21 15:31:27
userid	20112
video_access_date	0000-00-00