# Stripe: Subscription Details ## Description * Each record represents a subscription, enriched with customer details and payment aggregations. ## Supported Data Sources * Stripe ## Columns | Type | Name | Description | | -------- | ---------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | STRING | subscription\_id | Unique identifier for the subscription object. | | STRING | customer\_id | ID of the customer who owns the subscription. | | STRING | customer\_description | Description of the customer who owns the subscription. | | STRING | customer\_email | Email of the customer who owns the subscription. | | STRING | status | Possible values are incomplete, incomplete\_expired, trialing, active, past\_due, canceled, or unpaid. | | DATETIME | start\_date\_at | Date when the subscription was first created. The date might differ from the created date due to backdating. | | DATETIME | ended\_at | If the subscription has ended, the date the subscription ended. | | STRING | billing | How the description is billed. | | DATETIME | billing\_cycle\_anchor | Determines the date of the first full invoice, and, for plans with month or year intervals, the day of the month for subsequent invoices. | | DATETIME | canceled\_at | If the subscription has been canceled, the date of that cancellation. If the subscription was canceled with cancel\_at\_period\_end, canceled\_at will still reflect the date of the initial cancellation request, not the end of the subscription period when the subscription is automatically moved to a canceled state. | | DATETIME | created\_at | Time at which the subscription object was created. | | DATETIME | current\_period\_start | Start of the current period that the subscription has been invoiced for. | | DATETIME | current\_period\_end | End of the current period that the subscription has been invoiced for. At the end of this period, a new invoice will be created. | | INTEGER | days\_until\_due | Number of days a customer has to pay invoices generated by this subscription. This value will be null for subscriptions where collection\_method=charge\_automatically. | | BOOLEAN | is\_cancel\_at\_period\_end | If the subscription has been canceled with the at\_period\_end flag set to true, cancel\_at\_period\_end on the subscription will be true. You can use this attribute to determine whether a subscription that has a status of active is scheduled to be canceled at the end of the current period. | | DATETIME | cancel\_at | A date in the future at which the subscription will automatically get canceled | | INTEGER | number\_invoices\_generated | Number of invoices that have been generated for this subscription. | | INTEGER | total\_amount\_billed | The total amount that has been billed to the customer for this subscription. | | INTEGER | total\_amount\_paid | The total amount paid by the customer for this subscription. | | INTEGER | total\_amount\_remaining | Any outstanding balance for invoices related to this subscription. | | DATETIME | most\_recent\_invoice\_created\_at | The timestamp of the most recent invoice for this subscription created. | | DECIMAL | average\_invoice\_amount | The average amount of invoices generated for this subscription | | DECIMAL | average\_line\_item\_amount | The average sum of the line items for invoices generated for this subscription | | DECIMAL | avg\_num\_line\_items | The average number of line items for invoices generated for this 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. |