Windsor brings all your BigCommerce data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

BigCommerce Field Reference

Fields

ID	Type	Name	Description	Report
brands__custom_url	OBJECT	brands.custom_url	brands.custom_url	brands
brands__id	NUMERIC	brands.id	brands.id	brands
brands__image_url	TEXT	brands.image_url	brands.image_url	brands
brands__meta_description	TEXT	brands.meta_description	brands.meta_description	brands
brands__meta_keywords	OBJECT	brands.meta_keywords	brands.meta_keywords	brands
brands__name	TEXT	brands.name	brands.name	brands
brands__page_title	TEXT	brands.page_title	brands.page_title	brands
brands__search_keywords	TEXT	brands.search_keywords	brands.search_keywords	brands
categories__custom_url	OBJECT	categories.custom_url	categories.custom_url	categories
categories__default_product_sort	TEXT	categories.default_product_sort	categories.default_product_sort	categories
categories__description	TEXT	categories.description	categories.description	categories
categories__id	NUMERIC	categories.id	categories.id	categories
categories__image_url	TEXT	categories.image_url	categories.image_url	categories
categories__is_visible	BOOLEAN	categories.is_visible	categories.is_visible	categories
categories__layout_file	TEXT	categories.layout_file	categories.layout_file	categories
categories__meta_description	TEXT	categories.meta_description	categories.meta_description	categories
categories__meta_keywords	OBJECT	categories.meta_keywords	categories.meta_keywords	categories
categories__name	TEXT	categories.name	categories.name	categories
categories__page_title	TEXT	categories.page_title	categories.page_title	categories
categories__parent_id	NUMERIC	categories.parent_id	categories.parent_id	categories
categories__search_keywords	TEXT	categories.search_keywords	categories.search_keywords	categories
categories__sort_order	NUMERIC	categories.sort_order	categories.sort_order	categories
categories__views	NUMERIC	categories.views	categories.views	categories
channels__date_created	DATE	channels.date_created	channels.date_created	channels
channels__date_modified	DATE	channels.date_modified	channels.date_modified	channels
channels__external_id	TEXT	channels.external_id	channels.external_id	channels
channels__icon_url	TEXT	channels.icon_url	channels.icon_url	channels
channels__id	NUMERIC	channels.id	channels.id	channels
channels__is_enabled	BOOLEAN	channels.is_enabled	channels.is_enabled	channels
channels__is_listable_from_ui	BOOLEAN	channels.is_listable_from_ui	channels.is_listable_from_ui	channels
channels__is_visible	BOOLEAN	channels.is_visible	channels.is_visible	channels
channels__name	TEXT	channels.name	channels.name	channels
channels__platform	TEXT	channels.platform	channels.platform	channels
channels__status	TEXT	channels.status	channels.status	channels
channels__type	TEXT	channels.type	channels.type	channels
customers__address_count	NUMERIC	customers.address_count	customers.address_count	customers
customers__addresses	OBJECT	customers.addresses	customers.addresses	customers
customers__attribute_count	NUMERIC	customers.attribute_count	customers.attribute_count	customers
customers__authentication	OBJECT	customers.authentication	customers.authentication	customers
customers__company	TEXT	customers.company	customers.company	customers
customers__customer_group_id	NUMERIC	customers.customer_group_id	customers.customer_group_id	customers
customers__date_created	DATE	customers.date_created	customers.date_created	customers
customers__date_modified	DATE	customers.date_modified	customers.date_modified	customers
customers__email	TEXT	customers.email	customers.email	customers
customers__first_name	TEXT	customers.first_name	customers.first_name	customers
customers__id	NUMERIC	customers.id	customers.id	customers
customers__last_name	TEXT	customers.last_name	customers.last_name	customers
customers__notes	TEXT	customers.notes	customers.notes	customers
customers__phone	TEXT	customers.phone	customers.phone	customers
customers__registration_ip_address	TEXT	customers.registration_ip_address	customers.registration_ip_address	customers
customers__tax_exempt_category	TEXT	customers.tax_exempt_category	customers.tax_exempt_category	customers
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
order_products__applied_discounts	OBJECT	order_products.applied_discounts	order_products.applied_discounts	order_products
order_products__base_cost_price	NUMERIC	order_products.base_cost_price	order_products.base_cost_price	order_products
order_products__base_price	TEXT	order_products.base_price	order_products.base_price	order_products
order_products__base_total	NUMERIC	order_products.base_total	order_products.base_total	order_products
order_products__base_wrapping_cost	TEXT	order_products.base_wrapping_cost	order_products.base_wrapping_cost	order_products
order_products__bin_picking_number	TEXT	order_products.bin_picking_number	order_products.bin_picking_number	order_products
order_products__brand	TEXT	order_products.brand	order_products.brand	order_products
order_products__configurable_fields	OBJECT	order_products.configurable_fields	order_products.configurable_fields	order_products
order_products__cost_price_ex_tax	NUMERIC	order_products.cost_price_ex_tax	order_products.cost_price_ex_tax	order_products
order_products__cost_price_inc_tax	NUMERIC	order_products.cost_price_inc_tax	order_products.cost_price_inc_tax	order_products
order_products__cost_price_tax	NUMERIC	order_products.cost_price_tax	order_products.cost_price_tax	order_products
order_products__depth	TEXT	order_products.depth	order_products.depth	order_products
order_products__ebay_item_id	TEXT	order_products.ebay_item_id	order_products.ebay_item_id	order_products
order_products__ebay_transaction_id	TEXT	order_products.ebay_transaction_id	order_products.ebay_transaction_id	order_products
order_products__event_date	DATE	order_products.event_date	order_products.event_date	order_products
order_products__event_name	TEXT	order_products.event_name	order_products.event_name	order_products
order_products__external_id	TEXT	order_products.external_id	order_products.external_id	order_products
order_products__fixed_shipping_cost	TEXT	order_products.fixed_shipping_cost	order_products.fixed_shipping_cost	order_products
order_products__fulfillment_source	TEXT	order_products.fulfillment_source	order_products.fulfillment_source	order_products
order_products__gift_certificate_id	NUMERIC	order_products.gift_certificate_id	order_products.gift_certificate_id	order_products
order_products__height	TEXT	order_products.height	order_products.height	order_products
order_products__id	NUMERIC	order_products.id	order_products.id	order_products
order_products__is_bundled_product	BOOLEAN	order_products.is_bundled_product	order_products.is_bundled_product	order_products
order_products__is_refunded	BOOLEAN	order_products.is_refunded	order_products.is_refunded	order_products
order_products__name	TEXT	order_products.name	order_products.name	order_products
order_products__name_customer	TEXT	order_products.name_customer	order_products.name_customer	order_products
order_products__name_merchant	TEXT	order_products.name_merchant	order_products.name_merchant	order_products
order_products__option_set_id	NUMERIC	order_products.option_set_id	order_products.option_set_id	order_products
order_products__order_address_id	NUMERIC	order_products.order_address_id	order_products.order_address_id	order_products
order_products__order_id	NUMERIC	order_products.order_id	order_products.order_id	order_products
order_products__parent_order_product_id	NUMERIC	order_products.parent_order_product_id	order_products.parent_order_product_id	order_products
order_products__price_ex_tax	TEXT	order_products.price_ex_tax	order_products.price_ex_tax	order_products
order_products__price_inc_tax	TEXT	order_products.price_inc_tax	order_products.price_inc_tax	order_products
order_products__price_tax	TEXT	order_products.price_tax	order_products.price_tax	order_products
order_products__product_id	NUMERIC	order_products.product_id	order_products.product_id	order_products
order_products__product_options	OBJECT	order_products.product_options	order_products.product_options	order_products
order_products__quantity	NUMERIC	order_products.quantity	order_products.quantity	order_products
order_products__quantity_refunded	NUMERIC	order_products.quantity_refunded	order_products.quantity_refunded	order_products
order_products__quantity_shipped	NUMERIC	order_products.quantity_shipped	order_products.quantity_shipped	order_products
order_products__refund_amount	NUMERIC	order_products.refund_amount	order_products.refund_amount	order_products
order_products__return_id	NUMERIC	order_products.return_id	order_products.return_id	order_products
order_products__sku	TEXT	order_products.sku	order_products.sku	order_products
order_products__total_ex_tax	NUMERIC	order_products.total_ex_tax	order_products.total_ex_tax	order_products
order_products__total_inc_tax	NUMERIC	order_products.total_inc_tax	order_products.total_inc_tax	order_products
order_products__total_tax	NUMERIC	order_products.total_tax	order_products.total_tax	order_products
order_products__type	TEXT	order_products.type	order_products.type	order_products
order_products__upc	TEXT	order_products.upc	order_products.upc	order_products
order_products__variant_id	NUMERIC	order_products.variant_id	order_products.variant_id	order_products
order_products__weight	TEXT	order_products.weight	order_products.weight	order_products
order_products__width	TEXT	order_products.width	order_products.width	order_products
order_products__wrapping_cost_ex_tax	NUMERIC	order_products.wrapping_cost_ex_tax	order_products.wrapping_cost_ex_tax	order_products
order_products__wrapping_cost_inc_tax	NUMERIC	order_products.wrapping_cost_inc_tax	order_products.wrapping_cost_inc_tax	order_products
order_products__wrapping_cost_tax	NUMERIC	order_products.wrapping_cost_tax	order_products.wrapping_cost_tax	order_products
order_products__wrapping_id	TEXT	order_products.wrapping_id	order_products.wrapping_id	order_products
order_products__wrapping_message	TEXT	order_products.wrapping_message	order_products.wrapping_message	order_products
order_products__wrapping_name	TEXT	order_products.wrapping_name	order_products.wrapping_name	order_products
orders__base_handling_cost	TEXT	orders.base_handling_cost	orders.base_handling_cost	orders
orders__base_shipping_cost	TEXT	orders.base_shipping_cost	orders.base_shipping_cost	orders
orders__base_wrapping_cost	TEXT	orders.base_wrapping_cost	orders.base_wrapping_cost	orders
orders__billing_address	OBJECT	orders.billing_address	orders.billing_address	orders
orders__cart_id	TEXT	orders.cart_id	orders.cart_id	orders
orders__channel_id	NUMERIC	orders.channel_id	orders.channel_id	orders
orders__coupon_discount	TEXT	orders.coupon_discount	orders.coupon_discount	orders
orders__coupons	OBJECT	orders.coupons	orders.coupons	orders
orders__currency_code	TEXT	orders.currency_code	orders.currency_code	orders
orders__currency_exchange_rate	TEXT	orders.currency_exchange_rate	orders.currency_exchange_rate	orders
orders__currency_id	NUMERIC	orders.currency_id	orders.currency_id	orders
orders__customer_id	NUMERIC	orders.customer_id	orders.customer_id	orders
orders__customer_locale	TEXT	orders.customer_locale	orders.customer_locale	orders
orders__customer_message	TEXT	orders.customer_message	orders.customer_message	orders
orders__date_created	DATE	orders.date_created	orders.date_created	orders
orders__date_modified	DATE	orders.date_modified	orders.date_modified	orders
orders__date_shipped	DATE	orders.date_shipped	orders.date_shipped	orders
orders__default_currency_code	TEXT	orders.default_currency_code	orders.default_currency_code	orders
orders__default_currency_id	NUMERIC	orders.default_currency_id	orders.default_currency_id	orders
orders__discount_amount	NUMERIC	orders.discount_amount	orders.discount_amount	orders
orders__ebay_order_id	TEXT	orders.ebay_order_id	orders.ebay_order_id	orders
orders__external_id	TEXT	orders.external_id	orders.external_id	orders
orders__external_source	TEXT	orders.external_source	orders.external_source	orders
orders__geoip_country	COUNTRY	orders.geoip_country	orders.geoip_country	orders
orders__geoip_country_iso2	COUNTRY	orders.geoip_country_iso2	orders.geoip_country_iso2	orders
orders__gift_certificate_amount	NUMERIC	orders.gift_certificate_amount	orders.gift_certificate_amount	orders
orders__handling_cost_ex_tax	NUMERIC	orders.handling_cost_ex_tax	orders.handling_cost_ex_tax	orders
orders__handling_cost_inc_tax	NUMERIC	orders.handling_cost_inc_tax	orders.handling_cost_inc_tax	orders
orders__handling_cost_tax	NUMERIC	orders.handling_cost_tax	orders.handling_cost_tax	orders
orders__handling_cost_tax_class_id	NUMERIC	orders.handling_cost_tax_class_id	orders.handling_cost_tax_class_id	orders
orders__id	TEXT	orders.id	orders.id	orders
orders__ip_address	TEXT	orders.ip_address	orders.ip_address	orders
orders__is_deleted	BOOLEAN	orders.is_deleted	orders.is_deleted	orders
orders__is_email_opt_in	BOOLEAN	orders.is_email_opt_in	orders.is_email_opt_in	orders
orders__items_shipped	NUMERIC	orders.items_shipped	orders.items_shipped	orders
orders__items_total	NUMERIC	orders.items_total	orders.items_total	orders
orders__order_is_digital	BOOLEAN	orders.order_is_digital	orders.order_is_digital	orders
orders__order_source	TEXT	orders.order_source	orders.order_source	orders
orders__payment_method	TEXT	orders.payment_method	orders.payment_method	orders
orders__payment_status	TEXT	orders.payment_status	orders.payment_status	orders
orders__products	OBJECT	orders.products	orders.products	orders
orders__refunded_amount	NUMERIC	orders.refunded_amount	orders.refunded_amount	orders
orders__shipping_address_count	NUMERIC	orders.shipping_address_count	orders.shipping_address_count	orders
orders__shipping_addresses	OBJECT	orders.shipping_addresses	orders.shipping_addresses	orders
orders__shipping_cost_ex_tax	NUMERIC	orders.shipping_cost_ex_tax	orders.shipping_cost_ex_tax	orders
orders__shipping_cost_inc_tax	NUMERIC	orders.shipping_cost_inc_tax	orders.shipping_cost_inc_tax	orders
orders__shipping_cost_tax	NUMERIC	orders.shipping_cost_tax	orders.shipping_cost_tax	orders
orders__shipping_cost_tax_class_id	NUMERIC	orders.shipping_cost_tax_class_id	orders.shipping_cost_tax_class_id	orders
orders__staff_notes	TEXT	orders.staff_notes	orders.staff_notes	orders
orders__status	TEXT	orders.status	orders.status	orders
orders__status_id	NUMERIC	orders.status_id	orders.status_id	orders
orders__store_credit_amount	NUMERIC	orders.store_credit_amount	orders.store_credit_amount	orders
orders__subtotal_ex_tax	NUMERIC	orders.subtotal_ex_tax	orders.subtotal_ex_tax	orders
orders__subtotal_inc_tax	NUMERIC	orders.subtotal_inc_tax	orders.subtotal_inc_tax	orders
orders__subtotal_tax	NUMERIC	orders.subtotal_tax	orders.subtotal_tax	orders
orders__tax_provider_id	TEXT	orders.tax_provider_id	orders.tax_provider_id	orders
orders__total_ex_tax	NUMERIC	orders.total_ex_tax	orders.total_ex_tax	orders
orders__total_inc_tax	NUMERIC	orders.total_inc_tax	orders.total_inc_tax	orders
orders__wrapping_cost_ex_tax	NUMERIC	orders.wrapping_cost_ex_tax	orders.wrapping_cost_ex_tax	orders
orders__wrapping_cost_inc_tax	NUMERIC	orders.wrapping_cost_inc_tax	orders.wrapping_cost_inc_tax	orders
orders__wrapping_cost_tax	NUMERIC	orders.wrapping_cost_tax	orders.wrapping_cost_tax	orders
orders__wrapping_cost_tax_class_id	NUMERIC	orders.wrapping_cost_tax_class_id	orders.wrapping_cost_tax_class_id	orders
pages__body	TEXT	pages.body	pages.body	pages
pages__channel_id	NUMERIC	pages.channel_id	pages.channel_id	pages
pages__contact_fields	TEXT	pages.contact_fields	pages.contact_fields	pages
pages__email	TEXT	pages.email	pages.email	pages
pages__feed	TEXT	pages.feed	pages.feed	pages
pages__id	NUMERIC	pages.id	pages.id	pages
pages__is_customers_only	BOOLEAN	pages.is_customers_only	pages.is_customers_only	pages
pages__is_homepage	BOOLEAN	pages.is_homepage	pages.is_homepage	pages
pages__is_visible	BOOLEAN	pages.is_visible	pages.is_visible	pages
pages__link	TEXT	pages.link	pages.link	pages
pages__meta_description	TEXT	pages.meta_description	pages.meta_description	pages
pages__meta_keywords	TEXT	pages.meta_keywords	pages.meta_keywords	pages
pages__meta_title	TEXT	pages.meta_title	pages.meta_title	pages
pages__name	TEXT	pages.name	pages.name	pages
pages__parent_id	NUMERIC	pages.parent_id	pages.parent_id	pages
pages__search_keywords	TEXT	pages.search_keywords	pages.search_keywords	pages
pages__sort_order	NUMERIC	pages.sort_order	pages.sort_order	pages
pages__type	TEXT	pages.type	pages.type	pages
pages__url	TEXT	pages.url	pages.url	pages
products__availability	TEXT	products.availability	products.availability	products
products__availability_description	TEXT	products.availability_description	products.availability_description	products
products__base_variant_id	NUMERIC	products.base_variant_id	products.base_variant_id	products
products__bin_picking_number	TEXT	products.bin_picking_number	products.bin_picking_number	products
products__brand_id	NUMERIC	products.brand_id	products.brand_id	products
products__brand_name or brand_id	TEXT	products.brand_name or brand_id	products.brand_name or brand_id	products
products__bulk_pricing_rules	OBJECT	products.bulk_pricing_rules	products.bulk_pricing_rules	products
products__calculated_price	NUMERIC	products.calculated_price	products.calculated_price	products
products__categories	OBJECT	products.categories	products.categories	products
products__condition	TEXT	products.condition	products.condition	products
products__cost_price	NUMERIC	products.cost_price	products.cost_price	products
products__custom_fields	OBJECT	products.custom_fields	products.custom_fields	products
products__custom_url	OBJECT	products.custom_url	products.custom_url	products
products__date_created	DATE	products.date_created	products.date_created	products
products__date_modified	DATE	products.date_modified	products.date_modified	products
products__depth	NUMERIC	products.depth	products.depth	products
products__description	TEXT	products.description	products.description	products
products__fixed_cost_shipping_price	NUMERIC	products.fixed_cost_shipping_price	products.fixed_cost_shipping_price	products
products__gift_wrapping_options_list	OBJECT	products.gift_wrapping_options_list	products.gift_wrapping_options_list	products
products__gift_wrapping_options_type	TEXT	products.gift_wrapping_options_type	products.gift_wrapping_options_type	products
products__gtin	TEXT	products.gtin	products.gtin	products
products__height	NUMERIC	products.height	products.height	products
products__id	NUMERIC	products.id	products.id	products
products__images	OBJECT	products.images	products.images	products
products__inventory_level	NUMERIC	products.inventory_level	products.inventory_level	products
products__inventory_tracking	TEXT	products.inventory_tracking	products.inventory_tracking	products
products__inventory_warning_level	NUMERIC	products.inventory_warning_level	products.inventory_warning_level	products
products__is_condition_shown	BOOLEAN	products.is_condition_shown	products.is_condition_shown	products
products__is_featured	BOOLEAN	products.is_featured	products.is_featured	products
products__is_free_shipping	BOOLEAN	products.is_free_shipping	products.is_free_shipping	products
products__is_preorder_only	BOOLEAN	products.is_preorder_only	products.is_preorder_only	products
products__is_price_hidden	BOOLEAN	products.is_price_hidden	products.is_price_hidden	products
products__is_visible	BOOLEAN	products.is_visible	products.is_visible	products
products__layout_file	TEXT	products.layout_file	products.layout_file	products
products__map_price	NUMERIC	products.map_price	products.map_price	products
products__meta_description	TEXT	products.meta_description	products.meta_description	products
products__meta_keywords	OBJECT	products.meta_keywords	products.meta_keywords	products
products__modifiers	OBJECT	products.modifiers	products.modifiers	products
products__mpn	TEXT	products.mpn	products.mpn	products
products__name	TEXT	products.name	products.name	products
products__open_graph_description	TEXT	products.open_graph_description	products.open_graph_description	products
products__open_graph_title	TEXT	products.open_graph_title	products.open_graph_title	products
products__open_graph_type	TEXT	products.open_graph_type	products.open_graph_type	products
products__open_graph_use_image	BOOLEAN	products.open_graph_use_image	products.open_graph_use_image	products
products__open_graph_use_meta_description	BOOLEAN	products.open_graph_use_meta_description	products.open_graph_use_meta_description	products
products__open_graph_use_product_name	BOOLEAN	products.open_graph_use_product_name	products.open_graph_use_product_name	products
products__option_set_display	TEXT	products.option_set_display	products.option_set_display	products
products__option_set_id	NUMERIC	products.option_set_id	products.option_set_id	products
products__options	OBJECT	products.options	products.options	products
products__order_quantity_maximum	NUMERIC	products.order_quantity_maximum	products.order_quantity_maximum	products
products__order_quantity_minimum	NUMERIC	products.order_quantity_minimum	products.order_quantity_minimum	products
products__page_title	TEXT	products.page_title	products.page_title	products
products__preorder_message	TEXT	products.preorder_message	products.preorder_message	products
products__preorder_release_date	DATE	products.preorder_release_date	products.preorder_release_date	products
products__price	NUMERIC	products.price	products.price	products
products__price_hidden_label	TEXT	products.price_hidden_label	products.price_hidden_label	products
products__product_tax_code	TEXT	products.product_tax_code	products.product_tax_code	products
products__related_products	OBJECT	products.related_products	products.related_products	products
products__retail_price	NUMERIC	products.retail_price	products.retail_price	products
products__reviews_count	NUMERIC	products.reviews_count	products.reviews_count	products
products__reviews_rating_sum	NUMERIC	products.reviews_rating_sum	products.reviews_rating_sum	products
products__sale_price	NUMERIC	products.sale_price	products.sale_price	products
products__search_keywords	TEXT	products.search_keywords	products.search_keywords	products
products__sku	TEXT	products.sku	products.sku	products
products__sort_order	NUMERIC	products.sort_order	products.sort_order	products
products__tax_class_id	NUMERIC	products.tax_class_id	products.tax_class_id	products
products__total_sold	NUMERIC	products.total_sold	products.total_sold	products
products__type	TEXT	products.type	products.type	products
products__upc	TEXT	products.upc	products.upc	products
products__variants	OBJECT	products.variants	products.variants	products
products__videos	OBJECT	products.videos	products.videos	products
products__view_count	NUMERIC	products.view_count	products.view_count	products
products__warranty	TEXT	products.warranty	products.warranty	products
products__weight	NUMERIC	products.weight	products.weight	products
products__width	NUMERIC	products.width	products.width	products
source	TEXT	Source	The name of the Windsor connector returning the row
store__account_uuid	TEXT	store.account_uuid	store.account_uuid	store
store__active_comparison_modules	OBJECT	store.active_comparison_modules	store.active_comparison_modules	store
store__address	TEXT	store.address	store.address	store
store__admin_email	TEXT	store.admin_email	store.admin_email	store
store__control_panel_base_url	TEXT	store.control_panel_base_url	store.control_panel_base_url	store
store__country	COUNTRY	store.country	store.country	store
store__country_code	COUNTRY	store.country_code	store.country_code	store
store__currency	TEXT	store.currency	store.currency	store
store__currency_symbol	TEXT	store.currency_symbol	store.currency_symbol	store
store__currency_symbol_location	TEXT	store.currency_symbol_location	store.currency_symbol_location	store
store__decimal_places	NUMERIC	store.decimal_places	store.decimal_places	store
store__decimal_separator	TEXT	store.decimal_separator	store.decimal_separator	store
store__default_channel_id	NUMERIC	store.default_channel_id	store.default_channel_id	store
store__default_site_id	NUMERIC	store.default_site_id	store.default_site_id	store
store__dimension_decimal_places	NUMERIC	store.dimension_decimal_places	store.dimension_decimal_places	store
store__dimension_decimal_token	TEXT	store.dimension_decimal_token	store.dimension_decimal_token	store
store__dimension_thousands_token	TEXT	store.dimension_thousands_token	store.dimension_thousands_token	store
store__dimension_units	TEXT	store.dimension_units	store.dimension_units	store
store__domain	TEXT	store.domain	store.domain	store
store__favicon_url	TEXT	store.favicon_url	store.favicon_url	store
store__features	OBJECT	store.features	store.features	store
store__first_name	TEXT	store.first_name	store.first_name	store
store__id	TEXT	store.id	store.id	store
store__industry	TEXT	store.industry	store.industry	store
store__is_price_entered_with_tax	BOOLEAN	store.is_price_entered_with_tax	store.is_price_entered_with_tax	store
store__language	TEXT	store.language	store.language	store
store__last_name	TEXT	store.last_name	store.last_name	store
store__logo	OBJECT	store.logo	store.logo	store
store__name	TEXT	store.name	store.name	store
store__order_email	TEXT	store.order_email	store.order_email	store
store__phone	TEXT	store.phone	store.phone	store
store__plan_is_trial	BOOLEAN	store.plan_is_trial	store.plan_is_trial	store
store__plan_level	TEXT	store.plan_level	store.plan_level	store
store__plan_name	TEXT	store.plan_name	store.plan_name	store
store__secure_url	TEXT	store.secure_url	store.secure_url	store
store__status	TEXT	store.status	store.status	store
store__store_id	NUMERIC	store.store_id	store.store_id	store
store__thousands_separator	TEXT	store.thousands_separator	store.thousands_separator	store
store__timezone	OBJECT	store.timezone	store.timezone	store
store__weight_units	TEXT	store.weight_units	store.weight_units	store
today	DATE	Today	Today's date
transactions__amount	NUMERIC	transactions.amount	transactions.amount	transactions
transactions__avs_result	OBJECT	transactions.avs_result	transactions.avs_result	transactions
transactions__credit_card	OBJECT	transactions.credit_card	transactions.credit_card	transactions
transactions__currency	TEXT	transactions.currency	transactions.currency	transactions
transactions__custom	OBJECT	transactions.custom	transactions.custom	transactions
transactions__cvv_result	OBJECT	transactions.cvv_result	transactions.cvv_result	transactions
transactions__date_created	DATE	transactions.date_created	transactions.date_created	transactions
transactions__event	TEXT	transactions.event	transactions.event	transactions
transactions__fraud_review	BOOLEAN	transactions.fraud_review	transactions.fraud_review	transactions
transactions__gateway	TEXT	transactions.gateway	transactions.gateway	transactions
transactions__gateway_transaction_id	TEXT	transactions.gateway_transaction_id	transactions.gateway_transaction_id	transactions
transactions__gift_certificate	OBJECT	transactions.gift_certificate	transactions.gift_certificate	transactions
transactions__id	NUMERIC	transactions.id	transactions.id	transactions
transactions__method	TEXT	transactions.method	transactions.method	transactions
transactions__offline	OBJECT	transactions.offline	transactions.offline	transactions
transactions__order_id	TEXT	transactions.order_id	transactions.order_id	transactions
transactions__payment_instrument_token	TEXT	transactions.payment_instrument_token	transactions.payment_instrument_token	transactions
transactions__payment_method_id	TEXT	transactions.payment_method_id	transactions.payment_method_id	transactions
transactions__reference_transaction_id	NUMERIC	transactions.reference_transaction_id	transactions.reference_transaction_id	transactions
transactions__status	TEXT	transactions.status	transactions.status	transactions
transactions__store_credit	OBJECT	transactions.store_credit	transactions.store_credit	transactions
transactions__test	BOOLEAN	transactions.test	transactions.test	transactions