Stripe: Invoice Details

Description

• Each record represents an invoice, enriched with details about the associated charge, customer, and subscription data.

Supported Data Sources

• 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.