Chargebee integration summary

Stitch’s Chargebee integration replicates data using the Chargebee v2 API . Refer to the Schema section for a list of objects available for replication.

This integration supports Chargebee sites that use version 1.0 or version 2.0 of Chargebee’s Product Catalog. The Product Catalog version your site uses determines which tables and fields you can select for replication, however. Refer to the Table and field availability and Chargebee product catalogs section for more info.

Chargebee feature snapshot

A high-level look at Stitch's Chargebee (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Released on May 21, 2019

Supported by

Singer Community

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-chargebee

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Chargebee

Step 1: Generate an API Key

First, you’ll generate a Chargebee API Key for Stitch. This will allow Stitch to read data from your Chargebee account using the Chargebee API.

  1. Sign into your Chargebee account.
  2. In the left sidenav, click Settings > Configure Chargebee.
  3. Click the API keys and webhooks button.
  4. On the API Keys page, click the + Add API Key button. The Create an API Key modal will display.
  5. Select Read-Only Key as the API key type.
  6. Select All to define the API key’s access. This will grant read-only access to your Chargebee site.
  7. In the Name the API key field, enter Stitch.
  8. Click Create Key.

Chargebee will create the API key and redirect you back to the API Keys page:

Copy the API key somwhere handy - you’ll need it to complete the setup in Stitch.

Step 2: Add Chargebee as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Chargebee icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Chargebee” would create a schema called stitch_chargebee in the destination. Note: Schema names cannot be changed after you save the integration.

  5. In the API Key field, paste the API key you generated in Step 1.
  6. In the Site field, enter the name of your Chargebee site. This can be found in the URL of your Chargebee site. For example: If the URL was https://stitch.chargebee.com, only stitch would be entered into this field.

Step 3: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Chargebee integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Chargebee’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 4: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Chargebee integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 5: Set objects to replicate

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Chargebee integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Chargebee, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.


Chargebee replication

Table and field availability and Chargebee product catalogs

The availability of some tables and fields is dependent on the Chargebee Product Catalog version your Chargebee site uses. Refer to Chargebee’s documentation for more info, including how to identify which Product Catalog version your site is using.

The following table contains a list of the tables included in this version of Stitch’s Chargebee integration and the Product Catalog version required to replicate the table.

Additionally, some fields are also subject to Product Catalog version requirements. These fields are noted in the attribute documentation for individual tables.

Note: If your site is using a Product Catalog version that a table or field doesn’t support, the table/field won’t display in the Tables to Replicate tab in Stitch. For example: If the site is using v2.0 of the Product Catalog, tables/fields that require v1.0 won’t display in Stitch.

Table name Required Product Catalog version

Chargebee table reference

addons

The addons table contains info about the addons in your Chargebee account. Addons are additional charges applied to subscriptions apart from base charges.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

addons schema on GitHub

Chargebee API method

Join addons with on
invoices
addons.id = invoices.notes.entity_id
plans
addons.id = plans.applicable_addons.id

accounting_category1

STRING

accounting_category2

STRING

accounting_category3

STRING

accounting_category4

STRING

accounting_code

STRING

archived_at

DATE-TIME

avalara_sale_type

STRING

avalara_service_type

INTEGER

avalara_transaction_type

INTEGER

channel

STRING

charge_type

STRING

currency_code

STRING

custom_fields

STRING

description

STRING

enabled_in_portal

BOOLEAN

id

STRING

included_in_mrr

BOOLEAN

invoice_name

STRING

invoice_notes

STRING

is_shippable

BOOLEAN

meta_data

STRING

name

STRING

object

STRING

period

INTEGER

period_unit

STRING

price

INTEGER

price_in_decimal

STRING

pricing_model

STRING

resource_version

INTEGER

shipping_frequency_period

INTEGER

shipping_frequency_period_unit

STRING

show_description_in_invoices

BOOLEAN

show_description_in_quotes

BOOLEAN

sku

STRING

status

STRING

tax_code

STRING

tax_profile_id

STRING

taxable

BOOLEAN

taxjar_product_code

STRING

tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

object

STRING

price

INTEGER

price_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

type

STRING

unit

STRING

updated_at

DATE-TIME

comments

The comments table contains info about comments in your Chargebee account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

created_at

Useful links

Chargebee documentation

comments schema on GitHub

Chargebee API method

added_by

STRING

created_at

DATE-TIME

entity_id

STRING

entity_type

STRING

id

STRING

notes

STRING

object

STRING

type

STRING

coupons

The coupons table contains info about the coupons in your Chargebee account.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

coupons schema on GitHub

Chargebee API method

Join coupons with on
credit_notes
coupons.id = credit_notes.discounts.entity_id
coupons.id = credit_notes.line_item_discounts.coupon_id
events
coupons.id = events.content.coupon.id
coupons.id = events.content.invoice.discounts.entity_id
coupons.id = events.content.invoice.line_item_discounts.coupon_id
coupons.id = events.content.subscription.coupons.coupon_id
invoices
coupons.id = invoices.discounts.entity_id
coupons.id = invoices.line_item_discounts.coupon_id
coupons.id = invoices.notes.entity_id
subscriptions
coupons.id = subscriptions.coupons.coupon_id
orders
coupons.id = orders.line_item_discounts.coupon_id

apply_discount_on

STRING

apply_on

STRING

archived_at

DATE-TIME

created_at

DATE-TIME

currency_code

STRING

discount_amount

NUMBER

discount_percentage

NUMBER

discount_type

STRING

duration_month

INTEGER

duration_type

STRING

id

STRING

invoice_name

STRING

invoice_notes

STRING

item_constraint_criteria

ARRAY

currencies

ARRAY

item_family_ids

ARRAY

item_price_periods

ARRAY

item_type

STRING

item_constraints

ARRAY

constraint

STRING

item_price_ids

ARRAY

item_type

STRING

max_redemptions

INTEGER

meta_data

STRING

name

STRING

object

STRING

period

INTEGER

period_unit

STRING

redemptions

INTEGER

resource_version

INTEGER

status

STRING

updated_at

DATE-TIME

valid_till

DATE-TIME

credit_notes

The credit_notes table contains info about the credit notes in your Chargebee account. A credit note is a document that specifies the money owed by a business to a customer.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

credit_notes schema on GitHub

Chargebee API method

Join credit_notes with on
coupons
credit_notes.discounts.entity_id = coupons.id
credit_notes.line_item_discounts.coupon_id = coupons.id
events
credit_notes.discounts.entity_id = events.content.coupon.id
credit_notes.line_item_discounts.coupon_id = events.content.coupon.id
credit_notes.discounts.entity_id = events.content.invoice.discounts.entity_id
credit_notes.line_item_discounts.coupon_id = events.content.invoice.discounts.entity_id
credit_notes.discounts.entity_id = events.content.invoice.line_item_discounts.coupon_id
credit_notes.line_item_discounts.coupon_id = events.content.invoice.line_item_discounts.coupon_id
credit_notes.discounts.entity_id = events.content.subscription.coupons.coupon_id
credit_notes.line_item_discounts.coupon_id = events.content.subscription.coupons.coupon_id
credit_notes.id = events.content.invoice.adjustment_credit_notes.cn_id
credit_notes.id = events.content.invoice.applied_credits.cn_id
credit_notes.id = events.content.invoice.issued_credit_notes.cn_id
credit_notes.customer_id = events.content.customer.id
credit_notes.customer_id = events.content.invoice.customer_id
credit_notes.customer_id = events.content.subscription.customer_id
credit_notes.customer_id = events.content.transaction.customer_id
credit_notes.allocations.invoice_id = events.content.invoice.id
credit_notes.reference_invoice_id = events.content.invoice.id
credit_notes.allocations.invoice_id = events.content.transaction.linked_credit_notes.cn_reference_invoice_id
credit_notes.reference_invoice_id = events.content.transaction.linked_credit_notes.cn_reference_invoice_id
credit_notes.line_item_discounts.line_item_id = events.content.invoice.line_item_discounts.line_item_id
credit_notes.line_item_taxes.line_item_id = events.content.invoice.line_item_discounts.line_item_id
credit_notes.line_item_tiers.line_item_id = events.content.invoice.line_item_discounts.line_item_id
credit_notes.line_items.id = events.content.invoice.line_item_discounts.line_item_id
credit_notes.line_item_discounts.line_item_id = events.content.invoice.line_item_taxes.line_item_id
credit_notes.line_item_taxes.line_item_id = events.content.invoice.line_item_taxes.line_item_id
credit_notes.line_item_tiers.line_item_id = events.content.invoice.line_item_taxes.line_item_id
credit_notes.line_items.id = events.content.invoice.line_item_taxes.line_item_id
credit_notes.line_item_discounts.line_item_id = events.content.invoice.line_items.id
credit_notes.line_item_taxes.line_item_id = events.content.invoice.line_items.id
credit_notes.line_item_tiers.line_item_id = events.content.invoice.line_items.id
credit_notes.line_items.id = events.content.invoice.line_items.id
credit_notes.subscription_id = events.content.subscription.id
credit_notes.line_items.subscription_id = events.content.subscription.id
credit_notes.subscription_id = events.content.invoice.subscription_id
credit_notes.line_items.subscription_id = events.content.invoice.subscription_id
credit_notes.subscription_id = events.content.transaction.subscription_id
credit_notes.line_items.subscription_id = events.content.transaction.subscription_id
credit_notes.linked_refunds.txn_id = events.content.invoice.linked_payments.txn_id
credit_notes.linked_refunds.txn_id = events.content.transaction.id
credit_notes.linked_refunds.txn_id = events.content.transaction.linked_refunds.txn_id
credit_notes.linked_refunds.txn_id = events.content.transaction.reference_transaction_id
credit_notes.linked_refunds.txn_id = events.content.transaction.refunded_txn_id
invoices
credit_notes.discounts.entity_id = invoices.discounts.entity_id
credit_notes.line_item_discounts.coupon_id = invoices.discounts.entity_id
credit_notes.discounts.entity_id = invoices.line_item_discounts.coupon_id
credit_notes.line_item_discounts.coupon_id = invoices.line_item_discounts.coupon_id
credit_notes.discounts.entity_id = invoices.notes.entity_id
credit_notes.line_item_discounts.coupon_id = invoices.notes.entity_id
credit_notes.id = invoices.adjustment_credit_notes.cn_id
credit_notes.id = invoices.applied_credits.cn_id
credit_notes.id = invoices.issued_credit_notes.cn_id
credit_notes.customer_id = invoices.customer_id
credit_notes.customer_id = invoices.notes.entity_id
credit_notes.allocations.invoice_id = invoices.id
credit_notes.reference_invoice_id = invoices.id
credit_notes.line_item_discounts.line_item_id = invoices.line_item_discounts.line_item_id
credit_notes.line_item_taxes.line_item_id = invoices.line_item_discounts.line_item_id
credit_notes.line_item_tiers.line_item_id = invoices.line_item_discounts.line_item_id
credit_notes.line_items.id = invoices.line_item_discounts.line_item_id
credit_notes.line_item_discounts.line_item_id = invoices.line_item_taxes.line_item_id
credit_notes.line_item_taxes.line_item_id = invoices.line_item_taxes.line_item_id
credit_notes.line_item_tiers.line_item_id = invoices.line_item_taxes.line_item_id
credit_notes.line_items.id = invoices.line_item_taxes.line_item_id
credit_notes.line_item_discounts.line_item_id = invoices.line_item_tiers.line_item_id
credit_notes.line_item_taxes.line_item_id = invoices.line_item_tiers.line_item_id
credit_notes.line_item_tiers.line_item_id = invoices.line_item_tiers.line_item_id
credit_notes.line_items.id = invoices.line_item_tiers.line_item_id
credit_notes.line_item_discounts.line_item_id = invoices.line_items.id
credit_notes.line_item_taxes.line_item_id = invoices.line_items.id
credit_notes.line_item_tiers.line_item_id = invoices.line_items.id
credit_notes.line_items.id = invoices.line_items.id
credit_notes.subscription_id = invoices.line_items.subscription_id
credit_notes.line_items.subscription_id = invoices.line_items.subscription_id
credit_notes.subscription_id = invoices.notes.entity_id
credit_notes.line_items.subscription_id = invoices.notes.entity_id
credit_notes.subscription_id = invoices.subscription_id
credit_notes.line_items.subscription_id = invoices.subscription_id
credit_notes.linked_refunds.txn_id = invoices.linked_payments.txn_id
subscriptions
credit_notes.discounts.entity_id = subscriptions.coupons.coupon_id
credit_notes.line_item_discounts.coupon_id = subscriptions.coupons.coupon_id
credit_notes.customer_id = subscriptions.customer_id
credit_notes.subscription_id = subscriptions.id
credit_notes.line_items.subscription_id = subscriptions.id
orders
credit_notes.discounts.entity_id = orders.line_item_discounts.coupon_id
credit_notes.line_item_discounts.coupon_id = orders.line_item_discounts.coupon_id
credit_notes.id = orders.linked_credit_notes.id
credit_notes.customer_id = orders.customer_id
credit_notes.allocations.invoice_id = orders.invoice_id
credit_notes.reference_invoice_id = orders.invoice_id
credit_notes.line_item_discounts.line_item_id = orders.line_item_discounts.line_item_id
credit_notes.line_item_taxes.line_item_id = orders.line_item_discounts.line_item_id
credit_notes.line_item_tiers.line_item_id = orders.line_item_discounts.line_item_id
credit_notes.line_items.id = orders.line_item_discounts.line_item_id
credit_notes.line_item_discounts.line_item_id = orders.line_item_taxes.line_item_id
credit_notes.line_item_taxes.line_item_id = orders.line_item_taxes.line_item_id
credit_notes.line_item_tiers.line_item_id = orders.line_item_taxes.line_item_id
credit_notes.line_items.id = orders.line_item_taxes.line_item_id
credit_notes.subscription_id = orders.subscription_id
credit_notes.line_items.subscription_id = orders.subscription_id
customers
credit_notes.customer_id = customers.id
payment_sources
credit_notes.customer_id = payment_sources.customer_id
promotional_credits
credit_notes.customer_id = promotional_credits.customer_id
transactions
credit_notes.customer_id = transactions.customer_id
credit_notes.allocations.invoice_id = transactions.linked_credit_notes.cn_reference_invoice_id
credit_notes.reference_invoice_id = transactions.linked_credit_notes.cn_reference_invoice_id
credit_notes.subscription_id = transactions.subscription_id
credit_notes.line_items.subscription_id = transactions.subscription_id
credit_notes.linked_refunds.txn_id = transactions.id
credit_notes.linked_refunds.txn_id = transactions.linked_refunds.txn_id
credit_notes.linked_refunds.txn_id = transactions.reference_transaction_id
credit_notes.linked_refunds.txn_id = transactions.refunded_txn_id
virtual_bank_accounts
credit_notes.customer_id = virtual_bank_accounts.customer_id
gifts
credit_notes.customer_id = gifts.gift_receiver.customer_id
credit_notes.customer_id = gifts.gifter.customer_id
credit_notes.allocations.invoice_id = gifts.gifter.invoice_id
credit_notes.reference_invoice_id = gifts.gifter.invoice_id
credit_notes.subscription_id = gifts.gift_receiver.subscription_id
credit_notes.line_items.subscription_id = gifts.gift_receiver.subscription_id

allocations

ARRAY

allocated_amount

INTEGER

allocated_at

DATE-TIME

invoice_date

DATE-TIME

invoice_id

STRING

invoice_status

STRING

amount_allocated

INTEGER

amount_available

INTEGER

amount_refunded

INTEGER

base_currency_code

STRING

channel

STRING

create_reason_code

STRING

currency_code

STRING

customer_id

STRING

date

DATE-TIME

deleted

BOOLEAN

discounts

ARRAY

amount

INTEGER

description

STRING

entity_id

STRING

entity_type

STRING

object

STRING

einvoice

OBJECT

id

STRING

message

STRING

status

STRING

exchange_rate

NUMBER

fractional_correction

INTEGER

generated_at

DATE-TIME

id

STRING

line_item_discounts

ARRAY

coupon_id

STRING

discount_amount

INTEGER

discount_type

STRING

entity_id

STRING

line_item_id

STRING

object

STRING

line_item_taxes

ARRAY

is_non_compliance_tax

BOOLEAN

is_partial_tax_applied

BOOLEAN

line_item_id

STRING

local_currency_code

STRING

tax_amount

INTEGER

tax_amount_in_local_currency

INTEGER

tax_juris_code

STRING

tax_juris_name

STRING

tax_juris_type

STRING

tax_name

STRING

tax_rate

NUMBER

taxable_amount

INTEGER

line_item_tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

line_item_id

STRING

quantity_used

INTEGER

quantity_used_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

unit_amount

INTEGER

unit_amount_in_decimal

STRING

line_items

ARRAY

amount

INTEGER

amount_in_decimal

STRING

customer_id

STRING

date_from

DATE-TIME

date_to

DATE-TIME

description

STRING

discount_amount

INTEGER

entity_description

STRING

entity_id

STRING

entity_type

STRING

id

STRING

is_taxed

BOOLEAN

item_level_discount_amount

INTEGER

object

STRING

pricing_model

STRING

quantity

INTEGER

quantity_in_decimal

STRING

subscription_id

STRING

tax_amount

INTEGER

tax_exempt_reason

STRING

tax_rate

NUMBER

unit_amount

INTEGER

unit_amount_in_decimal

STRING

linked_refunds

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

refund_reason_code

STRING

txn_amount

INTEGER

txn_date

DATE-TIME

txn_id

STRING

txn_status

STRING

local_currency_code

STRING

object

STRING

price_type

STRING

reason_code

STRING

reference_invoice_id

STRING

refunded_at

DATE-TIME

resource_version

INTEGER

round_off_amount

INTEGER

status

STRING

sub_total

INTEGER

sub_total_in_local_currency

INTEGER

subscription_id

STRING

taxes

ARRAY

amount

INTEGER

description

STRING

name

STRING

total

INTEGER

total_in_local_currency

INTEGER

type

STRING

updated_at

DATE-TIME

vat_number

STRING

vat_number_prefix

STRING

voided_at

DATE-TIME

customers

The customers table contains info about the customers in your Chargebee account.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

customers schema on GitHub

Chargebee API method

Join customers with on
credit_notes
customers.id = credit_notes.customer_id
events
customers.id = events.content.customer.id
customers.id = events.content.invoice.customer_id
customers.id = events.content.subscription.customer_id
customers.id = events.content.transaction.customer_id
customers.primary_payment_source_id = events.content.subscription.payment_source_id
customers.primary_payment_source_id = events.content.transaction.payment_source_id
invoices
customers.id = invoices.customer_id
customers.id = invoices.notes.entity_id
payment_sources
customers.id = payment_sources.customer_id
customers.primary_payment_source_id = payment_sources.id
promotional_credits
customers.id = promotional_credits.customer_id
subscriptions
customers.id = subscriptions.customer_id
customers.primary_payment_source_id = subscriptions.payment_source_id
transactions
customers.id = transactions.customer_id
customers.primary_payment_source_id = transactions.payment_source_id
virtual_bank_accounts
customers.id = virtual_bank_accounts.customer_id
gifts
customers.id = gifts.gift_receiver.customer_id
customers.id = gifts.gifter.customer_id
orders
customers.id = orders.customer_id

allow_direct_debit

BOOLEAN

auto_close_invoices

BOOLEAN

auto_collection

STRING

backup_payment_source_id

STRING

balances

ARRAY

balance_currency_code

STRING

currency_code

STRING

excess_payments

INTEGER

object

STRING

promotional_credits

INTEGER

refundable_credits

INTEGER

unbilled_charges

INTEGER

billing_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

billing_date

BOOLEAN

billing_date_mode

STRING

billing_day_of_week

BOOLEAN

billing_day_of_week_mode

STRING

business_customer_without_vat_number

BOOLEAN

business_entity_id

STRING

card_status

STRING

cf_company_id

INTEGER, STRING

cf_people_id

STRING

channel

STRING

child_account_access

OBJECT

portal_download_invoices

STRING

portal_edit_subscriptions

STRING

send_invoice_emails

BOOLEAN

send_payment_emails

BOOLEAN

send_subscription_emails

BOOLEAN

client_profile_id

STRING

company

STRING

consolidated_invoicing

BOOLEAN

contacts

ARRAY

email

STRING

enabled

BOOLEAN

first_name

STRING

id

STRING

label

STRING

last_name

STRING

object

STRING

phone

STRING

send_account_email

STRING

send_billing_email

STRING

created_at

DATE-TIME

created_from_ip

STRING

custom_fields

STRING

customer_type

STRING

deleted

BOOLEAN

email

STRING

entity_code

STRING

entity_identifier_scheme

STRING

entity_identifier_standard

STRING

entity_identifiers

ARRAY

id

STRING

scheme

STRING

standard

STRING

value

STRING

excess_payments

INTEGER

exempt_number

STRING

exemption_details

STRING

first_name

STRING

fraud_flag

STRING

id

STRING

invoice_notes

STRING

is_einvoice_enabled

BOOLEAN

is_location_valid

BOOLEAN

last_name

STRING

locale

STRING

meta_data

STRING

mrr

INTEGER

net_term_days

INTEGER

object

STRING

offline_payment_method

STRING

parent_account_access

OBJECT

portal_download_child_invoices

STRING

portal_edit_child_subscriptions

STRING

send_invoice_emails

BOOLEAN

send_payment_emails

BOOLEAN

send_subscription_emails

BOOLEAN

payment_method

OBJECT

gateway

STRING

gateway_account_id

STRING

object

STRING

reference_id

STRING

status

STRING

type

STRING

phone

STRING

pii_cleared

STRING

preferred_currency_code

STRING

primary_payment_source_id

STRING

promotional_credits

INTEGER

referral_urls

ARRAY

created_at

DATE-TIME

external_customer_id

STRING

referral_account_id

STRING

referral_campaign_id

STRING

referral_external_account_id

STRING

referral_sharing_url

STRING

referral_system

STRING

updated_at

DATE-TIME

refundable_credits

INTEGER

registered_for_gst

BOOLEAN

relationship

OBJECT

invoice_owner_id

STRING

parent_id

STRING

payment_owner_id

STRING

root_id

STRING

resource_version

INTEGER

tax_providers_fields

STRING

taxability

STRING

unbilled_charges

INTEGER

updated_at

DATE-TIME

use_default_hierarchy_settings

BOOLEAN

vat_number

STRING

vat_number_prefix

STRING

vat_number_status

STRING

vat_number_validated_time

DATE-TIME

events

The events table contains info about the events that have occurred on your Chargebee site. Event records contain data about affected resources and additional details, such as when the change occurred. This can be used to create a log of events for a record and analyze how it has changed over time.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

occurred_at

Useful links

Chargebee documentation

events schema on GitHub

Chargebee API method

Join events with on
coupons
events.content.coupon.id = coupons.id
events.content.invoice.discounts.entity_id = coupons.id
events.content.invoice.line_item_discounts.coupon_id = coupons.id
events.content.subscription.coupons.coupon_id = coupons.id
credit_notes
events.content.coupon.id = credit_notes.discounts.entity_id
events.content.invoice.discounts.entity_id = credit_notes.discounts.entity_id
events.content.invoice.line_item_discounts.coupon_id = credit_notes.discounts.entity_id
events.content.subscription.coupons.coupon_id = credit_notes.discounts.entity_id
events.content.coupon.id = credit_notes.line_item_discounts.coupon_id
events.content.invoice.discounts.entity_id = credit_notes.line_item_discounts.coupon_id
events.content.invoice.line_item_discounts.coupon_id = credit_notes.line_item_discounts.coupon_id
events.content.subscription.coupons.coupon_id = credit_notes.line_item_discounts.coupon_id
events.content.invoice.adjustment_credit_notes.cn_id = credit_notes.id
events.content.invoice.applied_credits.cn_id = credit_notes.id
events.content.invoice.issued_credit_notes.cn_id = credit_notes.id
events.content.customer.id = credit_notes.customer_id
events.content.invoice.customer_id = credit_notes.customer_id
events.content.subscription.customer_id = credit_notes.customer_id
events.content.transaction.customer_id = credit_notes.customer_id
events.content.invoice.id = credit_notes.allocations.invoice_id
events.content.transaction.linked_credit_notes.cn_reference_invoice_id = credit_notes.allocations.invoice_id
events.content.invoice.id = credit_notes.reference_invoice_id
events.content.transaction.linked_credit_notes.cn_reference_invoice_id = credit_notes.reference_invoice_id
events.content.invoice.line_item_discounts.line_item_id = credit_notes.line_item_discounts.line_item_id
events.content.invoice.line_item_taxes.line_item_id = credit_notes.line_item_discounts.line_item_id
events.content.invoice.line_items.id = credit_notes.line_item_discounts.line_item_id
events.content.invoice.line_item_discounts.line_item_id = credit_notes.line_item_taxes.line_item_id
events.content.invoice.line_item_taxes.line_item_id = credit_notes.line_item_taxes.line_item_id
events.content.invoice.line_items.id = credit_notes.line_item_taxes.line_item_id
events.content.invoice.line_item_discounts.line_item_id = credit_notes.line_item_tiers.line_item_id
events.content.invoice.line_item_taxes.line_item_id = credit_notes.line_item_tiers.line_item_id
events.content.invoice.line_items.id = credit_notes.line_item_tiers.line_item_id
events.content.invoice.line_item_discounts.line_item_id = credit_notes.line_items.id
events.content.invoice.line_item_taxes.line_item_id = credit_notes.line_items.id
events.content.invoice.line_items.id = credit_notes.line_items.id
events.content.subscription.id = credit_notes.subscription_id
events.content.invoice.subscription_id = credit_notes.subscription_id
events.content.transaction.subscription_id = credit_notes.subscription_id
events.content.subscription.id = credit_notes.line_items.subscription_id
events.content.invoice.subscription_id = credit_notes.line_items.subscription_id
events.content.transaction.subscription_id = credit_notes.line_items.subscription_id
events.content.invoice.linked_payments.txn_id = credit_notes.linked_refunds.txn_id
events.content.transaction.id = credit_notes.linked_refunds.txn_id
events.content.transaction.linked_refunds.txn_id = credit_notes.linked_refunds.txn_id
events.content.transaction.reference_transaction_id = credit_notes.linked_refunds.txn_id
events.content.transaction.refunded_txn_id = credit_notes.linked_refunds.txn_id
invoices
events.content.coupon.id = invoices.discounts.entity_id
events.content.invoice.discounts.entity_id = invoices.discounts.entity_id
events.content.invoice.line_item_discounts.coupon_id = invoices.discounts.entity_id
events.content.subscription.coupons.coupon_id = invoices.discounts.entity_id
events.content.coupon.id = invoices.line_item_discounts.coupon_id
events.content.invoice.discounts.entity_id = invoices.line_item_discounts.coupon_id
events.content.invoice.line_item_discounts.coupon_id = invoices.line_item_discounts.coupon_id
events.content.subscription.coupons.coupon_id = invoices.line_item_discounts.coupon_id
events.content.coupon.id = invoices.notes.entity_id
events.content.invoice.discounts.entity_id = invoices.notes.entity_id
events.content.invoice.line_item_discounts.coupon_id = invoices.notes.entity_id
events.content.subscription.coupons.coupon_id = invoices.notes.entity_id
events.content.invoice.adjustment_credit_notes.cn_id = invoices.adjustment_credit_notes.cn_id
events.content.invoice.applied_credits.cn_id = invoices.adjustment_credit_notes.cn_id
events.content.invoice.issued_credit_notes.cn_id = invoices.adjustment_credit_notes.cn_id
events.content.invoice.adjustment_credit_notes.cn_id = invoices.applied_credits.cn_id
events.content.invoice.applied_credits.cn_id = invoices.applied_credits.cn_id
events.content.invoice.issued_credit_notes.cn_id = invoices.applied_credits.cn_id
events.content.invoice.adjustment_credit_notes.cn_id = invoices.issued_credit_notes.cn_id
events.content.invoice.applied_credits.cn_id = invoices.issued_credit_notes.cn_id
events.content.invoice.issued_credit_notes.cn_id = invoices.issued_credit_notes.cn_id
events.content.customer.id = invoices.customer_id
events.content.invoice.customer_id = invoices.customer_id
events.content.subscription.customer_id = invoices.customer_id
events.content.transaction.customer_id = invoices.customer_id
events.content.customer.id = invoices.notes.entity_id
events.content.invoice.customer_id = invoices.notes.entity_id
events.content.subscription.customer_id = invoices.notes.entity_id
events.content.transaction.customer_id = invoices.notes.entity_id
events.content.invoice.id = invoices.id
events.content.transaction.linked_credit_notes.cn_reference_invoice_id = invoices.id
events.content.invoice.line_item_discounts.line_item_id = invoices.line_item_discounts.line_item_id
events.content.invoice.line_item_taxes.line_item_id = invoices.line_item_discounts.line_item_id
events.content.invoice.line_items.id = invoices.line_item_discounts.line_item_id
events.content.invoice.line_item_discounts.line_item_id = invoices.line_item_taxes.line_item_id
events.content.invoice.line_item_taxes.line_item_id = invoices.line_item_taxes.line_item_id
events.content.invoice.line_items.id = invoices.line_item_taxes.line_item_id
events.content.invoice.line_item_discounts.line_item_id = invoices.line_item_tiers.line_item_id
events.content.invoice.line_item_taxes.line_item_id = invoices.line_item_tiers.line_item_id
events.content.invoice.line_items.id = invoices.line_item_tiers.line_item_id
events.content.invoice.line_item_discounts.line_item_id = invoices.line_items.id
events.content.invoice.line_item_taxes.line_item_id = invoices.line_items.id
events.content.invoice.line_items.id = invoices.line_items.id
events.content.subscription.id = invoices.line_items.subscription_id
events.content.invoice.subscription_id = invoices.line_items.subscription_id
events.content.transaction.subscription_id = invoices.line_items.subscription_id
events.content.subscription.id = invoices.notes.entity_id
events.content.invoice.subscription_id = invoices.notes.entity_id
events.content.transaction.subscription_id = invoices.notes.entity_id
events.content.subscription.id = invoices.subscription_id
events.content.invoice.subscription_id = invoices.subscription_id
events.content.transaction.subscription_id = invoices.subscription_id
events.content.invoice.linked_payments.txn_id = invoices.linked_payments.txn_id
events.content.transaction.id = invoices.linked_payments.txn_id
events.content.transaction.linked_refunds.txn_id = invoices.linked_payments.txn_id
events.content.transaction.reference_transaction_id = invoices.linked_payments.txn_id
events.content.transaction.refunded_txn_id = invoices.linked_payments.txn_id
subscriptions
events.content.coupon.id = subscriptions.coupons.coupon_id
events.content.invoice.discounts.entity_id = subscriptions.coupons.coupon_id
events.content.invoice.line_item_discounts.coupon_id = subscriptions.coupons.coupon_id
events.content.subscription.coupons.coupon_id = subscriptions.coupons.coupon_id
events.content.customer.id = subscriptions.customer_id
events.content.invoice.customer_id = subscriptions.customer_id
events.content.subscription.customer_id = subscriptions.customer_id
events.content.transaction.customer_id = subscriptions.customer_id
events.content.subscription.payment_source_id = subscriptions.payment_source_id
events.content.transaction.payment_source_id = subscriptions.payment_source_id
events.content.subscription.id = subscriptions.id
events.content.invoice.subscription_id = subscriptions.id
events.content.transaction.subscription_id = subscriptions.id
orders
events.content.coupon.id = orders.line_item_discounts.coupon_id
events.content.invoice.discounts.entity_id = orders.line_item_discounts.coupon_id
events.content.invoice.line_item_discounts.coupon_id = orders.line_item_discounts.coupon_id
events.content.subscription.coupons.coupon_id = orders.line_item_discounts.coupon_id
events.content.invoice.adjustment_credit_notes.cn_id = orders.linked_credit_notes.id
events.content.invoice.applied_credits.cn_id = orders.linked_credit_notes.id
events.content.invoice.issued_credit_notes.cn_id = orders.linked_credit_notes.id
events.content.customer.id = orders.customer_id
events.content.invoice.customer_id = orders.customer_id
events.content.subscription.customer_id = orders.customer_id
events.content.transaction.customer_id = orders.customer_id
events.content.invoice.id = orders.invoice_id
events.content.transaction.linked_credit_notes.cn_reference_invoice_id = orders.invoice_id
events.content.invoice.line_item_discounts.line_item_id = orders.line_item_discounts.line_item_id
events.content.invoice.line_item_taxes.line_item_id = orders.line_item_discounts.line_item_id
events.content.invoice.line_items.id = orders.line_item_discounts.line_item_id
events.content.invoice.line_item_discounts.line_item_id = orders.line_item_taxes.line_item_id
events.content.invoice.line_item_taxes.line_item_id = orders.line_item_taxes.line_item_id
events.content.invoice.line_items.id = orders.line_item_taxes.line_item_id
events.content.subscription.id = orders.subscription_id
events.content.invoice.subscription_id = orders.subscription_id
events.content.transaction.subscription_id = orders.subscription_id
customers
events.content.customer.id = customers.id
events.content.invoice.customer_id = customers.id
events.content.subscription.customer_id = customers.id
events.content.transaction.customer_id = customers.id
events.content.subscription.payment_source_id = customers.primary_payment_source_id
events.content.transaction.payment_source_id = customers.primary_payment_source_id
payment_sources
events.content.customer.id = payment_sources.customer_id
events.content.invoice.customer_id = payment_sources.customer_id
events.content.subscription.customer_id = payment_sources.customer_id
events.content.transaction.customer_id = payment_sources.customer_id
events.content.subscription.payment_source_id = payment_sources.id
events.content.transaction.payment_source_id = payment_sources.id
promotional_credits
events.content.customer.id = promotional_credits.customer_id
events.content.invoice.customer_id = promotional_credits.customer_id
events.content.subscription.customer_id = promotional_credits.customer_id
events.content.transaction.customer_id = promotional_credits.customer_id
transactions
events.content.customer.id = transactions.customer_id
events.content.invoice.customer_id = transactions.customer_id
events.content.subscription.customer_id = transactions.customer_id
events.content.transaction.customer_id = transactions.customer_id
events.content.invoice.id = transactions.linked_credit_notes.cn_reference_invoice_id
events.content.transaction.linked_credit_notes.cn_reference_invoice_id = transactions.linked_credit_notes.cn_reference_invoice_id
events.content.subscription.payment_source_id = transactions.payment_source_id
events.content.transaction.payment_source_id = transactions.payment_source_id
events.content.subscription.id = transactions.subscription_id
events.content.invoice.subscription_id = transactions.subscription_id
events.content.transaction.subscription_id = transactions.subscription_id
events.content.invoice.linked_payments.txn_id = transactions.id
events.content.transaction.id = transactions.id
events.content.transaction.linked_refunds.txn_id = transactions.id
events.content.transaction.reference_transaction_id = transactions.id
events.content.transaction.refunded_txn_id = transactions.id
events.content.invoice.linked_payments.txn_id = transactions.linked_refunds.txn_id
events.content.transaction.id = transactions.linked_refunds.txn_id
events.content.transaction.linked_refunds.txn_id = transactions.linked_refunds.txn_id
events.content.transaction.reference_transaction_id = transactions.linked_refunds.txn_id
events.content.transaction.refunded_txn_id = transactions.linked_refunds.txn_id
events.content.invoice.linked_payments.txn_id = transactions.reference_transaction_id
events.content.transaction.id = transactions.reference_transaction_id
events.content.transaction.linked_refunds.txn_id = transactions.reference_transaction_id
events.content.transaction.reference_transaction_id = transactions.reference_transaction_id
events.content.transaction.refunded_txn_id = transactions.reference_transaction_id
events.content.invoice.linked_payments.txn_id = transactions.refunded_txn_id
events.content.transaction.id = transactions.refunded_txn_id
events.content.transaction.linked_refunds.txn_id = transactions.refunded_txn_id
events.content.transaction.reference_transaction_id = transactions.refunded_txn_id
events.content.transaction.refunded_txn_id = transactions.refunded_txn_id
virtual_bank_accounts
events.content.customer.id = virtual_bank_accounts.customer_id
events.content.invoice.customer_id = virtual_bank_accounts.customer_id
events.content.subscription.customer_id = virtual_bank_accounts.customer_id
events.content.transaction.customer_id = virtual_bank_accounts.customer_id
gifts
events.content.customer.id = gifts.gift_receiver.customer_id
events.content.invoice.customer_id = gifts.gift_receiver.customer_id
events.content.subscription.customer_id = gifts.gift_receiver.customer_id
events.content.transaction.customer_id = gifts.gift_receiver.customer_id
events.content.customer.id = gifts.gifter.customer_id
events.content.invoice.customer_id = gifts.gifter.customer_id
events.content.subscription.customer_id = gifts.gifter.customer_id
events.content.transaction.customer_id = gifts.gifter.customer_id
events.content.invoice.id = gifts.gifter.invoice_id
events.content.transaction.linked_credit_notes.cn_reference_invoice_id = gifts.gifter.invoice_id
events.content.subscription.id = gifts.gift_receiver.subscription_id
events.content.invoice.subscription_id = gifts.gift_receiver.subscription_id
events.content.transaction.subscription_id = gifts.gift_receiver.subscription_id

api_version

STRING

content

OBJECT

coupon

OBJECT

apply_discount_on

STRING

apply_on

STRING

archived_at

DATE-TIME

created_at

DATE-TIME

currency_code

STRING

discount_amount

NUMBER

discount_percentage

NUMBER

discount_type

STRING

duration_month

INTEGER

duration_type

STRING

id

STRING

invoice_name

STRING

invoice_notes

STRING

item_constraint_criteria

ARRAY

currencies

ARRAY

item_family_ids

ARRAY

item_price_periods

ARRAY

item_type

STRING

item_constraints

ARRAY

constraint

STRING

item_price_ids

ARRAY

item_type

STRING

max_redemptions

INTEGER

meta_data

STRING

name

STRING

object

STRING

period

INTEGER

period_unit

STRING

redemptions

INTEGER

resource_version

INTEGER

status

STRING

updated_at

DATE-TIME

valid_till

DATE-TIME

coupon_code

OBJECT

code

STRING

coupon_id

STRING

coupon_set_id

STRING

coupon_set_name

STRING

coupon_site_id

STRING

status

STRING

coupon_set

OBJECT

archived_count

INTEGER

coupon_id

STRING

id

STRING

meta_data

STRING

name

STRING

redeemed_count

INTEGER

total_count

INTEGER

credit_note

OBJECT

allocations

ARRAY

allocated_amount

INTEGER

allocated_at

DATE-TIME

invoice_date

DATE-TIME

invoice_id

STRING

invoice_status

STRING

amount_allocated

INTEGER

amount_available

INTEGER

amount_refunded

INTEGER

base_currency_code

STRING

channel

STRING

create_reason_code

STRING

currency_code

STRING

customer_id

STRING

date

DATE-TIME

deleted

BOOLEAN

discounts

ARRAY

amount

INTEGER

description

STRING

entity_id

STRING

entity_type

STRING

object

STRING

einvoice

OBJECT

id

STRING

message

STRING

status

STRING

exchange_rate

NUMBER

fractional_correction

INTEGER

generated_at

DATE-TIME

id

STRING

line_item_discounts

ARRAY

coupon_id

STRING

discount_amount

INTEGER

discount_type

STRING

entity_id

STRING

line_item_id

STRING

object

STRING

line_item_taxes

ARRAY

is_non_compliance_tax

BOOLEAN

is_partial_tax_applied

BOOLEAN

line_item_id

STRING

local_currency_code

STRING

tax_amount

INTEGER

tax_amount_in_local_currency

INTEGER

tax_juris_code

STRING

tax_juris_name

STRING

tax_juris_type

STRING

tax_name

STRING

tax_rate

NUMBER

taxable_amount

INTEGER

line_item_tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

line_item_id

STRING

quantity_used

INTEGER

quantity_used_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

unit_amount

INTEGER

unit_amount_in_decimal

STRING

line_items

ARRAY

amount

INTEGER

amount_in_decimal

STRING

customer_id

STRING

date_from

DATE-TIME

date_to

DATE-TIME

description

STRING

discount_amount

INTEGER

entity_description

STRING

entity_id

STRING

entity_type

STRING

id

STRING

is_taxed

BOOLEAN

item_level_discount_amount

INTEGER

object

STRING

pricing_model

STRING

quantity

INTEGER

quantity_in_decimal

STRING

subscription_id

STRING

tax_amount

INTEGER

tax_exempt_reason

STRING

tax_rate

NUMBER

unit_amount

INTEGER

unit_amount_in_decimal

STRING

linked_refunds

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

refund_reason_code

STRING

txn_amount

INTEGER

txn_date

DATE-TIME

txn_id

STRING

txn_status

STRING

local_currency_code

STRING

object

STRING

price_type

STRING

reason_code

STRING

reference_invoice_id

STRING

refunded_at

DATE-TIME

resource_version

INTEGER

round_off_amount

INTEGER

status

STRING

sub_total

INTEGER

sub_total_in_local_currency

INTEGER

subscription_id

STRING

taxes

ARRAY

amount

INTEGER

description

STRING

name

STRING

total

INTEGER

total_in_local_currency

INTEGER

type

STRING

updated_at

DATE-TIME

vat_number

STRING

vat_number_prefix

STRING

voided_at

DATE-TIME

customer

OBJECT

allow_direct_debit

BOOLEAN

auto_close_invoices

BOOLEAN

auto_collection

STRING

backup_payment_source_id

STRING

balances

ARRAY

balance_currency_code

STRING

currency_code

STRING

excess_payments

INTEGER

object

STRING

promotional_credits

INTEGER

refundable_credits

INTEGER

unbilled_charges

INTEGER

billing_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

billing_date

BOOLEAN

billing_date_mode

STRING

billing_day_of_week

BOOLEAN

billing_day_of_week_mode

STRING

business_customer_without_vat_number

BOOLEAN

business_entity_id

STRING

card_status

STRING

cf_company_id

INTEGER, STRING

cf_people_id

STRING

channel

STRING

child_account_access

OBJECT

portal_download_invoices

STRING

portal_edit_subscriptions

STRING

send_invoice_emails

BOOLEAN

send_payment_emails

BOOLEAN

send_subscription_emails

BOOLEAN

client_profile_id

STRING

company

STRING

consolidated_invoicing

BOOLEAN

contacts

ARRAY

email

STRING

enabled

BOOLEAN

first_name

STRING

id

STRING

label

STRING

last_name

STRING

object

STRING

phone

STRING

send_account_email

STRING

send_billing_email

STRING

created_at

DATE-TIME

created_from_ip

STRING

custom_fields

STRING

customer_type

STRING

deleted

BOOLEAN

email

STRING

entity_code

STRING

entity_identifier_scheme

STRING

entity_identifier_standard

STRING

entity_identifiers

ARRAY

id

STRING

scheme

STRING

standard

STRING

value

STRING

excess_payments

INTEGER

exempt_number

STRING

exemption_details

STRING

first_name

STRING

fraud_flag

STRING

id

STRING

invoice_notes

STRING

is_einvoice_enabled

BOOLEAN

is_location_valid

BOOLEAN

last_name

STRING

locale

STRING

meta_data

STRING

mrr

INTEGER

net_term_days

INTEGER

object

STRING

offline_payment_method

STRING

parent_account_access

OBJECT

portal_download_child_invoices

STRING

portal_edit_child_subscriptions

STRING

send_invoice_emails

BOOLEAN

send_payment_emails

BOOLEAN

send_subscription_emails

BOOLEAN

payment_method

OBJECT

gateway

STRING

gateway_account_id

STRING

object

STRING

reference_id

STRING

status

STRING

type

STRING

phone

STRING

pii_cleared

STRING

preferred_currency_code

STRING

primary_payment_source_id

STRING

promotional_credits

INTEGER

referral_urls

ARRAY

created_at

DATE-TIME

external_customer_id

STRING

referral_account_id

STRING

referral_campaign_id

STRING

referral_external_account_id

STRING

referral_sharing_url

STRING

referral_system

STRING

updated_at

DATE-TIME

refundable_credits

INTEGER

registered_for_gst

BOOLEAN

relationship

OBJECT

invoice_owner_id

STRING

parent_id

STRING

payment_owner_id

STRING

root_id

STRING

resource_version

INTEGER

tax_providers_fields

STRING

taxability

STRING

unbilled_charges

INTEGER

updated_at

DATE-TIME

use_default_hierarchy_settings

BOOLEAN

vat_number

STRING

vat_number_prefix

STRING

vat_number_status

STRING

vat_number_validated_time

DATE-TIME

gift

OBJECT

auto_claim

BOOLEAN

claim_expiry_date

DATE-TIME

gift_receiver

OBJECT

customer_id

STRING

email

STRING

first_name

STRING

last_name

STRING

subscription_id

STRING

gift_timelines

ARRAY

occurred_at

DATE-TIME

status

STRING

gifter

OBJECT

customer_id

STRING

invoice_id

STRING

note

STRING

signature

STRING

id

STRING

no_expiry

BOOLEAN

resource_version

INTEGER

scheduled_at

DATE-TIME

status

STRING

updated_at

DATE-TIME

invoice

OBJECT

adjustment_credit_notes

ARRAY

cn_create_reason_code

STRING

cn_date

DATE-TIME

cn_id

STRING

cn_reason_code

STRING

cn_status

STRING

cn_total

INTEGER

amount_adjusted

INTEGER

amount_due

INTEGER

amount_paid

INTEGER

amount_to_collect

INTEGER

applied_credits

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

cn_create_reason_code

STRING

cn_date

DATE-TIME

cn_id

STRING

cn_reason_code

STRING

cn_status

STRING

base_currency_code

STRING

billing_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

channel

STRING

credits_applied

INTEGER

currency_code

STRING

customer_id

STRING

date

DATE-TIME

deleted

BOOLEAN

discounts

ARRAY

amount

INTEGER

description

STRING

entity_id

STRING

entity_type

STRING

object

STRING

due_date

DATE-TIME

dunning_attempts

ARRAY

attempt

INTEGER

created_at

DATE-TIME

dunning_type

STRING

transaction_id

STRING

txn_amount

INTEGER

txn_status

STRING

dunning_status

STRING

einvoice

OBJECT

id

STRING

message

STRING

status

STRING

exchange_rate

NUMBER

expected_payment_date

DATE-TIME

first_invoice

BOOLEAN

generated_at

DATE-TIME

has_advance_charges

BOOLEAN

id

STRING

is_gifted

BOOLEAN

issued_credit_notes

ARRAY

cn_create_reason_code

STRING

cn_date

DATE-TIME

cn_id

STRING

cn_reason_code

STRING

cn_status

STRING

cn_total

INTEGER

line_item_discounts

ARRAY

coupon_id

STRING

discount_amount

INTEGER

discount_type

STRING

entity_id

STRING

line_item_id

STRING

object

STRING

line_item_taxes

ARRAY

is_non_compliance_tax

BOOLEAN

is_partial_tax_applied

BOOLEAN

line_item_id

STRING

local_currency_code

STRING

tax_amount

INTEGER

tax_amount_in_local_currency

INTEGER

tax_juris_code

STRING

tax_juris_name

STRING

tax_juris_type

STRING

tax_name

STRING

tax_rate

INTEGER, NUMBER

taxable_amount

INTEGER

line_item_tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

line_item_id

STRING

quantity_used

INTEGER

quantity_used_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

unit_amount

INTEGER

unit_amount_in_decimal

STRING

line_items

ARRAY

amount

INTEGER

amount_in_decimal

STRING

customer_id

STRING

date_from

DATE-TIME

date_to

DATE-TIME

description

STRING

discount_amount

INTEGER

entity_description

STRING

entity_id

STRING

entity_type

STRING

id

STRING

is_taxed

BOOLEAN

item_level_discount_amount

INTEGER

object

STRING

pricing_model

STRING

quantity

INTEGER

quantity_in_decimal

STRING

subscription_id

STRING

tax_amount

INTEGER

tax_exempt_reason

STRING

tax_rate

NUMBER

unit_amount

INTEGER

unit_amount_in_decimal

STRING

linked_orders

ARRAY

batch_id

STRING

created_at

DATE-TIME

document_number

STRING

fulfillment_status

STRING

id

STRING

order_type

STRING

reference_id

STRING

status

STRING

linked_payments

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

txn_amount

INTEGER

txn_date

DATE-TIME

txn_id

STRING

txn_status

STRING

local_currency_code

STRING

net_term_days

INTEGER

new_sales_amount

INTEGER

next_retry_at

DATE-TIME

notes

ARRAY

entity_id

STRING

entity_type

STRING

note

STRING

object

STRING

paid_at

DATE-TIME

payment_owner

STRING

po_number

STRING

price_type

STRING

recurring

BOOLEAN

resource_version

INTEGER

round_off_amount

INTEGER

shipping_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

status

STRING

sub_total

INTEGER

sub_total_in_local_currency

INTEGER

subscription_id

STRING

tax

INTEGER

taxes

ARRAY

amount

INTEGER

description

STRING

name

STRING

term_finalized

BOOLEAN

total

INTEGER

total_in_local_currency

INTEGER

updated_at

DATE-TIME

vat_number

STRING

vat_number_prefix

STRING

void_reason_code

STRING

voided_at

DATE-TIME

write_off_amount

INTEGER

item

OBJECT

applicable_items

ARRAY

archivable

BOOLEAN, STRING

archived_at

DATE-TIME

channel

STRING

custom_fields

STRING

description

STRING

enabled_for_checkout

BOOLEAN

enabled_in_portal

BOOLEAN

external_name

STRING

gift_claim_redirect_url

STRING

id

STRING

included_in_mrr

BOOLEAN

is_giftable

BOOLEAN

is_shippable

BOOLEAN

item_applicability

STRING

item_family_id

STRING

metadata

STRING

metered

BOOLEAN

name

STRING

object

STRING

redirect_url

STRING

resource_version

INTEGER

status

STRING

type

STRING

unit

STRING

updated_at

DATE-TIME

usage_calculation

STRING

item_family

OBJECT

channel

STRING

custom_fields

STRING

description

STRING

id

STRING

name

STRING

object

STRING

resource_version

INTEGER

status

STRING

updated_at

DATE-TIME

item_price

OBJECT

accounting_detail

OBJECT

accounting_category1

STRING

accounting_category2

STRING

accounting_category3

STRING

accounting_category4

STRING

accounting_code

STRING

sku

STRING

archivable

BOOLEAN, STRING

archived_at

DATE-TIME

billing_cycles

INTEGER

channel

STRING

created_at

DATE-TIME

currency_code

STRING

custom_fields

STRING

description

STRING

external_name

STRING

free_quantity

INTEGER

free_quantity_in_decimal

STRING

id

STRING

invoice_notes

STRING

is_taxable

BOOLEAN

item_family_id

STRING

item_id

STRING

item_type

STRING

metadata

STRING

name

STRING

object

STRING

period

INTEGER

period_unit

STRING

price

INTEGER

price_in_decimal

STRING

pricing_model

STRING

resource_version

INTEGER

shipping_period

INTEGER

shipping_period_unit

STRING

show_description_in_invoices

BOOLEAN

show_description_in_quotes

BOOLEAN

status

STRING

tax_detail

OBJECT

avalara_sale_type

STRING

avalara_service_type

INTEGER

avalara_tax_code

STRING

avalara_transaction_type

INTEGER

tax_profile_id

STRING

taxjar_product_code

STRING

tiers

ARRAY

ending_unit

INTEGER

price

INTEGER

starting_unit

INTEGER

trial_end_action

STRING

trial_period

INTEGER

trial_period_unit

STRING

updated_at

DATE-TIME

order

OBJECT

amount_adjusted

INTEGER

amount_paid

INTEGER

batch_id

STRING

billing_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

cancellation_reason

STRING

cancelled_at

DATE-TIME

created_at

DATE-TIME

created_by

STRING

currency_code

STRING

customer_id

STRING

deleted

BOOLEAN

delivered_at

DATE-TIME

discount

INTEGER

document_number

STRING

fulfillment_status

STRING

gift_id

STRING

gift_note

STRING

id

STRING

invoice_id

STRING

invoice_round_off_amount

INTEGER

is_gifted

BOOLEAN

is_resent

BOOLEAN

line_item_discounts

ARRAY

coupon_id

STRING

discount_amount

INTEGER

discount_type

STRING

line_item_id

STRING

line_item_taxes

ARRAY

is_non_compliance_tax

BOOLEAN

is_partial_tax_applied

BOOLEAN

line_item_id

STRING

local_currency_code

STRING

tax_amount

INTEGER

tax_amount_in_local_currency

INTEGER

tax_juris_code

STRING

tax_juris_name

STRING

tax_juris_type

STRING

tax_name

STRING

tax_rate

INTEGER, NUMBER

taxable_amount

INTEGER

linked_credit_notes

ARRAY

amount

INTEGER

amount_adjusted

INTEGER

amount_refunded

INTEGER

id

STRING

status

STRING

type

STRING

note

STRING

order_date

DATE-TIME

order_line_items

ARRAY

amount

INTEGER

amount_adjusted

INTEGER

amount_paid

INTEGER

description

STRING

discount_amount

INTEGER

entity_id

STRING

entity_type

STRING

fulfillment_amount

INTEGER

fulfillment_quantity

INTEGER

id

STRING

invoice_id

STRING

invoice_line_item_id

STRING

is_shippable

BOOLEAN

item_level_discount_amount

INTEGER

refundable_credits

INTEGER

refundable_credits_issued

INTEGER

sku

STRING

status

STRING

tax_amount

INTEGER

unit_price

INTEGER

order_type

STRING

original_order_id

STRING

paid_on

DATE-TIME

payment_status

STRING

price_type

STRING

reference_id

STRING

refundable_credits

INTEGER

refundable_credits_issued

INTEGER

resend_reason

STRING

resent_orders

ARRAY

amount

INTEGER

order_id

STRING

reason

STRING

resent_status

STRING

resource_version

INTEGER

rounding_adjustement

INTEGER

shipment_carrier

STRING

shipped_at

DATE-TIME

shipping_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status,

STRING

zip

STRING

shipping_cut_off_date

DATE-TIME

shipping_date

DATE-TIME

status

STRING

status_update_at

DATE-TIME

sub_total

INTEGER

subscription_id

STRING

tax

INTEGER

total

INTEGER

tracking_id

STRING

tracking_url

STRING

updated_at

DATE-TIME

payment_source

OBJECT

amazon_payment

OBJECT

agreement_id

STRING

email

STRING

bank_account

OBJECT

account_holder_type

STRING

account_type

STRING

bank_name

STRING

echeck_type

STRING

last4

STRING

mandate_id

STRING

name_on_account

STRING

card

OBJECT

billing_addr1

STRING

billing_addr2

STRING

billing_city

STRING

billing_country

STRING

billing_state

STRING

billing_state_code

STRING

billing_zip

STRING

brand

STRING

expiry_month

INTEGER

expiry_year

INTEGER

first_name

STRING

funding_type

STRING

iin

STRING

last4

STRING

last_name

STRING

masked_number

STRING

object

STRING

created_at

DATE-TIME

customer_id

STRING

deleted

BOOLEAN

gateway

STRING

gateway_account_id

STRING

id

STRING

ip_address

STRING

issuing_country

STRING

mandates

ARRAY

created_at

DATE-TIME

id

STRING

subscription_id

STRING

object

STRING

paypal

OBJECT

agremeent_id

STRING

email

STRING

reference_id

STRING

resource_version

INTEGER

status

STRING

type

STRING

updated_at

DATE-TIME

upi

OBJECT

vpa

STRING

promotional_credit

OBJECT

amount

STRING

amount_in_decimal

STRING

closing_balance

INTEGER

created_at

DATE-TIME

credit_type

STRING

currency_code

STRING

customer_id

STRING

description

STRING

done_by

STRING

id

STRING

object

STRING

reference

STRING

type

STRING

quote

OBJECT

amount_due

INTEGER

amount_paid

INTEGER

billing_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

charge_on_acceptance

INTEGER

contract_term_end

DATE-TIME

contract_term_start

DATE-TIME

contract_term_termination_fee

INTEGER

credits_applied

INTEGER

currency_code

STRING

customer_id

STRING

date

DATE-TIME

discounts

ARRAY

amount

INTEGER

description

STRING

entity_id

STRING

entity_type

STRING

id

STRING

invoice_id

STRING

line_item_discounts

ARRAY

coupon_id

STRING

discount_amount

INTEGER

discount_type

STRING

entity_id

STRING

line_item_id

STRING

line_item_taxes

ARRAY

is_non_compliance_tax

BOOLEAN

is_partial_tax_applied

BOOLEAN

line_item_id

STRING

local_currency_code

STRING

tax_amount

INTEGER

tax_amount_in_local_currency

INTEGER

tax_juris_code

STRING

tax_juris_name

STRING

tax_juris_type

STRING

tax_name

STRING

tax_rate

NUMBER

taxable_amount

INTEGER

line_item_tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

line_item_id

STRING

quantity_used

INTEGER

quantity_used_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

unit_amount

INTEGER

unit_amount_in_decimal

STRING

line_items

ARRAY

amount

INTEGER

amount_in_decimal

STRING

customer_id

STRING

date_from

DATE-TIME

date_to

DATE-TIME

description

STRING

discount_amount

INTEGER

entity_description

STRING

entity_id

STRING

entity_type

STRING

id

STRING

is_taxed

BOOLEAN

item_level_discount_amount

INTEGER

object

STRING

pricing_model

STRING

quantity

INTEGER

quantity_in_decimal

STRING

subscription_id

STRING

tax_amount

INTEGER

tax_exempt_reason

STRING

tax_rate

NUMBER

unit_amount

INTEGER

unit_amount_in_decimal

STRING

name

STRING

notes

ARRAY

object

STRING

operation_type

STRING

po_number

STRING

price_type

STRING

resource_version

INTEGER

shipping_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status,

STRING

zip

STRING

status

STRING

sub_total

INTEGER

subscription_id

STRING

taxes

ARRAY

amount

INTEGER

description

STRING

name

STRING

total

INTEGER

total_payable

INTEGER

updated_at

DATE-TIME

valid_till

DATE-TIME

vat_number

STRING

vat_number_prefix

STRING

version

INTEGER

subscription

OBJECT

activated_at

DATE-TIME

auto_close_invoices

BOOLEAN

auto_collection

STRING

base_currency_code

STRING

billing_period

INTEGER

billing_period_unit

STRING

cancel_reason

STRING

cancel_reason_code

STRING

cancel_schedule_created_at

DATE-TIME

cancelled_at

DATE-TIME

changes_scheduled_at

DATE-TIME

channel

STRING

charged_items

ARRAY

item_price_id

STRING

last_charged_at

DATE-TIME

object

STRING

contract_term

OBJECT

action_at_term_end

STRING

billing_cycle

INTEGER

cancellation_cutoff_period

INTEGER

contract_end

DATE-TIME

contract_start

DATE-TIME

created_at

DATE-TIME

id

STRING

remaining_billing_cycles

INTEGER

status

STRING

subscription_id

STRING

total_contract_value

INTEGER

contract_term_billing_cycle_on_renewal

INTEGER

coupon

STRING

coupons

ARRAY

applied_count

INTEGER

apply_till

DATE-TIME

coupon_code

STRING

coupon_id

STRING

object

STRING

create_pending_invoices

BOOLEAN

created_at

DATE-TIME

created_from_ip

STRING

currency_code

STRING

current_term_end

DATE-TIME

current_term_start

DATE-TIME

custom_fields

STRING

customer_id

STRING

deleted

BOOLEAN

discounts

ARRAY

amount

NUMBER

applied_count

INTEGER

apply_on

STRING

apply_till

INTEGER

coupon_id

STRING

created_at

INTEGER

currency_code

STRING

duration_type

STRING

id

STRING

included_in_mrr

BOOLEAN

index

INTEGER

invoice_name

STRING

item_price_id

STRING

name

STRING

object

STRING

percentage

NUMBER

period

INTEGER

period_unit

STRING

resource_version

INTEGER

type

STRING

updated_at

INTEGER

due_invoices_count

INTEGER

due_since

DATE-TIME

exchange_rate

NUMBER

free_period

INTEGER

free_period_unit

STRING

has_scheduled_advance_invoices

BOOLEAN

has_scheduled_changes

BOOLEAN

id

STRING

invoice_notes

STRING

item_tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

item_price_id

STRING

price

INTEGER

price_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

meta_data

STRING

mrr

INTEGER

next_billing_at

DATE-TIME

object

STRING

override_relationship

BOOLEAN

pause_date

DATE-TIME

payment_source_id

STRING

plan_amount_in_decimal

STRING

plan_free_quantity_in_decimal

STRING

plan_quantity_in_decimal

STRING

plan_unit_price_in_decimal

STRING

po_number

STRING

referral_info

OBJECT

account_id

STRING

campaign_id

STRING

coupon_code

STRING

destination_url

STRING

external_campaign_id

STRING

external_reference_id

STRING

friend_offer_type

STRING

notify_referral_system

STRING

post_purchase_widget_enabled

BOOLEAN

referral_code

STRING

referral_system

STRING

referrer_id

STRING

referrer_reward_type

STRING

reward_status

STRING

remaining_billing_cycles

INTEGER

resource_version

INTEGER

resume_date

DATE-TIME

shipping_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

start_date

DATE-TIME

started_at

DATE-TIME

status

STRING

subscription_items

ARRAY

amount

INTEGER

amount_in_decimal

STRING

billing_cycles

INTEGER

charge_on_event

STRING

charge_on_option

STRING

charge_once

BOOLEAN

free_quantity

INTEGER

free_quantity_in_decimal

STRING

item_price_id

STRING

item_type

STRING

object

STRING

quantity

INTEGER

quantity_in_decimal

STRING

service_period_days

INTEGER

trial_end

DATE-TIME

unit_price

INTEGER

unit_price_in_decimal

STRING

total_dues

INTEGER

trial_end

DATE-TIME

trial_end_action

STRING

trial_start

DATE-TIME

updated_at

DATE-TIME

transaction

OBJECT

amount

INTEGER

amount_capturable

STRING

amount_unused

INTEGER

authorization_reason

STRING

base_currency_code

STRING

currency_code

STRING

customer_id

STRING

date

DATE-TIME

deleted

BOOLEAN

error_code

STRING

error_text

STRING

exchange_rate

NUMBER

fraud_flag

STRING

fraud_reason

STRING

gateway

STRING

gateway_account_id

STRING

id

STRING

id_at_gateway

STRING

iin

STRING

initiator_type

STRING

last4

STRING

linked_credit_notes

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

cn_create_reason_code

STRING

cn_date

DATE-TIME

cn_id

STRING

cn_reason_code

STRING

cn_reference_invoice_id

STRING

cn_status

STRING

cn_total

INTEGER

linked_invoices

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

invoice_date

DATE-TIME

invoice_id

STRING

invoice_status

STRING

invoice_total

INTEGER

linked_payments

ARRAY

amount

INTEGER

date

DATE-TIME

id

STRING

status

STRING

linked_refunds

ARRAY

txn_amount

INTEGER

txn_date

DATE-TIME

txn_id

STRING

txn_status

STRING

masked_card_number

STRING

merchant_reference_id

STRING

object

STRING

payment_method

STRING

payment_source_id

STRING

reference_authorization_id

STRING

reference_number

STRING

reference_transaction_id

STRING

refunded_txn_id

STRING

resource_version

INTEGER

reversal_transaction_id

STRING

reversal_txn_id

STRING

settled_at

DATE-TIME

status

STRING

subscription_id

STRING

three_d_secure

BOOLEAN

type

STRING

updated_at

DATE-TIME

validated_at

DATE-TIME

voided_at

DATE-TIME

unbilled_charges

ARRAY

amount

INTEGER

amount_in_decimal

STRING

currency_code

STRING

customer_id

STRING

date_from

DATE-TIME

date_to

DATE-TIME

deleted

BOOLEAN

description

STRING

discount_amount

INTEGER

entity_id

STRING

entity_type

STRING

id

STRING

is_voided

BOOLEAN

pricing_model

STRING

quantity

INTEGER

quantity_in_decimal

STRING

subscription_id

STRING

tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

quantity_used

INTEGER

quantity_used_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

unit_amount

INTEGER

unit_amount_in_decimal

STRING

unit_amount

INTEGER

unit_amount_in_decimal

STRING

voided_at

DATE-TIME

virtual_bank_account

OBJECT

account_number

STRING

bank_name

STRING

created_at

DATE-TIME

customer_id

STRING

deleted

BOOLEAN

email

STRING

gateway

STRING

gateway_account_id

STRING

id

STRING

object

STRING

reference_id

STRING

resource_version

INTEGER

routing_number

STRING

scheme

STRING

swift_code

STRING

updated_at

DATE-TIME

event_type

STRING

id

STRING

object

STRING

occurred_at

DATE-TIME

source

STRING

user

STRING

webhook_status

STRING

gifts

The gifts table contains info about the gifts in your Chargebee account.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

gifts schema on GitHub

Chargebee API method

Join gifts with on
credit_notes
gifts.gift_receiver.customer_id = credit_notes.customer_id
gifts.gifter.customer_id = credit_notes.customer_id
gifts.gifter.invoice_id = credit_notes.allocations.invoice_id
gifts.gifter.invoice_id = credit_notes.reference_invoice_id
gifts.gift_receiver.subscription_id = credit_notes.subscription_id
gifts.gift_receiver.subscription_id = credit_notes.line_items.subscription_id
customers
gifts.gift_receiver.customer_id = customers.id
gifts.gifter.customer_id = customers.id
events
gifts.gift_receiver.customer_id = events.content.customer.id
gifts.gifter.customer_id = events.content.customer.id
gifts.gift_receiver.customer_id = events.content.invoice.customer_id
gifts.gifter.customer_id = events.content.invoice.customer_id
gifts.gift_receiver.customer_id = events.content.subscription.customer_id
gifts.gifter.customer_id = events.content.subscription.customer_id
gifts.gift_receiver.customer_id = events.content.transaction.customer_id
gifts.gifter.customer_id = events.content.transaction.customer_id
gifts.gifter.invoice_id = events.content.invoice.id
gifts.gifter.invoice_id = events.content.transaction.linked_credit_notes.cn_reference_invoice_id
gifts.gift_receiver.subscription_id = events.content.subscription.id
gifts.gift_receiver.subscription_id = events.content.invoice.subscription_id
gifts.gift_receiver.subscription_id = events.content.transaction.subscription_id
invoices
gifts.gift_receiver.customer_id = invoices.customer_id
gifts.gifter.customer_id = invoices.customer_id
gifts.gift_receiver.customer_id = invoices.notes.entity_id
gifts.gifter.customer_id = invoices.notes.entity_id
gifts.gifter.invoice_id = invoices.id
gifts.gift_receiver.subscription_id = invoices.line_items.subscription_id
gifts.gift_receiver.subscription_id = invoices.notes.entity_id
gifts.gift_receiver.subscription_id = invoices.subscription_id
payment_sources
gifts.gift_receiver.customer_id = payment_sources.customer_id
gifts.gifter.customer_id = payment_sources.customer_id
promotional_credits
gifts.gift_receiver.customer_id = promotional_credits.customer_id
gifts.gifter.customer_id = promotional_credits.customer_id
subscriptions
gifts.gift_receiver.customer_id = subscriptions.customer_id
gifts.gifter.customer_id = subscriptions.customer_id
gifts.gift_receiver.subscription_id = subscriptions.id
transactions
gifts.gift_receiver.customer_id = transactions.customer_id
gifts.gifter.customer_id = transactions.customer_id
gifts.gifter.invoice_id = transactions.linked_credit_notes.cn_reference_invoice_id
gifts.gift_receiver.subscription_id = transactions.subscription_id
virtual_bank_accounts
gifts.gift_receiver.customer_id = virtual_bank_accounts.customer_id
gifts.gifter.customer_id = virtual_bank_accounts.customer_id
orders
gifts.gift_receiver.customer_id = orders.customer_id
gifts.gifter.customer_id = orders.customer_id
gifts.id = orders.gift_id
gifts.gifter.invoice_id = orders.invoice_id
gifts.gift_receiver.subscription_id = orders.subscription_id

auto_claim

BOOLEAN

claim_expiry_date

DATE-TIME

gift_receiver

OBJECT

customer_id

STRING

email

STRING

first_name

STRING

last_name

STRING

subscription_id

STRING

gift_timelines

ARRAY

occurred_at

DATE-TIME

status

STRING

gifter

OBJECT

customer_id

STRING

invoice_id

STRING

note

STRING

signature

STRING

id

STRING

no_expiry

BOOLEAN

resource_version

INTEGER

scheduled_at

DATE-TIME

status

STRING

updated_at

DATE-TIME

invoices

The invoices table contains info about the invoices in your Chargebee account. Invoices are statements containing charges, adjustments, and any discounts for a subscription specific to a term.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

invoices schema on GitHub

Chargebee API method

Join invoices with on
addons
invoices.notes.entity_id = addons.id
plans
invoices.notes.entity_id = plans.applicable_addons.id
invoices.notes.entity_id = plans.id
coupons
invoices.discounts.entity_id = coupons.id
invoices.line_item_discounts.coupon_id = coupons.id
invoices.notes.entity_id = coupons.id
credit_notes
invoices.discounts.entity_id = credit_notes.discounts.entity_id
invoices.line_item_discounts.coupon_id = credit_notes.discounts.entity_id
invoices.notes.entity_id = credit_notes.discounts.entity_id
invoices.discounts.entity_id = credit_notes.line_item_discounts.coupon_id
invoices.line_item_discounts.coupon_id = credit_notes.line_item_discounts.coupon_id
invoices.notes.entity_id = credit_notes.line_item_discounts.coupon_id
invoices.adjustment_credit_notes.cn_id = credit_notes.id
invoices.applied_credits.cn_id = credit_notes.id
invoices.issued_credit_notes.cn_id = credit_notes.id
invoices.customer_id = credit_notes.customer_id
invoices.notes.entity_id = credit_notes.customer_id
invoices.id = credit_notes.allocations.invoice_id
invoices.id = credit_notes.reference_invoice_id
invoices.line_item_discounts.line_item_id = credit_notes.line_item_discounts.line_item_id
invoices.line_item_taxes.line_item_id = credit_notes.line_item_discounts.line_item_id
invoices.line_item_tiers.line_item_id = credit_notes.line_item_discounts.line_item_id
invoices.line_items.id = credit_notes.line_item_discounts.line_item_id
invoices.line_item_discounts.line_item_id = credit_notes.line_item_taxes.line_item_id
invoices.line_item_taxes.line_item_id = credit_notes.line_item_taxes.line_item_id
invoices.line_item_tiers.line_item_id = credit_notes.line_item_taxes.line_item_id
invoices.line_items.id = credit_notes.line_item_taxes.line_item_id
invoices.line_item_discounts.line_item_id = credit_notes.line_item_tiers.line_item_id
invoices.line_item_taxes.line_item_id = credit_notes.line_item_tiers.line_item_id
invoices.line_item_tiers.line_item_id = credit_notes.line_item_tiers.line_item_id
invoices.line_items.id = credit_notes.line_item_tiers.line_item_id
invoices.line_item_discounts.line_item_id = credit_notes.line_items.id
invoices.line_item_taxes.line_item_id = credit_notes.line_items.id
invoices.line_item_tiers.line_item_id = credit_notes.line_items.id
invoices.line_items.id = credit_notes.line_items.id
invoices.line_items.subscription_id = credit_notes.subscription_id
invoices.notes.entity_id = credit_notes.subscription_id
invoices.subscription_id = credit_notes.subscription_id
invoices.line_items.subscription_id = credit_notes.line_items.subscription_id
invoices.notes.entity_id = credit_notes.line_items.subscription_id
invoices.subscription_id = credit_notes.line_items.subscription_id
invoices.linked_payments.txn_id = credit_notes.linked_refunds.txn_id
events
invoices.discounts.entity_id = events.content.coupon.id
invoices.line_item_discounts.coupon_id = events.content.coupon.id
invoices.notes.entity_id = events.content.coupon.id
invoices.discounts.entity_id = events.content.invoice.discounts.entity_id
invoices.line_item_discounts.coupon_id = events.content.invoice.discounts.entity_id
invoices.notes.entity_id = events.content.invoice.discounts.entity_id
invoices.discounts.entity_id = events.content.invoice.line_item_discounts.coupon_id
invoices.line_item_discounts.coupon_id = events.content.invoice.line_item_discounts.coupon_id
invoices.notes.entity_id = events.content.invoice.line_item_discounts.coupon_id
invoices.discounts.entity_id = events.content.subscription.coupons.coupon_id
invoices.line_item_discounts.coupon_id = events.content.subscription.coupons.coupon_id
invoices.notes.entity_id = events.content.subscription.coupons.coupon_id
invoices.adjustment_credit_notes.cn_id = events.content.invoice.adjustment_credit_notes.cn_id
invoices.applied_credits.cn_id = events.content.invoice.adjustment_credit_notes.cn_id
invoices.issued_credit_notes.cn_id = events.content.invoice.adjustment_credit_notes.cn_id
invoices.adjustment_credit_notes.cn_id = events.content.invoice.applied_credits.cn_id
invoices.applied_credits.cn_id = events.content.invoice.applied_credits.cn_id
invoices.issued_credit_notes.cn_id = events.content.invoice.applied_credits.cn_id
invoices.adjustment_credit_notes.cn_id = events.content.invoice.issued_credit_notes.cn_id
invoices.applied_credits.cn_id = events.content.invoice.issued_credit_notes.cn_id
invoices.issued_credit_notes.cn_id = events.content.invoice.issued_credit_notes.cn_id
invoices.customer_id = events.content.customer.id
invoices.notes.entity_id = events.content.customer.id
invoices.customer_id = events.content.invoice.customer_id
invoices.notes.entity_id = events.content.invoice.customer_id
invoices.customer_id = events.content.subscription.customer_id
invoices.notes.entity_id = events.content.subscription.customer_id
invoices.customer_id = events.content.transaction.customer_id
invoices.notes.entity_id = events.content.transaction.customer_id
invoices.id = events.content.invoice.id
invoices.id = events.content.transaction.linked_credit_notes.cn_reference_invoice_id
invoices.line_item_discounts.line_item_id = events.content.invoice.line_item_discounts.line_item_id
invoices.line_item_taxes.line_item_id = events.content.invoice.line_item_discounts.line_item_id
invoices.line_item_tiers.line_item_id = events.content.invoice.line_item_discounts.line_item_id
invoices.line_items.id = events.content.invoice.line_item_discounts.line_item_id
invoices.line_item_discounts.line_item_id = events.content.invoice.line_item_taxes.line_item_id
invoices.line_item_taxes.line_item_id = events.content.invoice.line_item_taxes.line_item_id
invoices.line_item_tiers.line_item_id = events.content.invoice.line_item_taxes.line_item_id
invoices.line_items.id = events.content.invoice.line_item_taxes.line_item_id
invoices.line_item_discounts.line_item_id = events.content.invoice.line_items.id
invoices.line_item_taxes.line_item_id = events.content.invoice.line_items.id
invoices.line_item_tiers.line_item_id = events.content.invoice.line_items.id
invoices.line_items.id = events.content.invoice.line_items.id
invoices.line_items.subscription_id = events.content.subscription.id
invoices.notes.entity_id = events.content.subscription.id
invoices.subscription_id = events.content.subscription.id
invoices.line_items.subscription_id = events.content.invoice.subscription_id
invoices.notes.entity_id = events.content.invoice.subscription_id
invoices.subscription_id = events.content.invoice.subscription_id
invoices.line_items.subscription_id = events.content.transaction.subscription_id
invoices.notes.entity_id = events.content.transaction.subscription_id
invoices.subscription_id = events.content.transaction.subscription_id
invoices.linked_payments.txn_id = events.content.invoice.linked_payments.txn_id
invoices.linked_payments.txn_id = events.content.transaction.id
invoices.linked_payments.txn_id = events.content.transaction.linked_refunds.txn_id
invoices.linked_payments.txn_id = events.content.transaction.reference_transaction_id
invoices.linked_payments.txn_id = events.content.transaction.refunded_txn_id
subscriptions
invoices.discounts.entity_id = subscriptions.coupons.coupon_id
invoices.line_item_discounts.coupon_id = subscriptions.coupons.coupon_id
invoices.notes.entity_id = subscriptions.coupons.coupon_id
invoices.customer_id = subscriptions.customer_id
invoices.notes.entity_id = subscriptions.customer_id
invoices.line_items.subscription_id = subscriptions.id
invoices.notes.entity_id = subscriptions.id
invoices.subscription_id = subscriptions.id
orders
invoices.discounts.entity_id = orders.line_item_discounts.coupon_id
invoices.line_item_discounts.coupon_id = orders.line_item_discounts.coupon_id
invoices.notes.entity_id = orders.line_item_discounts.coupon_id
invoices.adjustment_credit_notes.cn_id = orders.linked_credit_notes.id
invoices.applied_credits.cn_id = orders.linked_credit_notes.id
invoices.issued_credit_notes.cn_id = orders.linked_credit_notes.id
invoices.customer_id = orders.customer_id
invoices.notes.entity_id = orders.customer_id
invoices.id = orders.invoice_id
invoices.line_item_discounts.line_item_id = orders.line_item_discounts.line_item_id
invoices.line_item_taxes.line_item_id = orders.line_item_discounts.line_item_id
invoices.line_item_tiers.line_item_id = orders.line_item_discounts.line_item_id
invoices.line_items.id = orders.line_item_discounts.line_item_id
invoices.line_item_discounts.line_item_id = orders.line_item_taxes.line_item_id
invoices.line_item_taxes.line_item_id = orders.line_item_taxes.line_item_id
invoices.line_item_tiers.line_item_id = orders.line_item_taxes.line_item_id
invoices.line_items.id = orders.line_item_taxes.line_item_id
invoices.line_items.subscription_id = orders.subscription_id
invoices.notes.entity_id = orders.subscription_id
invoices.subscription_id = orders.subscription_id
invoices.linked_orders.id = orders.id
customers
invoices.customer_id = customers.id
invoices.notes.entity_id = customers.id
payment_sources
invoices.customer_id = payment_sources.customer_id
invoices.notes.entity_id = payment_sources.customer_id
promotional_credits
invoices.customer_id = promotional_credits.customer_id
invoices.notes.entity_id = promotional_credits.customer_id
transactions
invoices.customer_id = transactions.customer_id
invoices.notes.entity_id = transactions.customer_id
invoices.id = transactions.linked_credit_notes.cn_reference_invoice_id
invoices.line_items.subscription_id = transactions.subscription_id
invoices.notes.entity_id = transactions.subscription_id
invoices.subscription_id = transactions.subscription_id
invoices.linked_payments.txn_id = transactions.id
invoices.linked_payments.txn_id = transactions.linked_refunds.txn_id
invoices.linked_payments.txn_id = transactions.reference_transaction_id
invoices.linked_payments.txn_id = transactions.refunded_txn_id
virtual_bank_accounts
invoices.customer_id = virtual_bank_accounts.customer_id
invoices.notes.entity_id = virtual_bank_accounts.customer_id
gifts
invoices.customer_id = gifts.gift_receiver.customer_id
invoices.notes.entity_id = gifts.gift_receiver.customer_id
invoices.customer_id = gifts.gifter.customer_id
invoices.notes.entity_id = gifts.gifter.customer_id
invoices.id = gifts.gifter.invoice_id
invoices.line_items.subscription_id = gifts.gift_receiver.subscription_id
invoices.notes.entity_id = gifts.gift_receiver.subscription_id
invoices.subscription_id = gifts.gift_receiver.subscription_id

adjustment_credit_notes

ARRAY

cn_create_reason_code

STRING

cn_date

DATE-TIME

cn_id

STRING

cn_reason_code

STRING

cn_status

STRING

cn_total

INTEGER

amount_adjusted

INTEGER

amount_due

INTEGER

amount_paid

INTEGER

amount_to_collect

INTEGER

applied_credits

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

cn_create_reason_code

STRING

cn_date

DATE-TIME

cn_id

STRING

cn_reason_code

STRING

cn_status

STRING

base_currency_code

STRING

billing_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

channel

STRING

credits_applied

INTEGER

currency_code

STRING

customer_id

STRING

date

DATE-TIME

deleted

BOOLEAN

discounts

ARRAY

amount

INTEGER

description

STRING

entity_id

STRING

entity_type

STRING

object

STRING

due_date

DATE-TIME

dunning_attempts

ARRAY

attempt

INTEGER

created_at

DATE-TIME

dunning_type

STRING

transaction_id

STRING

txn_amount

INTEGER

txn_status

STRING

dunning_status

STRING

einvoice

OBJECT

id

STRING

message

STRING

status

STRING

exchange_rate

NUMBER

expected_payment_date

DATE-TIME

first_invoice

BOOLEAN

generated_at

DATE-TIME

has_advance_charges

BOOLEAN

id

STRING

is_gifted

BOOLEAN

issued_credit_notes

ARRAY

cn_create_reason_code

STRING

cn_date

DATE-TIME

cn_id

STRING

cn_reason_code

STRING

cn_status

STRING

cn_total

INTEGER

line_item_discounts

ARRAY

coupon_id

STRING

discount_amount

INTEGER

discount_type

STRING

entity_id

STRING

line_item_id

STRING

object

STRING

line_item_taxes

ARRAY

is_non_compliance_tax

BOOLEAN

is_partial_tax_applied

BOOLEAN

line_item_id

STRING

local_currency_code

STRING

tax_amount

INTEGER

tax_amount_in_local_currency

INTEGER

tax_juris_code

STRING

tax_juris_name

STRING

tax_juris_type

STRING

tax_name

STRING

tax_rate

INTEGER, NUMBER

taxable_amount

INTEGER

line_item_tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

line_item_id

STRING

quantity_used

INTEGER

quantity_used_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

unit_amount

INTEGER

unit_amount_in_decimal

STRING

line_items

ARRAY

amount

INTEGER

amount_in_decimal

STRING

customer_id

STRING

date_from

DATE-TIME

date_to

DATE-TIME

description

STRING

discount_amount

INTEGER

entity_description

STRING

entity_id

STRING

entity_type

STRING

id

STRING

is_taxed

BOOLEAN

item_level_discount_amount

INTEGER

object

STRING

pricing_model

STRING

quantity

INTEGER

quantity_in_decimal

STRING

subscription_id

STRING

tax_amount

INTEGER

tax_exempt_reason

STRING

tax_rate

NUMBER

unit_amount

INTEGER

unit_amount_in_decimal

STRING

linked_orders

ARRAY

batch_id

STRING

created_at

DATE-TIME

document_number

STRING

fulfillment_status

STRING

id

STRING

order_type

STRING

reference_id

STRING

status

STRING

linked_payments

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

txn_amount

INTEGER

txn_date

DATE-TIME

txn_id

STRING

txn_status

STRING

local_currency_code

STRING

net_term_days

INTEGER

new_sales_amount

INTEGER

next_retry_at

DATE-TIME

notes

ARRAY

entity_id

STRING

entity_type

STRING

note

STRING

object

STRING

paid_at

DATE-TIME

payment_owner

STRING

po_number

STRING

price_type

STRING

recurring

BOOLEAN

resource_version

INTEGER

round_off_amount

INTEGER

shipping_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

status

STRING

sub_total

INTEGER

sub_total_in_local_currency

INTEGER

subscription_id

STRING

tax

INTEGER

taxes

ARRAY

amount

INTEGER

description

STRING

name

STRING

term_finalized

BOOLEAN

total

INTEGER

total_in_local_currency

INTEGER

updated_at

DATE-TIME

vat_number

STRING

vat_number_prefix

STRING

void_reason_code

STRING

voided_at

DATE-TIME

write_off_amount

INTEGER

item_families

The item_families table contains info about item families.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

item_families schema on GitHub

Chargebee API method

Join item_families with on
item_prices
item_families.id = item_prices.item_family_id
items
item_families.id = items.item_family_id

channel

STRING

custom_fields

STRING

description

STRING

id

STRING

name

STRING

object

STRING

resource_version

INTEGER

status

STRING

updated_at

DATE-TIME

item_prices

The item_prices table contains info about item prices.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

item_prices schema on GitHub

Chargebee API method

Join item_prices with on
item_families
item_prices.item_family_id = item_families.id
items
item_prices.item_family_id = items.item_family_id
item_prices.item_id = items.id

accounting_detail

OBJECT

accounting_category1

STRING

accounting_category2

STRING

accounting_category3

STRING

accounting_category4

STRING

accounting_code

STRING

sku

STRING

archivable

BOOLEAN, STRING

archived_at

DATE-TIME

billing_cycles

INTEGER

channel

STRING

created_at

DATE-TIME

currency_code

STRING

custom_fields

STRING

description

STRING

external_name

STRING

free_quantity

INTEGER

free_quantity_in_decimal

STRING

id

STRING

invoice_notes

STRING

is_taxable

BOOLEAN

item_family_id

STRING

item_id

STRING

item_type

STRING

metadata

STRING

name

STRING

object

STRING

period

INTEGER

period_unit

STRING

price

INTEGER

price_in_decimal

STRING

pricing_model

STRING

resource_version

INTEGER

shipping_period

INTEGER

shipping_period_unit

STRING

show_description_in_invoices

BOOLEAN

show_description_in_quotes

BOOLEAN

status

STRING

tax_detail

OBJECT

avalara_sale_type

STRING

avalara_service_type

INTEGER

avalara_tax_code

STRING

avalara_transaction_type

INTEGER

tax_profile_id

STRING

taxjar_product_code

STRING

tiers

ARRAY

ending_unit

INTEGER

price

INTEGER

starting_unit

INTEGER

trial_end_action

STRING

trial_period

INTEGER

trial_period_unit

STRING

updated_at

DATE-TIME

items

The items table contains info about the items in your Chargebee account.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

items schema on GitHub

Chargebee API method

Join items with on
item_families
items.item_family_id = item_families.id
item_prices
items.item_family_id = item_prices.item_family_id
items.id = item_prices.item_id

applicable_items

ARRAY

archivable

BOOLEAN, STRING

archived_at

DATE-TIME

channel

STRING

custom_fields

STRING

description

STRING

enabled_for_checkout

BOOLEAN

enabled_in_portal

BOOLEAN

external_name

STRING

gift_claim_redirect_url

STRING

id

STRING

included_in_mrr

BOOLEAN

is_giftable

BOOLEAN

is_shippable

BOOLEAN

item_applicability

STRING

item_family_id

STRING

metadata

STRING

metered

BOOLEAN

name

STRING

object

STRING

redirect_url

STRING

resource_version

INTEGER

status

STRING

type

STRING

unit

STRING

updated_at

DATE-TIME

usage_calculation

STRING

orders

The orders table contains info about the orders in your Chargebee account. The Order Management feature must be enabled to replicate this table. For more information, refer to the Chargebee docs.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

orders schema on GitHub

Chargebee API method

Join orders with on
coupons
orders.line_item_discounts.coupon_id = coupons.id
credit_notes
orders.line_item_discounts.coupon_id = credit_notes.discounts.entity_id
orders.line_item_discounts.coupon_id = credit_notes.line_item_discounts.coupon_id
orders.linked_credit_notes.id = credit_notes.id
orders.customer_id = credit_notes.customer_id
orders.invoice_id = credit_notes.allocations.invoice_id
orders.invoice_id = credit_notes.reference_invoice_id
orders.line_item_discounts.line_item_id = credit_notes.line_item_discounts.line_item_id
orders.line_item_taxes.line_item_id = credit_notes.line_item_discounts.line_item_id
orders.line_item_discounts.line_item_id = credit_notes.line_item_taxes.line_item_id
orders.line_item_taxes.line_item_id = credit_notes.line_item_taxes.line_item_id
orders.line_item_discounts.line_item_id = credit_notes.line_item_tiers.line_item_id
orders.line_item_taxes.line_item_id = credit_notes.line_item_tiers.line_item_id
orders.line_item_discounts.line_item_id = credit_notes.line_items.id
orders.line_item_taxes.line_item_id = credit_notes.line_items.id
orders.subscription_id = credit_notes.subscription_id
orders.subscription_id = credit_notes.line_items.subscription_id
events
orders.line_item_discounts.coupon_id = events.content.coupon.id
orders.line_item_discounts.coupon_id = events.content.invoice.discounts.entity_id
orders.line_item_discounts.coupon_id = events.content.invoice.line_item_discounts.coupon_id
orders.line_item_discounts.coupon_id = events.content.subscription.coupons.coupon_id
orders.linked_credit_notes.id = events.content.invoice.adjustment_credit_notes.cn_id
orders.linked_credit_notes.id = events.content.invoice.applied_credits.cn_id
orders.linked_credit_notes.id = events.content.invoice.issued_credit_notes.cn_id
orders.customer_id = events.content.customer.id
orders.customer_id = events.content.invoice.customer_id
orders.customer_id = events.content.subscription.customer_id
orders.customer_id = events.content.transaction.customer_id
orders.invoice_id = events.content.invoice.id
orders.invoice_id = events.content.transaction.linked_credit_notes.cn_reference_invoice_id
orders.line_item_discounts.line_item_id = events.content.invoice.line_item_discounts.line_item_id
orders.line_item_taxes.line_item_id = events.content.invoice.line_item_discounts.line_item_id
orders.line_item_discounts.line_item_id = events.content.invoice.line_item_taxes.line_item_id
orders.line_item_taxes.line_item_id = events.content.invoice.line_item_taxes.line_item_id
orders.line_item_discounts.line_item_id = events.content.invoice.line_items.id
orders.line_item_taxes.line_item_id = events.content.invoice.line_items.id
orders.subscription_id = events.content.subscription.id
orders.subscription_id = events.content.invoice.subscription_id
orders.subscription_id = events.content.transaction.subscription_id
invoices
orders.line_item_discounts.coupon_id = invoices.discounts.entity_id
orders.line_item_discounts.coupon_id = invoices.line_item_discounts.coupon_id
orders.line_item_discounts.coupon_id = invoices.notes.entity_id
orders.linked_credit_notes.id = invoices.adjustment_credit_notes.cn_id
orders.linked_credit_notes.id = invoices.applied_credits.cn_id
orders.linked_credit_notes.id = invoices.issued_credit_notes.cn_id
orders.customer_id = invoices.customer_id
orders.customer_id = invoices.notes.entity_id
orders.invoice_id = invoices.id
orders.line_item_discounts.line_item_id = invoices.line_item_discounts.line_item_id
orders.line_item_taxes.line_item_id = invoices.line_item_discounts.line_item_id
orders.line_item_discounts.line_item_id = invoices.line_item_taxes.line_item_id
orders.line_item_taxes.line_item_id = invoices.line_item_taxes.line_item_id
orders.line_item_discounts.line_item_id = invoices.line_item_tiers.line_item_id
orders.line_item_taxes.line_item_id = invoices.line_item_tiers.line_item_id
orders.line_item_discounts.line_item_id = invoices.line_items.id
orders.line_item_taxes.line_item_id = invoices.line_items.id
orders.subscription_id = invoices.line_items.subscription_id
orders.subscription_id = invoices.notes.entity_id
orders.subscription_id = invoices.subscription_id
orders.id = invoices.linked_orders.id
subscriptions
orders.line_item_discounts.coupon_id = subscriptions.coupons.coupon_id
orders.customer_id = subscriptions.customer_id
orders.subscription_id = subscriptions.id
customers
orders.customer_id = customers.id
payment_sources
orders.customer_id = payment_sources.customer_id
promotional_credits
orders.customer_id = promotional_credits.customer_id
transactions
orders.customer_id = transactions.customer_id
orders.invoice_id = transactions.linked_credit_notes.cn_reference_invoice_id
orders.subscription_id = transactions.subscription_id
virtual_bank_accounts
orders.customer_id = virtual_bank_accounts.customer_id
gifts
orders.customer_id = gifts.gift_receiver.customer_id
orders.customer_id = gifts.gifter.customer_id
orders.gift_id = gifts.id
orders.invoice_id = gifts.gifter.invoice_id
orders.subscription_id = gifts.gift_receiver.subscription_id

amount_adjusted

INTEGER

amount_paid

INTEGER

batch_id

STRING

billing_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

cancellation_reason

STRING

cancelled_at

DATE-TIME

created_at

DATE-TIME

created_by

STRING

currency_code

STRING

customer_id

STRING

deleted

BOOLEAN

delivered_at

DATE-TIME

discount

INTEGER

document_number

STRING

fulfillment_status

STRING

gift_id

STRING

gift_note

STRING

id

STRING

invoice_id

STRING

invoice_round_off_amount

INTEGER

is_gifted

BOOLEAN

is_resent

BOOLEAN

line_item_discounts

ARRAY

coupon_id

STRING

discount_amount

INTEGER

discount_type

STRING

line_item_id

STRING

line_item_taxes

ARRAY

is_non_compliance_tax

BOOLEAN

is_partial_tax_applied

BOOLEAN

line_item_id

STRING

local_currency_code

STRING

tax_amount

INTEGER

tax_amount_in_local_currency

INTEGER

tax_juris_code

STRING

tax_juris_name

STRING

tax_juris_type

STRING

tax_name

STRING

tax_rate

INTEGER, NUMBER

taxable_amount

INTEGER

linked_credit_notes

ARRAY

amount

INTEGER

amount_adjusted

INTEGER

amount_refunded

INTEGER

id

STRING

status

STRING

type

STRING

note

STRING

order_date

DATE-TIME

order_line_items

ARRAY

amount

INTEGER

amount_adjusted

INTEGER

amount_paid

INTEGER

description

STRING

discount_amount

INTEGER

entity_id

STRING

entity_type

STRING

fulfillment_amount

INTEGER

fulfillment_quantity

INTEGER

id

STRING

invoice_id

STRING

invoice_line_item_id

STRING

is_shippable

BOOLEAN

item_level_discount_amount

INTEGER

refundable_credits

INTEGER

refundable_credits_issued

INTEGER

sku

STRING

status

STRING

tax_amount

INTEGER

unit_price

INTEGER

order_type

STRING

original_order_id

STRING

paid_on

DATE-TIME

payment_status

STRING

price_type

STRING

reference_id

STRING

refundable_credits

INTEGER

refundable_credits_issued

INTEGER

resend_reason

STRING

resent_orders

ARRAY

amount

INTEGER

order_id

STRING

reason

STRING

resent_status

STRING

resource_version

INTEGER

rounding_adjustement

INTEGER

shipment_carrier

STRING

shipped_at

DATE-TIME

shipping_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status,

STRING

zip

STRING

shipping_cut_off_date

DATE-TIME

shipping_date

DATE-TIME

status

STRING

status_update_at

DATE-TIME

sub_total

INTEGER

subscription_id

STRING

tax

INTEGER

total

INTEGER

tracking_id

STRING

tracking_url

STRING

updated_at

DATE-TIME

payment_sources

The payment_sources table contains info about customer payment sources.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

payment_sources schema on GitHub

Chargebee API method

Join payment_sources with on
credit_notes
payment_sources.customer_id = credit_notes.customer_id
customers
payment_sources.customer_id = customers.id
payment_sources.id = customers.primary_payment_source_id
events
payment_sources.customer_id = events.content.customer.id
payment_sources.customer_id = events.content.invoice.customer_id
payment_sources.customer_id = events.content.subscription.customer_id
payment_sources.customer_id = events.content.transaction.customer_id
payment_sources.id = events.content.subscription.payment_source_id
payment_sources.id = events.content.transaction.payment_source_id
invoices
payment_sources.customer_id = invoices.customer_id
payment_sources.customer_id = invoices.notes.entity_id
promotional_credits
payment_sources.customer_id = promotional_credits.customer_id
subscriptions
payment_sources.customer_id = subscriptions.customer_id
payment_sources.id = subscriptions.payment_source_id
transactions
payment_sources.customer_id = transactions.customer_id
payment_sources.id = transactions.payment_source_id
virtual_bank_accounts
payment_sources.customer_id = virtual_bank_accounts.customer_id
gifts
payment_sources.customer_id = gifts.gift_receiver.customer_id
payment_sources.customer_id = gifts.gifter.customer_id
orders
payment_sources.customer_id = orders.customer_id

amazon_payment

OBJECT

agreement_id

STRING

email

STRING

bank_account

OBJECT

account_holder_type

STRING

account_type

STRING

bank_name

STRING

echeck_type

STRING

last4

STRING

mandate_id

STRING

name_on_account

STRING

card

OBJECT

billing_addr1

STRING

billing_addr2

STRING

billing_city

STRING

billing_country

STRING

billing_state

STRING

billing_state_code

STRING

billing_zip

STRING

brand

STRING

expiry_month

INTEGER

expiry_year

INTEGER

first_name

STRING

funding_type

STRING

iin

STRING

last4

STRING

last_name

STRING

masked_number

STRING

object

STRING

created_at

DATE-TIME

customer_id

STRING

deleted

BOOLEAN

gateway

STRING

gateway_account_id

STRING

id

STRING

ip_address

STRING

issuing_country

STRING

mandates

ARRAY

created_at

DATE-TIME

id

STRING

subscription_id

STRING

object

STRING

paypal

OBJECT

agremeent_id

STRING

email

STRING

reference_id

STRING

resource_version

INTEGER

status

STRING

type

STRING

updated_at

DATE-TIME

upi

OBJECT

vpa

STRING

plans

The plans table contains info about the plans in your Chargebee account. Plans are used to specify prices and billing frequencies for subscriptions.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

plans schema on GitHub

Chargebee API method

Join plans with on
addons
plans.applicable_addons.id = addons.id
invoices
plans.applicable_addons.id = invoices.notes.entity_id
plans.id = invoices.notes.entity_id

account_code

STRING

accounting_category1

STRING

accounting_category2

STRING

accounting_category3

STRING

accounting_category4

STRING

accounting_code

STRING

addon_applicability

STRING

applicable_addons

ARRAY

id

STRING

quantity_in_decimal

STRING

archived_at

DATE-TIME

attached_addons

ARRAY

billing_cycles

INTEGER

id

STRING

quantity

INTEGER

quantity_in_decimal

STRING

type

STRING

avalara_sale_type

STRING

avalara_service_type

INTEGER

avalara_transaction_type

INTEGER

billing_cycles

INTEGER

channel

STRING

charge_model

STRING

claim_url

STRING

currency_code

STRING

custom_fields

STRING

description

STRING

enabled_in_hosted_pages

BOOLEAN

enabled_in_portal

BOOLEAN

event_based_addons

ARRAY

charge_once

BOOLEAN

id

STRING

on_event

STRING

quantity

INTEGER

quantity_in_decimal

STRING

free_quantity

INTEGER

free_quantity_in_decimal

STRING

giftable

BOOLEAN

id

STRING

invoice_name

STRING

invoice_notes

STRING

is_shippable

BOOLEAN

meta_data

STRING

name

STRING

object

STRING

period

INTEGER

period_unit

STRING

price

INTEGER

price_in_decimal

STRING

pricing_model

STRING

redirect_url

STRING

resource_version

INTEGER

setup_cost

INTEGER

shipping_frequency_period

INTEGER

shipping_frequency_period_unit

STRING

show_description_in_invoices

BOOLEAN

show_description_in_quotes

BOOLEAN

sku

STRING

status

STRING

tax_code

STRING

tax_profile_id

STRING

taxable

BOOLEAN

taxjar_product_code

STRING

tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

price

INTEGER

price_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

trial_end_action

STRING

trial_period

INTEGER

trial_period_unit

STRING

updated_at

DATE-TIME

promotional_credits

The promotional_credits table contains info about the promotional_credits in your Chargebee account.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

created_at

Useful links

Chargebee documentation

promotional_credits schema on GitHub

Chargebee API method

Join promotional_credits with on
credit_notes
promotional_credits.customer_id = credit_notes.customer_id
customers
promotional_credits.customer_id = customers.id
events
promotional_credits.customer_id = events.content.customer.id
promotional_credits.customer_id = events.content.invoice.customer_id
promotional_credits.customer_id = events.content.subscription.customer_id
promotional_credits.customer_id = events.content.transaction.customer_id
invoices
promotional_credits.customer_id = invoices.customer_id
promotional_credits.customer_id = invoices.notes.entity_id
payment_sources
promotional_credits.customer_id = payment_sources.customer_id
subscriptions
promotional_credits.customer_id = subscriptions.customer_id
transactions
promotional_credits.customer_id = transactions.customer_id
virtual_bank_accounts
promotional_credits.customer_id = virtual_bank_accounts.customer_id
gifts
promotional_credits.customer_id = gifts.gift_receiver.customer_id
promotional_credits.customer_id = gifts.gifter.customer_id
orders
promotional_credits.customer_id = orders.customer_id

amount

STRING

amount_in_decimal

STRING

closing_balance

INTEGER

created_at

DATE-TIME

credit_type

STRING

currency_code

STRING

customer_id

STRING

description

STRING

done_by

STRING

id

STRING

object

STRING

reference

STRING

type

STRING

quotes

The quotes table contains info about quotes in your Chargebee account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

quotes schema on GitHub

Chargebee API method

amount_due

INTEGER

amount_paid

INTEGER

billing_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

charge_on_acceptance

INTEGER

contract_term_end

DATE-TIME

contract_term_start

DATE-TIME

contract_term_termination_fee

INTEGER

credits_applied

INTEGER

currency_code

STRING

customer_id

STRING

date

DATE-TIME

discounts

ARRAY

amount

INTEGER

description

STRING

entity_id

STRING

entity_type

STRING

object

STRING

id

STRING

invoice_id

STRING

line_item_discounts

ARRAY

coupon_id

STRING

discount_amount

INTEGER

discount_type

STRING

entity_id

STRING

line_item_id

STRING

line_item_taxes

ARRAY

is_non_compliance_tax

BOOLEAN

is_partial_tax_applied

BOOLEAN

line_item_id

STRING

tax_amount

INTEGER

tax_juris_code

STRING

tax_juris_name

STRING

tax_juris_type

STRING

tax_name

STRING

tax_rate

INTEGER

taxable_amount

INTEGER

line_item_tiers

ARRAY

ending_unit

INTEGER

line_item_id

STRING

quantity_used

INTEGER

starting_unit

INTEGER

unit_amount

INTEGER

line_items

ARRAY

amount

INTEGER

date_from

DATE-TIME

date_to

DATE-TIME

description

STRING

discount_amount

INTEGER

entity_id

STRING

entity_type

STRING

id

STRING

is_taxed

BOOLEAN

item_level_discount_amount

INTEGER

object

STRING

pricing_model

STRING

quantity

INTEGER

subscription_id

STRING

tax_amount

INTEGER

tax_exempt_reason

STRING

tax_rate

INTEGER

unit_amount

INTEGER

name

STRING

notes

STRING

operation_type

STRING

po_number

STRING

price_type

STRING

resource_version

INTEGER

shipping_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status,

STRING

zip

STRING

status

STRING

sub_total

INTEGER

subscription_id

STRING

taxes

ARRAY

amount

INTEGER

description

STRING

name

STRING

total

INTEGER

total_payable

INTEGER

updated_at

DATE-TIME

valid_till

DATE-TIME

vat_number

STRING

vat_number_prefix

STRING

version

INTEGER

subscriptions

The subscriptions table contains info about the subscriptions your customers have subscribed to. A subscription is a recurring item that customers are billed for, such as a plan or addon. It may also contain discount items.

Note: Chargebee does not update the updated_at value when the following attributes on a subscription are modified:

  • due_invoices_count
  • due_since
  • total_dues

Because of this functionality and Stitch’s use of this value as a Replication Key, updates made to subscriptions where only these attributes are modified may not be detected. You should ensure that another attribute on the subscription is also modified to ensure that the updated_at value is updated, which will allow Stitch to detect and replicate the record.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

subscriptions schema on GitHub

Chargebee API method

Join subscriptions with on
coupons
subscriptions.coupons.coupon_id = coupons.id
credit_notes
subscriptions.coupons.coupon_id = credit_notes.discounts.entity_id
subscriptions.coupons.coupon_id = credit_notes.line_item_discounts.coupon_id
subscriptions.customer_id = credit_notes.customer_id
subscriptions.id = credit_notes.subscription_id
subscriptions.id = credit_notes.line_items.subscription_id
events
subscriptions.coupons.coupon_id = events.content.coupon.id
subscriptions.coupons.coupon_id = events.content.invoice.discounts.entity_id
subscriptions.coupons.coupon_id = events.content.invoice.line_item_discounts.coupon_id
subscriptions.coupons.coupon_id = events.content.subscription.coupons.coupon_id
subscriptions.customer_id = events.content.customer.id
subscriptions.customer_id = events.content.invoice.customer_id
subscriptions.customer_id = events.content.subscription.customer_id
subscriptions.customer_id = events.content.transaction.customer_id
subscriptions.payment_source_id = events.content.subscription.payment_source_id
subscriptions.payment_source_id = events.content.transaction.payment_source_id
subscriptions.id = events.content.subscription.id
subscriptions.id = events.content.invoice.subscription_id
subscriptions.id = events.content.transaction.subscription_id
invoices
subscriptions.coupons.coupon_id = invoices.discounts.entity_id
subscriptions.coupons.coupon_id = invoices.line_item_discounts.coupon_id
subscriptions.coupons.coupon_id = invoices.notes.entity_id
subscriptions.customer_id = invoices.customer_id
subscriptions.customer_id = invoices.notes.entity_id
subscriptions.id = invoices.line_items.subscription_id
subscriptions.id = invoices.notes.entity_id
subscriptions.id = invoices.subscription_id
orders
subscriptions.coupons.coupon_id = orders.line_item_discounts.coupon_id
subscriptions.customer_id = orders.customer_id
subscriptions.id = orders.subscription_id
customers
subscriptions.customer_id = customers.id
subscriptions.payment_source_id = customers.primary_payment_source_id
payment_sources
subscriptions.customer_id = payment_sources.customer_id
subscriptions.payment_source_id = payment_sources.id
promotional_credits
subscriptions.customer_id = promotional_credits.customer_id
transactions
subscriptions.customer_id = transactions.customer_id
subscriptions.payment_source_id = transactions.payment_source_id
subscriptions.id = transactions.subscription_id
virtual_bank_accounts
subscriptions.customer_id = virtual_bank_accounts.customer_id
gifts
subscriptions.customer_id = gifts.gift_receiver.customer_id
subscriptions.customer_id = gifts.gifter.customer_id
subscriptions.id = gifts.gift_receiver.subscription_id

activated_at

DATE-TIME

auto_close_invoices

BOOLEAN

auto_collection

STRING

base_currency_code

STRING

billing_period

INTEGER

billing_period_unit

STRING

cancel_reason

STRING

cancel_reason_code

STRING

cancel_schedule_created_at

DATE-TIME

cancelled_at

DATE-TIME

changes_scheduled_at

DATE-TIME

channel

STRING

charged_items

ARRAY

item_price_id

STRING

last_charged_at

DATE-TIME

object

STRING

contract_term

OBJECT

action_at_term_end

STRING

billing_cycle

INTEGER

cancellation_cutoff_period

INTEGER

contract_end

DATE-TIME

contract_start

DATE-TIME

created_at

DATE-TIME

id

STRING

remaining_billing_cycles

INTEGER

status

STRING

subscription_id

STRING

total_contract_value

INTEGER

contract_term_billing_cycle_on_renewal

INTEGER

coupon

STRING

coupons

ARRAY

applied_count

INTEGER

apply_till

DATE-TIME

coupon_code

STRING

coupon_id

STRING

object

STRING

create_pending_invoices

BOOLEAN

created_at

DATE-TIME

created_from_ip

STRING

currency_code

STRING

current_term_end

DATE-TIME

current_term_start

DATE-TIME

custom_fields

STRING

customer_id

STRING

deleted

BOOLEAN

discounts

ARRAY

amount

NUMBER

applied_count

INTEGER

apply_on

STRING

apply_till

INTEGER

coupon_id

STRING

created_at

INTEGER

currency_code

STRING

duration_type

STRING

id

STRING

included_in_mrr

BOOLEAN

index

INTEGER

invoice_name

STRING

item_price_id

STRING

name

STRING

object

STRING

percentage

NUMBER

period

INTEGER

period_unit

STRING

resource_version

INTEGER

type

STRING

updated_at

INTEGER

due_invoices_count

INTEGER

due_since

DATE-TIME

exchange_rate

NUMBER

free_period

INTEGER

free_period_unit

STRING

has_scheduled_advance_invoices

BOOLEAN

has_scheduled_changes

BOOLEAN

id

STRING

invoice_notes

STRING

item_tiers

ARRAY

ending_unit

INTEGER

ending_unit_in_decimal

STRING

item_price_id

STRING

price

INTEGER

price_in_decimal

STRING

starting_unit

INTEGER

starting_unit_in_decimal

STRING

meta_data

STRING

mrr

INTEGER

next_billing_at

DATE-TIME

object

STRING

override_relationship

BOOLEAN

pause_date

DATE-TIME

payment_source_id

STRING

plan_amount_in_decimal

STRING

plan_free_quantity_in_decimal

STRING

plan_quantity_in_decimal

STRING

plan_unit_price_in_decimal

STRING

po_number

STRING

referral_info

OBJECT

account_id

STRING

campaign_id

STRING

coupon_code

STRING

destination_url

STRING

external_campaign_id

STRING

external_reference_id

STRING

friend_offer_type

STRING

notify_referral_system

STRING

post_purchase_widget_enabled

BOOLEAN

referral_code

STRING

referral_system

STRING

referrer_id

STRING

referrer_reward_type

STRING

reward_status

STRING

remaining_billing_cycles

INTEGER

resource_version

INTEGER

resume_date

DATE-TIME

shipping_address

OBJECT

city

STRING

company

STRING

country

STRING

email

STRING

first_name

STRING

last_name

STRING

line1

STRING

line2

STRING

line3

STRING

object

STRING

phone

STRING

state

STRING

state_code

STRING

validation_status

STRING

zip

STRING

start_date

DATE-TIME

started_at

DATE-TIME

status

STRING

subscription_items

ARRAY

amount

INTEGER

amount_in_decimal

STRING

billing_cycles

INTEGER

charge_on_event

STRING

charge_on_option

STRING

charge_once

BOOLEAN

free_quantity

INTEGER

free_quantity_in_decimal

STRING

item_price_id

STRING

item_type

STRING

object

STRING

quantity

INTEGER

quantity_in_decimal

STRING

service_period_days

INTEGER

trial_end

DATE-TIME

unit_price

INTEGER

unit_price_in_decimal

STRING

total_dues

INTEGER

trial_end

DATE-TIME

trial_end_action

STRING

trial_start

DATE-TIME

updated_at

DATE-TIME

transactions

The transactions table contains info about the transactions that have occurred in your Chargebee account.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

transactions schema on GitHub

Chargebee API method

Join transactions with on
credit_notes
transactions.customer_id = credit_notes.customer_id
transactions.linked_credit_notes.cn_reference_invoice_id = credit_notes.allocations.invoice_id
transactions.linked_credit_notes.cn_reference_invoice_id = credit_notes.reference_invoice_id
transactions.subscription_id = credit_notes.subscription_id
transactions.subscription_id = credit_notes.line_items.subscription_id
transactions.id = credit_notes.linked_refunds.txn_id
transactions.linked_refunds.txn_id = credit_notes.linked_refunds.txn_id
transactions.reference_transaction_id = credit_notes.linked_refunds.txn_id
transactions.refunded_txn_id = credit_notes.linked_refunds.txn_id
customers
transactions.customer_id = customers.id
transactions.payment_source_id = customers.primary_payment_source_id
events
transactions.customer_id = events.content.customer.id
transactions.customer_id = events.content.invoice.customer_id
transactions.customer_id = events.content.subscription.customer_id
transactions.customer_id = events.content.transaction.customer_id
transactions.linked_credit_notes.cn_reference_invoice_id = events.content.invoice.id
transactions.linked_credit_notes.cn_reference_invoice_id = events.content.transaction.linked_credit_notes.cn_reference_invoice_id
transactions.payment_source_id = events.content.subscription.payment_source_id
transactions.payment_source_id = events.content.transaction.payment_source_id
transactions.subscription_id = events.content.subscription.id
transactions.subscription_id = events.content.invoice.subscription_id
transactions.subscription_id = events.content.transaction.subscription_id
transactions.id = events.content.invoice.linked_payments.txn_id
transactions.linked_refunds.txn_id = events.content.invoice.linked_payments.txn_id
transactions.reference_transaction_id = events.content.invoice.linked_payments.txn_id
transactions.refunded_txn_id = events.content.invoice.linked_payments.txn_id
transactions.id = events.content.transaction.id
transactions.linked_refunds.txn_id = events.content.transaction.id
transactions.reference_transaction_id = events.content.transaction.id
transactions.refunded_txn_id = events.content.transaction.id
transactions.id = events.content.transaction.linked_refunds.txn_id
transactions.linked_refunds.txn_id = events.content.transaction.linked_refunds.txn_id
transactions.reference_transaction_id = events.content.transaction.linked_refunds.txn_id
transactions.refunded_txn_id = events.content.transaction.linked_refunds.txn_id
transactions.id = events.content.transaction.reference_transaction_id
transactions.linked_refunds.txn_id = events.content.transaction.reference_transaction_id
transactions.reference_transaction_id = events.content.transaction.reference_transaction_id
transactions.refunded_txn_id = events.content.transaction.reference_transaction_id
transactions.id = events.content.transaction.refunded_txn_id
transactions.linked_refunds.txn_id = events.content.transaction.refunded_txn_id
transactions.reference_transaction_id = events.content.transaction.refunded_txn_id
transactions.refunded_txn_id = events.content.transaction.refunded_txn_id
invoices
transactions.customer_id = invoices.customer_id
transactions.customer_id = invoices.notes.entity_id
transactions.linked_credit_notes.cn_reference_invoice_id = invoices.id
transactions.subscription_id = invoices.line_items.subscription_id
transactions.subscription_id = invoices.notes.entity_id
transactions.subscription_id = invoices.subscription_id
transactions.id = invoices.linked_payments.txn_id
transactions.linked_refunds.txn_id = invoices.linked_payments.txn_id
transactions.reference_transaction_id = invoices.linked_payments.txn_id
transactions.refunded_txn_id = invoices.linked_payments.txn_id
payment_sources
transactions.customer_id = payment_sources.customer_id
transactions.payment_source_id = payment_sources.id
promotional_credits
transactions.customer_id = promotional_credits.customer_id
subscriptions
transactions.customer_id = subscriptions.customer_id
transactions.payment_source_id = subscriptions.payment_source_id
transactions.subscription_id = subscriptions.id
virtual_bank_accounts
transactions.customer_id = virtual_bank_accounts.customer_id
gifts
transactions.customer_id = gifts.gift_receiver.customer_id
transactions.customer_id = gifts.gifter.customer_id
transactions.linked_credit_notes.cn_reference_invoice_id = gifts.gifter.invoice_id
transactions.subscription_id = gifts.gift_receiver.subscription_id
orders
transactions.customer_id = orders.customer_id
transactions.linked_credit_notes.cn_reference_invoice_id = orders.invoice_id
transactions.subscription_id = orders.subscription_id

amount

INTEGER

amount_capturable

STRING

amount_unused

INTEGER

authorization_reason

STRING

base_currency_code

STRING

currency_code

STRING

customer_id

STRING

date

DATE-TIME

deleted

BOOLEAN

error_code

STRING

error_text

STRING

exchange_rate

NUMBER

fraud_flag

STRING

fraud_reason

STRING

gateway

STRING

gateway_account_id

STRING

id

STRING

id_at_gateway

STRING

iin

STRING

initiator_type

STRING

last4

STRING

linked_credit_notes

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

cn_create_reason_code

STRING

cn_date

DATE-TIME

cn_id

STRING

cn_reason_code

STRING

cn_reference_invoice_id

STRING

cn_status

STRING

cn_total

INTEGER

linked_invoices

ARRAY

applied_amount

INTEGER

applied_at

DATE-TIME

invoice_date

DATE-TIME

invoice_id

STRING

invoice_status

STRING

invoice_total

INTEGER

linked_payments

ARRAY

amount

INTEGER

date

DATE-TIME

id

STRING

status

STRING

linked_refunds

ARRAY

txn_amount

INTEGER

txn_date

DATE-TIME

txn_id

STRING

txn_status

STRING

masked_card_number

STRING

merchant_reference_id

STRING

object

STRING

payment_method

STRING

payment_source_id

STRING

reference_authorization_id

STRING

reference_number

STRING

reference_transaction_id

STRING

refunded_txn_id

STRING

resource_version

INTEGER

reversal_transaction_id

STRING

reversal_txn_id

STRING

settled_at

DATE-TIME

status

STRING

subscription_id

STRING

three_d_secure

BOOLEAN

type

STRING

updated_at

DATE-TIME

validated_at

DATE-TIME

voided_at

DATE-TIME

virtual_bank_accounts

The virtual_bank_accounts table contains info about the virtual bank accounts in your Chargebee account. A virtual bank account is a unique account number that can be shared with your users while still protecting your sensitive bank account details.

Note: This table is available Refer to the Table and field availability and Chargebee Product Catalogs section for more info.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

Chargebee documentation

virtual_bank_accounts schema on GitHub

Chargebee API method

Join virtual_bank_accounts with on
credit_notes
virtual_bank_accounts.customer_id = credit_notes.customer_id
customers
virtual_bank_accounts.customer_id = customers.id
events
virtual_bank_accounts.customer_id = events.content.customer.id
virtual_bank_accounts.customer_id = events.content.invoice.customer_id
virtual_bank_accounts.customer_id = events.content.subscription.customer_id
virtual_bank_accounts.customer_id = events.content.transaction.customer_id
invoices
virtual_bank_accounts.customer_id = invoices.customer_id
virtual_bank_accounts.customer_id = invoices.notes.entity_id
payment_sources
virtual_bank_accounts.customer_id = payment_sources.customer_id
promotional_credits
virtual_bank_accounts.customer_id = promotional_credits.customer_id
subscriptions
virtual_bank_accounts.customer_id = subscriptions.customer_id
transactions
virtual_bank_accounts.customer_id = transactions.customer_id
gifts
virtual_bank_accounts.customer_id = gifts.gift_receiver.customer_id
virtual_bank_accounts.customer_id = gifts.gifter.customer_id
orders
virtual_bank_accounts.customer_id = orders.customer_id

account_number

STRING

bank_name

STRING

created_at

DATE-TIME

customer_id

STRING

deleted

BOOLEAN

email

STRING

gateway

STRING

gateway_account_id

STRING

id

STRING

object

STRING

reference_id

STRING

resource_version

INTEGER

routing_number

STRING

scheme

STRING

swift_code

STRING

updated_at

DATE-TIME


Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.