1. Payments
  2. Transactions
  3. Transaction linked payments

Transaction linked payments

transaction_linked_payments
copy
Click to Copy
The list of payments captured for this authorization transaction.
UPSERT KEY
transaction_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
transaction_id string, not null
Foreign Key transactions.id
The unique identifier of the transaction this table belongs to.
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.
payment_txn_id string, not null
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.