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 |
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 |
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 |