Metrics
BETA
Billing
Invoicing
Payments
Invoice line items
invoice_line_items
copy
Click to Copy
The list of line items for this invoice.
Columns
id string, null
Uniquely identifies a line item.
subscription_id string, null
Foreign Key
subscriptions.id
A unique identifier for the subscription this line item belongs to.
invoice_id string, not null
Foreign Key
invoices.id
The unique ID of the invoice this table belongs to.
customer_id string, null
Foreign Key
customers.id
A unique identifier for the customer this line item belongs to.
amount long, null
Total amount of this line item. Typically equals unit amount x quantity.
amount_in_decimal string, null
The decimal representation of the amount for the
line_item, in major units of the currency. Typically equals unit_amount_in_decimal x quantity_in_decimal.date_from timestamp, not null
Start date of this line item.
date_to timestamp, not null
End date of this line item.
description string, not null
Detailed description of this line item.
discount_amount long, null
Total discounts for this line.
entity_description string, null
Detailed description of this item.
entity_id string, null
The identifier of the modeled entity this line item is based on. Will be null for the 'adhoc' entity type.
entity_type string, not null
Specifies the modeled entity this line item is based on.
is_taxed boolean, not null, default=false
Specifies whether this line item is taxed.
item_level_discount_amount long, null
Line item-level discounts for this line.
quantity null, default=1
The quantity of the recurring item represented by this line item. For metered line items, this value is updated from usages when:
- The invoice is generated as pending.
- The invoice is closed.
- The sync usages API is called.
quantity_in_decimal string, null
The decimal representation of the quantity of this line_item.
reference_line_item_id string, null
The unique identifier of the invoice line item to which this credit note line item is related. This is the same as invoice_line_items.id.
tax_amount long, null, default=0
The tax amount charged for this item.
tax_exempt_reason string, null
The reason the line item price/amount is exempted from tax.
tax_rate double, null
The rate of tax used to calculate tax for this line item.
unit_amount long, not null
Unit amount of the line item.
unit_amount_in_decimal string, null
The decimal representation of the unit amount of the
line_item. The value is in major units of the currency.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.