Release Notes
December 2024
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CREDIT_NOTE_LINE_ITEM | |||||
column | New Column | reference_line_item_id | |||
INVOICE_DUNNING_ATTEMPT | |||||
column | New Column | transaction_amount | |||
column | New Column | transaction_status | |||
INVOICE_LINKED_PAYMENT | |||||
column | New Column | transaction_amount | |||
column | New Column | transaction_date | |||
column | New Column | transaction_status | |||
QUOTE | |||||
table | New Table | QUOTE | |||
QUOTE_DISCOUNT | |||||
table | New Table | QUOTE_DISCOUNT | |||
QUOTE_LINE_ITEM | |||||
table | New Table | QUOTE_LINE_ITEM | |||
QUOTE_LINE_ITEM_DISCOUNT | |||||
table | New Table | QUOTE_LINE_ITEM_DISCOUNT | |||
QUOTE_LINE_ITEM_ITER | |||||
table | New Table | QUOTE_LINE_ITEM_ITER | |||
QUOTE_LINE_ITEM_TAX | |||||
table | New Table | QUOTE_LINE_ITEM_TAX | |||
QUOTE_NOTE | |||||
table | New Table | QUOTE_NOTE | |||
QUOTE_SUBSCRIPTION | |||||
table | New Table | QUOTE_SUBSCRIPTION | |||
QUOTE_SUBSCRIPTION_ADDON | |||||
table | New Table | QUOTE_SUBSCRIPTION_ADDON | |||
QUOTE_SUBSCRIPTION_COUPON | |||||
table | New Table | QUOTE_SUBSCRIPTION_COUPON | |||
QUOTE_SUBSCRIPTION_DISCOUNT | |||||
table | New Table | QUOTE_SUBSCRIPTION_DISCOUNT | |||
QUOTE_SUBSCRIPTION_EVENT_BASED_ADDON | |||||
table | New Table | QUOTE_SUBSCRIPTION_EVENT_BASED_ADDON | |||
QUOTE_SUBSCRIPTION_ITEM | |||||
table | New Table | QUOTE_SUBSCRIPTION_ITEM | |||
QUOTE_SUBSCRIPTION_ITEM_ITER | |||||
table | New Table | QUOTE_SUBSCRIPTION_ITEM_ITER | |||
QUOTE_TAX | |||||
table | New Table | QUOTE_TAX | |||
SUBSCRIPTION | |||||
column | New Column | active_id | |||
column | New Column | changes_scheduled_at | |||
column | New Column | contract_term_total_contract_value_before_tax | |||
column | New Column | shipping_address_index | |||
SUBSCRIPTION_DISCOUNT | |||||
table | New Table | SUBSCRIPTION_DISCOUNT | |||
SUBSCRIPTION_ITEM_PRICE | |||||
column | New Column | billing_period | |||
column | New Column | billing_period_unit | |||
column | New Column | charge_once | |||
column | New Column | free_quantity_in_decimal | |||
column | New Column | proration_type | |||
column | New Column | trial_end | |||
column | New Column | usage_accumulation_reset_frequency |
October 2024
INVOICE_LINE_ITEM
table. 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
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 toconstraints
- 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 totransaction_id
- Removed the
txn_amount
,txn_date
, andtxn_status
columns
We have made the following changes to the EVENT
table:
- Renamed the
user
column tousers
- 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 tocredit_note_id
- Removed the
cn_create_reason_code
,cn_date
,cn_reason_code
,cn_status
, andcn_total
columns
We have made the following changes to the INVOICE_APPLIED_CREDIT
table:
- Renamed the
cn_id
column tocredit_note_id
- Removed the
cn_create_reason_code
,cn_date
,cn_reason_code
, andcn_status
columns
We have made the following changes to the INVOICE_LINKED_ORDER
table:
- Renamed the
id
column toorder_id
- Removed the
batch_id
,created_at
,document_number
,fulfilment_status
,order_type
,reference_id
, andstatus
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
andprice_in_decimal
columns
We have made the following changes to the TRANSACTION_LINKED_CREDIT_NOTE
table:
- Renamed the
cn_id
column tocredit_note_id
- Removed the
cn_create_reason_code
,cn_date
, andcn_reference_invoice_id
columns
We have made the following changes to the TRANSACTION_LINKED_PAYMENT
table:
- Renamed the
transaction_txn_id
column totransaction_id
- Removed the
amount
,date
, andstatus
columns
We have renamed the following columns in the COUPON_APPLICABLE_ITEM_PRICE
table:
coupon_item_constraint_constraint
tocoupon_item_constraints
coupon_item_constraint_item_type
tocoupon_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
toauto_close_invoice
mrr
tomonthly_reccuring_revenue
We have renamed the following columns in the TRANSACTION
table:
iin
toissuer_identification_number
last4
tolast_4
txn_id
torefunded_transaction_id
We have renamed the following columns in the TRANSACTION_REFUND
table:
refunded_txn_id
torefunded_transaction_id
txn_amount
totransaction_amount
txn_date
totransaction_date
txn_status
totransaction_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: