Payment source mandates - Chargebee Data Catalog

Each row is uniquely identified by this combination. Use these columns together as the upsert key when applying incremental datasets to your warehouse.

Columns

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.

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.

created_at timestamp, not null

Timestamp indicating when the mandate was created.

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.