Order Fields
Old order ID29001
DateJul 2, 2024
ParentJulie Johnstone
Emailjuliejohnstoneauthor@gmail.com
Payment modecard
Payment status
Transaction ID
Order Detail
Order, class registration, and linked PayPal/payment import rows.
Items
| Student | Course | Product | Amount | Status |
|---|---|---|---|---|
| Davis Johnstone | English & Reading Workshop (for July 13th, 2024 test) | English & Reading Workshop (for July 13th, 2024 test) | $195.00 | enrolled |
Payment Rows
| Provider | Transaction / Payment ID | Amount | Status | Date | Old Payment ID |
|---|---|---|---|---|---|
| paypal | 6RY42269RN831013L | $195.00 | paid | 2024-07-02 09:20:28 | 29510 |
Raw Old Order Fields
| Old Field | Imported Value |
|---|---|
| comment_date | |
| courseid | 933 |
| created_at | 2024-07-02 16:15:45 |
| date | 1719936945 |
| finish | 0 |
| id | 29001 |
| is_deleted | 0 |
| is_new_order | 1 |
| live | 0 |
| onlineclass | |
| ord_comments | |
| order_type | 0 |
| paid | 1 |
| paid_resp | |
| paid_status | 0 |
| parent_id | 44508 |
| 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=380&CREDITCARDTYPE=Amex&ACCT=371293229783008&EXPDATE=102024&CVV2=7123&FIRSTNAME=Julie&LASTNAME=Johnstone&STREET=st.peter burg&CITY=france&STATE=Arkansas&ZIP=01010&COUNTRYCODE=US&CURRENCYCODE=USD&DESC=\ [0] Davis Johnstone Course :- English & Reading Workshop (for July 13th, 2024 test) Price :- 195\ [1] Davis Johnstone Co\"} |
| paypal_response | {\"TIMESTAMP\":\"2024-07-02T16:20:28Z\",\"CORRELATIONID\":\"f9d8dd6bf61f7\",\"ACK\":\"Success\",\"VERSION\":\"85.0\",\"BUILD\":\"000000\",\"AMT\":\"380.00\",\"CURRENCYCODE\":\"USD\",\"AVSCODE\":\"Y\",\"CVV2MATCH\":\"M\",\"TRANSACTIONID\":\"6RY42269RN831013L\"} |
| paypal_token | [redacted] |
| pu_date | |
| sent | 1 |
| start | 0 |
| transid | |
| updated_at | 2024-07-02 16:15:45 |
| userid | 18618 |
| video_access_date | 0000-00-00 |