Order Detail

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

Order Fields

Old order ID29289 DateAug 15, 2024 ParentRoss Vandernoot Emailvandernoot@gmail.com Payment modecard Payment status Transaction ID

Items

Student	Course	Product	Amount	Status
Andrew Vander Noot	Birmingham ACT Foundations Prep Course (for October 26th, 2024 Test)	Birmingham ACT Foundations Prep Course (for October 26th, 2024 Test)	$395.00	enrolled

Payment Rows

Provider	Transaction / Payment ID	Amount	Status	Date	Old Payment ID
paypal	2C057477S52743738	$395.00	paid	2024-08-15 11:15:46	29798

Raw Old Order Fields

Old Field	Imported Value
comment_date
courseid	961
created_at	2024-08-15 18:14:58
date	1723745698
finish	0
id	29289
is_deleted	0
is_new_order	1
live	0
onlineclass
ord_comments
order_type	0
paid	1
paid_resp
paid_status	0
parent_id	45895
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=4270829029211965&EXPDATE=022028&CVV2=383&FIRSTNAME=Ross&LASTNAME=Vandernoot&STREET=st.peter burg&CITY=france&STATE=Arkansas&ZIP=01010&COUNTRYCODE=US&CURRENCYCODE=USD&DESC=\ [0] Andrew Vander Noot Course :- Birmingham ACT Foundations Prep Course (for October 26th, 2024 Test) Price :- 395\"}
paypal_response	{\"TIMESTAMP\":\"2024-08-15T18:15:46Z\",\"CORRELATIONID\":\"5b7a155a136e3\",\"ACK\":\"Success\",\"VERSION\":\"85.0\",\"BUILD\":\"000000\",\"AMT\":\"395.00\",\"CURRENCYCODE\":\"USD\",\"AVSCODE\":\"N\",\"CVV2MATCH\":\"M\",\"TRANSACTIONID\":\"2C057477S52743738\"}
paypal_token	[redacted]
pu_date
sent	1
start	0
transid
updated_at	2024-08-15 18:14:58
userid	19507
video_access_date	0000-00-00