capture_on_shipment Campaigns
Capture on shipment
integer products_cycle1billdelay Campaigns
Products cycle1 bill delay
string enable_fraud_plugin Campaigns
Enable fraud plugin
integer shipprofiles_shipmethod Campaigns
Ship profiles ship method
string products_producttype Campaigns
Products product type
string products_campaignproductid Campaigns
Products campaign product id
integer products_trialenabled Campaigns
Products trial enabled
integer shipprofiles_isupcharge Campaigns
Ship profiles is upcharge
integer shipprofiles_profilename Campaigns
Ship profiles profile name
string products_variantdetailid Campaigns
Products variant detail id
string products_staggerintervalcycles Campaigns
Products stagger interval cycles
string currencies_iscomma Campaigns
Currencies is comma
integer products_baseproductname Campaigns
Products base product name
string products_productcategoryname Campaigns
Products product category name
string countries_currencycode Campaigns
Countries currency code
string products_clubpluginid Campaigns
Products club plugin id
string products_finalbillingcycle Campaigns
Products final billing cycle
string re_order_days Campaigns
Re order days
string products_trialtype Campaigns
Products trial type
string pr_percent Campaigns
Pr percent
float products_fulfillmentdelayhours Campaigns
Products fulfillment delay hours
integer products_productqty Campaigns
Products product qty
integer products_hasvariants Campaigns
Products has variants
integer products_productdescription Campaigns
Products product description
string products_cycle2_price Campaigns
Products cycle2 price
string shipprofiles_freeshipthreshold Campaigns
Ship profiles free ship threshold
string countries_countrycode Campaigns
Countries country code
string block_prepaid Campaigns
Block prepaid
integer products_isvariantbundle Campaigns
Products is variant bundle
integer coupon_max Campaigns
Coupon max
integer countries_numericcode Campaigns
Countries numeric code
string currencies_sendtogateway Campaigns
Currencies send to gateway
integer products_externalproductid Campaigns
Products external product id
string insure_ship_load_balancer_id Campaigns
Insure ship load balancer id
string auto_tax Campaigns
Auto tax
integer currencies_rounding Campaigns
Currencies rounding
string products_minorderprice Campaigns
Products min order price
string products_weight Campaigns
Products weight
string products_iseditable Campaigns
Products is editable
integer date_created Campaigns
Date created
datetime products_fulfillmentcycletype Campaigns
Products fulfillment cycle type
string currencies_currencyname Campaigns
Currencies currency name
string products_shippingcost Campaigns
Products shipping cost
string list_sales_entry Campaigns
List sales entry
integer require_t_o_s Campaigns
Require TOS
integer products_persistentrebillday Campaigns
Products persistent rebill day
integer currencies_currencynumber Campaigns
Currencies currency number
string products_billername Campaigns
Products biller name
string single_transaction Campaigns
Single transaction
integer currencies_currencyfee Campaigns
Currencies currency fee
string shipprofiles_includecoupons Campaigns
Ship profiles include coupons
integer block_visa Campaigns
Block visa
integer products_productid Campaigns
Products product id
integer products_compareatprice Campaigns
Products compare at price
string products_trialloadbalancerid Campaigns
Products trial load balancer id
string disable_external_payments Campaigns
Disable external payments
integer shipprofiles_highestshippriceonly Campaigns
Ship profiles highest ship price only
integer campaign_name Campaigns
Campaign name
string products_fixedbillingday Campaigns
Products fixed billing day
string products_maxorderprice Campaigns
Products max order price
string products_producttags Campaigns
Products product tags
string products_bundleproductqty Campaigns
Products bundle product qty
string products_productcategoryid Campaigns
Products product category id
string block_chargeback_blacklist Campaigns
Block Chargeback Blacklist
integer products_productcost Campaigns
Products Product Cost
string products_cycle2_isshippable Campaigns
Products Cycle2 Is Shippable
integer tax_service_id Campaigns
Tax Service Id
integer pinless_debit_route Campaigns
Pinless Debit Route
integer currencies_includeshipping Campaigns
Currencies Include Shipping
integer has_automatic_coupons Campaigns
Has Automatic Coupons
integer products_trialbillerid Campaigns
Products Trial Biller Id
string products_showtoaffiliates Campaigns
Products Show To Affiliates
integer shipprofiles_shiprefcode Campaigns
Ship Profiles Ship Ref Code
string countries_countryname Campaigns
Countries Country Name
string currency_number Campaigns
Currency Number
string block_mastercard Campaigns
Block Mastercard
integer products_cycle2_billdelay Campaigns
Products Cycle2 Bill Delay
string products_shippingprice Campaigns
Products Shipping Price
string customfields_fieldname Campaigns
Custom Fields Field Name
string products_ispricepercent Campaigns
Products Is Price Percent
integer products_subscriptionoptions Campaigns
Products Subscription Options
string block_debit Campaigns
Block Debit
integer disable_recycle_billing Campaigns
Disable Recycle Billing
integer qa_percent Campaigns
Qa Percent
integer products_descriptor Campaigns
Products Descriptor
string products_price Campaigns
Products Price
string products_billingcycletype Campaigns
Products Billing Cycle Type
string products_trialloadbalancername Campaigns
Products Trial Load Balancer Name
string upsell_window Campaigns
Upsell Window
string products_maxorderqty Campaigns
Products Max Order Qty
string products_taxserviceid Campaigns
Products Tax Service Id
string products_trialauthtype Campaigns
Products Trial Auth Type
string currency_symbol Campaigns
Currency Symbol
string shipprofiles_shipprofileid Campaigns
Ship Profiles Ship Profile Id
integer products_billerid Campaigns
Products Biller Id
integer products_recurringproductid Campaigns
Products Recurring Product Id
string products_productname Campaigns
Products Product Name
string currencies_decimals Campaigns
Currencies Decimals
float shipprofiles_applyentireorder Campaigns
Ship Profiles Apply Entire Order
integer campaign_category_id Campaigns
Campaign Category Id
integer bundle_fulfillment Campaigns
Bundle Fulfillment
integer products_imageurl Campaigns
Products Image Url
string require_q_a Campaigns
Require QA
integer insure_ship_id Campaigns
Insure Ship Id
integer products_campaignproductqty Campaigns
Products Campaign Product Qty
string products_fulfillmenthouseid Campaigns
Products Fulfillment House Id
string products_imageurls Campaigns
Products Image Urls
string products_allowstorepickup Campaigns
Products Allow Store Pickup
string currency Campaigns
Currency
string customfields_fieldtype Campaigns
Custom Fields Field Type
string insure_ship_biller_id Campaigns
Insure Ship Biller Id
string products_cycle3_billdelay Campaigns
Products Cycle3 Bill Delay
string products_custommessageoptions Campaigns
Products Custom Message Options
string products_loadbalancername Campaigns
Products Load Balancer Name
string products_cycle2_shipprice Campaigns
Products Cycle2 Ship Price
string products_productsku Campaigns
Products Product Sku
string products_cycle3_isshippable Campaigns
Products Cycle3 Is Shippable
integer shipprofiles_rules Campaigns
Ship Profiles Rules
string is_locked Campaigns
Is Locked
integer campaign_t_o_s Campaigns
Campaign Tos
string external_campaign_id Campaigns
External Campaign Id
string products_stockquantity Campaigns
Products Stock Quantity
string products_cycle1_price Campaigns
Products Cycle1 Price
string currencies_currencysymbol Campaigns
Currencies Currency Symbol
string currencies_symbolalign Campaigns
Currencies Symbol Align
string products_cycle1_shipprice Campaigns
Products Cycle1 Ship Price
string max_bundle_hours Campaigns
Max Bundle Hours
integer products_cycle3_shipprice Campaigns
Products Cycle3 Ship Price
string products_trialbillername Campaigns
Products Trial Biller Name
string products_storefront Campaigns
Products Storefront
integer campaign_type Campaigns
Campaign Type
string preauth_only Campaigns
Preauth Only
integer products_msrp Campaigns
Products Msrp
string currencies_currencycode Campaigns
Currencies Currency Code
string default_ship_profile_id Campaigns
Default Ship Profile Id
string shipprofiles_skipupsell Campaigns
Ship Profiles Skip Upsell
integer default_coupon_code Campaigns
Default Coupon Code
string products_staggerfulfillments Campaigns
Products Stagger Fulfillments
integer cod_orders Campaigns
Cod Orders
integer campaign_id Campaigns
Campaign Id
integer products_cycle1_isshippable Campaigns
Products Cycle1 Is Shippable
integer products_isproductcombo Campaigns
Products Is Product Combo
string products_clientproductid Campaigns
Products Client Product Id
string products_cycle3_price Campaigns
Products Cycle3 Price
string products_useoffermid Campaigns
Products Use Offer Mid
integer e_signature Campaigns
ESignature
integer countries_continent Campaigns
Countries Continent
string products_externalvariantdetailid Campaigns
Products External Variant Detail Id
string products_loadbalancerid Campaigns
Products Load Balancer Id
string shipprofiles_shipcarrier Campaigns
Ship Profiles Ship Carrier
string customer_id Customers
Customer id
integer paysources_achlast4 Customers
Pay sources ach last4
string client_source_id Customers
Client source id
string paysources_isprimary Customers
Pay sources is primary
string ship_address2 Customers confidencial
Shipping address2
string pay_source_id Customers
Pay source id
integer last_name Customers confidencial
Last name
string source_type Customers
Source type
string date_created Customers
Date created
datetime paysources_paysourceid Customers
Pay source id
integer paysources_achbankname Customers confidencial
Pay sources ach bank name
string ship_address1 Customers confidencial
Shipping address1
string date_updated Customers
Date updated
datetime campaign_name Customers
Campaign name
string source_value4 Customers
Source value4
string first_name Customers confidencial
First name
string card_type Customers
Card type
string address1 Customers confidencial
Address1
string card_expiry_date Customers
Card expiry date
datetime ship_state Customers
Shipping state
string state Customers confidencial
State
string e_commerce_password Customers confidencial
E commerce password
string credit_amount Customers confidencial
Credit amount
string ip_address Customers confidencial
Ip address
string paysources_cardexpirydate Customers
Pay sources card expiry date
datetime company_name Customers
Company name
string paysources_cardyear Customers
Pay sources card year
string paysources_achroutingnumber Customers confidencial
Pay sources ach routing number
string email_opt_in Customers
Email opt in
integer source_value5 Customers
Source value5
string notes_agentname Customers
Notes agent name
string contact_opt_in Customers
Contact opt in
integer card_last4 Customers confidencial
Card last4
string ship_country Customers
Shipping country
string notes_datecreated Customers
Notes date created
datetime do_not_sell_name Customers
Do not sell name
string postal_code Customers confidencial
Postal code
string source_value3 Customers
Source value3
string ship_first_name Customers confidencial
Shipping first name
string source_title Customers
Source title
string pay_source Customers
Pay source
string paysources_achaccounttype Customers
Pay sources ach account type
string phone_number Customers confidencial
Phone number
string campaign_type Customers
Campaign type
string gender Customers confidencial
Gender
string source_value1 Customers
Source value1
string paysources_paysourcetype Customers
Pay sources pay source type
string paysources_cardlast4 Customers confidencial
Pay sources card last4
string source_id Customers
Source id
string ship_postal_code Customers confidencial
Shipping postal code
string address2 Customers confidencial
Address 2
string most_recent_activity Customers
Most recent activity
datetime bill_ship_same Customers
Bill Shipping same
integer paysources_cardtype Customers
Card type
string source_value2 Customers
Source value2
string ship_city Customers
Shipping city
string paysources_cardmonth Customers
Pay sources card month
string ship_last_name Customers confidencial
Shipping last name
string email_address Customers confidencial
Email address
string notes_message Customers
Notes message
string ship_company_name Customers
Shipping company name
string e_commerce_login Customers confidencial
e-commerce login
string ach_account_number Orders
Ach account number
string ach_routing_number Orders
Ach routing number
string actual_order_id Orders
Actual order id
integer address1 Orders confidencial
Address1
string address2 Orders confidencial
Address2
string agent_name Orders
Agent name
string agent_user_id Orders
Agent user id
integer avs_response Orders
Avs response
string base_shipping Orders
Base shipping
string campaign_category_name Orders
Campaign category name
string campaign_id Orders
Campaign id
integer campaign_name Orders
Campaign name
string card_expiry_date Orders
Card expiry date
datetime card_is_debit Orders
Card is debit
integer card_is_prepaid Orders
Card is prepaid
integer card_last4 Orders confidencial
Card last4
string city Orders confidencial
City
string client_order_id Orders
Client order id
string company_name Orders confidencial
Company name
string country Orders confidencial
Country
string coupon_code Orders
Coupon code
string currency_code Orders
Currency code
string currency_symbol Orders
Currency symbol
string customer_id Orders
Customer id
integer cvv_response Orders
Cvv response
string date_updated Orders
Date updated
datetime discount_price Orders
Discount price
string email_address Orders confidencial
Email address
string external_order_id Orders
External order id
string first_name Orders confidencial
First name
string funnel_reference_id Orders
Funnel reference id
string has_upsell Orders
Has upsell
string ip_address Orders confidencial
Ip address
string is_decline_save Orders
Is decline save
integer last_name Orders confidencial
Last name
string name Orders confidencial
Name
string order_status Orders
Order status
string order_type Orders
Order type
string pay_source Orders
Pay source
string phone_number Orders confidencial
Phone number
string postal_code Orders confidencial
Postal code
string product_cost Orders
Product cost
string refund_remaining Orders
Refund remaining
string review_status Orders
Review status
string ship_address1 Orders confidencial
Ship address1
string ship_address2 Orders confidencial
Ship address2
string ship_carrier Orders
Ship carrier
string ship_company_name Orders
Ship company name
string ship_country Orders
Ship country
string ship_first_name Orders confidencial
Ship first name
string ship_last_name Orders confidencial
Ship last name
string ship_method Orders
Ship method
string ship_postal_code Orders confidencial
Ship postal code
string ship_profile_id Orders
Ship profile id
string ship_state Orders confidencial
Ship state
string ship_upcharge Orders
Ship upcharge
string shipping_cost Orders
Shipping cost
string source_title Orders
Source title
string source_value1 Orders
Source value1
string source_value2 Orders
Source value2
string source_value3 Orders
Source value3
string source_value4 Orders
Source value4
string source_value5 Orders
Source value5
string state Orders confidencial
State
string total_amount Orders
Total amount
string total_discount Orders
Total discount
string u_t_m_campaign Orders
Utm campaign
string u_t_m_content Orders
Utm content
string u_t_m_medium Orders
Utm medium
string u_t_m_source Orders
Utm source
string voice_log_number Orders
Voice log number
string fulfillments_responsetext Orders
Fulfillments response text
string fulfillments_trackingnumber Orders
Fulfillments tracking number
string fulfillments_shipcarrier Orders
Fulfillments ship carrier
string fulfillments_datedelivered Orders
Fulfillments date delivered
datetime fulfillments_dateshipped Orders
Fulfillments date shipped
datetime fulfillments_company Orders
Fulfillments company
string fulfillments_clientfulfillmentid Orders
Fulfillments client fulfillment id
string fulfillments_rmanumber Orders
Fulfillments rma number
string fulfillments_datecreated Orders
Fulfillments date created
datetime fulfillments_fulfillmentid Orders
Fulfillments fulfillment id
integer fulfillments_datereturned Orders
Fulfillments date returned
datetime date_created Orders
Date created
datetime fulfillments_fulfillmenthouseid Orders
Fulfillments fulfillment house id
integer fulfillments_shipmethod Orders
Fulfillments ship method
string fulfillments_items_price Orders
Fulfillments items price
string fulfillments_items_variantdetailid Orders
Fulfillments items variant detail id
string fulfillments_items_sku Orders
Fulfillments items sku
string fulfillments_items_fulfillmentitemid Orders
Fulfillments items fulfillment item id
string fulfillments_items_purchaseid Orders
Fulfillments items purchase id
string fulfillments_items_productid Orders
Fulfillments items product id
string fulfillments_items_shipping Orders
Fulfillments items shipping
string fulfillments_items_name Orders
Fulfillments items name
string fulfillments_items_qty Orders
Fulfillments items qty
string fulfillments_items_rmanumber Orders
Fulfillments items rma number
string fulfillments_items_salestax Orders
Fulfillments items sales tax
string fulfillments_items_status Orders
Fulfillments items status
string item_detailed_status Orders
Item detailed status
string item_order_item_id Orders
Item order item id
string item_price Orders
Item price
string item_product_id Orders
Item product id
string item_purchase_id Orders
Item purchase id
string item_purchase_status Orders
Item purchase status
string item_shipping Orders
Item shipping
string item_next_bill_date Orders
Item next bill date
datetime compare_at_price Products
Compare At Price
float custom_message_options Products
Custom Message Options
string threshold_quantity Products
Threshold Quantity
integer product_description Products
Product Description
string shipping_price Products
Shipping Price
float product_type Products
Product Type
string storefront Products
Storefront
integer product_sku Products
Product Sku
string final_fulfillment_cycle Products
Final Fulfillment Cycle
string product_id Products
Product Id
integer product_code Products
Product Code
string fulfillment_delay_hours Products
Fulfillment Delay Hours
integer fulfillment_cycle_type Products
Fulfillment Cycle Type
string client_product_id Products
Client Product Id
string fulfillment_house_id Products
Fulfillment House Id
string product_name Products
Product Name
string is_variant_bundle Products
Is Variant Bundle
integer is_price_percent Products
Is Price Percent
integer club_plugin_id Products
Club Plugin Id
integer external_product_id Products
External Product Id
integer is_product_combo Products
Is Product Combo
integer product_image_path Products
Product Image Path
string campaign_id Products
Campaign Id
integer item_count Products
Item Count
integer product_qty Products
Product Qty
integer tax_service_id Products
Tax Service Id
string product_category_id Products
Product Category Id
string product_tags Products
Product Tags
string product_category_name Products
Product Category Name
string currency_symbol Products
Currency Symbol
string stock_qty Products
Stock Qty
integer image_paths Products
Image Paths
string fulfillment_interval_day_of_month Products
Fulfillment Interval Day Of Month
integer bundle_product_qty Products
Bundle Product Qty
integer product_cost Products
Product Cost
float actual_order_id Transactions
Actual Order Id
integer items_sku Transactions
Items Sku
string items_quantity Transactions
Items Quantity
string avs_response Transactions
Avs Response
string items_variantdetailid Transactions
Items Variant Detail Id
string recycle_number Transactions
Recycle Number
string custom1 Transactions
Custom 1
string source_value4 Transactions
Source Value 4
string pay_source Transactions
Pay Source
string order_agent_name Transactions
Order Agent Name
string country Transactions confidencial
Country
string ach_bank_name Transactions
Ach Bank Name
string client_order_id Transactions
Client Order Id
string items_productid Transactions
Items Product Id
string first_name Transactions confidencial
First Name
string order_type Transactions
Order Type
string currency_symbol Transactions
Currency Symbol
string email_address Transactions confidencial
Email Address
string items_transactionitemid Transactions
Items Transaction Item Id
string custom5 Transactions
Custom 5
string currency_code Transactions
Currency Code
string cvv_response Transactions
Cvv Response
string is_chargedback Transactions
Is Chargedback
integer items_salestax Transactions
Items Sales Tax
string transaction_id Transactions
Transaction Id
integer items_datedelivered Transactions
Items Date Delivered
datetime ach_account_number Transactions
Ach Account Number
string source_title Transactions
Source Title
string custom3 Transactions
Custom 3
string response_text Transactions
Response Text
string items_nextbilldate Transactions
Items Next Bill Date
string ach_routing_number Transactions
Ach Routing Number
string chargeback_date Transactions
Chargeback Date
string chargeback_note Transactions
Chargeback Note
string city Transactions confidencial
City
string merchant_txn_id Transactions
Merchant Txn Id
string items_billingcyclenumber Transactions
Items Billing Cycle Number
string items_trackingnumber Transactions
Items Tracking Number
string refund_reason Transactions
Refund Reason
string card_bin Transactions
Card Bin
string source_value3 Transactions
Source Value 3
string date_updated Transactions
Date Updated
datetime client_txn_id Transactions
Client Txn Id
string custom2 Transactions
Custom 2
string surcharge Transactions
Surcharge
string auth_code Transactions
Auth Code
string items_price Transactions
Items Price
string date_created Transactions
Date Created
datetime postal_code Transactions confidencial
Postal Code
string items_lastcancellationdate Transactions
Items Last Cancellation Date
string items_purchaseid Transactions
Items Purchase Id
string campaign_category_name Transactions
Campaign Category Name
string parent_txn_id Transactions
Parent Txn Id
string address2 Transactions confidencial
Address 2
string campaign_id Transactions
Campaign Id
string response_type Transactions
Response Type
string address1 Transactions confidencial
Address 1
string chargeback_reason_code Transactions
Chargeback Reason Code
string order_id Transactions
Order Id
string source_value5 Transactions
Source Value 5
string items_shipping Transactions
Items Shipping
string customer_id Transactions
Customer Id
integer campaign_name Transactions
Campaign Name
string merchant_descriptor Transactions
Merchant Descriptor
string items_product Transactions
Items Product
string card_type Transactions
Card Type
string merchant_id Transactions
Merchant Id
integer card_is_prepaid Transactions
Card Is Prepaid
integer custom4 Transactions
Custom 4
string mid_number Transactions
Mid Number
string items_dateshipped Transactions
Items Date Shipped
datetime funnel_reference_id Transactions
Funnel Reference Id
string merchant Transactions
Merchant
string 3d_txn_result Transactions
3D Txn Result
string billing_cycle_number Transactions
Billing Cycle Number
integer items_status Transactions
Items Status
string items_fulfillmentstatus Transactions
Items Fulfillment Status
string ip_address Transactions confidencial
Ip Address
string last_name Transactions confidencial
Last Name
string chargeback_amount Transactions
Chargeback Amount
string source_value2 Transactions
Source Value 2
string card_last4 Transactions confidencial
Card Last 4
string pay_source_id Transactions
Pay Source Id
string txn_type Transactions
Txn Type
string total_amount Transactions
Total Amount
string card_is_debit Transactions
Card Is Debit
integer phone_number Transactions confidencial
Phone Number
string source_value1 Transactions
Source Value 1
string