Billing
Invoicing
Payments
Product Catalog
Omnichannel subscriptions
omnichannel_subscriptions
copy
Click to Copy
Represents subscription records unified across multiple app store sources (Apple App Store and Google Play Store). Provides a one-to-one mapping of source data into Chargebee’s omnichannel format.
Columns
id string, not null
Primary Key
Chargebee-generated identifier for the recorded omnichannel subscription.
customer_id string, null
Foreign Key
customers.id
The ID of the Chargebee customer linked to this subscription.
app_id string, not null
Chargebee App Identifier associated with the mobile app that generated the purchase.
created_at timestamp, not null
Timestamp when the omnichannel subscription was created in Chargebee.
id_at_source string, not null
Identifier of the subscription in the source store. For Apple, this is the Transaction ID of the initial purchase; for Google, the purchase token of the initial purchase.
initial_purchase_transaction_id string, null
Identifier of the initial purchase transaction record associated with this subscription.
resource_version long, null
Version number of this resource, updated to a new millisecond timestamp whenever the resource changes.
source string, not null
Origin store where the purchase is managed (e.g., `apple_app_store' and `google_play_store`).
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.