Chargebee

Chargebee is a recurring billing and subscription management tool.

Chargebee integration replicates data using the Chargebee v2 API.

See the Schema section for a list of objects available for replication.

便利なリンクやサポートされている機能など、このコネクタの概要について説明します。

機能/性能	サポートの詳細
サポートされている Qlik Talend Data Integration プロジェクト	レプリケーションプロジェクトのみ。データパイプラインプロジェクトはサポートされていません。
ターゲットの更新方法	レプリケーションタスク: 変更を適用変更の保存データレイクタスクにデータをランディング: 変更データキャプチャ (CDC)
メタデータの管理	手動でのメタデータ生成は必要ありません。
スキーマの進化	[列のデータ型を変更] 操作のみサポートされています。
LOB 列 (NCLOB、CLOB、BLOB) のレプリケーション	サポートされていません。
スケジュールされた CDC	必須。これにより、ソースの変更に応じてターゲットが最新の状態に保たれます。レプリケーションタスクについては、「タスクのスケジューリング」を参照してください。レイクランディングタスクについては、「レイクランディングタスクの CDC のスケジュール設定」を参照してください。
通知	部分的にサポート動作変更時の通知の設定
監視	このコネクタではフルロードは関係ないため、CDC のみ。個々のデータタスクの監視
JSON 列ペイロードの自動ネスト解除	サポートされていません。ソースデータセット内の JSON 列ペイロードは、ターゲット上で自動的にネスト解除されません。

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

使用するアカウントに、フェッチするテーブルへのアクセス権があることを確認してください。

To generate your API key:

Log into your Chargebee account.
Click Settings > Configure Chargebee > API Keys and Webhooks.
On the API Keys page, click + Add API Key. The Create an API Key modal is displayed.
Select Read-Only Key as the API key type.
Select All to define the API key’s access. This grants read-only access to your Chargebee site.
In the Name the API key field, enter QTC.
Click Create Key. Chargebee creates the API key and redirects you back to the API Keys page.
Copy and paste your API key into a secured file.

Creating the connection

詳細については、「SaaSアプリケーションへの接続」を参照してください。

必要な接続プロパティを入力します。
接続名に接続の名前を入力します。
接続メタデータを開くを選択して、作成時の接続のメタデータを定義します。
[作成] をクリックします。

Connection settings
Setting	Description
Data gateway	ユースケースに応じて Data Movement gateway を選択します。情報メモ Qlik Talend Cloud スターターサブスクリプションでは Data Movement gateway をサポートしていないため、この項目は使用できません。別のサブスクリプションティアを利用しており、Data Movement gateway を使用しない場合は、 [None] (なし) を選択します。 Data Movement gateway の利点とそれを必要とするユースケースの詳細については、「Qlik データゲートウェイ - データ移動」を参照してください。
Start Date	ソースからターゲットにデータをレプリケートする必要がある日付を `MM/DD/YYYY` 形式で入力します。
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

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

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 for more info.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee API method

Join addons with	on
coupons	addons.id = coupons.addon_ids
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	addons.id = invoices.notes.entity_id
plans	addons.id = plans.applicable_addons.id
subscriptions	addons.id = subscriptions.addons.id addons.id = subscriptions.charged_event_based_addons.id addons.id = subscriptions.event_based_addons.id

accounting_category1

STRING

accounting_category2

STRING

accounting_category3

STRING

accounting_category4

STRING

accounting_code

STRING

archived_at

DATE-TIME

avalara_sale_type

STRING

avalara_service_type

INTEGER

avalara_transaction_type

INTEGER

channel

STRING

charge_type

STRING

currency_code

STRING

custom_fields

STRING

description

STRING

enabled_in_portal

BOOLEAN

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 Chargebee API method

added_by

STRING

created_at

DATE-TIME

entity_id

STRING

entity_type

STRING

notes

STRING

object

STRING

type

STRING

coupons

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

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee API method

Join coupons with	on
addons	coupons.addon_ids = addons.id
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	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	coupons.addon_ids = plans.applicable_addons.id coupons.plan_ids = plans.id
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	coupons.id = credit_notes.discounts.entity_id coupons.id = credit_notes.line_item_discounts.coupon_id
orders	coupons.id = orders.line_item_discounts.coupon_id

apply_discount_on

STRING

apply_on

STRING

archived_at

DATE-TIME

created_at

DATE-TIME

currency_code

STRING

discount_amount

NUMBER

discount_percentage

NUMBER

discount_type

STRING

duration_month

INTEGER

duration_type

STRING

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 for more info.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee documentation Chargebee API method

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

allocations

ARRAY

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

exchange_rate

NUMBER

fractional_correction

INTEGER

generated_at

DATE-TIME

STRING

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

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

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

customers

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

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee documentation Chargebee API method

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

allow_direct_debit

BOOLEAN

auto_close_invoices

BOOLEAN

auto_collection

STRING

backup_payment_source_id

STRING

balances

ARRAY

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

billing_date

BOOLEAN

billing_date_mode

STRING

billing_day_of_week

BOOLEAN

billing_day_of_week_mode

STRING

business_customer_without_vat_number

BOOLEAN

card_status

STRING

cf_company_id

INTEGER, STRING

channel

STRING

child_account_access

OBJECT

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

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

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

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

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

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

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

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 for more info.

Replication Method	CDC
Primary Key	id
Replication Key	occurred_at
Useful links	Chargebee documentation Chargebee API method

Join events with	on
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	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	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	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	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	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	events.content.coupon.id = orders.line_item_discounts.coupon_id events.content.invoice.discounts.entity_id = orders.line_item_discounts.coupon_id events.content.invoice.line_item_discounts.coupon_id = orders.line_item_discounts.coupon_id events.content.subscription.coupons.coupon_id = orders.line_item_discounts.coupon_id events.content.invoice.adjustment_credit_notes.cn_id = orders.linked_credit_notes.id events.content.invoice.applied_credits.cn_id = orders.linked_credit_notes.id events.content.invoice.issued_credit_notes.cn_id = orders.linked_credit_notes.id events.content.customer.id = orders.customer_id events.content.invoice.customer_id = orders.customer_id events.content.subscription.customer_id = orders.customer_id events.content.transaction.customer_id = orders.customer_id events.content.invoice.id = orders.invoice_id events.content.transaction.linked_credit_notes.cn_reference_invoice_id = orders.invoice_id events.content.invoice.line_item_discounts.line_item_id = orders.line_item_discounts.line_item_id events.content.invoice.line_item_taxes.line_item_id = orders.line_item_discounts.line_item_id events.content.invoice.line_items.id = orders.line_item_discounts.line_item_id events.content.invoice.line_item_discounts.line_item_id = orders.line_item_taxes.line_item_id events.content.invoice.line_item_taxes.line_item_id = orders.line_item_taxes.line_item_id events.content.invoice.line_items.id = orders.line_item_taxes.line_item_id events.content.subscription.id = orders.subscription_id events.content.invoice.subscription_id = orders.subscription_id events.content.transaction.subscription_id = orders.subscription_id
customers	events.content.customer.id = customers.id events.content.invoice.customer_id = customers.id events.content.subscription.customer_id = customers.id events.content.transaction.customer_id = customers.id events.content.subscription.payment_source_id = customers.primary_payment_source_id events.content.transaction.payment_source_id = customers.primary_payment_source_id
payment_sources	events.content.customer.id = payment_sources.customer_id events.content.invoice.customer_id = payment_sources.customer_id events.content.subscription.customer_id = payment_sources.customer_id events.content.transaction.customer_id = payment_sources.customer_id events.content.subscription.payment_source_id = payment_sources.id events.content.transaction.payment_source_id = payment_sources.id
promotional_credits	events.content.customer.id = promotional_credits.customer_id events.content.invoice.customer_id = promotional_credits.customer_id events.content.subscription.customer_id = promotional_credits.customer_id events.content.transaction.customer_id = promotional_credits.customer_id
transactions	events.content.customer.id = transactions.customer_id events.content.invoice.customer_id = transactions.customer_id events.content.subscription.customer_id = transactions.customer_id events.content.transaction.customer_id = transactions.customer_id events.content.invoice.id = transactions.linked_credit_notes.cn_reference_invoice_id events.content.transaction.linked_credit_notes.cn_reference_invoice_id = transactions.linked_credit_notes.cn_reference_invoice_id events.content.subscription.payment_source_id = transactions.payment_source_id events.content.transaction.payment_source_id = transactions.payment_source_id events.content.subscription.id = transactions.subscription_id events.content.invoice.subscription_id = transactions.subscription_id events.content.transaction.subscription_id = transactions.subscription_id events.content.invoice.linked_payments.txn_id = transactions.id events.content.transaction.id = transactions.id events.content.transaction.linked_refunds.txn_id = transactions.id events.content.transaction.reference_transaction_id = transactions.id events.content.transaction.refunded_txn_id = transactions.id events.content.invoice.linked_payments.txn_id = transactions.linked_refunds.txn_id events.content.transaction.id = transactions.linked_refunds.txn_id events.content.transaction.linked_refunds.txn_id = transactions.linked_refunds.txn_id events.content.transaction.reference_transaction_id = transactions.linked_refunds.txn_id events.content.transaction.refunded_txn_id = transactions.linked_refunds.txn_id events.content.invoice.linked_payments.txn_id = transactions.reference_transaction_id events.content.transaction.id = transactions.reference_transaction_id events.content.transaction.linked_refunds.txn_id = transactions.reference_transaction_id events.content.transaction.reference_transaction_id = transactions.reference_transaction_id events.content.transaction.refunded_txn_id = transactions.reference_transaction_id events.content.invoice.linked_payments.txn_id = transactions.refunded_txn_id events.content.transaction.id = transactions.refunded_txn_id events.content.transaction.linked_refunds.txn_id = transactions.refunded_txn_id events.content.transaction.reference_transaction_id = transactions.refunded_txn_id events.content.transaction.refunded_txn_id = transactions.refunded_txn_id
virtual_bank_accounts	events.content.customer.id = virtual_bank_accounts.customer_id events.content.invoice.customer_id = virtual_bank_accounts.customer_id events.content.subscription.customer_id = virtual_bank_accounts.customer_id events.content.transaction.customer_id = virtual_bank_accounts.customer_id
gifts	events.content.customer.id = gifts.gift_receiver.customer_id events.content.invoice.customer_id = gifts.gift_receiver.customer_id events.content.subscription.customer_id = gifts.gift_receiver.customer_id events.content.transaction.customer_id = gifts.gift_receiver.customer_id events.content.customer.id = gifts.gifter.customer_id events.content.invoice.customer_id = gifts.gifter.customer_id events.content.subscription.customer_id = gifts.gifter.customer_id events.content.transaction.customer_id = gifts.gifter.customer_id events.content.invoice.id = gifts.gifter.invoice_id events.content.transaction.linked_credit_notes.cn_reference_invoice_id = gifts.gifter.invoice_id events.content.subscription.id = gifts.gift_receiver.subscription_id events.content.invoice.subscription_id = gifts.gift_receiver.subscription_id events.content.transaction.subscription_id = gifts.gift_receiver.subscription_id

api_version

STRING

content

OBJECT

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

object

STRING

occurred_at

DATE-TIME

source

STRING

user

STRING

webhook_status

STRING

gifts

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

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee documentation Chargebee API method

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

auto_claim

BOOLEAN

claim_expiry_date

DATE-TIME

gift_receiver

OBJECT

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

STRING

no_expiry

BOOLEAN

resource_version

INTEGER

scheduled_at

DATE-TIME

status

STRING

updated_at

DATE-TIME

invoices

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

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee documentation Chargebee API method

Join invoices with	on
addons	invoices.notes.entity_id = addons.id
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	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	invoices.notes.entity_id = plans.applicable_addons.id invoices.notes.entity_id = plans.id
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	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	invoices.discounts.entity_id = orders.line_item_discounts.coupon_id invoices.line_item_discounts.coupon_id = orders.line_item_discounts.coupon_id invoices.notes.entity_id = orders.line_item_discounts.coupon_id invoices.adjustment_credit_notes.cn_id = orders.linked_credit_notes.id invoices.applied_credits.cn_id = orders.linked_credit_notes.id invoices.issued_credit_notes.cn_id = orders.linked_credit_notes.id invoices.customer_id = orders.customer_id invoices.notes.entity_id = orders.customer_id invoices.id = orders.invoice_id invoices.line_item_discounts.line_item_id = orders.line_item_discounts.line_item_id invoices.line_item_taxes.line_item_id = orders.line_item_discounts.line_item_id invoices.line_item_tiers.line_item_id = orders.line_item_discounts.line_item_id invoices.line_items.id = orders.line_item_discounts.line_item_id invoices.line_item_discounts.line_item_id = orders.line_item_taxes.line_item_id invoices.line_item_taxes.line_item_id = orders.line_item_taxes.line_item_id invoices.line_item_tiers.line_item_id = orders.line_item_taxes.line_item_id invoices.line_items.id = orders.line_item_taxes.line_item_id invoices.line_items.subscription_id = orders.subscription_id invoices.notes.entity_id = orders.subscription_id invoices.subscription_id = orders.subscription_id invoices.linked_orders.id = orders.id
customers	invoices.customer_id = customers.id invoices.notes.entity_id = customers.id
payment_sources	invoices.customer_id = payment_sources.customer_id invoices.notes.entity_id = payment_sources.customer_id
promotional_credits	invoices.customer_id = promotional_credits.customer_id invoices.notes.entity_id = promotional_credits.customer_id
transactions	invoices.customer_id = transactions.customer_id invoices.notes.entity_id = transactions.customer_id invoices.id = transactions.linked_credit_notes.cn_reference_invoice_id invoices.line_items.subscription_id = transactions.subscription_id invoices.notes.entity_id = transactions.subscription_id invoices.subscription_id = transactions.subscription_id invoices.linked_payments.txn_id = transactions.id invoices.linked_payments.txn_id = transactions.linked_refunds.txn_id invoices.linked_payments.txn_id = transactions.reference_transaction_id invoices.linked_payments.txn_id = transactions.refunded_txn_id
virtual_bank_accounts	invoices.customer_id = virtual_bank_accounts.customer_id invoices.notes.entity_id = virtual_bank_accounts.customer_id
gifts	invoices.customer_id = gifts.gift_receiver.customer_id invoices.notes.entity_id = gifts.gift_receiver.customer_id invoices.customer_id = gifts.gifter.customer_id invoices.notes.entity_id = gifts.gifter.customer_id invoices.id = gifts.gifter.invoice_id invoices.line_items.subscription_id = gifts.gift_receiver.subscription_id invoices.notes.entity_id = gifts.gift_receiver.subscription_id invoices.subscription_id = gifts.gift_receiver.subscription_id

adjustment_credit_notes

ARRAY

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

channel

STRING

credits_applied

INTEGER

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

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

exchange_rate

NUMBER

expected_payment_date

DATE-TIME

first_invoice

BOOLEAN

generated_at

DATE-TIME

has_advance_charges

BOOLEAN

STRING

is_gifted

BOOLEAN

issued_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

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

local_currency_code

STRING

net_term_days

INTEGER

new_sales_amount

INTEGER

next_retry_at

DATE-TIME

notes

ARRAY

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

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

status

STRING

sub_total

INTEGER

sub_total_in_local_currency

INTEGER

subscription_id

STRING

tax

INTEGER

taxes

ARRAY

This is 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_families

The item_families table contains info about item families.

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee API method

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

channel

STRING

custom_fields

STRING

description

STRING

name

STRING

object

STRING

resource_version

INTEGER

status

STRING

updated_at

DATE-TIME

item_prices

The item_prices table contains info about item prices.

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee API method

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

Join item_prices with

item_families

item_prices.item_family_id = item_families.id

items

item_prices.item_family_id = items.item_family_id

item_prices.item_id = items.id

accounting_detail

OBJECT

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

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 for more info.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee API method

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

Join items with

item_families

items.item_family_id = item_families.id

item_prices

items.item_family_id = item_prices.item_family_id

items.id = item_prices.item_id

applicable_items

ARRAY

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

included_in_mrr

BOOLEAN

is_giftable

BOOLEAN

is_shippable

BOOLEAN

item_applicability

STRING

item_family_id

STRING

metadata

STRING

metered

BOOLEAN

name

STRING

object

STRING

redirect_url

STRING

resource_version

INTEGER

status

STRING

type

STRING

unit

STRING

updated_at

DATE-TIME

usage_calculation

STRING

orders

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

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee documentation Chargebee API method

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

amount_adjusted

INTEGER

amount_paid

INTEGER

batch_id

STRING

billing_address

OBJECT

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

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

invoice_id

STRING

invoice_round_off_amount

INTEGER

is_gifted

BOOLEAN

is_resent

BOOLEAN

line_item_discounts

ARRAY

This is a nested data structure:

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

note

STRING

order_date

DATE-TIME

order_line_items

ARRAY

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

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

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

shipping_cut_off_date

DATE-TIME

shipping_date

DATE-TIME

status

STRING

status_update_at

DATE-TIME

sub_total

INTEGER

subscription_id

STRING

tax

INTEGER

total

INTEGER

tracking_id

STRING

tracking_url

STRING

updated_at

DATE-TIME

payment_sources

The payment_sources table contains info about customer payment sources.

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee documentation Chargebee API method

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

amazon_payment

OBJECT

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

customer_id

STRING

deleted

BOOLEAN

gateway

STRING

gateway_account_id

STRING

ip_address

STRING

issuing_country

STRING

mandates

ARRAY

This is a nested data structure:

created_at: DATE-TIME
id: STRING
subscription_id: STRING

object

STRING

paypal

OBJECT

This is a nested data structure:

agremeent_id: STRING
email: STRING

reference_id

STRING

resource_version

INTEGER

status

STRING

type

STRING

updated_at

DATE-TIME

upi

OBJECT

This is a nested data structure:

vpa: STRING

plans

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

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee API method

Join plans with	on
addons	plans.applicable_addons.id = addons.id
coupons	plans.applicable_addons.id = coupons.addon_ids plans.id = coupons.plan_ids
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	plans.applicable_addons.id = invoices.notes.entity_id plans.id = invoices.notes.entity_id
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

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

avalara_sale_type

STRING

avalara_service_type

INTEGER

avalara_transaction_type

INTEGER

billing_cycles

INTEGER

channel

STRING

charge_model

STRING

claim_url

STRING

currency_code

STRING

custom_fields

STRING

description

STRING

enabled_in_hosted_pages

BOOLEAN

enabled_in_portal

BOOLEAN

event_based_addons

ARRAY

This is a nested data structure:

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

free_quantity

INTEGER

free_quantity_in_decimal

STRING

giftable

BOOLEAN

STRING

invoice_name

STRING

invoice_notes

STRING

is_shippable

BOOLEAN

meta_data

STRING

name

STRING

object

STRING

period

INTEGER

period_unit

STRING

price

INTEGER

price_in_decimal

STRING

pricing_model

STRING

redirect_url

STRING

resource_version

INTEGER

setup_cost

INTEGER

shipping_frequency_period

INTEGER

shipping_frequency_period_unit

STRING

show_description_in_invoices

BOOLEAN

show_description_in_quotes

BOOLEAN

sku

STRING

status

STRING

tax_code

STRING

tax_profile_id

STRING

taxable

BOOLEAN

taxjar_product_code

STRING

tiers

ARRAY

This is a nested data structure:

ending_unit: INTEGER
ending_unit_in_decimal: STRING
price: INTEGER
price_in_decimal: STRING
starting_unit: INTEGER
starting_unit_in_decimal: STRING

trial_end_action

STRING

trial_period

INTEGER

trial_period_unit

STRING

updated_at

DATE-TIME

promotional_credits

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

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

Replication Method	CDC
Primary Key	id
Replication Key	created_at
Useful links	Chargebee documentation Chargebee API method

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

amount

STRING

amount_in_decimal

STRING

closing_balance

INTEGER

created_at

DATE-TIME

credit_type

STRING

currency_code

STRING

customer_id

STRING

description

STRING

done_by

STRING

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 Chargebee API method

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

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

This is a nested data structure:

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

STRING

invoice_id

STRING

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

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

name

STRING

notes

STRING

operation_type

STRING

po_number

STRING

price_type

STRING

resource_version

INTEGER

shipping_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

status

STRING

sub_total

INTEGER

subscription_id

STRING

taxes

ARRAY

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

subscriptions

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

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

due_invoices_count
due_since
total_dues

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee documentation Chargebee API method

Join subscriptions with	on
addons	subscriptions.addons.id = addons.id subscriptions.charged_event_based_addons.id = addons.id subscriptions.event_based_addons.id = addons.id
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	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	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	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	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	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	subscriptions.customer_id = customers.id subscriptions.payment_source_id = customers.primary_payment_source_id
payment_sources	subscriptions.customer_id = payment_sources.customer_id subscriptions.payment_source_id = payment_sources.id
promotional_credits	subscriptions.customer_id = promotional_credits.customer_id
transactions	subscriptions.customer_id = transactions.customer_id subscriptions.payment_source_id = transactions.payment_source_id subscriptions.id = transactions.subscription_id
virtual_bank_accounts	subscriptions.customer_id = virtual_bank_accounts.customer_id
gifts	subscriptions.customer_id = gifts.gift_receiver.customer_id subscriptions.customer_id = gifts.gifter.customer_id subscriptions.gift_id = gifts.id subscriptions.id = gifts.gift_receiver.subscription_id

activated_at

DATE-TIME

auto_close_invoices

BOOLEAN

auto_collection

STRING

base_currency_code

STRING

billing_period

INTEGER

billing_period_unit

STRING

cancel_reason

STRING

cancel_reason_code

STRING

cancel_schedule_created_at

DATE-TIME

cancelled_at

DATE-TIME

changes_scheduled_at

DATE-TIME

channel

STRING

charged_items

ARRAY

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

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

discounts

ARRAY

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

exchange_rate

NUMBER

free_period

INTEGER

free_period_unit

STRING

gift_id

STRING

has_scheduled_advance_invoices

BOOLEAN

has_scheduled_changes

BOOLEAN

STRING

invoice_notes

STRING

meta_data

STRING

mrr

INTEGER

next_billing_at

DATE-TIME

object

STRING

offline_payment_method

STRING

override_relationship

BOOLEAN

pause_date

DATE-TIME

payment_source_id

STRING

plan_amount

INTEGER

plan_amount_in_decimal

STRING

plan_free_quantity

INTEGER

plan_free_quantity_in_decimal

STRING

plan_id

STRING

plan_quantity

INTEGER

plan_quantity_in_decimal

STRING

plan_unit_price

INTEGER

plan_unit_price_in_decimal

STRING

po_number

STRING

referral_info

OBJECT

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

setup_fee

INTEGER

shipping_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

start_date

DATE-TIME

started_at

DATE-TIME

status

STRING

subscription_items

ARRAY

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

transactions

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

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee documentation Chargebee API method

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

amount

INTEGER

amount_capturable

STRING

amount_unused

INTEGER

authorization_reason

STRING

base_currency_code

STRING

currency_code

STRING

customer_id

STRING

date

DATE-TIME

deleted

BOOLEAN

error_code

STRING

error_text

STRING

exchange_rate

NUMBER

fraud_flag

STRING

fraud_reason

STRING

gateway

STRING

gateway_account_id

STRING

id_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 for more info.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Chargebee documentation Chargebee API method

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

account_number

STRING

bank_name

STRING

created_at

DATE-TIME

customer_id

STRING

deleted

BOOLEAN

email

STRING

gateway

STRING

gateway_account_id

STRING

object

STRING

reference_id

STRING

resource_version

INTEGER

routing_number

STRING

scheme

STRING

swift_code

STRING

updated_at

DATE-TIME

このページは役に立ちましたか?

このページまたはコンテンツにタイポ、ステップの省略、技術的エラーなどの問題が見つかった場合はお知らせください。

こちらにフィードバックをお寄せください