1. Invoicing
  2. Invoices
  3. Invoice discounts

Invoice discounts

invoice_discounts
copy
Click to Copy
The list of all deductions applied to the invoice.

Columns

No match found
invoice_id string, not null
Foreign Key invoices.id
The unique ID of the invoice this table belongs to.
amount long, not null
The amount deducted.
coupon_set_code string, null
The coupon code, if applicable, used to provide the discount. The coupon ID is available in entity_id.
description string, null
Description of this deduction.
discount_type string, null
The type of discount applied to the line item. Relevant only when discounts[entity_type] is one of item_level_discount, item_level_coupon, document_level_discount, or document_level_coupon.
entity_id string, null
When the deduction is due to a coupon or a discount, this is the ID of the coupon or discount.
entity_type string, not null
The type of deduction and the amount to which it is applied.
line_item_id string, null
The unique ID of the line item this deduction is for. This is required when discounts[entity_type] is item_level_coupon or document_level_coupon.
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.