Getting Started
Data Management
Frequently Asked Questions
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].
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
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
customer_id
The ID of the customer being charged.
description
The description of the charge.
failure_code
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
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
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
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
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
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.Last modified 1yr ago