1. Product Catalog
  2. Coupons
  3. Coupon item constraint criteria

Coupon item constraint criteria

coupon_item_constraint_criteria
copy
Click to Copy

List of item constraint criteria that determine how the coupon can be redeemed.

Columns

No match found
coupon_id string, not null
Foreign Key coupons.id
The unique identifier of the associated coupon.
currencies string, null
List of currencies (ISO 4217 format) for which this coupon is applicable.
item_family_ids string, null
List of item family identifiers to which the coupon is applicable.
item_price_periods string, null
List of billing frequencies for which the coupon is applicable. Possible values are day, week, month, and year.
item_type string, not null
Item type for which this criteria is applicable. Possible values are:
  • addon: Addon
  • charge: Charge
  • plan: Plan
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.