Stripe (v27-02-2015)

stripe_balance_history & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

stripe_balance_history Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Balance History ID (id)

• amount

• available_on

• created

• currency

• description

• fee

• fee_details*

• net

• source__sourced_transfers__data*

• status

• type

Charge Dispute Support

Due to the current structure of our Stripe integration and how updates work in the Stripe API, records in this table will not be updated if a related dispute is updated.

You can, however, find this info in the stripe_events table.

stripe_charges Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Charge ID (id)

• received_at

• amount

• amount_refunded

• balance_transaction

• captured

• created

• currency

• customer_id

• description

• dispute_id

• failure_code

• failure_message

• fraud_details_stripe_report

• fraud_details_user_report

• invoice_id

• paid

• receipt_email

• receipt_number

• refunded

• statement_descriptor

• status

stripe_coupons Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Coupon ID (id)

• received_at

• created

• duration

• duration_in_months

• metadata__quota_calls

• metadata__quota_level

• metadata__service

• percent_off

• times_redeemed

• valid

stripe_customers & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

stripe_customers Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Customer ID (id)

• received_at

• account_balance

• created

• currency

• delinquent

• description

• discount_id

• email

• metadata__id

• metadata__extra

• metadata__name

• metadata__settings

• workspace

stripe_events & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Event Replication

The stripe_events table is sort of a “grab bag” of all events across all endpoints, or tables. For every event that takes place on a parent object, a row will be added to the table.

For example: If a customer account is updated, you’ll see the latest state of the customer’s account info in the stripe_customers table. You’ll also see a row in this table for the actual update event itself.

stripe_events Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Event ID (id)

• created

• data__object__business_url

• data__object__charges_enabled

• data__object__country

• data__object__default_currency

• data__object__default_source

• data__object__delinquent

• data__object__description

• data__object__details_submitted

• data__object__discount

• data__object__display_name

• data__object__email

• data__object__id

• data__object__managed

• data__object__object

• data__object__shipping

• data__object__sources__data*

• data__object__statement_descriptor

• data__object__subscriptions__data*

• data__object__support_phone

• data__object__timezone

• data__object__transfers_enabled

• livemode

• object

• pending_webhooks

• request

• type

stripe_invoice_items Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Invoice Item ID (id)

• received_at

• amount

• currency

• customer_id

• date

• description

• discountable

• invoice_id

• period_end

• period_start

• plan_id

• proration

• quantity

• bigint

• subscription_id

stripe_invoices & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Upcoming Invoices

Stitch’s Stripe integration doesn’t currently replicate upcoming invoices, which Stripe defines as “the next upcoming invoice.”

This is due to the way Stripe generates and assigns IDs to invoices. Existing invoices have IDs while upcoming invoices do not. As Stitch uses the id column to identify new data for replication, if an invoice doesn’t have an ID, Stitch will be unable to replicate it.

stripe_invoices Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Invoice ID (id)

• received_at

• amount_due

• attempt_count

• attempted

• charge_id

• closed

• currency

• customer_id

• date

• discount_id

• ending_balance

• forgiven

• lines*

• next_payment_attempt

• paid

• period_end

• period_start

• receipt_number

• starting_balance

• subscription_id

• subtotal

• total

• webhooks_delivered_at

stripe_plans Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Plan ID (id)

• received_at

• amount

• created

• currency

• interval

• interval_count

• metadata__available

• metadata__grandfathered

• metadata__overage_rows_fee

• metadata__overage_rows_per

• metadata__quota_calls

• metadata__quota_level

• metadata__quota_rows

• metadata__service

• metadata__tier

• name

• statement_descriptor

• trial_period_days

stripe_subscriptions Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Subscription ID (id)

• received_at

• cancel_at_period_end

• current_period_end

• current_period_start

• customer_id

• discount_id

• metadata__quota_calls

• metadata__quota_rows

• plan_id

• quantity

• start

• status

• trial_end

• trial_start

• canceled_at

stripe_transfers & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

stripe_transfers Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• Transfer ID (id)

• amount

• amount_reversed

• application_fee

• balance_transaction

• created

• currency

• date

• description

• destination

• destination_payment

• failure_code

• failure_message

• livemode

• medata__method

• metadata__recipient

• metadata__reversals*

• reversed

• source_transaction

• source_type

• statement_descriptor

• status

• type

stripe_transfer_transactions Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

• transfer_id

• transaction_id