1. Product Catalog
  2. Item prices
  3. Item price custom fields

Item price custom fields

item_price_custom_fields
copy
Click to Copy

Item Price Custom Fields contain custom fields defined under item_prices table in your Chargebee site.

Note:
If you create a custom field for item prices in Chargebee (for example, cf_age), it will appear as a column with the same name (cf_age) in this table. This helps you include your own business-specific details in reports and data analysis.

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, 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.
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.