Item mrr discounts history - Chargebee Data Catalog

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.

Note:

This table will have data for records captured only from the date it is first enabled for a site.
omnichannel_subscriptions are not included in the MRR History tables - item_mrr_history, item_mrr_discounts_history, and subscription_mrr_history.

UPSERT KEY

Each row is uniquely identified by this column. Use it as the upsert key when applying incremental datasets to your warehouse.

Columns

id string, 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.

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.

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 string, 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_exported_at timestamp

The column represents the timestamp when the data was exported to the configured destination.

record_extracted_at timestamp

The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.