The list of dunning attempts for a particular invoice.

Columns

No match found

transaction_id string, null
Foreign Key transactions.id
The transaction associated with the attempt.

invoice_id string, not null
Foreign Key invoices.id
The ID of the invoice for which dunning was attempted.

attempt not null
Dunning attempt number.

created_at timestamp, null
The timestamp when the attempt was made.

dunning_type string, not null, default=auto_collect
The type of dunning. Possible values are:
  • AUTO_COLLECT: Dunning type is auto collection.
  • OFFLINE: Dunning type is offline.
  • DIRECT_DEBIT: Dunning type is direct debit.

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.