1. Product Catalog
  2. Coupons
  3. Coupon item constraints

Coupon item constraints

coupon_item_constraints
copy
Click to Copy

List of item-level constraints that govern how the coupon can be redeemed in association with specific items.

UPSERT KEY
coupon_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
coupon_id string, not null
Foreign Key coupons.id
A unique identifier that references the associated coupon.
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.
constraint string, not null
Constraint applicable for the item. Possible values are:
  • all: Coupon applicable to all items.
  • criteria: Coupon applicable based on criteria.
  • none: Coupon not applicable to any items.
  • specific: Coupon applicable to specific items.
item_price_ids string, null
List of item price identifiers to which the coupon is applicable.
item_type string, not null
Item type for which this criteria is applicable. Possible values are:
  • addon: Addon
  • charge: Charge
  • plan: Plan
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.