InvoiceLineItems
Individual line items from invoices with pricing details
Columns
| Name | Type | ReadOnly | References | Description |
| Uuid [KEY] | String | True |
ChartMogul-generated UUID | |
| InvoiceUuid | String | False |
Invoices.Uuid |
UUID of the parent invoice |
| PlanUuid | String | False |
Plans.Uuid |
Associated plan identifier |
| Type | String | False |
Line item category The allowed values are subscription, one_time, trial. | |
| ProrationType | String | False |
Proration type The allowed values are differential, full, differential_mrr, differential_always. | |
| DisabledAt | Datetime | True |
Disablement timestamp | |
| ServicePeriodEnd | Datetime | False |
Billing period end date | |
| ServicePeriodStart | Datetime | False |
Billing period start date | |
| AccountCode | String | False |
Accounting reference | |
| AmountInCents | Long | False |
Charged amount after discounts and taxes (cents) | |
| IsBalanceTransfer | Boolean | False |
Customer balance return flag | |
| IsDisabled | Boolean | True |
Disabled status | |
| DisabledBy | String | True |
User who disabled | |
| DiscountAmountInCents | Long | False |
Discount value (cents) | |
| DiscountCode | String | False |
Applied discount code | |
| EditHistorySummary | String | True |
Edit tracking information | |
| ExternalId | String | False |
External line item identifier | |
| PlanExternalId | String | False |
External plan identifier | |
| IsProrated | Boolean | False |
Proration status | |
| Quantity | Integer | False |
Quantity being billed | |
| SubscriptionExternalId | String | False |
External subscription identifier | |
| SubscriptionSetExternalId | String | False |
Subscription set identifier | |
| SubscriptionUuid | String | True |
Associated subscription identifier | |
| TaxAmountInCents | Long | False |
Tax value (cents) | |
| TransactionFeesInCents | Long | False |
Associated fees (cents) | |
| IsUserCreated | Boolean | True |
Manual creation flag |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| IncludeEditHistories | Boolean |
Include edit history summary for automatic sources |
| IncludeDisabled | Boolean |
Include disabled invoices in response |