Stripe
## Columns
| Type | Name | Description |
| -------- | -------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 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\_number | A unique, identifying string that appears on emails sent to the customer for this invoice. This starts with the customer’s unique invoice\_prefix if it is specified. |
| DATETIME | invoice\_created\_at | Timestamp of when the invoice was created. |
| DATETIME | period\_start | Timestamp of the start of the period. |
| DATETIME | period\_end | Timestamp of the end of the period. |
| STRING | status | Current status of the invoice. |
| DATETIME | due\_date | Date when payment for the invoice is due. |
| STRING | currency | The currency that the invoice is in. Three-letter ISO currency code, in lowercase. |
| INTEGER | 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 | amount\_paid | The amount, if any, that the customer has paid on the invoice |
| INTEGER | subtotal | The amount of the invoice before discounts and taxes. |
| INTEGER | tax | The amount of tax being charged in the invoice. |
| INTEGER | total | The Total after discounts and taxes. |
| INTEGER | amount\_remaining | The amount of the invoice remaining to be paid. |
| INTEGER | attempt\_count | Number of payment attempts made for this invoice, from the perspective of the payment retry schedule. |
| STRING | invoice\_memo | An arbitrary string attached to the object. Often useful for displaying to users. |
| INTEGER | number\_of\_line\_items | Number of line item records for this invoice. |
| INTEGER | total\_quantity | The total quantity of items for this invoice. |
| STRING | balance\_transaction\_id | The ID of the balance transaction object representing payment |
| INTEGER | charge\_amount | The amount charged to the customer. |
| STRING | charge\_status | The status of the charge for the invoice. |
| STRING | connected\_account\_id | The ID of the account connected to the charge. |
| DATETIME | charge\_created\_at | When the charge for the invoice was created. |
| BOOLEAN | charge\_is\_refunded | Whether the charge has been fully refunded. If the charge is only partially refunded, this attribute will still be false. |
| STRING | customer\_id | The associated customer reference. |
| STRING | customer\_description | Description of the customer. |
| INTEGER | customer\_account\_balance | Current balance, if any, being stored on the customer. If negative, the customer has credit to apply to their next invoice. If positive, the customer has an amount owed that will be added to their next invoice. |
| STRING | customer\_currency | Three-letter ISO code for the currency the customer can be charged in for recurring billing purposes. |
| BOOLEAN | customer\_is\_delinquent | When the customer’s latest invoice is billed by charging automatically, delinquent is true if the invoice’s latest charge is failed. When the customer’s latest invoice is billed by sending an invoice, delinquent is true if the invoice is not paid by its due date. |
| STRING | customer\_email | Email of the customer. |
| STRING | subscription\_id | ID of the subscription this invoice relates to. |
| 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 |
| 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## 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-details.md?ask=