Release Notes
December 2024
We have updated the Quickstart packages for the following connectors:
- Fivetran Log to version 1.10.0
- Greenhouse to version 0.8.0
- LinkedIn Ad Analytics to version 0.10.0
- Mailchimp to version 0.10.0
- Marketo to version 0.12.1
- Quickbooks to version 0.17.0
- Shopify to version 0.14.0
- Stripe to version 0.15.1
- Tiktok Ads to version 0.7.0
- Twilio to version 0.4.0
- Zendesk Support to version 0.19.1
We have also updated the Quickstart package for the Ad Reporting multi-connector data model to version 1.10.0.
We've added the COUPON_PRODUCT
table with two columns, coupon_id
and product_id
, to support mapping between the COUPON
and PRODUCT
tables.
The Stripe connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
October 2024
We have changed the primary keys of the following tables:
- For the
INVOICE_LINE_ITEM_TAX_RATE
table, the new composite is a combination of theinvoice_id
,invoice_line_item_id
, andtax_rate_id
columns. Previously, the primary key was a combination of theinvoice_id
andtax_rate_id
columns. - For the
CREDIT_NOTE_LINE_ITEM_TAX_RATE
table, the new composite is a combination of thecredit_note_id
,credit_note_line_item_id
, andtax_rate_id
columns. Previously, the primary key was a combination of thecredit_note_line_item_id
, andtax_rate_id
columns. - For the
UPCOMING_INVOICE_LINE_ITEM_TAX_RATE
table, the new composite is a combination of thesubscription_id
,tax_rate_id
, andupcoming_invoice_line_item_id
columns. Previously, the primary key was a combination of thesubscription_id
, andtax_rate_id
columns.
Stripe has deprecated the tax_info_*
column. As a result, we have removed it from the CUSTOMER
table and replaced it with a new CUSTOMER_TAX
table. For more information, see Stripe's documentation.
July 2024
We now capture data of the archived prices in the PRICE
table. Previously, we captured data only for the active prices in this table.
We have added the following new tables to support upcoming invoices:
UPCOMING_INVOICE
UPCOMING_INVOICE_ACCOUNT_TAX_ID
UPCOMING_INVOICE_CUSTOM_FIELD
UPCOMING_INVOICE_LINE_ITEM
UPCOMING_INVOICE_LINE_ITEM_PRORATION_DETAILS_CREDITED_ITEM
UPCOMING_INVOICE_LINE_ITEM_TAX_RATE
UPCOMING_INVOICE_TAX_RATE
We have added the following new tables to support Quote:
QUOTE
QUOTE_LINE_ITEM
QUOTE_COMPUTED_UPFRONT_LINE_ITEM
QUOTE_TAX_RATE
We have added a new table, TAX_AMOUNT
, to store data for all Stripe tax amount and categories.
We have added a new table, CREDIT_NOTE_LINE_ITEM_TAX_RATE
, to store the tax rate ID applied to the credit note line item.
We have added a new table, INVOICE_ACCOUNT_TAX_ID
, to store the account tax ID related to the invoice.
We have added a new table, INVOICE_LINE_ITEM_PRORATION_DETAILS_CREDITED_ITEMS
, to store details for the proration credited items.
We have added the following new columns to the CREDIT_NOTE
table:
amount_shipping
effective_at
out_of_band_amount
shipping_cost_amount_subtotal
shipping_cost_amount_tax
shipping_cost_amount_total
shipping_cost_shipping_rate
subtotal_excluding_tax
total_excluding_tax
We have added two new columns, amount_excluding_tax
and unit_amount_excluding_tax
, to the CREDIT_NOTE_LINE_ITEM
table.
We have added the following new columns to the INVOICE
table:
account_country
account_name
amount_shipping
application
automatic_tax_enabled
automatic_tax_status
effective_at
from_invoice_action
from_invoice_invoice
last_finalisation_error_*
latest_revision
on_behalf_of
paid_out_of_band
payment_setting_default_mandate
payment_setting_payment_method_options.*
payment_setting_payment_method_types
rendering_amount_tax_display
rendering_pdf_page_size
shipping_cost_amount_subtotal
shipping_cost_amount_tax
shipping_cost_amount_total
shipping_cost_shipping_rate
shipping_details_address_*
shipping_details_name
shipping_details_phone
subtotal_excluding_tax
test_clock
total_excluding_tax
We have added two new columns, amount_excluding_tax
and unit_amount_excluding_tax
to the INVOICE_LINE_ITEM
table.
We have added two new columns, test_clock
and unit_amount_decimal
, to the INVOICE_ITEM
table.
We have removed the following columns from the INVOICE
table:
billing
date
finalized_at
We now sync the data of these discontinued columns to other columns in the INVOICE
table. Use the following columns:
collection_method
forbilling
created
fordate
status_transitions_finalized_at
forfinalized_at
June 2024
We have changed the data type of the livemode
column in the TRANSFER
table from STRING to BOOLEAN.
To apply this change, you need to drop the livemode
column in your connector's schema. The next sync will update the datatype. If you need historical data for this column, a re-sync is required.
May 2024
We have added three new columns, cancellation_details_comment
, cancellation_details_feedback
, and cancellation_details_reason
to the SUBSCRIPTION_HISTORY
table. We will only sync new data from May 19, 2024 into these columns. We will not sync your historical data before May 19, 2024.
April 2024
We have removed the ORDER_HISTORY
table and its child tables, ORDER_ITEM
and SHIPPING_METHOD
because Stripe removed support for this endpoint. We are gradually rolling out this change to all existing connectors.
March 2024
We have changed the sync strategy for the PLAN
table. To capture new records and updates, we now re-import this table every time we perform a sync for the connector. Previously, we re-imported this table once a day.
December 2023
We now capture the price and product data in the CHECKOUT_SESSION_LINE_ITEM
table and upsert it in the PRICE
and PRODUCT
tables respectively. Previously, we ignored the price and product data present in the CHECKOUT_SESSION_LINE_ITEM
.
We have added a new table, DISCOUNT
, to store data for all Stripe discounts and discount categories.
We have now deprecated the following tables that previously stored values for Stripe discounts and discount categories:
CHECKOUT_SESSION_LINE_ITEM_DISCOUNT
CUSTOMER_DISCOUNT
INVOICE_DISCOUNT
SUBSCRIPTION_DISCOUNT
November 2023
Effective November 22, 2023, we have deprecated the ORDER
and SUBSCRIPTION
tables.
October 2023
We have added two new columns, flat_amount_decimal
and unit_amount_decimal
, to the TIER
table.
The Stripe connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Stripe's priority-first syncs fetch the most recent 30 days' worth of data from the supported tables.
We have rolled out this feature for all active connectors. If a connector is currently paused and if you unpause it within 2 months, the connector will start supporting priority-first sync as soon as you unpause it. However, if you unpause the connector after 2 months from now, we will consider it as a new connector and perform a historical sync on a priority-first basis. To learn more, see our priority-first sync documentation.
July 2023
Stripe's Balance Transaction API now fetches the balance transactions only for the payouts whose reconciliation_status
field has changed to completed
. To support this change, we have updated our sync strategy and now fetch the balance transactions when the reconciliation_status
of a payout changes to completed
. This change applies to both Stripe Standard and Connected accounts. You may observe sync delays for the payouts we sync using the /events
endpoint.
We have added a new table, INVOICE_CUSTOM_FIELD
. If you want to backfill the historical data for this table, you can re-sync the INVOICE
table or contact our support team to re-sync it for you.
June 2023
We have added the following fields to the CHECKOUT_SESSION_LINE_ITEM_DISCOUNT
table:
checkout_session
coupon_id
customer_id
end
invoice_id
invoice_item_id
promotion_code
start
subscription_id
We have added a new column, reconciliation_status
, to the PAYOUT
table.
Be sure to re-sync these tables for the latest changes or contact our support team to re-sync it for you.
April 2023
We have added a new table, INVOICE_LINE_ITEM_TAX_RATE
, to store the mappings of invoices and their associated invoice line items and tax rates. You can re-sync the INVOICE
table to backfill the INVOICE_LINE_ITEM_TAX_RATE
table for old invoices.
March 2023
We have changed our sync strategy to handle invalid or deleted connected accounts. We now display a warning on your connector dashboard when we detect invalid or deleted Stripe connected accounts and skip these accounts from the sync. Previously, we didn't skip these accounts, causing the connector to break.
February 2023
We now update the three_d_secure
column of the CARD
table in the destination as 'attempted' when we receive a JSON response. For more information about three_d_secure
fields, see Stripe's documentation.
You can backfill the data for the three_d_secure
columns in the CARD
and PAYMENT_METHOD_CARD
tables. Perform a re-sync for the CARD
and PAYMENT_METHOD_CARD
tables. This will result in re-syncing the associated parent and child tables.
January 2023
We now sync data from the CUSTOMER
endpoint to the PAYMENT_METHOD
table. Previously, we synced data only from the PAYMENT_INTENT
and SETUP_INTENT
endpoints, to the PAYMENT_METHOD
table. To sync records from the CUSTOMER
endpoint, we recommend that you re-sync the CUSTOMER
table.
October 2022
We have added a new column, collection_method
, to the INVOICE
and SUBSCRIPTION
(SUBSCRIPTION_HISTORY
for history mode connectors) tables. This column stores the same value as the billing
column. Stripe has deprecated the billing
column. We will continue to support both columns.
We have added the following new columns to the CARD
table:
iin
description
issuer
NOTE: These columns are not available in standard Stripe API requests. Contact Stripe support to enable them on your account.
September 2022
We have added the following new tables:
CHECKOUT_SESSION
CHECKOUT_SESSION_PAYMENT_METHOD
CHECKOUT_SESSION_TAX_RATE
CHECKOUT_SESSION_SHIPPING_OPTION
CHECKOUT_SESSION_SHIPPING_ADDRESS_ALLOWED_COUNTRIES
CHECKOUT_SESSION_LINE_ITEM
CHECKOUT_SESSION_LINE_ITEM_TAX_RATE
SHIPPING_RATE
August 2022
We have added a new column, invoice_item_id
, to the INVOICE_LINE_ITEM
table.
February 2022
We have added two new tables, ORDER_HISTORY
and SUBSCRIPTION_HISTORY
. We automatically sync these tables for connectors created after February 1, 2022.
January 2022
We have deprecated the following tables and no longer sync new data to them:
TAX_RATE_INVOICE_MAPPING
TAX_RATE_INVOICE_ITEM_MAPPING
TAX_RATE_SUBSCRIPTION_MAPPING
In May 2021, we renamed these tables but continued syncing to the old tables as well as to the new tables for existing connectors. Now, the data from these tables syncs only to the following renamed tables:
INVOICE_TAX_RATE
INVOICE_ITEM_TAX_RATE
SUBSCRIPTION_TAX_RATE
If your connector was created before May 3, 2021, be sure to update your queries.
If your connector was created after May 3, 2021, you don't need to do anything.
December 2021
We added a new column, reporting_category
, to the BALANCE_TRANSACTION
table.
We have added a new table, ISSUING_TRANSACTION
, that contains data from Stripe's /issuing/transactions endpoint.
November 2021
We have added a new column, invoice_item_id
, to the PRICE
table.
October 2021
We have added a new column, invoice_line_item
, to the CREDIT_NOTE_LINE_ITEM
table.
September 2021
We have added the following new fields to the CHARGE
table:
billing_detail_address_city
billing_detail_address_country
billing_detail_address_line1
billing_detail_address_line2
billing_detail_address_postal_code
billing_detail_address_state
billing_detail_email
billing_detail_name
billing_detail_phone
August 2021
We have added a new table, PROMOTION_CODE.
See Stripe's promotion code documentation for more details.
We have deprecated the metadata_*
columns from the Stripe schema.
We now support the PAYMENT_INTENT
table for Stripe Connect accounts. If you'd like to sync data from Stripe connected accounts, contact our support team.
The Stripe connector now supports table-level re-syncs.
We now support table grouping in the Schema tab of your connector details page.
The Stripe connector now supports history mode for the following tables:
ORDER
SUBSCRIPTION
SUBSCRIPTION_ITEM
We are gradually rolling out this improvement to all existing connectors.
July 2021
We have added two new columns, pause_collection_behavior
and pause_collection_resumes_at
, to the SUBSCRIPTION
table.
We have added the following new columns to the PAYMENT_METHOD_CARD
table:
three_d_secure_authentication_flow
three_d_secure_result
three_d_secure_result_reason
three_d_secure_version
We have added a new table, SETUP_ATTEMPT
. By default, we exclude the table from your syncs. On your Connector Details page, go to the Schema tab and select the table. For more information, see Stripe's SetupAttempts documentation.
We have deprecated the three_d_secure_usage_supported
column from the PAYMENT_METHOD_CARD
and CARD
tables.
May 2021
We now support the REFUND
and DISPUTE
tables for Stripe Connect accounts. If you'd like to sync data from Stripe connected accounts, contact our support team.
We have renamed the following tables:
TAX_RATE_INVOICE_MAPPING
toINVOICE_TAX_RATE
TAX_RATE_INVOICE_ITEM_MAPPING
toINVOICE_ITEM_TAX_RATE
TAX_RATE_SUBSCRIPTION_MAPPING
toSUBSCRIPTION_TAX_RATE
We will continue to sync the TAX_RATE_*_MAPPING
tables for existing connectors.
We have added a new column, price_id
, to the INVOICE_LINE_ITEM
table.
We have added two new columns, price_id
and plan_id
, to the INVOICE_ITEM
table.
We have added a new column, three_d_secure_usage_supported
, to the PAYMENT_METHOD_CARD
and CARD
tables.
April 2021
We have added a new table, TAX_RATE_INVOICE_MAPPING
, which stores the tax rates applied to an invoice.
We have added a new table, APPLE_PAY_DOMAIN
. By default, we exclude the table from your syncs. On your Connector Details page, go to the Schema tab and select the table.
We have added the following new columns to the INVOICE
table:
default_payment_method_id
payment_intent_id
post_payment_credit_notes_amount
pre_payment_credit_notes_amount
subscription_id
We have added the following new columns to the SUBSCRIPTION
table:
default_payment_method
latest_invoice_id
pending_setup_intent_id
We have added a new column, payment_method_types
, to the PAYMENT_INTENT
table.
We will discontinue the metadata_*
columns from the Stripe schema after August 1, 2021. Be sure to update your queries with the metadata
column. We sync metadata as JSON objects. For more information on the metadata
column, see our documentation.
March 2021
We have added the following new columns to the ACCOUNT
table:
capabilities_afterpay_clearpay_payments
capabilities_au_becs_debit_payments
capabilities_bacs_debit_payments
capabilities_bancontact_payments
capabilities_cartes_bancaires_payments
capabilities_eps_payments
capabilities_fpx_payments
capabilities_giropay_payments
capabilities_grabpay_payments
capabilities_ideal_payments
capabilities_jcb_payments
capabilities_oxxo_payments
capabilities_p24_payments
capabilities_sepa_debit_payments
capabilities_sofort_payments
capabilities_tax_reporting_us_1099_k
capabilities_tax_reporting_us_1099_misc
We have added the following new columns to the tables below:
payment_method_id
to theCHARGE
tablediscount_id
to theORDER_ITEM
andORDER_REFUND_ITEM
tablespayment_intent_id
to theREFUND
table
We have added two new columns, destination_payment_id
and source_transaction_id
, to the TRANSFER
table.
We will discontinue the destination_payment
and source_transaction
columns of the TRANSFER
table after June 20, 2021. Be sure to update your queries.
We have added the following new columns to the CARDHOLDER
table:
spending_controls_allowed_categories
spending_controls_blocked_categories
spending_controls_spending_limits
spending_controls_spending_limits_currency
We have added a new column, amount_details_atm_fee
, to the AUTHORIZATION
and TRANSACTION
tables.
We have added a new column, wallet_type
, to the CARD
table.
February 2021
We have added a new field, calculated_statement_descriptor
, to the CHARGE
table.
We have added the following new fields to the INVOICE
table:
status_transitions_finalized_at
status_transitions_marked_uncollectible_at
status_transitions_paid_at
status_transitions_voided_at
January 2021
We have added a new field, metadata
, to the SUBSCRIPTION_SCHEDULE
table.
December 2020
We now create empty tables in the destination even if the source tables are empty (contain only Null
values).
We have added a new table, CREDIT_NOTE_LINE_ITEM
. See Stripe's documentation on the credit note line item object for more information.
We have added a new table, PRICE
. See Stripe's documentation on prices for more information.
We have added the following new fields to the CREDIT_NOTE
table:
customer_balance_transaction
discount_amount
subtotal
total
voided_at
We now sync the metadata as JSON objects. We have added a new column, metadata
, to the following tables:
ACCOUNT
APPLICATIOIN_FEE_REFUND
AUTHORIZATION
BANK_ACCOUNT
CARD
CARDHOLDER
CHARGE
COUPON
CREDIT_NOTE
CUSTOMER
CUSTOMER_BALANCE_TRANSACTION
DISPUTE
FILE_LINK
INVOICE
INVOICE_ITEM
INVOICE_LINE_ITEM
ISSUING_CARD
ISSUING_DISPUTE
ORDER
PAYMENT_INTENT
PAYMENT_METHOD
PAYOUT
PLAN
PRODUCT
REFUND
SETUP_INTENT
SKU
SOURCE
SUBSCRIPTION
SUBSCRIPTION_ITEM
TAX_RATE
TOPUP
TRANSACTION
TRANSFER
TRANSFER_REVERSAL
November 2020
We have added the following new fields to the ACCOUNT
table:
requirements_current_deadline
requirements_currently_due
requirements_disabled_reason
requirements_errors
requirements_eventually_due
requirements_past_due
requirements_pending_verification
We now sync the BANK_ACCOUNT
and CARD
tables' records using the external_accounts
field of the ACCOUNT
table. See Stripe's documentation on external accounts for more information.
We have added a new table, CUSTOMER_DISCOUNT
, which stores information about customer discounts. See Stripe's documentation on discounts for more information.
We have removed the _fivetran_id
field from the INVOICE_DISCOUNT
and SUBSCRIPTION_DISCOUNT
tables.
September 2020
We have added the following new columns to the tables below:
is_deleted
andcapabilities_platform_payments
to theACCOUNT
tableverification_data_expiry_check
to theAUTHORIZATION
tablelivemode
to theORDER_RETURN
tableid
to theSUBSCRIPTION_DISCOUNT
table
We now support metadata_*
columns in the AUTHORIZATION
table.
August 2020
We have released pre-built, dbt Core-compatible data models for Stripe. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
We have added three new tables:
TAX_RATE
stores the tax rates that can be applied to either a subscription or an invoice item.TAX_RATE_SUBSCRIPTION_MAPPING
stores the tax rates applied to a subscription.TAX_RATE_INVOICE_ITEM_MAPPING
stores the tax rates applied to an invoice item.
We have renamed the following fields in the AUTHORIZATION
table:
authorized_amount
toamount
authorized_currency
tocurrency
We have moved the following fields from the TRANSACTION
table to the AUTHORIZATION
table:
merchant_data_network_id
merchant_data_postal_code
merchant_data_state
merchant_data_category
merchant_data_city
merchant_data_name
merchant_data_country
We have added the following columns to the ISSUING_CARD
table:
cancellation_reason
number
replaced_by
replacement_for
replacement_reason
shipping_eta
shipping_service
shipping_status
shipping_tracking_url
shipping_type
We have removed the following columns from the ISSUING_CARD
table:
authorization_controls_currency
authorization_controls_max_amount
authorization_controls_max_approvals
shipping_phone
We have removed the is_deleted
column from the PAYMENT_METHOD
table.
We have removed the client_secret
column from the SETUP_INTENT
table.
July 2020
We now capture deletes for the INVOICE
, INVOICE_ITEM
, and PERSON
tables. Deletes from these tables are captured in the is_deleted
column.
You can now select the PAYMENT_METHOD
and CUSTOMER_BALANCE_TRANSACTION
tables to sync from the Schema tab on your connector details page.
We have added a new column, is_deleted
, to the PERSON
table.
We have added a new table, SETUP_INTENT
. Read Stripe's documentation for more information.
June 2020
We can now enable support for your Stripe Connected Accounts on your connector. Contact our Support team to enable this feature on your connector.
We have added a new table, USAGE_RECORD
. This table stores the usage records of a subscription.
May 2020
We have added the following columns to the CUSTOMER
table:
address_*
balance
name
phone
April 2020
You can now select the tables you want to sync from the Schema tab on your connector details page.
March 2020
We have added a new field, tax_exempt
, to the CUSTOMER
table.
We have added a new table, PAYMENT_METHOD
, which stores customer payment method details. We have also added the following child tables to support the various payment types:
AU_BECS_DEBIT
stores details about the AU_BECS_DEBIT payment method.FPX
stores details about the FPX payment method.IDEAL
stores details about the IDEAL payment method.PAYMENT_METHOD_CARD
stores details about the CARD payment method.SEPA_DEBIT
stores details about the SEPA_DEBIT payment method.
We have updated the ACCOUNT
table to support the latest Stripe API version. We have deprecated the following fields from the ACCOUNT
table:
business_name
business_url
debit_negative_balances
decline_charge_on_avs_failure
decline_charge_on_cvc_failure
display_name
legal_entity
payout_schedule_delay_days
payout_schedule_interval
payout_schedule_monthly_anchor
payout_schedule_weekly_anchor
payout_statement_descriptor
product_description
statement_descriptor
support_address
support_email
support_phone
timezone
verification
See the Stripe ERD to learn more about the fields we support in the ACCOUNT
table.
February 2020
You can now configure your Stripe connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
We have added a new field, start_date
, to the SUBSCRIPTION
table. This field stores the actual subscription start date, while the start
field in the same table stores the last modified date of the subscription.
We have added a new table, SUBSCRIPTION_SCHEDULE
, which stores the historical change data of a subscription.
We have added a new table, PHASE
, which stores the details about phases in the subscription schedule life cycle.
We have added a new table, PHASE_PLAN
, which stores the subscription plan details during a specific phase.
We have added the following fields to the BALANCE_TRANSACTION
table:
payout_id
. This field stores the automatic payout ID in which the balance transaction was paid out.exchange_rate
. This field stores the exchange rate used for a transaction.
January 2020
We have added a new column, unique_id
, to the INVOICE_LINE_ITEM
table. This fix resolves the pagination break issue for invoice line items, which was introduced by the Stripe API update.
December 2019
We have added a new table, EARLY_FRAUD_WARNING
, which contains the following fields:
id
charge_id
actionable
created
fraud_type
livemode
November 2019
We have added a new column, network
, to the CARD
table.
October 2019
For version 2 of the Stripe connector, we have added a new column, invoice_id
, to the CHARGE
table to support mapping between the CHARGE
and INVOICE
tables.
September 2019
We have added a new column, customer_id
, to the INVOICE_ITEM
table.
August 2019
We have made the subscription_id
column a primary key.
The SUBSCRIPTION_ITEM
table now holds only existing subscription items. We will delete subscription items which are not related to any subscription. For example, when a subscription item is removed from a subscription, it does not belong to any subscription, so we delete that subscription item from the table.
July 2019
We have deprecated the OAuth 2.0 authentication mechanism for creating a new connector. Going forward, you need to use the restricted API key to create a new connector. We will continue to run existing connectors set up using the OAuth 2.0 mechanism. We encourage you to move to the new authentication for greater security.
April 2019
We have added a new table, CREDIT_NOTE
with the following columns:
id
amount
created
currency
customer
invoice_id
livemode
memo
number
pdf
reason
refund_id
status
type
March 2019
We have released a new version of the Stripe connector, version 1. The new version contains changed, added, and deprecated tables. In the existing tables, we have added new fields and removed the deprecated ones. See the schema for details.
Added Tables
ATTRIBUTE
AUTHORIZATION
CARDHOLDER
DISPUTE_BALANCE_TRANSACTION
FILE
INVOICE_DISCOUNT
ISSUING_CARD
ISSUING_DISPUTE
PAYMENT_INTENT
PAYOUT
PRODUCT
SHIPPING_METHOD
SUBSCRIPTION_DISCOUNT
SUBSCRIPTION_ITEM
TIER
TRANSACTION
TRANSFER_REVERSAL
Renamed Tables
_ACCOUNT
toACCOUNT
_APPLICATION_FEES
toAPPLICATION_FEE
_APPLICATION_FEE_REFUNDS
toAPPLICATION_FEE_REFUND
_BALANCE_TRANSACTIONS
toBALANCE_TRANSACTION
_BANK_ACCOUNTS
toBANK_ACCOUNT
_CARDS
toCARD
_CHARGES
toCHARGE
_COUPONS
toCOUPON
_CUSTOMERS
toCUSTOMER
_DISPUTES
toDISPUTE
_FEES
toFEE
_INVOICES
toINVOICE
_INVOICE_ITEMS
toINVOICE_ITEM
_ORDER
toORDER
_ORDER_ITEM
toORDER_ITEM
_ORDER_RETURNED
toORDER_RETURN
_ORDER_RETURNED_ITEM
toORDER_RETURNED_ITEM
_PLANS
toPLAN
_REFUNDS
toREFUND
_REVIEWS
toREVIEW
_SKU
toSKU
_SOURCE
toSOURCE
_SUBSCRIPTIONS
toSUBSCRIPTION
_TOPUP
toTOPUP
_TRANSFERS
toTRANSFER
Deprecated Tables
_RECIPIENTS
_SUBSCRIPTION_PLAN
The sunset date for version 0 is June 15, 2019. Connect to the new Stripe v1 connector.
January 2019
We have added a new column, outcome_risk_score
, to the CHARGES
table.
December 2018
The Stripe connector now supports top-up objects. This data appears in the TOPUP
table.
May 2018
We have added a new table, FILE_UPLOAD
.
We have added the following new columns to the tables below:
TABLE NAME | NEW COLUMN NAME |
---|---|
CHARGE | status |
INVOICES | amount_paid |
PLANS | nickname |