1. Payments
  2. Payment sources
  3. Payment source mandates

Payment source mandates

payment_source_mandates
copy
Click to Copy
Mandate details associated with the payment source.

Columns

No match found
id string, not null
A unique mandate identifier of the payment_source_mandates table.
subscription_id string, not null
Foreign Key subscriptions.id
Chargebee’s subscription ID used to find the mapping between the payment source and the Subscription.
payment_source_id string, not null
Foreign Key payment_sources.id
The unique identifier of the payment source associated with this mandate.
created_at timestamp, not null
Timestamp indicating when the mandate was created.
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.