1. Invoicing
  2. Orders
  3. Order line item discounts

Order line item discounts

order_line_item_discounts
copy
Click to Copy

The list of discounts applied for the order.

Columns

No match found
order_id string, not null
Foreign Key orders.id
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 attribute 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 attribute 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_idattribute will be null in this case.
  • prorated_credits: Represents the credit adjustment items in the invoice. The coupon_id attribute will be null in this case.
entity_id string, null
When the deduction is due to a coupon or a discount, then 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.