Changelog

24th Feb 2026 Release

New Tables Added:

• credit_note_custom_fields: Stores additional custom fields defined for credit_notes in your Chargebee site.
• invoice_custom_fields: Stores additional custom fields defined for invoices in your Chargebee site.

17th Feb 2026 Release

Column Type Update:

• The id column type in item_mrr_discounts_history has been updated from long to string.

16th Feb 2026 Release

New Table Added:

• omnichannel_subscription_item_offers: Represents offer details applied to omnichannel subscription items (such as introductory, upgrade, and retention offers) across app store sources, helping analyze offer-driven pricing, renewals, and revenue impact.

10th Feb 2026 Release

New Table Added:

• coupon_custom_fields: Stores custom field data associated with coupons.

4th Feb 2026 Release

Table Update:

• The exchange_rate_daily table now exports complete historical exchange rate data only for currencies configured on your site, instead of exporting the previous day's rate for all currencies.

30th Jan 2026 Release

New Table Added:

• omnichannel_subscription_transactions: Maps transactions to their corresponding omnichannel subscriptions across app store sources.

Table Update:

• The subscription mapping field has been moved out of omnichannel_transactions into the standalone omnichannel_subscription_transactions table.

20th Jan 2026 Release

New Table Added:

• omnichannel_subscription_item_offers: Captures offer-level pricing and term details associated with omnichannel subscription items.

14th Jan 2026 Release

New Table Added:

• item_mrr_discounts_history: Stores the historical breakdown of discounts applied at the item level that affect Monthly Recurring Revenue (MRR).

7th Oct 2025 Release

Two new tables have been added:

• exchange_rate_daily: Stores daily exchange rate information for various currencies, enabling currency conversion and financial reporting across different currencies.
• item_mrr_history: Captures the historical changes in item-level Monthly Recurring Revenue (MRR) for subscription items. Each row represents a distinct change event at the item level, allowing for detailed analysis of how individual subscription items contribute to overall MRR changes.

Table Renamed:

• subscription_mrr_changes has been renamed to subscription_mrr_history. The table structure has been updated with renamed fields: status → subscription_status, status_previous → subscription_status_previous, mrr → subscription_mrr, mrr_previous → subscription_mrr_previous, and mrr_change → subscription_mrr_change.

Note:

• The shipping_address_index column has been removed from the following tables: invoices, quotes, credit_notes, orders, and subscriptions.

12th Sep 2025 Release

Three new tables have been added:

• omnichannel_subscriptions: Represents subscription records unified across Apple App Store and Google Play Store, mapped to Chargebee’s omnichannel format.
• omnichannel_subscription_items: Represents subscription items across app stores, with lifecycle, renewal, cancellation, expiration, and catalog mapping attributes.
• omnichannel_transactions: Unified view of subscription purchase transactions across app stores. The price reflects the actual price paid by the end customer.

19th Aug 2025 Release

Three new metadata columns are now available across all tables, enabling better tracking of data flow.

• record_extracted_at: The column represents the timestamp when the updated data became available in Chargebee’s data lakehouse.
• record_exported_at: The column represents the timestamp when the data was exported to the configured destination.
• change_type: The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly

24th June 2025 Release

item_entitlements table has been removed from Automatic Exports until further notice.

14th May 2025 Release

Fourteen new tables have been added:

• business_entity_transfers: business_entity_transfer encapsulates the details of the movement of a resource (such as customer and subscription) from one business_entity to another.
• contract_terms: Subscriptions can run indefinitely, or they may run for a fixed number of billing cycles. Subscription can have 'contract terms', which define a lock-in period on the subscription for a certain number of billing cycles. This prevents the subscription from being canceled by the customer when it is within the contract term.
• orders: Orders are automatically generated for an invoice when it gets paid, based on the shipping preference chosen for the invoice's product and the shipping date configuration.
• order_line_item_discounts: The list of discounts applied for the order.
• order_line_item_taxes: The list of taxes applied on the order line items.
• order_line_items: The list of line items for this order.
• order_linked_credit_notes: The credit notes linked to the order.
• resent_orders: The list of resent orders applied on the order.
• ramps: The ramp resource or a subscription ramp represents a planned change to a subscription set to occur at a future date. By using this resource, you can define and schedule modifications to a subscription, such as updating pricing, altering the quantity, or transitioning to a different plan, without immediately applying them.
• ramp_coupons_to_add: Details about the coupons added to the subscription through this ramp.
• ramp_discounts_to_add: Details about the discounts added to the subscription through this ramp.
• ramp_item_tiers: Overrides the item_tiers for specific item_prices of the subscription.
• ramp_items_to_add: Details about the item prices added to the subscription through this ramp.
• ramp_items_to_update: Details about the item prices updated in the subscription through this ramp.

10th Apr 2025 Release

Two new tables have been added:

• payment_sources: Payment source of a customer.
• payment_source_mandates: Mandate details associated with the payment source.

24th Jan 2025 Release

Three new tables have been added to enhance subscription and MRR analysis:

Note: All tables automatically recalculate when reporting timezone or currency settings change.

7th Jan 2025 Release

New field available: dunning_status is added to the invoices table.

3rd Dec 2024 Release

New table available: invoice_dunning_attempts