1. Product Catalog
  2. Items
  3. Item bundle items

Item bundle items

item_bundle_items
copy
Click to Copy
The item_bundle_items table stores one row per component item within a bundle plan. Each row represents a plan, addon, or charge that has been grouped into a bundle, along with its quantity and price allocation.

Columns

No match found
item_id string, not null
Foreign Key items.id
The id of the parent item (the bundle plan) to which this component belongs.
bundle_item_id string, null
The unique identifier of the component item (plan, addon, or charge) within the bundle.
item_type string, null
The type of the component item within the bundle. Possible values are plan, addon, and charge.
price_allocation decimal, null
The percentage of the bundle's total price attributed to this component item. Used for revenue allocation across bundle components.
quantity null, default=1
The number of units of this component item included in the bundle.
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.