|
id
|
|
|
order_number
|
|
|
user_id
|
|
|
email
|
|
|
phone
|
|
|
subtotal
|
|
|
discount
|
|
|
coupon_code
|
|
|
total
|
|
|
refunded_total
|
|
|
refund_status
|
|
|
currency
|
|
|
payment_method
|
|
|
payment_id
|
|
|
wise_expected_amount
|
|
|
wise_expected_currency
|
|
|
payment_url
|
|
|
payment_status
|
|
|
order_status
|
|
|
notes
|
|
|
admin_notes
|
|
|
ip_address
|
|
|
billing_country
|
|
|
billing_state
|
|
|
billing_zip
|
|
|
tax_rate
|
|
|
tax_amount
|
|
|
us_invoice_id
|
|
|
user_agent
|
|
|
completed_at
|
|
|
created_at
|
|
|
updated_at
|
|
|
recovery_sent
|
|
|
recovery_sent_at
|
|
|
recovery_token
|
|
|
gclid
|
|
|
gbraid
|
|
|
wbraid
|
|
|
fbclid
|
|
|
ttclid
|
|
|
msclkid
|
|
|
utm_source
|
|
|
utm_medium
|
|
|
utm_campaign
|
|
|
utm_term
|
|
|
utm_content
|
|
|
referrer
|
|
|
landing_page
|
|
|
first_visit_at
|
|
|
session_count
|
|
|
first_touch_source
|
|
|
first_touch_medium
|
|
|
first_touch_campaign
|
|
|
first_touch_gclid
|
|
|
first_touch_fbclid
|
|
|
device_type
|
|
|
browser
|
|
|
os
|
|
|
client_id
|
|
|
fb_client_ip
|
|
|
fb_client_ua
|
|
|
fb_fbp
|
|
|
fb_fbc
|
|
|
fb_source_url
|
|
|
purchase_capi_sent_at
|
|
|
purchase_pixel_sent_at
|
|
|
idempotency_key
|
|
|
cart_hash
|
|
|
is_express
|
|
|
trustpilot_invite_sent_at
|
|
|
trustpilot_wa_contacted_at
|
|