Billing
Invoicing
Payments
Product Catalog
Omnichannel transactions
omnichannel_transactions
copy
Click to Copy
Provides a unified view of subscription purchase transactions across multiple sources such as Apple App Store and Google Play Store. For Apple, the
price reflects the configured price at the time of purchase (after any offers).Columns
id string, not null
Primary Key
Unique identifier generated by Chargebee for the recorded transaction.
app_id string, not null
Chargebee App Identifier linked to the mobile app where the transaction originated.
created_at timestamp, not null
Timestamp when the omnichannel transaction record was created in Chargebee.
id_at_source string, not null
Identifier of the transaction in the source store. For the Apple App Store, this is the Transaction ID. For Google Play Store, this is the Order ID.
price_currency string, null
Three-letter ISO 4217 currency code associated with the transaction amount.
price_nanos long, null
Fractional part of the transaction amount in nanos (1 nanounit = 10⁻⁹ of the currency). Must be between 0 and 999,999,999. For example:
USD 1.23 = 230,000,000 nanos.price_units long, null
The whole currency units of the transaction amount. For example:
USD 1.23 has units 1.resource_version long, null
Version number of this resource. Updated with a new millisecond timestamp whenever the resource changes.
transacted_at timestamp, null
Timestamp of when the transaction occurred in the source store. (For Google Play, this value may not be available).
type string, not null
Specifies the transaction type (for example, purchase or renewal).
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.