# Stripe (v3)

Information note **Stripe extraction is supported by Stitch**   
This integration is powered by [Singer's](https://www.singer.io/) Stripe tap and certified by Stitch. [Check out and contribute to the repo on GitHub](https://github.com/singer-io/tap-stripe).  
  
For support, contact [Support](https://community.qlik.com/t5/Support/ct-p/qlikSupport).

## Stripe integration summary

Stitch’s Stripe integration replicates data using the [Stripe REST API](https://stripe.com/docs/api). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#schema) section for a list of objects available for replication.

## Stripe feature snapshot

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

| **STITCH** |  |  |  |
| --- | --- | --- | --- |
| **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Released on August 29, 2023 | **Supported by**<br><br>the Info icon<br><br>Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| **Stitch plan**<br><br>the Info icon<br><br>The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**<br><br>the Info icon<br><br>Indicates if the integration is available as a source in Stitch Connect. | the Success icon<br><br>This version of the integration is available via the API.<br><br><br>Available |
| **Singer GitHub repository** | [singer-io/tap-stripe](https://github.com/singer-io/tap-stripe) |  |  |
| **REPLICATION SETTINGS** |  |  |  |
| **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**<br><br>the Info icon<br><br>A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**<br><br>the Info icon<br><br>A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **Table-level reset**<br><br>the Info icon<br><br>Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon<br><br>Table-level resets are not supported for this integration. Resets are only supported at the integration level.<br><br><br>Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**<br><br>the Info icon<br><br>Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon<br><br>Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.<br><br><br>Unsupported |
| **DATA SELECTION** |  |  |  |
| **Table selection**<br><br>the Info icon<br><br>The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | **Column selection**<br><br>the Info icon<br><br>The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **Select all**<br><br>the Info icon<br><br>Indicates if the integration supports selecting all available tables and columns. | the Success icon<br><br>Supported<br><br><br>Supported |  |  |
| **TRANSPARENCY** |  |  |  |
| **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**<br><br>the Info icon<br><br>Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**<br><br>the Info icon<br><br>Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |

## Connecting Stripe

### Stripe setup requirements

To set up Stripe in Stitch, you need:

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

### Step 1: Add Stripe as a Stitch data source

1. [Sign into your Stitch account](https://app.stitchdata.com/).

2. On the Stitch Dashboard page, click the **Add Integration** button.

3. Click the **Stripe** icon.

4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

   For example, the name “Stitch Stripe” would create a schema called `stitch_stripe` in the destination. **Note**: Schema names cannot be changed after you save the integration.

5. In the **Lookback window** field, enter the number of historical days’ worth of data you would like to replicate from the start date. The maximum lookback period is 600 days. This field is optional. Head to the [Lookback windows and data extraction](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#lookback-windows-extraction) section to learn more about this.

### Step 2: Define the historical replication start date

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

Change this setting if you want to replicate data beyond Stripe’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide.

### Step 3: Create a replication schedule

Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information.

In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Stripe integrations support the following replication scheduling methods:

* [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency)

* [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)

* [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage.

### Step 4: Authorize Stitch to access Stripe

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

### Step 5: Set objects to replicate

Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements).

The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#schema)

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

* Selection options
* Individual tables and columns
* All tables and columns

For Stripe integrations, you can select:

1. **Individual tables and columns**

2. **All tables and columns**

Click the tabs to view instructions for each selection method.

1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate.

2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate.

3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate.

4. Repeat this process for all the tables and columns you want to replicate.

5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections.

Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature.

1. Click into the integration from the Stitch Dashboard page.

2. Click the **Tables to Replicate** tab.

3. In the list of tables, click the box next to the **Table Names** column.

4. In the menu that displays, click **Track all Tables and Fields**:

   ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab

5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections.

### Initial and historical replication jobs

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

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

Information note

**Initial replication jobs with Anchor Scheduling**

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information.

#### Free historical data loads

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

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

## Stripe replication

### Events table replication

Stripe will only provide 30 days of historical event data for the `events` table. Refer the the [Stripe docs](https://stripe.com/docs/api/events) for more information about the `events` table.

### Objects and events

In the Stripe API, there are two concepts:

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

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

* A table for **events**, which contains all events that have occurred for Stripe’s [supported event types](https://stripe.com/docs/api/events/types). This table acts as a history for an object record, showing how it has been changed over time.
* Tables for **objects**, which contains the latest version of records. These are tables like [`customers`](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#customers), [`charges`](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#charges), [`invoices`](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#invoices), etc.

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

#### Example event and object data replication over time

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

[![Example showing how event and invoice records are replicated as an invoice changes over time](https://help.qlik.com/en-US/stitch/images/integrations/stripe-events.svg)Example showing how event and invoice records are replicated as an invoice changes over timeExample showing how event and invoice records are replicated as an invoice changes over time](https://help.qlik.com/en-US/stitch/images/integrations/stripe-events.svg)

### Lookback windows and data extraction

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

While Stitch replicates data in this way to account for updates to records made during the lookback window, it can have a [substantial impact on your overall row usage](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#lookback-window-row-count-impact).

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

* Historical and full re-replications
* Ongoing replications

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

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

`Start Date - Lookback Window = Minimum Extraction Date`

**Example**

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

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

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

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

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

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

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

**Example**

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

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

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

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

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

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

## Stripe table reference

Information note

**Schemas and versioning**

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

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

This is the latest version of the Stripe integration.

Information note

**Table and column names in your destination**

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

For example: Object names are lowercased in Redshift (`CusTomERs` &gt; `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` &gt; `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info.

### balance\_transactions

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

| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/balance/balance_transaction "Opens in new tab: Stripe documentation")<br><br><br>[balance_transactions schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/balance_transactions.json "Opens in new tab: balance_transactions schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#charges) | ```<br>balance_transactions.id = charges.balance_transaction<br>``` |
| [payouts](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand fee\_details<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								application							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/charges/object "Opens in new tab: Stripe documentation")<br><br><br>[charges schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/charges.json "Opens in new tab: charges schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#balance-transactions) | ```<br>charges.balance_transaction = balance_transactions.id<br>``` |
| [payouts](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand billing\_details<br><br><table> <tr> <td> <p> <strong>								address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand card<br><br><table> <tr> <td> <p> <strong>								address_city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_state							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								brand							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cvc_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								dynamic_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								exp_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								exp_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								funding							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tokenization_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand fraud\_details<br><br><table> <tr> <td> <p> <strong>								stripe_report							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **id**<br><br><br>STRING |
| **invoice**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand outcome<br><br><table> <tr> <td> <p> <strong>								network_status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								reason							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								risk_level							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								risk_score							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								seller_message							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand payment\_method\_details<br><br><table> <tr> <td> <p> <strong>								ach_credit_transfer							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand ach_credit_transfer</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								account_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bank_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								routing_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								swift_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								ach_debit							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand ach_debit</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								account_holder_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bank_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								routing_number							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								alipay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								bancontact							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand bancontact</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								bank_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bank_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bic							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								iban_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								preferred_language							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_name							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								card							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand card</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address_city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_state							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								brand							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								card_present							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand card_present</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								brand							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								emv_auth_data							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								exp_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								exp_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								funding							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								generated_card							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								network							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								read_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								receipt							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand receipt</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								application_cryptogram							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								application_preferred_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								authorization_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								authorization_response_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cardholder_verification_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								dedicated_file_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								terminal_verification_results							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transaction_status_information							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								checks							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand checks</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address_line1_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_postal_code_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cvc_check							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cvc_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								dynamic_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								eps							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand eps</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								verified_name							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								exp_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								exp_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								funding							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								giropay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand giropay</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								bank_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bank_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bic							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_name							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								ideal							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand ideal</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								bank							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bic							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								iban_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_name							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								installments							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand installments</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								plan							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand plan</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								klarna							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								multibanco							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand multibanco</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								entity							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								reference							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								network							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								p24							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand p24</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								reference							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_name							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								sepa_debit							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand sepa_debit</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								bank_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								branch_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								mandate							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								sofort							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand sofort</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								bank_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bank_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bic							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								iban_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_name							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								stripe_account							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								three_d_secure							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand three_d_secure</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								authenticated							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								succeeded							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								version							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								tokenization_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								wallet							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand wallet</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amex_express_checkout							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								apple_pay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								dynamic_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								google_pay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								masterpass							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand masterpass</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								billing_address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand billing_address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								shipping_address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shipping_address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								samsung_pay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								visa_checkout							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand visa_checkout</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								billing_address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand billing_address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								shipping_address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand shipping_address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								wechat							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								card_present							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand card_present</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount_authorized							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								brand							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cardholder_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								emv_auth_data							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								exp_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								exp_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								funding							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								generated_card							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								network							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								overcapture_supported							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								read_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								receipt							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand receipt</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								account_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								application_cryptogram							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								application_preferred_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								authorization_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								authorization_response_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cardholder_verification_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								dedicated_file_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								terminal_verification_results							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transaction_status_information							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand refunds<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								balance_transaction							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								charge							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								failure_reason							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								instructions_email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								next_action							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand next_action</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								display_details							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand display_details</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								email_sent							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand email_sent</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								email_sent_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								email_sent_to							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								expires_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								payment_intent							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								reason							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								receipt_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								source_transfer_reversal							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transfer_reversal							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **review**<br><br><br>STRING |
| **shipping**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **source**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand source<br><br><table> <tr> <td> <p> <strong>								ach_credit_transfer							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand ach_credit_transfer</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								account_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bank_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_account_holder_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_account_holder_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_account_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_routing_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								routing_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								swift_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								address_city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_state							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								alipay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								bancontact							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								brand							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								card							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand card</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address_line1_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								brand							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cvc_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								dynamic_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								exp_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								exp_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								funding							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								three_d_secure							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tokenization_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								client_secret							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cvc_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								dynamic_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								eps							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								exp_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								exp_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								flow							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								funding							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								ideal							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								multibanco							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								owner							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand owner</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_address							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_phone							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								receiver							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand receiver</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								amount_charged							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_received							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_returned							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								refund_attributes_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_attributes_status							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								redirect							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand redirect</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								failure_reason							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								return_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								url							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								statement_descriptor							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tokenization_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand transfer\_data<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								destination							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/coupons "Opens in new tab: Stripe documentation")<br><br><br>[coupons schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/coupons.json "Opens in new tab: coupons schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#customers) | ```<br>coupons.id = customers.discount.coupon.id<br>``` |
| [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#invoices) | ```<br>coupons.id = invoices.discount.coupon.id<br>``` |
| [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/customers/object "Opens in new tab: Stripe documentation")<br><br><br>[customers schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/customers.json "Opens in new tab: customers schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#coupons) | ```<br>customers.discount.coupon.id = coupons.id<br>``` |
| [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand address<br><br><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **balance**<br><br><br>INTEGER |
| **cards**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand cards<br><br><table> <tr> <td> <p> <strong>								address_city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_state							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								brand							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cvc_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								dynamic_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								exp_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								exp_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								funding							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tokenization_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand discount<br><br><table> <tr> <td> <p> <strong>								checkout_session							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								coupon							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand coupon</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount_off							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								duration							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								duration_in_months							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								max_redemptions							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								percent_off							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								percent_off_precise							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								redeem_by							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								times_redeemed							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								valid							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								customer							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								end							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								invoice							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								invoice_item							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								promotion_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								start							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								subscription							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand invoice\_settings<br><br><table> <tr> <td> <p> <strong>								custom_fields							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								default_payment_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								footer							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **shipping**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand shipping<br><br><table> <tr> <td> <p> <strong>								address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **sources**<br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand sources<br><br><table> <tr> <td> <p> <strong>								ach_credit_transfer							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand ach_credit_transfer</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								account_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bank_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_account_holder_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_account_holder_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_account_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_routing_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								routing_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								swift_code							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								address_city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line1_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_state							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								alipay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								bancontact							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								brand							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								card							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand card</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address_line1_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								address_zip_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								brand							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cvc_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								dynamic_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								exp_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								exp_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								funding							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								three_d_secure							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tokenization_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								client_secret							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cvc_check							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								dynamic_last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								eps							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								exp_month							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								exp_year							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								flow							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								funding							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								ideal							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								multibanco							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								owner							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand owner</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_address							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_phone							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								receiver							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand receiver</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								address							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								amount_charged							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_received							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_returned							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								refund_attributes_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_attributes_status							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								redirect							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand redirect</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								failure_reason							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								return_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								url							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								statement_descriptor							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tokenization_method							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table><br><br>["TYPE", ["NULL", "STRING"]] |
| **subscriptions**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **tax\_exempt**<br><br><br>STRING |
| **tax\_ids**<br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand tax\_ids<br><br><table> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								customer							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verification							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand verification</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_address							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								verified_name							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table><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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/disputes/object "Opens in new tab: Stripe documentation")<br><br><br>[disputes schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/disputes.json "Opens in new tab: disputes schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#balance-transactions) | ```<br>disputes.balance_transactions.id = balance_transactions.id<br>``` |
| [charges](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand balance\_transactions<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand evidence<br><br><table> <tr> <td> <p> <strong>								access_activity_log							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								billing_address							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cancellation_policy							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cancellation_policy_disclosure							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								cancellation_rebuttal							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_communication							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_email_address							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_purchase_ip							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								customer_signature							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								duplicate_charge_documentation							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								duplicate_charge_explanation							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								duplicate_charge_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								product_description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								receipt							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_policy							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_policy_disclosure							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								refund_refusal_explanation							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								service_date							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								service_documentation							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								shipping_address							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								shipping_carrier							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								shipping_date							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								shipping_documentation							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								shipping_tracking_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								uncategorized_file							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								uncategorized_text							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **evidence\_details**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand evidence\_details<br><br><table> <tr> <td> <p> <strong>								due_by							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								has_evidence							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								past_due							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								submission_count							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **id**<br><br><br>STRING |
| **is\_charge\_refundable**<br><br><br>BOOLEAN |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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/docs/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/stitch/integrations/saas/stripe#replication) section. Additionally, refer to [Stripe’s documentation](https://stripe.com/docs/api/events/types) for info about event types and the objects they describe.

| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/events "Opens in new tab: Stripe documentation")<br><br><br>[events schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/events.json "Opens in new tab: events schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date |
| **Useful links** | [Stripe documentation](https://help.qlik.com/en-US/stitch/integrations/saas/stripe "Opens in new tab: Stripe documentation")<br><br><br>[invoice_items schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/invoice_items.json "Opens in new tab: invoice_items schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **id**<br><br><br>STRING |
| **invoice**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **object**<br><br><br>STRING |
| **period**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand period<br><br><table> <tr> <td> <p> <strong>								end							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								start							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> </table> |
| **plan**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand plan<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								aggregate_usage							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_decimal							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								billing_scheme							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval_count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								nickname							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								product							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								statement_description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								statement_descriptor							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tiers							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tiers</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								flat_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								up_to							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								tiers_mode							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transform_usage							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								trial_period_days							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								updated							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								updated_by_event_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								usage_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand tax\_rates<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								display_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								inclusive							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								jurisdiction							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								percentage							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id<br><br>invoice |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/invoices/line_item "Opens in new tab: Stripe documentation")<br><br><br>[invoice_line_items schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/invoice_line_items.json "Opens in new tab: invoice_line_items schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#charges) | ```<br>invoice_line_items.invoice = charges.invoice<br>``` |
| [invoice_items](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#plans) | ```<br>invoice_line_items.plan.product = plans.product<br>``` |
| [products](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#products) | ```<br>invoice_line_items.plan.product = products.id<br>``` |
| [subscription_items](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand discount\_amounts<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								discount							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **discountable**<br><br><br>BOOLEAN |
| **discounts**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **object**<br><br><br>STRING |
| **period**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand period<br><br><table> <tr> <td> <p> <strong>								end							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								start							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> </table> |
| **plan**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand plan<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								aggregate_usage							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_decimal							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								billing_scheme							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval_count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								nickname							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								product							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								statement_description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								statement_descriptor							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tiers							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tiers</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								flat_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								up_to							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								tiers_mode							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transform_usage							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								trial_period_days							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								updated							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								updated_by_event_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								usage_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **price**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand price<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								billing_scheme							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								lookup_key							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								nickname							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								product							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								recurring							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand recurring</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								aggregate_usage							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval_count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								usage_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								tax_behavior							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tiers							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tiers</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								flat_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								flat_amount_decimal							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount_decimal							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								up_to							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								tiers_mode							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transform_quantity							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand transform_quantity</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								divide_by							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								round							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount_decimal							</strong> </p> <p>							NUMBER													</p> </td> </tr> </table> |
| **proration**<br><br><br>BOOLEAN |
| **proration\_details**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand tax\_amounts<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								inclusive							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								tax_rate							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **tax\_rates**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand tax\_rates<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								display_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								inclusive							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								jurisdiction							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								percentage							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_type							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table> |
| **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/stitch/integrations/saas/stripe#invoice_line_items) table. To replicate these records, you must set this table and the `invoice_line_items` table to replicate.

| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/invoices "Opens in new tab: Stripe documentation")<br><br><br>[invoices schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/invoices.json "Opens in new tab: invoices schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#disputes) | ```<br>invoices.charge = disputes.charge<br>``` |
| [coupons](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#coupons) | ```<br>invoices.discount.coupon.id = coupons.id<br>``` |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand automatic\_tax<br><br><table> <tr> <td> <p> <strong>								enabled							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand custom\_fields<br><br><table> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **customer**<br><br><br>STRING |
| **customer\_address**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand customer\_address<br><br><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand customer\_shipping<br><br><table> <tr> <td> <p> <strong>								address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **customer\_tax\_exempt**<br><br><br>STRING |
| **customer\_tax\_ids**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand customer\_tax\_ids<br><br><table> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								value							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand default\_tax\_rates<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								display_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								inclusive							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								jurisdiction							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								percentage							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **description**<br><br><br>STRING |
| **discount**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand discount<br><br><table> <tr> <td> <p> <strong>								checkout_session							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								coupon							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand coupon</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount_off							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								duration							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								duration_in_months							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								max_redemptions							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								percent_off							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								percent_off_precise							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								redeem_by							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								times_redeemed							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								valid							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								customer							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								end							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								invoice							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								invoice_item							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								promotion_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								start							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								subscription							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **discounts**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand last\_finalization\_error<br><br><table> <tr> <td> <p> <strong>								code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								doc_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								message							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								param							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								payment_method_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **lines**<br><br><br>ARRAY, OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand payment\_settings<br><br><table> <tr> <td> <p> <strong>								payment_method_options							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand payment_method_options</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								acss_debit							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand acss_debit</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								mandate_options							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand mandate_options</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								transaction_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								verification_method							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								bancontact							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand bancontact</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								preferred_language							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								card							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand card</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								request_three_d_secure							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								payment_method_types							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> </table> |
| **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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand status\_transitions<br><br><table> <tr> <td> <p> <strong>								finalized_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								marked_uncollectible_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								paid_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								voided_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> </table> |
| **subscription**<br><br><br>STRING |
| **subscription\_details**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand subscription\_details<br><br><table> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand total\_discount\_amounts<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								discount							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **total\_tax\_amounts**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand total\_tax\_amounts<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								inclusive							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								tax_rate							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **transfer\_data**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand transfer\_data<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								destination							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/payments/payment-intents "Opens in new tab: Stripe documentation")<br><br><br>[payment_intents schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/payment_intents.json "Opens in new tab: payment_intents schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand automatic\_payment\_methods<br><br><table> <tr> <td> <p> <strong>								enabled							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand last\_payment\_error<br><br><table> <tr> <td> <p> <strong>								charge							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								decline_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								doc_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								message							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								param							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								payment_method_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **latest\_charge**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **next\_action**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand next\_action<br><br><table> <tr> <td> <p> <strong>								alipay_handle_redirect							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand alipay_handle_redirect</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								native_data							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								native_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								return_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								url							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								boleto_display_details							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand boleto_display_details</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								expires_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								hosted_voucher_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								pdf							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								oxxo_display_details							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand oxxo_display_details</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								expires_after							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								hosted_voucher_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								number							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								redirect_to_url							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand redirect_to_url</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								return_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								url							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								use_stripe_sdk							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								verify_with_microdeposits							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand verify_with_microdeposits</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								arrival_date							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								hosted_verification_url							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								wechat_pay_display_qr_code							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand wechat_pay_display_qr_code</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								data							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								image_data_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								image_url_png							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								image_url_svg							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								wechat_pay_redirect_to_android_app							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand wechat_pay_redirect_to_android_app</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								app_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								nonce_str							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								package							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								partner_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								prepay_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								sign							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								timestamp							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								wechat_pay_redirect_to_ios_app							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand wechat_pay_redirect_to_ios_app</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								native_url							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand payment\_method\_options<br><br><table> <tr> <td> <p> <strong>								acss_debit							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand acss_debit</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								mandate_options							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand mandate_options</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								custom_mandate_url							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval_description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								payment_schedule							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transaction_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								afterpay_clearpay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand afterpay_clearpay</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								reference							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								alipay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand alipay</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								au_becs_debit							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand au_becs_debit</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								bacs_debit							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand bacs_debit</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								bancontact							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand bancontact</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								preferred_language							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								boleto							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand boleto</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								expires_after_days							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								card							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand card</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								installments							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand installments</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								available_plans							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand available_plans</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								enabled							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								plan							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand plan</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								network							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								request_three_d_secure							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								card_present							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								eps							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand eps</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								fps							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand fps</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								giropay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand giropay</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								grabpay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand grabpay</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								ideal							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand ideal</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								interac_present							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								klarna							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand klarna</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								preferred_locale							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								oxxo							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand oxxo</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								expires_after_days							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								p24							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand p24</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								sepa_debit							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand sepa_debit</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								mandate_options							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								sofort							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand sofort</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								preferred_language							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								wechat_pay							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand wechat_pay</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								app_id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								client							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								setup_future_usage							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table> |
| **payment\_method\_types**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **processing**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand shipping<br><br><table> <tr> <td> <p> <strong>								address							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand address</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								city							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line1							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								line2							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								postal_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								carrier							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								phone							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tracking_number							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand transfer\_data<br><br><table> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								destination							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/payouts "Opens in new tab: Stripe documentation")<br><br><br>[payout_transactions schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/payout_transactions.json "Opens in new tab: payout_transactions schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/payouts "Opens in new tab: Stripe documentation")<br><br><br>[payouts schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/payouts.json "Opens in new tab: payouts schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand bank\_account<br><br><table> <tr> <td> <p> <strong>								account_holder_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								account_holder_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								bank_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								fingerprint							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								last4							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								routing_number							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								status							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/plans "Opens in new tab: Stripe documentation")<br><br><br>[plans schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/plans.json "Opens in new tab: plans schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#invoice-line-items) | ```<br>plans.product = invoice_line_items.plan.product<br>``` |
| [products](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand tiers<br><br><table> <tr> <td> <p> <strong>								flat_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								up_to							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **tiers\_mode**<br><br><br>STRING |
| **transform\_usage**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/products "Opens in new tab: Stripe documentation")<br><br><br>[products schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/products.json "Opens in new tab: products schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#invoice-items) | ```<br>products.id = invoice_items.plan.product<br>``` |
| [invoice_line_items](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#invoice-line-items) | ```<br>products.id = invoice_line_items.plan.product<br>``` |
| [plans](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#plans) | ```<br>products.id = plans.product<br>``` |
| [subscription_items](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#subscription-items) | ```<br>products.id = subscription_items.plan.product<br>``` |
| [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#subscriptions) | ```<br>products.id = subscriptions.plan.product<br>``` |

products table schema

| **active**<br><br><br>BOOLEAN |
| --- |
| **attributes**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **caption**<br><br><br>STRING |
| **created**<br><br><br>DATE-TIME |
| **deactivate\_on**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **description**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **images**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **name**<br><br><br>STRING |
| **object**<br><br><br>STRING |
| **package\_dimensions**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand package\_dimensions<br><br><table> <tr> <td> <p> <strong>								height							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								length							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								weight							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								width							</strong> </p> <p>							NUMBER													</p> </td> </tr> </table> |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/subscription_items "Opens in new tab: Stripe documentation")<br><br><br>[subscription_items schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/subscription_items.json "Opens in new tab: subscription_items schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand billing\_thresholds<br><br><table> <tr> <td> <p> <strong>								usage_gte							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **ended\_at**<br><br><br>DATE-TIME |
| **id**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **object**<br><br><br>STRING |
| **plan**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand plan<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								aggregate_usage							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								amount_decimal							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								billing_scheme							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval_count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								nickname							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								product							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								statement_description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								statement_descriptor							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tiers							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tiers</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								flat_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								up_to							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								tiers_mode							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transform_usage							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								trial_period_days							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								updated							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								updated_by_event_type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								usage_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **price**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand price<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								billing_scheme							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								lookup_key							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								nickname							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								product							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								recurring							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand recurring</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								aggregate_usage							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval_count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								usage_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								tax_behavior							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tiers							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tiers</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								flat_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								flat_amount_decimal							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount_decimal							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								up_to							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								tiers_mode							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transform_quantity							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand transform_quantity</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								divide_by							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								round							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount_decimal							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand tax\_rates<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								country							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								display_name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								inclusive							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								jurisdiction							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								percentage							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								state							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tax_type							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table> |
| **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/stitch/integrations/saas/stripe#plans).

| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://stripe.com/docs/api/subscriptions "Opens in new tab: Stripe documentation")<br><br><br>[subscriptions schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/subscriptions.json "Opens in new tab: subscriptions schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#coupons) | ```<br>subscriptions.discount.coupon.id = coupons.id<br>``` |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#charges) | ```<br>subscriptions.customer = charges.customer<br>```<br><br>```<br>subscriptions.customer = charges.card.customer<br>``` |
| [invoice_items](https://help.qlik.com/en-US/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand billing\_thresholds<br><br><table> <tr> <td> <p> <strong>								amount_gte							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								reset_billing_cycle_anchor							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand discount<br><br><table> <tr> <td> <p> <strong>								checkout_session							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								coupon							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand coupon</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								amount_off							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								duration							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								duration_in_months							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								max_redemptions							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								percent_off							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								percent_off_precise							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								redeem_by							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								times_redeemed							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								valid							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								customer							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								end							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								invoice							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								invoice_item							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								promotion_code							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								start							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								subscription							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand invoice\_customer\_balance\_settings<br><br><table> <tr> <td> <p> <strong>								consume_applied_balance_on_void							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table> |
| **items**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **latest\_invoice**<br><br><br>STRING |
| **livemode**<br><br><br>BOOLEAN |
| **metadata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand pause\_collection<br><br><table> <tr> <td> <p> <strong>								behavior							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								resumes_at							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> </table> |
| **pending\_invoice\_item\_interval**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand pending\_invoice\_item\_interval<br><br><table> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval_count							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **pending\_setup\_intent**<br><br><br>STRING |
| **plan**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand plan<br><br><table> <tr> <td> <p> <strong>								active							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								aggregate_usage							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								billing_scheme							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								created							</strong> </p> <p>							DATE-TIME													</p> </td> </tr> <tr> <td> <p> <strong>								currency							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								id							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								interval_count							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								livemode							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								metadata							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								name							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								nickname							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								object							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								product							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								statement_description							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								statement_descriptor							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								tiers							</strong> </p> <p>							ARRAY																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand tiers</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								flat_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								unit_amount							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								up_to							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								tiers_mode							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								transform_usage							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								trial_period_days							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								usage_type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand transfer\_data<br><br><table> <tr> <td> <p> <strong>								amount_percent							</strong> </p> <p>							NUMBER													</p> </td> </tr> <tr> <td> <p> <strong>								destination							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created |
| **Useful links** | [Stripe documentation](https://help.qlik.com/en-US/stitch/integrations/saas/stripe "Opens in new tab: Stripe documentation")<br><br><br>[transfers schema on GitHub](https://github.com/singer-io/tap-stripe/tree/master/tap_stripe/schemas/transfers.json "Opens in new tab: transfers schema on GitHub")<br><br><br>[Stripe API method](https://stripe.com/docs/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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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/stitch/integrations/saas/stripe#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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **object**<br><br><br>STRING |
| **recipient**<br><br><br>STRING |
| **reversals**<br><br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 |