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.

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.
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
starting_unit not null
The lower limit of the unit range for the tier.
starting_unit_in_decimal string, null
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.