# Stripe: Invoice Line Item Details ## Description * Each record represents an invoice line item, enriched with details about the associated invoice, charge, customer, subscription, and pricing data. ## Supported Data Sources * Stripe ## Columns | Type | Name | Description | | -------- | ------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | STRING | invoice\_line\_item\_id | The unique Identifier of the invoice line object. Note that the same line item can be shown across different invoices, so this value can appear multiple times. | | STRING | invoice\_id | The unique Identifier of the invoice object. Note invoices can have many line items, so this value can appear multiple times. | | STRING | invoice\_item\_id | The ID of the invoice item this item is a part of | | INTEGER | invoice\_line\_item\_amount | Amount for this line item. | | STRING | currency | Currency of this line item. | | STRING | invoice\_line\_item\_memo | Description for this line item. | | BOOLEAN | is\_discountable | Whether this line item is discountable. | | STRING | plan\_id | The ID that documents the plan record detailing the base price, currency, and billing information for each product. Valid if you are using the Plan API. | | STRING | price\_id | The ID that documents the price record detailing the base price, currency, and billing information for each product. Valid if you are using the new Prices API. | | BOOLEAN | proration | Whether this is a proration. | | INTEGER | quantity | The quantity of the subscription, if the line item is a subscription or a proration. | | STRING | subscription\_id | The ID of the subscription that the invoice item pertains to, if any. | | STRING | subscription\_item\_id | The subscription item that generated this invoice item. Left empty if the line item is not an explicit result of a subscription. | | STRING | type | A string identifying the type of the source of this line item, either an invoice item or a subscription. | | STRING | unique\_invoice\_line\_item\_id | A unique id generated for old invoice line item ID's from a past version of the API | | DATETIME | period\_start | Start of the usage period during which invoice items were added to this invoice. | | DATETIME | period\_end | End of the usage period during which invoice items were added to this invoice. | | DATETIME | invoice\_created\_at | Timestamp of when the invoice was created. | | STRING | invoice\_status | Current status of the invoice. | | DATETIME | invoice\_due\_date | Date when payment for the invoice is due. | | INTEGER | invoice\_amount\_due | Final amount due at this time for this invoice. If the invoice’s total is smaller than the minimum charge amount, for example, or if there is account credit that can be applied to the invoice, the amount\_due may be 0. If there is a positive starting\_balance for the invoice (the customer owes money), the amount\_due will also take that into account. The charge that gets generated for the invoice will be for the amount specified in amount\_due. | | INTEGER | invoice\_amount\_paid | The amount, if any, that the customer has paid on the invoice | | INTEGER | invoice\_subtotal | The amount of the invoice before discounts and taxes. | | INTEGER | invoice\_tax | The amount of tax being charged in the invoice. | | INTEGER | invoice\_total | The total of the invoice after discounts and taxes. | | STRING | connected\_account\_id | The ID of the account connected to the charge. | | STRING | customer\_id | The associated customer reference. | | STRING | subscription\_billing | How the subscription is billed | | DATETIME | subscription\_start\_date | The start date of the subscription | | DATETIME | subscription\_ended\_at | The end date of the subscription | | BOOLEAN | price\_plan\_is\_active | Boolean indicating if the plan or price is active (true) or in-active (false). | | INTEGER | price\_plan\_amount | The unit amount in cents to be charged, represented as a whole integer if possible. | | STRING | price\_plan\_interval | The frequency at which a subscription is billed. One of day, week, month or year. | | INTEGER | price\_plan\_interval\_count | The number of intervals between subscription billings. For example, interval\_count=3 bills every 3 months. | | STRING | price\_plan\_nickname | A brief description of the plan or price, hidden from customers. | | STRING | price\_plan\_product\_id | Reference to the product this price or plan is about. | | STRING | source\_relation | The source where this data was pulled from. If you are making use of the `union_schemas` variable, this will be the source schema. If you are making use of the `union_databases` variable, this will be the source database. If you are not unioning together multiple sources, this will be an empty string. | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/stripe-invoice-line-item-details.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.