Order Detail

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

Order Fields

Old order ID28497 DateMay 31, 2024 ParentLauren Scott Emailscottfamily77@gmail.com Payment modecard Payment status Transaction ID

Items

Student	Course	Product	Amount	Status
Lucy Scott	Birmingham ACT Standard Prep Course (AS) (for July 13th, 2024 Test)	Birmingham ACT Standard Prep Course (AS) (for July 13th, 2024 Test)	$395.00	enrolled

Payment Rows

Provider	Transaction / Payment ID	Amount	Status	Date	Old Payment ID
paypal	9DV43757Y73711246	$395.00	paid	2024-05-31 20:13:44	29006

Raw Old Order Fields

Old Field	Imported Value
comment_date
courseid	899
created_at	2024-06-01 03:09:54
date	1717211394
finish	0
id	28497
is_deleted	0
is_new_order	1
live	0
onlineclass
ord_comments
order_type	0
paid	1
paid_resp
paid_status	0
parent_id	48409
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=790&CREDITCARDTYPE=Visa&ACCT=4147098682910542&EXPDATE=042028&CVV2=088&FIRSTNAME=Lauren&LASTNAME=Scott&STREET=st.peter burg&CITY=france&STATE=Arkansas&ZIP=01010&COUNTRYCODE=US&CURRENCYCODE=USD&DESC=\ [0] Aliza Scott Course :- Birmingham ACT Standard Prep Course (AS) (for July 13th, 2024 Test) Price :- 395\ [1] Lucy Sc\"}
paypal_response	{\"TIMESTAMP\":\"2024-06-01T03:13:43Z\",\"CORRELATIONID\":\"6cd903281ee7e\",\"ACK\":\"Success\",\"VERSION\":\"85.0\",\"BUILD\":\"56068150\",\"AMT\":\"790.00\",\"CURRENCYCODE\":\"USD\",\"AVSCODE\":\"N\",\"CVV2MATCH\":\"M\",\"TRANSACTIONID\":\"9DV43757Y73711246\"}
paypal_token	[redacted]
pu_date
sent	1
start	0
transid
updated_at	2024-06-01 03:09:54
userid	19258
video_access_date	0000-00-00