Release Notes

December 2024

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

We are making these schema changes to introduce feature enhancements and improve schema usability.

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.

125 total changes • 64 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ADDON`
column	Rename Column	`accounting_category1`	`accounting_category_1`
column	Rename Column	`accounting_category2`	`accounting_category_2`
column	Rename Column	`accounting_category3`	`accounting_category_3`
column	Rename Column	`accounting_category4`	`accounting_category_4`
column	New Column		`proration_type`
`ADDON_TAX_PROVIDER_FIELD`
table	New Table		`ADDON_TAX_PROVIDER_FIELD`
`ADDON_TIER`
table	New Table		`ADDON_TIER`
`CREDIT_NOTE_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CREDIT_NOTE_LINE_ITEM`
table	New Table
`CREDIT_NOTE_LINE_ITEM_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CREDIT_NOTE_LINE_ITEM_TAX`
table	New Table
`CREDIT_NOTE_LINE_ITEM_TIER`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CREDIT_NOTE_TAX`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CUSTOMER_BALANCE`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`customer_id`	`customer_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CUSTOMER_TAX_PROVIDER_FIELD`
table	New Table		`CUSTOMER_TAX_PROVIDER_FIELD`
`EVENT`
table	New Table		`EVENT`
`EVENT_METADATA`
table	New Table		`EVENT_METADATA`
`EVENT_WEBHOOK`
table	New Table		`EVENT_WEBHOOK`
`GIFT_TIMELINE`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`gift_id`	`gift_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`HOSTED_PAGE`
column	New Column		`business_entity_id`
`INVOICE`
column	New Column		`einvoice_reference_number`
column	New Column		`local_currency_exchange_rate`
column	New Column		`site_details_at_creation_organization_address_city`
column	New Column		`site_details_at_creation_organization_address_country_code`
column	New Column		`site_details_at_creation_organization_address_line_1`
column	New Column		`site_details_at_creation_organization_address_state`
column	New Column		`site_details_at_creation_organization_address_zip`
column	New Column		`site_details_at_creation_organization_email`
column	New Column		`site_details_at_creation_organization_name`
column	New Column		`site_details_at_creation_organization_phone`
column	New Column		`site_details_at_creation_organization_website`
column	New Column		`site_details_at_creation_timezone`
column	New Column		`statement_descriptor`
column	New Column		`statement_descriptor_id`
column	New Column		`tax_category`
column	New Column		`tax_origin_country`
column	New Column		`tax_origin_registration_number`
`INVOICE_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_DUNNING_ATTEMPT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_LINE_ITEM`
table	New Table
`INVOICE_LINE_ITEM_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_LINE_ITEM_TAX`
table	New Table
`INVOICE_NOTE`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_TAX`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`LINE_ITEM`
table	Deprecated Table	`LINE_ITEM`		Data now available in the `INVOICE_LINE_ITEM`, `QUOTE_LINE_ITEM`, and `CREDIT_NOTE_LINE_ITEM` tables.
`LINE_ITEM_TAX`
table	Deprecated Table	`LINE_ITEM_TAX`		Data now available in the `INVOICE_LINE_ITEM_TAX`, `CREDIT_NOTE_LINE_ITEM_TAX`, `QUOTE_LINE_ITEM_TAX`, and `ORDER_LINE_ITEM_TAX` tables.
`ORDER_LINE_ITEM_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`order_id`	`order_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`ORDER_LINE_ITEM_TAX`
table	New Table	`_FIVETRAN_ID` 🔑		No longer primary key.
`PAYMENT_SOURCE`
column	New Column		`bank_account_direct_debit_scheme`
column	New Column		`boleto_email`
column	New Column		`boleto_first_name`
column	New Column		`boleto_last_4`
column	New Column		`boleto_last_name`
column	New Column		`klarna_pay_now_email`
column	New Column		`venmo_user_name`
`PLAN`
column	Rename Column	`accounting_category1`	`accounting_category_1`
column	Rename Column	`accounting_category2`	`accounting_category_2`
column	Rename Column	`accounting_category3`	`accounting_category_3`
column	Rename Column	`accounting_category4`	`accounting_category_4`
`PLAN_TAX_PROVIDER_FIELD`
table	New Table		`PLAN_TAX_PROVIDER_FIELD`
`PLAN_TIER`
table	New Table		`PLAN_TIER`
`QUOTE_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`QUOTE_LINE_ITEM`
table	New Table
`QUOTE_LINE_ITEM_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`QUOTE_LINE_ITEM_TAX`
table	New Table
`QUOTE_LINE_ITEM_TIER`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`QUOTE_TAX`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`SUBSCRIPTION`
column	New Column		`contract_term_total_contract_value_before_tax`
`TIER`
table	Deprecated Table	`TIER`		Data now available in the `UNBILLED_CHARGE_TIER`, `ADDON_TIER`, and `PLAN_TIER` tables.
`TRANSACTION`
column	New Column		`custom_payment_method_id`
column	New Column		`custom_payment_method_name`
column	New Column		`error_cause_customer_message`
column	New Column		`error_cause_id`
column	New Column		`error_cause_merchant_message`
column	New Column		`error_detail_decline_code`
column	New Column		`error_detail_decline_message`
column	New Column		`error_detail_error_category`
column	New Column		`error_detail_error_code`
column	New Column		`error_detail_error_field`
column	New Column		`error_detail_error_message`
column	New Column		`error_detail_network_error_code`
column	New Column		`error_detail_network_error_message`
column	New Column		`error_detail_processor_error_code`
column	New Column		`error_detail_processor_error_message`
column	New Column		`error_detail_recommendation_code`
column	New Column		`error_detail_recommendation_message`
column	New Column		`error_detail_request_id`
`UNBILLED_CHARGE_TIER`
table	New Table		`UNBILLED_CHARGE_TIER`

February 2024

We have removed the updated_at column as the composite primary key. The updated_at column now has a foreign key relationship to the SUBSCRIPTION table in the following tables:

SUBSCRIPTION_ADDON
SUBSCRIPTION_CHARGED_EVENT_BASED_ADDON
SUBSCRIPTION_COUPON
SUBSCRIPTION_EVENT_BASED_ADDON

August 2023

You can now configure your Chargebee Product Catalog 1.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:

ADDON_METADATA
COUPON_ADDON
COUPON_SET_METADATA
CREDIT_NOTE_DISCOUNT
CREDIT_NOTE_LINKED_REFUND
CREDIT_NOTE_LINKED_TAX_WITHHELD_REFUND
CREDIT_NOTE_TAX
CUSTOMER_BALANCE
CUSTOMER_ENTITY_IDENTIFIER
CUSTOMER_METADATA
GIFT_TIMELINE
INVOICE_DISCOUNT
INVOICE_LINKED_ORDER
INVOICE_LINKED_PAYMENT
INVOICE_LINKED_TAXES_WITHHELD
INVOICE_NOTE
INVOICE_TAX
LINE_ITEM
LINE_ITEM_TAX
PAYMENT_SOURCE_MANDATE
PLAN_METADATA
QUOTE_DISCOUNT
QUOTE_TAX
SUBSCRIPTION_ESTIMATE
SUBSCRIPTION_METADATA
SUBSCRIPTION_RENEWAL_CREDIT_NOTE_ESTIMATE
SUBSCRIPTION_RENEWAL_ESTIMATE
SUBSCRIPTION_RENEWAL_INVOICE_LINE_ITEM
SUBSCRIPTION_RENEWAL_UNBILLED_CHARGE_ESTIMATE
TIER

We have renamed the following tables:

INVOICE_ALLOCATION to CREDIT_NOTE_INVOICE_ALLOCATION
ORDER to ORDERS
PLAN_COUPON to COUPON_PLAN

We have changed the primary keys of the following tables:

CREDIT_NOTE_LINE_ITEM_DISCOUNT
INVOICE
INVOICE_APPLIED_CREDIT
INVOICE_DUNNING_ATTEMPT
INVOICE_LINE_ITEM_DISCOUNT
ORDER_LINE_ITEM_DISCOUNT
ORDER_LINKED_CREDIT_NOTE
QUOTE_LINE_ITEM_DISCOUNT
QUOTE_LINE_ITEM_TIER
SUBSCRIPTION
SUBSCRIPTION_ADDON
SUBSCRIPTION_COUPON
SUBSCRIPTION_EVENT_BASED_ADDON

We have combined the following line item tables into the new table, LINE_ITEM:

CREDIT_NOTE_LINE_ITEM
INVOICE_LINE_ITEM
QUOTE_LINE_ITEM

We have combined the following line item tax tables into the new table, LINE_ITEM_TAX:

CREDIT_NOTE_LINE_ITEM_TAX
INVOICE_LINE_ITEM_TAX
ORDERS_LINE_ITEM_TAX
QUOTE_LINE_ITEM_TAX

We have combined the tiers column of the following tables into the new table, TIER:

ADDON
PLAN
UNBILLED_CHARGE

We have added a new column, customer_id, to the PROMOTIONAL_CREDIT table.

We have added a new column, cn_reason_code, to the TRANSACTION_LINKED_CREDIT_NOTE table.

We have added a new column, coupon_id, to the following tables:

CREDIT_NOTE_LINE_ITEM_DISCOUNT
INVOICE_LINE_ITEM_DISCOUNT
QUOTE_LINE_ITEM_DISCOUNT

We have added two new columns, invoice_date and invoice_status columns, to the CREDIT_NOTE_INVOICE_ALLOCATION table.

We have added two new columns, txn_amount and txn_status, to the INVOICE_DUNNING_ATTEMPT table.

We have added two new columns, apply_till and coupon_code, to the SUBSCRIPTION_COUPON table.

We have added the following new columns to the CREDIT_NOTE table:

business_enity_id
channel
credit_note_billing_address_*
credit_note_shipping_address_*
customer_id
deleted
e_invoice_id
e_invoice_message
e_invoice_status
generated_at
reference_invoice_id
subscription_id

We have added the following new columns to the INVOICE_APPLIED_CREDIT table:

cn_create_reason_code
cn_date
cn_reason_code
cn_status

We have added the following new columns to the TRANSACTION table:

customer_id
deleted
iin
last_4
payment_method_details
payment_source_id
reference_authorization_id
reference_transaction_id
refunded_txn_id
reversal_transaction_id
subscription_id

We have added the following new columns to the UNBILLED_CHARGE table:

customer_id
deleted
is_advance_charge
subscription_id
updated_id

We have made the following changes to the ADDON table:

added the following new columns:
- channel
- hsn_code
- object
removed the tiers column

We have made the following changes to the COUPON_SET table:

added a new column, coupon_id
removed the object column

We have made the following changes to the CUSTOMER table:

added the following new columns:
- backup_payment_source_id
- billing_month
- business_entity_id
- channel
- deleted
- einvoicing_method
- entity_identifier_scheme
- entity_identifier_standard
- is_einvoice_enabled
- primary_payment_source_id
removed the following columns:
- balances
- payment_method_gateway
- payment_method_gateway_account_id
- payment_method_object
- payment_method_reference_id
- payment_method_status
- payment_method_type

We have made the following changes to the GIFT table:

added a new column, claim_expiry_date
removed the gift_receiver_object column

We have made the following changes to the INVOICE table:

added the following new columns:
- channel
- customer_id
- deleted
- einvoice_id
- einvoice_message
- einvoice_status
- generated_at
- is_written_off
- subscription_id
- tax_override_reason
- use_for_proration
- write_off_date
removed the discounts and taxes columns

We have made the following changes to the ORDER_LINE_ITEM table:

added two new columns, invoice_id and invoice_line_item_id
renamed the line_items_id column to id

We have made the following changes to the ORDERS table:

added the following new columns:
- invoice_id
- subscription_id
- customer_id
- original_order_id
- deleted
- gift_id
- shipping_address_index
removed the order_line_item column

We have made the following changes to the PAYMENT_SOURCE table:

added the following new columns:
- amazon_payment_agreement_id
- amazon_payment_email
- bank_account_email
- bank_account_first_name
- bank_account_last_name
- business_entity_id
- customer_id
- deleted
- paypal_agreement_id
- paypal_email
- upi_vpa
renamed the following columns:
- bank_account_account_holder_type to bank_account_holder_type
- column bank_account_account_type to bank_account_type

We have made the following changes to the PLAN table:

added the following new columns:
- channel
- charge_model
- hsn_code
- object
removed the following columns:
- charge_once
- ending_unit_in_decimal
- on_event
- quantity_in_decimal
- starting_unit_in_decimal
- tiers
- type

We have made the following changes to the QUOTE table:

added the following new columns:
- customer_id
- deleted
- invoice_id
- shipping_address_index
- subscription_id
removed the shipping_address_object column

We have made the following changes to the SUBSCRIPTION table:

added the following new columns:
- business_entity_id
- changes_scheduled_at
- channel
- customer_id
- deleted
- gift_id
- payment_source_id
- plan_id
removed the contract_term_object and shipping_address_object columns

We have made the following changes to the VIRTUAL_BANK_ACCOUNT table:

added two new columns, customer_id and deleted
removed the customer_id column

We have removed the addon_ids column from the COUPON table.

We have removed the object column from the following tables:

COMMENT
COUPON_CODE
SITE_MIGRATION_DETAIL

If you want to sync historical data for these tables and columns, contact our support team.

NOTE: In the CUSTOMER_REFERRAL_URL table, the customer_id column refers to the external customer ID in the referral system.

September 2022

We now offer Fivetran Lite connectors. A Lite connector is a new tier of connectors built for specific use cases with an accelerated development cycle.

Lite connectors are now available for the following sources: