Invoice Line Items

Here are the fields included in the Invoice Line Items source dataset you can export using destinations:

Field name Field type Description
ID Integer The internal ChartMogul ID of the invoice line item object.
EXTERNAL_ID String The unique identifier specified by you for the line item. Typically an identifier from your internal system.
TYPE String Either subscription or one_time.
TYPE_DATA JSON String Additional information about the invoice line item:
prorated — Specifies whether an invoice is prorated
proration_type — The type of proration
balance_transfer — Specifies whether there is balance transfer. Learn more.
AMOUNT_IN_CENTS Integer The final amount charged towards this line item, for the specified quantity and service period, after discounts, taxes and fees have been applied. Expressed in cents (or pence for GBP, etc.)
QUANTITY Integer The number of seats or licenses of the subscription being billed by this line item. Can be any non-zero integer. Defaults to 1.
DISCOUNT_CODE String If a discount has been applied to this line item, then this is an optional reference code to identify the discount.
DISCOUNT_AMOUNT_IN_CENTS Integer If any discount has been applied to this line item, then this is the discount amount in cents. Defaults to 0.
TAX_AMOUNT_IN_CENTS Integer The tax that has been applied to this line item, in cents. Defaults to 0.
SERVICE_PERIOD_START Timestamp The start date of the service period for which this subscription is being charged.
SERVICE_PERIOD_END Timestamp The end date of the service period for which this subscription is being charged.
TRANSACTION_FEES_IN_CENTS Integer The final total transaction fees paid to a billing provider and/or payment processor for this line item. Expressed in cents (or pence for GBP, etc.).
UNMAPPED_ATTRIBUTES JSON String Not used at the moment. The idea is to allow headers of any kind in the CSV file when uploading the data.
CREATED_AT Timestamp The time when this invoice line item was created in ChartMogul.
UPDATED_AT Timestamp The time when this invoice line item was updated in ChartMogul.
SUBSCRIPTION_EXTERNAL_ID String A reference identifier for the subscription in your system.
INVOICE_EXTERNAL_ID String The unique external identifier for the invoice that this invoice line item is part of.
PLAN_EXTERNAL_ID String The unique external identifier for the plan that this invoice line item is linked to.
DATA_SOURCE_UUID String The ChartMogul UUID of the source to which these invoices should be attributed.
SUBSCRIPTION_SET_EXTERNAL_ID String A reference identifier for a set of subscriptions used to group several subscriptions into one set.
TRANSACTION_FEES_CURRENCY String The three-letter currency code for transaction_fees_in_cents, e.g. USD, EUR, GBP. Refer to the full list of supported currencies.
DISCOUNT_DESCRIPTION String A short description of discount_amount_in_cents.
EVENT_ORDER Integer Used for ordering events that happen at the same time. Learn more.