1. Omnichannel
  2. Omnichannel transactions
  3. Omnichannel subscription transactions

Omnichannel subscription transactions

omnichannel_subscription_transactions
copy
Click to Copy
Maps the relationship between omnichannel transactions and omnichannel subscriptions. Use this table to associate multiple transactions (such as initial purchases, renewals, and upgrades) with a single omnichannel subscription across app store sources such as the Apple App Store and Google Play Store.

Columns

No match found
omnichannel_transaction_id string, not null
Foreign Key omnichannel_transactions.id
The unique identifier of the related omnichannel transaction.
omnichannel_subscription_id string, null
Foreign Key omnichannel_subscriptions.id
The unique identifier of the related omnichannel subscription. This represents the subscription that the transaction is associated with.
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.