Order Detail

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

Order Fields

Old order ID29608 DateOct 13, 2024 ParentBRENT PRITCHARD EmailM.BRENT.PRITCHARD@GMAIL.COM Payment modecard Payment status Transaction ID

Items

Student	Course	Product	Amount	Status
Anna-Claire Pritchard	Birmingham ACT Foundations Prep Course (for Dec 14th, 2024 Test)	Birmingham ACT Foundations Prep Course (for Dec 14th, 2024 Test)	$395.00	enrolled

Payment Rows

Provider	Transaction / Payment ID	Amount	Status	Date	Old Payment ID
paypal	54Y0810612776772R	$395.00	paid	2024-10-16 11:37:39	30117

Raw Old Order Fields

Old Field	Imported Value
comment_date
courseid	963
created_at	2024-10-13 15:45:00
date	1728834300
finish	0
id	29608
is_deleted	0
is_new_order	1
live	0
onlineclass
ord_comments
order_type	0
paid	1
paid_resp
paid_status	0
parent_id	48668
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=4147099239562901&EXPDATE=112028&CVV2=513&FIRSTNAME=BRENT&LASTNAME=PRITCHARD&STREET=st.peter burg&CITY=france&STATE=Arkansas&ZIP=01010&COUNTRYCODE=US&CURRENCYCODE=USD&DESC=\ [0] Anna-Claire PRITCHARD Course :- Birmingham ACT Foundations Prep Course (for Dec 14th, 2024 Test) Price :- 395\"}
paypal_response	{\"TIMESTAMP\":\"2024-10-16T18:37:40Z\",\"CORRELATIONID\":\"fe5b9760aa6cc\",\"ACK\":\"Success\",\"VERSION\":\"85.0\",\"BUILD\":\"000000\",\"AMT\":\"395.00\",\"CURRENCYCODE\":\"USD\",\"AVSCODE\":\"N\",\"CVV2MATCH\":\"M\",\"TRANSACTIONID\":\"54Y0810612776772R\"}
paypal_token	[redacted]
pu_date
sent	1
start	0
transid
updated_at	2024-10-13 15:45:00
userid	19628
video_access_date	0000-00-00