Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Chargebee data to
Chargebee Connector Reference
223 metrics581 dimensions
The Chargebee connector exposes 804 fields (223 metrics, 581 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Chargebee Fields
Chargebee addon fields
The addon report of the Chargebee connector includes 43 fields.
Chargebee addon fields (addon__accounting_category1 to addon__tiers)
| ID | Type | Name | Description |
|---|---|---|---|
| addon__accounting_category1 | TEXT | addon.accounting_category1 | addon.accounting_category1 |
| addon__accounting_category2 | TEXT | addon.accounting_category2 | addon.accounting_category2 |
| addon__accounting_category3 | TEXT | addon.accounting_category3 | addon.accounting_category3 |
| addon__accounting_category4 | TEXT | addon.accounting_category4 | addon.accounting_category4 |
| addon__accounting_code | TEXT | addon.accounting_code | addon.accounting_code |
| addon__archived_at | NUMERIC | addon.archived_at | addon.archived_at |
| addon__avalara_sale_type | TEXT | addon.avalara_sale_type | addon.avalara_sale_type |
| addon__avalara_service_type | NUMERIC | addon.avalara_service_type | addon.avalara_service_type |
| addon__avalara_transaction_type | NUMERIC | addon.avalara_transaction_type | addon.avalara_transaction_type |
| addon__channel | TEXT | addon.channel | addon.channel |
| addon__charge_type | TEXT | addon.charge_type | addon.charge_type |
| addon__currency_code | TEXT | addon.currency_code | addon.currency_code |
| addon__custom_fields | OBJECT | addon.custom_fields | addon.custom_fields |
| addon__description | TEXT | addon.description | addon.description |
| addon__enabled_in_portal | BOOLEAN | addon.enabled_in_portal | addon.enabled_in_portal |
| addon__id | TEXT | addon.id | addon.id |
| addon__included_in_mrr | BOOLEAN | addon.included_in_mrr | addon.included_in_mrr |
| addon__invoice_name | TEXT | addon.invoice_name | addon.invoice_name |
| addon__invoice_notes | TEXT | addon.invoice_notes | addon.invoice_notes |
| addon__is_shippable | BOOLEAN | addon.is_shippable | addon.is_shippable |
| addon__meta_data | OBJECT | addon.meta_data | addon.meta_data |
| addon__name | TEXT | addon.name | addon.name |
| addon__object | TEXT | addon.object | addon.object |
| addon__period | NUMERIC | addon.period | addon.period |
| addon__period_unit | TEXT | addon.period_unit | addon.period_unit |
| addon__price | NUMERIC | addon.price | addon.price |
| addon__price_in_decimal | TEXT | addon.price_in_decimal | addon.price_in_decimal |
| addon__pricing_model | TEXT | addon.pricing_model | addon.pricing_model |
| addon__resource_version | NUMERIC | addon.resource_version | addon.resource_version |
| addon__shipping_frequency_period | NUMERIC | addon.shipping_frequency_period | addon.shipping_frequency_period |
| addon__shipping_frequency_period_unit | TEXT | addon.shipping_frequency_period_unit | addon.shipping_frequency_period_unit |
| addon__show_description_in_invoices | BOOLEAN | addon.show_description_in_invoices | addon.show_description_in_invoices |
| addon__show_description_in_quotes | BOOLEAN | addon.show_description_in_quotes | addon.show_description_in_quotes |
| addon__sku | TEXT | addon.sku | addon.sku |
| addon__status | TEXT | addon.status | addon.status |
| addon__tax_code | TEXT | addon.tax_code | addon.tax_code |
| addon__tax_profile_id | TEXT | addon.tax_profile_id | addon.tax_profile_id |
| addon__taxable | BOOLEAN | addon.taxable | addon.taxable |
| addon__taxjar_product_code | TEXT | addon.taxjar_product_code | addon.taxjar_product_code |
| addon__tiers | OBJECT | addon.tiers | addon.tiers |
Chargebee addon fields (addon__type to addon__updated_at)
| ID | Type | Name | Description |
|---|---|---|---|
| addon__type | TEXT | addon.type | addon.type |
| addon__unit | TEXT | addon.unit | addon.unit |
| addon__updated_at | NUMERIC | addon.updated_at | addon.updated_at |
Chargebee attached_item fields
The attached_item report of the Chargebee connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| attached_item__billing_cycles | NUMERIC | attached_item.billing_cycles | attached_item.billing_cycles |
| attached_item__charge_on_event | TEXT | attached_item.charge_on_event | attached_item.charge_on_event |
| attached_item__charge_once | BOOLEAN | attached_item.charge_once | attached_item.charge_once |
| attached_item__created_at | NUMERIC | attached_item.created_at | attached_item.created_at |
| attached_item__custom_fields | OBJECT | attached_item.custom_fields | attached_item.custom_fields |
| attached_item__id | TEXT | attached_item.id | attached_item.id |
| attached_item__item_id | TEXT | attached_item.item_id | attached_item.item_id |
| attached_item__object | TEXT | attached_item.object | attached_item.object |
| attached_item__parent_item_id | TEXT | attached_item.parent_item_id | attached_item.parent_item_id |
| attached_item__quantity | NUMERIC | attached_item.quantity | attached_item.quantity |
| attached_item__quantity_in_decimal | TEXT | attached_item.quantity_in_decimal | attached_item.quantity_in_decimal |
| attached_item__resource_version | NUMERIC | attached_item.resource_version | attached_item.resource_version |
| attached_item__status | TEXT | attached_item.status | attached_item.status |
| attached_item__type | TEXT | attached_item.type | attached_item.type |
| attached_item__updated_at | NUMERIC | attached_item.updated_at | attached_item.updated_at |
Chargebee comment fields
The comment report of the Chargebee connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| comment__added_by | TEXT | comment.added_by | comment.added_by |
| comment__created_at | NUMERIC | comment.created_at | comment.created_at |
| comment__custom_fields | OBJECT | comment.custom_fields | comment.custom_fields |
| comment__entity_id | TEXT | comment.entity_id | comment.entity_id |
| comment__entity_type | TEXT | comment.entity_type | comment.entity_type |
| comment__id | TEXT | comment.id | comment.id |
| comment__notes | TEXT | comment.notes | comment.notes |
| comment__object | TEXT | comment.object | comment.object |
| comment__type | TEXT | comment.type | comment.type |
Chargebee contact fields
The contact report of the Chargebee connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| contact__custom_fields | OBJECT | contact.custom_fields | contact.custom_fields |
| contact__customer_id | TEXT | contact.customer_id | contact.customer_id |
| contact__email | TEXT | contact.email | contact.email |
| contact__enabled | BOOLEAN | contact.enabled | contact.enabled |
| contact__first_name | TEXT | contact.first_name | contact.first_name |
| contact__id | TEXT | contact.id | contact.id |
| contact__label | TEXT | contact.label | contact.label |
| contact__last_name | TEXT | contact.last_name | contact.last_name |
| contact__object | TEXT | contact.object | contact.object |
| contact__phone | TEXT | contact.phone | contact.phone |
| contact__send_account_email | BOOLEAN | contact.send_account_email | contact.send_account_email |
| contact__send_billing_email | BOOLEAN | contact.send_billing_email | contact.send_billing_email |
Chargebee coupon fields
The coupon report of the Chargebee connector includes 27 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| coupon__apply_discount_on | TEXT | coupon.apply_discount_on | coupon.apply_discount_on |
| coupon__apply_on | TEXT | coupon.apply_on | coupon.apply_on |
| coupon__archived_at | NUMERIC | coupon.archived_at | coupon.archived_at |
| coupon__coupon_constraints | OBJECT | coupon.coupon_constraints | coupon.coupon_constraints |
| coupon__created_at | NUMERIC | coupon.created_at | coupon.created_at |
| coupon__currency_code | TEXT | coupon.currency_code | coupon.currency_code |
| coupon__custom_fields | OBJECT | coupon.custom_fields | coupon.custom_fields |
| coupon__discount_amount | NUMERIC | coupon.discount_amount | coupon.discount_amount |
| coupon__discount_percentage | NUMERIC | coupon.discount_percentage | coupon.discount_percentage |
| coupon__discount_type | TEXT | coupon.discount_type | coupon.discount_type |
| coupon__duration_month | NUMERIC | coupon.duration_month | coupon.duration_month |
| coupon__duration_type | TEXT | coupon.duration_type | coupon.duration_type |
| coupon__id | TEXT | coupon.id | coupon.id |
| coupon__invoice_name | TEXT | coupon.invoice_name | coupon.invoice_name |
| coupon__invoice_notes | TEXT | coupon.invoice_notes | coupon.invoice_notes |
| coupon__item_constraint_criteria | OBJECT | coupon.item_constraint_criteria | coupon.item_constraint_criteria |
| coupon__item_constraints | OBJECT | coupon.item_constraints | coupon.item_constraints |
| coupon__max_redemptions | NUMERIC | coupon.max_redemptions | coupon.max_redemptions |
| coupon__name | TEXT | coupon.name | coupon.name |
| coupon__object | TEXT | coupon.object | coupon.object |
| coupon__period | NUMERIC | coupon.period | coupon.period |
| coupon__period_unit | TEXT | coupon.period_unit | coupon.period_unit |
| coupon__redemptions | NUMERIC | coupon.redemptions | coupon.redemptions |
| coupon__resource_version | NUMERIC | coupon.resource_version | coupon.resource_version |
| coupon__status | TEXT | coupon.status | coupon.status |
| coupon__updated_at | NUMERIC | coupon.updated_at | coupon.updated_at |
| coupon__valid_till | NUMERIC | coupon.valid_till | coupon.valid_till |
Chargebee credit_note fields
The credit_note report of the Chargebee connector includes 49 fields.
Chargebee credit_note fields (credit_note__allocations to credit_note__sub_total_in_local_currency)
| ID | Type | Name | Description |
|---|---|---|---|
| credit_note__allocations | OBJECT | credit_note.allocations | credit_note.allocations |
| credit_note__amount_allocated | NUMERIC | credit_note.amount_allocated | credit_note.amount_allocated |
| credit_note__amount_available | NUMERIC | credit_note.amount_available | credit_note.amount_available |
| credit_note__amount_refunded | NUMERIC | credit_note.amount_refunded | credit_note.amount_refunded |
| credit_note__base_currency_code | TEXT | credit_note.base_currency_code | credit_note.base_currency_code |
| credit_note__billing_address | OBJECT | credit_note.billing_address | credit_note.billing_address |
| credit_note__business_entity_id | TEXT | credit_note.business_entity_id | credit_note.business_entity_id |
| credit_note__channel | TEXT | credit_note.channel | credit_note.channel |
| credit_note__create_reason_code | TEXT | credit_note.create_reason_code | credit_note.create_reason_code |
| credit_note__currency_code | TEXT | credit_note.currency_code | credit_note.currency_code |
| credit_note__custom_fields | OBJECT | credit_note.custom_fields | credit_note.custom_fields |
| credit_note__customer_id | TEXT | credit_note.customer_id | credit_note.customer_id |
| credit_note__customer_notes | TEXT | credit_note.customer_notes | credit_note.customer_notes |
| credit_note__date | NUMERIC | credit_note.date | credit_note.date |
| credit_note__deleted | BOOLEAN | credit_note.deleted | credit_note.deleted |
| credit_note__discounts | OBJECT | credit_note.discounts | credit_note.discounts |
| credit_note__exchange_rate | NUMERIC | credit_note.exchange_rate | credit_note.exchange_rate |
| credit_note__fractional_correction | NUMERIC | credit_note.fractional_correction | credit_note.fractional_correction |
| credit_note__generated_at | NUMERIC | credit_note.generated_at | credit_note.generated_at |
| credit_note__id | TEXT | credit_note.id | credit_note.id |
| credit_note__is_digital | BOOLEAN | credit_note.is_digital | credit_note.is_digital |
| credit_note__is_vat_moss_registered | BOOLEAN | credit_note.is_vat_moss_registered | credit_note.is_vat_moss_registered |
| credit_note__line_item_discounts | OBJECT | credit_note.line_item_discounts | credit_note.line_item_discounts |
| credit_note__line_item_taxes | OBJECT | credit_note.line_item_taxes | credit_note.line_item_taxes |
| credit_note__line_item_tiers | OBJECT | credit_note.line_item_tiers | credit_note.line_item_tiers |
| credit_note__line_items | OBJECT | credit_note.line_items | credit_note.line_items |
| credit_note__linked_refunds | OBJECT | credit_note.linked_refunds | credit_note.linked_refunds |
| credit_note__linked_tax_withheld_refunds | OBJECT | credit_note.linked_tax_withheld_refunds | credit_note.linked_tax_withheld_refunds |
| credit_note__local_currency_code | TEXT | credit_note.local_currency_code | credit_note.local_currency_code |
| credit_note__object | TEXT | credit_note.object | credit_note.object |
| credit_note__price_type | TEXT | credit_note.price_type | credit_note.price_type |
| credit_note__reason_code | TEXT | credit_note.reason_code | credit_note.reason_code |
| credit_note__reference_invoice_id | TEXT | credit_note.reference_invoice_id | credit_note.reference_invoice_id |
| credit_note__refunded_at | NUMERIC | credit_note.refunded_at | credit_note.refunded_at |
| credit_note__resource_version | NUMERIC | credit_note.resource_version | credit_note.resource_version |
| credit_note__round_off_amount | NUMERIC | credit_note.round_off_amount | credit_note.round_off_amount |
| credit_note__shipping_address | OBJECT | credit_note.shipping_address | credit_note.shipping_address |
| credit_note__status | TEXT | credit_note.status | credit_note.status |
| credit_note__sub_total | NUMERIC | credit_note.sub_total | credit_note.sub_total |
| credit_note__sub_total_in_local_currency | NUMERIC | credit_note.sub_total_in_local_currency | credit_note.sub_total_in_local_currency |
Chargebee credit_note fields (credit_note__subscription_id to credit_note__voided_at)
| ID | Type | Name | Description |
|---|---|---|---|
| credit_note__subscription_id | TEXT | credit_note.subscription_id | credit_note.subscription_id |
| credit_note__taxes | OBJECT | credit_note.taxes | credit_note.taxes |
| credit_note__total | NUMERIC | credit_note.total | credit_note.total |
| credit_note__total_in_local_currency | NUMERIC | credit_note.total_in_local_currency | credit_note.total_in_local_currency |
| credit_note__type | TEXT | credit_note.type | credit_note.type |
| credit_note__updated_at | NUMERIC | credit_note.updated_at | credit_note.updated_at |
| credit_note__vat_number | TEXT | credit_note.vat_number | credit_note.vat_number |
| credit_note__vat_number_prefix | TEXT | credit_note.vat_number_prefix | credit_note.vat_number_prefix |
| credit_note__voided_at | NUMERIC | credit_note.voided_at | credit_note.voided_at |
Chargebee customer fields
The customer report of the Chargebee connector includes 63 fields.
Chargebee customer fields (customer__allow_direct_debit to customer__net_term_days)
| ID | Type | Name | Description |
|---|---|---|---|
| customer__allow_direct_debit | BOOLEAN | customer.allow_direct_debit | customer.allow_direct_debit |
| customer__auto_close_invoices | BOOLEAN | customer.auto_close_invoices | customer.auto_close_invoices |
| customer__auto_collection | TEXT | customer.auto_collection | customer.auto_collection |
| customer__backup_payment_source_id | TEXT | customer.backup_payment_source_id | customer.backup_payment_source_id |
| customer__balances | OBJECT | customer.balances | customer.balances |
| customer__billing_address | OBJECT | customer.billing_address | customer.billing_address |
| customer__billing_date | NUMERIC | customer.billing_date | customer.billing_date |
| customer__billing_date_mode | TEXT | customer.billing_date_mode | customer.billing_date_mode |
| customer__billing_day_of_week | TEXT | customer.billing_day_of_week | customer.billing_day_of_week |
| customer__billing_day_of_week_mode | TEXT | customer.billing_day_of_week_mode | customer.billing_day_of_week_mode |
| customer__billing_month | NUMERIC | customer.billing_month | customer.billing_month |
| customer__business_customer_without_vat_number | BOOLEAN | customer.business_customer_without_vat_number | customer.business_customer_without_vat_number |
| customer__business_entity_id | TEXT | customer.business_entity_id | customer.business_entity_id |
| customer__card_status | TEXT | customer.card_status | customer.card_status |
| customer__channel | TEXT | customer.channel | customer.channel |
| customer__child_account_access | OBJECT | customer.child_account_access | customer.child_account_access |
| customer__client_profile_id | TEXT | customer.client_profile_id | customer.client_profile_id |
| customer__company | TEXT | customer.company | customer.company |
| customer__consolidated_invoicing | BOOLEAN | customer.consolidated_invoicing | customer.consolidated_invoicing |
| customer__contacts | OBJECT | customer.contacts | customer.contacts |
| customer__created_at | NUMERIC | customer.created_at | customer.created_at |
| customer__created_from_ip | TEXT | customer.created_from_ip | customer.created_from_ip |
| customer__custom_fields | OBJECT | customer.custom_fields | customer.custom_fields |
| customer__customer_type | TEXT | customer.customer_type | customer.customer_type |
| customer__deleted | BOOLEAN | customer.deleted | customer.deleted |
| customer__email | TEXT | customer.email | customer.email |
| customer__entity_code | TEXT | customer.entity_code | customer.entity_code |
| customer__excess_payments | NUMERIC | customer.excess_payments | customer.excess_payments |
| customer__exempt_number | TEXT | customer.exempt_number | customer.exempt_number |
| customer__exemption_details | OBJECT | customer.exemption_details | customer.exemption_details |
| customer__first_name | TEXT | customer.first_name | customer.first_name |
| customer__fraud_flag | TEXT | customer.fraud_flag | customer.fraud_flag |
| customer__id | TEXT | customer.id | customer.id |
| customer__invoice_notes | TEXT | customer.invoice_notes | customer.invoice_notes |
| customer__is_location_valid | BOOLEAN | customer.is_location_valid | customer.is_location_valid |
| customer__last_name | TEXT | customer.last_name | customer.last_name |
| customer__locale | TEXT | customer.locale | customer.locale |
| customer__meta_data | OBJECT | customer.meta_data | customer.meta_data |
| customer__mrr | NUMERIC | customer.mrr | customer.mrr |
| customer__net_term_days | NUMERIC | customer.net_term_days | customer.net_term_days |
Chargebee customer fields (customer__object to customer__vat_number_validated_time)
| ID | Type | Name | Description |
|---|---|---|---|
| customer__object | TEXT | customer.object | customer.object |
| customer__offline_payment_method | TEXT | customer.offline_payment_method | customer.offline_payment_method |
| customer__parent_account_access | OBJECT | customer.parent_account_access | customer.parent_account_access |
| customer__payment_method | OBJECT | customer.payment_method | customer.payment_method |
| customer__phone | TEXT | customer.phone | customer.phone |
| customer__pii_cleared | TEXT | customer.pii_cleared | customer.pii_cleared |
| customer__preferred_currency_code | TEXT | customer.preferred_currency_code | customer.preferred_currency_code |
| customer__primary_payment_source_id | TEXT | customer.primary_payment_source_id | customer.primary_payment_source_id |
| customer__promotional_credits | NUMERIC | customer.promotional_credits | customer.promotional_credits |
| customer__referral_urls | OBJECT | customer.referral_urls | customer.referral_urls |
| customer__refundable_credits | NUMERIC | customer.refundable_credits | customer.refundable_credits |
| customer__registered_for_gst | BOOLEAN | customer.registered_for_gst | customer.registered_for_gst |
| customer__relationship | OBJECT | customer.relationship | customer.relationship |
| customer__resource_version | NUMERIC | customer.resource_version | customer.resource_version |
| customer__tax_providers_fields | OBJECT | customer.tax_providers_fields | customer.tax_providers_fields |
| customer__taxability | TEXT | customer.taxability | customer.taxability |
| customer__unbilled_charges | NUMERIC | customer.unbilled_charges | customer.unbilled_charges |
| customer__updated_at | NUMERIC | customer.updated_at | customer.updated_at |
| customer__use_default_hierarchy_settings | BOOLEAN | customer.use_default_hierarchy_settings | customer.use_default_hierarchy_settings |
| customer__vat_number | TEXT | customer.vat_number | customer.vat_number |
| customer__vat_number_prefix | TEXT | customer.vat_number_prefix | customer.vat_number_prefix |
| customer__vat_number_status | TEXT | customer.vat_number_status | customer.vat_number_status |
| customer__vat_number_validated_time | NUMERIC | customer.vat_number_validated_time | customer.vat_number_validated_time |
Chargebee differential_price fields
The differential_price report of the Chargebee connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| differential_price__created_at | NUMERIC | differential_price.created_at | differential_price.created_at |
| differential_price__currency_code | TEXT | differential_price.currency_code | differential_price.currency_code |
| differential_price__custom_fields | OBJECT | differential_price.custom_fields | differential_price.custom_fields |
| differential_price__id | TEXT | differential_price.id | differential_price.id |
| differential_price__item_price_id | TEXT | differential_price.item_price_id | differential_price.item_price_id |
| differential_price__modified_at | NUMERIC | differential_price.modified_at | differential_price.modified_at |
| differential_price__object | TEXT | differential_price.object | differential_price.object |
| differential_price__parent_item_id | TEXT | differential_price.parent_item_id | differential_price.parent_item_id |
| differential_price__parent_periods | OBJECT | differential_price.parent_periods | differential_price.parent_periods |
| differential_price__price | NUMERIC | differential_price.price | differential_price.price |
| differential_price__price_in_decimal | TEXT | differential_price.price_in_decimal | differential_price.price_in_decimal |
| differential_price__resource_version | NUMERIC | differential_price.resource_version | differential_price.resource_version |
| differential_price__status | TEXT | differential_price.status | differential_price.status |
| differential_price__tiers | OBJECT | differential_price.tiers | differential_price.tiers |
| differential_price__updated_at | NUMERIC | differential_price.updated_at | differential_price.updated_at |
Chargebee event fields
The event report of the Chargebee connector includes 11 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| event__api_version | TEXT | event.api_version | event.api_version |
| event__content | OBJECT | event.content | event.content |
| event__custom_fields | OBJECT | event.custom_fields | event.custom_fields |
| event__event_type | TEXT | event.event_type | event.event_type |
| event__id | TEXT | event.id | event.id |
| event__object | TEXT | event.object | event.object |
| event__occurred_at | NUMERIC | event.occurred_at | event.occurred_at |
| event__source | TEXT | event.source | event.source |
| event__user | TEXT | event.user | event.user |
| event__webhook_status | TEXT | event.webhook_status | event.webhook_status |
| event__webhooks | OBJECT | event.webhooks | event.webhooks |
Chargebee gift fields
The gift report of the Chargebee connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| gift__auto_claim | BOOLEAN | gift.auto_claim | gift.auto_claim |
| gift__claim_expiry_date | NUMERIC | gift.claim_expiry_date | gift.claim_expiry_date |
| gift__custom_fields | OBJECT | gift.custom_fields | gift.custom_fields |
| gift__gift_receiver | OBJECT | gift.gift_receiver | gift.gift_receiver |
| gift__gift_timelines | OBJECT | gift.gift_timelines | gift.gift_timelines |
| gift__gifter | OBJECT | gift.gifter | gift.gifter |
| gift__id | TEXT | gift.id | gift.id |
| gift__no_expiry | BOOLEAN | gift.no_expiry | gift.no_expiry |
| gift__object | TEXT | gift.object | gift.object |
| gift__resource_version | NUMERIC | gift.resource_version | gift.resource_version |
| gift__scheduled_at | NUMERIC | gift.scheduled_at | gift.scheduled_at |
| gift__status | TEXT | gift.status | gift.status |
| gift__updated_at | NUMERIC | gift.updated_at | gift.updated_at |
Chargebee hosted_page fields
The hosted_page report of the Chargebee connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| hosted_page__business_entity_id | TEXT | hosted_page.business_entity_id | hosted_page.business_entity_id |
| hosted_page__checkout_info | OBJECT | hosted_page.checkout_info | hosted_page.checkout_info |
| hosted_page__content | OBJECT | hosted_page.content | hosted_page.content |
| hosted_page__created_at | NUMERIC | hosted_page.created_at | hosted_page.created_at |
| hosted_page__custom_fields | OBJECT | hosted_page.custom_fields | hosted_page.custom_fields |
| hosted_page__embed | BOOLEAN | hosted_page.embed | hosted_page.embed |
| hosted_page__expires_at | NUMERIC | hosted_page.expires_at | hosted_page.expires_at |
| hosted_page__id | TEXT | hosted_page.id | hosted_page.id |
| hosted_page__object | TEXT | hosted_page.object | hosted_page.object |
| hosted_page__pass_thru_content | TEXT | hosted_page.pass_thru_content | hosted_page.pass_thru_content |
| hosted_page__resource_version | NUMERIC | hosted_page.resource_version | hosted_page.resource_version |
| hosted_page__state | TEXT | hosted_page.state | hosted_page.state |
| hosted_page__type | TEXT | hosted_page.type | hosted_page.type |
| hosted_page__updated_at | NUMERIC | hosted_page.updated_at | hosted_page.updated_at |
| hosted_page__url | TEXT | hosted_page.url | hosted_page.url |
Chargebee invoice fields
The invoice report of the Chargebee connector includes 69 fields.
Chargebee invoice fields (invoice__adjustment_credit_notes to invoice__net_term_days)
| ID | Type | Name | Description |
|---|---|---|---|
| invoice__adjustment_credit_notes | OBJECT | invoice.adjustment_credit_notes | invoice.adjustment_credit_notes |
| invoice__amount_adjusted | NUMERIC | invoice.amount_adjusted | invoice.amount_adjusted |
| invoice__amount_due | NUMERIC | invoice.amount_due | invoice.amount_due |
| invoice__amount_paid | NUMERIC | invoice.amount_paid | invoice.amount_paid |
| invoice__amount_to_collect | NUMERIC | invoice.amount_to_collect | invoice.amount_to_collect |
| invoice__applied_credits | OBJECT | invoice.applied_credits | invoice.applied_credits |
| invoice__base_currency_code | TEXT | invoice.base_currency_code | invoice.base_currency_code |
| invoice__billing_address | OBJECT | invoice.billing_address | invoice.billing_address |
| invoice__business_entity_id | TEXT | invoice.business_entity_id | invoice.business_entity_id |
| invoice__channel | TEXT | invoice.channel | invoice.channel |
| invoice__credits_applied | NUMERIC | invoice.credits_applied | invoice.credits_applied |
| invoice__currency_code | TEXT | invoice.currency_code | invoice.currency_code |
| invoice__custom_fields | OBJECT | invoice.custom_fields | invoice.custom_fields |
| invoice__customer_id | TEXT | invoice.customer_id | invoice.customer_id |
| invoice__date | NUMERIC | invoice.date | invoice.date |
| invoice__deleted | BOOLEAN | invoice.deleted | invoice.deleted |
| invoice__discounts | OBJECT | invoice.discounts | invoice.discounts |
| invoice__due_date | NUMERIC | invoice.due_date | invoice.due_date |
| invoice__dunning_attempts | OBJECT | invoice.dunning_attempts | invoice.dunning_attempts |
| invoice__dunning_status | TEXT | invoice.dunning_status | invoice.dunning_status |
| invoice__einvoice | OBJECT | invoice.einvoice | invoice.einvoice |
| invoice__exchange_rate | NUMERIC | invoice.exchange_rate | invoice.exchange_rate |
| invoice__expected_payment_date | NUMERIC | invoice.expected_payment_date | invoice.expected_payment_date |
| invoice__first_invoice | BOOLEAN | invoice.first_invoice | invoice.first_invoice |
| invoice__generated_at | NUMERIC | invoice.generated_at | invoice.generated_at |
| invoice__has_advance_charges | BOOLEAN | invoice.has_advance_charges | invoice.has_advance_charges |
| invoice__id | TEXT | invoice.id | invoice.id |
| invoice__is_digital | BOOLEAN | invoice.is_digital | invoice.is_digital |
| invoice__is_gifted | BOOLEAN | invoice.is_gifted | invoice.is_gifted |
| invoice__issued_credit_notes | OBJECT | invoice.issued_credit_notes | invoice.issued_credit_notes |
| invoice__line_item_discounts | OBJECT | invoice.line_item_discounts | invoice.line_item_discounts |
| invoice__line_item_taxes | OBJECT | invoice.line_item_taxes | invoice.line_item_taxes |
| invoice__line_item_tiers | OBJECT | invoice.line_item_tiers | invoice.line_item_tiers |
| invoice__line_items | OBJECT | invoice.line_items | invoice.line_items |
| invoice__linked_orders | OBJECT | invoice.linked_orders | invoice.linked_orders |
| invoice__linked_payments | OBJECT | invoice.linked_payments | invoice.linked_payments |
| invoice__linked_taxes_withheld | OBJECT | invoice.linked_taxes_withheld | invoice.linked_taxes_withheld |
| invoice__local_currency_code | TEXT | invoice.local_currency_code | invoice.local_currency_code |
| invoice__local_currency_exchange_rate | NUMERIC | invoice.local_currency_exchange_rate | invoice.local_currency_exchange_rate |
| invoice__net_term_days | NUMERIC | invoice.net_term_days | invoice.net_term_days |
Chargebee invoice fields (invoice__new_sales_amount to invoice__write_off_amount)
| ID | Type | Name | Description |
|---|---|---|---|
| invoice__new_sales_amount | NUMERIC | invoice.new_sales_amount | invoice.new_sales_amount |
| invoice__next_retry_at | NUMERIC | invoice.next_retry_at | invoice.next_retry_at |
| invoice__notes | OBJECT | invoice.notes | invoice.notes |
| invoice__object | TEXT | invoice.object | invoice.object |
| invoice__paid_at | NUMERIC | invoice.paid_at | invoice.paid_at |
| invoice__payment_owner | TEXT | invoice.payment_owner | invoice.payment_owner |
| invoice__po_number | TEXT | invoice.po_number | invoice.po_number |
| invoice__price_type | TEXT | invoice.price_type | invoice.price_type |
| invoice__recurring | BOOLEAN | invoice.recurring | invoice.recurring |
| invoice__resource_version | NUMERIC | invoice.resource_version | invoice.resource_version |
| invoice__round_off_amount | NUMERIC | invoice.round_off_amount | invoice.round_off_amount |
| invoice__shipping_address | OBJECT | invoice.shipping_address | invoice.shipping_address |
| invoice__statement_descriptor | OBJECT | invoice.statement_descriptor | invoice.statement_descriptor |
| invoice__status | TEXT | invoice.status | invoice.status |
| invoice__sub_total | NUMERIC | invoice.sub_total | invoice.sub_total |
| invoice__sub_total_in_local_currency | NUMERIC | invoice.sub_total_in_local_currency | invoice.sub_total_in_local_currency |
| invoice__subscription_id | TEXT | invoice.subscription_id | invoice.subscription_id |
| invoice__tax | NUMERIC | invoice.tax | invoice.tax |
| invoice__tax_category | TEXT | invoice.tax_category | invoice.tax_category |
| invoice__taxes | OBJECT | invoice.taxes | invoice.taxes |
| invoice__term_finalized | BOOLEAN | invoice.term_finalized | invoice.term_finalized |
| invoice__total | NUMERIC | invoice.total | invoice.total |
| invoice__total_in_local_currency | NUMERIC | invoice.total_in_local_currency | invoice.total_in_local_currency |
| invoice__updated_at | NUMERIC | invoice.updated_at | invoice.updated_at |
| invoice__vat_number | TEXT | invoice.vat_number | invoice.vat_number |
| invoice__vat_number_prefix | TEXT | invoice.vat_number_prefix | invoice.vat_number_prefix |
| invoice__void_reason_code | TEXT | invoice.void_reason_code | invoice.void_reason_code |
| invoice__voided_at | NUMERIC | invoice.voided_at | invoice.voided_at |
| invoice__write_off_amount | NUMERIC | invoice.write_off_amount | invoice.write_off_amount |
Chargebee item fields
The item report of the Chargebee connector includes 26 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| item__applicable_items | OBJECT | item.applicable_items | item.applicable_items |
| item__archived_at | NUMERIC | item.archived_at | item.archived_at |
| item__channel | TEXT | item.channel | item.channel |
| item__custom_fields | OBJECT | item.custom_fields | item.custom_fields |
| item__description | TEXT | item.description | item.description |
| item__enabled_for_checkout | BOOLEAN | item.enabled_for_checkout | item.enabled_for_checkout |
| item__enabled_in_portal | BOOLEAN | item.enabled_in_portal | item.enabled_in_portal |
| item__external_name | TEXT | item.external_name | item.external_name |
| item__gift_claim_redirect_url | TEXT | item.gift_claim_redirect_url | item.gift_claim_redirect_url |
| item__id | TEXT | item.id | item.id |
| item__included_in_mrr | BOOLEAN | item.included_in_mrr | item.included_in_mrr |
| item__is_giftable | BOOLEAN | item.is_giftable | item.is_giftable |
| item__is_shippable | BOOLEAN | item.is_shippable | item.is_shippable |
| item__item_applicability | TEXT | item.item_applicability | item.item_applicability |
| item__item_family_id | TEXT | item.item_family_id | item.item_family_id |
| item__metadata | OBJECT | item.metadata | item.metadata |
| item__metered | BOOLEAN | item.metered | item.metered |
| item__name | TEXT | item.name | item.name |
| item__object | TEXT | item.object | item.object |
| item__redirect_url | TEXT | item.redirect_url | item.redirect_url |
| item__resource_version | NUMERIC | item.resource_version | item.resource_version |
| item__status | TEXT | item.status | item.status |
| item__type | TEXT | item.type | item.type |
| item__unit | TEXT | item.unit | item.unit |
| item__updated_at | NUMERIC | item.updated_at | item.updated_at |
| item__usage_calculation | TEXT | item.usage_calculation | item.usage_calculation |
Chargebee item_family fields
The item_family report of the Chargebee connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| item_family__channel | TEXT | item_family.channel | item_family.channel |
| item_family__custom_fields | OBJECT | item_family.custom_fields | item_family.custom_fields |
| item_family__description | TEXT | item_family.description | item_family.description |
| item_family__id | TEXT | item_family.id | item_family.id |
| item_family__name | TEXT | item_family.name | item_family.name |
| item_family__object | TEXT | item_family.object | item_family.object |
| item_family__resource_version | NUMERIC | item_family.resource_version | item_family.resource_version |
| item_family__status | TEXT | item_family.status | item_family.status |
| item_family__updated_at | NUMERIC | item_family.updated_at | item_family.updated_at |
Chargebee item_price fields
The item_price report of the Chargebee connector includes 37 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| item_price__accounting_detail | OBJECT | item_price.accounting_detail | item_price.accounting_detail |
| item_price__archived_at | NUMERIC | item_price.archived_at | item_price.archived_at |
| item_price__billing_cycles | NUMERIC | item_price.billing_cycles | item_price.billing_cycles |
| item_price__channel | TEXT | item_price.channel | item_price.channel |
| item_price__created_at | NUMERIC | item_price.created_at | item_price.created_at |
| item_price__currency_code | TEXT | item_price.currency_code | item_price.currency_code |
| item_price__custom_fields | OBJECT | item_price.custom_fields | item_price.custom_fields |
| item_price__description | TEXT | item_price.description | item_price.description |
| item_price__external_name | TEXT | item_price.external_name | item_price.external_name |
| item_price__free_quantity | NUMERIC | item_price.free_quantity | item_price.free_quantity |
| item_price__free_quantity_in_decimal | TEXT | item_price.free_quantity_in_decimal | item_price.free_quantity_in_decimal |
| item_price__id | TEXT | item_price.id | item_price.id |
| item_price__invoice_notes | TEXT | item_price.invoice_notes | item_price.invoice_notes |
| item_price__is_taxable | BOOLEAN | item_price.is_taxable | item_price.is_taxable |
| item_price__item_family_id | TEXT | item_price.item_family_id | item_price.item_family_id |
| item_price__item_id | TEXT | item_price.item_id | item_price.item_id |
| item_price__item_type | TEXT | item_price.item_type | item_price.item_type |
| item_price__metadata | OBJECT | item_price.metadata | item_price.metadata |
| item_price__name | TEXT | item_price.name | item_price.name |
| item_price__object | TEXT | item_price.object | item_price.object |
| item_price__period | NUMERIC | item_price.period | item_price.period |
| item_price__period_unit | TEXT | item_price.period_unit | item_price.period_unit |
| item_price__price | NUMERIC | item_price.price | item_price.price |
| item_price__price_in_decimal | TEXT | item_price.price_in_decimal | item_price.price_in_decimal |
| item_price__pricing_model | TEXT | item_price.pricing_model | item_price.pricing_model |
| item_price__resource_version | NUMERIC | item_price.resource_version | item_price.resource_version |
| item_price__shipping_period | NUMERIC | item_price.shipping_period | item_price.shipping_period |
| item_price__shipping_period_unit | TEXT | item_price.shipping_period_unit | item_price.shipping_period_unit |
| item_price__show_description_in_invoices | BOOLEAN | item_price.show_description_in_invoices | item_price.show_description_in_invoices |
| item_price__show_description_in_quotes | BOOLEAN | item_price.show_description_in_quotes | item_price.show_description_in_quotes |
| item_price__status | TEXT | item_price.status | item_price.status |
| item_price__tax_detail | OBJECT | item_price.tax_detail | item_price.tax_detail |
| item_price__tiers | OBJECT | item_price.tiers | item_price.tiers |
| item_price__trial_end_action | TEXT | item_price.trial_end_action | item_price.trial_end_action |
| item_price__trial_period | NUMERIC | item_price.trial_period | item_price.trial_period |
| item_price__trial_period_unit | TEXT | item_price.trial_period_unit | item_price.trial_period_unit |
| item_price__updated_at | NUMERIC | item_price.updated_at | item_price.updated_at |
Chargebee order fields
The order report of the Chargebee connector includes 60 fields.
Chargebee order fields (order__amount_adjusted to order__refundable_credits)
| ID | Type | Name | Description |
|---|---|---|---|
| order__amount_adjusted | NUMERIC | order.amount_adjusted | order.amount_adjusted |
| order__amount_paid | NUMERIC | order.amount_paid | order.amount_paid |
| order__base_currency_code | TEXT | order.base_currency_code | order.base_currency_code |
| order__batch_id | TEXT | order.batch_id | order.batch_id |
| order__billing_address | OBJECT | order.billing_address | order.billing_address |
| order__business_entity_id | TEXT | order.business_entity_id | order.business_entity_id |
| order__cancellation_reason | TEXT | order.cancellation_reason | order.cancellation_reason |
| order__cancelled_at | NUMERIC | order.cancelled_at | order.cancelled_at |
| order__created_at | NUMERIC | order.created_at | order.created_at |
| order__created_by | TEXT | order.created_by | order.created_by |
| order__currency_code | TEXT | order.currency_code | order.currency_code |
| order__custom_fields | OBJECT | order.custom_fields | order.custom_fields |
| order__customer_id | TEXT | order.customer_id | order.customer_id |
| order__deleted | BOOLEAN | order.deleted | order.deleted |
| order__delivered_at | NUMERIC | order.delivered_at | order.delivered_at |
| order__discount | NUMERIC | order.discount | order.discount |
| order__document_number | TEXT | order.document_number | order.document_number |
| order__exchange_rate | NUMERIC | order.exchange_rate | order.exchange_rate |
| order__fulfillment_status | TEXT | order.fulfillment_status | order.fulfillment_status |
| order__gift_id | TEXT | order.gift_id | order.gift_id |
| order__gift_note | TEXT | order.gift_note | order.gift_note |
| order__id | TEXT | order.id | order.id |
| order__invoice_id | TEXT | order.invoice_id | order.invoice_id |
| order__invoice_round_off_amount | NUMERIC | order.invoice_round_off_amount | order.invoice_round_off_amount |
| order__is_gifted | BOOLEAN | order.is_gifted | order.is_gifted |
| order__is_resent | BOOLEAN | order.is_resent | order.is_resent |
| order__line_item_discounts | OBJECT | order.line_item_discounts | order.line_item_discounts |
| order__line_item_taxes | OBJECT | order.line_item_taxes | order.line_item_taxes |
| order__linked_credit_notes | OBJECT | order.linked_credit_notes | order.linked_credit_notes |
| order__note | TEXT | order.note | order.note |
| order__object | TEXT | order.object | order.object |
| order__order_date | NUMERIC | order.order_date | order.order_date |
| order__order_line_items | OBJECT | order.order_line_items | order.order_line_items |
| order__order_type | TEXT | order.order_type | order.order_type |
| order__original_order_id | TEXT | order.original_order_id | order.original_order_id |
| order__paid_on | NUMERIC | order.paid_on | order.paid_on |
| order__payment_status | TEXT | order.payment_status | order.payment_status |
| order__price_type | TEXT | order.price_type | order.price_type |
| order__reference_id | TEXT | order.reference_id | order.reference_id |
| order__refundable_credits | NUMERIC | order.refundable_credits | order.refundable_credits |
Chargebee order fields (order__refundable_credits_issued to order__updated_at)
| ID | Type | Name | Description |
|---|---|---|---|
| order__refundable_credits_issued | NUMERIC | order.refundable_credits_issued | order.refundable_credits_issued |
| order__resend_reason | TEXT | order.resend_reason | order.resend_reason |
| order__resent_orders | OBJECT | order.resent_orders | order.resent_orders |
| order__resent_status | TEXT | order.resent_status | order.resent_status |
| order__resource_version | NUMERIC | order.resource_version | order.resource_version |
| order__rounding_adjustement | NUMERIC | order.rounding_adjustement | order.rounding_adjustement |
| order__shipment_carrier | TEXT | order.shipment_carrier | order.shipment_carrier |
| order__shipped_at | NUMERIC | order.shipped_at | order.shipped_at |
| order__shipping_address | OBJECT | order.shipping_address | order.shipping_address |
| order__shipping_cut_off_date | NUMERIC | order.shipping_cut_off_date | order.shipping_cut_off_date |
| order__shipping_date | NUMERIC | order.shipping_date | order.shipping_date |
| order__status | TEXT | order.status | order.status |
| order__status_update_at | NUMERIC | order.status_update_at | order.status_update_at |
| order__sub_total | NUMERIC | order.sub_total | order.sub_total |
| order__subscription_id | TEXT | order.subscription_id | order.subscription_id |
| order__tax | NUMERIC | order.tax | order.tax |
| order__total | NUMERIC | order.total | order.total |
| order__tracking_id | TEXT | order.tracking_id | order.tracking_id |
| order__tracking_url | TEXT | order.tracking_url | order.tracking_url |
| order__updated_at | NUMERIC | order.updated_at | order.updated_at |
Chargebee payment_source fields
The payment_source report of the Chargebee connector includes 22 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| payment_source__amazon_payment | OBJECT | payment_source.amazon_payment | payment_source.amazon_payment |
| payment_source__bank_account | OBJECT | payment_source.bank_account | payment_source.bank_account |
| payment_source__business_entity_id | TEXT | payment_source.business_entity_id | payment_source.business_entity_id |
| payment_source__card | OBJECT | payment_source.card | payment_source.card |
| payment_source__created_at | NUMERIC | payment_source.created_at | payment_source.created_at |
| payment_source__custom_fields | OBJECT | payment_source.custom_fields | payment_source.custom_fields |
| payment_source__customer_id | TEXT | payment_source.customer_id | payment_source.customer_id |
| payment_source__deleted | BOOLEAN | payment_source.deleted | payment_source.deleted |
| payment_source__gateway | TEXT | payment_source.gateway | payment_source.gateway |
| payment_source__gateway_account_id | TEXT | payment_source.gateway_account_id | payment_source.gateway_account_id |
| payment_source__id | TEXT | payment_source.id | payment_source.id |
| payment_source__ip_address | TEXT | payment_source.ip_address | payment_source.ip_address |
| payment_source__issuing_country | TEXT | payment_source.issuing_country | payment_source.issuing_country |
| payment_source__mandates | OBJECT | payment_source.mandates | payment_source.mandates |
| payment_source__object | TEXT | payment_source.object | payment_source.object |
| payment_source__paypal | OBJECT | payment_source.paypal | payment_source.paypal |
| payment_source__reference_id | TEXT | payment_source.reference_id | payment_source.reference_id |
| payment_source__resource_version | NUMERIC | payment_source.resource_version | payment_source.resource_version |
| payment_source__status | TEXT | payment_source.status | payment_source.status |
| payment_source__type | TEXT | payment_source.type | payment_source.type |
| payment_source__updated_at | NUMERIC | payment_source.updated_at | payment_source.updated_at |
| payment_source__upi | OBJECT | payment_source.upi | payment_source.upi |
Chargebee plan fields
The plan report of the Chargebee connector includes 55 fields.
Chargebee plan fields (plan__accounting_category1 to plan__setup_cost)
| ID | Type | Name | Description |
|---|---|---|---|
| plan__accounting_category1 | TEXT | plan.accounting_category1 | plan.accounting_category1 |
| plan__accounting_category2 | TEXT | plan.accounting_category2 | plan.accounting_category2 |
| plan__accounting_category3 | TEXT | plan.accounting_category3 | plan.accounting_category3 |
| plan__accounting_category4 | TEXT | plan.accounting_category4 | plan.accounting_category4 |
| plan__accounting_code | TEXT | plan.accounting_code | plan.accounting_code |
| plan__addon_applicability | TEXT | plan.addon_applicability | plan.addon_applicability |
| plan__applicable_addons | OBJECT | plan.applicable_addons | plan.applicable_addons |
| plan__archived_at | NUMERIC | plan.archived_at | plan.archived_at |
| plan__attached_addons | OBJECT | plan.attached_addons | plan.attached_addons |
| plan__avalara_sale_type | TEXT | plan.avalara_sale_type | plan.avalara_sale_type |
| plan__avalara_service_type | NUMERIC | plan.avalara_service_type | plan.avalara_service_type |
| plan__avalara_transaction_type | NUMERIC | plan.avalara_transaction_type | plan.avalara_transaction_type |
| plan__billing_cycles | NUMERIC | plan.billing_cycles | plan.billing_cycles |
| plan__channel | TEXT | plan.channel | plan.channel |
| plan__charge_model | TEXT | plan.charge_model | plan.charge_model |
| plan__claim_url | TEXT | plan.claim_url | plan.claim_url |
| plan__currency_code | TEXT | plan.currency_code | plan.currency_code |
| plan__custom_fields | OBJECT | plan.custom_fields | plan.custom_fields |
| plan__description | TEXT | plan.description | plan.description |
| plan__enabled_in_hosted_pages | BOOLEAN | plan.enabled_in_hosted_pages | plan.enabled_in_hosted_pages |
| plan__enabled_in_portal | BOOLEAN | plan.enabled_in_portal | plan.enabled_in_portal |
| plan__event_based_addons | OBJECT | plan.event_based_addons | plan.event_based_addons |
| plan__free_quantity | NUMERIC | plan.free_quantity | plan.free_quantity |
| plan__free_quantity_in_decimal | TEXT | plan.free_quantity_in_decimal | plan.free_quantity_in_decimal |
| plan__giftable | BOOLEAN | plan.giftable | plan.giftable |
| plan__id | TEXT | plan.id | plan.id |
| plan__invoice_name | TEXT | plan.invoice_name | plan.invoice_name |
| plan__invoice_notes | TEXT | plan.invoice_notes | plan.invoice_notes |
| plan__is_shippable | BOOLEAN | plan.is_shippable | plan.is_shippable |
| plan__meta_data | OBJECT | plan.meta_data | plan.meta_data |
| plan__name | TEXT | plan.name | plan.name |
| plan__object | TEXT | plan.object | plan.object |
| plan__period | NUMERIC | plan.period | plan.period |
| plan__period_unit | TEXT | plan.period_unit | plan.period_unit |
| plan__price | NUMERIC | plan.price | plan.price |
| plan__price_in_decimal | TEXT | plan.price_in_decimal | plan.price_in_decimal |
| plan__pricing_model | TEXT | plan.pricing_model | plan.pricing_model |
| plan__redirect_url | TEXT | plan.redirect_url | plan.redirect_url |
| plan__resource_version | NUMERIC | plan.resource_version | plan.resource_version |
| plan__setup_cost | NUMERIC | plan.setup_cost | plan.setup_cost |
Chargebee plan fields (plan__shipping_frequency_period to plan__updated_at)
| ID | Type | Name | Description |
|---|---|---|---|
| plan__shipping_frequency_period | NUMERIC | plan.shipping_frequency_period | plan.shipping_frequency_period |
| plan__shipping_frequency_period_unit | TEXT | plan.shipping_frequency_period_unit | plan.shipping_frequency_period_unit |
| plan__show_description_in_invoices | BOOLEAN | plan.show_description_in_invoices | plan.show_description_in_invoices |
| plan__show_description_in_quotes | BOOLEAN | plan.show_description_in_quotes | plan.show_description_in_quotes |
| plan__sku | TEXT | plan.sku | plan.sku |
| plan__status | TEXT | plan.status | plan.status |
| plan__tax_code | TEXT | plan.tax_code | plan.tax_code |
| plan__tax_profile_id | TEXT | plan.tax_profile_id | plan.tax_profile_id |
| plan__taxable | BOOLEAN | plan.taxable | plan.taxable |
| plan__taxjar_product_code | TEXT | plan.taxjar_product_code | plan.taxjar_product_code |
| plan__tiers | OBJECT | plan.tiers | plan.tiers |
| plan__trial_end_action | TEXT | plan.trial_end_action | plan.trial_end_action |
| plan__trial_period | NUMERIC | plan.trial_period | plan.trial_period |
| plan__trial_period_unit | TEXT | plan.trial_period_unit | plan.trial_period_unit |
| plan__updated_at | NUMERIC | plan.updated_at | plan.updated_at |
Chargebee promotional_credit fields
The promotional_credit report of the Chargebee connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| promotional_credit__amount | NUMERIC | promotional_credit.amount | promotional_credit.amount |
| promotional_credit__amount_in_decimal | TEXT | promotional_credit.amount_in_decimal | promotional_credit.amount_in_decimal |
| promotional_credit__closing_balance | NUMERIC | promotional_credit.closing_balance | promotional_credit.closing_balance |
| promotional_credit__created_at | NUMERIC | promotional_credit.created_at | promotional_credit.created_at |
| promotional_credit__credit_type | TEXT | promotional_credit.credit_type | promotional_credit.credit_type |
| promotional_credit__currency_code | TEXT | promotional_credit.currency_code | promotional_credit.currency_code |
| promotional_credit__custom_fields | OBJECT | promotional_credit.custom_fields | promotional_credit.custom_fields |
| promotional_credit__customer_id | TEXT | promotional_credit.customer_id | promotional_credit.customer_id |
| promotional_credit__description | TEXT | promotional_credit.description | promotional_credit.description |
| promotional_credit__done_by | TEXT | promotional_credit.done_by | promotional_credit.done_by |
| promotional_credit__id | TEXT | promotional_credit.id | promotional_credit.id |
| promotional_credit__object | TEXT | promotional_credit.object | promotional_credit.object |
| promotional_credit__reference | TEXT | promotional_credit.reference | promotional_credit.reference |
| promotional_credit__type | TEXT | promotional_credit.type | promotional_credit.type |
Chargebee quote fields
The quote report of the Chargebee connector includes 39 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| quote__amount_due | NUMERIC | quote.amount_due | quote.amount_due |
| quote__amount_paid | NUMERIC | quote.amount_paid | quote.amount_paid |
| quote__billing_address | OBJECT | quote.billing_address | quote.billing_address |
| quote__business_entity_id | TEXT | quote.business_entity_id | quote.business_entity_id |
| quote__charge_on_acceptance | NUMERIC | quote.charge_on_acceptance | quote.charge_on_acceptance |
| quote__contract_term_end | NUMERIC | quote.contract_term_end | quote.contract_term_end |
| quote__contract_term_start | NUMERIC | quote.contract_term_start | quote.contract_term_start |
| quote__contract_term_termination_fee | NUMERIC | quote.contract_term_termination_fee | quote.contract_term_termination_fee |
| quote__credits_applied | NUMERIC | quote.credits_applied | quote.credits_applied |
| quote__currency_code | TEXT | quote.currency_code | quote.currency_code |
| quote__custom_fields | OBJECT | quote.custom_fields | quote.custom_fields |
| quote__customer_id | TEXT | quote.customer_id | quote.customer_id |
| quote__date | NUMERIC | quote.date | quote.date |
| quote__discounts | OBJECT | quote.discounts | quote.discounts |
| quote__id | TEXT | quote.id | quote.id |
| quote__invoice_id | TEXT | quote.invoice_id | quote.invoice_id |
| quote__line_item_discounts | OBJECT | quote.line_item_discounts | quote.line_item_discounts |
| quote__line_item_taxes | OBJECT | quote.line_item_taxes | quote.line_item_taxes |
| quote__line_item_tiers | OBJECT | quote.line_item_tiers | quote.line_item_tiers |
| quote__line_items | OBJECT | quote.line_items | quote.line_items |
| quote__name | TEXT | quote.name | quote.name |
| quote__notes | OBJECT | quote.notes | quote.notes |
| quote__object | TEXT | quote.object | quote.object |
| quote__operation_type | TEXT | quote.operation_type | quote.operation_type |
| quote__po_number | TEXT | quote.po_number | quote.po_number |
| quote__price_type | TEXT | quote.price_type | quote.price_type |
| quote__resource_version | NUMERIC | quote.resource_version | quote.resource_version |
| quote__shipping_address | OBJECT | quote.shipping_address | quote.shipping_address |
| quote__status | TEXT | quote.status | quote.status |
| quote__sub_total | NUMERIC | quote.sub_total | quote.sub_total |
| quote__subscription_id | TEXT | quote.subscription_id | quote.subscription_id |
| quote__taxes | OBJECT | quote.taxes | quote.taxes |
| quote__total | NUMERIC | quote.total | quote.total |
| quote__total_payable | NUMERIC | quote.total_payable | quote.total_payable |
| quote__updated_at | NUMERIC | quote.updated_at | quote.updated_at |
| quote__valid_till | NUMERIC | quote.valid_till | quote.valid_till |
| quote__vat_number | TEXT | quote.vat_number | quote.vat_number |
| quote__vat_number_prefix | TEXT | quote.vat_number_prefix | quote.vat_number_prefix |
| quote__version | NUMERIC | quote.version | quote.version |
Chargebee quote_line_group fields
The quote_line_group report of the Chargebee connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| quote_line_group__amount_due | NUMERIC | quote_line_group.amount_due | quote_line_group.amount_due |
| quote_line_group__amount_paid | NUMERIC | quote_line_group.amount_paid | quote_line_group.amount_paid |
| quote_line_group__billing_cycle_number | NUMERIC | quote_line_group.billing_cycle_number | quote_line_group.billing_cycle_number |
| quote_line_group__charge_event | TEXT | quote_line_group.charge_event | quote_line_group.charge_event |
| quote_line_group__credits_applied | NUMERIC | quote_line_group.credits_applied | quote_line_group.credits_applied |
| quote_line_group__custom_fields | OBJECT | quote_line_group.custom_fields | quote_line_group.custom_fields |
| quote_line_group__discounts | OBJECT | quote_line_group.discounts | quote_line_group.discounts |
| quote_line_group__id | TEXT | quote_line_group.id | quote_line_group.id |
| quote_line_group__line_item_discounts | OBJECT | quote_line_group.line_item_discounts | quote_line_group.line_item_discounts |
| quote_line_group__line_item_taxes | OBJECT | quote_line_group.line_item_taxes | quote_line_group.line_item_taxes |
| quote_line_group__line_items | OBJECT | quote_line_group.line_items | quote_line_group.line_items |
| quote_line_group__object | TEXT | quote_line_group.object | quote_line_group.object |
| quote_line_group__quote_id | TEXT | quote_line_group.quote_id | quote_line_group.quote_id |
| quote_line_group__sub_total | NUMERIC | quote_line_group.sub_total | quote_line_group.sub_total |
| quote_line_group__taxes | OBJECT | quote_line_group.taxes | quote_line_group.taxes |
| quote_line_group__total | NUMERIC | quote_line_group.total | quote_line_group.total |
| quote_line_group__version | NUMERIC | quote_line_group.version | quote_line_group.version |
Chargebee site_migration_detail fields
The site_migration_detail report of the Chargebee connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| site_migration_detail__custom_fields | OBJECT | site_migration_detail.custom_fields | site_migration_detail.custom_fields |
| site_migration_detail__entity_id | TEXT | site_migration_detail.entity_id | site_migration_detail.entity_id |
| site_migration_detail__entity_id_at_other_site | TEXT | site_migration_detail.entity_id_at_other_site | site_migration_detail.entity_id_at_other_site |
| site_migration_detail__entity_type | TEXT | site_migration_detail.entity_type | site_migration_detail.entity_type |
| site_migration_detail__migrated_at | NUMERIC | site_migration_detail.migrated_at | site_migration_detail.migrated_at |
| site_migration_detail__object | TEXT | site_migration_detail.object | site_migration_detail.object |
| site_migration_detail__other_site_name | TEXT | site_migration_detail.other_site_name | site_migration_detail.other_site_name |
| site_migration_detail__status | TEXT | site_migration_detail.status | site_migration_detail.status |
Chargebee subscription fields
The subscription report of the Chargebee connector includes 76 fields.
Chargebee subscription fields (subscription__activated_at to subscription__id)
| ID | Type | Name | Description |
|---|---|---|---|
| subscription__activated_at | NUMERIC | subscription.activated_at | subscription.activated_at |
| subscription__addons | OBJECT | subscription.addons | subscription.addons |
| subscription__affiliate_token | TEXT | subscription.affiliate_token | subscription.affiliate_token |
| subscription__auto_close_invoices | BOOLEAN | subscription.auto_close_invoices | subscription.auto_close_invoices |
| subscription__auto_collection | TEXT | subscription.auto_collection | subscription.auto_collection |
| subscription__base_currency_code | TEXT | subscription.base_currency_code | subscription.base_currency_code |
| subscription__billing_period | NUMERIC | subscription.billing_period | subscription.billing_period |
| subscription__billing_period_unit | TEXT | subscription.billing_period_unit | subscription.billing_period_unit |
| subscription__business_entity_id | TEXT | subscription.business_entity_id | subscription.business_entity_id |
| subscription__cancel_reason | TEXT | subscription.cancel_reason | subscription.cancel_reason |
| subscription__cancel_reason_code | TEXT | subscription.cancel_reason_code | subscription.cancel_reason_code |
| subscription__cancel_schedule_created_at | NUMERIC | subscription.cancel_schedule_created_at | subscription.cancel_schedule_created_at |
| subscription__cancelled_at | NUMERIC | subscription.cancelled_at | subscription.cancelled_at |
| subscription__channel | TEXT | subscription.channel | subscription.channel |
| subscription__charged_event_based_addons | OBJECT | subscription.charged_event_based_addons | subscription.charged_event_based_addons |
| subscription__charged_items | OBJECT | subscription.charged_items | subscription.charged_items |
| subscription__contract_term | OBJECT | subscription.contract_term | subscription.contract_term |
| subscription__contract_term_billing_cycle_on_renewal | NUMERIC | subscription.contract_term_billing_cycle_on_renewal | subscription.contract_term_billing_cycle_on_renewal |
| subscription__coupon | TEXT | subscription.coupon | subscription.coupon |
| subscription__coupons | OBJECT | subscription.coupons | subscription.coupons |
| subscription__create_pending_invoices | BOOLEAN | subscription.create_pending_invoices | subscription.create_pending_invoices |
| subscription__created_at | NUMERIC | subscription.created_at | subscription.created_at |
| subscription__created_from_ip | TEXT | subscription.created_from_ip | subscription.created_from_ip |
| subscription__currency_code | TEXT | subscription.currency_code | subscription.currency_code |
| subscription__current_term_end | NUMERIC | subscription.current_term_end | subscription.current_term_end |
| subscription__current_term_start | NUMERIC | subscription.current_term_start | subscription.current_term_start |
| subscription__custom_fields | OBJECT | subscription.custom_fields | subscription.custom_fields |
| subscription__customer_id | TEXT | subscription.customer_id | subscription.customer_id |
| subscription__deleted | BOOLEAN | subscription.deleted | subscription.deleted |
| subscription__discounts | OBJECT | subscription.discounts | subscription.discounts |
| subscription__due_invoices_count | NUMERIC | subscription.due_invoices_count | subscription.due_invoices_count |
| subscription__due_since | NUMERIC | subscription.due_since | subscription.due_since |
| subscription__event_based_addons | OBJECT | subscription.event_based_addons | subscription.event_based_addons |
| subscription__exchange_rate | NUMERIC | subscription.exchange_rate | subscription.exchange_rate |
| subscription__free_period | NUMERIC | subscription.free_period | subscription.free_period |
| subscription__free_period_unit | TEXT | subscription.free_period_unit | subscription.free_period_unit |
| subscription__gift_id | TEXT | subscription.gift_id | subscription.gift_id |
| subscription__has_scheduled_advance_invoices | BOOLEAN | subscription.has_scheduled_advance_invoices | subscription.has_scheduled_advance_invoices |
| subscription__has_scheduled_changes | BOOLEAN | subscription.has_scheduled_changes | subscription.has_scheduled_changes |
| subscription__id | TEXT | subscription.id | subscription.id |
Chargebee subscription fields (subscription__invoice_notes to subscription__updated_at)
| ID | Type | Name | Description |
|---|---|---|---|
| subscription__invoice_notes | TEXT | subscription.invoice_notes | subscription.invoice_notes |
| subscription__item_tiers | OBJECT | subscription.item_tiers | subscription.item_tiers |
| subscription__meta_data | OBJECT | subscription.meta_data | subscription.meta_data |
| subscription__metadata | OBJECT | subscription.metadata | subscription.metadata |
| subscription__mrr | NUMERIC | subscription.mrr | subscription.mrr |
| subscription__next_billing_at | NUMERIC | subscription.next_billing_at | subscription.next_billing_at |
| subscription__object | TEXT | subscription.object | subscription.object |
| subscription__offline_payment_method | TEXT | subscription.offline_payment_method | subscription.offline_payment_method |
| subscription__override_relationship | BOOLEAN | subscription.override_relationship | subscription.override_relationship |
| subscription__pause_date | NUMERIC | subscription.pause_date | subscription.pause_date |
| subscription__payment_source_id | TEXT | subscription.payment_source_id | subscription.payment_source_id |
| subscription__plan_amount | NUMERIC | subscription.plan_amount | subscription.plan_amount |
| subscription__plan_amount_in_decimal | TEXT | subscription.plan_amount_in_decimal | subscription.plan_amount_in_decimal |
| subscription__plan_free_quantity | NUMERIC | subscription.plan_free_quantity | subscription.plan_free_quantity |
| subscription__plan_free_quantity_in_decimal | TEXT | subscription.plan_free_quantity_in_decimal | subscription.plan_free_quantity_in_decimal |
| subscription__plan_id | TEXT | subscription.plan_id | subscription.plan_id |
| subscription__plan_quantity | NUMERIC | subscription.plan_quantity | subscription.plan_quantity |
| subscription__plan_quantity_in_decimal | TEXT | subscription.plan_quantity_in_decimal | subscription.plan_quantity_in_decimal |
| subscription__plan_unit_price | NUMERIC | subscription.plan_unit_price | subscription.plan_unit_price |
| subscription__plan_unit_price_in_decimal | TEXT | subscription.plan_unit_price_in_decimal | subscription.plan_unit_price_in_decimal |
| subscription__po_number | TEXT | subscription.po_number | subscription.po_number |
| subscription__referral_info | OBJECT | subscription.referral_info | subscription.referral_info |
| subscription__remaining_billing_cycles | NUMERIC | subscription.remaining_billing_cycles | subscription.remaining_billing_cycles |
| subscription__resource_version | NUMERIC | subscription.resource_version | subscription.resource_version |
| subscription__resume_date | NUMERIC | subscription.resume_date | subscription.resume_date |
| subscription__setup_fee | NUMERIC | subscription.setup_fee | subscription.setup_fee |
| subscription__shipping_address | OBJECT | subscription.shipping_address | subscription.shipping_address |
| subscription__start_date | NUMERIC | subscription.start_date | subscription.start_date |
| subscription__started_at | NUMERIC | subscription.started_at | subscription.started_at |
| subscription__status | TEXT | subscription.status | subscription.status |
| subscription__subscription_items | OBJECT | subscription.subscription_items | subscription.subscription_items |
| subscription__total_dues | NUMERIC | subscription.total_dues | subscription.total_dues |
| subscription__trial_end | NUMERIC | subscription.trial_end | subscription.trial_end |
| subscription__trial_end_action | TEXT | subscription.trial_end_action | subscription.trial_end_action |
| subscription__trial_start | NUMERIC | subscription.trial_start | subscription.trial_start |
| subscription__updated_at | NUMERIC | subscription.updated_at | subscription.updated_at |
Chargebee transaction fields
The transaction report of the Chargebee connector includes 55 fields.
Chargebee transaction fields (transaction__amount to transaction__reference_authorization_id)
| ID | Type | Name | Description |
|---|---|---|---|
| transaction__amount | NUMERIC | transaction.amount | transaction.amount |
| transaction__amount_capturable | NUMERIC | transaction.amount_capturable | transaction.amount_capturable |
| transaction__amount_unused | NUMERIC | transaction.amount_unused | transaction.amount_unused |
| transaction__authorization_reason | TEXT | transaction.authorization_reason | transaction.authorization_reason |
| transaction__base_currency_code | TEXT | transaction.base_currency_code | transaction.base_currency_code |
| transaction__business_entity_id | TEXT | transaction.business_entity_id | transaction.business_entity_id |
| transaction__cn_create_reason_code | TEXT | transaction.cn_create_reason_code | transaction.cn_create_reason_code |
| transaction__cn_date | NUMERIC | transaction.cn_date | transaction.cn_date |
| transaction__cn_reference_invoice_id | TEXT | transaction.cn_reference_invoice_id | transaction.cn_reference_invoice_id |
| transaction__cn_status | TEXT | transaction.cn_status | transaction.cn_status |
| transaction__cn_total | NUMERIC | transaction.cn_total | transaction.cn_total |
| transaction__currency_code | TEXT | transaction.currency_code | transaction.currency_code |
| transaction__custom_fields | OBJECT | transaction.custom_fields | transaction.custom_fields |
| transaction__customer_id | TEXT | transaction.customer_id | transaction.customer_id |
| transaction__date | NUMERIC | transaction.date | transaction.date |
| transaction__deleted | BOOLEAN | transaction.deleted | transaction.deleted |
| transaction__error_code | TEXT | transaction.error_code | transaction.error_code |
| transaction__error_detail | TEXT | transaction.error_detail | transaction.error_detail |
| transaction__error_text | TEXT | transaction.error_text | transaction.error_text |
| transaction__exchange_rate | NUMERIC | transaction.exchange_rate | transaction.exchange_rate |
| transaction__fraud_flag | TEXT | transaction.fraud_flag | transaction.fraud_flag |
| transaction__fraud_reason | TEXT | transaction.fraud_reason | transaction.fraud_reason |
| transaction__gateway | TEXT | transaction.gateway | transaction.gateway |
| transaction__gateway_account_id | TEXT | transaction.gateway_account_id | transaction.gateway_account_id |
| transaction__id | TEXT | transaction.id | transaction.id |
| transaction__id_at_gateway | TEXT | transaction.id_at_gateway | transaction.id_at_gateway |
| transaction__iin | TEXT | transaction.iin | transaction.iin |
| transaction__initiator_type | TEXT | transaction.initiator_type | transaction.initiator_type |
| transaction__last4 | TEXT | transaction.last4 | transaction.last4 |
| transaction__linked_credit_notes | OBJECT | transaction.linked_credit_notes | transaction.linked_credit_notes |
| transaction__linked_invoices | OBJECT | transaction.linked_invoices | transaction.linked_invoices |
| transaction__linked_payments | OBJECT | transaction.linked_payments | transaction.linked_payments |
| transaction__linked_refunds | OBJECT | transaction.linked_refunds | transaction.linked_refunds |
| transaction__masked_card_number | TEXT | transaction.masked_card_number | transaction.masked_card_number |
| transaction__merchant_reference_id | TEXT | transaction.merchant_reference_id | transaction.merchant_reference_id |
| transaction__object | TEXT | transaction.object | transaction.object |
| transaction__payment_method | TEXT | transaction.payment_method | transaction.payment_method |
| transaction__payment_method_details | TEXT | transaction.payment_method_details | transaction.payment_method_details |
| transaction__payment_source_id | TEXT | transaction.payment_source_id | transaction.payment_source_id |
| transaction__reference_authorization_id | TEXT | transaction.reference_authorization_id | transaction.reference_authorization_id |
Chargebee transaction fields (transaction__reference_number to transaction__voided_at)
| ID | Type | Name | Description |
|---|---|---|---|
| transaction__reference_number | TEXT | transaction.reference_number | transaction.reference_number |
| transaction__reference_transaction_id | TEXT | transaction.reference_transaction_id | transaction.reference_transaction_id |
| transaction__refrence_number | TEXT | transaction.refrence_number | transaction.refrence_number |
| transaction__refunded_txn_id | TEXT | transaction.refunded_txn_id | transaction.refunded_txn_id |
| transaction__resource_version | NUMERIC | transaction.resource_version | transaction.resource_version |
| transaction__reversal_transaction_id | TEXT | transaction.reversal_transaction_id | transaction.reversal_transaction_id |
| transaction__settled_at | NUMERIC | transaction.settled_at | transaction.settled_at |
| transaction__status | TEXT | transaction.status | transaction.status |
| transaction__subscription_id | TEXT | transaction.subscription_id | transaction.subscription_id |
| transaction__three_d_secure | BOOLEAN | transaction.three_d_secure | transaction.three_d_secure |
| transaction__txn_amount | NUMERIC | transaction.txn_amount | transaction.txn_amount |
| transaction__txn_date | NUMERIC | transaction.txn_date | transaction.txn_date |
| transaction__type | TEXT | transaction.type | transaction.type |
| transaction__updated_at | NUMERIC | transaction.updated_at | transaction.updated_at |
| transaction__voided_at | NUMERIC | transaction.voided_at | transaction.voided_at |
Chargebee unbilled_charge fields
The unbilled_charge report of the Chargebee connector includes 25 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| unbilled_charge__amount | NUMERIC | unbilled_charge.amount | unbilled_charge.amount |
| unbilled_charge__amount_in_decimal | TEXT | unbilled_charge.amount_in_decimal | unbilled_charge.amount_in_decimal |
| unbilled_charge__currency_code | TEXT | unbilled_charge.currency_code | unbilled_charge.currency_code |
| unbilled_charge__custom_fields | OBJECT | unbilled_charge.custom_fields | unbilled_charge.custom_fields |
| unbilled_charge__customer_id | TEXT | unbilled_charge.customer_id | unbilled_charge.customer_id |
| unbilled_charge__date_from | NUMERIC | unbilled_charge.date_from | unbilled_charge.date_from |
| unbilled_charge__date_to | NUMERIC | unbilled_charge.date_to | unbilled_charge.date_to |
| unbilled_charge__deleted | BOOLEAN | unbilled_charge.deleted | unbilled_charge.deleted |
| unbilled_charge__description | TEXT | unbilled_charge.description | unbilled_charge.description |
| unbilled_charge__discount_amount | NUMERIC | unbilled_charge.discount_amount | unbilled_charge.discount_amount |
| unbilled_charge__entity_id | TEXT | unbilled_charge.entity_id | unbilled_charge.entity_id |
| unbilled_charge__entity_type | TEXT | unbilled_charge.entity_type | unbilled_charge.entity_type |
| unbilled_charge__id | TEXT | unbilled_charge.id | unbilled_charge.id |
| unbilled_charge__is_advance_charge | BOOLEAN | unbilled_charge.is_advance_charge | unbilled_charge.is_advance_charge |
| unbilled_charge__is_voided | BOOLEAN | unbilled_charge.is_voided | unbilled_charge.is_voided |
| unbilled_charge__object | TEXT | unbilled_charge.object | unbilled_charge.object |
| unbilled_charge__pricing_model | TEXT | unbilled_charge.pricing_model | unbilled_charge.pricing_model |
| unbilled_charge__quantity | NUMERIC | unbilled_charge.quantity | unbilled_charge.quantity |
| unbilled_charge__quantity_in_decimal | TEXT | unbilled_charge.quantity_in_decimal | unbilled_charge.quantity_in_decimal |
| unbilled_charge__subscription_id | TEXT | unbilled_charge.subscription_id | unbilled_charge.subscription_id |
| unbilled_charge__tiers | OBJECT | unbilled_charge.tiers | unbilled_charge.tiers |
| unbilled_charge__unit_amount | NUMERIC | unbilled_charge.unit_amount | unbilled_charge.unit_amount |
| unbilled_charge__unit_amount_in_decimal | TEXT | unbilled_charge.unit_amount_in_decimal | unbilled_charge.unit_amount_in_decimal |
| unbilled_charge__updated_at | NUMERIC | unbilled_charge.updated_at | unbilled_charge.updated_at |
| unbilled_charge__voided_at | NUMERIC | unbilled_charge.voided_at | unbilled_charge.voided_at |
Chargebee virtual_bank_account fields
The virtual_bank_account report of the Chargebee connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| virtual_bank_account__account_number | TEXT | virtual_bank_account.account_number | virtual_bank_account.account_number |
| virtual_bank_account__bank_name | TEXT | virtual_bank_account.bank_name | virtual_bank_account.bank_name |
| virtual_bank_account__created_at | NUMERIC | virtual_bank_account.created_at | virtual_bank_account.created_at |
| virtual_bank_account__custom_fields | OBJECT | virtual_bank_account.custom_fields | virtual_bank_account.custom_fields |
| virtual_bank_account__customer_id | TEXT | virtual_bank_account.customer_id | virtual_bank_account.customer_id |
| virtual_bank_account__deleted | BOOLEAN | virtual_bank_account.deleted | virtual_bank_account.deleted |
| virtual_bank_account__email | TEXT | virtual_bank_account.email | virtual_bank_account.email |
| virtual_bank_account__gateway | TEXT | virtual_bank_account.gateway | virtual_bank_account.gateway |
| virtual_bank_account__id | TEXT | virtual_bank_account.id | virtual_bank_account.id |
| virtual_bank_account__reference_id | TEXT | virtual_bank_account.reference_id | virtual_bank_account.reference_id |
| virtual_bank_account__resource_version | NUMERIC | virtual_bank_account.resource_version | virtual_bank_account.resource_version |
| virtual_bank_account__routing_number | TEXT | virtual_bank_account.routing_number | virtual_bank_account.routing_number |
| virtual_bank_account__scheme | TEXT | virtual_bank_account.scheme | virtual_bank_account.scheme |
| virtual_bank_account__swift_code | TEXT | virtual_bank_account.swift_code | virtual_bank_account.swift_code |
| virtual_bank_account__updated_at | NUMERIC | virtual_bank_account.updated_at | virtual_bank_account.updated_at |
Chargebee other fields
The Chargebee connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |