InvoiceLineItems
Returns the line items of invoices, including their amount, billing period, pricing, and applied discount details.
View-Specific Information
SELECT
The add-in uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
| Column | Supported Operators |
| InvoiceId | = |
| AccountId | = |
You can select from InvoiceLineItems with the following queries:
SELECT * FROM InvoiceLineItems WHERE InvoiceId = 'in_123456'
SELECT * FROM InvoiceLineItems WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the invoice line item. | |
| InvoiceId | String |
Invoices.Id | The Id of the invoice. |
| Amount | Integer | The amount of the line item, in cents. | |
| Currency | String | The three-letter ISO currency code, in lowercase. It must be a supported currency. | |
| Description | String | An arbitrary string attached to the object, often useful for displaying to users. | |
| Discountable | Boolean | Indicates whether discounts apply to this line item. This is always false for prorations. | |
| LiveMode | Boolean | Indicates whether the object exists in live mode, which is true in live mode and false in test mode. | |
| Metadata | String | The metadata object. | |
| Object | String | The string representing the object's type. Objects of the same type share the same value. | |
| PeriodEnd | Datetime | The end of the period, which must be greater than or equal to the start. | |
| PeriodStart | Datetime | The start of the period. | |
| Proration | Boolean | DEPRECATED. Indicates whether this line item is a proration. | |
| Quantity | Integer | The quantity of the subscription, if the line item is a subscription or a proration. | |
| Type | String | DEPRECATED. The string identifying the type of the source of this line item, such as invoiceitem or subscription. | |
| DiscountAmountsAggregate | String | The amount of discount calculated per discount for this line item. | |
| DiscountsAggregate | String | The discounts that apply to the line item. | |
| Subtotal | Integer | The subtotal of this line item. | |
| ParentInvoiceItemDetailsInvoiceItem | String | The invoice item that generated this line item. | |
| ParentSubscriptionItemDetailsSubscriptionItem | String | The subscription item that generated this line item. | |
| ParentSubscriptionItemDetailsProration | Boolean | Indicates whether this line item is a proration. | |
| PricingUnitAmount | Integer | DEPRECATED. The unit amount of the pricing for this line item. | |
| PricingType | String | The type of pricing, such as unit_amount or price. | |
| PricingPriceId | String | The Id of the price this line item uses. | |
| PricingUnitAmountDecimal | String | The unit amount of the pricing, in decimal, for this line item. | |
| PricingPriceDetailsProduct | String | The Id of the product that this price belongs to. | |
| PretaxCreditAmountsAggregate | String | The pretax credit amounts for this line item. | |
| TaxesAggregate | String | The taxes applied to this line item. | |
| QuantityDecimal | Decimal | The quantity of units for the line item, expressed as a non-negative decimal with at most 12 decimal places. | |
| ParentType | String | The type of parent that generated this line item. |
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 | |
| AccountId | String | The Id of the connected account from which to retrieve invoice line items. |