Windsor brings all your Recharge data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Recharge Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| addresses__address1 | TEXT | addresses.address1 | addresses.address1 | addresses |
| addresses__address2 | TEXT | addresses.address2 | addresses.address2 | addresses |
| addresses__cart_note | TEXT | addresses.cart_note | addresses.cart_note | addresses |
| addresses__city | TEXT | addresses.city | addresses.city | addresses |
| addresses__company | TEXT | addresses.company | addresses.company | addresses |
| addresses__country | TEXT | addresses.country | addresses.country | addresses |
| addresses__country_code | TEXT | addresses.country_code | addresses.country_code | addresses |
| addresses__created_at | DATE | addresses.created_at | addresses.created_at | addresses |
| addresses__customer_id | NUMERIC | addresses.customer_id | addresses.customer_id | addresses |
| addresses__discount_id | NUMERIC | addresses.discount_id | addresses.discount_id | addresses |
| addresses__discounts | OBJECT | addresses.discounts | addresses.discounts | addresses |
| addresses__first_name | TEXT | addresses.first_name | addresses.first_name | addresses |
| addresses__id | NUMERIC | addresses.id | addresses.id | addresses |
| addresses__last_name | TEXT | addresses.last_name | addresses.last_name | addresses |
| addresses__note_attributes | OBJECT | addresses.note_attributes | addresses.note_attributes | addresses |
| addresses__order_attributes | OBJECT | addresses.order_attributes | addresses.order_attributes | addresses |
| addresses__order_note | TEXT | addresses.order_note | addresses.order_note | addresses |
| addresses__payment_method_id | NUMERIC | addresses.payment_method_id | addresses.payment_method_id | addresses |
| addresses__phone | TEXT | addresses.phone | addresses.phone | addresses |
| addresses__presentment_currency | TEXT | addresses.presentment_currency | addresses.presentment_currency | addresses |
| addresses__province | TEXT | addresses.province | addresses.province | addresses |
| addresses__shipping_lines_conserved | OBJECT | addresses.shipping_lines_conserved | addresses.shipping_lines_conserved | addresses |
| addresses__shipping_lines_override | OBJECT | addresses.shipping_lines_override | addresses.shipping_lines_override | addresses |
| addresses__updated_at | DATE | addresses.updated_at | addresses.updated_at | addresses |
| addresses__zip | TEXT | addresses.zip | addresses.zip | addresses |
| charges__address_id | NUMERIC | charges.address_id | charges.address_id | charges |
| charges__analytics_data | OBJECT | charges.analytics_data | charges.analytics_data | charges |
| charges__billing_address | OBJECT | charges.billing_address | charges.billing_address | charges |
| charges__charge_attempts | NUMERIC | charges.charge_attempts | charges.charge_attempts | charges |
| charges__client_details | OBJECT | charges.client_details | charges.client_details | charges |
| charges__created_at | DATE | charges.created_at | charges.created_at | charges |
| charges__currency | TEXT | charges.currency | charges.currency | charges |
| charges__customer | OBJECT | charges.customer | charges.customer | charges |
| charges__customer_hash | TEXT | charges.customer_hash | charges.customer_hash | charges |
| charges__customer_id | NUMERIC | charges.customer_id | charges.customer_id | charges |
| charges__discount_codes | OBJECT | charges.discount_codes | charges.discount_codes | charges |
| charges__discounts | OBJECT | charges.discounts | charges.discounts | charges |
| charges__email | TEXT | charges.email | charges.email | charges |
| charges__error | TEXT | charges.error | charges.error | charges |
| charges__error_type | TEXT | charges.error_type | charges.error_type | charges |
| charges__external_order_id | OBJECT | charges.external_order_id | charges.external_order_id | charges |
| charges__external_transaction_id | OBJECT | charges.external_transaction_id | charges.external_transaction_id | charges |
| charges__external_variant_id_not_found | BOOLEAN | charges.external_variant_id_not_found | charges.external_variant_id_not_found | charges |
| charges__external_variant_not_found | BOOLEAN | charges.external_variant_not_found | charges.external_variant_not_found | charges |
| charges__first_name | TEXT | charges.first_name | charges.first_name | charges |
| charges__has_uncommited_changes | BOOLEAN | charges.has_uncommited_changes | charges.has_uncommited_changes | charges |
| charges__has_uncommitted_changes | BOOLEAN | charges.has_uncommitted_changes | charges.has_uncommitted_changes | charges |
| charges__id | NUMERIC | charges.id | charges.id | charges |
| charges__last_charge_attempt | TEXT | charges.last_charge_attempt | charges.last_charge_attempt | charges |
| charges__last_charge_attempt_date | TEXT | charges.last_charge_attempt_date | charges.last_charge_attempt_date | charges |
| charges__last_name | TEXT | charges.last_name | charges.last_name | charges |
| charges__line_items | OBJECT | charges.line_items | charges.line_items | charges |
| charges__merged_at | DATE | charges.merged_at | charges.merged_at | charges |
| charges__note | TEXT | charges.note | charges.note | charges |
| charges__note_attributes | OBJECT | charges.note_attributes | charges.note_attributes | charges |
| charges__number_times_tried | NUMERIC | charges.number_times_tried | charges.number_times_tried | charges |
| charges__order_attributes | OBJECT | charges.order_attributes | charges.order_attributes | charges |
| charges__orders_count | NUMERIC | charges.orders_count | charges.orders_count | charges |
| charges__payment_processor | TEXT | charges.payment_processor | charges.payment_processor | charges |
| charges__processed_at | DATE | charges.processed_at | charges.processed_at | charges |
| charges__processor_name | TEXT | charges.processor_name | charges.processor_name | charges |
| charges__retry_date | TEXT | charges.retry_date | charges.retry_date | charges |
| charges__scheduled_at | DATE | charges.scheduled_at | charges.scheduled_at | charges |
| charges__shipments_count | NUMERIC | charges.shipments_count | charges.shipments_count | charges |
| charges__shipping_address | OBJECT | charges.shipping_address | charges.shipping_address | charges |
| charges__shipping_lines | OBJECT | charges.shipping_lines | charges.shipping_lines | charges |
| charges__shopify_order_id | TEXT | charges.shopify_order_id | charges.shopify_order_id | charges |
| charges__shopify_variant_id_not_found | TEXT | charges.shopify_variant_id_not_found | charges.shopify_variant_id_not_found | charges |
| charges__status | TEXT | charges.status | charges.status | charges |
| charges__subtotal_price | TEXT | charges.subtotal_price | charges.subtotal_price | charges |
| charges__tags | TEXT | charges.tags | charges.tags | charges |
| charges__tax_lines | TEXT | charges.tax_lines | charges.tax_lines | charges |
| charges__taxable | BOOLEAN | charges.taxable | charges.taxable | charges |
| charges__taxes_included | BOOLEAN | charges.taxes_included | charges.taxes_included | charges |
| charges__total_discounts | TEXT | charges.total_discounts | charges.total_discounts | charges |
| charges__total_duties | TEXT | charges.total_duties | charges.total_duties | charges |
| charges__total_line_items_price | TEXT | charges.total_line_items_price | charges.total_line_items_price | charges |
| charges__total_price | TEXT | charges.total_price | charges.total_price | charges |
| charges__total_refunds | TEXT | charges.total_refunds | charges.total_refunds | charges |
| charges__total_tax | TEXT | charges.total_tax | charges.total_tax | charges |
| charges__total_weight | NUMERIC | charges.total_weight | charges.total_weight | charges |
| charges__total_weight_grams | NUMERIC | charges.total_weight_grams | charges.total_weight_grams | charges |
| charges__transaction_id | TEXT | charges.transaction_id | charges.transaction_id | charges |
| charges__type | TEXT | charges.type | charges.type | charges |
| charges__updated_at | DATE | charges.updated_at | charges.updated_at | charges |
| collections__created_at | DATE | collections.created_at | collections.created_at | collections |
| collections__description | TEXT | collections.description | collections.description | collections |
| collections__id | NUMERIC | collections.id | collections.id | collections |
| collections__name | TEXT | collections.name | collections.name | collections |
| collections__sort_order | TEXT | collections.sort_order | collections.sort_order | collections |
| collections__title | TEXT | collections.title | collections.title | collections |
| collections__type | TEXT | collections.type | collections.type | collections |
| collections__updated_at | DATE | collections.updated_at | collections.updated_at | collections |
| customers__accepts_marketing | NUMERIC | customers.accepts_marketing | customers.accepts_marketing | customers |
| customers__analytics_data | OBJECT | customers.analytics_data | customers.analytics_data | customers |
| customers__apply_credit_to_next_checkout_charge | BOOLEAN | customers.apply_credit_to_next_checkout_charge | customers.apply_credit_to_next_checkout_charge | customers |
| customers__apply_credit_to_next_recurring_charge | BOOLEAN | customers.apply_credit_to_next_recurring_charge | customers.apply_credit_to_next_recurring_charge | customers |
| customers__billing_address1 | TEXT | customers.billing_address1 | customers.billing_address1 | customers |
| customers__billing_address2 | TEXT | customers.billing_address2 | customers.billing_address2 | customers |
| customers__billing_city | TEXT | customers.billing_city | customers.billing_city | customers |
| customers__billing_company | TEXT | customers.billing_company | customers.billing_company | customers |
| customers__billing_country | TEXT | customers.billing_country | customers.billing_country | customers |
| customers__billing_first_name | TEXT | customers.billing_first_name | customers.billing_first_name | customers |
| customers__billing_last_name | TEXT | customers.billing_last_name | customers.billing_last_name | customers |
| customers__billing_phone | TEXT | customers.billing_phone | customers.billing_phone | customers |
| customers__billing_province | TEXT | customers.billing_province | customers.billing_province | customers |
| customers__billing_zip | TEXT | customers.billing_zip | customers.billing_zip | customers |
| customers__created_at | DATE | customers.created_at | customers.created_at | customers |
| customers__email | TEXT | customers.email | customers.email | customers |
| customers__external_customer_id | OBJECT | customers.external_customer_id | customers.external_customer_id | customers |
| customers__first_charge_processed_at | DATE | customers.first_charge_processed_at | customers.first_charge_processed_at | customers |
| customers__first_name | TEXT | customers.first_name | customers.first_name | customers |
| customers__has_card_error_in_dunning | BOOLEAN | customers.has_card_error_in_dunning | customers.has_card_error_in_dunning | customers |
| customers__has_payment_method_in_dunning | BOOLEAN | customers.has_payment_method_in_dunning | customers.has_payment_method_in_dunning | customers |
| customers__has_valid_payment_method | BOOLEAN | customers.has_valid_payment_method | customers.has_valid_payment_method | customers |
| customers__hash | TEXT | customers.hash | customers.hash | customers |
| customers__id | NUMERIC | customers.id | customers.id | customers |
| customers__last_name | TEXT | customers.last_name | customers.last_name | customers |
| customers__number_active_subscriptions | NUMERIC | customers.number_active_subscriptions | customers.number_active_subscriptions | customers |
| customers__number_subscriptions | NUMERIC | customers.number_subscriptions | customers.number_subscriptions | customers |
| customers__phone | TEXT | customers.phone | customers.phone | customers |
| customers__processor_type | TEXT | customers.processor_type | customers.processor_type | customers |
| customers__reason_payment_method_not_valid | TEXT | customers.reason_payment_method_not_valid | customers.reason_payment_method_not_valid | customers |
| customers__shopify_customer_id | TEXT | customers.shopify_customer_id | customers.shopify_customer_id | customers |
| customers__status | TEXT | customers.status | customers.status | customers |
| customers__stripe_customer_token | TEXT | customers.stripe_customer_token | customers.stripe_customer_token | customers |
| customers__subscriptions_active_count | NUMERIC | customers.subscriptions_active_count | customers.subscriptions_active_count | customers |
| customers__subscriptions_total_count | NUMERIC | customers.subscriptions_total_count | customers.subscriptions_total_count | customers |
| customers__tax_exempt | BOOLEAN | customers.tax_exempt | customers.tax_exempt | customers |
| customers__updated_at | DATE | customers.updated_at | customers.updated_at | customers |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| discounts__applies_to | TEXT | discounts.applies_to | discounts.applies_to | discounts |
| discounts__applies_to_id | NUMERIC | discounts.applies_to_id | discounts.applies_to_id | discounts |
| discounts__applies_to_product_type | TEXT | discounts.applies_to_product_type | discounts.applies_to_product_type | discounts |
| discounts__applies_to_resource | TEXT | discounts.applies_to_resource | discounts.applies_to_resource | discounts |
| discounts__channel_settings | OBJECT | discounts.channel_settings | discounts.channel_settings | discounts |
| discounts__code | TEXT | discounts.code | discounts.code | discounts |
| discounts__created_at | DATE | discounts.created_at | discounts.created_at | discounts |
| discounts__discount_type | TEXT | discounts.discount_type | discounts.discount_type | discounts |
| discounts__duration | TEXT | discounts.duration | discounts.duration | discounts |
| discounts__duration_usage_limit | NUMERIC | discounts.duration_usage_limit | discounts.duration_usage_limit | discounts |
| discounts__ends_at | DATE | discounts.ends_at | discounts.ends_at | discounts |
| discounts__external_discount_id | TEXT | discounts.external_discount_id | discounts.external_discount_id | discounts |
| discounts__external_discount_source | TEXT | discounts.external_discount_source | discounts.external_discount_source | discounts |
| discounts__first_time_customer_restriction | TEXT | discounts.first_time_customer_restriction | discounts.first_time_customer_restriction | discounts |
| discounts__id | NUMERIC | discounts.id | discounts.id | discounts |
| discounts__once_per_customer | BOOLEAN | discounts.once_per_customer | discounts.once_per_customer | discounts |
| discounts__prerequisite_subtotal_min | NUMERIC | discounts.prerequisite_subtotal_min | discounts.prerequisite_subtotal_min | discounts |
| discounts__starts_at | DATE | discounts.starts_at | discounts.starts_at | discounts |
| discounts__status | TEXT | discounts.status | discounts.status | discounts |
| discounts__times_used | NUMERIC | discounts.times_used | discounts.times_used | discounts |
| discounts__updated_at | DATE | discounts.updated_at | discounts.updated_at | discounts |
| discounts__usage_limit | NUMERIC | discounts.usage_limit | discounts.usage_limit | discounts |
| discounts__value | NUMERIC | discounts.value | discounts.value | discounts |
| metafields__created_at | DATE | metafields.created_at | metafields.created_at | metafields |
| metafields__description | TEXT | metafields.description | metafields.description | metafields |
| metafields__id | NUMERIC | metafields.id | metafields.id | metafields |
| metafields__key | TEXT | metafields.key | metafields.key | metafields |
| metafields__namespace | TEXT | metafields.namespace | metafields.namespace | metafields |
| metafields__owner_id | TEXT | metafields.owner_id | metafields.owner_id | metafields |
| metafields__owner_resource | TEXT | metafields.owner_resource | metafields.owner_resource | metafields |
| metafields__updated_at | DATE | metafields.updated_at | metafields.updated_at | metafields |
| metafields__value | TEXT | metafields.value | metafields.value | metafields |
| metafields__value_type | TEXT | metafields.value_type | metafields.value_type | metafields |
| onetimes__address_id | TEXT | onetimes.address_id | onetimes.address_id | onetimes |
| onetimes__created_at | DATE | onetimes.created_at | onetimes.created_at | onetimes |
| onetimes__customer_id | TEXT | onetimes.customer_id | onetimes.customer_id | onetimes |
| onetimes__id | NUMERIC | onetimes.id | onetimes.id | onetimes |
| onetimes__next_charge_scheduled_at | DATE | onetimes.next_charge_scheduled_at | onetimes.next_charge_scheduled_at | onetimes |
| onetimes__price | TEXT | onetimes.price | onetimes.price | onetimes |
| onetimes__product_title | TEXT | onetimes.product_title | onetimes.product_title | onetimes |
| onetimes__properties | OBJECT | onetimes.properties | onetimes.properties | onetimes |
| onetimes__quantity | NUMERIC | onetimes.quantity | onetimes.quantity | onetimes |
| onetimes__recharge_product_id | NUMERIC | onetimes.recharge_product_id | onetimes.recharge_product_id | onetimes |
| onetimes__shopify_product_id | NUMERIC | onetimes.shopify_product_id | onetimes.shopify_product_id | onetimes |
| onetimes__shopify_variant_id | NUMERIC | onetimes.shopify_variant_id | onetimes.shopify_variant_id | onetimes |
| onetimes__sku | TEXT | onetimes.sku | onetimes.sku | onetimes |
| onetimes__status | TEXT | onetimes.status | onetimes.status | onetimes |
| onetimes__updated_at | DATE | onetimes.updated_at | onetimes.updated_at | onetimes |
| onetimes__variant_title | TEXT | onetimes.variant_title | onetimes.variant_title | onetimes |
| orders__accepts_marketing | BOOLEAN | orders.accepts_marketing | orders.accepts_marketing | orders |
| orders__address_id | NUMERIC | orders.address_id | orders.address_id | orders |
| orders__address_is_active | NUMERIC | orders.address_is_active | orders.address_is_active | orders |
| orders__billing_address | OBJECT | orders.billing_address | orders.billing_address | orders |
| orders__browser_ip | TEXT | orders.browser_ip | orders.browser_ip | orders |
| orders__charge | OBJECT | orders.charge | orders.charge | orders |
| orders__charge_id | NUMERIC | orders.charge_id | orders.charge_id | orders |
| orders__charge_status | TEXT | orders.charge_status | orders.charge_status | orders |
| orders__client_details | OBJECT | orders.client_details | orders.client_details | orders |
| orders__created_at | DATE | orders.created_at | orders.created_at | orders |
| orders__currency | TEXT | orders.currency | orders.currency | orders |
| orders__customer | OBJECT | orders.customer | orders.customer | orders |
| orders__customer_id | NUMERIC | orders.customer_id | orders.customer_id | orders |
| orders__discount_codes | OBJECT | orders.discount_codes | orders.discount_codes | orders |
| orders__discounts | OBJECT | orders.discounts | orders.discounts | orders |
| orders__email | TEXT | orders.email | orders.email | orders |
| orders__error | TEXT | orders.error | orders.error | orders |
| orders__external_cart_token | TEXT | orders.external_cart_token | orders.external_cart_token | orders |
| orders__external_order_id | OBJECT | orders.external_order_id | orders.external_order_id | orders |
| orders__external_order_name | OBJECT | orders.external_order_name | orders.external_order_name | orders |
| orders__external_order_number | OBJECT | orders.external_order_number | orders.external_order_number | orders |
| orders__first_name | TEXT | orders.first_name | orders.first_name | orders |
| orders__hash | TEXT | orders.hash | orders.hash | orders |
| orders__id | NUMERIC | orders.id | orders.id | orders |
| orders__is_prepaid | NUMERIC | orders.is_prepaid | orders.is_prepaid | orders |
| orders__last_name | TEXT | orders.last_name | orders.last_name | orders |
| orders__line_items | OBJECT | orders.line_items | orders.line_items | orders |
| orders__note | TEXT | orders.note | orders.note | orders |
| orders__note_attributes | OBJECT | orders.note_attributes | orders.note_attributes | orders |
| orders__order_attributes | OBJECT | orders.order_attributes | orders.order_attributes | orders |
| orders__payment_processor | TEXT | orders.payment_processor | orders.payment_processor | orders |
| orders__phone | TEXT | orders.phone | orders.phone | orders |
| orders__processed_at | DATE | orders.processed_at | orders.processed_at | orders |
| orders__redacted | BOOLEAN | orders.redacted | orders.redacted | orders |
| orders__scheduled_at | DATE | orders.scheduled_at | orders.scheduled_at | orders |
| orders__send_email_welcome | BOOLEAN | orders.send_email_welcome | orders.send_email_welcome | orders |
| orders__shipped_date | TEXT | orders.shipped_date | orders.shipped_date | orders |
| orders__shipping_address | OBJECT | orders.shipping_address | orders.shipping_address | orders |
| orders__shipping_date | TEXT | orders.shipping_date | orders.shipping_date | orders |
| orders__shipping_lines | OBJECT | orders.shipping_lines | orders.shipping_lines | orders |
| orders__shopify_cart_token | TEXT | orders.shopify_cart_token | orders.shopify_cart_token | orders |
| orders__shopify_customer_id | TEXT | orders.shopify_customer_id | orders.shopify_customer_id | orders |
| orders__shopify_id | TEXT | orders.shopify_id | orders.shopify_id | orders |
| orders__shopify_order_id | TEXT | orders.shopify_order_id | orders.shopify_order_id | orders |
| orders__shopify_order_number | NUMERIC | orders.shopify_order_number | orders.shopify_order_number | orders |
| orders__status | TEXT | orders.status | orders.status | orders |
| orders__subtotal_price | NUMERIC | orders.subtotal_price | orders.subtotal_price | orders |
| orders__tags | TEXT | orders.tags | orders.tags | orders |
| orders__tax_lines | OBJECT | orders.tax_lines | orders.tax_lines | orders |
| orders__taxable | BOOLEAN | orders.taxable | orders.taxable | orders |
| orders__total_discounts | NUMERIC | orders.total_discounts | orders.total_discounts | orders |
| orders__total_duties | TEXT | orders.total_duties | orders.total_duties | orders |
| orders__total_line_items_price | NUMERIC | orders.total_line_items_price | orders.total_line_items_price | orders |
| orders__total_price | NUMERIC | orders.total_price | orders.total_price | orders |
| orders__total_refunds | TEXT | orders.total_refunds | orders.total_refunds | orders |
| orders__total_tax | TEXT | orders.total_tax | orders.total_tax | orders |
| orders__total_weight | NUMERIC | orders.total_weight | orders.total_weight | orders |
| orders__total_weight_grams | NUMERIC | orders.total_weight_grams | orders.total_weight_grams | orders |
| orders__transaction_id | TEXT | orders.transaction_id | orders.transaction_id | orders |
| orders__type | TEXT | orders.type | orders.type | orders |
| orders__updated_at | DATE | orders.updated_at | orders.updated_at | orders |
| orders__verified_email | BOOLEAN | orders.verified_email | orders.verified_email | orders |
| products__charge_interval_frequency | NUMERIC | products.charge_interval_frequency | products.charge_interval_frequency | products |
| products__collection_id | NUMERIC | products.collection_id | products.collection_id | products |
| products__created_at | DATE | products.created_at | products.created_at | products |
| products__cutoff_day_of_month | NUMERIC | products.cutoff_day_of_month | products.cutoff_day_of_month | products |
| products__cutoff_day_of_week | NUMERIC | products.cutoff_day_of_week | products.cutoff_day_of_week | products |
| products__discount_amount | NUMERIC | products.discount_amount | products.discount_amount | products |
| products__discount_type | TEXT | products.discount_type | products.discount_type | products |
| products__expire_after_specific_number_of_charges | NUMERIC | products.expire_after_specific_number_of_charges | products.expire_after_specific_number_of_charges | products |
| products__handle | TEXT | products.handle | products.handle | products |
| products__id | NUMERIC | products.id | products.id | products |
| products__images | OBJECT | products.images | products.images | products |
| products__modifiable_properties | OBJECT | products.modifiable_properties | products.modifiable_properties | products |
| products__order_day_of_month | NUMERIC | products.order_day_of_month | products.order_day_of_month | products |
| products__order_day_of_week | NUMERIC | products.order_day_of_week | products.order_day_of_week | products |
| products__order_interval_frequency_options | OBJECT | products.order_interval_frequency_options | products.order_interval_frequency_options | products |
| products__order_interval_unit | TEXT | products.order_interval_unit | products.order_interval_unit | products |
| products__product_id | NUMERIC | products.product_id | products.product_id | products |
| products__shopify_product_id | NUMERIC | products.shopify_product_id | products.shopify_product_id | products |
| products__storefront_purchase_options | TEXT | products.storefront_purchase_options | products.storefront_purchase_options | products |
| products__subscription_defaults | OBJECT | products.subscription_defaults | products.subscription_defaults | products |
| products__title | TEXT | products.title | products.title | products |
| products__updated_at | DATE | products.updated_at | products.updated_at | products |
| shop__shop | OBJECT | shop.shop | shop.shop | shop |
| shop__store | OBJECT | shop.store | shop.store | shop |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| subscriptions__address_id | NUMERIC | subscriptions.address_id | subscriptions.address_id | subscriptions |
| subscriptions__analytics_data | OBJECT | subscriptions.analytics_data | subscriptions.analytics_data | subscriptions |
| subscriptions__cancellation_reason | TEXT | subscriptions.cancellation_reason | subscriptions.cancellation_reason | subscriptions |
| subscriptions__cancellation_reason_comments | TEXT | subscriptions.cancellation_reason_comments | subscriptions.cancellation_reason_comments | subscriptions |
| subscriptions__cancelled_at | DATE | subscriptions.cancelled_at | subscriptions.cancelled_at | subscriptions |
| subscriptions__charge_interval_frequency | TEXT | subscriptions.charge_interval_frequency | subscriptions.charge_interval_frequency | subscriptions |
| subscriptions__commit_update | BOOLEAN | subscriptions.commit_update | subscriptions.commit_update | subscriptions |
| subscriptions__created_at | DATE | subscriptions.created_at | subscriptions.created_at | subscriptions |
| subscriptions__customer_id | NUMERIC | subscriptions.customer_id | subscriptions.customer_id | subscriptions |
| subscriptions__email | TEXT | subscriptions.email | subscriptions.email | subscriptions |
| subscriptions__expire_after_specific_number_of_charges | NUMERIC | subscriptions.expire_after_specific_number_of_charges | subscriptions.expire_after_specific_number_of_charges | subscriptions |
| subscriptions__external_product_id | OBJECT | subscriptions.external_product_id | subscriptions.external_product_id | subscriptions |
| subscriptions__external_variant_id | OBJECT | subscriptions.external_variant_id | subscriptions.external_variant_id | subscriptions |
| subscriptions__has_queued_charges | NUMERIC | subscriptions.has_queued_charges | subscriptions.has_queued_charges | subscriptions |
| subscriptions__id | NUMERIC | subscriptions.id | subscriptions.id | subscriptions |
| subscriptions__is_prepaid | BOOLEAN | subscriptions.is_prepaid | subscriptions.is_prepaid | subscriptions |
| subscriptions__is_skippable | BOOLEAN | subscriptions.is_skippable | subscriptions.is_skippable | subscriptions |
| subscriptions__is_swappable | BOOLEAN | subscriptions.is_swappable | subscriptions.is_swappable | subscriptions |
| subscriptions__max_retries_reached | NUMERIC | subscriptions.max_retries_reached | subscriptions.max_retries_reached | subscriptions |
| subscriptions__next_charge_scheduled_at | DATE | subscriptions.next_charge_scheduled_at | subscriptions.next_charge_scheduled_at | subscriptions |
| subscriptions__order_day_of_month | NUMERIC | subscriptions.order_day_of_month | subscriptions.order_day_of_month | subscriptions |
| subscriptions__order_day_of_week | NUMERIC | subscriptions.order_day_of_week | subscriptions.order_day_of_week | subscriptions |
| subscriptions__order_interval_frequency | TEXT | subscriptions.order_interval_frequency | subscriptions.order_interval_frequency | subscriptions |
| subscriptions__order_interval_unit | TEXT | subscriptions.order_interval_unit | subscriptions.order_interval_unit | subscriptions |
| subscriptions__presentment_currency | TEXT | subscriptions.presentment_currency | subscriptions.presentment_currency | subscriptions |
| subscriptions__price | NUMERIC | subscriptions.price | subscriptions.price | subscriptions |
| subscriptions__product_title | TEXT | subscriptions.product_title | subscriptions.product_title | subscriptions |
| subscriptions__properties | OBJECT | subscriptions.properties | subscriptions.properties | subscriptions |
| subscriptions__quantity | NUMERIC | subscriptions.quantity | subscriptions.quantity | subscriptions |
| subscriptions__recharge_product_id | NUMERIC | subscriptions.recharge_product_id | subscriptions.recharge_product_id | subscriptions |
| subscriptions__shopify_product_id | NUMERIC | subscriptions.shopify_product_id | subscriptions.shopify_product_id | subscriptions |
| subscriptions__shopify_variant_id | NUMERIC | subscriptions.shopify_variant_id | subscriptions.shopify_variant_id | subscriptions |
| subscriptions__sku | TEXT | subscriptions.sku | subscriptions.sku | subscriptions |
| subscriptions__sku_override | BOOLEAN | subscriptions.sku_override | subscriptions.sku_override | subscriptions |
| subscriptions__status | TEXT | subscriptions.status | subscriptions.status | subscriptions |
| subscriptions__updated_at | DATE | subscriptions.updated_at | subscriptions.updated_at | subscriptions |
| subscriptions__variant_title | TEXT | subscriptions.variant_title | subscriptions.variant_title | subscriptions |
| today | DATE | Today | Today's date |