Stripe (v3) | Stitch Documentation

Stripe extraction is supported by Stitch
This integration is powered by Singer's Stripe tap and certified by Stitch. Check out and contribute to the repo on GitHub.

For support, contact Support.

Stripe integration summary

Stitch’s Stripe integration replicates data using the Stripe REST API. Refer to the Schema section for a list of objects available for replication.

Stripe feature snapshot

A high-level look at Stitch's Stripe (v3) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on August 29, 2023	Supported by	Stitch
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-stripe
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Stripe

Stripe setup requirements

To set up Stripe in Stitch, you need:

Administrator permissions in Stripe. This is required to grant Stitch access to Stripe.

Step 1: Add Stripe as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Stripe icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Stripe” would create a schema called stitch_stripe in the destination. Note: Schema names cannot be changed after you save the integration.
In the Lookback window field, enter the number of historical days’ worth of data you would like to replicate from the start date. The maximum lookback period is 600 days. This field is optional. Head to the Lookback windows and data extraction section to learn more about this.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Stripe integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Stripe’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Stripe integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access Stripe

Next, you’ll be prompted to sign into your Stripe account.
A screen explaining what you’re authorizing will display. Note: Stitch will only ever read your Stripe data, and cannot create charges or any other records in Stripe.
Click Sign in with Stripe to connect.
Sign into your Stripe account.
After the authorization process is successfully completed, you’ll be directed back to Stitch.
Click All Done.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Stripe integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Stripe, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

Stripe replication

Events table replication

Stripe will only provide 30 days of historical event data for the events table. Refer the the Stripe docs for more information about the events table.

Objects and events

In the Stripe API, there are two concepts:

Objects, which are items like charges, invoices, customers, etc.
Events, which are changes to objects. For example: An invoice being created, or its status going from draft to open.

Whenever an object is created or updated in Stripe, a corresponding event is created. Because Stripe creates and updates object records in this way, there are two types of tables in Stitch’s Stripe integration:

A table for events, which contains all events that have occurred for Stripe’s supported event types. This table acts as a history for an object record, showing how it has been changed over time.
Tables for objects, which contains the latest version of records. These are tables like customers, charges, invoices, etc.

Note: Updates based on events is only applicable to the type of object the event is for. For example: If a dispute object is updated, only the corresponding record in the disputes table will be updated. The related charge in the charges table will not be updated. To retrieve related data for different objects, you’ll need to use the events table. Refer to Stripe’s documentation for info about event types and the objects they describe.

Example event and object data replication over time

In the image below is an example of how records for the events and invoices tables will look as an invoice changes over time. Click the image to enlarge.

Lookback windows and data extraction

When Stitch runs a replication job for Stripe, you can use a configurable lookback window of up to 600 days to query and extract data for your tables. A lookback window is a period of time for attributing shared files and the lookback period after those actions occur.

While Stitch replicates data in this way to account for updates to records made during the lookback window, it can have a substantial impact on your overall row usage.

In the sections below are examples of how lookback windows impact how Stitch extracts data during historical and ongoing replication jobs.

Historical and full re-replications
Ongoing replications

For historical and full re-replications of Stripe data, Stitch will query for and extract data newer than or equal to the date defined in the Start Date field in the Integration Settings page.

The Start Date, in conjunction with the Lookback Window, defines the minimum date Stitch should query for when extracting historical data. This is calculated as:

Start Date - Lookback Window = Minimum Extraction Date

Example

During the initial set up, the Lookback Window and Start Date settings are defined as:

Lookback Window: 600 days (default setting)
Start Date: 07/03/2017, or 2017-07-03 00:00:00

To account for the Lookback Window, Stitch would calculate the Minimum Extraction Date value as: 2017-07-03 00:00:00 - 600 days = 2015-11-11 00:00:00

If you were to write a SQL query using this date for the charges table, it might look like this:

  SELECT *
    FROM stripe.charges
   WHERE created >= '2015-11-11 00:00:00'   /* Min. Extraction Date */
ORDER BY created

For ongoing replication jobs, Stitch will query for and extract data using the last saved maximum value in the table’s Replication Key column and the Lookback Window for the table.

Note: This applies to every replication job that takes place after the historical replication job.

Example

The last maximum saved Replication Key value for the charges table is 2017-10-01 00:00:00.

To account for the Lookback Window of 600 days, we’d subtract this from the last maximum saved Replication Key value:

2017-10-01 00:00:00 - 600 days = 2016-02-09 00:00:00

In this case, Stitch would query for and extract data that is newer than or equal to 2016-02-09 00:00:00 and older than or equal to 2017-10-01 00:00:00.

If this were a SQL query, it might look like this:

  SELECT *
    FROM charges
   WHERE created >= '2016-02-09 00:00:00'
                              /* max Replication Key value - Lookback Window */
     AND created <= '2017-10-01 00:00:00'
                              /* max Replication Key value from previous job */
ORDER BY created

Stripe table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 3 of this integration.

This is the latest version of the Stripe integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

balance_transactions

The balance_transactions table contains info about transactions have have contributed to your Stripe account balance, including charges, transfers, etc.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation balance_transactions schema on GitHub Stripe API method

balance_transactions table foreign keys

Join balance_transactions with	on
charges	balance_transactions.id = charges.balance_transaction
payouts	balance_transactions.id = payouts.balance_transaction balance_transactions.id = payouts.failure_balance_transaction
transfers	balance_transactions.id = transfers.balance_transaction balance_transactions.id = transfers.failure_balance_transaction
disputes	balance_transactions.id = disputes.balance_transactions.id

balance_transactions table schema

amount

INTEGER

available_on

INTEGER

created

DATE-TIME

currency

STRING

description

STRING

exchange_rate

NUMBER

fee

INTEGER

fee_details

ARRAY

Click to expand fee_details

amount

INTEGER

application

STRING

currency

STRING

description

STRING

type

STRING

net

INTEGER

object

STRING

source

STRING

sourced_transfers

ARRAY

status

STRING

type

STRING

updated

DATE-TIME

charges

The charges table contains info about charges to credit and debit cards.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation charges schema on GitHub Stripe API method

charges table foreign keys

Join charges with	on
balance_transactions	charges.balance_transaction = balance_transactions.id
payouts	charges.balance_transaction = payouts.balance_transaction charges.balance_transaction = payouts.failure_balance_transaction
transfers	charges.balance_transaction = transfers.balance_transaction charges.balance_transaction = transfers.failure_balance_transaction charges.source_transfer = transfers.id
disputes	charges.balance_transaction = disputes.balance_transactions.id charges.id = disputes.charge
customers	charges.card.id = customers.cards.id charges.source.id = customers.cards.id charges.customer = customers.id charges.card.customer = customers.id charges.customer = customers.cards.customer charges.card.customer = customers.cards.customer charges.customer = customers.discount.customer charges.card.customer = customers.discount.customer
invoices	charges.id = invoices.charge charges.customer = invoices.customer charges.card.customer = invoices.customer charges.customer = invoices.discount.customer charges.card.customer = invoices.discount.customer charges.invoice = invoices.id
invoice_items	charges.customer = invoice_items.customer charges.card.customer = invoice_items.customer charges.invoice = invoice_items.invoice
subscription_items	charges.customer = subscription_items.customer charges.card.customer = subscription_items.customer
subscriptions	charges.customer = subscriptions.customer charges.card.customer = subscriptions.customer
invoice_line_items	charges.invoice = invoice_line_items.invoice

charges table schema

amount

INTEGER

amount_captured

INTEGER

amount_refunded

INTEGER

application

STRING

application_fee

STRING

application_fee_amount

INTEGER

balance_transaction

STRING

billing_details

OBJECT

Click to expand billing_details

address

OBJECT

Click to expand address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

email

STRING

name

STRING

phone

STRING

calculated_statement_descriptor

STRING

captured

BOOLEAN

card

OBJECT

Click to expand card

address_city

STRING

address_country

STRING

address_line1

STRING

address_line1_check

STRING

address_line2

STRING

address_state

STRING

address_zip

STRING

address_zip_check

STRING

brand

STRING

country

STRING

customer

STRING

cvc_check

STRING

dynamic_last4

STRING

exp_month

INTEGER

exp_year

INTEGER

fingerprint

STRING

funding

STRING

last4

STRING

metadata

OBJECT

name

STRING

object

STRING

tokenization_method

STRING

type

STRING

created

DATE-TIME

currency

STRING

customer

STRING

description

STRING

destination

STRING

dispute

STRING

disputed

BOOLEAN

failure_code

STRING

failure_message

STRING

fraud_details

OBJECT

Click to expand fraud_details

stripe_report

STRING

invoice

STRING

livemode

BOOLEAN

metadata

OBJECT

object

STRING

on_behalf_of

STRING

order

STRING

outcome

OBJECT

Click to expand outcome

network_status

STRING

reason

STRING

risk_level

STRING

risk_score

INTEGER

seller_message

STRING

type

STRING

paid

BOOLEAN

payment_intent

STRING

payment_method

STRING

payment_method_details

OBJECT

Click to expand payment_method_details

ach_credit_transfer

OBJECT

Click to expand ach_credit_transfer

account_number

STRING

bank_name

STRING

routing_number

STRING

swift_code

STRING

ach_debit

OBJECT

Click to expand ach_debit

account_holder_type

STRING

bank_name

STRING

country

STRING

fingerprint

STRING

last4

STRING

routing_number

STRING

alipay

OBJECT

bancontact

OBJECT

Click to expand bancontact

bank_code

STRING

bank_name

STRING

bic

STRING

iban_last4

STRING

preferred_language

STRING

verified_name

STRING

card

OBJECT

Click to expand card

address_city

STRING

address_country

STRING

address_line1

STRING

address_line1_check

STRING

address_line2

STRING

address_state

STRING

address_zip

STRING

address_zip_check

STRING

brand

STRING

card_present

OBJECT

Click to expand card_present

brand

STRING

country

STRING

emv_auth_data

STRING

exp_month

INTEGER

exp_year

INTEGER

fingerprint

STRING

funding

STRING

generated_card

STRING

last4

STRING

network

STRING

read_method

STRING

receipt

OBJECT

Click to expand receipt

application_cryptogram

STRING

application_preferred_name

STRING

authorization_code

STRING

authorization_response_code

STRING

cardholder_verification_method

STRING

dedicated_file_name

STRING

terminal_verification_results

STRING

transaction_status_information

STRING

checks

OBJECT

Click to expand checks

address_line1_check

STRING

address_postal_code_check

STRING

cvc_check

STRING

country

STRING

customer

STRING

cvc_check

STRING

dynamic_last4

STRING

eps

OBJECT

Click to expand eps

verified_name

STRING

exp_month

INTEGER

exp_year

INTEGER

fingerprint

STRING

funding

STRING

giropay

OBJECT

Click to expand giropay

bank_code

STRING

bank_name

STRING

bic

STRING

verified_name

STRING

ideal

OBJECT

Click to expand ideal

bank

STRING

bic

STRING

iban_last4

STRING

verified_name

STRING

installments

OBJECT

Click to expand installments

plan

OBJECT

Click to expand plan

count

INTEGER

interval

STRING

type

STRING

klarna

OBJECT

last4

STRING

metadata

OBJECT

multibanco

OBJECT

Click to expand multibanco

entity

STRING

reference

STRING

name

STRING

network

STRING

object

STRING

p24

OBJECT

Click to expand p24

reference

STRING

verified_name

STRING

sepa_debit

OBJECT

Click to expand sepa_debit

bank_code

STRING

branch_code

STRING

country

STRING

fingerprint

STRING

last4

STRING

mandate

STRING

sofort

OBJECT

Click to expand sofort

bank_code

STRING

bank_name

STRING

bic

STRING

country

STRING

iban_last4

STRING

verified_name

STRING

stripe_account

OBJECT

three_d_secure

OBJECT

Click to expand three_d_secure

authenticated

BOOLEAN

succeeded

BOOLEAN

version

STRING

tokenization_method

STRING

type

STRING

wallet

OBJECT

Click to expand wallet

amex_express_checkout

OBJECT

apple_pay

OBJECT

dynamic_last4

STRING

google_pay

OBJECT

masterpass

OBJECT

Click to expand masterpass

billing_address

OBJECT

Click to expand billing_address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

email

STRING

name

STRING

shipping_address

OBJECT

Click to expand shipping_address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

samsung_pay

OBJECT

type

STRING

visa_checkout

OBJECT

Click to expand visa_checkout

billing_address

OBJECT

Click to expand billing_address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

email

STRING

name

STRING

shipping_address

OBJECT

Click to expand shipping_address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

wechat

OBJECT

card_present

OBJECT

Click to expand card_present

amount_authorized

INTEGER

brand

STRING

cardholder_name

STRING

country

STRING

emv_auth_data

STRING

exp_month

INTEGER

exp_year

INTEGER

fingerprint

STRING

funding

STRING

generated_card

STRING

last4

STRING

network

STRING

overcapture_supported

BOOLEAN

read_method

STRING

receipt

OBJECT

Click to expand receipt

account_type

STRING

application_cryptogram

STRING

application_preferred_name

STRING

authorization_code

STRING

authorization_response_code

STRING

cardholder_verification_method

STRING

dedicated_file_name

STRING

terminal_verification_results

STRING

transaction_status_information

STRING

type

STRING

receipt_email

STRING

receipt_number

STRING

receipt_url

STRING

refunded

BOOLEAN

refunds

ARRAY

Click to expand refunds

amount

INTEGER

balance_transaction

STRING

charge

STRING

created

DATE-TIME

currency

STRING

description

STRING

failure_reason

STRING

instructions_email

STRING

metadata

OBJECT

next_action

OBJECT

Click to expand next_action

display_details

OBJECT

Click to expand display_details

email_sent

OBJECT

Click to expand email_sent

email_sent_at

DATE-TIME

email_sent_to

STRING

expires_at

DATE-TIME

type

STRING

object

STRING

payment_intent

STRING

reason

STRING

receipt_number

STRING

source_transfer_reversal

STRING

status

STRING

transfer_reversal

STRING

review

STRING

shipping

OBJECT

source

OBJECT

Click to expand source

ach_credit_transfer

OBJECT

Click to expand ach_credit_transfer

account_number

STRING

bank_name

STRING

fingerprint

STRING

refund_account_holder_name

STRING

refund_account_holder_type

STRING

refund_account_number

STRING

refund_routing_number

STRING

routing_number

STRING

swift_code

STRING

address_city

STRING

address_country

STRING

address_line1

STRING

address_line1_check

STRING

address_line2

STRING

address_state

STRING

address_zip

STRING

address_zip_check

STRING

alipay

OBJECT

amount

INTEGER

bancontact

OBJECT

brand

STRING

card

OBJECT

Click to expand card

address_line1_check

STRING

address_zip_check

STRING

brand

STRING

country

STRING

cvc_check

STRING

dynamic_last4

STRING

exp_month

INTEGER

exp_year

INTEGER

fingerprint

STRING

funding

STRING

last4

STRING

name

STRING

three_d_secure

STRING

tokenization_method

STRING

type

STRING

client_secret

STRING

country

STRING

created

DATE-TIME

currency

STRING

customer

STRING

cvc_check

STRING

dynamic_last4

STRING

eps

OBJECT

exp_month

INTEGER

exp_year

INTEGER

fingerprint

STRING

flow

STRING

funding

STRING

ideal

OBJECT

last4

STRING

livemode

BOOLEAN

metadata

OBJECT

multibanco

OBJECT

name

STRING

object

STRING

owner

OBJECT

Click to expand owner

address

OBJECT

Click to expand address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

email

STRING

name

STRING

phone

STRING

verified_address

STRING

verified_email

STRING

verified_name

STRING

verified_phone

STRING

receiver

OBJECT

Click to expand receiver

address

STRING

amount_charged

INTEGER

amount_received

INTEGER

amount_returned

INTEGER

refund_attributes_method

STRING

refund_attributes_status

STRING

redirect

OBJECT

Click to expand redirect

failure_reason

STRING

return_url

STRING

status

STRING

url

STRING

statement_descriptor

STRING

status

STRING

tokenization_method

STRING

type

STRING

usage

STRING

source_transfer

STRING

statement_description

STRING

statement_descriptor

STRING

statement_descriptor_suffix

STRING

status

STRING

transfer_data

OBJECT

Click to expand transfer_data

amount

INTEGER

destination

STRING

transfer_group

STRING

updated

DATE-TIME

updated_by_event_type

STRING

coupons

The coupons table contains info about percent or amount-off discounts that may be applied to a customer. Note: Coupons only apply to invoices; they don’t apply to one-off charges.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation coupons schema on GitHub Stripe API method

coupons table foreign keys

Join coupons with	on
customers	coupons.id = customers.discount.coupon.id
invoices	coupons.id = invoices.discount.coupon.id
subscriptions	coupons.id = subscriptions.discount.coupon.id

coupons table schema

amount_off

INTEGER

created

DATE-TIME

currency

STRING

duration

STRING

duration_in_months

INTEGER

STRING

livemode

BOOLEAN

max_redemptions

INTEGER

metadata

OBJECT

name

STRING

object

STRING

percent_off

NUMBER

percent_off_precise

NUMBER

redeem_by

DATE-TIME

times_redeemed

INTEGER

updated

DATE-TIME

updated_by_event_type

STRING

valid

BOOLEAN

customers

The customers table contains info about your customers.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation customers schema on GitHub Stripe API method

customers table foreign keys

Join customers with	on
charges	customers.cards.id = charges.card.id customers.cards.id = charges.source.id customers.id = charges.customer customers.cards.customer = charges.customer customers.discount.customer = charges.customer customers.id = charges.card.customer customers.cards.customer = charges.card.customer customers.discount.customer = charges.card.customer
coupons	customers.discount.coupon.id = coupons.id
invoices	customers.discount.coupon.id = invoices.discount.coupon.id customers.id = invoices.customer customers.cards.customer = invoices.customer customers.discount.customer = invoices.customer customers.id = invoices.discount.customer customers.cards.customer = invoices.discount.customer customers.discount.customer = invoices.discount.customer customers.subscriptions = invoices.subscription customers.discount.subscription = invoices.subscription customers.subscriptions = invoices.discount.subscription customers.discount.subscription = invoices.discount.subscription
subscriptions	customers.discount.coupon.id = subscriptions.discount.coupon.id customers.id = subscriptions.customer customers.cards.customer = subscriptions.customer customers.discount.customer = subscriptions.customer customers.subscriptions = subscriptions.id customers.discount.subscription = subscriptions.id
invoice_items	customers.id = invoice_items.customer customers.cards.customer = invoice_items.customer customers.discount.customer = invoice_items.customer customers.subscriptions = invoice_items.subscription customers.discount.subscription = invoice_items.subscription
subscription_items	customers.id = subscription_items.customer customers.cards.customer = subscription_items.customer customers.discount.customer = subscription_items.customer customers.subscriptions = subscription_items.subscription customers.discount.subscription = subscription_items.subscription
invoice_line_items	customers.subscriptions = invoice_line_items.subscription customers.discount.subscription = invoice_line_items.subscription

customers table schema

account_balance

INTEGER

address

OBJECT

Click to expand address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

balance

INTEGER

cards

ARRAY

Click to expand cards

address_city

STRING

address_country

STRING

address_line1

STRING

address_line1_check

STRING

address_line2

STRING

address_state

STRING

address_zip

STRING

address_zip_check

STRING

brand

STRING

country

STRING

customer

STRING

cvc_check

STRING

dynamic_last4

STRING

exp_month

INTEGER

exp_year

INTEGER

fingerprint

STRING

funding

STRING

last4

STRING

metadata

OBJECT

name

STRING

object

STRING

tokenization_method

STRING

type

STRING

created

DATE-TIME

currency

STRING

default_card

STRING

default_source

STRING

delinquent

BOOLEAN

description

STRING

discount

OBJECT

Click to expand discount

checkout_session

STRING

coupon

OBJECT

Click to expand coupon

amount_off

INTEGER

created

DATE-TIME

currency

STRING

duration

STRING

duration_in_months

INTEGER

STRING

livemode

BOOLEAN

max_redemptions

INTEGER

metadata

OBJECT

name

STRING

object

STRING

percent_off

NUMBER

percent_off_precise

NUMBER

redeem_by

DATE-TIME

times_redeemed

INTEGER

valid

BOOLEAN

customer

STRING

end

DATE-TIME

STRING

invoice

STRING

invoice_item

STRING

object

STRING

promotion_code

STRING

start

DATE-TIME

subscription

STRING

email

STRING

invoice_prefix

STRING

invoice_settings

OBJECT

Click to expand invoice_settings

custom_fields

ARRAY

default_payment_method

STRING

footer

STRING

livemode

BOOLEAN

metadata

OBJECT

name

STRING

next_invoice_sequence

INTEGER

object

STRING

phone

STRING

preferred_locales

ARRAY

shipping

OBJECT

Click to expand shipping

address

OBJECT

Click to expand address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

name

STRING

phone

STRING

sources

ARRAY

Click to expand sources

ach_credit_transfer

OBJECT

Click to expand ach_credit_transfer

account_number

STRING

bank_name

STRING

fingerprint

STRING

refund_account_holder_name

STRING

refund_account_holder_type

STRING

refund_account_number

STRING

refund_routing_number

STRING

routing_number

STRING

swift_code

STRING

address_city

STRING

address_country

STRING

address_line1

STRING

address_line1_check

STRING

address_line2

STRING

address_state

STRING

address_zip

STRING

address_zip_check

STRING

alipay

OBJECT

amount

INTEGER

bancontact

OBJECT

brand

STRING

card

OBJECT

Click to expand card

address_line1_check

STRING

address_zip_check

STRING

brand

STRING

country

STRING

cvc_check

STRING

dynamic_last4

STRING

exp_month

INTEGER

exp_year

INTEGER

fingerprint

STRING

funding

STRING

last4

STRING

name

STRING

three_d_secure

STRING

tokenization_method

STRING

type

STRING

client_secret

STRING

country

STRING

created

DATE-TIME

currency

STRING

customer

STRING

cvc_check

STRING

dynamic_last4

STRING

eps

OBJECT

exp_month

INTEGER

exp_year

INTEGER

fingerprint

STRING

flow

STRING

funding

STRING

ideal

OBJECT

last4

STRING

livemode

BOOLEAN

metadata

OBJECT

multibanco

OBJECT

name

STRING

object

STRING

owner

OBJECT

Click to expand owner

address

OBJECT

Click to expand address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

email

STRING

name

STRING

phone

STRING

verified_address

STRING

verified_email

STRING

verified_name

STRING

verified_phone

STRING

receiver

OBJECT

Click to expand receiver

address

STRING

amount_charged

INTEGER

amount_received

INTEGER

amount_returned

INTEGER

refund_attributes_method

STRING

refund_attributes_status

STRING

redirect

OBJECT

Click to expand redirect

failure_reason

STRING

return_url

STRING

status

STRING

url

STRING

statement_descriptor

STRING

status

STRING

tokenization_method

STRING

type

STRING

usage

STRING

["TYPE", ["NULL", "STRING"]]

subscriptions

ARRAY

tax_exempt

STRING

tax_ids

ARRAY

Click to expand tax_ids

country

STRING

created

DATE-TIME

customer

STRING

livemode

BOOLEAN

object

STRING

type

STRING

value

STRING

verification

OBJECT

Click to expand verification

status

STRING

verified_address

STRING

verified_name

STRING

["TYPE", ["NULL", "STRING"]]

tax_info

STRING

tax_info_verification

STRING

updated

DATE-TIME

updated_by_event_type

STRING

disputes

This table contains information about customer disputes related to charges on their credit card.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation disputes schema on GitHub Stripe API method

disputes table foreign keys

Join disputes with	on
balance_transactions	disputes.balance_transactions.id = balance_transactions.id
charges	disputes.balance_transactions.id = charges.balance_transaction disputes.charge = charges.id
payouts	disputes.balance_transactions.id = payouts.balance_transaction disputes.balance_transactions.id = payouts.failure_balance_transaction
transfers	disputes.balance_transactions.id = transfers.balance_transaction disputes.balance_transactions.id = transfers.failure_balance_transaction
invoices	disputes.charge = invoices.charge

disputes table schema

amount

INTEGER

balance_transactions

ARRAY

Click to expand balance_transactions

STRING

charge

STRING

created

DATE-TIME

currency

STRING

evidence

STRING, OBJECT

Click to expand evidence

access_activity_log

STRING

billing_address

STRING

cancellation_policy

STRING

cancellation_policy_disclosure

STRING

cancellation_rebuttal

STRING

customer_communication

STRING

customer_email_address

STRING

customer_name

STRING

customer_purchase_ip

STRING

customer_signature

STRING

duplicate_charge_documentation

STRING

duplicate_charge_explanation

STRING

duplicate_charge_id

STRING

product_description

STRING

receipt

STRING

refund_policy

STRING

refund_policy_disclosure

STRING

refund_refusal_explanation

STRING

service_date

STRING

service_documentation

STRING

shipping_address

STRING

shipping_carrier

STRING

shipping_date

STRING

shipping_documentation

STRING

shipping_tracking_number

STRING

uncategorized_file

STRING

uncategorized_text

STRING

evidence_details

OBJECT

Click to expand evidence_details

due_by

DATE-TIME

has_evidence

BOOLEAN

past_due

BOOLEAN

submission_count

INTEGER

STRING

is_charge_refundable

BOOLEAN

livemode

BOOLEAN

metadata

OBJECT

object

STRING

reason

STRING

status

STRING

updated

DATE-TIME

updated_by_event_type

STRING

events

The events table contains info about events. When an event occurs, a new event object is created. This table acts as the history of an object, allowing you to see how it has changed over time.

For example: When an invoice is created, an invoice.created event is created. When the draft invoice is finalized and updated to be open, an invoice.finalized event is created. When the invoice is sent to the customer, an invoice.sent event is created.

For more info about this table and how data is replicated, refer to the Replication section. Additionally, refer to Stripe’s documentation for info about event types and the objects they describe.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation events schema on GitHub Stripe API method

events table schema

api_version

STRING

created

DATE-TIME

data

OBJECT

STRING

livemode

BOOLEAN

object

STRING

pending_webhooks

INTEGER

request

STRING

type

STRING

updated

DATE-TIME

invoice_items

The invoice_items table contains info about items contained in customer invoices.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	date
Useful links	Stripe documentation invoice_items schema on GitHub Stripe API method

invoice_items table foreign keys

Join invoice_items with	on
charges	invoice_items.customer = charges.customer invoice_items.customer = charges.card.customer invoice_items.invoice = charges.invoice
customers	invoice_items.customer = customers.id invoice_items.customer = customers.cards.customer invoice_items.customer = customers.discount.customer invoice_items.subscription = customers.subscriptions invoice_items.subscription = customers.discount.subscription
invoices	invoice_items.customer = invoices.customer invoice_items.customer = invoices.discount.customer invoice_items.invoice = invoices.id invoice_items.subscription = invoices.subscription invoice_items.subscription = invoices.discount.subscription
subscription_items	invoice_items.customer = subscription_items.customer invoice_items.plan.id = subscription_items.plan.id invoice_items.plan.product = subscription_items.plan.product invoice_items.subscription_item = subscription_items.id invoice_items.subscription = subscription_items.subscription
subscriptions	invoice_items.customer = subscriptions.customer invoice_items.plan.id = subscriptions.plan.id invoice_items.plan.product = subscriptions.plan.product invoice_items.subscription_item = subscriptions.items invoice_items.subscription = subscriptions.id
invoice_line_items	invoice_items.invoice = invoice_line_items.invoice invoice_items.id = invoice_line_items.invoice_item invoice_items.plan.product = invoice_line_items.plan.product invoice_items.subscription = invoice_line_items.subscription
plans	invoice_items.plan.id = plans.id invoice_items.plan.product = plans.product
products	invoice_items.plan.product = products.id

invoice_items table schema

amount

INTEGER

currency

STRING

customer

STRING

date

DATE-TIME

description

STRING

discountable

BOOLEAN

discounts

ARRAY

STRING

invoice

STRING

livemode

BOOLEAN

metadata

OBJECT

object

STRING

period

OBJECT

Click to expand period

end

DATE-TIME

start

DATE-TIME

plan

OBJECT

Click to expand plan

active

BOOLEAN

aggregate_usage

STRING

amount

INTEGER

amount_decimal

NUMBER

billing_scheme

STRING

created

DATE-TIME

currency

STRING

interval

STRING

interval_count

INTEGER

livemode

BOOLEAN

metadata

OBJECT

name

STRING

nickname

STRING

object

STRING

product

STRING

statement_description

STRING

statement_descriptor

STRING

tiers

ARRAY

Click to expand tiers

flat_amount

INTEGER

unit_amount

INTEGER

up_to

INTEGER

tiers_mode

STRING

transform_usage

OBJECT

trial_period_days

INTEGER

updated

DATE-TIME

updated_by_event_type

STRING

usage_type

STRING

proration

BOOLEAN

quantity

INTEGER

subscription

STRING

subscription_item

STRING

tax_rates

ARRAY

Click to expand tax_rates

active

BOOLEAN

country

STRING

created

DATE-TIME

description

STRING

display_name

STRING

inclusive

BOOLEAN

jurisdiction

STRING

livemode

BOOLEAN

object

STRING

percentage

NUMBER

state

STRING

unit_amount

INTEGER

unit_amount_decimal

NUMBER

updated

DATE-TIME

updated_by_event_type

STRING

invoice_line_items

The invoice_line_items table contains info about the line items contained in invoices.

Note: In order to replicate invoice line item data, the invoices table must also be set to replicate.

Invoice line item replication

To replicate invoice line items, Stitch will use the Replication Key of the corresponding invoice in the invoices table to detect new and updated records. This means that any time an invoice is updated, its associated line items will also be replicated.

For example: An invoice with five line items is updated when its status changes from draft to open. The record in invoices will be replicated, as will the records for its five line items. In this example, a total of six records will be replicated.

Replication Method

Key-based Incremental

Primary Keys

invoice

Useful links

Stripe documentation

invoice_line_items schema on GitHub

Stripe API method

invoice_line_items table foreign keys

Join invoice_line_items with	on
charges	invoice_line_items.invoice = charges.invoice
invoice_items	invoice_line_items.invoice = invoice_items.invoice invoice_line_items.invoice_item = invoice_items.id invoice_line_items.plan.product = invoice_items.plan.product invoice_line_items.subscription = invoice_items.subscription
invoices	invoice_line_items.invoice = invoices.id invoice_line_items.id = invoices.lines invoice_line_items.subscription = invoices.subscription invoice_line_items.subscription = invoices.discount.subscription
plans	invoice_line_items.plan.product = plans.product
products	invoice_line_items.plan.product = products.id
subscription_items	invoice_line_items.plan.product = subscription_items.plan.product invoice_line_items.subscription = subscription_items.subscription
subscriptions	invoice_line_items.plan.product = subscriptions.plan.product invoice_line_items.subscription = subscriptions.id
customers	invoice_line_items.subscription = customers.subscriptions invoice_line_items.subscription = customers.discount.subscription

invoice_line_items table schema

amount

INTEGER

currency

STRING

description

STRING

discount_amounts

ARRAY

Click to expand discount_amounts

amount

INTEGER

discount

STRING

discountable

BOOLEAN

discounts

ARRAY

STRING

invoice

STRING

invoice_item

STRING

livemode

BOOLEAN

metadata

OBJECT

object

STRING

period

OBJECT

Click to expand period

end

DATE-TIME

start

DATE-TIME

plan

OBJECT

Click to expand plan

active

BOOLEAN

aggregate_usage

STRING

amount

INTEGER

amount_decimal

NUMBER

billing_scheme

STRING

created

DATE-TIME

currency

STRING

interval

STRING

interval_count

INTEGER

livemode

BOOLEAN

metadata

OBJECT

name

STRING

nickname

STRING

object

STRING

product

STRING

statement_description

STRING

statement_descriptor

STRING

tiers

ARRAY

Click to expand tiers

flat_amount

INTEGER

unit_amount

INTEGER

up_to

INTEGER

tiers_mode

STRING

transform_usage

OBJECT

trial_period_days

INTEGER

updated

DATE-TIME

updated_by_event_type

STRING

usage_type

STRING

price

OBJECT

Click to expand price

active

BOOLEAN

billing_scheme

STRING

created

DATE-TIME

currency

STRING

livemode

BOOLEAN

lookup_key

STRING

metadata

OBJECT

nickname

STRING

object

STRING

product

STRING

recurring

OBJECT

Click to expand recurring

aggregate_usage

STRING

interval

STRING

interval_count

INTEGER

usage_type

STRING

tax_behavior

STRING

tiers

ARRAY

Click to expand tiers

flat_amount

INTEGER

flat_amount_decimal

NUMBER

unit_amount

INTEGER

unit_amount_decimal

NUMBER

up_to

INTEGER

tiers_mode

STRING

transform_quantity

OBJECT

Click to expand transform_quantity

divide_by

INTEGER

round

STRING

type

STRING

unit_amount

INTEGER

unit_amount_decimal

NUMBER

proration

BOOLEAN

proration_details

OBJECT

quantity

INTEGER

subscription

STRING

subscription_item

STRING

tax_amounts

ARRAY

Click to expand tax_amounts

amount

INTEGER

inclusive

BOOLEAN

tax_rate

STRING

tax_rates

ARRAY

Click to expand tax_rates

active

BOOLEAN

country

STRING

created

DATE-TIME

description

STRING

display_name

STRING

inclusive

BOOLEAN

jurisdiction

STRING

livemode

BOOLEAN

metadata

OBJECT

object

STRING

percentage

NUMBER

state

STRING

tax_type

BOOLEAN

type

STRING

invoices

The invoices table contains info about invoices. Invoices are statements of amounts owed by customers, which can be one-off charges or generated periodically from a subscription.

Invoice line items

Full records for the line items associated with an invoice can be found in the invoice_line_items table. To replicate these records, you must set this table and the invoice_line_items table to replicate.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation invoices schema on GitHub Stripe API method

invoices table foreign keys

Join invoices with	on
charges	invoices.charge = charges.id invoices.customer = charges.customer invoices.discount.customer = charges.customer invoices.customer = charges.card.customer invoices.discount.customer = charges.card.customer invoices.id = charges.invoice
disputes	invoices.charge = disputes.charge
coupons	invoices.discount.coupon.id = coupons.id
customers	invoices.discount.coupon.id = customers.discount.coupon.id invoices.customer = customers.id invoices.discount.customer = customers.id invoices.customer = customers.cards.customer invoices.discount.customer = customers.cards.customer invoices.customer = customers.discount.customer invoices.discount.customer = customers.discount.customer invoices.subscription = customers.subscriptions invoices.discount.subscription = customers.subscriptions invoices.subscription = customers.discount.subscription invoices.discount.subscription = customers.discount.subscription
subscriptions	invoices.discount.coupon.id = subscriptions.discount.coupon.id invoices.customer = subscriptions.customer invoices.discount.customer = subscriptions.customer invoices.subscription = subscriptions.id invoices.discount.subscription = subscriptions.id
invoice_items	invoices.customer = invoice_items.customer invoices.discount.customer = invoice_items.customer invoices.id = invoice_items.invoice invoices.subscription = invoice_items.subscription invoices.discount.subscription = invoice_items.subscription
subscription_items	invoices.customer = subscription_items.customer invoices.discount.customer = subscription_items.customer invoices.subscription = subscription_items.subscription invoices.discount.subscription = subscription_items.subscription
invoice_line_items	invoices.id = invoice_line_items.invoice invoices.lines = invoice_line_items.id invoices.subscription = invoice_line_items.subscription invoices.discount.subscription = invoice_line_items.subscription

invoices table schema

account_country

STRING

account_name

STRING

account_tax_ids

ARRAY

amount_due

INTEGER

amount_paid

INTEGER

amount_remaining

INTEGER

application_fee

INTEGER

application_fee_amount

INTEGER

attempt_count

INTEGER

attempted

BOOLEAN

auto_advance

BOOLEAN

automatic_tax

OBJECT

Click to expand automatic_tax

enabled

BOOLEAN

status

STRING

billing

STRING

billing_reason

STRING

charge

STRING

closed

BOOLEAN

collection_method

STRING

created

DATE-TIME

currency

STRING

custom_fields

ARRAY

Click to expand custom_fields

name

STRING

value

STRING

customer

STRING

customer_address

OBJECT

Click to expand customer_address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

customer_email

STRING

customer_name

STRING

customer_phone

STRING

customer_shipping

OBJECT

Click to expand customer_shipping

address

OBJECT

Click to expand address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

name

STRING

phone

STRING

customer_tax_exempt

STRING

customer_tax_ids

ARRAY

Click to expand customer_tax_ids

type

STRING

value

STRING

date

DATE-TIME

default_payment_method

STRING

default_source

STRING

default_tax_rates

ARRAY

Click to expand default_tax_rates

active

BOOLEAN

country

STRING

created

DATE-TIME

description

STRING

display_name

STRING

inclusive

BOOLEAN

jurisdiction

STRING

livemode

BOOLEAN

metadata

OBJECT

object

STRING

percentage

NUMBER

state

STRING

description

STRING

discount

OBJECT

Click to expand discount

checkout_session

STRING

coupon

OBJECT

Click to expand coupon

amount_off

INTEGER

created

DATE-TIME

currency

STRING

duration

STRING

duration_in_months

INTEGER

STRING

livemode

BOOLEAN

max_redemptions

INTEGER

metadata

OBJECT

name

STRING

object

STRING

percent_off

NUMBER

percent_off_precise

NUMBER

redeem_by

DATE-TIME

times_redeemed

INTEGER

valid

BOOLEAN

customer

STRING

end

DATE-TIME

STRING

invoice

STRING

invoice_item

STRING

object

STRING

promotion_code

STRING

start

DATE-TIME

subscription

STRING

discounts

ARRAY

due_date

DATE-TIME

ending_balance

INTEGER

finalized_at

DATE-TIME

footer

STRING

forgiven

BOOLEAN

hosted_invoice_url

STRING

invoice_pdf

STRING

last_finalization_error

OBJECT

Click to expand last_finalization_error

code

STRING

doc_url

STRING

message

STRING

param

STRING

payment_method_type

STRING

type

STRING

lines

ARRAY, OBJECT

livemode

BOOLEAN

metadata

OBJECT

next_payment_attempt

DATE-TIME

number

STRING

object

STRING

on_behalf_of

STRING, OBJECT

paid

BOOLEAN

paid_out_of_band

BOOLEAN

payment

STRING

payment_intent

STRING

payment_settings

OBJECT

Click to expand payment_settings

payment_method_options

OBJECT

Click to expand payment_method_options

acss_debit

OBJECT

Click to expand acss_debit

mandate_options

OBJECT

Click to expand mandate_options

transaction_type

STRING

verification_method

STRING

bancontact

OBJECT

Click to expand bancontact

preferred_language

STRING

card

OBJECT

Click to expand card

request_three_d_secure

STRING

payment_method_types

ARRAY

period_end

DATE-TIME

period_start

DATE-TIME

post_payment_credit_notes_amount

INTEGER

pre_payment_credit_notes_amount

INTEGER

quote

OBJECT, STRING

receipt_number

STRING

starting_balance

INTEGER

statement_description

STRING

statement_descriptor

STRING

status

STRING

status_transitions

OBJECT

Click to expand status_transitions

finalized_at

DATE-TIME

marked_uncollectible_at

DATE-TIME

paid_at

DATE-TIME

voided_at

DATE-TIME

subscription

STRING

subscription_details

OBJECT

Click to expand subscription_details

metadata

STRING

subtotal

INTEGER

tax

INTEGER

tax_percent

NUMBER

total

INTEGER

total_discount_amounts

ARRAY

Click to expand total_discount_amounts

amount

INTEGER

discount

STRING

total_tax_amounts

ARRAY

Click to expand total_tax_amounts

amount

INTEGER

inclusive

BOOLEAN

tax_rate

STRING

transfer_data

OBJECT

Click to expand transfer_data

amount

INTEGER

destination

STRING

updated

DATE-TIME

updated_by_event_type

STRING

webhooks_delivered_at

DATE-TIME

payment_intents

This table contains information about payments, from creation through checkout, in your Stripe account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation payment_intents schema on GitHub Stripe API method

payment_intents table schema

amount

INTEGER

amount_capturable

INTEGER

amount_received

INTEGER

application

STRING

application_fee_amount

INTEGER

automatic_payment_methods

OBJECT

Click to expand automatic_payment_methods

enabled

BOOLEAN

canceled_at

DATE-TIME

cancellation_reason

STRING

capture_method

STRING

client_secret

STRING

confirmation_method

STRING

created

DATE-TIME

currency

STRING

customer

STRING

description

STRING

invoice

STRING

last_payment_error

OBJECT

Click to expand last_payment_error

charge

STRING

code

STRING

decline_code

STRING

doc_url

STRING

message

STRING

param

STRING

payment_method_type

STRING

type

STRING

latest_charge

STRING

livemode

BOOLEAN

metadata

OBJECT

next_action

OBJECT

Click to expand next_action

alipay_handle_redirect

OBJECT

Click to expand alipay_handle_redirect

native_data

STRING

native_url

STRING

return_url

STRING

url

STRING

boleto_display_details

OBJECT

Click to expand boleto_display_details

expires_at

DATE-TIME

hosted_voucher_url

STRING

number

STRING

pdf

STRING

oxxo_display_details

OBJECT

Click to expand oxxo_display_details

expires_after

DATE-TIME

hosted_voucher_url

STRING

number

STRING

redirect_to_url

OBJECT

Click to expand redirect_to_url

return_url

STRING

url

STRING

type

STRING

use_stripe_sdk

OBJECT

verify_with_microdeposits

OBJECT

Click to expand verify_with_microdeposits

arrival_date

DATE-TIME

hosted_verification_url

STRING

wechat_pay_display_qr_code

OBJECT

Click to expand wechat_pay_display_qr_code

data

STRING

image_data_url

STRING

image_url_png

STRING

image_url_svg

STRING

wechat_pay_redirect_to_android_app

OBJECT

Click to expand wechat_pay_redirect_to_android_app

app_id

STRING

nonce_str

STRING

package

STRING

partner_id

STRING

prepay_id

STRING

sign

STRING

timestamp

STRING

wechat_pay_redirect_to_ios_app

OBJECT

Click to expand wechat_pay_redirect_to_ios_app

native_url

STRING

object

STRING

on_behalf_of

STRING

payment_method

STRING

payment_method_options

OBJECT

Click to expand payment_method_options

acss_debit

OBJECT

Click to expand acss_debit

mandate_options

OBJECT

Click to expand mandate_options

custom_mandate_url

STRING

interval_description

STRING

payment_schedule

STRING

transaction_type

STRING

afterpay_clearpay

OBJECT

Click to expand afterpay_clearpay

reference

STRING

setup_future_usage

STRING

alipay

OBJECT

Click to expand alipay

setup_future_usage

STRING

au_becs_debit

OBJECT

Click to expand au_becs_debit

setup_future_usage

STRING

bacs_debit

OBJECT

Click to expand bacs_debit

setup_future_usage

STRING

bancontact

OBJECT

Click to expand bancontact

preferred_language

STRING

setup_future_usage

STRING

boleto

OBJECT

Click to expand boleto

expires_after_days

INTEGER

setup_future_usage

STRING

card

OBJECT

Click to expand card

installments

OBJECT

Click to expand installments

available_plans

ARRAY

Click to expand available_plans

count

INTEGER

interval

STRING

type

STRING

enabled

BOOLEAN

plan

OBJECT

Click to expand plan

count

INTEGER

interval

STRING

type

STRING

network

STRING

request_three_d_secure

STRING

setup_future_usage

STRING

card_present

OBJECT

eps

OBJECT

Click to expand eps

setup_future_usage

STRING

fps

OBJECT

Click to expand fps

setup_future_usage

STRING

giropay

OBJECT

Click to expand giropay

setup_future_usage

STRING

grabpay

OBJECT

Click to expand grabpay

setup_future_usage

STRING

ideal

OBJECT

Click to expand ideal

setup_future_usage

STRING

interac_present

OBJECT

klarna

OBJECT

Click to expand klarna

preferred_locale

STRING

setup_future_usage

STRING

oxxo

OBJECT

Click to expand oxxo

expires_after_days

INTEGER

setup_future_usage

STRING

p24

OBJECT

Click to expand p24

setup_future_usage

STRING

sepa_debit

OBJECT

Click to expand sepa_debit

mandate_options

OBJECT

setup_future_usage

STRING

sofort

OBJECT

Click to expand sofort

preferred_language

STRING

setup_future_usage

STRING

wechat_pay

OBJECT

Click to expand wechat_pay

app_id

STRING

client

STRING

setup_future_usage

STRING

payment_method_types

ARRAY

processing

OBJECT

receipt_email

STRING

review

STRING

setup_future_usage

STRING

shipping

OBJECT

Click to expand shipping

address

OBJECT

Click to expand address

city

STRING

country

STRING

line1

STRING

line2

STRING

postal_code

STRING

state

STRING

carrier

STRING

name

STRING

phone

STRING

tracking_number

STRING

source

STRING

statement_descriptor

STRING

statement_descriptor_suffix

STRING

status

STRING

transfer_data

OBJECT

Click to expand transfer_data

amount

INTEGER

destination

STRING

transfer_group

STRING

updated

DATE-TIME

updated_by_event_type

STRING

payout_transactions

This table contains info about payout transactions.

Replication Method

Full Table

Primary Key

Useful links

Stripe documentation

payout_transactions schema on GitHub

Stripe API method

payout_transactions table foreign keys

Join payout_transactions with	on
payouts	payout_transactions.payout_id = payouts.id

payout_transactions table schema

STRING

payout_id

STRING

payouts

The payouts table contains info about payouts, which occur when you receive funds from Stripe or initiate a payout to a bank account of the debit card of a connected Stripe account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation payouts schema on GitHub Stripe API method

payouts table foreign keys

Join payouts with	on
balance_transactions	payouts.balance_transaction = balance_transactions.id payouts.failure_balance_transaction = balance_transactions.id
charges	payouts.balance_transaction = charges.balance_transaction payouts.failure_balance_transaction = charges.balance_transaction
transfers	payouts.balance_transaction = transfers.balance_transaction payouts.failure_balance_transaction = transfers.balance_transaction payouts.balance_transaction = transfers.failure_balance_transaction payouts.failure_balance_transaction = transfers.failure_balance_transaction
disputes	payouts.balance_transaction = disputes.balance_transactions.id payouts.failure_balance_transaction = disputes.balance_transactions.id
payout_transactions	payouts.id = payout_transactions.payout_id

payouts table schema

amount

INTEGER

amount_reversed

INTEGER

arrival_date

DATE-TIME

automatic

BOOLEAN

balance_transaction

STRING

bank_account

OBJECT

Click to expand bank_account

account_holder_name

STRING

account_holder_type

STRING

bank_name

STRING

country

STRING

currency

STRING

fingerprint

STRING

last4

STRING

metadata

OBJECT

name

STRING

object

STRING

routing_number

STRING

status

STRING

created

DATE-TIME

currency

STRING

date

DATE-TIME

description

STRING

destination

STRING

failure_balance_transaction

STRING

failure_code

STRING

failure_message

STRING

livemode

BOOLEAN

metadata

OBJECT

method

STRING

object

STRING

original_payout

STRING

recipient

STRING

reversed_by

STRING

source_transaction

STRING

source_type

STRING

statement_description

STRING

statement_descriptor

STRING

status

STRING

transfer_group

STRING

type

STRING

updated

DATE-TIME

updated_by_event_type

STRING

plans

The plans table contains info about the plans in your Stripe account. A plan defines the base price, currency, and billing cycle for subscriptions.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation plans schema on GitHub Stripe API method

plans table foreign keys

Join plans with	on
invoice_items	plans.id = invoice_items.plan.id plans.product = invoice_items.plan.product
subscription_items	plans.id = subscription_items.plan.id plans.product = subscription_items.plan.product
subscriptions	plans.id = subscriptions.plan.id plans.product = subscriptions.plan.product
invoice_line_items	plans.product = invoice_line_items.plan.product
products	plans.product = products.id

plans table schema

active

BOOLEAN

aggregate_usage

STRING

amount

INTEGER

amount_decimal

NUMBER

billing_scheme

STRING

created

DATE-TIME

currency

STRING

interval

STRING

interval_count

INTEGER

livemode

BOOLEAN

metadata

OBJECT

name

STRING

nickname

STRING

object

STRING

product

STRING

statement_description

STRING

statement_descriptor

STRING

tiers

ARRAY

Click to expand tiers

flat_amount

INTEGER

unit_amount

INTEGER

up_to

INTEGER

tiers_mode

STRING

transform_usage

OBJECT

trial_period_days

INTEGER

updated

DATE-TIME

updated_by_event_type

STRING

usage_type

STRING

products

The products table contains info about the products in your Stripe account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation products schema on GitHub Stripe API method

products table foreign keys

Join products with	on
invoice_items	products.id = invoice_items.plan.product
invoice_line_items	products.id = invoice_line_items.plan.product
plans	products.id = plans.product
subscription_items	products.id = subscription_items.plan.product
subscriptions	products.id = subscriptions.plan.product

products table schema

active

BOOLEAN

attributes

ARRAY

caption

STRING

created

DATE-TIME

deactivate_on

ARRAY

description

STRING

images

ARRAY

livemode

BOOLEAN

metadata

OBJECT

name

STRING

object

STRING

package_dimensions

OBJECT

Click to expand package_dimensions

height

NUMBER

length

NUMBER

weight

NUMBER

width

NUMBER

shippable

BOOLEAN

statement_descriptor

STRING

tax_code

STRING

type

STRING

unit_label

STRING

updated

DATE-TIME

updated_by_event_type

STRING

url

STRING

subscription_items

The subscription_items table contains info about subscription items. In Stripe, subscription items are used to create customer subscriptions with more than one plan.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation subscription_items schema on GitHub Stripe API method

subscription_items table foreign keys

Join subscription_items with	on
charges	subscription_items.customer = charges.customer subscription_items.customer = charges.card.customer
customers	subscription_items.customer = customers.id subscription_items.customer = customers.cards.customer subscription_items.customer = customers.discount.customer subscription_items.subscription = customers.subscriptions subscription_items.subscription = customers.discount.subscription
invoice_items	subscription_items.customer = invoice_items.customer subscription_items.plan.id = invoice_items.plan.id subscription_items.plan.product = invoice_items.plan.product subscription_items.id = invoice_items.subscription_item subscription_items.subscription = invoice_items.subscription
invoices	subscription_items.customer = invoices.customer subscription_items.customer = invoices.discount.customer subscription_items.subscription = invoices.subscription subscription_items.subscription = invoices.discount.subscription
subscriptions	subscription_items.customer = subscriptions.customer subscription_items.plan.id = subscriptions.plan.id subscription_items.plan.product = subscriptions.plan.product subscription_items.id = subscriptions.items subscription_items.subscription = subscriptions.id
plans	subscription_items.plan.id = plans.id subscription_items.plan.product = plans.product
invoice_line_items	subscription_items.plan.product = invoice_line_items.plan.product subscription_items.subscription = invoice_line_items.subscription
products	subscription_items.plan.product = products.id

subscription_items table schema

application_fee_percent

NUMBER

billing_thresholds

OBJECT

Click to expand billing_thresholds

usage_gte

INTEGER

cancel_at_period_end

BOOLEAN

canceled_at

DATE-TIME

created

DATE-TIME

current_period_end

DATE-TIME

current_period_start

DATE-TIME

customer

STRING

discount

OBJECT

ended_at

DATE-TIME

STRING

livemode

BOOLEAN

metadata

OBJECT

object

STRING

plan

OBJECT

Click to expand plan

active

BOOLEAN

aggregate_usage

STRING

amount

INTEGER

amount_decimal

NUMBER

billing_scheme

STRING

created

DATE-TIME

currency

STRING

interval

STRING

interval_count

INTEGER

livemode

BOOLEAN

metadata

OBJECT

name

STRING

nickname

STRING

object

STRING

product

STRING

statement_description

STRING

statement_descriptor

STRING

tiers

ARRAY

Click to expand tiers

flat_amount

INTEGER

unit_amount

INTEGER

up_to

INTEGER

tiers_mode

STRING

transform_usage

OBJECT

trial_period_days

INTEGER

updated

DATE-TIME

updated_by_event_type

STRING

usage_type

STRING

price

OBJECT

Click to expand price

active

BOOLEAN

billing_scheme

STRING

created

DATE-TIME

currency

STRING

livemode

BOOLEAN

lookup_key

STRING

metadata

OBJECT

nickname

STRING

object

STRING

product

STRING

recurring

OBJECT

Click to expand recurring

aggregate_usage

STRING

interval

STRING

interval_count

INTEGER

usage_type

STRING

tax_behavior

STRING

tiers

ARRAY

Click to expand tiers

flat_amount

INTEGER

flat_amount_decimal

STRING

unit_amount

INTEGER

unit_amount_decimal

STRING

up_to

INTEGER

tiers_mode

STRING

transform_quantity

OBJECT

Click to expand transform_quantity

divide_by

INTEGER

round

STRING

type

STRING

unit_amount

INTEGER

unit_amount_decimal

STRING

quantity

INTEGER

start

DATE-TIME

status

STRING

subscription

STRING

tax_percent

NUMBER

tax_rates

ARRAY

Click to expand tax_rates

active

BOOLEAN

country

STRING

created

DATE-TIME

description

STRING

display_name

STRING

inclusive

BOOLEAN

jurisdiction

STRING

livemode

BOOLEAN

metadata

OBJECT

object

STRING

percentage

NUMBER

state

STRING

tax_type

BOOLEAN

trial_end

DATE-TIME

trial_start

DATE-TIME

subscriptions

The subscriptions table contains info about subscriptions, which allow you to charge a customer on a recurring basis. A subscription ties a customer to a particular plan.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation subscriptions schema on GitHub Stripe API method

subscriptions table foreign keys

Join subscriptions with	on
coupons	subscriptions.discount.coupon.id = coupons.id
customers	subscriptions.discount.coupon.id = customers.discount.coupon.id subscriptions.customer = customers.id subscriptions.customer = customers.cards.customer subscriptions.customer = customers.discount.customer subscriptions.id = customers.subscriptions subscriptions.id = customers.discount.subscription
invoices	subscriptions.discount.coupon.id = invoices.discount.coupon.id subscriptions.customer = invoices.customer subscriptions.customer = invoices.discount.customer subscriptions.id = invoices.subscription subscriptions.id = invoices.discount.subscription
charges	subscriptions.customer = charges.customer subscriptions.customer = charges.card.customer
invoice_items	subscriptions.customer = invoice_items.customer subscriptions.plan.id = invoice_items.plan.id subscriptions.plan.product = invoice_items.plan.product subscriptions.items = invoice_items.subscription_item subscriptions.id = invoice_items.subscription
subscription_items	subscriptions.customer = subscription_items.customer subscriptions.plan.id = subscription_items.plan.id subscriptions.plan.product = subscription_items.plan.product subscriptions.items = subscription_items.id subscriptions.id = subscription_items.subscription
plans	subscriptions.plan.id = plans.id subscriptions.plan.product = plans.product
invoice_line_items	subscriptions.plan.product = invoice_line_items.plan.product subscriptions.id = invoice_line_items.subscription
products	subscriptions.plan.product = products.id

subscriptions table schema

application_fee_percent

NUMBER

billing

STRING

billing_cycle_anchor

DATE-TIME

billing_thresholds

OBJECT

Click to expand billing_thresholds

amount_gte

INTEGER

reset_billing_cycle_anchor

BOOLEAN

cancel_at

DATE-TIME

cancel_at_period_end

BOOLEAN

canceled_at

DATE-TIME

collection_method

STRING

created

DATE-TIME

current_period_end

DATE-TIME

current_period_start

DATE-TIME

customer

STRING

days_until_due

INTEGER

default_payment_method

STRING

default_source

STRING

discount

OBJECT

Click to expand discount

checkout_session

STRING

coupon

OBJECT

Click to expand coupon

amount_off

INTEGER

created

DATE-TIME

currency

STRING

duration

STRING

duration_in_months

INTEGER

STRING

livemode

BOOLEAN

max_redemptions

INTEGER

metadata

OBJECT

name

STRING

object

STRING

percent_off

NUMBER

percent_off_precise

NUMBER

redeem_by

DATE-TIME

times_redeemed

INTEGER

valid

BOOLEAN

customer

STRING

end

DATE-TIME

STRING

invoice

STRING

invoice_item

STRING

object

STRING

promotion_code

STRING

start

DATE-TIME

subscription

STRING

ended_at

DATE-TIME

STRING

invoice_customer_balance_settings

OBJECT

Click to expand invoice_customer_balance_settings

consume_applied_balance_on_void

BOOLEAN

items

ARRAY

latest_invoice

STRING

livemode

BOOLEAN

metadata

OBJECT

next_pending_invoice_item_invoice

DATE-TIME

object

STRING

pause_collection

OBJECT

Click to expand pause_collection

behavior

STRING

resumes_at

DATE-TIME

pending_invoice_item_interval

OBJECT

Click to expand pending_invoice_item_interval

interval

STRING

interval_count

INTEGER

pending_setup_intent

STRING

plan

OBJECT

Click to expand plan

active

BOOLEAN

aggregate_usage

STRING

amount

INTEGER

billing_scheme

STRING

created

DATE-TIME

currency

STRING

interval

STRING

interval_count

INTEGER

livemode

BOOLEAN

metadata

OBJECT

name

STRING

nickname

STRING

object

STRING

product

STRING

statement_description

STRING

statement_descriptor

STRING

tiers

ARRAY

Click to expand tiers

flat_amount

INTEGER

unit_amount

INTEGER

up_to

INTEGER

tiers_mode

STRING

transform_usage

OBJECT

trial_period_days

INTEGER

usage_type

STRING

quantity

INTEGER

schedule

STRING

start

DATE-TIME

start_date

DATE-TIME

status

STRING

tax_percent

NUMBER

transfer_data

OBJECT

Click to expand transfer_data

amount_percent

NUMBER

destination

STRING

trial_end

DATE-TIME

trial_start

DATE-TIME

updated

DATE-TIME

updated_by_event_type

STRING

transfers

The transfers table contains info about transfers sent to connected accounts.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	created
Useful links	Stripe documentation transfers schema on GitHub Stripe API method

transfers table foreign keys

Join transfers with	on
balance_transactions	transfers.balance_transaction = balance_transactions.id transfers.failure_balance_transaction = balance_transactions.id
charges	transfers.balance_transaction = charges.balance_transaction transfers.failure_balance_transaction = charges.balance_transaction transfers.id = charges.source_transfer
payouts	transfers.balance_transaction = payouts.balance_transaction transfers.failure_balance_transaction = payouts.balance_transaction transfers.balance_transaction = payouts.failure_balance_transaction transfers.failure_balance_transaction = payouts.failure_balance_transaction
disputes	transfers.balance_transaction = disputes.balance_transactions.id transfers.failure_balance_transaction = disputes.balance_transactions.id

transfers table schema

amount

INTEGER

amount_reversed

INTEGER

arrival_date

DATE-TIME

automatic

BOOLEAN

balance_transaction

STRING

created

DATE-TIME

currency

STRING

date

DATE-TIME

description

STRING

destination

STRING

failure_balance_transaction

STRING

livemode

BOOLEAN

metadata

OBJECT

object

STRING

recipient

STRING

reversals

ARRAY

reversed

BOOLEAN

source_transaction

STRING

source_type

STRING

statement_description

STRING

statement_descriptor

STRING

transfer_group

STRING

updated

DATE-TIME

updated_by_event_type

STRING

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Third-Party Downtime Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues