1. Omnichannel
  2. Omnichannel subscriptions
  3. Omnichannel subscription items

Omnichannel subscription items

omnichannel_subscription_items
copy
Click to Copy
Represents subscription items unified across multiple app store sources, such as Apple App Store and Google Play Store. This table contains fields that define the subscription lifecycle, renewal, cancellation, expiration, and Chargebee catalog mapping.

Columns

No match found
id string, not null
Uniquely identifies an omnichannel subscription item.
omnichannel_subscription_id string, not null
Foreign Key omnichannel_subscriptions.id
Identifier for the parent omnichannel subscription that this item belongs to.
auto_renew_status string, null
Indicates whether auto-renewal is enabled or disabled for the subscription item.
cancellation_reason string, null
The reason the subscription item was cancelled (e.g., customer cancelled, did not consent to price increase, refunded, merchant revoked).
cancelled_at timestamp, null
The timestamp when the subscription item was cancelled in the source store.
current_term_end timestamp, null
The timestamp when the current billing period of the subscription item ends. Applicable only if the item is `active`.
current_term_start timestamp, null
The timestamp when the current billing period of the subscription item started. Applicable only if the item is `active`.
expiration_reason string, null
The reason for the subscription item’s expiration, such as billing error, product unavailability, or other reasons.
expired_at timestamp, null
The timestamp when the subscription item expired in the source store.
grace_period_expires_at timestamp, null
The timestamp when the grace period for the subscription item expires in the source store.
has_scheduled_changes boolean, not null, default=false
Indicates if the subscription item has any scheduled changes.
item_id_at_source string, not null
The product ID of the subscription item in the source store.
item_parent_id_at_source string, null
The parent identifier of the product in the source store.
linked_item string, null
Represents the mapping between the omnichannel subscription item and a Chargebee catalog item, used to retrieve entitlements.
resource_version long, null
Version number of the resource. Updated with a new timestamp in milliseconds for every change.
resumes_at timestamp, null
The timestamp when the subscription item automatically resumes after being paused.
status string, not null
The current status of the subscription item (for example, active, cancelled, in_dunning, in_grace_period, expired, paused).
upcoming_renewal string, null
Details of the next renewal, including currency and price information, if available from the source store, and auto-renewal is enabled.
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.