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

Item applicable items

item_applicable_items
copy
Click to Copy
The item_applicable_items table lists addons and charges that can be applied to a plan item when applicability is restricted.
UPSERT KEY
item_id + record_id

Each row is uniquely identified by this combination. Use these columns together as the upsert key when applying incremental datasets to your warehouse.

Columns

No match found
id string, null
ID of the addon-item or plan-item that can be applied to the plan item.
item_id string, not null
Foreign Key items.id
The id of the parent item.
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.
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.
record_id integer
The column represents the unique integer identifier for each child record within a parent subset.