Release Notes

October 2024

Effective October 14, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

This schema change is required due to a data integrity issue in the INVOICE_LINE_ITEM table.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`INVOICE_LINE_ITEM`
column	Primary Key Change		`invoice_id`	`invoice_id` 🔑	Added to primary key.

June 2024

Effective June 28, 2024 we use a new June 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

These schema changes are necessary due to changes in the source API. We've also added new tables.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

3 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`DIFFERENTIAL_PRICE_TIER`
table	New Table		`DIFFERENTIAL_PRICE_TIER`	Child table of the `DIFFERENTIAL_PRICE` parent table.
`ITEM_PRICE_TIER`
table	New Table		`ITEM_PRICE_TIER`	Child table of the `ITEM_PRICE` parent table.
`PRICE_TIER`
table	Deprecated Table	`PRICE_TIER`		Chargebee Product Catalog 2.0 no longer supports it.

January 2024

We have added a new column, free_quantity, to the SUBSCRIPTION_ITEM_PRICE table.

September 2023

We no longer capture deletes for the INVOICE and SUBSCRIPTION tables. We no longer update the _fivetran_deleted column in these tables.

August 2023

You can now configure your Chargebee Product Catalog 2.0 connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.

We have added the following new tables:

COUPON_METADATA
EVENT_METADATA
ITEM_METADATA
ITEM_PRICE_METADATA
PAYMENT_SOURCE_MANDATE
PRICE_TIER
SUBSCRIPTION_METADATA

We have combined the DIFFERENTIAL_PRICE_TIER and ITEM_PRICE_TIER tier tables into a new table, PRICE_TIER.

We have renamed the ORDER table to ORDERS.

We have made the following changes to the COUPON_ITEM_CONSTRAINT table:

Renamed the constraint column to constraints
Added the item_type column to the set of composite primary keys

We have made the following changes to the CREDIT_NOTE_LINKED_REFUND and INVOICE_LINKED_PAYMENT tables:

Renamed the txn_id column to transaction_id
Removed the txn_amount, txn_date, and txn_status columns

We have made the following changes to the EVENT table:

Renamed the user column to users
Removed the metadata_* column

We have made the following changes to the INVOICE_ADJUSTMENT_CREDIT_NOTE and INVOICE_ISSUED_CREDIT_NOTE tables:

Renamed the cn_id column to credit_note_id
Removed the cn_create_reason_code, cn_date, cn_reason_code, cn_status, and cn_total columns

We have made the following changes to the INVOICE_APPLIED_CREDIT table:

Renamed the cn_id column to credit_note_id
Removed the cn_create_reason_code, cn_date, cn_reason_code, and cn_status columns

We have made the following changes to the INVOICE_LINKED_ORDER table:

Renamed the id column to order_id
Removed the batch_id, created_at, document_number, fulfilment_status, order_type, reference_id, and status columns

We have made the following changes to the ITEM_PRICE table:

Added a new column, accounting_detail_sku
Removed the metadata_* column

We have made the following changes to the SUBSCRIPTION_ITEM_TIER_PRICE table:

Added a new column, index
Removed the price and price_in_decimal columns

We have made the following changes to the TRANSACTION_LINKED_CREDIT_NOTE table:

Renamed the cn_id column to credit_note_id
Removed the cn_create_reason_code, cn_date, and cn_reference_invoice_id columns

We have made the following changes to the TRANSACTION_LINKED_PAYMENT table:

Renamed the transaction_txn_id column to transaction_id
Removed the amount, date, and status columns

We have renamed the following columns in the COUPON_APPLICABLE_ITEM_PRICE table:

coupon_item_constraint_constraint to coupon_item_constraints
coupon_item_constraint_item_type to coupon_item_constraint_type

We have renamed the gift_receiver_customer_id column to gift_receiver in the GIFT table.

We have renamed the following columns in the SUBSCRIPTION table:

auto_close_invoices to auto_close_invoice
mrr to monthly_reccuring_revenue

We have renamed the following columns in the TRANSACTION table:

iin to issuer_identification_number
last4 to last_4
txn_id to refunded_transaction_id

We have renamed the following columns in the TRANSACTION_REFUND table:

refunded_txn_id to refunded_transaction_id
txn_amount to transaction_amount
txn_date to transaction_date
txn_status to transaction_status

We have added a new column, recurring, to the INVOICE table.

We have removed the metadata_* column from the COUPON and ITEM tables.

We have removed the following columns from the CREDIT_NOTE_INVOICE_ALLOCATION table:

allocated_at
invoice_date
invoice_status

We have removed the txn_amount and txn_status columns from the INVOICE_DUNNING_ATTEMPT table.

We have removed the following columns from the ORDER_LINKED_CREDIT_NOTE table:

amount
amount_adjusted
amount_refunded
status
type

We have removed the following columns from the SUBSCRIPTION_ITEM_PRICE table:

current_term_end
free_quantity
free_quantity_in_decimal
next_billing_at
trial_end

We have removed the following columns from the TRANSACTION_INVOICE table:

invoice_date
invoice_total
invoice_status

July 2023

We have changed the sync strategy of our Chargebee Product Catalog 2.0 connector. We now incrementally sync the following tables and their child tables:

COMMENT
COUPON
CREDIT_NOTE
CUSTOMER
DIFFERENTIAL_PRICE
EVENT
GIFT
INVOICE
ITEM
ITEM_FAMILY
ITEM_PRICE
PAYMENT_SOURCE
ORDER
SUBSCRIPTION
TRANSACTION

October 2022

Lite connectors are now available for the following sources: