Order line item discounts - Chargebee Data Catalog

The list of discounts applied for the order.

order_id string, not null

The unique identifier of the order.

discount_amount long, not null

Discount amount.

discount_type string, not null

Type of this discount line item. Possible values are:

custom_discount: Represents the discount applied on a resent order against the original order.
document_level_coupon: Represents the 'Document' level coupons applied to this document. Further, the coupon_id field specifies the coupon ID this discount is based on.
document_level_discount: The deduction is due to a discount applied to the invoice sub_total. The discount ID is available as the entity_id.
item_level_coupon: Represents the 'Item' level coupons applied to this invoice. Further, the coupon_id field specifies the coupon ID this discount is based on.
item_level_discount: The deduction is due to a discount applied to a line item of the invoice. The discount ID is available as the entity_id.
promotional_credits: Represents the Promotional Credits item in the invoice. The coupon_id field will be null in this case.
prorated_credits: Represents the credit adjustment items in the invoice. The coupon_id field will be null in this case.

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 reference ID of the line item for which the discount is applicable.

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.