1. History
  2. Item mrr history
  3. Item mrr discounts history

Item mrr discounts history

item_mrr_discounts_history
copy
Click to Copy

Stores the historical breakdown of discounts applied at the item level that affect Monthly Recurring Revenue (MRR).Each row represents a single discount applied to a subscription item for a reporting period.Use this table to analyze how item-level and document-level discounts impact item MRR over time. This table will have data for changes from 6th January 8:00 AM IST onwards.

Columns

No match found
id long, not null
A unique identifier for the record.
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
An Identifier of the item price. Join with the item_price table to retrieve pricing details.
entity_id string, not null
The unique identifier of the discount entity (for example, a coupon or manual discount) that causes the item-level MRR reduction.
entity_type string, not null
Type of discount or adjustment applied to the item MRR. Multiple rows may exist for the same item_mrr_id when multiple discounts apply. Possible values are:
  • item_level_coupon: Coupon applied to a subscription line item (entity_id = coupon id).
  • document_level_coupon: Coupon applied to an invoice subtotal (entity_id = coupon id).
  • item_level_discount: Discount applied to a subscription line item (entity_id = discount id).
  • document_level_discount: Discount applied to an invoice subtotal (entity_id = discount id).
item_discount_amount long, not null
The amount by which the item’s MRR is reduced by the discount.
item_mrr_id long, not null
A unique identifier of the associated item-level MRR record. Join with the `item_mrr_history` table to link discounts with item MRR change events.
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.