# Square

Square is a large business technology platform serving all kinds of businesses. The Square operating system allows business owners to sell anywhere.

Square integration replicates data using the [Square API version 2023-06-08](https://developer.squareup.com/reference/square).

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

## Preparing for authentication

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

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

You must have administrator permissions for your Square Developer account.

Connections from Qlik Talend Cloud to the Square Sandbox instance are not currently supported.

To obtain your application ID and application secret:

1. Log into your [Square Developer](https://app.squareup.com/signup?country_code=fr&v=developers) account.
2. Click + to create an app.
3. Enter a name for your app.
4. In the left navigation bar, select OAuth, and then select Production.
5. Set Production Redirect URL to https://connector.qlik.com/auth/oauth/v3.htm.
6. On the OAuth > Production page, copy your application ID and application secret into a secured file.

## Creating the connection

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

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

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

   A window is displayed with an authentication code.

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

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

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

   When status is Verified, the authentication is verified.

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

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

Connection settings

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

## Schema

Information note

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

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

### bank\_accounts

The `bank_accounts` contains information about a merchant’s bank account in Square.

**Note**: This table can’t be replicated if the **Connect to a sandbox environment** box is checked in the [integration’s settings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#add-stitch-data-source) due to limits imposed by Square.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/bank-accounts-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/bank-accounts-api/get-bank-account "Opens in new tab: Square API method") |

bank\_accounts table foreign keys

| Join bank\_accounts with | on |
| --- | --- |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>bank_accounts.id = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>bank_accounts.id = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>bank_accounts.id = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>bank_accounts.id = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>bank_accounts.id = items.absent_at_location_ids<br>```<br><br>```<br>bank_accounts.id = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>bank_accounts.id = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>bank_accounts.id = items.present_at_location_ids<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>bank_accounts.id = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>bank_accounts.id = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>bank_accounts.id = orders.id<br>```<br><br>```<br>bank_accounts.id = orders.refunds.id<br>```<br><br>```<br>bank_accounts.id = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>bank_accounts.id = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>bank_accounts.id = refunds.id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>bank_accounts.id = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>bank_accounts.id = taxes.absent_at_location_ids<br>``` |

bank\_accounts table schema

| **account\_number\_suffix**<br><br><br>STRING |
| --- |
| **account\_type**<br><br><br>STRING |
| **bank\_name**<br><br><br>STRING |
| **country**<br><br><br>STRING |
| **creditable**<br><br><br>BOOLEAN |
| **currency**<br><br><br>STRING |
| **debit\_mandate\_reference\_id**<br><br><br>STRING |
| **debitable**<br><br><br>BOOLEAN |
| **holder\_name**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **location\_id**<br><br><br>STRING |
| **primary\_bank\_identification\_number**<br><br><br>STRING |
| **reference\_id**<br><br><br>STRING |
| **secondary\_bank\_identification\_number**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **version**<br><br><br>INTEGER |

### cash\_drawer\_shifts

The `cash_drawer_shifts` table contains infomration about cash transactions in Square.

| **Replication Method** | Full Table |
| --- | --- |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/cash-drawers-api/retrieve-cash-drawer-shift#response-body)<br><br>[Square API method](https://developer.squareup.com/reference/square/cash-drawers-api/retrieve-cash-drawer-shift "Opens in new tab: Square API method") |

cash\_drawer\_shifts table schema

| **closed\_at**<br><br><br>DATE-TIME |
| --- |
| **closed\_cash\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **created\_at**<br><br><br>DATE-TIME |
| **description**<br><br><br>STRING |
| **ended\_at**<br><br><br>DATE-TIME |
| **expected\_cash\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **location\_id**<br><br><br>STRING |
| **opened\_at**<br><br><br>DATE-TIME |
| **opened\_cash\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **state**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |

### categories

The `categories` table contains information about item categories for a given location in Square.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | updated\_at |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/catalog-api/v1-list-categories)<br><br>[Square API method](https://developer.squareup.com/reference/square/catalog-api/list-catalog "Opens in new tab: Square API method") |

categories table foreign keys

| Join categories with | on |
| --- | --- |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>categories.id = items.item_data.category_id<br>```<br><br>```<br>categories.absent_at_location_ids = items.absent_at_location_ids<br>```<br><br>```<br>categories.absent_at_location_ids = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>categories.absent_at_location_ids = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>categories.absent_at_location_ids = items.present_at_location_ids<br>``` |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>categories.absent_at_location_ids = bank_accounts.id<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>categories.absent_at_location_ids = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>categories.absent_at_location_ids = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>categories.absent_at_location_ids = inventories.location_id<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>categories.absent_at_location_ids = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>categories.absent_at_location_ids = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>categories.absent_at_location_ids = orders.id<br>```<br><br>```<br>categories.absent_at_location_ids = orders.refunds.id<br>```<br><br>```<br>categories.absent_at_location_ids = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>categories.absent_at_location_ids = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>categories.absent_at_location_ids = refunds.id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>categories.absent_at_location_ids = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>categories.absent_at_location_ids = taxes.absent_at_location_ids<br>``` |

categories table schema

| **absent\_at\_location\_ids**<br><br><br>ARRAY |
| --- |
| **category\_data**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>name: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **is\_deleted**<br><br><br>BOOLEAN |
| **present\_at\_all\_locations**<br><br><br>BOOLEAN |
| **type**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |
| **version**<br><br><br>INTEGER |

### customers

The `customers` contains information about customer profiles associated with your Square account.

| **Replication Method** | CDC |
| --- | --- |
| **Replication Key** | updated\_at |
| **Useful links** | [Square API method](https://developer.squareup.com/reference/square/customers-api/list-customers "Opens in new tab: Square API method") |

customers table schema

| **address**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>address_line_1: STRING</li><li>address_line_2: STRING</li><li>address_line_3: STRING</li><li>administrative_district_level_1: STRING</li><li>administrative_district_level_2: STRING</li><li>administrative_district_level_3: STRING</li><li>country: STRING</li><li>first_name: STRING</li><li>last_name: STRING</li><li>locality: STRING</li><li>postal_code: STRING</li><li>sublocality: STRING</li><li>sublocality_2: STRING</li><li>sublocality_3: STRING</li></ul> |
| --- |
| **birthday**<br><br>DATE-TIME<br><br>STRING |
| **company\_name**<br><br><br>STRING |
| **created\_at**<br><br><br>DATE-TIME |
| **creation\_source**<br><br><br>STRING |
| **email\_address**<br><br><br>STRING |
| **family\_name**<br><br><br>STRING |
| **given\_name**<br><br><br>STRING |
| **group\_ids**<br><br><br>ARRAY |
| **id**<br><br><br>STRING |
| **nickname**<br><br><br>STRING |
| **note**<br><br><br>STRING |
| **phone\_number**<br><br><br>STRING |
| **preferences**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>email_unsubscribed: BOOLEAN</li></ul> |
| **reference\_id**<br><br><br>STRING |
| **segment\_ids**<br><br><br>ARRAY |
| **tax\_ids**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>eu_vat: STRING</li></ul> |
| **updated\_at**<br><br><br>DATE-TIME |
| **version**<br><br><br>INTEGER |

### discounts

The `discounts` table contains information about discounts for a given location in Square.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | updated\_at |
| **Useful links** | [Square API method](https://developer.squareup.com/reference/square/catalog-api/list-catalog "Opens in new tab: Square API method") |

discounts table foreign keys

| Join discounts with | on |
| --- | --- |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>discounts.absent_at_location_ids = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>discounts.absent_at_location_ids = categories.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>discounts.absent_at_location_ids = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>discounts.absent_at_location_ids = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>discounts.absent_at_location_ids = items.absent_at_location_ids<br>```<br><br>```<br>discounts.absent_at_location_ids = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>discounts.absent_at_location_ids = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>discounts.absent_at_location_ids = items.present_at_location_ids<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>discounts.absent_at_location_ids = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>discounts.absent_at_location_ids = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>discounts.absent_at_location_ids = orders.id<br>```<br><br>```<br>discounts.absent_at_location_ids = orders.refunds.id<br>```<br><br>```<br>discounts.absent_at_location_ids = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>discounts.absent_at_location_ids = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>discounts.absent_at_location_ids = refunds.id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>discounts.absent_at_location_ids = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>discounts.absent_at_location_ids = taxes.absent_at_location_ids<br>``` |

discounts table schema

| **absent\_at\_location\_ids**<br><br><br>ARRAY |
| --- |
| **discount\_data**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>application_method: STRING</li><li>discount_type: STRING</li><li>label_color: STRING</li><li>modify_tax_basis: STRING</li><li>name: STRING</li><li>percentage: STRING</li><li>pin_required: BOOLEAN</li></ul> |
| **id**<br><br><br>STRING |
| **is\_deleted**<br><br><br>BOOLEAN |
| **present\_at\_all\_locations**<br><br><br>BOOLEAN |
| **type**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |
| **version**<br><br><br>INTEGER |

### inventories

The `inventories` table contains info about the current calculated stock count for a Square location.

| **Replication Method** | Full Table |
| --- | --- |
| **Loading Behavior** | Append-Only |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/inventory-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/inventory-api/retrieve-inventory-count "Opens in new tab: Square API method") |

inventories table foreign keys

| Join inventories with | on |
| --- | --- |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>inventories.location_id = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>inventories.location_id = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>inventories.location_id = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>inventories.location_id = team_members.assigned_locations.location_ids<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>inventories.location_id = items.absent_at_location_ids<br>```<br><br>```<br>inventories.location_id = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>inventories.location_id = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>inventories.location_id = items.present_at_location_ids<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>inventories.location_id = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>inventories.location_id = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>inventories.location_id = orders.id<br>```<br><br>```<br>inventories.location_id = orders.refunds.id<br>```<br><br>```<br>inventories.location_id = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>inventories.location_id = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>inventories.location_id = refunds.id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>inventories.location_id = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>inventories.location_id = taxes.absent_at_location_ids<br>``` |

inventories table schema

| **calculated\_at**<br><br><br>DATE-TIME |
| --- |
| **catalog\_object\_id**<br><br><br>STRING |
| **catalog\_object\_type**<br><br><br>STRING |
| **location\_id**<br><br><br>STRING |
| **quantity**<br><br><br>STRING |
| **state**<br><br><br>STRING |

### items

The `items` table contains information about items for a given location in Square.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | updated\_at |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/catalog-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/catalog-api/list-catalog "Opens in new tab: Square API method") |

items table foreign keys

| Join items with | on |
| --- | --- |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>items.item_data.category_id = categories.id<br>```<br><br>```<br>items.absent_at_location_ids = categories.absent_at_location_ids<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = categories.absent_at_location_ids<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = categories.absent_at_location_ids<br>```<br><br>```<br>items.present_at_location_ids = categories.absent_at_location_ids<br>``` |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>items.absent_at_location_ids = bank_accounts.id<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = bank_accounts.id<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = bank_accounts.id<br>```<br><br>```<br>items.present_at_location_ids = bank_accounts.id<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>items.absent_at_location_ids = discounts.absent_at_location_ids<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = discounts.absent_at_location_ids<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = discounts.absent_at_location_ids<br>```<br><br>```<br>items.present_at_location_ids = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>items.absent_at_location_ids = team_members.assigned_locations.location_ids<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = team_members.assigned_locations.location_ids<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = team_members.assigned_locations.location_ids<br>```<br><br>```<br>items.present_at_location_ids = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>items.absent_at_location_ids = inventories.location_id<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = inventories.location_id<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = inventories.location_id<br>```<br><br>```<br>items.present_at_location_ids = inventories.location_id<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>items.absent_at_location_ids = locations.id<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = locations.id<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = locations.id<br>```<br><br>```<br>items.present_at_location_ids = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>items.absent_at_location_ids = modifier_lists.absent_at_location_ids<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = modifier_lists.absent_at_location_ids<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = modifier_lists.absent_at_location_ids<br>```<br><br>```<br>items.present_at_location_ids = modifier_lists.absent_at_location_ids<br>```<br><br>```<br>items.item_data.modifier_list_info.modifier_list_id = modifier_lists.id<br>```<br><br>```<br>items.item_data.modifier_list_info.modifier_list_id = modifier_lists.modifier_list_data.modifiers.modifier_data.modifier_list_id<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>items.absent_at_location_ids = orders.id<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = orders.id<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = orders.id<br>```<br><br>```<br>items.present_at_location_ids = orders.id<br>```<br><br>```<br>items.absent_at_location_ids = orders.refunds.id<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = orders.refunds.id<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = orders.refunds.id<br>```<br><br>```<br>items.present_at_location_ids = orders.refunds.id<br>```<br><br>```<br>items.absent_at_location_ids = orders.tenders.id<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = orders.tenders.id<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = orders.tenders.id<br>```<br><br>```<br>items.present_at_location_ids = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>items.absent_at_location_ids = payments.id<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = payments.id<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = payments.id<br>```<br><br>```<br>items.present_at_location_ids = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>items.absent_at_location_ids = refunds.id<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = refunds.id<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = refunds.id<br>```<br><br>```<br>items.present_at_location_ids = refunds.id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>items.absent_at_location_ids = shifts.id<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = shifts.id<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = shifts.id<br>```<br><br>```<br>items.present_at_location_ids = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>items.absent_at_location_ids = taxes.absent_at_location_ids<br>```<br><br>```<br>items.item_data.variations.item_variation_data.location_overrides.location_id = taxes.absent_at_location_ids<br>```<br><br>```<br>items.item_data.variations.present_at_location_ids = taxes.absent_at_location_ids<br>```<br><br>```<br>items.present_at_location_ids = taxes.absent_at_location_ids<br>```<br><br>```<br>items.item_data.tax_ids = taxes.id<br>``` |

items table schema

| **absent\_at\_location\_ids**<br><br><br>ARRAY |
| --- |
| **id**<br><br><br>STRING |
| **is\_deleted**<br><br><br>BOOLEAN |
| **item\_data**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>abbreviation: STRING</li><li>available_electronically: BOOLEAN</li><li>available_for_pickup: BOOLEAN</li><li>available_online: BOOLEAN</li><li>category_id: STRING</li><li>description: STRING</li><li>item_options: ARRAY, which is also a nested data structure.											<ul><li>item_option_id: STRING</li></ul></li><li>label_color: STRING</li><li>legacy_tax_ids: ARRAY</li><li>modifier_list_info: ARRAY, which is also a nested data structure.											<ul><li>enabled: BOOLEAN</li><li>modifier_list_id: STRING</li></ul></li><li>name: STRING</li><li>product_type: STRING</li><li>skip_modifier_screen: BOOLEAN</li><li>tax_ids: ARRAY</li><li>variations: ARRAY, which is also a nested data structure.											<ul><li>id: STRING</li><li>is_deleted: BOOLEAN</li><li>item_variation_data: OBJECT, which is also a nested data structure.													<ul><li>inventory_alert_type: STRING</li><li>item_id: STRING</li><li>location_overrides: ARRAY, which is also a nested data structure.															<ul><li>inventory_alert_threshold: INTEGER</li><li>inventory_alert_type: STRING</li><li>location_id: STRING</li><li>sold_out: BOOLEAN</li><li>track_inventory: BOOLEAN</li></ul></li><li>name: STRING</li><li>ordinal: INTEGER</li><li>price_money: OBJECT, which is also a nested data structure.															<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>pricing_type: STRING</li><li>sku: STRING</li><li>track_inventory: BOOLEAN</li><li>user_data: STRING</li></ul></li><li>present_at_all_locations: BOOLEAN</li><li>present_at_location_ids: ARRAY</li><li>type: STRING</li><li>updated_at: DATE-TIME</li><li>version: INTEGER</li></ul></li><li>visibility: STRING</li></ul> |
| **present\_at\_all\_locations**<br><br><br>BOOLEAN |
| **present\_at\_location\_ids**<br><br><br>ARRAY |
| **type**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |
| **version**<br><br><br>INTEGER |

### locations

The `locations` table contains information about all of your business locations in Square.

| **Replication Method** | Full Table |
| --- | --- |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/locations-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/locations-api/list-locations "Opens in new tab: Square API method") |

locations table foreign keys

| Join locations with | on |
| --- | --- |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>locations.id = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>locations.id = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>locations.id = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>locations.id = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>locations.id = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>locations.id = items.absent_at_location_ids<br>```<br><br>```<br>locations.id = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>locations.id = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>locations.id = items.present_at_location_ids<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>locations.id = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>locations.id = orders.id<br>```<br><br>```<br>locations.id = orders.refunds.id<br>```<br><br>```<br>locations.id = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>locations.id = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>locations.id = refunds.id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>locations.id = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>locations.id = taxes.absent_at_location_ids<br>``` |

locations table schema

| **address**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>address_line_1: STRING</li><li>address_line_2: STRING</li><li>address_line_3: STRING</li><li>administrative_district_level_1: STRING</li><li>administrative_district_level_2: STRING</li><li>administrative_district_level_3: STRING</li><li>country: STRING</li><li>first_name: STRING</li><li>last_name: STRING</li><li>locality: STRING</li><li>postal_code: STRING</li><li>sublocality: STRING</li><li>sublocality_2: STRING</li><li>sublocality_3: STRING</li></ul> |
| --- |
| **business\_email**<br><br><br>STRING |
| **business\_hours**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>periods: ARRAY, which is also a nested data structure.											<ul><li>day_of_week: STRING</li><li>end_local_time: STRING</li><li>start_local_time: STRING</li></ul></li></ul> |
| **business\_name**<br><br><br>STRING |
| **capabilities**<br><br><br>ARRAY |
| **coordinates**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>latitude: NUMBER</li><li>longitude: NUMBER</li></ul> |
| **country**<br><br><br>STRING |
| **created\_at**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **description**<br><br><br>STRING |
| **facebook\_url**<br><br><br>STRING |
| **full\_format\_logo\_url**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **instagram\_username**<br><br><br>STRING |
| **language\_code**<br><br><br>STRING |
| **logo\_url**<br><br><br>STRING |
| **mcc**<br><br><br>STRING |
| **merchant\_id**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **phone\_number**<br><br><br>STRING |
| **pos\_background\_url**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **timezone**<br><br><br>STRING |
| **twitter\_username**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **website\_url**<br><br><br>STRING |

### modifier\_lists

The `modifier_lists` table contains information about modifier lists for a given location in Square.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | updated\_at |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/catalog-api/v1-list-modifier-lists)<br><br>[Square API method](https://developer.squareup.com/reference/square/catalog-api/list-catalog "Opens in new tab: Square API method") |

modifier\_lists table foreign keys

| Join modifier\_lists with | on |
| --- | --- |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>modifier_lists.absent_at_location_ids = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>modifier_lists.absent_at_location_ids = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>modifier_lists.absent_at_location_ids = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>modifier_lists.absent_at_location_ids = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>modifier_lists.absent_at_location_ids = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>modifier_lists.absent_at_location_ids = items.absent_at_location_ids<br>```<br><br>```<br>modifier_lists.absent_at_location_ids = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>modifier_lists.absent_at_location_ids = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>modifier_lists.absent_at_location_ids = items.present_at_location_ids<br>```<br><br>```<br>modifier_lists.id = items.item_data.modifier_list_info.modifier_list_id<br>```<br><br>```<br>modifier_lists.modifier_list_data.modifiers.modifier_data.modifier_list_id = items.item_data.modifier_list_info.modifier_list_id<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>modifier_lists.absent_at_location_ids = locations.id<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>modifier_lists.absent_at_location_ids = orders.id<br>```<br><br>```<br>modifier_lists.absent_at_location_ids = orders.refunds.id<br>```<br><br>```<br>modifier_lists.absent_at_location_ids = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>modifier_lists.absent_at_location_ids = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>modifier_lists.absent_at_location_ids = refunds.id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>modifier_lists.absent_at_location_ids = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>modifier_lists.absent_at_location_ids = taxes.absent_at_location_ids<br>``` |

modifier\_lists table schema

| **absent\_at\_location\_ids**<br><br><br>ARRAY |
| --- |
| **id**<br><br><br>STRING |
| **is\_deleted**<br><br><br>BOOLEAN |
| **modifier\_list\_data**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>modifiers: ARRAY, which is also a nested data structure.											<ul><li>id: STRING</li><li>is_deleted: BOOLEAN</li><li>modifier_data: OBJECT, which is also a nested data structure.													<ul><li>modifier_list_id: STRING</li><li>name: STRING</li><li>on_by_default: BOOLEAN</li><li>ordinal: INTEGER</li><li>price_money: OBJECT, which is also a nested data structure.															<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul></li><li>present_at_all_locations: BOOLEAN</li><li>type: STRING</li><li>updated_at: DATE-TIME</li><li>version: INTEGER</li></ul></li><li>name: STRING</li><li>ordinal: INTEGER</li><li>selection_type: STRING</li></ul> |
| **present\_at\_all\_locations**<br><br><br>BOOLEAN |
| **type**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |
| **version**<br><br><br>INTEGER |

### orders

The `orders` table contains information about order updates in Square.

| **Replication Method** | CDC |
| --- | --- |
| **Replication Key** | updated\_at |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/orders-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/orders-api/search-orders "Opens in new tab: Square API method") |

orders table foreign keys

| Join orders with | on |
| --- | --- |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>orders.id = bank_accounts.id<br>```<br><br>```<br>orders.refunds.id = bank_accounts.id<br>```<br><br>```<br>orders.tenders.id = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>orders.id = categories.absent_at_location_ids<br>```<br><br>```<br>orders.refunds.id = categories.absent_at_location_ids<br>```<br><br>```<br>orders.tenders.id = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>orders.id = discounts.absent_at_location_ids<br>```<br><br>```<br>orders.refunds.id = discounts.absent_at_location_ids<br>```<br><br>```<br>orders.tenders.id = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>orders.id = team_members.assigned_locations.location_ids<br>```<br><br>```<br>orders.refunds.id = team_members.assigned_locations.location_ids<br>```<br><br>```<br>orders.tenders.id = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>orders.id = inventories.location_id<br>```<br><br>```<br>orders.refunds.id = inventories.location_id<br>```<br><br>```<br>orders.tenders.id = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>orders.id = items.absent_at_location_ids<br>```<br><br>```<br>orders.refunds.id = items.absent_at_location_ids<br>```<br><br>```<br>orders.tenders.id = items.absent_at_location_ids<br>```<br><br>```<br>orders.id = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>orders.refunds.id = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>orders.tenders.id = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>orders.id = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>orders.refunds.id = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>orders.tenders.id = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>orders.id = items.present_at_location_ids<br>```<br><br>```<br>orders.refunds.id = items.present_at_location_ids<br>```<br><br>```<br>orders.tenders.id = items.present_at_location_ids<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>orders.id = locations.id<br>```<br><br>```<br>orders.refunds.id = locations.id<br>```<br><br>```<br>orders.tenders.id = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>orders.id = modifier_lists.absent_at_location_ids<br>```<br><br>```<br>orders.refunds.id = modifier_lists.absent_at_location_ids<br>```<br><br>```<br>orders.tenders.id = modifier_lists.absent_at_location_ids<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>orders.id = payments.id<br>```<br><br>```<br>orders.refunds.id = payments.id<br>```<br><br>```<br>orders.tenders.id = payments.id<br>```<br><br>```<br>orders.id = payments.order_id<br>```<br><br>```<br>orders.returns.source_order_id = payments.order_id<br>```<br><br>```<br>orders.refunds.id = payments.order_id<br>```<br><br>```<br>orders.refunds.id = payments.refund_ids<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>orders.id = refunds.id<br>```<br><br>```<br>orders.refunds.id = refunds.id<br>```<br><br>```<br>orders.tenders.id = refunds.id<br>```<br><br>```<br>orders.id = refunds.order_id<br>```<br><br>```<br>orders.returns.source_order_id = refunds.order_id<br>```<br><br>```<br>orders.tenders.id = refunds.payment_id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>orders.id = shifts.id<br>```<br><br>```<br>orders.refunds.id = shifts.id<br>```<br><br>```<br>orders.tenders.id = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>orders.id = taxes.absent_at_location_ids<br>```<br><br>```<br>orders.refunds.id = taxes.absent_at_location_ids<br>```<br><br>```<br>orders.tenders.id = taxes.absent_at_location_ids<br>``` |

orders table schema

| **closed\_at**<br><br><br>DATE-TIME |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **discounts**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>applied_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>name: STRING</li><li>percentage: STRING</li><li>pricing_rule_id: STRING</li><li>scope: STRING</li><li>type: STRING</li></ul> |
| **fulfillments**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>pickup_details: OBJECT, which is also a nested data structure.											<ul><li>accepted_at: DATE-TIME</li><li>auto_complete_duration: STRING</li><li>cancel_reason: STRING</li><li>canceled_at: DATE-TIME</li><li>expired_at: DATE-TIME</li><li>expires_at: DATE-TIME</li><li>note: STRING</li><li>picked_up_at: DATE-TIME</li><li>pickup_at: DATE-TIME</li><li>pickup_window_duration: STRING</li><li>placed_at: DATE-TIME</li><li>prep_time_duration: STRING</li><li>ready_at: DATE-TIME</li><li>recipient: OBJECT, which is also a nested data structure.													<ul><li>customer_id: STRING</li><li>display_name: STRING</li><li>email_address: STRING</li><li>phone_number: STRING</li></ul></li><li>rejected_at: DATE-TIME</li><li>schedule_type: STRING</li></ul></li><li>state: STRING</li><li>type: STRING</li><li>uid: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **line\_items**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>base_price_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>gross_sales_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>item_type: STRING</li><li>modifiers: ARRAY, which is also a nested data structure.											<ul><li>base_price_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>name: STRING</li><li>quantity: STRING</li><li>total_price_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul></li><li>name: STRING</li><li>note: STRING</li><li>quantity: STRING</li><li>quantity_unit: OBJECT, which is also a nested data structure.											<ul><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>measurement_unit: OBJECT, which is also a nested data structure.													<ul><li>area_unit: STRING</li><li>custom_unit: OBJECT, which is also a nested data structure.															<ul><li>abbreviation: STRING</li><li>name: STRING</li></ul></li><li>generic_unit: STRING</li><li>length_unit: STRING</li><li>time_unit: STRING</li><li>type: STRING</li><li>volume_unit: STRING</li><li>weight_unit: STRING</li></ul></li><li>precision: INTEGER</li></ul></li><li>total_discount_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_tax_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>uid: STRING</li><li>variation_name: STRING</li><li>variation_total_price_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul> |
| **location\_id**<br><br><br>STRING |
| **net\_amount\_due\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **net\_amounts**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>discount_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>service_charge_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>tax_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>tip_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul> |
| **pricing\_options**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>auto_apply_discounts: BOOLEAN</li></ul> |
| **reference\_id**<br><br><br>STRING |
| **refunds**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>created_at: DATE-TIME</li><li>id: STRING</li><li>location_id: STRING</li><li>processing_fee_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>reason: STRING</li><li>status: STRING</li><li>tender_id: STRING</li><li>transaction_id: STRING</li></ul> |
| **return\_amounts**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>discount_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>service_charge_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>tax_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>tip_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul> |
| **returns**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>return_amounts: OBJECT, which is also a nested data structure.											<ul><li>discount_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>service_charge_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>tax_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>tip_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul></li><li>return_discounts: ARRAY, which is also a nested data structure.											<ul><li>amount_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>applied_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>name: STRING</li><li>percentage: STRING</li><li>scope: STRING</li><li>source_discount_uid: STRING</li><li>type: STRING</li><li>uid: STRING</li></ul></li><li>return_line_items: ARRAY, which is also a nested data structure.											<ul><li>applied_discounts: ARRAY, which is also a nested data structure.													<ul><li>applied_money: OBJECT, which is also a nested data structure.															<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>discount_uid: STRING</li><li>uid: STRING</li></ul></li><li>applied_service_charges: ARRAY, which is also a nested data structure.													<ul><li>applied_money: OBJECT, which is also a nested data structure.															<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>service_charge_uid: STRING</li><li>uid: STRING</li></ul></li><li>applied_taxes: ARRAY, which is also a nested data structure.													<ul><li>applied_money: OBJECT, which is also a nested data structure.															<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>tax_uid: STRING</li><li>uid: STRING</li></ul></li><li>base_price_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>gross_return_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>item_type: STRING</li><li>name: STRING</li><li>note: STRING</li><li>quantity: STRING</li><li>quantity_unit: OBJECT, which is also a nested data structure.													<ul><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>measurement_unit: OBJECT, which is also a nested data structure.															<ul><li>area_unit: STRING</li><li>custom_unit: OBJECT, which is also a nested data structure.																	<ul><li>abbreviation: STRING</li><li>name: STRING</li></ul></li><li>generic_unit: STRING</li><li>length_unit: STRING</li><li>time_unit: STRING</li><li>type: STRING</li><li>volume_unit: STRING</li><li>weight_unit: STRING</li></ul></li><li>precision: INTEGER</li></ul></li><li>return_modifiers: ARRAY, which is also a nested data structure.													<ul><li>base_price_money: OBJECT, which is also a nested data structure.															<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>name: STRING</li><li>quantity: STRING</li><li>source_modifier_uid: STRING</li><li>total_price_money: OBJECT, which is also a nested data structure.																													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>uid: STRING</li></ul></li><li>source_line_item_uid: STRING</li><li>total_discount_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_service_charge_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_tax_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>uid: STRING</li><li>variation_name: STRING</li><li>variation_total_price_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul></li><li>return_service_charges: ARRAY, which is also a nested data structure.											<ul><li>amount_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>applied_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>calculation_phase: STRING</li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>name: STRING</li><li>percentage: STRING</li><li>source_service_charge_uid: STRING</li><li>taxable: BOOLEAN</li><li>total_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_tax_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul></li><li>return_taxes: ARRAY, which is also a nested data structure.											<ul><li>applied_money: OBJECT, which is also a nested data structure.</li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>name: STRING</li><li>percentage: STRING</li><li>scope: STRING</li><li>source_tax_uid: STRING</li><li>type: STRING</li><li>uid: STRING</li></ul></li><li>rounding_adjustment: OBJECT, which is also a nested data structure.											<ul><li>amount_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>name: STRING</li><li>uid: STRING</li></ul></li><li>source_order_id: STRING</li><li>uid: STRING</li></ul> |
| **service\_charges**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>applied_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>calculation_phase: STRING</li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>name: STRING</li><li>percentage: STRING</li><li>taxable: BOOLEAN</li><li>total_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>total_tax_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>type: STRING</li></ul> |
| **source**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>name: STRING</li></ul> |
| **state**<br><br><br>STRING |
| **taxes**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>applied_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>catalog_object_id: STRING</li><li>catalog_version: INTEGER</li><li>name: STRING</li><li>percentage: STRING</li><li>scope: STRING</li><li>type: STRING</li></ul> |
| **tenders**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>card_details: OBJECT, which is also a nested data structure.											<ul><li>card: OBJECT, which is also a nested data structure.													<ul><li>billing_address: OBJECT, which is also a nested data structure.															<ul><li>address_line_1: STRING</li><li>address_line_2: STRING</li><li>address_line_3: STRING</li><li>administrative_district_level_1: STRING</li><li>administrative_district_level_2: STRING</li><li>administrative_district_level_3: STRING</li><li>country: STRING</li><li>first_name: STRING</li><li>last_name: STRING</li><li>locality: STRING</li><li>postal_code: STRING</li><li>sublocality: STRING</li><li>sublocality_2: STRING</li><li>sublocality_3: STRING</li></ul></li><li>bin: STRING</li><li>card_brand: STRING</li><li>card_co_brand: STRING</li><li>card_type: STRING</li><li>cardholder_name: STRING</li><li>customer_id: STRING</li><li>enabled: BOOLEAN</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>id: STRING</li><li>last_4: STRING</li><li>merchant_id: STRING</li><li>prepaid_type: STRING</li><li>reference_id: STRING</li><li>version: INTEGER</li></ul></li><li>entry_method: STRING</li><li>status: STRING</li></ul></li><li>cash_details: OBJECT, which is also a nested data structure.											<ul><li>buyer_tendered_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>change_back_money: OBJECT, which is also a nested data structure.													<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul></li><li>created_at: DATE-TIME</li><li>customer_id: STRING</li><li>id: STRING</li><li>location_id: STRING</li><li>note: STRING</li><li>payment_id: STRING</li><li>processing_fee_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>tip_money: OBJECT, which is also a nested data structure.											<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>transaction_id: STRING</li><li>type: STRING</li></ul> |
| **total\_discount\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **total\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **total\_service\_charge\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **total\_tax\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **total\_tip\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **updated\_at**<br><br><br>DATE-TIME |
| **version**<br><br><br>INTEGER |

### payments

The `payments` table contains information about all payments taken in Square.

| **Replication Method** | Full Table |
| --- | --- |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/payments-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/payments-api/list-payments "Opens in new tab: Square API method") |

payments table foreign keys

| Join payments with | on |
| --- | --- |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>payments.id = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>payments.id = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>payments.id = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>payments.id = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>payments.id = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>payments.id = items.absent_at_location_ids<br>```<br><br>```<br>payments.id = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>payments.id = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>payments.id = items.present_at_location_ids<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>payments.id = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>payments.id = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>payments.id = orders.id<br>```<br><br>```<br>payments.id = orders.refunds.id<br>```<br><br>```<br>payments.id = orders.tenders.id<br>```<br><br>```<br>payments.order_id = orders.id<br>```<br><br>```<br>payments.order_id = orders.returns.source_order_id<br>```<br><br>```<br>payments.order_id = orders.refunds.id<br>```<br><br>```<br>payments.refund_ids = orders.refunds.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>payments.id = refunds.id<br>```<br><br>```<br>payments.order_id = refunds.order_id<br>```<br><br>```<br>payments.id = refunds.payment_id<br>```<br><br>```<br>payments.order_id = refunds.id<br>```<br><br>```<br>payments.refund_ids = refunds.id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>payments.id = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>payments.id = taxes.absent_at_location_ids<br>``` |

payments table schema

| **amount\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| --- |
| **app\_fee\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **application\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>application_id: STRING</li><li>square_product: STRING</li></ul> |
| **approved\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **bank\_account\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>account_ownership_type: STRING</li><li>ach_details: OBJECT, which is also a nested data structure.            <ul><li>account_number_suffix: STRING</li><li>account_type: STRING</li><li>routing_number: STRIN</li></ul></li><li>bank_name: STRING</li><li>country: STRING</li><li>errors: ARRAY, which is also a nested data structure.            <ul><li>category: STRING</li><li>code: STRING</li><li>detail: STRING</li><li>field: STRING</li></ul></li><li>fingerprint: STRING</li><li>statement_description: STRING</li><li>transfer_type: STRING</li></ul> |
| **billing\_address**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>address_line_1: STRING</li><li>address_line_2: STRING</li><li>address_line_3: STRING</li><li>administrative_district_level_1: STRING</li><li>administrative_district_level_2: STRING</li><li>administrative_district_level_3: STRING</li><li>country: STRING</li><li>first_name: STRING</li><li>last_name: STRING</li><li>locality: STRING</li><li>postal_code: STRING</li><li>sublocality: STRING</li><li>sublocality_2: STRING</li><li>sublocality_3: STRING</li></ul> |
| **buy\_now\_pay\_later\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>afterpay_details: OBJECT, which is also a nested data structure.            <ul><li>email_address: STRING</li></ul></li><li>brand: STRING</li><li>clearpay_details: OBJECT, which is also a nested data structure.            <ul><li>email_address: STRING</li></ul></li></ul> |
| **buyer\_email\_address**<br><br><br>STRING |
| **capabilities**<br><br><br>ARRAY |
| **card\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>application_cryptogram: STRING</li><li>application_identifier: STRING</li><li>application_name: STRING</li><li>auth_result_code: STRING</li><li>avs_status: STRING</li><li>card: OBJECT, which is also a nested data structure.            <ul><li>billing_address: OBJECT, which is also a nested data structure.</li><li>bin: STRING</li><li>card_brand: STRING</li><li>card_co_brand: STRING</li><li>card_type: STRING</li><li>cardholder_name: STRING</li><li>customer_id: STRING</li><li>enabled: BOOLEAN</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>id: STRING</li><li>last_4: STRING</li><li>merchant_id: STRING</li><li>prepaid_type: STRING</li><li>reference_id: STRING</li><li>version: INTEGER</li></ul></li><li>card_payment_timeline: OBJECT, which is also a nested data structure.            <ul><li>authorized_at: DATE-TIME</li><li>captured_at: DATE-TIME</li><li>voided_at: DATE-TIME</li></ul></li><li>cvv_status: STRING</li><li>entry_method: STRING</li><li>errors: ARRAY, which is also a nested data structure.            <ul><li>category: STRING</li><li>code: STRING</li><li>detail: STRING</li><li>field: STRING</li></ul></li><li>statement_description: STRING</li><li>status: STRING</li><li>verification_method: STRING</li><li>verification_results: STRING</li></ul> |
| **cash\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>buyer_supplied_money: OBJECT, which is also a nested data structure.            <ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>change_back_money: OBJECT, which is also a nested data structure.<ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li></ul> |
| **created\_at**<br><br><br>DATE-TIME |
| **customer\_id**<br><br><br>STRING |
| **delay\_action**<br><br><br>STRING |
| **delay\_duration**<br><br><br>STRING |
| **delayed\_until**<br><br><br>DATE-TIME |
| **device\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>device_id: STRING</li><li>device_installation_id: STRING</li><li>device_name: STRING</li></ul> |
| **external\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>source: STRING</li><li>source_fee_money: OBJECT, which is also a nested data structure.            <ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>source_id: STRING</li><li>type: STRING</li></ul> |
| **id**<br><br><br>STRING |
| **location\_id**<br><br><br>STRING |
| **note**<br><br><br>STRING |
| **order\_id**<br><br><br>STRING |
| **processing\_fee**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount_money: OBJECT, which is also a nested data structure.            <ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>effective_at: DATE-TIME</li><li>type: STRING</li></ul> |
| **receipt\_number**<br><br><br>STRING |
| **receipt\_url**<br><br><br>STRING |
| **reference\_id**<br><br><br>STRING |
| **refund\_ids**<br><br><br>ARRAY |
| **refunded\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **risk\_evaluation**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>created_at: DATE-TIME</li><li>risk_level: STRING</li></ul> |
| **shipping\_address**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>address_line_1: STRING</li><li>address_line_2: STRING</li><li>address_line_3: STRING</li><li>administrative_district_level_1: STRING</li><li>administrative_district_level_2: STRING</li><li>administrative_district_level_3: STRING</li><li>country: STRING</li><li>first_name: STRING</li><li>last_name: STRING</li><li>locality: STRING</li><li>postal_code: STRING</li><li>sublocality: STRING</li><li>sublocality_2: STRING</li><li>sublocality_3: STRING</li></ul> |
| **source\_type**<br><br><br>STRING |
| **statement\_description\_identifier**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **team\_member\_id**<br><br><br>STRING |
| **tip\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **total\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **updated\_at**<br><br><br>DATE-TIME |
| **version\_token**<br><br><br>STRING |
| **wallet\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>brand: STRING</li><li>cash_app_details: OBJECT, which is also a nested data structure.            <ul><li>buyer_cashtag: STRING</li><li>buyer_country_code: STRING</li><li>buyer_full_name: STRING</li></ul></li><li>status: STRING</li></ul> |

### payouts

The `payouts` table contains information about all payouts made in Square.

| **Replication Method** | Full Table |
| --- | --- |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/payouts-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/payouts-api/list-payouts "Opens in new tab: Square API method") |

payouts table schema

| **amount\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| --- |
| **arrival\_date**<br><br><br>DATE-TIME |
| **created\_at**<br><br><br>DATE-TIME |
| **destination**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>id: STRING</li><li>type: STRING</li></ul> |
| **end\_to\_end\_id**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **location\_id**<br><br><br>STRING |
| **payout\_fee**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount_money: OBJECT, which is also a nested data structure.            <ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>effective_at: DATE-TIME</li><li>type: STRING</li></ul> |
| **status**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |
| **version**<br><br><br>INTEGER |

### refunds

The `refunds` table contains information about refunds on items in Square.

| **Replication Method** | Full Table |
| --- | --- |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/refunds-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/refunds-api/list-payment-refunds "Opens in new tab: Square API method") |

refunds table foreign keys

| Join refunds with | on |
| --- | --- |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>refunds.id = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>refunds.id = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>refunds.id = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>refunds.id = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>refunds.id = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>refunds.id = items.absent_at_location_ids<br>```<br><br>```<br>refunds.id = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>refunds.id = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>refunds.id = items.present_at_location_ids<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>refunds.id = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>refunds.id = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>refunds.id = orders.id<br>```<br><br>```<br>refunds.id = orders.refunds.id<br>```<br><br>```<br>refunds.id = orders.tenders.id<br>```<br><br>```<br>refunds.order_id = orders.id<br>```<br><br>```<br>refunds.order_id = orders.returns.source_order_id<br>```<br><br>```<br>refunds.payment_id = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>refunds.id = payments.id<br>```<br><br>```<br>refunds.order_id = payments.order_id<br>```<br><br>```<br>refunds.payment_id = payments.id<br>```<br><br>```<br>refunds.id = payments.order_id<br>```<br><br>```<br>refunds.id = payments.refund_ids<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>refunds.id = shifts.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>refunds.id = taxes.absent_at_location_ids<br>``` |

refunds table schema

| **amount\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| --- |
| **app\_fee\_money**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>amount: INTEGER</li><li>currency: STRING</li></ul> |
| **created\_at**<br><br><br>DATE-TIME |
| **destination\_details**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>card_details: OBJECT, which is also a nested data structure.                        <ul><li>card: OBJECT, which is also a nested data structure.                                <ul><li>billing_address: OBJECT, which is also a nested data structure.                                        <ul><li>address_line_1: STRING</li><li>address_line_2: STRING</li><li>address_line_3: STRING</li><li>administrative_district_level_1: STRING</li><li>administrative_district_level_2: STRING</li><li>administrative_district_level_3: STRING</li><li>country: STRING</li><li>first_name: STRING</li><li>last_name: STRING</li><li>locality: STRING</li><li>postal_code: STRING</li><li>sublocality: STRING</li><li>sublocality_2: STRING</li><li>sublocality_3: STRING</li></ul></li><li>bin: STRING</li><li>card_brand: STRING</li><li>card_co_brand: STRING</li><li>card_type: STRING</li><li>cardholder_name: STRING</li><li>customer_id: STRING</li><li>enabled: BOOLEAN</li><li>exp_month: INTEGER</li><li>exp_year: INTEGER</li><li>fingerprint: STRING</li><li>id: STRING</li><li>last_4: STRING</li><li>merchant_id: STRING</li><li>prepaid_type: STRING</li><li>reference_id: STRING</li><li>version: INTEGER</li></ul></li><li>entry_method: STRING</li></ul></li></ul> |
| **destination\_type**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **location\_id**<br><br><br>STRING |
| **order\_id**<br><br><br>STRING |
| **payment\_id**<br><br><br>STRING |
| **processing\_fee**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>amount_money: OBJECT, which is also a nested data structure.            <ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>effective_at: DATE-TIME</li><li>type: STRING</li></ul> |
| **reason**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **team\_member\_id**<br><br><br>STRING |
| **unlinked**<br><br><br>BOOLEAN |
| **updated\_at**<br><br><br>DATE-TIME |

### roles

The `roles` table contains information about employees’ roles in Square.

**Note**: This table can’t be replicated if the **Connect to a sandbox environment** box is checked in the [integration’s settings](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#add-stitch-data-source) due to limits imposed by Square.

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/employees-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/employees-api/v1-list-employee-roles "Opens in new tab: Square API method") |

roles table schema

| **created\_at**<br><br><br>DATE-TIME |
| --- |
| **id**<br><br><br>STRING |
| **is\_owner**<br><br><br>BOOLEAN |
| **name**<br><br><br>STRING |
| **permissions**<br><br><br>ARRAY |
| **updated\_at**<br><br><br>DATE-TIME |

### shifts

The `shifts` table contains information about employee’s shifts in Square.

| **Replication Method** | CDC |
| --- | --- |
| **Replication Key** | updated\_at |
| **Useful links** | [Square documentation](https://developer.squareup.com/reference/square/labor-api)<br><br>[Square API method](https://developer.squareup.com/reference/square/labor-api/search-shifts "Opens in new tab: Square API method") |

shifts table foreign keys

| Join shifts with | on |
| --- | --- |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>shifts.team_member_id = team_members.id<br>```<br><br>```<br>shifts.id = team_members.assigned_locations.location_ids<br>``` |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>shifts.id = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>shifts.id = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>shifts.id = discounts.absent_at_location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>shifts.id = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>shifts.id = items.absent_at_location_ids<br>```<br><br>```<br>shifts.id = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>shifts.id = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>shifts.id = items.present_at_location_ids<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>shifts.id = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>shifts.id = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>shifts.id = orders.id<br>```<br><br>```<br>shifts.id = orders.refunds.id<br>```<br><br>```<br>shifts.id = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>shifts.id = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>shifts.id = refunds.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>shifts.id = taxes.absent_at_location_ids<br>``` |

shifts table schema

| **breaks**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>break_type_id: STRING</li><li>end_at: DATE-TIME</li><li>expected_duration: STRING</li><li>id: STRING</li><li>is_paid: BOOLEAN</li><li>name: STRING</li><li>start_at: DATE-TIME</li></ul> |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **end\_at**<br><br><br>DATE-TIME |
| **id**<br><br><br>STRING |
| **location\_id**<br><br><br>STRING |
| **start\_at**<br><br><br>DATE-TIME |
| **status**<br><br><br>STRING |
| **team\_member\_id**<br><br><br>STRING |
| **timezone**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |
| **version**<br><br><br>INTEGER |
| **wage**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>hourly_rate: OBJECT, which is also a nested data structure.            <ul><li>amount: INTEGER</li><li>currency: STRING</li></ul></li><li>job_id: STRING</li><li>title: STRING</li></ul> |

### taxes

The `taxes` table contains information about taxes enabled on your items in Square.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | updated\_at |
| **Useful links** | [Square API method](https://developer.squareup.com/reference/square/catalog-api/list-catalog "Opens in new tab: Square API method") |

taxes table foreign keys

| Join taxes with | on |
| --- | --- |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>taxes.absent_at_location_ids = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>taxes.absent_at_location_ids = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>taxes.absent_at_location_ids = discounts.absent_at_location_ids<br>``` |
| [team_members](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#team-members) | ```<br>taxes.absent_at_location_ids = team_members.assigned_locations.location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>taxes.absent_at_location_ids = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>taxes.absent_at_location_ids = items.absent_at_location_ids<br>```<br><br>```<br>taxes.absent_at_location_ids = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>taxes.absent_at_location_ids = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>taxes.absent_at_location_ids = items.present_at_location_ids<br>```<br><br>```<br>taxes.id = items.item_data.tax_ids<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>taxes.absent_at_location_ids = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>taxes.absent_at_location_ids = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>taxes.absent_at_location_ids = orders.id<br>```<br><br>```<br>taxes.absent_at_location_ids = orders.refunds.id<br>```<br><br>```<br>taxes.absent_at_location_ids = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>taxes.absent_at_location_ids = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>taxes.absent_at_location_ids = refunds.id<br>``` |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>taxes.absent_at_location_ids = shifts.id<br>``` |

taxes table schema

| **absent\_at\_location\_ids**<br><br><br>ARRAY |
| --- |
| **id**<br><br><br>STRING |
| **is\_deleted**<br><br><br>BOOLEAN |
| **present\_at\_all\_locations**<br><br><br>BOOLEAN |
| **tax\_data**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>applies_to_custom_amounts: BOOLEAN</li><li>calculation_phase: STRING</li><li>enabled: BOOLEAN</li><li>inclusion_type: STRING</li><li>name: STRING</li><li>percentage: STRING</li><li>tax_type_id: STRING</li><li>tax_type_name: STRING</li></ul> |
| **type**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |
| **version**<br><br><br>INTEGER |

### team\_members

| **Replication Method** | CDC |
| --- | --- |
| **Replication Key** | updated\_at |
| **Useful links** | Square documentation<br><br>[Square API method](https://developer.squareup.com/reference/square/team-api/search-team-members "Opens in new tab: Square API method") |

team\_members table foreign keys

| Join team\_members with | on |
| --- | --- |
| [shifts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#shifts) | ```<br>team_members.id = shifts.team_member_id<br>```<br><br>```<br>team_members.assigned_locations.location_ids = shifts.id<br>``` |
| [bank_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#bank-accounts) | ```<br>team_members.assigned_locations.location_ids = bank_accounts.id<br>``` |
| [categories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#categories) | ```<br>team_members.assigned_locations.location_ids = categories.absent_at_location_ids<br>``` |
| [discounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#discounts) | ```<br>team_members.assigned_locations.location_ids = discounts.absent_at_location_ids<br>``` |
| [inventories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#inventories) | ```<br>team_members.assigned_locations.location_ids = inventories.location_id<br>``` |
| [items](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#items) | ```<br>team_members.assigned_locations.location_ids = items.absent_at_location_ids<br>```<br><br>```<br>team_members.assigned_locations.location_ids = items.item_data.variations.item_variation_data.location_overrides.location_id<br>```<br><br>```<br>team_members.assigned_locations.location_ids = items.item_data.variations.present_at_location_ids<br>```<br><br>```<br>team_members.assigned_locations.location_ids = items.present_at_location_ids<br>``` |
| [locations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#locations) | ```<br>team_members.assigned_locations.location_ids = locations.id<br>``` |
| [modifier_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#modifier-lists) | ```<br>team_members.assigned_locations.location_ids = modifier_lists.absent_at_location_ids<br>``` |
| [orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#orders) | ```<br>team_members.assigned_locations.location_ids = orders.id<br>```<br><br>```<br>team_members.assigned_locations.location_ids = orders.refunds.id<br>```<br><br>```<br>team_members.assigned_locations.location_ids = orders.tenders.id<br>``` |
| [payments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#payments) | ```<br>team_members.assigned_locations.location_ids = payments.id<br>``` |
| [refunds](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#refunds) | ```<br>team_members.assigned_locations.location_ids = refunds.id<br>``` |
| [taxes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Square.htm#taxes) | ```<br>team_members.assigned_locations.location_ids = taxes.absent_at_location_ids<br>``` |

team\_members table schema

| **assigned\_locations**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>assignment_type: STRING</li><li>location_ids: ARRAY</li></ul> |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **email\_address**<br><br><br>STRING |
| **family\_name**<br><br><br>STRING |
| **given\_name**<br><br><br>STRING |
| **id**<br><br><br>STRING |
| **is\_owner**<br><br><br>BOOLEAN |
| **phone\_number**<br><br><br>STRING |
| **reference\_id**<br><br><br>STRING |
| **status**<br><br><br>STRING |
| **updated\_at**<br><br><br>DATE-TIME |