After the Stripe setup is complete, you'll see the following tables in your data warehouse.
To see a full list of attributes for each table, refer to Stripes's API documentation - click the table name to go there.
|balance_history||This table contains data about transactions have have contributed to your Stripe account balance, including charges, transfers, etc. Attributes include the balance history ID, amount, available on date, currency, description, fee, fee details, net, source, status, type, and created at date.|
|charges||This table contains information about charges to credit and debit cards, including the amount, currency, status, customer ID, and more.|
|coupons||This table contains information about a percent- or amount-off discount you may want to apply to a customer. Note that coupons only apply to invoices; they do not apply to one-off charges.|
|customers||Customer objects allow you to perform recurring charges and track multiple charges that are associated with the same customer.|
|events||Events let you know about something interesting that has just happened in an account. When an interesting event occurs, a new event object is created. For example, when a charge succeeds charge.succeeded event is created; or, when an invoice can't be paid an invoice.payment_failed event is created.
Note that many API requests may cause multiple events to be created. For example, if you create a new subscription for a customer, you will receive both a customer.subscription.created event and a charge.succeeded event.
|invoice_items||This table contains information about items contained in customer invoices. Attributes include the invoice item ID, amount, currency, customer, date, description, discountable flag, period start and end, plan details, and subscription.|
|invoices||This table contains information about invoices including the amount owed, subscriptions, invoice items, any automatic proration adjustments, and more.|
|plans||This table contains the pricing information for different products and feature levels on your site. For example, you may have a $10/month plan for basic features and a $20/month plan for premium features.|
|subscriptions||This table contains the details of subscription plans your customers belong to. Attributes include customer ID, status, canceled/ended at dates, tax percent, trial information, and more.|
|transfers||This table contains data about your transfers. A transfer is created any time Stripe sends you money or you initiiate a transfer to a connected account. Attributes include the transfer ID, amount, application fee, balance transaction, card details, currency, description, recipient, reversal info, source transaction, source type, statement descriptor, status, type, and created at date.|
|transfer_transactions||This table contains both a