# Stripe

Stripe is a suite of APIs+ powering online payment processing and commerce solutions. You can use Stripe as a data source when landing or replicating data.

It replicates data using the [Stripe REST API](https://stripe.com/Content/api).

See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#Schema) section for a list of objects available for replication.

## Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Information noteMake sure that the account you use has read access to the tables you want to fetch.

To generate your client ID:

1. Log into [Stripe](https://dashboard.stripe.com/).
2. In the top right, click the gear wheel and select Settings.
3. Click Connect.
4. Click Onboarding options.
5. Click the OAuth tab to generate your client ID.

To generate your secret key:

1. Click the Developers button in the bottom left corner of the screen.
2. Select the API Keys tab.
3. Click Reveal live key to reveal your secret key.

To redirect the URI:

1. Visit the OAuth page, where you got your Client ID.
2. Make sure Authorized Redirect URIs is set to https://connector.qlik.com/auth/oauth/v3.htm.

## Creating the connection

For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm).

1. Click Authenticate when you have filled in the required connection settings.

   You may be asked to log in to the source application.

   A window is displayed with an authentication code.

2. Copy the code to the clipboard and return to the connection dialog.

3. Paste the code in Complete authentication with the code provided by the source and click Verify.

   Tip noteYou may need to scroll down to see this field.

   When status is Verified, the authentication is verified.

4. Provide a name for the connection in Connection name.

5. Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings

| Setting | Description |
| --- | --- |
| Data gateway | Select a Data Movement gateway if required by your use case.<br><br>Information note<br><br>This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.<br><br>For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). |
| Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. |
| Client ID | Client ID. |
| Secret Key | Secret Key. |

## Schema

Information note

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

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

### balance\_transactions

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

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/balance/balance_transaction)<br><br>[Stripe API method](https://stripe.com/Content/api/balance/balance_history "Opens in new tab: Stripe API method") |

balance\_transactions table foreign keys

| Join balance\_transactions with | on |
| --- | --- |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>balance_transactions.id = charges.balance_transaction<br>``` |
| [payouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#payouts) | ```<br>balance_transactions.id = payouts.balance_transaction<br>```<br><br>```<br>balance_transactions.id = payouts.failure_balance_transaction<br>``` |
| [transfers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#transfers) | ```<br>balance_transactions.id = transfers.balance_transaction<br>```<br><br>```<br>balance_transactions.id = transfers.failure_balance_transaction<br>``` |
| [disputes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#disputes) | ```<br>balance_transactions.id = disputes.balance_transactions.id<br>``` |

balance\_transactions table schema

| **amount**<br><br><br>INTEGER |
| --- |
| **available\_on**<br><br><br>INTEGER |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **description**<br><br><br>STRING |
| **exchange\_rate**<br><br><br>NUMBER |
| **fee**<br><br><br>INTEGER |
| **fee\_details**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>application: STRING</li><li>currency: STRING</li><li>description: STRING</li><li>type: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **net**<br><br><br>INTEGER |
| **object**<br><br><br>STRING |
| **source**<br><br><br>STRING |
| **sourced\_transfers**<br><br><br>ARRAY |
| **status**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **updated**<br><br><br>DATE-TIME |

### charges

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

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/charges/object)<br><br>[Stripe API method](https://stripe.com/Content/api/charges/list "Opens in new tab: Stripe API method") |

charges table foreign keys

| Join charges with | on |
| --- | --- |
| [balance_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#balance-transactions) | ```<br>charges.balance_transaction = balance_transactions.id<br>``` |
| [payouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#payouts) | ```<br>charges.balance_transaction = payouts.balance_transaction<br>```<br><br>```<br>charges.balance_transaction = payouts.failure_balance_transaction<br>``` |
| [transfers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#transfers) | ```<br>charges.balance_transaction = transfers.balance_transaction<br>```<br><br>```<br>charges.balance_transaction = transfers.failure_balance_transaction<br>```<br><br>```<br>charges.source_transfer = transfers.id<br>``` |
| [disputes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#disputes) | ```<br>charges.balance_transaction = disputes.balance_transactions.id<br>```<br><br>```<br>charges.id = disputes.charge<br>``` |
| [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#customers) | ```<br>charges.card.id = customers.cards.id<br>```<br><br>```<br>charges.source.id = customers.cards.id<br>```<br><br>```<br>charges.customer = customers.id<br>```<br><br>```<br>charges.card.customer = customers.id<br>```<br><br>```<br>charges.customer = customers.cards.customer<br>```<br><br>```<br>charges.card.customer = customers.cards.customer<br>```<br><br>```<br>charges.customer = customers.discount.customer<br>```<br><br>```<br>charges.card.customer = customers.discount.customer<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoices) | ```<br>charges.id = invoices.charge<br>```<br><br>```<br>charges.customer = invoices.customer<br>```<br><br>```<br>charges.card.customer = invoices.customer<br>```<br><br>```<br>charges.customer = invoices.discount.customer<br>```<br><br>```<br>charges.card.customer = invoices.discount.customer<br>```<br><br>```<br>charges.invoice = invoices.id<br>``` |
| [invoice_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-items) | ```<br>charges.customer = invoice_items.customer<br>```<br><br>```<br>charges.card.customer = invoice_items.customer<br>```<br><br>```<br>charges.invoice = invoice_items.invoice<br>``` |
| [subscription_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscription-items) | ```<br>charges.customer = subscription_items.customer<br>```<br><br>```<br>charges.card.customer = subscription_items.customer<br>``` |
| [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscriptions) | ```<br>charges.customer = subscriptions.customer<br>```<br><br>```<br>charges.card.customer = subscriptions.customer<br>``` |
| [invoice_line_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-line-items) | ```<br>charges.invoice = invoice_line_items.invoice<br>``` |

charges table schema

| **amount**<br><br><br>INTEGER |
| --- |
| **amount\_captured**<br><br><br>INTEGER |
| **amount\_refunded**<br><br><br>INTEGER |
| **application**<br><br><br>STRING |
| **application\_fee**<br><br><br>STRING |
| **application\_fee\_amount**<br><br><br>INTEGER |
| **balance\_transaction**<br><br><br>STRING |
| **billing\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>address: OBJECT, which is also a nested data structure.											<ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul></li><li>email: STRING</li><li>name: STRING</li><li>phone: STRING</li></ul> |
| **calculated\_statement\_descriptor**<br><br><br>STRING |
| **captured**<br><br><br>BOOLEAN |
| **card**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>address_city: STRING</li><li>address_country: STRING</li><li>address_line1: STRING</li><li>address_line1_check: STRING</li><li>address_line2: STRING</li><li>address_state: STRING</li><li>address_zip: STRING</li><li>address_zip_check: STRING</li><li>brand: STRING</li><li>country: STRING</li><li>customer: STRING</li><li>cvc_check: STRING</li><li>dynamic_last4: STRING</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint</li><li>funding: STRING</li><li>id: STRING</li><li>last4: STRING</li><li>metadata: OBJECT</li><li>name: STRING</li><li>object: STRING</li><li>tokenization_method: STRING</li><li>type: STRING</li></ul> |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **customer**<br><br><br>STRING |
| **description**<br><br><br>STRING |
| **destination**<br><br><br>STRING |
| **dispute**<br><br><br>STRING |
| **disputed**<br><br><br>BOOLEAN |
| **failure\_code**<br><br><br>STRING |
| **failure\_message**<br><br><br>STRING |
| **fraud\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>stripe_report: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **invoice**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **object**<br><br><br>STRING |
| **on\_behalf\_of**<br><br><br>STRING |
| **order**<br><br><br>STRING |
| **outcome**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>network_status: STRING</li><li>reason: STRING</li><li>risk_level: STRING</li><li>risk_score: INTEGER</li><li>seller_message: STRING</li><li>type: STRING</li></ul> |
| **paid**<br><br><br>BOOLEAN |
| **payment\_intent**<br><br><br>STRING |
| **payment\_method**<br><br><br>STRING |
| **payment\_method\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>ach_credit_transfer: OBJECT, which is also a nested data structure.											<ul><li>account_number: STRING</li><li>bank_name: STRING</li><li>routing_number: STRING</li><li>swift_code: STRING</li></ul></li><li>ach_debit: OBJECT, which is also a nested data structure.											<ul><li>account_holder_type: STRING</li><li>bank_name: STRING</li><li>country: STRING</li><li>fingerprint: STRING</li><li>last4: STRING</li><li>routing_number: STRING</li></ul></li><li>alipay: OBJECT</li><li>bancontact: OBJECT, which is also a nested data structure.											<ul><li>bank_code: STRING</li><li>bank_name: STRING</li><li>bic: STRING</li><li>iban_last4: STRING</li><li>preferred_language: STRING</li><li>verified_name: STRING</li></ul></li><li>card: OBJECT, which is also a nested data structure.											<ul><li>address_city: STRING</li><li>address_country: STRING</li><li>address_line1: STRING</li><li>address_line1_check: STRING</li><li>address_line2: STRING</li><li>address_state: STRING</li><li>address_zip: STRING</li><li>address_zip_check: STRING</li><li>brand: STRING</li><li>card_present: OBJECT, which is also a nested data structure.													<ul><li>brand: STRING</li><li>country: STRING</li><li>emv_auth_data: STRING</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>funding: STRING</li><li>generated_card: STRING</li><li>last4: STRING</li><li>network: STRING</li><li>read_method: STRING</li><li>receipt: OBJECT, which is also a nested data structure.															<ul><li>application_cryptogram: STRING</li><li>application_preferred_name: STRING</li><li>authorization_code: STRING</li><li>authorization_response_code: STRING</li><li>cardholder_verification_method: STRING</li><li>dedicated_file_name: STRING</li><li>terminal_verification_results: STRING</li><li>transaction_status_information: STRING</li></ul></li></ul></li><li>checks: OBJECT, which is also a nested data structure.													<ul><li>address_line1_check: STRING</li><li>address_postal_code_check: STRING</li><li>cvc_check: STRING</li></ul></li><li>country: STRING</li><li>customer: STRING</li><li>cvc_check: STRING</li><li>dynamic_last4: STRING</li><li>eps: OBJECT, which is also a nested data structure.													<ul><li>verified_name: STRING</li></ul></li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>funding: STRING</li><li>giropay: OBJECT, which is also a nested data structure.													<ul><li>bank_code: STRING</li><li>bank_name: STRING</li><li>bic: STRING</li><li>verified_name: STRING</li></ul></li><li>id: STRING</li><li>ideal: OBJECT, which is also a nested data structure.													<ul><li>bank: STRING</li><li>bic: STRING</li><li>iban_last4: STRING</li><li>verified_name: STRING</li></ul></li><li>installments: OBJECT, which is also a nested data structure.													<ul><li>plan: OBJECT, which is also a nested data structure.															<ul><li>count: INTEGER</li><li>interval: STRING</li><li>type: STRING</li></ul></li></ul></li><li>klarna: OBJECT</li><li>last4: STRING</li><li>metadata: OBJECT</li><li>multibanco: OBJECT, which is also a nested data structure.													<ul><li>entity: STRING</li><li>reference: STRING</li></ul></li><li>name: STRING</li><li>network: STRING</li><li>object: STRING</li><li>p24: OBJECT, which is also a nested data structure.													<ul><li>reference: STRING</li><li>verified_name: STRING</li></ul></li><li>sepa_debit: OBJECT, which is also a nested data structure.													<ul><li>bank_code: STRING</li><li>branch_code: STRING</li><li>country: STRING</li><li>fingerprint: STRING</li><li>last4: STRING</li><li>mandate: STRING</li></ul></li><li>sofort: OBJECT, which is also a nested data structure.													<ul><li>bank_code: STRING</li><li>bank_name: STRING</li><li>bic: STRING</li><li>country: STRING</li><li>iban_last4: STRING</li><li>verified_name: STRING</li></ul></li><li>stripe_account: OBJECT</li><li>three_d_secure: OBJECT, which is also a nested data structure.													<ul><li>authenticated: BOOLEAN</li><li>succeeded: BOOLEAN</li><li>version: STRING</li></ul></li><li>tokenization_method: STRING</li><li>type: STRING</li><li>wallet: OBJECT, which is also a nested data structure.													<ul><li>amex_express_checkout: OBJECT</li><li>apple_pay: OBJECT</li><li>dynamic_last4: STRING</li><li>google_pay: OBJECT</li><li>masterpass: OBJECT, which is also a nested data structure.															<ul><li>billing_address: OBJECT, which is also a nested data structure.																	<ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul></li><li>email: STRING</li><li>name: STRING</li><li>shipping_address: OBJECT, which is also a nested data structure.																	<ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul></li></ul></li><li>samsung_pay: OBJECT</li><li>type: STRING</li><li>visa_checkout: OBJECT, which is also a nested data structure.															<ul><li>billing_address: OBJECT, which is also a nested data structure.																	<ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul></li><li>email: STRING</li><li>name: STRING</li><li>shipping_address: OBJECT, which is also a nested data structure.																	<ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul></li></ul></li></ul></li><li>wechat: OBJECT</li></ul></li><li>card_present: OBJECT, which is also a nested data structure.											<ul><li>amount_authorized: INTEGER</li><li>brand: STRING</li><li>cardholder_name: STRING</li><li>country: STRING</li><li>emv_auth_data: STRING</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>funding: STRING</li><li>generated_card: STRING</li><li>last4: STRING</li><li>network: STRING</li><li>overcapture_supported: BOOLEAN</li><li>read_method: STRING</li><li>receipt: OBJECT, which is also a nested data structure.													<ul><li>account_type: STRING</li><li>application_cryptogram: STRING</li><li>application_preferred_name: STRING</li><li>authorization_code: STRING</li><li>authorization_response_code: STRING</li><li>cardholder_verification_method: STRING</li><li>dedicated_file_name: STRING</li><li>terminal_verification_results: STRING</li><li>transaction_status_information: STRING</li></ul></li></ul></li><li>type: STRING</li></ul> |
| **receipt\_email**<br><br><br>STRING |
| **receipt\_number**<br><br><br>STRING |
| **receipt\_url**<br><br><br>STRING |
| **refunded**<br><br><br>BOOLEAN |
| **refunds**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>balance_transaction: STRING</li><li>charge: STRING</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>description: STRING</li><li>failure_reason: STRING</li><li>id: STRING</li><li>instructions_email: STRING</li><li>metadata: OBJECT</li><li>next_action: OBJECT, which is also a nested data structure.											<ul><li>display_details: OBJECT, which is also a nested data structure.													<ul><li>email_sent: OBJECT, which is also a nested data structure.															<ul><li>email_sent_at: DATE-TIME</li><li>email_sent_to: STRING</li></ul></li><li>expires_at: DATE-TIME</li></ul></li><li>type: STRING</li></ul></li><li>object: STRING</li><li>payment_intent: STRING</li><li>reason: STRING</li><li>receipt_number: STRING</li><li>source_transfer_reversal: STRING</li><li>status: STRING</li><li>transfer_reversal: STRING</li></ul> |
| **review**<br><br><br>STRING |
| **shipping**<br><br><br>OBJECT |
| **source**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>ach_credit_transfer: OBJECT, which is also a nested data structure.											<ul><li>account_number: STRING</li><li>bank_name: STRING</li><li>fingerprint: STRING</li><li>refund_account_holder_name: STRING</li><li>refund_account_holder_type: STRING</li><li>refund_account_number: STRING</li><li>refund_routing_number: STRING</li><li>routing_number: STRING</li><li>swift_code: STRING</li></ul></li><li>address_city: STRING</li><li>address_country: STRING</li><li>address_line1: STRING</li><li>address_line1_check: STRING</li><li>address_line2: STRING</li><li>address_state: STRING</li><li>address_zip: STRING</li><li>address_zip_check: STRING</li><li>alipay: OBJECT</li><li>amount: INTEGER</li><li>bancontact: OBJECT</li><li>brand: STRING</li><li>card: OBJECT, which is also a nested data structure.											<ul><li>address_line1_check: STRING</li><li>address_zip_check: STRING</li><li>brand: STRING</li><li>country: STRING</li><li>cvc_check: STRING</li><li>dynamic_last4: STRING</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>funding: STRING</li><li>last4: STRING</li><li>name: STRING</li><li>three_d_secure: STRING</li><li>tokenization_method: STRING</li><li>type: STRING</li></ul></li><li>client_secret: STRING</li><li>country: STRING</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>customer: STRING</li><li>cvc_check: STRING</li><li>dynamic_last4: STRING</li><li>eps: OBJECT</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>flow: STRING</li><li>funding: STRING</li><li>id: STRING</li><li>ideal: OBJECT</li><li>last4: STRING</li><li>livemode: BOOLEAN</li><li>metadata: OBJECT</li><li>multibanco: OBJECT</li><li>name: STRING</li><li>object: STRING</li><li>owner: OBJECT, which is also a nested data structure.											<ul><li>address: OBJECT, which is also a nested data structure.</li><li>email: STRING</li><li>name: STRING</li><li>phone: STRING</li><li>verified_address: STRING</li><li>verified_email: STRING</li><li>verified_name: STRING</li><li>verified_phone: STRING</li></ul></li><li>receiver: OBJECT, which is also a nested data structure.											<ul><li>address: STRING</li><li>amount_charged: INTEGER</li><li>amount_received: INTEGER</li><li>amount_returned: INTEGER</li><li>refund_attributes_method: STRING</li><li>refund_attributes_status: STRING</li></ul></li><li>redirect: OBJECT, which is also a nested data structure.											<ul><li>failure_reason: STRING</li><li>return_url: STRING</li><li>status: STRING</li><li>url: STRING</li></ul></li><li>statement_descriptor: STRING</li><li>status: STRING</li><li>tokenization_method: STRING</li><li>type: STRING</li><li>usage: STRING</li></ul> |
| **source\_transfer**<br><br><br>STRING |
| **statement\_description**<br><br><br>STRING |
| **statement\_descriptor**<br><br><br>STRING |
| **statement\_descriptor\_suffix**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **transfer\_data**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>destination: STRING</li></ul> |
| **transfer\_group**<br><br><br>STRING |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>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** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/coupons)<br><br>[Stripe API method](https://stripe.com/Content/api/coupons/list "Opens in new tab: Stripe API method") |

coupons table foreign keys

| Join coupons with | on |
| --- | --- |
| [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#customers) | ```<br>coupons.id = customers.discount.coupon.id<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoices) | ```<br>coupons.id = invoices.discount.coupon.id<br>``` |
| [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscriptions) | ```<br>coupons.id = subscriptions.discount.coupon.id<br>``` |

coupons table schema

| **amount\_off**<br><br><br>INTEGER |
| --- |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **duration**<br><br><br>STRING |
| **duration\_in\_months**<br><br><br>INTEGER |
| **id**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **max\_redemptions**<br><br><br>INTEGER |
| **metadata**<br><br><br>OBJECT |
| **name**<br><br><br>STRING |
| **object**<br><br><br>STRING |
| **percent\_off**<br><br><br>NUMBER |
| **percent\_off\_precise**<br><br><br>NUMBER |
| **redeem\_by**<br><br><br>DATE-TIME |
| **times\_redeemed**<br><br><br>INTEGER |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>STRING |
| **valid**<br><br><br>BOOLEAN |

### customers

The `customers` table contains info about your customers.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/customers/object)<br><br>[Stripe API method](https://stripe.com/Content/api/customers/list "Opens in new tab: Stripe API method") |

customers table foreign keys

| Join customers with | on |
| --- | --- |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>customers.cards.id = charges.card.id<br>```<br><br>```<br>customers.cards.id = charges.source.id<br>```<br><br>```<br>customers.id = charges.customer<br>```<br><br>```<br>customers.cards.customer = charges.customer<br>```<br><br>```<br>customers.discount.customer = charges.customer<br>```<br><br>```<br>customers.id = charges.card.customer<br>```<br><br>```<br>customers.cards.customer = charges.card.customer<br>```<br><br>```<br>customers.discount.customer = charges.card.customer<br>``` |
| [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#coupons) | ```<br>customers.discount.coupon.id = coupons.id<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoices) | ```<br>customers.discount.coupon.id = invoices.discount.coupon.id<br>```<br><br>```<br>customers.id = invoices.customer<br>```<br><br>```<br>customers.cards.customer = invoices.customer<br>```<br><br>```<br>customers.discount.customer = invoices.customer<br>```<br><br>```<br>customers.id = invoices.discount.customer<br>```<br><br>```<br>customers.cards.customer = invoices.discount.customer<br>```<br><br>```<br>customers.discount.customer = invoices.discount.customer<br>```<br><br>```<br>customers.subscriptions = invoices.subscription<br>```<br><br>```<br>customers.discount.subscription = invoices.subscription<br>```<br><br>```<br>customers.subscriptions = invoices.discount.subscription<br>```<br><br>```<br>customers.discount.subscription = invoices.discount.subscription<br>``` |
| [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscriptions) | ```<br>customers.discount.coupon.id = subscriptions.discount.coupon.id<br>```<br><br>```<br>customers.id = subscriptions.customer<br>```<br><br>```<br>customers.cards.customer = subscriptions.customer<br>```<br><br>```<br>customers.discount.customer = subscriptions.customer<br>```<br><br>```<br>customers.subscriptions = subscriptions.id<br>```<br><br>```<br>customers.discount.subscription = subscriptions.id<br>``` |
| [invoice_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-items) | ```<br>customers.id = invoice_items.customer<br>```<br><br>```<br>customers.cards.customer = invoice_items.customer<br>```<br><br>```<br>customers.discount.customer = invoice_items.customer<br>```<br><br>```<br>customers.subscriptions = invoice_items.subscription<br>```<br><br>```<br>customers.discount.subscription = invoice_items.subscription<br>``` |
| [subscription_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscription-items) | ```<br>customers.id = subscription_items.customer<br>```<br><br>```<br>customers.cards.customer = subscription_items.customer<br>```<br><br>```<br>customers.discount.customer = subscription_items.customer<br>```<br><br>```<br>customers.subscriptions = subscription_items.subscription<br>```<br><br>```<br>customers.discount.subscription = subscription_items.subscription<br>``` |
| [invoice_line_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-line-items) | ```<br>customers.subscriptions = invoice_line_items.subscription<br>```<br><br>```<br>customers.discount.subscription = invoice_line_items.subscription<br>``` |

customers table schema

| **account\_balance**<br><br><br>INTEGER |
| --- |
| **address**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul> |
| **balance**<br><br><br>INTEGER |
| **cards**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>address_city: STRING</li><li>address_country: STRING</li><li>address_line1: STRING</li><li>address_line1_check: STRING</li><li>address_line2: STRING</li><li>address_state: STRING</li><li>address_zip: STRING</li><li>address_zip_check: STRING</li><li>brand: STRING</li><li>country: STRING</li><li>customer: STRING</li><li>cvc_check: STRING</li><li>dynamic_last4: STRING</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>funding: STRING</li><li>id: STRING</li><li>last4: STRING</li><li>metadata: STRING</li><li>name: STRING</li><li>object: STRING</li><li>tokenization_method: STRING</li><li>type: STRING</li></ul> |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **default\_card**<br><br><br>STRING |
| **default\_source**<br><br><br>STRING |
| **delinquent**<br><br><br>BOOLEAN |
| **description**<br><br><br>STRING |
| **discount**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>checkout_session: STRING</li><li>coupon: OBJECT, which is also a nested data structure.											<ul><li>amount_off: INTEGER</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>duration: STRING</li><li>duration_in_months: INTEGER</li><li>id: STRING</li><li>livemode: BOOLEAN</li><li>max_redemptions: INTEGER</li><li>metadata: OBJECT</li><li>name: STRING</li><li>object: STRING</li><li>percent_off: NUMBER</li><li>percent_off_precise: NUMBER</li><li>redeem_by: DATE-TIME</li><li>times_redeemed: INTEGER</li><li>valid: BOOLEAN</li></ul></li><li>customer: STRING</li><li>end: DATE-TIME</li><li>id: STRING</li><li>invoice: STRING</li><li>invoice_item: STRING</li><li>object: STRING</li><li>promotion_code: STRING</li><li>start: DATE-TIME</li><li>subscription: STRING</li></ul> |
| **email**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **invoice\_prefix**<br><br><br>STRING |
| **invoice\_settings**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>custom_fields: ARRAY</li><li>default_payment_method: STRING</li><li>footer: STRING</li></ul> |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **name**<br><br><br>STRING |
| **next\_invoice\_sequence**<br><br><br>INTEGER |
| **object**<br><br><br>STRING |
| **phone**<br><br><br>STRING |
| **preferred\_locales**<br><br><br>ARRAY |
| **shipping**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>address: OBJECT, which is also a nested data structure.											<ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul></li><li>name: STRING</li><li>phone: STRING</li></ul> |
| **sources**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>ach_credit_transfer: OBJECT, which is also a nested data structure.											<ul><li>account_number: STRING</li><li>bank_name: STRING</li><li>fingerprint: STRING</li><li>refund_account_holder_name: STRING</li><li>refund_account_holder_type: STRING</li><li>refund_account_number: STRING</li><li>refund_routing_number: STRING</li><li>routing_number: STRING</li><li>swift_code: STRING</li></ul></li><li>address_city: STRING</li><li>address_country: STRING</li><li>address_line1: STRING</li><li>address_line1_check: STRING</li><li>address_line2: STRING</li><li>address_state: STRING</li><li>address_zip: STRING</li><li>address_zip_check: STRING</li><li>alipay: OBJECT</li><li>amount: INTEGER</li><li>bancontact: OBJECT</li><li>brand: STRING</li><li>card: OBJECT, which is also a nested data structure.											<ul><li>address_line1_check: STRING</li><li>address_zip_check: STRING</li><li>brand: STRING</li><li>country: STRING</li><li>cvc_check: STRING</li><li>dynamic_last4: STRING</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>funding: STRING</li><li>last4: STRING</li><li>name: STRING</li><li>three_d_secure: STRING</li><li>tokenization_method: STRING</li><li>type: STRING</li></ul></li><li>client_secret: STRING</li><li>country: STRING</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>customer: STRING</li><li>cvc_check: STRING</li><li>dynamic_last4: STRING</li><li>eps: OBJECT</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>flow: STRING</li><li>funding: STRING</li><li>id: STRING</li><li>ideal: OBJECT</li><li>last4: STRING</li><li>livemode: BOOLEAN</li><li>metadata: OBJECT</li><li>multibanco: OBJECT</li><li>name: STRING</li><li>object: STRING</li><li>owner: OBJECT, which is also a nested data structure.											<ul><li>address: OBJECT, which is also a nested data structure.													<ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul></li><li>email: STRING</li><li>name: STRING</li><li>phone: STRING</li><li>verified_address: STRING</li><li>verified_email: STRING</li><li>verified_name: STRING</li><li>verified_phone: STRING</li></ul></li><li>receiver: OBJECT, which is also a nested data structure.											<ul><li>address: STRING</li><li>amount_charged: INTEGER</li><li>amount_received: INTEGER</li><li>amount_returned: INTEGER</li><li>refund_attributes_method: STRING</li><li>refund_attributes_status: STRING</li></ul></li><li>redirect: OBJECT, which is also a nested data structure.											<ul><li>failure_reason: STRING</li><li>return_url: STRING</li><li>status: STRING</li><li>url: STRING</li></ul></li><li>statement_descriptor: STRING</li><li>status: STRING</li><li>tokenization_method: STRING</li><li>type: STRING</li><li>usage: STRING</li></ul><br><br>["TYPE", ["NULL", "STRING"]] |
| **subscriptions**<br><br><br>ARRAY |
| **tax\_exempt**<br><br><br>STRING |
| **tax\_ids**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>country: STRING</li><li>created: DATE-TIME</li><li>customer: STRING</li><li>id: STRING</li><li>livemode: BOOLEAN</li><li>object: STRING</li><li>type: STRING</li><li>value: STRING</li><li>verification: OBJECT, which is also a nested data structure.											<ul><li>status: STRING</li><li>verified_address: STRING</li><li>verified_name: STRING</li></ul></li></ul><br><br>["TYPE", ["NULL", "STRING"]] |
| **tax\_info**<br><br><br>STRING |
| **tax\_info\_verification**<br><br><br>STRING |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>STRING |

### disputes

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

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/disputes/object)<br><br>[Stripe API method](https://stripe.com/Content/api/disputes/list "Opens in new tab: Stripe API method") |

disputes table foreign keys

| Join disputes with | on |
| --- | --- |
| [balance_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#balance-transactions) | ```<br>disputes.balance_transactions.id = balance_transactions.id<br>``` |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>disputes.balance_transactions.id = charges.balance_transaction<br>```<br><br>```<br>disputes.charge = charges.id<br>``` |
| [payouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#payouts) | ```<br>disputes.balance_transactions.id = payouts.balance_transaction<br>```<br><br>```<br>disputes.balance_transactions.id = payouts.failure_balance_transaction<br>``` |
| [transfers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#transfers) | ```<br>disputes.balance_transactions.id = transfers.balance_transaction<br>```<br><br>```<br>disputes.balance_transactions.id = transfers.failure_balance_transaction<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoices) | ```<br>disputes.charge = invoices.charge<br>``` |

disputes table schema

| **amount**<br><br><br>INTEGER |
| --- |
| **balance\_transactions**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>id: STRING</li></ul> |
| **charge**<br><br><br>STRING |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **evidence**<br><br><br>STRING, OBJECT<br><br>This is a nested data structure:<br><br><ul><li>access_activity_log: STRING</li><li>billing_address: STRING</li><li>cancellation_policy: STRING</li><li>cancellation_policy_disclosure: STRING</li><li>cancellation_rebuttal: STRING</li><li>customer_communication: STRING</li><li>customer_email_address: STRING</li><li>customer_name: STRING</li><li>customer_purchase_ip: STRING</li><li>customer_signature: STRING</li><li>duplicate_charge_documentation: STRING</li><li>duplicate_charge_explanation: STRING</li><li>duplicate_charge_id: STRING</li><li>product_description: STRING</li><li>receipt: STRING</li><li>refund_policy: STRING</li><li>refund_policy_disclosure: STRING</li><li>refund_refusal_explanation: STRING</li><li>service_date: STRING</li><li>service_documentation: STRING</li><li>shipping_address: STRING</li><li>shipping_carrier: STRING</li><li>shipping_date: STRING</li><li>shipping_documentation: STRING</li><li>shipping_tracking_number: STRING</li><li>uncategorized_file: STRING</li><li>uncategorized_text: STRING</li></ul> |
| **evidence\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>due_by: DATE-TIME</li><li>has_evidence: BOOLEAN</li><li>past_due: BOOLEAN</li><li>submission_count: INTEGER</li></ul> |
| **id**<br><br><br>STRING |
| **is\_charge\_refundable**<br><br><br>BOOLEAN |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **object**<br><br><br>STRING |
| **reason**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>STRING |

### events

The `events` table contains info about [events](https://stripe.com/Content/api/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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#replication) section. Additionally, refer to [Stripe’s documentation](https://stripe.com/Content/api/events/types) for info about event types and the objects they describe.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/events)<br><br>[Stripe API method](https://stripe.com/Content/api/events/list "Opens in new tab: Stripe API method") |

events table schema

| **api\_version**<br><br><br>STRING |
| --- |
| **created**<br><br><br>DATE-TIME |
| **data**<br><br><br>OBJECT |
| **id**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **object**<br><br><br>STRING |
| **pending\_webhooks**<br><br><br>INTEGER |
| **request**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **updated**<br><br><br>DATE-TIME |

### invoice\_items

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

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | date |
| **Useful links** | Stripe documentation<br><br>[Stripe API method](https://stripe.com/Content/api/invoiceitems/list "Opens in new tab: Stripe API method") |

invoice\_items table foreign keys

| Join invoice\_items with | on |
| --- | --- |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>invoice_items.customer = charges.customer<br>```<br><br>```<br>invoice_items.customer = charges.card.customer<br>```<br><br>```<br>invoice_items.invoice = charges.invoice<br>``` |
| [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#customers) | ```<br>invoice_items.customer = customers.id<br>```<br><br>```<br>invoice_items.customer = customers.cards.customer<br>```<br><br>```<br>invoice_items.customer = customers.discount.customer<br>```<br><br>```<br>invoice_items.subscription = customers.subscriptions<br>```<br><br>```<br>invoice_items.subscription = customers.discount.subscription<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoices) | ```<br>invoice_items.customer = invoices.customer<br>```<br><br>```<br>invoice_items.customer = invoices.discount.customer<br>```<br><br>```<br>invoice_items.invoice = invoices.id<br>```<br><br>```<br>invoice_items.subscription = invoices.subscription<br>```<br><br>```<br>invoice_items.subscription = invoices.discount.subscription<br>``` |
| [subscription_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscription-items) | ```<br>invoice_items.customer = subscription_items.customer<br>```<br><br>```<br>invoice_items.plan.id = subscription_items.plan.id<br>```<br><br>```<br>invoice_items.plan.product = subscription_items.plan.product<br>```<br><br>```<br>invoice_items.subscription_item = subscription_items.id<br>```<br><br>```<br>invoice_items.subscription = subscription_items.subscription<br>``` |
| [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscriptions) | ```<br>invoice_items.customer = subscriptions.customer<br>```<br><br>```<br>invoice_items.plan.id = subscriptions.plan.id<br>```<br><br>```<br>invoice_items.plan.product = subscriptions.plan.product<br>```<br><br>```<br>invoice_items.subscription_item = subscriptions.items<br>```<br><br>```<br>invoice_items.subscription = subscriptions.id<br>``` |
| [invoice_line_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-line-items) | ```<br>invoice_items.invoice = invoice_line_items.invoice<br>```<br><br>```<br>invoice_items.id = invoice_line_items.invoice_item<br>```<br><br>```<br>invoice_items.plan.product = invoice_line_items.plan.product<br>```<br><br>```<br>invoice_items.subscription = invoice_line_items.subscription<br>``` |
| [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#plans) | ```<br>invoice_items.plan.id = plans.id<br>```<br><br>```<br>invoice_items.plan.product = plans.product<br>``` |
| [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#products) | ```<br>invoice_items.plan.product = products.id<br>``` |

invoice\_items table schema

| **amount**<br><br><br>INTEGER |
| --- |
| **currency**<br><br><br>STRING |
| **customer**<br><br><br>STRING |
| **date**<br><br><br>DATE-TIME |
| **description**<br><br><br>STRING |
| **discountable**<br><br><br>BOOLEAN |
| **discounts**<br><br><br>ARRAY |
| **id**<br><br><br>STRING |
| **invoice**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **object**<br><br><br>STRING |
| **period**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>end: DATE-TIME</li><li>start: DATE-TIME</li></ul> |
| **plan**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>aggregate_usage: STRING</li><li>amount: INTEGER</li><li>amount_decimal: NUMBER</li><li>billing_scheme: STRING</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>id: STRING</li><li>interval: STRING</li><li>interval_count: INTEGER</li><li>livemode: BOOLEAN</li><li>metadata: OBJECT</li><li>name: STRING</li><li>nickname: STRING</li><li>object: STRING</li><li>product: STRING</li><li>statement_description: STRING</li><li>statement_descriptor: STRING</li><li>tiers: ARRAY, which is also a nested data structure.											<ul><li>flat_amount: INTEGER</li><li>unit_amount: INTEGER</li><li>up_to: INTEGER</li></ul></li><li>tiers_mode: STRING</li><li>transform_usage: OBJECT</li><li>trial_period_days: INTEGER</li><li>updated: DATE-TIME</li><li>updated_by_event_type: STRING</li><li>usage_type: STRING</li></ul> |
| **proration**<br><br><br>BOOLEAN |
| **quantity**<br><br><br>INTEGER |
| **subscription**<br><br><br>STRING |
| **subscription\_item**<br><br><br>STRING |
| **tax\_rates**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>country: STRING</li><li>created: DATE-TIME</li><li>description: STRING</li><li>display_name: STRING</li><li>id: STRING</li><li>inclusive: BOOLEAN</li><li>jurisdiction: STRING</li><li>livemode: BOOLEAN</li><li>object: STRING</li><li>percentage: NUMBER</li><li>state: STRING</li></ul> |
| **unit\_amount**<br><br><br>INTEGER |
| **unit\_amount\_decimal**<br><br><br>NUMBER |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>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`](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#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`](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#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** | CDC |
| --- | --- |
| **Primary Keys** | id<br><br>invoice |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/invoices/line_item)<br><br>[Stripe API method](https://stripe.com/Content/api/invoices/invoice_lines "Opens in new tab: Stripe API method") |

invoice\_line\_items table foreign keys

| Join invoice\_line\_items with | on |
| --- | --- |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>invoice_line_items.invoice = charges.invoice<br>``` |
| [invoice_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-items) | ```<br>invoice_line_items.invoice = invoice_items.invoice<br>```<br><br>```<br>invoice_line_items.invoice_item = invoice_items.id<br>```<br><br>```<br>invoice_line_items.plan.product = invoice_items.plan.product<br>```<br><br>```<br>invoice_line_items.subscription = invoice_items.subscription<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoices) | ```<br>invoice_line_items.invoice = invoices.id<br>```<br><br>```<br>invoice_line_items.id = invoices.lines<br>```<br><br>```<br>invoice_line_items.subscription = invoices.subscription<br>```<br><br>```<br>invoice_line_items.subscription = invoices.discount.subscription<br>``` |
| [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#plans) | ```<br>invoice_line_items.plan.product = plans.product<br>``` |
| [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#products) | ```<br>invoice_line_items.plan.product = products.id<br>``` |
| [subscription_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscription-items) | ```<br>invoice_line_items.plan.product = subscription_items.plan.product<br>```<br><br>```<br>invoice_line_items.subscription = subscription_items.subscription<br>``` |
| [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscriptions) | ```<br>invoice_line_items.plan.product = subscriptions.plan.product<br>```<br><br>```<br>invoice_line_items.subscription = subscriptions.id<br>``` |
| [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#customers) | ```<br>invoice_line_items.subscription = customers.subscriptions<br>```<br><br>```<br>invoice_line_items.subscription = customers.discount.subscription<br>``` |

invoice\_line\_items table schema

| **amount**<br><br><br>INTEGER |
| --- |
| **currency**<br><br><br>STRING |
| **description**<br><br><br>STRING |
| **discount\_amounts**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>discount: STRING</li></ul> |
| **discountable**<br><br><br>BOOLEAN |
| **discounts**<br><br><br>ARRAY |
| **id**<br><br><br>STRING |
| **invoice**<br><br><br>STRING |
| **invoice\_item**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **object**<br><br><br>STRING |
| **period**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>end: DATE-TIME</li><li>start: DATE-TIME</li></ul> |
| **plan**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>aggregate_usage: STRING</li><li>amount: INTEGER</li><li>amount_decimal: NUMBER</li><li>billing_scheme: STRING</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>id: STRING</li><li>interval: STRING</li><li>interval_count: INTEGER</li><li>livemode: BOOLEAN</li><li>metadata: OBJECT</li><li>name: STRING</li><li>nickname: STRING</li><li>object: STRING</li><li>product: STRING</li><li>statement_description: STRING</li><li>statement_descriptor: STRING</li><li>tiers: ARRAY, which is also a nested data structure.											<ul><li>flat_amount: INTEGER</li><li>unit_amount: INTEGER</li><li>up_to: INTEGER</li></ul></li><li>tiers_mode: STRING</li><li>transform_usage: OBJECT</li><li>trial_period_days: INTEGER</li><li>updated: DATE-TIME</li><li>updated_by_event_type: STRING</li><li>usage_type: STRING</li></ul> |
| **price**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>billing_scheme: STRING</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>id: STRING</li><li>livemode: BOOLEAN</li><li>lookup_key: STRING</li><li>metadata: OBJECT</li><li>nickname: STRING</li><li>object: STRING</li><li>product: STRING</li><li>recurring: OBJECT, which is also a nested data structure.											<ul><li>aggregate_usage: STRING</li><li>interval: STRING</li><li>interval_count: INTEGER</li><li>usage_type: STRING</li></ul></li><li>tax_behavior: STRING</li><li>tiers: ARRAY, which is also a nested data structure.											<ul><li>flat_amount: INTEGER</li><li>flat_amount_decimal: NUMBER</li><li>unit_amount: INTEGER</li><li>unit_amount_decimal: NUMBER</li><li>up_to: INTEGER</li></ul></li><li>tiers_mode: STRING</li><li>transform_quantity: OBJECT, which is also a nested data structure.											<ul><li>divide_by: INTEGER</li><li>round: STRING</li></ul></li><li>type: STRING</li><li>unit_amount: INTEGER</li><li>unit_amount_decimal: NUMBER</li></ul> |
| **proration**<br><br><br>BOOLEAN |
| **proration\_details**<br><br><br>OBJECT |
| **quantity**<br><br><br>INTEGER |
| **subscription**<br><br><br>STRING |
| **subscription\_item**<br><br><br>STRING |
| **tax\_amounts**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>inclusive: BOOLEAN</li><li>tax_rate: STRING</li></ul> |
| **tax\_rates**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>country: STRING</li><li>created: DATE-TIME</li><li>description: STRING</li><li>display_name: STRING</li><li>id: STRING</li><li>inclusive: BOOLEAN</li><li>jurisdiction: STRING</li><li>livemode: BOOLEAN</li><li>metadata: OBJECT</li><li>object: STRING</li><li>percentage: NUMBER</li><li>state: STRING</li><li>tax_type: BOOLEAN</li></ul> |
| **type**<br><br><br>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`](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice_line_items) table. To replicate these records, you must set this table and the `invoice_line_items` table to replicate.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/invoices)<br><br>[Stripe API method](https://stripe.com/Content/api/invoices/list "Opens in new tab: Stripe API method") |

invoices table foreign keys

| Join invoices with | on |
| --- | --- |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>invoices.charge = charges.id<br>```<br><br>```<br>invoices.customer = charges.customer<br>```<br><br>```<br>invoices.discount.customer = charges.customer<br>```<br><br>```<br>invoices.customer = charges.card.customer<br>```<br><br>```<br>invoices.discount.customer = charges.card.customer<br>```<br><br>```<br>invoices.id = charges.invoice<br>``` |
| [disputes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#disputes) | ```<br>invoices.charge = disputes.charge<br>``` |
| [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#coupons) | ```<br>invoices.discount.coupon.id = coupons.id<br>``` |
| [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#customers) | ```<br>invoices.discount.coupon.id = customers.discount.coupon.id<br>```<br><br>```<br>invoices.customer = customers.id<br>```<br><br>```<br>invoices.discount.customer = customers.id<br>```<br><br>```<br>invoices.customer = customers.cards.customer<br>```<br><br>```<br>invoices.discount.customer = customers.cards.customer<br>```<br><br>```<br>invoices.customer = customers.discount.customer<br>```<br><br>```<br>invoices.discount.customer = customers.discount.customer<br>```<br><br>```<br>invoices.subscription = customers.subscriptions<br>```<br><br>```<br>invoices.discount.subscription = customers.subscriptions<br>```<br><br>```<br>invoices.subscription = customers.discount.subscription<br>```<br><br>```<br>invoices.discount.subscription = customers.discount.subscription<br>``` |
| [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscriptions) | ```<br>invoices.discount.coupon.id = subscriptions.discount.coupon.id<br>```<br><br>```<br>invoices.customer = subscriptions.customer<br>```<br><br>```<br>invoices.discount.customer = subscriptions.customer<br>```<br><br>```<br>invoices.subscription = subscriptions.id<br>```<br><br>```<br>invoices.discount.subscription = subscriptions.id<br>``` |
| [invoice_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-items) | ```<br>invoices.customer = invoice_items.customer<br>```<br><br>```<br>invoices.discount.customer = invoice_items.customer<br>```<br><br>```<br>invoices.id = invoice_items.invoice<br>```<br><br>```<br>invoices.subscription = invoice_items.subscription<br>```<br><br>```<br>invoices.discount.subscription = invoice_items.subscription<br>``` |
| [subscription_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscription-items) | ```<br>invoices.customer = subscription_items.customer<br>```<br><br>```<br>invoices.discount.customer = subscription_items.customer<br>```<br><br>```<br>invoices.subscription = subscription_items.subscription<br>```<br><br>```<br>invoices.discount.subscription = subscription_items.subscription<br>``` |
| [invoice_line_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-line-items) | ```<br>invoices.id = invoice_line_items.invoice<br>```<br><br>```<br>invoices.lines = invoice_line_items.id<br>```<br><br>```<br>invoices.subscription = invoice_line_items.subscription<br>```<br><br>```<br>invoices.discount.subscription = invoice_line_items.subscription<br>``` |

invoices table schema

| **account\_country**<br><br><br>STRING |
| --- |
| **account\_name**<br><br><br>STRING |
| **account\_tax\_ids**<br><br><br>ARRAY |
| **amount\_due**<br><br><br>INTEGER |
| **amount\_paid**<br><br><br>INTEGER |
| **amount\_remaining**<br><br><br>INTEGER |
| **application\_fee**<br><br><br>INTEGER |
| **application\_fee\_amount**<br><br><br>INTEGER |
| **attempt\_count**<br><br><br>INTEGER |
| **attempted**<br><br><br>BOOLEAN |
| **auto\_advance**<br><br><br>BOOLEAN |
| **automatic\_tax**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>enabled: BOOLEAN</li><li>status: STRING</li></ul> |
| **billing**<br><br><br>STRING |
| **billing\_reason**<br><br><br>STRING |
| **charge**<br><br><br>STRING |
| **closed**<br><br><br>BOOLEAN |
| **collection\_method**<br><br><br>STRING |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **custom\_fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>name: STRING</li><li>value: STRING</li></ul> |
| **customer**<br><br><br>STRING |
| **customer\_address**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul> |
| **customer\_email**<br><br><br>STRING |
| **customer\_name**<br><br><br>STRING |
| **customer\_phone**<br><br><br>STRING |
| **customer\_shipping**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>address: OBJECT, which is also a nested data structure.											<ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code: STRING</li><li>state: STRING</li></ul></li><li>name: STRING</li><li>phone: STRING</li></ul> |
| **customer\_tax\_exempt**<br><br><br>STRING |
| **customer\_tax\_ids**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>type: STRING</li><li>value: STRING</li></ul> |
| **date**<br><br><br>DATE-TIME |
| **default\_payment\_method**<br><br><br>STRING |
| **default\_source**<br><br><br>STRING |
| **default\_tax\_rates**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>country: STRING</li><li>created: DATE-TIME</li><li>description: STRING</li><li>display_name: STRING</li><li>id: STRING</li><li>inclusive: BOOLEAN</li><li>jurisdiction: STRING</li><li>livemode: BOOLEAN</li><li>metadata: OBJECT</li><li>object: STRING</li><li>percentage: NUMBER</li><li>state: STRING</li></ul> |
| **description**<br><br><br>STRING |
| **discount**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>checkout_session: STRING</li><li>coupon: OBJECT, which is also a nested data structure.											<ul><li>amount_off: INTEGER</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>duration: STRING</li><li>duration_in_months: INTEGER</li><li>id: STRING</li><li>livemode: BOOLEAN</li><li>max_redemptions: INTEGER</li><li>metadata: OBJECT</li><li>name: STRING</li><li>object: STRING</li><li>percent_off: NUMBER</li><li>percent_off_precise: NUMBER</li><li>redeem_by: DATE-TIME</li><li>times_redeemed: INTEGER</li><li>valid: BOOLEAN</li></ul></li><li>customer: STRING</li><li>end: DATE-TIME</li><li>id: STRING</li><li>invoice: STRING</li><li>invoice_item: STRING</li><li>object: STRING</li><li>promotion_code: STRING</li><li>start: DATE-TIME</li><li>subscription: STRING</li></ul> |
| **discounts**<br><br><br>ARRAY |
| **due\_date**<br><br><br>DATE-TIME |
| **ending\_balance**<br><br><br>INTEGER |
| **finalized\_at**<br><br><br>DATE-TIME |
| **footer**<br><br><br>STRING |
| **forgiven**<br><br><br>BOOLEAN |
| **hosted\_invoice\_url**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **invoice\_pdf**<br><br><br>STRING |
| **last\_finalization\_error**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>code: STRING</li><li>doc_url: STRING</li><li>message: STRING</li><li>param: STRING</li><li>payment_method_type: STRING</li><li>type: STRING</li></ul> |
| **lines**<br><br><br>ARRAY, OBJECT |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **next\_payment\_attempt**<br><br><br>DATE-TIME |
| **number**<br><br><br>STRING |
| **object**<br><br><br>STRING |
| **on\_behalf\_of**<br><br><br>STRING, OBJECT |
| **paid**<br><br><br>BOOLEAN |
| **paid\_out\_of\_band**<br><br><br>BOOLEAN |
| **payment**<br><br><br>STRING |
| **payment\_intent**<br><br><br>STRING |
| **payment\_settings**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>payment_method_options: OBJECT, which is also a nested data structure.											<ul><li>acss_debit: OBJECT, which is also a nested data structure.													<ul><li>mandate_options: OBJECT, which is also a nested data structure.															<ul><li>transaction_type: STRING</li></ul></li><li>verification_method: STRING</li></ul></li><li>bancontact: OBJECT, which is also a nested data structure.													<ul><li>preferred_language: STRING</li></ul></li><li>card: OBJECT, which is also a nested data structure.													<ul><li>request_three_d_secure: STRING</li></ul></li></ul></li><li>payment_method_types: ARRAY</li></ul> |
| **period\_end**<br><br><br>DATE-TIME |
| **period\_start**<br><br><br>DATE-TIME |
| **post\_payment\_credit\_notes\_amount**<br><br><br>INTEGER |
| **pre\_payment\_credit\_notes\_amount**<br><br><br>INTEGER |
| **quote**<br><br><br>OBJECT, STRING |
| **receipt\_number**<br><br><br>STRING |
| **starting\_balance**<br><br><br>INTEGER |
| **statement\_description**<br><br><br>STRING |
| **statement\_descriptor**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **status\_transitions**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>finalized_at: DATE-TIME</li><li>marked_uncollectible_at: DATE-TIME</li><li>paid_at: DATE-TIME</li><li>voided_at: DATE-TIME</li></ul> |
| **subscription**<br><br><br>STRING |
| **subscription\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>metadata: STRING</li></ul> |
| **subtotal**<br><br><br>INTEGER |
| **tax**<br><br><br>INTEGER |
| **tax\_percent**<br><br><br>NUMBER |
| **total**<br><br><br>INTEGER |
| **total\_discount\_amounts**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>discount: STRING</li></ul> |
| **total\_tax\_amounts**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>inclusive: BOOLEAN</li><li>tax_rate: STRING</li></ul> |
| **transfer\_data**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>destination: STRING</li></ul> |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>STRING |
| **webhooks\_delivered\_at**<br><br><br>DATE-TIME |

### payment\_intents

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

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/payments/payment-intents)<br><br>[Stripe API method](https://stripe.com/Content/api/payment_intents/list "Opens in new tab: Stripe API method") |

payment\_intents table schema

| **amount**<br><br><br>INTEGER |
| --- |
| **amount\_capturable**<br><br><br>INTEGER |
| **amount\_received**<br><br><br>INTEGER |
| **application**<br><br><br>STRING |
| **application\_fee\_amount**<br><br><br>INTEGER |
| **automatic\_payment\_methods**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>enabled: BOOLEAN</li></ul> |
| **canceled\_at**<br><br><br>DATE-TIME |
| **cancellation\_reason**<br><br><br>STRING |
| **capture\_method**<br><br><br>STRING |
| **client\_secret**<br><br><br>STRING |
| **confirmation\_method**<br><br><br>STRING |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **customer**<br><br><br>STRING |
| **description**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **invoice**<br><br><br>STRING |
| **last\_payment\_error**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>charge: STRING</li><li>code: STRING</li><li>decline_code: STRING</li><li>doc_url: STRING</li><li>message: STRING</li><li>param: STRING</li><li>payment_method_type: STRING</li><li>type: STRING</li></ul> |
| **latest\_charge**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **next\_action**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>alipay_handle_redirect: OBJECT, which is also a nested data structure.											<ul><li>native_data: STRING</li><li>native_url: STRING</li><li>return_url: STRING</li><li>url: STRING</li></ul></li><li>boleto_display_details: OBJECT, which is also a nested data structure.											<ul><li>expires_at: DATE-TIME</li><li>hosted_voucher_url: STRING</li><li>number: STRING</li><li>pdf: STRING</li></ul></li><li>oxxo_display_details: OBJECT, which is also a nested data structure.											<ul><li>expires_after: DATE-TIME</li><li>hosted_voucher_url: STRING</li><li>number: STRING</li></ul></li><li>redirect_to_url: OBJECT, which is also a nested data structure.											<ul><li>return_url: STRING</li><li>url: STRING</li></ul></li><li>type: STRING</li><li>use_stripe_sdk: OBJECT</li><li>verify_with_microdeposits: OBJECT, which is also a nested data structure.											<ul><li>arrival_date: DATE-TIME</li><li>hosted_verification_url: STRING</li></ul></li><li>wechat_pay_display_qr_code: OBJECT, which is also a nested data structure.											<ul><li>data: STRING</li><li>image_data_url: STRING</li><li>image_url_png: STRING</li><li>image_url_svg: STRING</li></ul></li><li>wechat_pay_redirect_to_android_app: OBJECT, which is also a nested data structure.											<ul><li>app_id: STRING</li><li>nonce_str: STRING</li><li>package: STRING</li><li>partner_id: STRING</li><li>prepay_id: STRING</li><li>sign: STRING</li><li>timestamp: STRING</li></ul></li><li>wechat_pay_redirect_to_ios_app: OBJECT, which is also a nested data structure.											<ul><li>native_url: STRING</li></ul></li></ul> |
| **object**<br><br><br>STRING |
| **on\_behalf\_of**<br><br><br>STRING |
| **payment\_method**<br><br><br>STRING |
| **payment\_method\_options**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>acss_debit: OBJECT, which is also a nested data structure.											<ul><li>mandate_options: OBJECT, which is also a nested data structure.													<ul><li>custom_mandate_url: STRING</li><li>interval_description: STRING</li><li>payment_schedule: STRING</li><li>transaction_type: STRING</li></ul></li></ul></li><li>afterpay_clearpay: OBJECT, which is also a nested data structure.											<ul><li>reference: STRING</li><li>setup_future_usage: STRING</li></ul></li><li>alipay: OBJECT, which is also a nested data structure.											<ul><li>setup_future_usage: STRING</li></ul></li><li>au_becs_debit: OBJECT, which is also a nested data structure.											<ul><li>setup_future_usage: STRING</li></ul></li><li>bacs_debit: OBJECT, which is also a nested data structure.											<ul><li>setup_future_usage: STRING</li></ul></li><li>bancontact: OBJECT, which is also a nested data structure.											<ul><li>preferred_language: STRING</li><li>setup_future_usage: STRING</li></ul></li><li>boleto: OBJECT, which is also a nested data structure.											<ul><li>expires_after_days: INTEGER</li><li>setup_future_usage: STRING</li></ul></li><li>card: OBJECT, which is also a nested data structure.											<ul><li>installments: OBJECT, which is also a nested data structure.													<ul><li>available_plans: ARRAY, which is also a nested data structure.															<ul><li>count: INTEGER</li><li>interval: STRING</li><li>type: STRING</li></ul></li><li>enabled: BOOLEAN</li><li>plan: OBJECT, which is also a nested data structure.															<ul><li>count: INTEGER</li><li>interval: STRING</li><li>type: STRING</li></ul></li></ul></li><li>network: STRING</li><li>request_three_d_secure: STRING</li><li>setup_future_usage: STRING</li></ul></li><li>card_present: OBJECT</li><li>eps: OBJECT, which is also a nested data structure.											<ul><li>setup_future_usage: STRING</li></ul></li><li>fps: OBJECT, which is also a nested data structure.											<ul><li>setup_future_usage: STRING</li></ul></li><li>giropay: OBJECT, which is also a nested data structure.											<ul><li>setup_future_usage: STRING</li></ul></li><li>grabpay: OBJECT, which is also a nested data structure.											<ul><li>setup_future_usage: STRING</li></ul></li><li>ideal: OBJECT, which is also a nested data structure.											<ul><li>setup_future_usage: STRING</li></ul></li><li>interac_present: OBJECT</li><li>klarna: OBJECT, which is also a nested data structure.											<ul><li>preferred_locale: STRING</li><li>setup_future_usage: STRING</li></ul></li><li>oxxo: OBJECT, which is also a nested data structure.											<ul><li>expires_after_days: STRING</li><li>setup_future_usage: STRING</li></ul></li><li>p24: OBJECT, which is also a nested data structure.											<ul><li>setup_future_usage: STRING</li></ul></li><li>sepa_debit: OBJECT, which is also a nested data structure.											<ul><li>mandate_options: OBJECT</li><li>setup_future_usage: STRING</li></ul></li><li>sofort: OBJECT, which is also a nested data structure.											<ul><li>preferred_language: STRING</li><li>setup_future_usage: STRING</li></ul></li><li>wechat_pay: OBJECT, which is also a nested data structure.											<ul><li>app_id: STRING</li><li>client: STRING</li><li>setup_future_usage: STRING</li></ul></li></ul> |
| **payment\_method\_types**<br><br><br>ARRAY |
| **processing**<br><br><br>OBJECT |
| **receipt\_email**<br><br><br>STRING |
| **review**<br><br><br>STRING |
| **setup\_future\_usage**<br><br><br>STRING |
| **shipping**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>address: OBJECT, which is also a nested data structure.											<ul><li>city: STRING</li><li>country: STRING</li><li>line1: STRING</li><li>line2: STRING</li><li>postal_code STRING</li><li>state: STRING</li></ul></li><li>carrier: STRING</li><li>name: STRING</li><li>phone: STRING</li><li>tracking_number: STRING</li></ul> |
| **source**<br><br><br>STRING |
| **statement\_descriptor**<br><br><br>STRING |
| **statement\_descriptor\_suffix**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **transfer\_data**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>destination: STRING</li></ul> |
| **transfer\_group**<br><br><br>STRING |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>STRING |

### payout\_transactions

This table contains info about payout transactions.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/payouts)<br><br>[Stripe API method](https://stripe.com/Content/api/payouts/list "Opens in new tab: Stripe API method") |

payout\_transactions table foreign keys

| Join payout\_transactions with | on |
| --- | --- |
| [payouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#payouts) | ```<br>payout_transactions.payout_id = payouts.id<br>``` |

payout\_transactions table schema

| **id**<br><br><br>STRING |
| --- |
| **payout\_id**<br><br><br>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** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/payouts)<br><br>[Stripe API method](https://stripe.com/Content/api/payouts/list "Opens in new tab: Stripe API method") |

payouts table foreign keys

| Join payouts with | on |
| --- | --- |
| [balance_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#balance-transactions) | ```<br>payouts.balance_transaction = balance_transactions.id<br>```<br><br>```<br>payouts.failure_balance_transaction = balance_transactions.id<br>``` |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>payouts.balance_transaction = charges.balance_transaction<br>```<br><br>```<br>payouts.failure_balance_transaction = charges.balance_transaction<br>``` |
| [transfers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#transfers) | ```<br>payouts.balance_transaction = transfers.balance_transaction<br>```<br><br>```<br>payouts.failure_balance_transaction = transfers.balance_transaction<br>```<br><br>```<br>payouts.balance_transaction = transfers.failure_balance_transaction<br>```<br><br>```<br>payouts.failure_balance_transaction = transfers.failure_balance_transaction<br>``` |
| [disputes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#disputes) | ```<br>payouts.balance_transaction = disputes.balance_transactions.id<br>```<br><br>```<br>payouts.failure_balance_transaction = disputes.balance_transactions.id<br>``` |
| [payout_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#payout-transactions) | ```<br>payouts.id = payout_transactions.payout_id<br>``` |

payouts table schema

| **amount**<br><br><br>INTEGER |
| --- |
| **amount\_reversed**<br><br><br>INTEGER |
| **arrival\_date**<br><br><br>DATE-TIME |
| **automatic**<br><br><br>BOOLEAN |
| **balance\_transaction**<br><br><br>STRING |
| **bank\_account**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>account_holder_name: STRING</li><li>account_holder_type: STRING</li><li>bank_name: STRING</li><li>country: STRING</li><li>currency: STRING</li><li>fingerprint: STRING</li><li>id: STRING</li><li>last4: STRING</li><li>metadata: OBJECT</li><li>name: STRING</li><li>object: STRING</li><li>routing_number: STRING</li><li>status: STRING</li></ul> |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **date**<br><br><br>DATE-TIME |
| **description**<br><br><br>STRING |
| **destination**<br><br><br>STRING |
| **failure\_balance\_transaction**<br><br><br>STRING |
| **failure\_code**<br><br><br>STRING |
| **failure\_message**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **method**<br><br><br>STRING |
| **object**<br><br><br>STRING |
| **original\_payout**<br><br><br>STRING |
| **recipient**<br><br><br>STRING |
| **reversed\_by**<br><br><br>STRING |
| **source\_transaction**<br><br><br>STRING |
| **source\_type**<br><br><br>STRING |
| **statement\_description**<br><br><br>STRING |
| **statement\_descriptor**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **transfer\_group**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>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** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/plans)<br><br>[Stripe API method](https://stripe.com/Content/api/plans/list "Opens in new tab: Stripe API method") |

plans table foreign keys

| Join plans with | on |
| --- | --- |
| [invoice_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-items) | ```<br>plans.id = invoice_items.plan.id<br>```<br><br>```<br>plans.product = invoice_items.plan.product<br>``` |
| [subscription_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscription-items) | ```<br>plans.id = subscription_items.plan.id<br>```<br><br>```<br>plans.product = subscription_items.plan.product<br>``` |
| [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscriptions) | ```<br>plans.id = subscriptions.plan.id<br>```<br><br>```<br>plans.product = subscriptions.plan.product<br>``` |
| [invoice_line_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-line-items) | ```<br>plans.product = invoice_line_items.plan.product<br>``` |
| [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#products) | ```<br>plans.product = products.id<br>``` |

plans table schema

| **active**<br><br><br>BOOLEAN |
| --- |
| **aggregate\_usage**<br><br><br>STRING |
| **amount**<br><br><br>INTEGER |
| **amount\_decimal**<br><br><br>NUMBER |
| **billing\_scheme**<br><br><br>STRING |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **interval**<br><br><br>STRING |
| **interval\_count**<br><br><br>INTEGER |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **name**<br><br><br>STRING |
| **nickname**<br><br><br>STRING |
| **object**<br><br><br>STRING |
| **product**<br><br><br>STRING |
| **statement\_description**<br><br><br>STRING |
| **statement\_descriptor**<br><br><br>STRING |
| **tiers**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>flat_amount: INTEGER</li><li>unit_amount: INTEGER</li><li>up_to: INTEGER</li></ul> |
| **tiers\_mode**<br><br><br>STRING |
| **transform\_usage**<br><br><br>OBJECT |
| **trial\_period\_days**<br><br><br>INTEGER |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>STRING |
| **usage\_type**<br><br><br>STRING |

### products

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

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/products)<br><br>[Stripe API method](https://stripe.com/Content/api/products/list "Opens in new tab: Stripe API method") |

products table foreign keys

| Join products with | on |
| --- | --- |
| [invoice_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-items) | ```<br>products.id = invoice_items.plan.product<br>``` |
| [invoice_line_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-line-items) | ```<br>products.id = invoice_line_items.plan.product<br>``` |
| [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#plans) | ```<br>products.id = plans.product<br>``` |
| [subscription_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscription-items) | ```<br>products.id = subscription_items.plan.product<br>``` |
| [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscriptions) | ```<br>products.id = subscriptions.plan.product<br>``` |

products table schema

| **active**<br><br><br>BOOLEAN |
| --- |
| **attributes**<br><br><br>ARRAY |
| **caption**<br><br><br>STRING |
| **created**<br><br><br>DATE-TIME |
| **deactivate\_on**<br><br><br>ARRAY |
| **description**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **images**<br><br><br>ARRAY |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **name**<br><br><br>STRING |
| **object**<br><br><br>STRING |
| **package\_dimensions**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>height: NUMBER</li><li>length: NUMBER</li><li>weight: NUMBER</li><li>width: NUMBER</li></ul> |
| **shippable**<br><br><br>BOOLEAN |
| **statement\_descriptor**<br><br><br>STRING |
| **tax\_code**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **unit\_label**<br><br><br>STRING |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>STRING |
| **url**<br><br><br>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** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/subscription_items)<br><br>[Stripe API method](https://stripe.com/Content/api/subscription_items/list "Opens in new tab: Stripe API method") |

subscription\_items table foreign keys

| Join subscription\_items with | on |
| --- | --- |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>subscription_items.customer = charges.customer<br>```<br><br>```<br>subscription_items.customer = charges.card.customer<br>``` |
| [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#customers) | ```<br>subscription_items.customer = customers.id<br>```<br><br>```<br>subscription_items.customer = customers.cards.customer<br>```<br><br>```<br>subscription_items.customer = customers.discount.customer<br>```<br><br>```<br>subscription_items.subscription = customers.subscriptions<br>```<br><br>```<br>subscription_items.subscription = customers.discount.subscription<br>``` |
| [invoice_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-items) | ```<br>subscription_items.customer = invoice_items.customer<br>```<br><br>```<br>subscription_items.plan.id = invoice_items.plan.id<br>```<br><br>```<br>subscription_items.plan.product = invoice_items.plan.product<br>```<br><br>```<br>subscription_items.id = invoice_items.subscription_item<br>```<br><br>```<br>subscription_items.subscription = invoice_items.subscription<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoices) | ```<br>subscription_items.customer = invoices.customer<br>```<br><br>```<br>subscription_items.customer = invoices.discount.customer<br>```<br><br>```<br>subscription_items.subscription = invoices.subscription<br>```<br><br>```<br>subscription_items.subscription = invoices.discount.subscription<br>``` |
| [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscriptions) | ```<br>subscription_items.customer = subscriptions.customer<br>```<br><br>```<br>subscription_items.plan.id = subscriptions.plan.id<br>```<br><br>```<br>subscription_items.plan.product = subscriptions.plan.product<br>```<br><br>```<br>subscription_items.id = subscriptions.items<br>```<br><br>```<br>subscription_items.subscription = subscriptions.id<br>``` |
| [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#plans) | ```<br>subscription_items.plan.id = plans.id<br>```<br><br>```<br>subscription_items.plan.product = plans.product<br>``` |
| [invoice_line_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-line-items) | ```<br>subscription_items.plan.product = invoice_line_items.plan.product<br>```<br><br>```<br>subscription_items.subscription = invoice_line_items.subscription<br>``` |
| [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#products) | ```<br>subscription_items.plan.product = products.id<br>``` |

subscription\_items table schema

| **application\_fee\_percent**<br><br><br>NUMBER |
| --- |
| **billing\_thresholds**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>usage_gte: INTEGER</li></ul> |
| **cancel\_at\_period\_end**<br><br><br>BOOLEAN |
| **canceled\_at**<br><br><br>DATE-TIME |
| **created**<br><br><br>DATE-TIME |
| **current\_period\_end**<br><br><br>DATE-TIME |
| **current\_period\_start**<br><br><br>DATE-TIME |
| **customer**<br><br><br>STRING |
| **discount**<br><br><br>OBJECT |
| **ended\_at**<br><br><br>DATE-TIME |
| **id**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **object**<br><br><br>STRING |
| **plan**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>aggregate_usage: STRING</li><li>amount: INTEGER</li><li>amount_decimal: NUMBER</li><li>billing_scheme: STRING</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>id: STRING</li><li>interval: STRING</li><li>interval_count: INTEGER</li><li>livemode: BOOLEAN</li><li>metadata: OBJECT</li><li>name: STRING</li><li>nickname: STRING</li><li>object: STRING</li><li>product: STRING</li><li>statement_description: STRING</li><li>statement_descriptor: STRING</li><li>tiers: ARRAY, which is also a nested data structure.											<ul><li>flat_amount: INTEGER</li><li>unit_amount: INTEGER</li><li>up_to: INTEGER</li></ul></li><li>tiers_mode: STRING</li><li>transform_usage: OBJECT</li><li>trial_period_days: INTEGER</li><li>updated: DATE-TIME</li><li>updated_by_event_type: STRING</li><li>usage_type: STRING</li></ul> |
| **price**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>billing_scheme: STRING</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>id: STRING</li><li>livemode: BOOLEAN</li><li>lookup_key: STRING</li><li>metadata: OBJECT</li><li>nickname: STRING</li><li>object: STRING</li><li>product: STRING</li><li>recurring: OBJECT, which is also a nested data structure.											<ul><li>aggregate_usage: STRING</li><li>interval: STRING</li><li>interval_count: INTEGER</li><li>usage_type: STRING</li></ul></li><li>tax_behavior: STRING</li><li>tiers: ARRAY, which is also a nested data structure.											<ul><li>flat_amount: INTEGER</li><li>flat_amount_decimal: STRING</li><li>unit_amount: INTEGER</li><li>unit_amount_decimal: STRING</li><li>up_to: INTEGER</li></ul></li><li>tiers_mode: STRING</li><li>transform_quantity: OBJECT, which is also a nested data structure.											<ul><li>divide_by: INTEGER</li><li>round: STRING</li></ul></li><li>type: STRING</li><li>unit_amount: INTEGER</li><li>unit_amount_decimal: STRING</li></ul> |
| **quantity**<br><br><br>INTEGER |
| **start**<br><br><br>DATE-TIME |
| **status**<br><br><br>STRING |
| **subscription**<br><br><br>STRING |
| **tax\_percent**<br><br><br>NUMBER |
| **tax\_rates**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>country: STRING</li><li>created: DATE-TIME</li><li>description: STRING</li><li>display_name: STRING</li><li>id: STRING</li><li>inclusive: BOOLEAN</li><li>jurisdiction: STRING</li><li>livemode: BOOLEAN</li><li>metadata: OBJECT</li><li>object: STRING</li><li>percentage: NUMBER</li><li>state: STRING</li><li>tax_type: BOOLEAN</li></ul> |
| **trial\_end**<br><br><br>DATE-TIME |
| **trial\_start**<br><br><br>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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#plans).

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/Content/api/subscriptions)<br><br>[Stripe API method](https://stripe.com/Content/api/subscriptions/list "Opens in new tab: Stripe API method") |

subscriptions table foreign keys

| Join subscriptions with | on |
| --- | --- |
| [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#coupons) | ```<br>subscriptions.discount.coupon.id = coupons.id<br>``` |
| [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#customers) | ```<br>subscriptions.discount.coupon.id = customers.discount.coupon.id<br>```<br><br>```<br>subscriptions.customer = customers.id<br>```<br><br>```<br>subscriptions.customer = customers.cards.customer<br>```<br><br>```<br>subscriptions.customer = customers.discount.customer<br>```<br><br>```<br>subscriptions.id = customers.subscriptions<br>```<br><br>```<br>subscriptions.id = customers.discount.subscription<br>``` |
| [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoices) | ```<br>subscriptions.discount.coupon.id = invoices.discount.coupon.id<br>```<br><br>```<br>subscriptions.customer = invoices.customer<br>```<br><br>```<br>subscriptions.customer = invoices.discount.customer<br>```<br><br>```<br>subscriptions.id = invoices.subscription<br>```<br><br>```<br>subscriptions.id = invoices.discount.subscription<br>``` |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>subscriptions.customer = charges.customer<br>```<br><br>```<br>subscriptions.customer = charges.card.customer<br>``` |
| [invoice_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-items) | ```<br>subscriptions.customer = invoice_items.customer<br>```<br><br>```<br>subscriptions.plan.id = invoice_items.plan.id<br>```<br><br>```<br>subscriptions.plan.product = invoice_items.plan.product<br>```<br><br>```<br>subscriptions.items = invoice_items.subscription_item<br>```<br><br>```<br>subscriptions.id = invoice_items.subscription<br>``` |
| [subscription_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#subscription-items) | ```<br>subscriptions.customer = subscription_items.customer<br>```<br><br>```<br>subscriptions.plan.id = subscription_items.plan.id<br>```<br><br>```<br>subscriptions.plan.product = subscription_items.plan.product<br>```<br><br>```<br>subscriptions.items = subscription_items.id<br>```<br><br>```<br>subscriptions.id = subscription_items.subscription<br>``` |
| [plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#plans) | ```<br>subscriptions.plan.id = plans.id<br>```<br><br>```<br>subscriptions.plan.product = plans.product<br>``` |
| [invoice_line_items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#invoice-line-items) | ```<br>subscriptions.plan.product = invoice_line_items.plan.product<br>```<br><br>```<br>subscriptions.id = invoice_line_items.subscription<br>``` |
| [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#products) | ```<br>subscriptions.plan.product = products.id<br>``` |

subscriptions table schema

| **application\_fee\_percent**<br><br><br>NUMBER |
| --- |
| **billing**<br><br><br>STRING |
| **billing\_cycle\_anchor**<br><br><br>DATE-TIME |
| **billing\_thresholds**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount_gte: INTEGER</li><li>reset_billing_cycle_anchor: BOOLEAN</li></ul> |
| **cancel\_at**<br><br><br>DATE-TIME |
| **cancel\_at\_period\_end**<br><br><br>BOOLEAN |
| **canceled\_at**<br><br><br>DATE-TIME |
| **collection\_method**<br><br><br>STRING |
| **created**<br><br><br>DATE-TIME |
| **current\_period\_end**<br><br><br>DATE-TIME |
| **current\_period\_start**<br><br><br>DATE-TIME |
| **customer**<br><br><br>STRING |
| **days\_until\_due**<br><br><br>INTEGER |
| **default\_payment\_method**<br><br><br>STRING |
| **default\_source**<br><br><br>STRING |
| **discount**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>checkout_session: STRING</li><li>coupon: OBJECT, which is also a nested data structure.											<ul><li>amount_off: INTEGER</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>duration: STRING</li><li>duration_in_months: INTEGER</li><li>id: STRING</li><li>livemode: BOOLEAN</li><li>max_redemptions: INTEGER</li><li>metadata: OBJECT</li><li>name: STRING</li><li>object: STRING</li><li>percent_off: NUMBER</li><li>percent_off_precise: NUMBER</li><li>redeem_by: DATE-TIME</li><li>times_redeemed: INTEGER</li><li>valid: BOOLEAN</li></ul></li><li>customer: STRING</li><li>end: DATE-TIME</li><li>id: STRING</li><li>invoice: STRING</li><li>invoice_item: STRING</li><li>object: STRING</li><li>promotion_code: STRING</li><li>start: DATE-TIME</li><li>subscription: STRING</li></ul> |
| **ended\_at**<br><br><br>DATE-TIME |
| **id**<br><br><br>STRING |
| **invoice\_customer\_balance\_settings**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>consume_applied_balance_on_void: BOOLEAN</li></ul> |
| **items**<br><br><br>ARRAY |
| **latest\_invoice**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **next\_pending\_invoice\_item\_invoice**<br><br><br>DATE-TIME |
| **object**<br><br><br>STRING |
| **pause\_collection**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>behavior: STRING</li><li>resumes_at: DATE-TIME</li></ul> |
| **pending\_invoice\_item\_interval**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>interval: STRING</li><li>interval_count: INTEGER</li></ul> |
| **pending\_setup\_intent**<br><br><br>STRING |
| **plan**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>active: BOOLEAN</li><li>aggregate_usage: STRING</li><li>amount: INTEGER</li><li>billing_scheme: STRING</li><li>created: DATE-TIME</li><li>currency: STRING</li><li>id: STRING</li><li>interval: STRING</li><li>interval_count: INTEGER</li><li>livemode: BOOLEAN</li><li>metadata: OBJECT</li><li>name: STRING</li><li>nickname: STRING</li><li>object: STRING</li><li>product: STRING</li><li>statement_description: STRING</li><li>statement_descriptor: STRING</li><li>tiers: ARRAY, which is also a nested data structure.											<ul><li>flat_amount: INTEGER</li><li>unit_amount: INTEGER</li><li>up_to: INTEGER</li></ul></li><li>tiers_mode: STRING</li><li>transform_usage: OBJECT</li><li>trial_period_days: INTEGER</li><li>usage_type: STRING</li></ul> |
| **quantity**<br><br><br>INTEGER |
| **schedule**<br><br><br>STRING |
| **start**<br><br><br>DATE-TIME |
| **start\_date**<br><br><br>DATE-TIME |
| **status**<br><br><br>STRING |
| **tax\_percent**<br><br><br>NUMBER |
| **transfer\_data**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount_percent: NUMBER</li><li>destination: STRING</li></ul> |
| **trial\_end**<br><br><br>DATE-TIME |
| **trial\_start**<br><br><br>DATE-TIME |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>STRING |

### transfers

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

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | created |
| **Useful links** | Stripe documentation<br><br>[Stripe API method](https://stripe.com/Content/api/transfers/list "Opens in new tab: Stripe API method") |

transfers table foreign keys

| Join transfers with | on |
| --- | --- |
| [balance_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#balance-transactions) | ```<br>transfers.balance_transaction = balance_transactions.id<br>```<br><br>```<br>transfers.failure_balance_transaction = balance_transactions.id<br>``` |
| [charges](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#charges) | ```<br>transfers.balance_transaction = charges.balance_transaction<br>```<br><br>```<br>transfers.failure_balance_transaction = charges.balance_transaction<br>```<br><br>```<br>transfers.id = charges.source_transfer<br>``` |
| [payouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#payouts) | ```<br>transfers.balance_transaction = payouts.balance_transaction<br>```<br><br>```<br>transfers.failure_balance_transaction = payouts.balance_transaction<br>```<br><br>```<br>transfers.balance_transaction = payouts.failure_balance_transaction<br>```<br><br>```<br>transfers.failure_balance_transaction = payouts.failure_balance_transaction<br>``` |
| [disputes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Stripe-v2.htm#disputes) | ```<br>transfers.balance_transaction = disputes.balance_transactions.id<br>```<br><br>```<br>transfers.failure_balance_transaction = disputes.balance_transactions.id<br>``` |

transfers table schema

| **amount**<br><br><br>INTEGER |
| --- |
| **amount\_reversed**<br><br><br>INTEGER |
| **arrival\_date**<br><br><br>DATE-TIME |
| **automatic**<br><br><br>BOOLEAN |
| **balance\_transaction**<br><br><br>STRING |
| **created**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **date**<br><br><br>DATE-TIME |
| **description**<br><br><br>STRING |
| **destination**<br><br><br>STRING |
| **failure\_balance\_transaction**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT |
| **object**<br><br><br>STRING |
| **recipient**<br><br><br>STRING |
| **reversals**<br><br><br>ARRAY |
| **reversed**<br><br><br>BOOLEAN |
| **source\_transaction**<br><br><br>STRING |
| **source\_type**<br><br><br>STRING |
| **statement\_description**<br><br><br>STRING |
| **statement\_descriptor**<br><br><br>STRING |
| **transfer\_group**<br><br><br>STRING |
| **updated**<br><br><br>DATE-TIME |
| **updated\_by\_event\_type**<br><br><br>STRING |