Credit note line item discounts - Chargebee Data Catalog

Lists the discounts applied to each line item of this credit note.

UPSERT KEY

credit_note_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

credit_note_id string, not null

Foreign Key credit_notes.id

The unique ID of the credit note for this record.

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.

discount_amount long, not null

The amount deducted. The format of this value depends on the type of currency.

discount_type string, not null

The type of deduction and the amount to which it is applied.

entity_id string, null

When the deduction is due to a coupon or a discount, this is the id of the coupon or discount.

line_item_id string, not null

The unique ID of the line item for this deduction.

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.