Order Detail

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

Order Fields

Old order ID30538 DateApr 14, 2025 ParentJoan Short EmailJoantshort@gmail.com Payment modecard Payment status Transaction ID

Items

Student	Course	Product	Amount	Status
Henry Short	Birmingham ACT Advanced Prep Course (for June 14th, 2025 Test)	Birmingham ACT Advanced Prep Course (for June 14th, 2025 Test)	$395.00	enrolled

Payment Rows

Provider	Transaction / Payment ID	Amount	Status	Date	Old Payment ID
paypal	96A85436GJ541531J	$395.00	paid	2025-04-14 16:36:44	31047

Raw Old Order Fields

Old Field	Imported Value
comment_date
courseid	985
created_at	2025-04-14 23:34:31
date	1744673671
finish	0
id	30538
is_deleted	0
is_new_order	1
live	0
onlineclass
ord_comments
order_type	0
paid	1
paid_resp
paid_status	0
parent_id	46154
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=4134961003772369&EXPDATE=052027&CVV2=014&FIRSTNAME=Henry&LASTNAME=Short&STREET=st.peter burg&CITY=france&STATE=Arkansas&ZIP=01010&COUNTRYCODE=US&CURRENCYCODE=USD&DESC=\ [0] Henry Short Course :- Birmingham ACT Advanced Prep Course (for June 14th, 2025 Test) Price :- 395\"}
paypal_response	{\"TIMESTAMP\":\"2025-04-14T23:36:43Z\",\"CORRELATIONID\":\"ba7cdc3d997f4\",\"ACK\":\"Success\",\"VERSION\":\"85.0\",\"BUILD\":\"56068150\",\"AMT\":\"395.00\",\"CURRENCYCODE\":\"USD\",\"AVSCODE\":\"N\",\"CVV2MATCH\":\"M\",\"TRANSACTIONID\":\"96A85436GJ541531J\"}
paypal_token	[redacted]
pu_date
sent	1
start	0
transid
updated_at	2025-04-14 23:34:31
userid	20028
video_access_date	0000-00-00