Billing
Invoicing
Payments
Product Catalog
Item mrr history
item_mrr_history
copy
Click to Copy
This table captures the historical changes in item level Monthly Recurring Revenue (MRR). 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.
Columns
id long, not null
Primary Key
A unique identifier for the record that distinguishes each entry in the database.
subscription_id string, not null
Foreign Key
subscriptions.id
A unique identifier for the specific subscription.
item_price_id string, not null
Foreign Key
item_prices.id
The
item_price_id of the item. Can be joined with the item_prices table to get more details.item_id string, not null
Foreign Key
items.id
The
id of the item associated with this subscription. Each item will be stored in separate rows if the subscription has more than 1 item associated.customer_id string, not null
Foreign Key
customers.id
A unique identifier for the customer who holds the subscription, allowing for tracking and management of customer-related data.
currency_code string, not null
The currency in which the subscription fees are charged, represented as a three-letter ISO currency code (e.g., USD, EUR).
item_discount decimal, null
The total discount amount applied specifically attributable for this item. This includes both line item discount (applicable specifically for the item) and invoice discounts (split amongst all items).
item_discount_difference decimal, null
The difference of item-level discount between current value and previous value.
item_discount_previous decimal, null
The previous discount applied to the item before the current change.
item_mrr decimal, not null
The MRR at the item level.
item_mrr_difference decimal, null
The difference of
item_mrr between current value and previous value of this item.item_mrr_previous decimal, null
The previous MRR of the item before the current change.
item_price decimal, not null
The current price of the item in the subscription in the specified currency code.
item_price_difference decimal, not null
The difference of
item_price between current value and previous value.item_price_previous decimal, null
The previous price of the item before the current change.
item_quantity long, not null
The current number of units of the item that the customer is subscribed to, indicating the scale of the subscription.
item_quantity_difference long, not null
The difference in quantity of item between current value and previous value.
item_quantity_previous long, not null
The previous quantity of the item before the current change.
record_end_at timestamp, null
The timestamp at which this change ceased to end. If NULL, it represents that the record is currently applicable.
record_recorded_at timestamp, not null
The timestamp at which this change was recorded.
record_start_at timestamp, not null
The timestamp at which this change became applicable.
record_extracted_at timestamp
The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.
record_exported_at timestamp
The column represents the timestamp when the data was exported to the configured destination.
change_type string
The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly.