Stripe

The Stripe source pulls data from your Stripe accounts and sends it to your data warehouse. To setup the Stripe source, contact [email protected].

Data from the Stripe source can only be sent to the warehouse destinations.

Schema

Freshpaint provides the following tables and fields for Stripe as a Source:

balance_transactions

Each balance transaction represents a transfer of money either into or out of your Stripe account.

Column

Description

id

The unique identifier for the balance transaction.

amount

The amount of money for the transaction in cents.

currency

The ISO currency code for the currency used for the transaction.

description

The description of the transaction.

fee

The amount for the fee for the transaction in cents.

net

The net amount of the transaction in cents.

status

Whether the funds for the transaction are available yet. Can be either available or pending.

charges

A charge object represents a request to charge a credit or debit card.

Column

Description

id

The unique identifier for the charge.

amount

The amount of the charge in cents.

amount_refunded

The amount of the charge refunded in cents. It can different from the amount charged if there's a partial refund.

balance_transaction_id

The id of the balance transaction associated with the charge.

captured

Whether or not the charge is uncaptured. An uncaptured charge authorizes a payment without making it. This becomes true was the charge has been performed.

created

The Unix timestamp in seconds when the charge was created.

currency

The ISO currency code for the currency used for the charge.

customer_id

The ID of the customer being charged.

description

The description of the charge.

failure_code

A Stripe error code describing why the charge failed.

failure_message

A message explaining why the charge failed.

invoice_id

ID of the invoice this charge is a part of.

paid

Whether or not the charge has succeed.

receipt_email

The email address the receipt for the charge was sent to.

refunded

Whether or not the charge has been refunded.

statement_descriptor

The description of the charge on the customer's statement.

status

The status of the payment. Can be succeeded, pending, or failed.

customers

Column

Description

id

The unique identifier for the customer.

account_balance

The current balance of a customer. If positive, they have an amount owed that will be added to the next invoice. If negative, they have credit that will be applied to the next invoice.

currency

The ISO currency code for the currency used by the customer.

delinquent

Whether or not the customer's latest invoice was not paid on time.

description

A description of the customer.

email

The email for the customer.

invoice_items

An invoice item represents a one-off charge that was attached to an invoice.

Column

Description

id

The unique identifier for the invoice item.

currency

The ISO currency code for the currency for the invoice item.

customer_id

The ID of the customer the invoice belongs to.

description

The description of the invoice item.

discountable

Whether or not discounts will apply to the invoice item.

invoice_id

The ID of the invoice the invoice item belongs to.

proration

Whether or not the invoice item was created for a proration adjustment when the customer switched plans.

quantity

The number of units for the invoice item.

subscription_id

The ID of the subscription this invoice item is a part of.

invoice_lines

An invoice line represents one part of an invoice. It can represent either an invoice item or a subscription.

Column

Description

id

The unique identifier for the invoice item.

currency

The ISO currency code for the currency for the invoice item.

description

The description of the invoice item.

discountable

Whether or not discounts will apply to the invoice item.

invoice_id

The ID of the invoice the invoice item belongs to.

period_start

The Unix time in seconds for the start of the invoice period.

period_end

The Unix time in seconds for the end of the invoice period.

plan_id

The ID of the plan for the invoice line, if the invoice line is a subscription.

proration

Whether or not the invoice line was created for a proration adjustment when the customer switched plans.

quantity

The number of units for the invoice item.

subscription_id

The ID of the subscription this invoice item is a part of.

type

The source of the invoice line. It can be either invoiceitem or subscription.

invoices

Column

Description

id

The unique identifier for the invoice.

amount_due

The amount due for the invoice in cents.

applicationfee

The fee that will be applied to the owner's Stripe account when the invoice is paid. Only applicable if you are using Stripe Connect.

attempt_count

The number of attempts to pay the invoice.

attempted

Whether or not the invoice has been attempted to be paid.

charge_id

The ID of the charge associated with the invoice.

currency

The ISO currency code for the currency for the invoice.

customer_id

The ID of the customer the invoice is associated with.

description

A description of the invoice.

ending_balance

The final customer balance after the invoice is completed.

receipt_number

The receipt number that appears on the email receipts sent.

statement_descriptor

The description of the charge on the customer's statement.

subtotal

The total amount for the invoice in cents before a discount or tax is applied.

tax

The amount of tax in cents for the invoice.

total

The total amount in cents after discounts and taxes.

plans

A plan represents a unique type of subscription a customer can be a part of.

Column

Description

id

The unique identifier of the plan.

interval

How often the subscription is billed. Can be day, week, month, or year.

name

The name of the plan.

amount

The amount in cents to be charged.

currency

The ISO currency code for the currency for the plan.

interval_count

The number of intervals between when the subscription is billed. If interval=month and interval_count=3, the plan bills every 3 months.

trial_period_days

The number of days for the trial period when a customer is subscribed to the plan.

subscriptions

Column

Description

id

The unique identifier for the subscription.

application_fee_percent

An number between 0 and 100 representing the percentage of the invoice subtotal that will be transferred to the application owner's account. Only applicable if you are using Stripe Connect.

cancel_at_period_end

Whether or not the subscription will be cancelled at the end of the period.

customer_id

The ID of the customer the subscription is associated with.

quantity

The quantity of the item purchased for the subscription.

status

The status of the subscription. Can be incomplete, incomplete_expired, trialing, active, past_due, canceled, or unpaid.