# Chargebee Chargebee is a recurring billing and subscription management tool. Chargebee integration replicates data using the [Chargebee v2 API](https://apidocs.chargebee.com/docs/api). See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#Schema) section for a list of objects available for replication. ## Preparing for authentication To access your data, you need to authenticate the connection with your account credentials. Information noteMake sure that the account you use has read access to the tables you want to fetch. To generate your API key: 1. Log into your [Chargebee account](https://app.chargebee.com/login). 2. Click Settings > Configure Chargebee > API Keys and Webhooks. 3. On the API Keys page, click + Add API Key. The Create an API Key modal is displayed. 4. Select Read-Only Key as the API key type. 5. Select All to define the API key’s access. This grants read-only access to your Chargebee site. 6. In the Name the API key field, enter QTC. 7. Click Create Key. Chargebee creates the API key and redirects you back to the API Keys page. 8. Copy and paste your API key into a secured file. ## Creating the connection For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm). 1. Fill in the required connection properties. 2. Provide a name for the connection in Connection name. 3. Select Open connection metadata to define metadata for the connection when it has been created. 4. Click Create. Connection settings | Setting | Description | | --- | --- | | Data gateway | Select a Data Movement gateway if required by your use case.

Information note

This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.

For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). | | Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. | | API Key | API key. | | Include Deleted | Select the check box to include deleted data. | | Subdomain | The subdomain for your Chargebee account.

Example: my-chargebee-site.chargebee.com, enter my-chargebee-site. | ## Schema Information note Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing. Depending on your destination, table and column names may not appear as they are outlined below. ### 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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee API method](https://apidocs.chargebee.com/Content/api/addons?prod_cat_ver=1#list_addons "Opens in new tab: Chargebee API method") | addons table foreign keys | Join addons with | on | | --- | --- | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#coupons) | ```
addons.id = coupons.addon_ids
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#events) | ```
addons.id = events.content.subscription.addons.id
```

```
addons.id = events.content.subscription.charged_event_based_addons.id
```

```
addons.id = events.content.subscription.event_based_addons.id
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#invoices) | ```
addons.id = invoices.notes.entity_id
``` | | [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#plans) | ```
addons.id = plans.applicable_addons.id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
addons.id = subscriptions.addons.id
```

```
addons.id = subscriptions.charged_event_based_addons.id
```

```
addons.id = subscriptions.event_based_addons.id
``` | addons table schema | **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

This is a nested data structure:

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** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | created\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/comments)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/comments#list_comments "Opens in new tab: Chargebee API method") | comments table schema | **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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee API method](https://apidocs.chargebee.com/Content/api/coupons#list_coupons "Opens in new tab: Chargebee API method") | coupons table foreign keys | Join coupons with | on | | --- | --- | | [addons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#addons) | ```
coupons.addon_ids = addons.id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#events) | ```
coupons.addon_ids = events.content.subscription.addons.id
```

```
coupons.addon_ids = events.content.subscription.charged_event_based_addons.id
```

```
coupons.addon_ids = events.content.subscription.event_based_addons.id
```

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

```
coupons.plan_ids = events.content.coupon.plan_ids
```

```
coupons.plan_ids = events.content.subscription.plan_id
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#invoices) | ```
coupons.addon_ids = invoices.notes.entity_id
```

```
coupons.id = invoices.discounts.entity_id
```

```
coupons.id = invoices.line_item_discounts.coupon_id
```

```
coupons.id = invoices.notes.entity_id
```

```
coupons.plan_ids = invoices.notes.entity_id
``` | | [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#plans) | ```
coupons.addon_ids = plans.applicable_addons.id
```

```
coupons.plan_ids = plans.id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
coupons.addon_ids = subscriptions.addons.id
```

```
coupons.addon_ids = subscriptions.charged_event_based_addons.id
```

```
coupons.addon_ids = subscriptions.event_based_addons.id
```

```
coupons.id = subscriptions.coupons.coupon_id
```

```
coupons.plan_ids = subscriptions.plan_id
``` | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#credit-notes) | ```
coupons.id = credit_notes.discounts.entity_id
```

```
coupons.id = credit_notes.line_item_discounts.coupon_id
``` | | [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#orders) | ```
coupons.id = orders.line_item_discounts.coupon_id
``` | coupons table schema | **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

This is a nested data structure:

currencies: ARRAY, which is also a nested data structure.
item_family_ids: ARRAY, which is also a nested data structure.
item_price_periods: ARRAY, which is also a nested data structure.
item_type: STRING

| | **item\_constraints**

ARRAY

This is a nested data structure:

constraint: STRING
item_price_ids: ARRAY, which is also a nested data structure.
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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/credit_notes)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/credit_notes#list_credit_notes "Opens in new tab: Chargebee API method") | credit\_notes table foreign keys | Join credit\_notes with | on | | --- | --- | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#coupons) | ```
credit_notes.discounts.entity_id = coupons.id
```

```
credit_notes.line_item_discounts.coupon_id = coupons.id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#customers) | ```
credit_notes.customer_id = customers.id
``` | | [payment_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#payment-sources) | ```
credit_notes.customer_id = payment_sources.customer_id
``` | | [promotional_credits](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#promotional-credits) | ```
credit_notes.customer_id = promotional_credits.customer_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#virtual-bank-accounts) | ```
credit_notes.customer_id = virtual_bank_accounts.customer_id
``` | | [gifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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
``` | credit\_notes table schema | **allocations**

ARRAY

This is a nested data structure:

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

This is a nested data structure:

amount: INTEGER
description: STRING
entity_id: STRING
entity_type: STRING
object: STRING

| | **einvoice**

OBJECT

This is a nested data structure:

id: STRING
message: STRING
status: STRING

coupon_id: STRING
discount_amount: INTEGER
discount_type: STRING
entity_id: STRING
line_item_id: STRING
object: STRING

| | **line\_item\_taxes**

ARRAY

This is a nested data structure:

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

This is a nested data structure:

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

This is a nested data structure:

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

This is a nested data structure:

applied_amount: INTEGER
applied_at: DATE-TIME
refund_reason_code: STRING
txn_amount: INTEGER
txn_date: DATE-TIME
txn_id: STRING
txn_status: STRING

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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/customers)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/customers#list_customers "Opens in new tab: Chargebee API method") | customers table foreign keys | Join customers with | on | | --- | --- | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#credit-notes) | ```
customers.id = credit_notes.customer_id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#invoices) | ```
customers.id = invoices.customer_id
```

```
customers.id = invoices.notes.entity_id
``` | | [payment_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#payment-sources) | ```
customers.id = payment_sources.customer_id
```

```
customers.primary_payment_source_id = payment_sources.id
``` | | [promotional_credits](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#promotional-credits) | ```
customers.id = promotional_credits.customer_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
customers.id = subscriptions.customer_id
```

```
customers.primary_payment_source_id = subscriptions.payment_source_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#transactions) | ```
customers.id = transactions.customer_id
```

```
customers.primary_payment_source_id = transactions.payment_source_id
``` | | [virtual_bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#virtual-bank-accounts) | ```
customers.id = virtual_bank_accounts.customer_id
``` | | [gifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#gifts) | ```
customers.id = gifts.gift_receiver.customer_id
```

```
customers.id = gifts.gifter.customer_id
``` | | [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#orders) | ```
customers.id = orders.customer_id
``` | customers table schema | **allow\_direct\_debit**

BOOLEAN | | --- | | **auto\_close\_invoices**

BOOLEAN | | **auto\_collection**

STRING | | **backup\_payment\_source\_id**

STRING | | **balances**

ARRAY

This is a nested data structure:

balance_currency_code: STRING
currency_code: STRING
excess_payments: INTEGER
object: STRING
promotional_credits: INTEGER
refundable_credits: INTEGER
unbilled_charges: INTEGER

| | **billing\_address**

OBJECT

This is a nested data structure:

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

portal_download_invoices: STRING
portal_edit_subscriptions: STRING
send_invoice_emails: BOOLEAN
send_payment_emails: BOOLEAN
send_subscription_emails: BOOLEAN

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

id: STRING
scheme: STRING
standard: STRING
value: STRING

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

This is a nested data structure:

gateway: STRING
gateway_account_id: STRING
object: STRING
reference_id: STRING
status: STRING
type: STRING

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

This is a nested data structure:

invoice_owner_id: STRING
parent_id: STRING
payment_owner_id: STRING
root_id: STRING

| | **resource\_version**

INTEGER | | **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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | occurred\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/events)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/events#list_events "Opens in new tab: Chargebee API method") | events table foreign keys | Join events with | on | | --- | --- | | [addons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#addons) | ```
events.content.subscription.addons.id = addons.id
```

```
events.content.subscription.charged_event_based_addons.id = addons.id
```

```
events.content.subscription.event_based_addons.id = addons.id
``` | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#coupons) | ```
events.content.subscription.addons.id = coupons.addon_ids
```

```
events.content.subscription.charged_event_based_addons.id = coupons.addon_ids
```

```
events.content.subscription.event_based_addons.id = coupons.addon_ids
```

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

```
events.content.coupon.plan_ids = coupons.plan_ids
```

```
events.content.subscription.plan_id = coupons.plan_ids
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#invoices) | ```
events.content.subscription.addons.id = invoices.notes.entity_id
```

```
events.content.subscription.charged_event_based_addons.id = invoices.notes.entity_id
```

```
events.content.subscription.event_based_addons.id = invoices.notes.entity_id
```

```
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.coupon.plan_ids = invoices.notes.entity_id
```

```
events.content.subscription.plan_id = invoices.notes.entity_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
``` | | [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#plans) | ```
events.content.subscription.addons.id = plans.applicable_addons.id
```

```
events.content.subscription.charged_event_based_addons.id = plans.applicable_addons.id
```

```
events.content.subscription.event_based_addons.id = plans.applicable_addons.id
```

```
events.content.coupon.plan_ids = plans.id
```

```
events.content.subscription.plan_id = plans.id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
events.content.subscription.addons.id = subscriptions.addons.id
```

```
events.content.subscription.charged_event_based_addons.id = subscriptions.addons.id
```

```
events.content.subscription.event_based_addons.id = subscriptions.addons.id
```

```
events.content.subscription.addons.id = subscriptions.charged_event_based_addons.id
```

```
events.content.subscription.charged_event_based_addons.id = subscriptions.charged_event_based_addons.id
```

```
events.content.subscription.event_based_addons.id = subscriptions.charged_event_based_addons.id
```

```
events.content.subscription.addons.id = subscriptions.event_based_addons.id
```

```
events.content.subscription.charged_event_based_addons.id = subscriptions.event_based_addons.id
```

```
events.content.subscription.event_based_addons.id = subscriptions.event_based_addons.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.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.coupon.plan_ids = subscriptions.plan_id
```

```
events.content.subscription.plan_id = subscriptions.plan_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
``` | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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
``` | | [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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
``` | events table schema | **api\_version**

STRING | | --- | | **content**

OBJECT

This is a nested data structure:

coupon: OBJECT, which is also a nested data structure.
- 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, which is also a nested data structure.
  - currencies: ARRAY, which is also a nested data structure.
  - item_family_ids: ARRAY, which is also a nested data structure.
  - item_price_periods: ARRAY, which is also a nested data structure.
  - item_type: STRING
- item_constraints: ARRAY, which is also a nested data structure.
  - constraint: STRING
  - item_price_ids: ARRAY, which is also a nested data structure.
  - 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, which is also a nested data structure.
- code: STRING
- coupon_id: STRING
- coupon_set_id: STRING
- coupon_set_name: STRING
- coupon_site_id: STRING
- status: STRING
coupon_set: OBJECT, which is also a nested data structure.
- archived_count: INTEGER
- coupon_id: STRING
- id: STRING
- meta_data: STRING
- name: STRING
- redeemed_count: INTEGER
- total_count: INTEGER
credit_note: OBJECT, which is also a nested data structure.
- allocations: ARRAY, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - amount: INTEGER
  - description: STRING
  - entity_id: STRING
  - entity_type: STRING
  - object: STRING
- einvoice: OBJECT, which is also a nested data structure.
  - id: STRING
  - message: STRING
  - status: STRING
- exchange_rate: NUMBER
- fractional_correction: INTEGER
- generated_at: DATE-TIME
- id: STRING
- line_item_discounts: ARRAY, which is also a nested data structure.
  - coupon_id: STRING
  - discount_amount: INTEGER
  - discount_type: STRING
  - entity_id: STRING
  - line_item_id: STRING
  - object: STRING
- line_item_taxes: ARRAY, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
- allow_direct_debit: BOOLEAN
- auto_close_invoices: BOOLEAN
- auto_collection: STRING
- backup_payment_source_id: STRING
- balances: ARRAY, which is also a nested data structure.
  - balance_currency_code: STRING
  - currency_code: STRING
  - excess_payments: INTEGER
  - object: STRING
  - promotional_credits: INTEGER
  - refundable_credits: INTEGER
  - unbilled_charges: INTEGER
- billing_address: OBJECT, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
- auto_claim: BOOLEAN
- claim_expiry_date: DATE-TIME
- gift_receiver: OBJECT, which is also a nested data structure.
  - customer_id: STRING
  - email: STRING
  - first_name: STRING
  - last_name: STRING
  - subscription_id: STRING
- gift_timelines: ARRAY, which is also a nested data structure.
  - occurred_at: DATE-TIME
  - status: STRING
- gifter: OBJECT, which is also a nested data structure.
  - 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, which is also a nested data structure.
- adjustment_credit_notes: ARRAY, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - amount: INTEGER
  - description: STRING
  - entity_id: STRING
  - entity_type: STRING
  - object: STRING
- due_date: DATE-TIME
- dunning_attempts: ARRAY, which is also a nested data structure.
  - attempt: INTEGER
  - created_at: DATE-TIME
  - dunning_type: STRING
  - transaction_id: STRING
  - txn_amount: INTEGER
  - txn_status: STRING
- dunning_status: STRING
- einvoice: OBJECT, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - coupon_id: STRING
  - discount_amount: INTEGER
  - discount_type: STRING
  - entity_id: STRING
  - line_item_id: STRING
  - object: STRING
- line_item_taxes: ARRAY, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
- applicable_items: ARRAY, which is also a nested data structure.
  - id: STRING
- 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, which is also a nested data structure.
- 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, which is also a nested data structure.
- accounting_detail: OBJECT, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
- amount_adjusted: INTEGER
- amount_paid: INTEGER
- batch_id: STRING
- billing_address: OBJECT, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - coupon_id: STRING
  - discount_amount: INTEGER
  - discount_type: STRING
  - line_item_id: STRING
- line_item_taxes: ARRAY, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - amount: INTEGER
  - amount_adjusted: INTEGER
  - amount_refunded: INTEGER
  - id: STRING
  - id: STRING
  - type: STRING
- note: STRING
- order_date: DATE-TIME
- order_line_items: ARRAY, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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
- 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, which is also a nested data structure.
- amazon_payment: OBJECT, which is also a nested data structure.
  - agreement_id: STRING
  - email: STRING
- bank_account: OBJECT, which is also a nested data structure.
  - account_holder_type: STRING
  - account_type: STRING
  - bank_name: STRING
  - echeck_type: STRING
  - last4: STRING
  - mandate_id: STRING
  - name_on_account: STRING
- card: OBJECT, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - created_at: DATE-TIME
  - id: STRING
  - subscription_id: STRING
- object: STRING
- paypal: OBJECT, which is also a nested data structure.
  - agreement_id: STRING
  - email: STRING
- reference_id: STRING
- resource_version: INTEGER
- status: STRING
- type: STRING
- updated_at: DATE-TIME
- upi: OBJECT, which is also a nested data structure.
  - vpa: STRING
promotional_credit: OBJECT, which is also a nested data structure.
- 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, which is also a nested data structure.
- amount_due: INTEGER
- amount_paid: INTEGER
- billing_address: OBJECT, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - amount: INTEGER
  - description: STRING
  - entity_id: STRING
  - entity_type: STRING
- id: STRING
- line_item_discounts: ARRAY, which is also a nested data structure.
  - coupon_id: STRING
  - discount_amount: INTEGER
  - discount_type: STRING
  - entity_id: STRING
  - line_item_id: STRING
- line_item_taxes: ARRAY, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, ARRAY, which is also a nested data structure.
  - 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, which is also a nested data structure.
- object: STRING
- operation_type: STRING
- po_number: STRING
- price_type: STRING
- resource_version: INTEGER
- shipping_address: OBJECT, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
- 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, which is also a nested data structure.
  - item_price_id: STRING
  - last_charged_at: DATE-TIME
  - object: STRING
- contract_term: OBJECT, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
- 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, which is also a nested data structure.
  - 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: STRING
- linked_invoices: ARRAY, which is also a nested data structure.
  - applied_amount: INTEGER
  - applied_at: DATE-TIME
  - invoice_date: DATE-TIME
  - invoice_id: STRING
  - invoice_status: STRING
  - invoice_total: INTEGER
- linked_payments: ARRAY, which is also a nested data structure.
  - amount: INTEGER
  - date: DATE-TIME
  - id: STRING
  - status: STRING
- linked_refunds: ARRAY, which is also a nested data structure.
  - 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: OBJECT, which is also a nested data structure.
- 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, which is also a nested data structure.
  - 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, which is also a nested data structure.
- 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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/gifts)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/gifts#list_gifts "Opens in new tab: Chargebee API method") | gifts table foreign keys | Join gifts with | on | | --- | --- | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#customers) | ```
gifts.gift_receiver.customer_id = customers.id
```

```
gifts.gifter.customer_id = customers.id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#payment-sources) | ```
gifts.gift_receiver.customer_id = payment_sources.customer_id
```

```
gifts.gifter.customer_id = payment_sources.customer_id
``` | | [promotional_credits](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#promotional-credits) | ```
gifts.gift_receiver.customer_id = promotional_credits.customer_id
```

```
gifts.gifter.customer_id = promotional_credits.customer_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
gifts.gift_receiver.customer_id = subscriptions.customer_id
```

```
gifts.gifter.customer_id = subscriptions.customer_id
```

```
gifts.id = subscriptions.gift_id
```

```
gifts.gift_receiver.subscription_id = subscriptions.id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#virtual-bank-accounts) | ```
gifts.gift_receiver.customer_id = virtual_bank_accounts.customer_id
```

```
gifts.gifter.customer_id = virtual_bank_accounts.customer_id
``` | | [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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
``` | gifts table schema | **auto\_claim**

BOOLEAN | | --- | | **claim\_expiry\_date**

DATE-TIME | | **gift\_receiver**

OBJECT

This is a nested data structure:

customer_id: STRING
email: STRING
first_name: STRING
last_name: STRING
subscription_id: STRING

| | **gift\_timelines**

ARRAY

This is a nested data structure:

occurred_at: DATE-TIME
status: STRING

| | **gifter**

OBJECT

This is a nested data structure:

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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/invoices)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/invoices#list_invoices "Opens in new tab: Chargebee API method") | invoices table foreign keys | Join invoices with | on | | --- | --- | | [addons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#addons) | ```
invoices.notes.entity_id = addons.id
``` | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#coupons) | ```
invoices.notes.entity_id = coupons.addon_ids
```

```
invoices.discounts.entity_id = coupons.id
```

```
invoices.line_item_discounts.coupon_id = coupons.id
```

```
invoices.notes.entity_id = coupons.id
```

```
invoices.notes.entity_id = coupons.plan_ids
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#events) | ```
invoices.notes.entity_id = events.content.subscription.addons.id
```

```
invoices.notes.entity_id = events.content.subscription.charged_event_based_addons.id
```

```
invoices.notes.entity_id = events.content.subscription.event_based_addons.id
```

```
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.notes.entity_id = events.content.coupon.plan_ids
```

```
invoices.notes.entity_id = events.content.subscription.plan_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
``` | | [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#plans) | ```
invoices.notes.entity_id = plans.applicable_addons.id
```

```
invoices.notes.entity_id = plans.id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
invoices.notes.entity_id = subscriptions.addons.id
```

```
invoices.notes.entity_id = subscriptions.charged_event_based_addons.id
```

```
invoices.notes.entity_id = subscriptions.event_based_addons.id
```

```
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.notes.entity_id = subscriptions.plan_id
```

```
invoices.line_items.subscription_id = subscriptions.id
```

```
invoices.notes.entity_id = subscriptions.id
```

```
invoices.subscription_id = subscriptions.id
``` | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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
``` | | [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#customers) | ```
invoices.customer_id = customers.id
```

```
invoices.notes.entity_id = customers.id
``` | | [payment_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#payment-sources) | ```
invoices.customer_id = payment_sources.customer_id
```

```
invoices.notes.entity_id = payment_sources.customer_id
``` | | [promotional_credits](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#promotional-credits) | ```
invoices.customer_id = promotional_credits.customer_id
```

```
invoices.notes.entity_id = promotional_credits.customer_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#virtual-bank-accounts) | ```
invoices.customer_id = virtual_bank_accounts.customer_id
```

```
invoices.notes.entity_id = virtual_bank_accounts.customer_id
``` | | [gifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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
``` | invoices table schema | **adjustment\_credit\_notes**

ARRAY

This is a nested data structure:

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

This is a nested data structure:

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

This is a nested data structure:

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

amount: INTEGER
description: STRING
entity_id: STRING
entity_type: STRING
object: STRING

| | **due\_date**

DATE-TIME | | **dunning\_attempts**

ARRAY

This is a nested data structure:

attempt: INTEGER
created_at: DATE-TIME
dunning_type: STRING
transaction_id: STRING
txn_amount: INTEGER
txn_status: STRING

| | **dunning\_status**

STRING | | **einvoice**

OBJECT

This is a nested data structure:

id: STRING
message: STRING
status: STRING

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

This is a nested data structure:

coupon_id: STRING
discount_amount: INTEGER
discount_type: STRING
entity_id: STRING
line_item_id: STRING
object: STRING

| | **line\_item\_taxes**

ARRAY

This is a nested data structure:

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

This is a nested data structure:

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

This is a nested data structure:

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

This is a nested data structure:

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

This is a nested data structure:

applied_amount: INTEGER
applied_at: DATE-TIME
txn_amount: INTEGER
txn_date: DATE-TIME
txn_id: STRING
txn_status: STRING

entity_id: STRING
entity_type: STRING
note: STRING

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

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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee API method](https://apidocs.chargebee.com/Content/api/item_families?prod_cat_ver=2#list_item_families "Opens in new tab: Chargebee API method") | item\_families table foreign keys | Join item\_families with | on | | --- | --- | | [item_prices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#item-prices) | ```
item_families.id = item_prices.item_family_id
``` | | [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#items) | ```
item_families.id = items.item_family_id
``` | item\_families table schema | **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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee API method](https://apidocs.chargebee.com/Content/api/item_prices?prod_cat_ver=2#list_item_prices "Opens in new tab: Chargebee API method") | item\_prices table foreign keys | Join item\_prices with | on | | --- | --- | | [item_families](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#item-families) | ```
item_prices.item_family_id = item_families.id
``` | | [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#items) | ```
item_prices.item_family_id = items.item_family_id
```

```
item_prices.item_id = items.id
``` | item\_prices table schema | **accounting\_detail**

OBJECT

This is a nested data structure:

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

This is a nested data structure:

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

This is a nested data structure:

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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee API method](https://apidocs.chargebee.com/Content/api/items?prod_cat_ver=2#list_items "Opens in new tab: Chargebee API method") | items table foreign keys | Join items with | on | | --- | --- | | [item_families](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#item-families) | ```
items.item_family_id = item_families.id
``` | | [item_prices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#item-prices) | ```
items.item_family_id = item_prices.item_family_id
```

```
items.id = item_prices.item_id
``` | items table schema | **applicable\_items**

ARRAY

This is a nested data structure:

id: STRING

| | --- | | **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](https://www.chargebee.com/Content/orders.html). **Note**: This table is available Refer to the [Table and field availability and Chargebee Product Catalogs section](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/orders)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/orders#list_orders "Opens in new tab: Chargebee API method") | orders table foreign keys | Join orders with | on | | --- | --- | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#coupons) | ```
orders.line_item_discounts.coupon_id = coupons.id
``` | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
orders.line_item_discounts.coupon_id = subscriptions.coupons.coupon_id
```

```
orders.customer_id = subscriptions.customer_id
```

```
orders.gift_id = subscriptions.gift_id
```

```
orders.subscription_id = subscriptions.id
``` | | [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#customers) | ```
orders.customer_id = customers.id
``` | | [payment_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#payment-sources) | ```
orders.customer_id = payment_sources.customer_id
``` | | [promotional_credits](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#promotional-credits) | ```
orders.customer_id = promotional_credits.customer_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#virtual-bank-accounts) | ```
orders.customer_id = virtual_bank_accounts.customer_id
``` | | [gifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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
``` | orders table schema | **amount\_adjusted**

INTEGER | | --- | | **amount\_paid**

INTEGER | | **batch\_id**

STRING | | **billing\_address**

OBJECT

This is a nested data structure:

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

coupon_id: STRING
discount_amount: INTEGER
discount_type: STRING
line_item_id: STRING

| | **line\_item\_taxes**

ARRAY

This is a nested data structure:

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

This is a nested data structure:

amount: INTEGER
amount_adjusted: INTEGER
amount_refunded: INTEGER
id: STRING
status: STRING
type: STRING

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

amount: INTEGER
order_id: STRING
reason: STRING

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

| | **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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/payment_sources)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/payment_sources#list_payment_sources "Opens in new tab: Chargebee API method") | payment\_sources table foreign keys | Join payment\_sources with | on | | --- | --- | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#credit-notes) | ```
payment_sources.customer_id = credit_notes.customer_id
``` | | [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#customers) | ```
payment_sources.customer_id = customers.id
```

```
payment_sources.id = customers.primary_payment_source_id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#invoices) | ```
payment_sources.customer_id = invoices.customer_id
```

```
payment_sources.customer_id = invoices.notes.entity_id
``` | | [promotional_credits](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#promotional-credits) | ```
payment_sources.customer_id = promotional_credits.customer_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
payment_sources.customer_id = subscriptions.customer_id
```

```
payment_sources.id = subscriptions.payment_source_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#transactions) | ```
payment_sources.customer_id = transactions.customer_id
```

```
payment_sources.id = transactions.payment_source_id
``` | | [virtual_bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#virtual-bank-accounts) | ```
payment_sources.customer_id = virtual_bank_accounts.customer_id
``` | | [gifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#gifts) | ```
payment_sources.customer_id = gifts.gift_receiver.customer_id
```

```
payment_sources.customer_id = gifts.gifter.customer_id
``` | | [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#orders) | ```
payment_sources.customer_id = orders.customer_id
``` | payment\_sources table schema | **amazon\_payment**

OBJECT

This is a nested data structure:

agreement_id: STRING
email: STRING

| | --- | | **bank\_account**

OBJECT

This is a nested data structure:

account_holder_type: STRING
account_type: STRING
bank_name: STRING
echeck_type: STRING
last4: STRING
mandate_id: STRING
name_on_account: STRING

| | **card**

OBJECT

This is a nested data structure:

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
id: STRING
subscription_id: STRING

| | **object**

STRING | | **paypal**

OBJECT

This is a nested data structure:

agremeent_id: STRING
email: STRING

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`](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions). **Note**: This table is available Refer to the [Table and field availability and Chargebee Product Catalogs section](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee API method](https://apidocs.chargebee.com/Content/api/plans?prod_cat_ver=1#list_plans "Opens in new tab: Chargebee API method") | plans table foreign keys | Join plans with | on | | --- | --- | | [addons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#addons) | ```
plans.applicable_addons.id = addons.id
``` | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#coupons) | ```
plans.applicable_addons.id = coupons.addon_ids
```

```
plans.id = coupons.plan_ids
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#events) | ```
plans.applicable_addons.id = events.content.subscription.addons.id
```

```
plans.applicable_addons.id = events.content.subscription.charged_event_based_addons.id
```

```
plans.applicable_addons.id = events.content.subscription.event_based_addons.id
```

```
plans.id = events.content.coupon.plan_ids
```

```
plans.id = events.content.subscription.plan_id
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#invoices) | ```
plans.applicable_addons.id = invoices.notes.entity_id
```

```
plans.id = invoices.notes.entity_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
plans.applicable_addons.id = subscriptions.addons.id
```

```
plans.applicable_addons.id = subscriptions.charged_event_based_addons.id
```

```
plans.applicable_addons.id = subscriptions.event_based_addons.id
```

```
plans.id = subscriptions.plan_id
``` | plans table schema | **account\_code**

STRING | | --- | | **accounting\_category1**

STRING | | **accounting\_category2**

STRING | | **accounting\_category3**

STRING | | **accounting\_category4**

STRING | | **accounting\_code**

STRING | | **addon\_applicability**

STRING | | **applicable\_addons**

ARRAY

This is a nested data structure:

id: STRING
quantity_in_decimal: STRING

| | **archived\_at**

DATE-TIME | | **attached\_addons**

ARRAY

This is a nested data structure:

billing_cycles: INTEGER
id: STRING
quantity: STRING
quantity_in_decimal: STRING
type: STRING

charge_once: BOOLEAN
id: STRING
on_event: STRING
quantity: INTEGER
quantity_in_decimal: STRING

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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | created\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/promotional_credits)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/promotional_credits#list_promotional_credits "Opens in new tab: Chargebee API method") | promotional\_credits table foreign keys | Join promotional\_credits with | on | | --- | --- | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#credit-notes) | ```
promotional_credits.customer_id = credit_notes.customer_id
``` | | [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#customers) | ```
promotional_credits.customer_id = customers.id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#invoices) | ```
promotional_credits.customer_id = invoices.customer_id
```

```
promotional_credits.customer_id = invoices.notes.entity_id
``` | | [payment_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#payment-sources) | ```
promotional_credits.customer_id = payment_sources.customer_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
promotional_credits.customer_id = subscriptions.customer_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#transactions) | ```
promotional_credits.customer_id = transactions.customer_id
``` | | [virtual_bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#virtual-bank-accounts) | ```
promotional_credits.customer_id = virtual_bank_accounts.customer_id
``` | | [gifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#gifts) | ```
promotional_credits.customer_id = gifts.gift_receiver.customer_id
```

```
promotional_credits.customer_id = gifts.gifter.customer_id
``` | | [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#orders) | ```
promotional_credits.customer_id = orders.customer_id
``` | promotional\_credits table schema | **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** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/quotes)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/quotes#list_quotes "Opens in new tab: Chargebee API method") | quotes table schema | **amount\_due**

INTEGER | | --- | | **amount\_paid**

INTEGER | | **billing\_address**

OBJECT

This is a nested data structure:

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

amount: INTEGER
description: STRING
entity_id: STRING
entity_type: STRING
object: STRING

coupon_id: STRING
discount_amount: INTEGER
discount_type: STRING
entity_id: STRING
line_item_id: STRING

| | **line\_item\_taxes**

ARRAY

This is a nested data structure:

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

This is a nested data structure:

ending_unit: INTEGER
line_item_id: STRING
quantity_used: INTEGER
starting_unit: INTEGER
unit_amount: INTEGER

| | **line\_items**

ARRAY

This is a nested data structure:

amount: INTEGER
date_from: 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: NUMBER
unit_amount: INTEGER

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

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`](https://apidocs.chargebee.com/Content/api/subscriptions#subscription_updated_at) value when the following attributes on a subscription are modified: * `due_invoices_count` * `due_since` * `total_dues` **Note**: This table is available Refer to the [Table and field availability and Chargebee Product Catalogs section](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/subscriptions)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/subscriptions#list_subscriptions "Opens in new tab: Chargebee API method") | subscriptions table foreign keys | Join subscriptions with | on | | --- | --- | | [addons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#addons) | ```
subscriptions.addons.id = addons.id
```

```
subscriptions.charged_event_based_addons.id = addons.id
```

```
subscriptions.event_based_addons.id = addons.id
``` | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#coupons) | ```
subscriptions.addons.id = coupons.addon_ids
```

```
subscriptions.charged_event_based_addons.id = coupons.addon_ids
```

```
subscriptions.event_based_addons.id = coupons.addon_ids
```

```
subscriptions.coupons.coupon_id = coupons.id
```

```
subscriptions.plan_id = coupons.plan_ids
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#events) | ```
subscriptions.addons.id = events.content.subscription.addons.id
```

```
subscriptions.charged_event_based_addons.id = events.content.subscription.addons.id
```

```
subscriptions.event_based_addons.id = events.content.subscription.addons.id
```

```
subscriptions.addons.id = events.content.subscription.charged_event_based_addons.id
```

```
subscriptions.charged_event_based_addons.id = events.content.subscription.charged_event_based_addons.id
```

```
subscriptions.event_based_addons.id = events.content.subscription.charged_event_based_addons.id
```

```
subscriptions.addons.id = events.content.subscription.event_based_addons.id
```

```
subscriptions.charged_event_based_addons.id = events.content.subscription.event_based_addons.id
```

```
subscriptions.event_based_addons.id = events.content.subscription.event_based_addons.id
```

```
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.plan_id = events.content.coupon.plan_ids
```

```
subscriptions.plan_id = events.content.subscription.plan_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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#invoices) | ```
subscriptions.addons.id = invoices.notes.entity_id
```

```
subscriptions.charged_event_based_addons.id = invoices.notes.entity_id
```

```
subscriptions.event_based_addons.id = invoices.notes.entity_id
```

```
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.plan_id = invoices.notes.entity_id
```

```
subscriptions.id = invoices.line_items.subscription_id
```

```
subscriptions.id = invoices.notes.entity_id
```

```
subscriptions.id = invoices.subscription_id
``` | | [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#plans) | ```
subscriptions.addons.id = plans.applicable_addons.id
```

```
subscriptions.charged_event_based_addons.id = plans.applicable_addons.id
```

```
subscriptions.event_based_addons.id = plans.applicable_addons.id
```

```
subscriptions.plan_id = plans.id
``` | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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
``` | | [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#orders) | ```
subscriptions.coupons.coupon_id = orders.line_item_discounts.coupon_id
```

```
subscriptions.customer_id = orders.customer_id
```

```
subscriptions.gift_id = orders.gift_id
```

```
subscriptions.id = orders.subscription_id
``` | | [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#customers) | ```
subscriptions.customer_id = customers.id
```

```
subscriptions.payment_source_id = customers.primary_payment_source_id
``` | | [payment_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#payment-sources) | ```
subscriptions.customer_id = payment_sources.customer_id
```

```
subscriptions.payment_source_id = payment_sources.id
``` | | [promotional_credits](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#promotional-credits) | ```
subscriptions.customer_id = promotional_credits.customer_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#transactions) | ```
subscriptions.customer_id = transactions.customer_id
```

```
subscriptions.payment_source_id = transactions.payment_source_id
```

```
subscriptions.id = transactions.subscription_id
``` | | [virtual_bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#virtual-bank-accounts) | ```
subscriptions.customer_id = virtual_bank_accounts.customer_id
``` | | [gifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#gifts) | ```
subscriptions.customer_id = gifts.gift_receiver.customer_id
```

```
subscriptions.customer_id = gifts.gifter.customer_id
```

```
subscriptions.gift_id = gifts.id
```

```
subscriptions.id = gifts.gift_receiver.subscription_id
``` | subscriptions table schema | **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

This is a nested data structure:

item_price_id: STRING
last_charged_at: DATE-TIME
object: STRING

| | **contract\_term**

OBJECT

This is a nested data structure:

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

This is a nested data structure:

applied_count: INTEGER
apply_till: DATE-TIME
coupon_code: STRING
coupon_id: STRING
object: STRING

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

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

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

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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/transactions)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/transactions#list_transactions "Opens in new tab: Chargebee API method") | transactions table foreign keys | Join transactions with | on | | --- | --- | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#customers) | ```
transactions.customer_id = customers.id
```

```
transactions.payment_source_id = customers.primary_payment_source_id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#payment-sources) | ```
transactions.customer_id = payment_sources.customer_id
```

```
transactions.payment_source_id = payment_sources.id
``` | | [promotional_credits](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#promotional-credits) | ```
transactions.customer_id = promotional_credits.customer_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
transactions.customer_id = subscriptions.customer_id
```

```
transactions.payment_source_id = subscriptions.payment_source_id
```

```
transactions.subscription_id = subscriptions.id
``` | | [virtual_bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#virtual-bank-accounts) | ```
transactions.customer_id = virtual_bank_accounts.customer_id
``` | | [gifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#orders) | ```
transactions.customer_id = orders.customer_id
```

```
transactions.linked_credit_notes.cn_reference_invoice_id = orders.invoice_id
```

```
transactions.subscription_id = orders.subscription_id
``` | transactions table schema | **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

This is a nested data structure:

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

This is a nested data structure:

applied_amount: INTEGER
applied_at: DATE-TIME
invoice_date: DATE-TIME
invoice_id: STRING
invoice_status: STRING
invoice_total: INTEGER

| | **linked\_payments**

ARRAY

This is a nested data structure:

amount: INTEGER
date: DATE-TIME
id: STRING
status: STRING

| | **linked\_refunds**

ARRAY

This is a nested data structure:

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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#product-catalog-versions) for more info. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | updated\_at | | **Useful links** | [Chargebee documentation](https://apidocs.chargebee.com/Content/api/virtual_bank_accounts)

[Chargebee API method](https://apidocs.chargebee.com/Content/api/virtual_bank_accounts#list_virtual_bank_accounts "Opens in new tab: Chargebee API method") | virtual\_bank\_accounts table foreign keys | Join virtual\_bank\_accounts with | on | | --- | --- | | [credit_notes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#credit-notes) | ```
virtual_bank_accounts.customer_id = credit_notes.customer_id
``` | | [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#customers) | ```
virtual_bank_accounts.customer_id = customers.id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#invoices) | ```
virtual_bank_accounts.customer_id = invoices.customer_id
```

```
virtual_bank_accounts.customer_id = invoices.notes.entity_id
``` | | [payment_sources](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#payment-sources) | ```
virtual_bank_accounts.customer_id = payment_sources.customer_id
``` | | [promotional_credits](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#promotional-credits) | ```
virtual_bank_accounts.customer_id = promotional_credits.customer_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#subscriptions) | ```
virtual_bank_accounts.customer_id = subscriptions.customer_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#transactions) | ```
virtual_bank_accounts.customer_id = transactions.customer_id
``` | | [gifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#gifts) | ```
virtual_bank_accounts.customer_id = gifts.gift_receiver.customer_id
```

```
virtual_bank_accounts.customer_id = gifts.gifter.customer_id
``` | | [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargebee.htm#orders) | ```
virtual_bank_accounts.customer_id = orders.customer_id
``` | virtual\_bank\_accounts table schema | **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 |