1. Billing
  2. Subscriptions
  3. Subscription charged items

Subscription charged items

subscription_charged_items
copy
Click to Copy
The `subscription_charged_items` table lists event-based charge items that have already been billed.
UPSERT KEY
subscription_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
subscription_id string, not null
Foreign Key subscriptions.id
The unique identifier of the `subscription` associated with this record.
item_price_id string, not null
Foreign Key item_prices.id
A unique identifier for the `item_price`.
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.
last_charged_at timestamp, not null
The timestamp of the most recent charge for this item price in the subscription.
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.