Data Dictionary

Data Dictionary

The Stripe API creates a data object in response to each request, which Panoply unpacks and organizes into tables. References to “object” in the table schema listed below are referring to the data object created by Stripe. The Stripe data elements ingested by Panoply are listed below. Additional information is available in the Stripe API reference documentation.

Stripe’s data resources are organized into core resources, payment methods, checkout, billing, connect, fraud, issuing, terminal and orders categories. Panoply collects the following data from Stripe:

Core resources

Balance Transactions

This table contains data relating to your Stripe balance, as well as historical information about your balance. Stripe balance API endpoint documentation

Charges

This table contains data relating to the credit and debit charges in your account. Stripe charges API endpoint documentation

Customers

This table contains data relating to specific customers. Stripe customers API endpoint documentation

Disputes

This table contains data relating to disputes on your account. Stripe disputes API endpoint documentation.

Events

This table contains all data relating to events on your account. If a charge succeeds, or a payment fails, it will be reflected in an event object, which will in turn be written into this table.Stripe events API endpoint documentation.

Files

This table contains information regarding files hosted on Stripe’s servers. Stripe files API endpoint documentation

This table contains information about File Links, which contain a URL that can be used to retrieve the contents of the file without authentication. Stripe file links API endpoint documentation

Mandates

This table contains information about mandates, which are records the permission a customer has given you to debit their payment method. Stripe mandates API endpoint documentation

PaymentIntents

This table contains information about the PaymentIntent object. Stripe payment intents API endpoint documentation

SetupIntents

This table contains information about the SetupIntent object. Stripe setup intents API endpoint documentation

SetupAttempts

This table contains information about the SetupAttempt object, which describes one attempted confirmation of a SetupIntent, whether that confirmation was successful or unsuccessful. Stripe setup attempts API endpoint documentation

Payouts

This table contains data relating to payments into your account from Stripe. For more information, see the Stripe payouts API endpoint documentation.

Products

This table contains information about specific goods or services you offer to your customers. Stripe products API endpoint documentation

Prices

This table contains information about the prices, defined by the unit cost, currency, and (optional) billing cycle for both recurring and one-time purchases of products. Stripe prices API endpoint documentation

Refunds

This table contains data relating to refunds generated on your account.For more information, see the Stripe refunds API endpoint documentation

Tokens

This table contains information on the tokenization, which is the process Stripe uses to collect sensitive card or bank account details, or personally identifiable information (PII), directly from your customers in a secure manner. A token representing this information is returned to your server to use. Stripe tokens API endpoint documentation

Payment Methods

PaymentMethods

This table contains information about PaymentMethod objects, which represent your customer’s payment instruments. Stripe payment methods API endpoint documentation

Bank Accounts

This table contains information about the bank accounts used as payment methods on Customer objects. Stripe bank accounts API endpoint documentation

Cards

This table contains information about customer cards in order to charge the customer later. Stripe cards API endpoint documentation

Sources

This table contains information about source objects, which allow users to accept a variety of payment methods. They represent a customer’s payment instrument, and can be used with the Stripe API just like a Card object: once chargeable, they can be charged, or can be attached to customers. Stripe sources API endpoint documentation

Checkout

Sessions

This table contains data about the Checkout Session which represents your customer’s session as they pay for one-time purchases or subscriptions through Checkout. Stripe sources API endpoint documentation

Billing

Coupons

This table contains information about coupons that can be used by customers. Stripe coupons API endpoint documentation

Credit Notes

This table contains information about credit notes issued to adjust an invoice’s amount after the invoice is finalized. Stripe credit notes API endpoint documentation

Customer Balance Transactions

This table contains information about each customer’s balance value, which denotes a debit or credit that’s automatically applied to their next invoice upon finalization. Stripe customer balance transactions API endpoint documentation

Customer Portal

This table contains information regarding portal sessions, which describe the instantiation of the customer portal for a particular customer. Stripe customer portal API endpoint documentation

Customer Tax IDs

This table contains the customer’s tax IDs that are displayed on invoices and credit notes issued for the customer. Stripe customer tax IDs API endpoint documentation

Discounts

This table contains information about when the discount began and when it will end. Stripe discounts API endpoint documentation

Invoices

This table contains data relating to invoices on your account. For more information, see the Stripe invoices API endpoint documentation

Invoice Items

This table contains data relating to charges added to existing customer orders. For more information, see the Stripe invoive items API endpoint documentation

Plans

This table contains data relating to the subscription plans you have attached to your account. For more information, see the Stripe plans API endpoint documentation

Promotion Codes

This table contains information on customer-redeemable codes for a coupon. Stripe promotion codes API endpoint documentation

Subscriptions

This table contains data relating to the subscriptions attached to your account. For more information, see the Stripe subscriptions API endpoint documentation

Subscription Items

This table contains information about subscription items for customer subscriptions with more than one plan, making it easy to represent complex billing relationships. Stripe subscription items API endpoint documentation

Subscription Schedules

This table contains information about subscription schedules, which allow users to create and manage the lifecycle of a subscription by predefining expected changes. Stripe subscription schedules API endpoint documentation

Tax Rates

This table contains information about tax rates that can be applied to invoices, subscriptions and Checkout Sessions to collect tax. Stripe tax rates API endpoint documentation

Usage Records

This table contains information about usage records which allow users to report customer usage and metrics to Stripe for metered billing of subscription prices. Stripe usage records API endpoint documentation

Connect

Accounts

This table contains data relating to the customer accounts attached to your Stripe account.For more information, see the Stripe accounts API endpoint documentation

This table contains information about account links which are the means by which a Connect platform grants a connected account permission to access Stripe-hosted applications, such as Connect Onboarding. Stripe account links API endpoint documentation

Application fees

This table contains data relating to transaction fees that are additional to teh charges made to your customers. For more information, see the Stripe application fees API endpoint documentation

Capabilities

This table contains data relating to a capability for a Stripe account. Stripe capabilities API endpoint documentation

Country Specs

This table contains data relating to the country specs attached to each customer account. For more information, see the Stripe country specs API endpoint documentation

External Accounts

This table contains information on External Accounts, which are transfer destinations on Account objects for Custom and Express accounts. They can be bank accounts or debit cards.Stripe external accounts API endpoint documentation

Person

This table contains information for the object representing a person associated with a Stripe account. A platform cannot access a Standard or Express account’s persons after the account starts onboarding, such as after generating an account link for the account. Stripe person API endpoint documentation

Top-Ups

This table contains information about individual top-ups, as well as list all top-ups. Top-ups are identified by a unique, random ID. Stripe top ups API endpoint documentation

Transfers

This table contains information about funds moving between Stripe accounts as part of Connect. Stripe transfers API endpoint documentation

Transfer Reversals

This table contains information about reverse transfers made to a connected account, either entirely or partially, and can also specify whether to refund any related application fees. Transfer reversals add to the platform’s balance and subtract from the destination account’s balance. Stripe transfer reversals API endpoint documentation

Fraud

Early Fraud Warnings

This table contains information on early fraud warnings, which indicate that the card issuer has notified us that a charge may be fraudulent. Stripe early fraud warnings API endpoint documentation

Reviews

This table contains information about Reviews which can be used to supplement automated fraud detection with human expertise. Stripe fraud reviews API endpoint documentation

Value Lists

This table contains information about value lists, which allows users to group values together which can then be referenced in rules. Stripe fraud value list API endpoint documentation

Value List Items

This table contains information about the value list items, which allows users to add specific values to a given Radar value list, which can then be used in rules. Stripe fraud value list items API endpoint documentation

Issuing

Authorizations

This table contains information about the Issuing Authorization object which are created when an issued card is used to make a purchase. Stripe issuing authorizations API endpoint documentation

Cardholders

This table contains information about the Issuing Cardholder object which represents an individual or business entity who is issued cards. Stripe issuing cardholders API endpoint documentation

Disputes

This table contains information about dispute transactions. Stripe issuing disputes API endpoint documentation

Transactions

This table contains information about Issuing Transaction objects. Stripe issuing transactions API endpoint documentation

Terminal

Locations

This table contains information about locations. Each location represents a grouping of readers. Stripe terminal locations API endpoint documentation

Readers

This table contains information about readers. Each reader represents a physical device for accepting payment details. Stripe terminal readers API endpoint documentation

Orders

Orders

This table contains information about Order objects, which are created to handle end customers’ purchases of previously defined products. Stripe orders API endpoint documentation

Returns

This table contains information about return objects, which represents the full or partial return of a number of order items. Returns always belong to an order, and may optionally contain a refund. Stripe orders API endpoint documentation

SKUs

This table contains stores representations of stock keeping units. SKUs describe specific product variations, taking into account any combination of: attributes, currency, and cost. For example, a product may be a T-shirt, whereas a specific SKU represents the size: large, color: red version of that shirt. Stripe SKUs API endpoint documentation

Getting started is easy! Get all your data in one place in minutes.
Try Free