1. Product Catalog
  2. Item prices
  3. Item price tiers

Item price tiers

item_price_tiers
copy
Click to Copy
List of quantity-based pricing tiers for the item price. Applicable only for tiered, volume, and stairstep pricing_models.
UPSERT KEY
item_price_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
item_price_id string, not null
Foreign Key item_prices.id
The unique ID of the item_price this table belongs to.
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.
ending_unit null
The upper limit of the unit range for the tier.
ending_unit_in_decimal string, null
price long, not null, default=0
The per-unit price for the tier when the pricing_model is tiered or volume, and the total price for the tier when the pricing_model is stairstep. The value is stored in the minor unit of the currency.
price_in_decimal string, null
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.
starting_unit not null
The lower limit of the unit range for the tier.
starting_unit_in_decimal string, null