# Mambu (v2) Information note **Mambu extraction is supported by Stitch** This integration is powered by [Singer's](https://www.singer.io/) Mambu tap and certified by Stitch. [Check out and contribute to the repo on GitHub](https://github.com/singer-io/tap-mambu). For support, contact [Support](https://community.qlik.com/t5/Support/ct-p/qlikSupport). ## Mambu integration summary Stitch’s Mambu integration replicates data using the [Mambu v2.0](https://api.mambu.com/?shell#Welcome) and [v1.0 APIs](https://support.mambu.com/docs/rest-apis-overview). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#schema) section for a list of objects available for replication. ## Mambu feature snapshot A high-level look at Stitch's Mambu (v2) integration, including release status, useful links, and the features supported in Stitch. | **STITCH** | | | | | --- | --- | --- | --- | | **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | | **Supported by**

the Info icon

Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) | | **Stitch plan**

the Info icon

The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**

the Info icon

Indicates if the integration is available as a source in Stitch Connect. | the Remove icon

This version of the integration isn't available via the API.

Not available | | **Singer GitHub repository** | [singer-io/tap-mambu](https://github.com/singer-io/tap-mambu) | | | | **REPLICATION SETTINGS** | | | | | **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**

the Info icon

A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**

the Info icon

A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Table-level reset**

the Info icon

Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon

Table-level resets are not supported for this integration. Resets are only supported at the integration level.

Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**

the Info icon

Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon

Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.

Unsupported | | **DATA SELECTION** | | | | | **Table selection**

the Info icon

The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | **Column selection**

the Info icon

The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Select all**

the Info icon

Indicates if the integration supports selecting all available tables and columns. | the Success icon

Supported

Supported | | | | **TRANSPARENCY** | | | | | **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**

the Info icon

Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**

the Info icon

Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | ## Connecting Mambu ### Mambu setup requirements To set up Mambu in Stitch, you need: * **A Mambu account with API access**. The Mambu integration requires an account login with API access. In Mambu’s app, API access can be granted to any existing user. ### Step 1: Add Mambu as a Stitch data source 1. [Sign into your Stitch account](https://app.stitchdata.com/). 2. On the Stitch Dashboard page, click the **Add Integration** button. 3. Click the **Mambu** icon. 4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination. For example, the name “Stitch Mambu” would create a schema called `stitch_mambu` in the destination. **Note**: Schema names cannot be changed after you save the integration. 5. In the **Subdomain** field, enter your Mambu subdomain. For example: If the subdomain were `stitch.mambu.com`, only `stitch` would be entered into this field. 6. In the **Username** and **Password** fields, enter the username and password of the Mambu user with Mambu API access. ### Step 2: Define the historical replication start date The Sync Historical Data setting defines the starting date for your Mambu integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse. Change this setting if you want to replicate data beyond Mambu’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide. ### Step 3: Create a replication schedule Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information. In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins. Mambu integrations support the following replication scheduling methods: * [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency) * [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling) * [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only) To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage. ### Step 4: Set objects to replicate Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements). The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#schema) **Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts. * Selection options * Individual tables and columns * All tables and columns For Mambu integrations, you can select: 1. **Individual tables and columns** 2. **All tables and columns** Click the tabs to view instructions for each selection method. 1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate. 2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate. 3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate. 4. Repeat this process for all the tables and columns you want to replicate. 5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections. Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature. 1. Click into the integration from the Stitch Dashboard page. 2. Click the **Tables to Replicate** tab. 3. In the list of tables, click the box next to the **Table Names** column. 4. In the menu that displays, click **Track all Tables and Fields**: ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab 5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections. ### Initial and historical replication jobs After you finish setting up Mambu, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page. For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.** Information note **Initial replication jobs with Anchor Scheduling** If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information. #### Free historical data loads The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota. Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage. ## Mambu table reference Information note **Schemas and versioning** Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing. The schema and info displayed below is for **version 2** of this integration. Information note **Table and column names in your destination** Depending on your destination, table and column names may not appear as they are outlined below. For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info. ### activities This table contains information about activities. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | encoded\_key | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | timestamp | | **Useful links** | [Mambu documentation](https://support.mambu.com/docs/activities-api "Opens in new tab: Mambu documentation")

[activities schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/activities.json "Opens in new tab: activities schema on GitHub")

[Mambu API method](https://api.mambu.com/v1/#activities-get-all-activities "Opens in new tab: Mambu API method") | activities table foreign keys | Join activities with | on | | --- | --- | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
activities.client_key = clients.encoded_key
```

```
activities.user_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
activities.client_key = communications.client_key
```

```
activities.user_key = communications.user_key
```

```
activities.user_key = communications.sender_key
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
activities.client_key = groups.group_members.client_key
```

```
activities.user_key = groups.assigned_user_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
activities.user_key = deposit_transactions.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
activities.user_key = gl_journal_entries.user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
activities.user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
activities.user_key = loan_transactions.user_key
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
activities.user_key = tasks.created_by_user_key
```

```
activities.user_key = tasks.assigned_user_key
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
activities.user_key = users.encoded_key
``` | activities table schema | **branch\_name**

STRING | | --- | | **client\_key**

STRING | | **client\_name**

STRING | | **encoded\_key**

STRING | | **field\_changes**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand field\_changes

branchKey

STRING

clientKey

STRING

field_change_name

STRING

INTEGER

loanAccountKey

STRING

loanProductKey

STRING

new_value

STRING

original_value

STRING

transaction_id

INTEGER

| | **loan\_account\_name**

STRING | | **loan\_product\_name**

STRING | | **notes**

STRING | | **timestamp**

DATE-TIME | | **transaction\_ID**

INTEGER | | **type**

STRING | | **user\_key**

STRING | | **user\_name**

STRING | ### audit\_trail This table contains information about activities that have been performed in the Mambu Core Banking system. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | occurred\_at | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[audit_trail schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/audit_trail.json "Opens in new tab: audit_trail schema on GitHub")

[Mambu API method](https://support.mambu.com/docs/audit-trail "Opens in new tab: Mambu API method") | audit\_trail table schema | **client\_ip**

STRING | | --- | | **event\_source**

STRING | | **occurred\_at**

DATE-TIME | | **request\_method**

STRING | | **request\_payload**

STRING | | **request\_uri**

STRING | | **resource**

STRING | | **resource\_fragment**

STRING | | **response\_code**

NUMBER | | **response\_payload**

STRING | | **user\_agent**

STRING | | **username**

STRING | ### branches This table contains information about branches. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[branches schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/branches.json "Opens in new tab: branches schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#branches-getall "Opens in new tab: Mambu API method") | branches table foreign keys | Join branches with | on | | --- | --- | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
branches.encoded_key = centres.assigned_branch_key
```

```
branches.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
branches.custom_fields.id = centres.custom_fields.id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
branches.encoded_key = deposit_transactions.branch_key
```

```
branches.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
branches.custom_fields.id = deposit_transactions.custom_fields.id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
branches.encoded_key = groups.assigned_branch_key
```

```
branches.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
branches.custom_fields.id = groups.custom_fields.id
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
branches.encoded_key = loan_accounts.assigned_branch_key
```

```
branches.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
branches.custom_fields.id = loan_accounts.custom_fields.id
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
branches.encoded_key = loan_transactions.branch_key
```

```
branches.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
branches.custom_fields.id = loan_transactions.custom_fields.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
branches.encoded_key = users.access.managed_branches.branch_key
```

```
branches.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
branches.custom_fields.id = users.custom_fields.id
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
branches.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
branches.custom_fields.id = clients.custom_fields.id
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
branches.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
branches.custom_fields.id = communications.custom_fields.id
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
branches.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
branches.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
branches.custom_fields.field_set_id = custom_field_sets.id
```

```
branches.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
branches.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
branches.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
branches.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
branches.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
branches.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
branches.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
branches.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
branches.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
branches.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
branches.custom_fields.id = tasks.custom_fields.id
``` | branches table schema | **addresses**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand addresses

city

STRING

country

STRING

encoded_key

STRING

index_in_list

INTEGER

latitude

NUMBER

line1

STRING

line2

STRING

longitude

NUMBER

parent_key

STRING

postcode

STRING

region

STRING

| | --- | | **branch\_holidays**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand branch\_holidays

creation_date

DATE-TIME

date

DATE

encoded_key

STRING

is_anually_recurring

BOOLEAN

name

STRING

| | **creation\_date**

DATE-TIME | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **email\_address**

STRING | | **encoded\_key**

STRING | | **id**

STRING | | **last\_modified\_date**

DATE-TIME | | **name**

STRING | | **notes**

STRING | | **phone\_number**

STRING | | **state**

STRING | ### cards This table contains information about cards. **Note**: In order to replicate this table, you must also set the [deposit_account](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-account) table to replicate. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | deposit\_id

reference\_token | | | deposit\_account | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[cards schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/cards.json "Opens in new tab: cards schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#depositaccounts-getallcards "Opens in new tab: Mambu API method") | cards table schema | **deposit\_id**

STRING | | --- | | **reference\_token**

STRING | ### centres This table contains information about centres. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[centres schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/centres.json "Opens in new tab: centres schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#centres-getall "Opens in new tab: Mambu API method") | centres table foreign keys | Join centres with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
centres.assigned_branch_key = branches.encoded_key
```

```
centres.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
centres.custom_fields.id = branches.custom_fields.id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
centres.assigned_branch_key = deposit_transactions.branch_key
```

```
centres.encoded_key = deposit_transactions.centre_key
```

```
centres.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
centres.custom_fields.id = deposit_transactions.custom_fields.id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
centres.assigned_branch_key = groups.assigned_branch_key
```

```
centres.encoded_key = groups.assigned_centre_key
```

```
centres.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
centres.custom_fields.id = groups.custom_fields.id
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
centres.assigned_branch_key = loan_accounts.assigned_branch_key
```

```
centres.encoded_key = loan_accounts.assigned_centre_key
```

```
centres.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
centres.custom_fields.id = loan_accounts.custom_fields.id
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
centres.assigned_branch_key = loan_transactions.branch_key
```

```
centres.encoded_key = loan_transactions.centre_key
```

```
centres.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
centres.custom_fields.id = loan_transactions.custom_fields.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
centres.assigned_branch_key = users.access.managed_branches.branch_key
```

```
centres.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
centres.custom_fields.id = users.custom_fields.id
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
centres.encoded_key = clients.assigned_centre_key
```

```
centres.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
centres.custom_fields.id = clients.custom_fields.id
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
centres.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
centres.custom_fields.id = communications.custom_fields.id
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
centres.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
centres.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
centres.custom_fields.field_set_id = custom_field_sets.id
```

```
centres.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
centres.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
centres.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
centres.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
centres.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
centres.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
centres.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
centres.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
centres.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
centres.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
centres.custom_fields.id = tasks.custom_fields.id
``` | centres table schema | **addresses**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand addresses

city

STRING

country

STRING

encoded_key

STRING

index_in_list

INTEGER

latitude

NUMBER

line1

STRING

line2

STRING

longitude

NUMBER

parent_key

STRING

postcode

STRING

region

STRING

| | --- | | **assigned\_branch\_key**

STRING | | **creation\_date**

DATE-TIME | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **encoded\_key**

STRING | | **id**

STRING | | **last\_modified\_date**

DATE-TIME | | **meeting\_day**

STRING | | **name**

STRING | | **notes**

STRING | | **state**

STRING | ### clients This table contains information about clients. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[clients schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/clients.json "Opens in new tab: clients schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#clients-search "Opens in new tab: Mambu API method") | clients table foreign keys | Join clients with | on | | --- | --- | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
clients.assigned_centre_key = centres.encoded_key
```

```
clients.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
clients.custom_fields.id = centres.custom_fields.id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
clients.assigned_centre_key = deposit_transactions.centre_key
```

```
clients.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
clients.custom_fields.id = deposit_transactions.custom_fields.id
```

```
clients.assigned_user_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
clients.assigned_centre_key = groups.assigned_centre_key
```

```
clients.encoded_key = groups.group_members.client_key
```

```
clients.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
clients.custom_fields.id = groups.custom_fields.id
```

```
clients.assigned_user_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
clients.assigned_centre_key = loan_accounts.assigned_centre_key
```

```
clients.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
clients.custom_fields.id = loan_accounts.custom_fields.id
```

```
clients.assigned_user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
clients.assigned_centre_key = loan_transactions.centre_key
```

```
clients.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
clients.custom_fields.id = loan_transactions.custom_fields.id
```

```
clients.assigned_user_key = loan_transactions.user_key
``` | | [activities](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#activities) | ```
clients.encoded_key = activities.client_key
```

```
clients.assigned_user_key = activities.user_key
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
clients.encoded_key = communications.client_key
```

```
clients.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
clients.custom_fields.id = communications.custom_fields.id
```

```
clients.assigned_user_key = communications.user_key
```

```
clients.assigned_user_key = communications.sender_key
``` | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
clients.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
clients.custom_fields.id = branches.custom_fields.id
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
clients.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
clients.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
clients.custom_fields.field_set_id = custom_field_sets.id
```

```
clients.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
clients.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
clients.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
clients.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
clients.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
clients.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
clients.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
clients.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
clients.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
clients.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
clients.custom_fields.id = tasks.custom_fields.id
```

```
clients.assigned_user_key = tasks.created_by_user_key
```

```
clients.assigned_user_key = tasks.assigned_user_key
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
clients.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
clients.custom_fields.id = users.custom_fields.id
```

```
clients.assigned_user_key = users.encoded_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
clients.assigned_user_key = gl_journal_entries.user_key
``` | clients table schema | **activation\_date**

DATE-TIME | | --- | | **addresses**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand addresses

city

STRING

country

STRING

encoded_key

STRING

index_in_list

INTEGER

latitude

NUMBER

line1

STRING

line2

STRING

longitude

NUMBER

parent_key

STRING

postcode

STRING

region

STRING

| | **approved\_date**

DATE-TIME | | **assigned\_branch\_key**

STRING | | **assigned\_centre\_key**

STRING | | **assigned\_user\_key**

STRING | | **birth\_date**

DATE | | **client\_role\_key**

STRING | | **closed\_date**

DATE-TIME | | **creation\_date**

DATE-TIME | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **email\_address**

STRING | | **encoded\_key**

STRING | | **first\_name**

STRING | | **gender**

STRING | | **group\_loan\_cycle**

INTEGER | | **home\_phone**

STRING | | **id**

STRING | | **id\_documents**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand id\_documents

client_key

STRING

document_id

STRING

document_type

STRING

encoded_key

STRING

identification_document_template_key

STRING

index_in_list

INTEGER

issuing_authority

STRING

valid_until

DATE

| | **last\_modified\_date**

DATE-TIME | | **last\_name**

STRING | | **middle\_name**

STRING | | **migration\_event\_key**

STRING | | **mobile\_phone**

STRING | | **notes**

STRING | | **preferred\_language**

STRING | | **profile\_picture\_key**

STRING | | **profile\_signature\_key**

STRING | | **state**

STRING | ### communications This table contains information about communications. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | encoded\_key | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | creation\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[communications schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/communications.json "Opens in new tab: communications schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#communications-search "Opens in new tab: Mambu API method") | communications table foreign keys | Join communications with | on | | --- | --- | | [activities](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#activities) | ```
communications.client_key = activities.client_key
```

```
communications.user_key = activities.user_key
```

```
communications.sender_key = activities.user_key
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
communications.client_key = clients.encoded_key
```

```
communications.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
communications.custom_fields.id = clients.custom_fields.id
```

```
communications.user_key = clients.assigned_user_key
```

```
communications.sender_key = clients.assigned_user_key
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
communications.client_key = groups.group_members.client_key
```

```
communications.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
communications.custom_fields.id = groups.custom_fields.id
```

```
communications.group_key = groups.encoded_key
```

```
communications.user_key = groups.assigned_user_key
```

```
communications.sender_key = groups.assigned_user_key
``` | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
communications.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
communications.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
communications.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
communications.custom_fields.id = centres.custom_fields.id
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
communications.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
communications.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
communications.custom_fields.field_set_id = custom_field_sets.id
```

```
communications.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
communications.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
communications.custom_fields.id = deposit_accounts.custom_fields.id
```

```
communications.deposit_account_key = deposit_accounts.encoded_key
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
communications.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
communications.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
communications.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
communications.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
communications.custom_fields.id = deposit_transactions.custom_fields.id
```

```
communications.user_key = deposit_transactions.user_key
```

```
communications.sender_key = deposit_transactions.user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
communications.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
communications.custom_fields.id = loan_accounts.custom_fields.id
```

```
communications.deposit_account_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key
```

```
communications.deposit_account_key = loan_accounts.funding_sources.deposit_account_key
```

```
communications.deposit_account_key = loan_accounts.guarantors.deposit_account_key
```

```
communications.loan_account_key = loan_accounts.encoded_key
```

```
communications.user_key = loan_accounts.assigned_user_key
```

```
communications.sender_key = loan_accounts.assigned_user_key
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
communications.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
communications.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
communications.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
communications.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
communications.custom_fields.id = loan_transactions.custom_fields.id
```

```
communications.user_key = loan_transactions.user_key
```

```
communications.sender_key = loan_transactions.user_key
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
communications.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
communications.custom_fields.id = tasks.custom_fields.id
```

```
communications.user_key = tasks.created_by_user_key
```

```
communications.sender_key = tasks.created_by_user_key
```

```
communications.user_key = tasks.assigned_user_key
```

```
communications.sender_key = tasks.assigned_user_key
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
communications.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
communications.custom_fields.id = users.custom_fields.id
```

```
communications.user_key = users.encoded_key
```

```
communications.sender_key = users.encoded_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
communications.user_key = gl_journal_entries.user_key
```

```
communications.sender_key = gl_journal_entries.user_key
``` | communications table schema | **body**

STRING | | --- | | **client\_key**

STRING | | **creation\_date**

DATE-TIME | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **deposit\_account\_key**

STRING | | **destination**

STRING | | **encoded\_key**

STRING | | **event**

STRING | | **failure\_cause**

STRING | | **failure\_reason**

STRING | | **group\_key**

STRING | | **loan\_account\_key**

STRING | | **num\_retries**

INTEGER | | **reference\_id**

STRING | | **repayment\_key**

STRING | | **send\_date**

DATE-TIME | | **sender\_key**

STRING | | **state**

STRING | | **subject**

STRING | | **template\_key**

STRING | | **type**

STRING | | **user\_key**

STRING | ### credit\_arrangements This table contains information about credit arrangements. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[credit_arrangements schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/credit_arrangements.json "Opens in new tab: credit_arrangements schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#creditarrangements-getall "Opens in new tab: Mambu API method") | credit\_arrangements table foreign keys | Join credit\_arrangements with | on | | --- | --- | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
credit_arrangements.encoded_key = deposit_accounts.credit_arrangement_key
```

```
credit_arrangements.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
credit_arrangements.encoded_key = loan_accounts.credit_arrangement_key
```

```
credit_arrangements.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = loan_accounts.custom_fields.id
``` | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
credit_arrangements.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
credit_arrangements.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = centres.custom_fields.id
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
credit_arrangements.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = clients.custom_fields.id
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
credit_arrangements.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = communications.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
credit_arrangements.custom_fields.field_set_id = custom_field_sets.id
```

```
credit_arrangements.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
credit_arrangements.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
credit_arrangements.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
credit_arrangements.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
credit_arrangements.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = deposit_transactions.custom_fields.id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
credit_arrangements.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = groups.custom_fields.id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
credit_arrangements.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
credit_arrangements.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
credit_arrangements.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
credit_arrangements.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = loan_transactions.custom_fields.id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
credit_arrangements.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = tasks.custom_fields.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
credit_arrangements.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
credit_arrangements.custom_fields.id = users.custom_fields.id
``` | credit\_arrangements table schema | **amount**

NUMBER | | --- | | **approved\_date**

DATE-TIME | | **available\_credit\_amount**

NUMBER | | **consumed\_credit\_amount**

NUMBER | | **creation\_date**

DATE-TIME | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **encoded\_key**

STRING | | **expire\_date**

DATE-TIME | | **holder\_key**

STRING | | **holder\_type**

STRING | | **id**

STRING | | **last\_modified\_date**

DATE-TIME | | **notes**

STRING | | **start\_date**

DATE-TIME | | **state**

STRING | | **sub\_state**

STRING | ### custom\_field\_sets This table contains information about custom field sets. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[custom_field_sets schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/custom_field_sets.json "Opens in new tab: custom_field_sets schema on GitHub")

[Mambu API method](https://api.mambu.com/v1/#custom-field-sets-get-custom-field-sets "Opens in new tab: Mambu API method") | custom\_field\_sets table foreign keys | Join custom\_field\_sets with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
custom_field_sets.id = branches.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
custom_field_sets.id = centres.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = centres.custom_fields.id
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
custom_field_sets.id = clients.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = clients.custom_fields.id
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
custom_field_sets.id = communications.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = communications.custom_fields.id
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
custom_field_sets.id = credit_arrangements.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
custom_field_sets.id = deposit_accounts.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
custom_field_sets.id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
custom_field_sets.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
custom_field_sets.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
custom_field_sets.id = deposit_transactions.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = deposit_transactions.custom_fields.id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
custom_field_sets.id = groups.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = groups.custom_fields.id
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
custom_field_sets.id = loan_accounts.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = loan_accounts.custom_fields.id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
custom_field_sets.id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
custom_field_sets.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
custom_field_sets.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
custom_field_sets.id = loan_transactions.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = loan_transactions.custom_fields.id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
custom_field_sets.id = tasks.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = tasks.custom_fields.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
custom_field_sets.id = users.custom_fields.field_set_id
```

```
custom_field_sets.custom_fields.id = users.custom_fields.id
``` | custom\_field\_sets table schema | **created\_date**

DATE-TIME | | --- | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

amounts

OBJECT

custom_field_product_settings

ARRAY

custom_field_encoded_key

STRING

encoded_key

STRING

is_default

BOOLEAN

is_required

BOOLEAN

link_type

STRING

product_key

STRING

custom_field_selection_options

ARRAY

encoded_key

STRING

is_default

BOOLEAN

score

STRING

value

STRING

data_type

STRING

edit_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

| | **encoded\_key**

STRING | | **id**

STRING | | **index\_in\_list**

INTEGER | | **last\_modified\_date**

DATE-TIME | | **name**

STRING | | **notes**

STRING | | **type**

STRING | | **usage**

STRING | ### deposit\_accounts This table contains information about deposit accounts. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[deposit_accounts schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/deposit_accounts.json "Opens in new tab: deposit_accounts schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#deposit-accounts-search "Opens in new tab: Mambu API method") | deposit\_accounts table foreign keys | Join deposit\_accounts with | on | | --- | --- | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
deposit_accounts.credit_arrangement_key = credit_arrangements.encoded_key
```

```
deposit_accounts.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
deposit_accounts.credit_arrangement_key = loan_accounts.credit_arrangement_key
```

```
deposit_accounts.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = loan_accounts.custom_fields.id
```

```
deposit_accounts.encoded_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key
```

```
deposit_accounts.encoded_key = loan_accounts.funding_sources.deposit_account_key
```

```
deposit_accounts.encoded_key = loan_accounts.guarantors.deposit_account_key
``` | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
deposit_accounts.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
deposit_accounts.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = centres.custom_fields.id
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
deposit_accounts.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = clients.custom_fields.id
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
deposit_accounts.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = communications.custom_fields.id
```

```
deposit_accounts.encoded_key = communications.deposit_account_key
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
deposit_accounts.custom_fields.field_set_id = custom_field_sets.id
```

```
deposit_accounts.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
deposit_accounts.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
deposit_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
deposit_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
deposit_accounts.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = deposit_transactions.custom_fields.id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
deposit_accounts.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = groups.custom_fields.id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
deposit_accounts.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
deposit_accounts.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
deposit_accounts.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
deposit_accounts.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = loan_transactions.custom_fields.id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
deposit_accounts.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = tasks.custom_fields.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
deposit_accounts.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
deposit_accounts.custom_fields.id = users.custom_fields.id
``` | deposit\_accounts table schema | **account\_holder\_key**

STRING | | --- | | **account\_holder\_type**

STRING | | **account\_state**

STRING | | **account\_type**

STRING | | **accrued\_amounts**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand accrued\_amounts

interest_accrued

NUMBER

overdraft_interest_accrued

NUMBER

technical_overdraft_interest_accrued

NUMBER

| | **activation\_date**

DATE-TIME | | **approved\_date**

DATE-TIME | | **assigned\_branch\_key**

STRING | | **assigned\_centre\_key**

STRING | | **assigned\_user\_key**

STRING | | **balances**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand balances

available_balance

NUMBER

fees_due

NUMBER

hold_balance

NUMBER

locked_balance

NUMBER

overdraft_amount

NUMBER

overdraft_interest_due

NUMBER

technical_overdraft_amount

NUMBER

technical_overdraft_interest_due

NUMBER

total_balance

NUMBER

| | **closed\_date**

DATE-TIME | | **creation\_date**

DATE-TIME | | **credit\_arrangement\_key**

STRING | | **currency\_code**

STRING | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **encoded\_key**

STRING | | **id**

STRING | | **interest\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand interest\_settings

interest_payment_settings

OBJECT

interest_payment_dates

ARRAY

day

INTEGER

month

INTEGER

interest_payment_point

STRING

interest_rate_settings

OBJECT

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate

NUMBER

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

| | **internal\_controls**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand internal\_controls

max_withdrawal_amount

NUMBER

recommended_deposit_amount

NUMBER

target_amount

NUMBER

| | **last\_account\_appraisal\_date**

DATE-TIME | | **last\_interest\_calculation\_date**

DATE-TIME | | **last\_interest\_stored\_date**

DATE-TIME | | **last\_modified\_date**

DATE-TIME | | **last\_overdraft\_interest\_review\_date**

DATE-TIME | | **last\_sent\_to\_arrears\_date**

DATE-TIME | | **linked\_settlement\_account\_keys**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **locked\_date**

DATE-TIME | | **maturity\_date**

DATE-TIME | | **migration\_event\_key**

STRING | | **name**

STRING | | **notes**

STRING | | **overdraft\_interest\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand overdraft\_interest\_settings

interest_rate_settings

OBJECT

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

interest_spread

NUMBER

| | **overdraft\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand overdraft\_settings

allowed_overdraft

BOOLEAN

overdraft_expiry_date

DATE-TIME

overdraft_limit

NUMBER

| | **product\_type\_key**

STRING | | **withholding\_tax\_source\_key**

STRING | ### deposit\_products This table contains information about deposit (savings) products. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[deposit_products schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/deposit_products.json "Opens in new tab: deposit_products schema on GitHub")

[Mambu API method](https://api.mambu.com/v1/#savings-products-get-savings-products "Opens in new tab: Mambu API method") | deposit\_products table foreign keys | Join deposit\_products with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = branches.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = branches.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = centres.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = centres.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = centres.custom_fields.id
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = clients.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = clients.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = clients.custom_fields.id
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = communications.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = communications.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = communications.custom_fields.id
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = credit_arrangements.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = credit_arrangements.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = custom_field_sets.id
```

```
deposit_products.custom_field_values.custom_field.id = custom_field_sets.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = deposit_accounts.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = deposit_accounts.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = deposit_accounts.custom_fields.id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = deposit_transactions.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = deposit_transactions.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = deposit_transactions.custom_fields.id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = groups.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = groups.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = groups.custom_fields.id
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = loan_accounts.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = loan_accounts.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = loan_accounts.custom_fields.id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
deposit_products.custom_field_values.custom_field.id = loan_products.custom_field_values.custom_field.id
```

```
deposit_products.custom_field_values.custom_field_id = loan_products.custom_field_values.custom_field.id
```

```
deposit_products.custom_field_values.custom_field.id = loan_products.custom_field_values.custom_field_id
```

```
deposit_products.custom_field_values.custom_field_id = loan_products.custom_field_values.custom_field_id
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = loan_transactions.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = loan_transactions.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = loan_transactions.custom_fields.id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = tasks.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = tasks.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = tasks.custom_fields.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
deposit_products.custom_field_values.custom_field.custom_field_set.id = users.custom_fields.field_set_id
```

```
deposit_products.custom_field_values.custom_field.id = users.custom_fields.id
```

```
deposit_products.custom_field_values.custom_field_id = users.custom_fields.id
``` | deposit\_products table schema | **accounting\_method**

STRING | | --- | | **activated**

BOOLEAN | | **allow\_arbitrary\_fees**

BOOLEAN | | **allow\_offset**

BOOLEAN | | **allow\_overdraft**

BOOLEAN | | **allow\_technical\_overdraft**

BOOLEAN | | **available\_product\_branches**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand available\_product\_branches

branch_key

STRING

encoded_key

STRING

| | **collect\_interest\_when\_locked**

BOOLEAN | | **creation\_date**

DATE-TIME | | **currencies**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand currencies

code

STRING

creation_date

DATE-TIME

currency_symbol_position

STRING

digits_after_decimal

INTEGER

is_base_currency

BOOLEAN

last_modified_date

DATE-TIME

name

STRING

symbol

STRING

| | **custom\_field\_values**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_field\_values

amount

STRING

custom_field

OBJECT

amounts

OBJECT

custom_field_selection_options

ARRAY

encoded_key

STRING

score

STRING

value

STRING

custom_field_set

OBJECT

creation_date

DATE-TIME

encoded_key

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

type

STRING

usage

STRING

data_type

STRING

edit_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

custom_field_id

STRING

custom_field_key

STRING

custom_field_set_group_index

INTEGER

encoded_key

STRING

index_in_list

INTEGER

parent_key

STRING

value

STRING

| | **description**

STRING | | **encoded\_key**

STRING | | **for\_all\_branches**

BOOLEAN | | **for\_groups**

BOOLEAN | | **for\_individuals**

BOOLEAN | | **id**

STRING | | **id\_generator\_type**

STRING | | **id\_pattern**

STRING | | **interest\_accrued\_accounting\_method**

STRING | | **interest\_calculation\_balance**

STRING | | **interest\_days\_in\_year**

STRING | | **interest\_paid\_into\_account**

BOOLEAN | | **interest\_payment\_point**

STRING | | **interest\_rate\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand interest\_rate\_settings

accrue_interest_after_maturity

BOOLEAN

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

| | **last\_modified\_date**

DATE-TIME | | **line\_of\_credit\_requirement**

STRING | | **maturity\_period\_limit**

STRING | | **max\_overdraft\_limit**

STRING | | **min\_opening\_balance**

STRING | | **name**

STRING | | **overdraft\_days\_in\_year**

STRING | | **overdraft\_interest\_rate\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand overdraft\_interest\_rate\_settings

accrue_interest_after_maturity

BOOLEAN

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

| | **product\_type**

STRING | | **savings\_fees**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand savings\_fees

active

BOOLEAN

amortization_profile

STRING

amount

STRING

amount_calculation_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_amortization_upon_reschedule_option

STRING

fee_application

STRING

fee_product_rules

ARRAY

name

STRING

trigger

STRING

| | **savings\_product\_rules**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **templates**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand templates

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

| | **withholding\_tax\_enabled**

BOOLEAN | ### deposit\_transactions This table contains information about deposit transactions. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | encoded\_key | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | creation\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[deposit_transactions schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/deposit_transactions.json "Opens in new tab: deposit_transactions schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#deposittransactions-search "Opens in new tab: Mambu API method") | deposit\_transactions table foreign keys | Join deposit\_transactions with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
deposit_transactions.branch_key = branches.encoded_key
```

```
deposit_transactions.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
deposit_transactions.branch_key = centres.assigned_branch_key
```

```
deposit_transactions.centre_key = centres.encoded_key
```

```
deposit_transactions.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = centres.custom_fields.id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
deposit_transactions.branch_key = groups.assigned_branch_key
```

```
deposit_transactions.centre_key = groups.assigned_centre_key
```

```
deposit_transactions.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = groups.custom_fields.id
```

```
deposit_transactions.user_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
deposit_transactions.branch_key = loan_accounts.assigned_branch_key
```

```
deposit_transactions.centre_key = loan_accounts.assigned_centre_key
```

```
deposit_transactions.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = loan_accounts.custom_fields.id
```

```
deposit_transactions.user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
deposit_transactions.branch_key = loan_transactions.branch_key
```

```
deposit_transactions.centre_key = loan_transactions.centre_key
```

```
deposit_transactions.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = loan_transactions.custom_fields.id
```

```
deposit_transactions.transfer_details.linked_deposit_transaction_key = loan_transactions.transfer_details.linked_deposit_transaction_key
```

```
deposit_transactions.linked_loan_transaction_key = loan_transactions.encoded_key
```

```
deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.encoded_key
```

```
deposit_transactions.linked_loan_transaction_key = loan_transactions.linked_loan_transaction_key
```

```
deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.linked_loan_transaction_key
```

```
deposit_transactions.linked_loan_transaction_key = loan_transactions.parent_loan_transaction_key
```

```
deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.parent_loan_transaction_key
```

```
deposit_transactions.linked_loan_transaction_key = loan_transactions.transfer_details.linked_loan_transaction_key
```

```
deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.transfer_details.linked_loan_transaction_key
```

```
deposit_transactions.user_key = loan_transactions.user_key
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
deposit_transactions.branch_key = users.access.managed_branches.branch_key
```

```
deposit_transactions.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = users.custom_fields.id
```

```
deposit_transactions.user_key = users.encoded_key
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
deposit_transactions.centre_key = clients.assigned_centre_key
```

```
deposit_transactions.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = clients.custom_fields.id
```

```
deposit_transactions.user_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
deposit_transactions.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = communications.custom_fields.id
```

```
deposit_transactions.user_key = communications.user_key
```

```
deposit_transactions.user_key = communications.sender_key
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
deposit_transactions.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
deposit_transactions.custom_fields.field_set_id = custom_field_sets.id
```

```
deposit_transactions.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
deposit_transactions.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
deposit_transactions.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
deposit_transactions.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
deposit_transactions.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
deposit_transactions.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
deposit_transactions.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
deposit_transactions.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
deposit_transactions.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
deposit_transactions.custom_fields.id = tasks.custom_fields.id
```

```
deposit_transactions.user_key = tasks.created_by_user_key
```

```
deposit_transactions.user_key = tasks.assigned_user_key
``` | | [activities](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#activities) | ```
deposit_transactions.user_key = activities.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
deposit_transactions.user_key = gl_journal_entries.user_key
``` | deposit\_transactions table schema | **account\_balances**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand account\_balances

total_balance

NUMBER

| | --- | | **adjustment\_transaction\_key**

STRING | | **affected\_amounts**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand affected\_amounts

fees_amount

NUMBER

fraction_amount

NUMBER

funds_amount

NUMBER

interest_amount

NUMBER

overdraft_amount

NUMBER

overdraft_fees_amount

NUMBER

overdraft_interest_amount

NUMBER

technical_overdraft_amount

NUMBER

technical_overdraft_interest_amount

NUMBER

| | **amount**

NUMBER | | **booking\_date**

DATE-TIME | | **branch\_key**

STRING | | **card\_transaction**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand card\_transaction

advice

BOOLEAN

amount

NUMBER

card_acceptor

OBJECT

city

STRING

country

STRING

mcc

INTEGER

name

STRING

state

STRING

zip

STRING

card_token

STRING

currency_code

STRING

encoded_key

STRING

external_authorization_reference_id

STRING

external_reference_id

STRING

user_transaction_time

STRING

| | **centre\_key**

STRING | | **creation\_date**

DATE-TIME | | **currency\_code**

STRING | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **encoded\_key**

STRING | | **external\_id**

STRING | | **fees**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand fees

amount

NUMBER

name

STRING

predefined_fee_key

STRING

tax_amount

NUMBER

trigger

STRING

| | **id**

STRING | | **linked\_loan\_transaction\_key**

STRING | | **migration\_event\_key**

STRING | | **notes**

STRING | | **original\_transaction\_key**

STRING | | **parent\_account\_key**

STRING | | **payment\_details**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand payment\_details

creditor

OBJECT

name

STRING

creditor_account

OBJECT

currency

STRING

identification

OBJECT

iban

STRING

other

OBJECT

identification

STRING

scheme

STRING

creditor_agent

OBJECT

financial_institution_identification

OBJECT

bic

STRING

debtor

OBJECT

name

STRING

debtor_account

OBJECT

currency

STRING

identification

OBJECT

iban

STRING

other

OBJECT

identification

STRING

scheme

STRING

debtor_agent

OBJECT

financial_institution_identification

OBJECT

bic

STRING

payment_identification

OBJECT

end_to_end_identification

STRING

instruction_identification

STRING

transaction_identification

STRING

payment_type_information

OBJECT

service_level

OBJECT

code

STRING

remittance_information

OBJECT

structured

OBJECT

creditor_reference_information

OBJECT

reference

STRING

reference_issuer

STRING

reference_type

STRING

unstructured

STRING

| | **taxes**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand taxes

tax_rate

NUMBER

| | **terms**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand terms

interest_settings

OBJECT

interest_rate

NUMBER

overdraft_interest_settings

OBJECT

index_interest_rate

NUMBER

interest_rate

NUMBER

overdraft_settings

OBJECT

overdraft_limit

NUMBER

| | **till\_key**

STRING | | **transaction\_details**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand transaction\_details

transaction_channel_id

STRING

transaction_channel_key

STRING

| | **transfer\_details**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand transfer\_details

linked_deposit_transaction_key

STRING

linked_loan_transaction_key

STRING

| | **type**

STRING | | **user\_key**

STRING | | **value\_date**

DATE-TIME | ### gl\_accounts This table contains information about general ledger accounts. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | gl\_code | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://support.mambu.com/docs/gl-accounts-api "Opens in new tab: Mambu documentation")

[gl_accounts schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/gl_accounts.json "Opens in new tab: gl_accounts schema on GitHub")

[Mambu API method](https://api.mambu.com/v1/#general-ledger-accounts-get-all-gl-accounts "Opens in new tab: Mambu API method") | gl\_accounts table foreign keys | Join gl\_accounts with | on | | --- | --- | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
gl_accounts.gl_code = gl_journal_entries.gl_account.gl_code
``` | gl\_accounts table schema | **activated**

BOOLEAN | | --- | | **allow\_manual\_journal\_entries**

BOOLEAN | | **balance**

NUMBER | | **creation\_date**

DATE-TIME | | **currency**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand currency

code

STRING

currency_symbol_position

STRING

digits_after_decimal

INTEGER

is_base_currency

BOOLEAN

last_modified_date

DATE-TIME

name

STRING

symbol

STRING

| | **encoded\_key**

STRING | | **entry\_id**

STRING | | **gl\_code**

STRING | | **last\_modified\_date**

DATE-TIME | | **name**

STRING | | **strip\_trailing\_zeros**

BOOLEAN | | **type**

STRING | | **usage**

STRING | ### gl\_journal\_entries This table contains information about general ledger entries. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | entry\_id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | booking\_date | | **Useful links** | [Mambu documentation](https://support.mambu.com/docs/gl-journal-entries-api "Opens in new tab: Mambu documentation")

[gl_journal_entries schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/gl_journal_entries.json "Opens in new tab: gl_journal_entries schema on GitHub")

[Mambu API method](https://api.mambu.com/v1/#gl-journal-entries-search-for-gl-journal-entries "Opens in new tab: Mambu API method") | gl\_journal\_entries table foreign keys | Join gl\_journal\_entries with | on | | --- | --- | | [gl_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-accounts) | ```
gl_journal_entries.gl_account.gl_code = gl_accounts.gl_code
``` | | [activities](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#activities) | ```
gl_journal_entries.user_key = activities.user_key
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
gl_journal_entries.user_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
gl_journal_entries.user_key = communications.user_key
```

```
gl_journal_entries.user_key = communications.sender_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
gl_journal_entries.user_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
gl_journal_entries.user_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
gl_journal_entries.user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
gl_journal_entries.user_key = loan_transactions.user_key
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
gl_journal_entries.user_key = tasks.created_by_user_key
```

```
gl_journal_entries.user_key = tasks.assigned_user_key
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
gl_journal_entries.user_key = users.encoded_key
``` | gl\_journal\_entries table schema | **account\_key**

STRING | | --- | | **amount**

NUMBER | | **booking\_date**

DATE-TIME | | **creation\_date**

DATE-TIME | | **encoded\_key**

STRING | | **entry\_date**

DATE-TIME | | **entry\_id**

STRING | | **gl\_account**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand gl\_account

activated

BOOLEAN

allow_manual_journal_entries

BOOLEAN

balance

NUMBER

creation_date

DATE-TIME

currency

OBJECT

code

STRING

currency_symbol_position

STRING

digits_after_decimal

INTEGER

is_base_currency

BOOLEAN

last_modified_date

DATE-TIME

name

STRING

symbol

STRING

encoded_key

STRING

entry_id

STRING

gl_code

STRING

last_modified_date

DATE-TIME

name

STRING

strip_trailing_zeros

BOOLEAN

type

STRING

usage

STRING

| | **product\_key**

STRING | | **transaction\_id**

STRING | | **type**

STRING | | **user\_key**

STRING | ### groups This table contains information about groups. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[groups schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/groups.json "Opens in new tab: groups schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#groups-search "Opens in new tab: Mambu API method") | groups table foreign keys | Join groups with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
groups.assigned_branch_key = branches.encoded_key
```

```
groups.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
groups.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
groups.assigned_branch_key = centres.assigned_branch_key
```

```
groups.assigned_centre_key = centres.encoded_key
```

```
groups.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
groups.custom_fields.id = centres.custom_fields.id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
groups.assigned_branch_key = deposit_transactions.branch_key
```

```
groups.assigned_centre_key = deposit_transactions.centre_key
```

```
groups.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
groups.custom_fields.id = deposit_transactions.custom_fields.id
```

```
groups.assigned_user_key = deposit_transactions.user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
groups.assigned_branch_key = loan_accounts.assigned_branch_key
```

```
groups.assigned_centre_key = loan_accounts.assigned_centre_key
```

```
groups.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
groups.custom_fields.id = loan_accounts.custom_fields.id
```

```
groups.assigned_user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
groups.assigned_branch_key = loan_transactions.branch_key
```

```
groups.assigned_centre_key = loan_transactions.centre_key
```

```
groups.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
groups.custom_fields.id = loan_transactions.custom_fields.id
```

```
groups.assigned_user_key = loan_transactions.user_key
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
groups.assigned_branch_key = users.access.managed_branches.branch_key
```

```
groups.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
groups.custom_fields.id = users.custom_fields.id
```

```
groups.assigned_user_key = users.encoded_key
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
groups.assigned_centre_key = clients.assigned_centre_key
```

```
groups.group_members.client_key = clients.encoded_key
```

```
groups.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
groups.custom_fields.id = clients.custom_fields.id
```

```
groups.assigned_user_key = clients.assigned_user_key
``` | | [activities](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#activities) | ```
groups.group_members.client_key = activities.client_key
```

```
groups.assigned_user_key = activities.user_key
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
groups.group_members.client_key = communications.client_key
```

```
groups.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
groups.custom_fields.id = communications.custom_fields.id
```

```
groups.encoded_key = communications.group_key
```

```
groups.assigned_user_key = communications.user_key
```

```
groups.assigned_user_key = communications.sender_key
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
groups.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
groups.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
groups.custom_fields.field_set_id = custom_field_sets.id
```

```
groups.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
groups.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
groups.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
groups.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
groups.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
groups.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
groups.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
groups.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
groups.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
groups.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
groups.custom_fields.id = tasks.custom_fields.id
```

```
groups.assigned_user_key = tasks.created_by_user_key
```

```
groups.assigned_user_key = tasks.assigned_user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
groups.assigned_user_key = gl_journal_entries.user_key
``` | groups table schema | **addresses**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand addresses

city

STRING

country

STRING

encoded_key

STRING

index_in_list

INTEGER

latitude

NUMBER

line1

STRING

line2

STRING

longitude

NUMBER

parent_key

STRING

postcode

STRING

region

STRING

| | --- | | **assigned\_branch\_key**

STRING | | **assigned\_centre\_key**

STRING | | **assigned\_user\_key**

STRING | | **creation\_date**

DATE-TIME | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **email\_address**

STRING | | **encoded\_key**

STRING | | **group\_members**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand group\_members

client_key

STRING

roles

ARRAY

encoded_key

STRING

group_role_name_key

STRING

role_name

STRING

| | **group\_name**

STRING | | **group\_role\_key**

STRING | | **home\_phone**

STRING | | **id**

STRING | | **last\_modified\_date**

DATE-TIME | | **loan\_cycle**

STRING | | **migration\_event\_key**

STRING | | **mobile\_phone**

STRING | | **notes**

STRING | | **preferred\_language**

STRING | ### index\_rate\_sources This table contains information about index rate sources. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | encoded\_key | | **Useful links** | [index_rate_sources schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/index_rate_sources.json "Opens in new tab: index_rate_sources schema on GitHub")

[Mambu API method](https://api.mambu.com/#mambu-api-v2-index-rate-sources "Opens in new tab: Mambu API method") | index\_rate\_sources table schema | **encoded\_key**

STRING | | --- | | **name**

STRING | | **notes**

STRING | | **type**

STRING | ### installments This table contains information about installments for a loan. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | encoded\_key | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_paid\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/#mambu-api-v2-installments "Opens in new tab: Mambu documentation")

[installments schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/installments.json "Opens in new tab: installments schema on GitHub")

[Mambu API method](https://api.mambu.com/#installments-getall "Opens in new tab: Mambu API method") | installments table schema | **due\_date**

DATE-TIME | | --- | | **encoded\_key**

STRING | | **fee**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand fee

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

| | **interest**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand interest

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

| | **last\_paid\_date**

DATE-TIME | | **number**

STRING | | **parent\_account\_key**

STRING | | **penalty**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand penalty

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

| | **principal**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand principal

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

| | **repaid\_date**

DATE-TIME | | **state**

STRING | ### interest\_accrual\_breakdown This table contains information about interest accruals. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | entry\_id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | creation\_date | | **Useful links** | [interest_accrual_breakdown schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/helpers/schemas/interest_accrual_breakdown.json "Opens in new tab: interest_accrual_breakdown schema on GitHub") | interest\_accrual\_breakdown table schema | **account\_id**

STRING | | --- | | **account\_key**

STRING | | **amount**

NUMBER | | **booking\_date**

DATE-TIME | | **branch\_key**

STRING | | **branch\_name**

STRING | | **creation\_date**

DATE-TIME | | **entry\_id**

INTEGER | | **entry\_type**

STRING | | **foreign\_amount**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand foreign\_amount

accounting_rate

OBJECT

encoded_key

STRING

end_date

DATE-TIME

from_currency_code

STRING

rate

NUMBER

start_date

DATE-TIME

to_currency_code

STRING

amount

NUMBER

currency

OBJECT

code

STRING

| | **gl\_account\_id**

STRING | | **gl\_account\_key**

STRING | | **gl\_account\_name**

STRING | | **gl\_account\_type**

STRING | | **parent\_entry\_id**

INTEGER | | **product\_id**

STRING | | **product\_key**

STRING | | **product\_type**

STRING | | **transaction\_id**

STRING | ### loan\_accounts This table contains information about Loan Accounts. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[loan_accounts schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/loan_accounts.json "Opens in new tab: loan_accounts schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#loan-accounts-search "Opens in new tab: Mambu API method") | loan\_accounts table foreign keys | Join loan\_accounts with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
loan_accounts.assigned_branch_key = branches.encoded_key
```

```
loan_accounts.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
loan_accounts.assigned_branch_key = centres.assigned_branch_key
```

```
loan_accounts.assigned_centre_key = centres.encoded_key
```

```
loan_accounts.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = centres.custom_fields.id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
loan_accounts.assigned_branch_key = deposit_transactions.branch_key
```

```
loan_accounts.assigned_centre_key = deposit_transactions.centre_key
```

```
loan_accounts.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = deposit_transactions.custom_fields.id
```

```
loan_accounts.assigned_user_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
loan_accounts.assigned_branch_key = groups.assigned_branch_key
```

```
loan_accounts.assigned_centre_key = groups.assigned_centre_key
```

```
loan_accounts.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = groups.custom_fields.id
```

```
loan_accounts.assigned_user_key = groups.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
loan_accounts.assigned_branch_key = loan_transactions.branch_key
```

```
loan_accounts.assigned_centre_key = loan_transactions.centre_key
```

```
loan_accounts.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = loan_transactions.custom_fields.id
```

```
loan_accounts.assigned_user_key = loan_transactions.user_key
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
loan_accounts.assigned_branch_key = users.access.managed_branches.branch_key
```

```
loan_accounts.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = users.custom_fields.id
```

```
loan_accounts.assigned_user_key = users.encoded_key
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
loan_accounts.assigned_centre_key = clients.assigned_centre_key
```

```
loan_accounts.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = clients.custom_fields.id
```

```
loan_accounts.assigned_user_key = clients.assigned_user_key
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
loan_accounts.credit_arrangement_key = credit_arrangements.encoded_key
```

```
loan_accounts.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
loan_accounts.credit_arrangement_key = deposit_accounts.credit_arrangement_key
```

```
loan_accounts.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = deposit_accounts.custom_fields.id
```

```
loan_accounts.disbursement_details.transaction_details.target_deposit_account_key = deposit_accounts.encoded_key
```

```
loan_accounts.funding_sources.deposit_account_key = deposit_accounts.encoded_key
```

```
loan_accounts.guarantors.deposit_account_key = deposit_accounts.encoded_key
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
loan_accounts.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = communications.custom_fields.id
```

```
loan_accounts.disbursement_details.transaction_details.target_deposit_account_key = communications.deposit_account_key
```

```
loan_accounts.funding_sources.deposit_account_key = communications.deposit_account_key
```

```
loan_accounts.guarantors.deposit_account_key = communications.deposit_account_key
```

```
loan_accounts.encoded_key = communications.loan_account_key
```

```
loan_accounts.assigned_user_key = communications.user_key
```

```
loan_accounts.assigned_user_key = communications.sender_key
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
loan_accounts.custom_fields.field_set_id = custom_field_sets.id
```

```
loan_accounts.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
loan_accounts.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
loan_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
loan_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
loan_accounts.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
loan_accounts.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
loan_accounts.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
loan_accounts.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
loan_accounts.custom_fields.id = tasks.custom_fields.id
```

```
loan_accounts.assigned_user_key = tasks.created_by_user_key
```

```
loan_accounts.assigned_user_key = tasks.assigned_user_key
``` | | [activities](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#activities) | ```
loan_accounts.assigned_user_key = activities.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
loan_accounts.assigned_user_key = gl_journal_entries.user_key
``` | loan\_accounts table schema | **account\_arrears\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand account\_arrears\_settings

date_calculation_method

STRING

encoded_key

STRING

monthly_tolerance_day

INTEGER

non_working_days_method

STRING

tolerance_calculation_method

STRING

tolerance_period

INTEGER

| | --- | | **account\_holder\_key**

STRING | | **account\_holder\_type**

STRING | | **account\_state**

STRING | | **account\_sub\_state**

STRING | | **accrued\_interest**

NUMBER | | **accrued\_penalty**

NUMBER | | **activation\_transaction\_key**

STRING | | **allow\_offset**

BOOLEAN | | **approved\_date**

DATE-TIME | | **arrears\_tolerance\_period**

INTEGER | | **assets**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand assets

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

| | **assigned\_branch\_key**

STRING | | **assigned\_centre\_key**

STRING | | **assigned\_user\_key**

STRING | | **balances**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand balances

fees_balance

NUMBER

fees_due

NUMBER

fees_paid

NUMBER

interest_balance

NUMBER

interest_due

NUMBER

interest_from_arrears_balance

NUMBER

interest_from_arrears_due

NUMBER

interest_from_arrears_paid

NUMBER

interest_paid

NUMBER

penalty_balance

NUMBER

penalty_due

NUMBER

penalty_paid

NUMBER

principal_balance

NUMBER

principal_due

NUMBER

principal_paid

NUMBER

redraw_balance

NUMBER

| | **closed\_date**

DATE-TIME | | **creation\_date**

DATE-TIME | | **credit\_arrangement\_key**

STRING | | **currency**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand currency

code

STRING

| | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **days\_in\_arrears**

INTEGER | | **days\_late**

INTEGER | | **disbursement\_details**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand disbursement\_details

disbursement_date

DATE-TIME

encoded_key

STRING

expected_disbursement_date

DATE-TIME

fees

ARRAY

amount

NUMBER

encoded_key

STRING

predefined_fee_encoded_key

STRING

first_repayment_date

DATE-TIME

transaction_details

OBJECT

encoded_key

STRING

internal_transfer

BOOLEAN

target_deposit_account_key

STRING

transaction_channel_id

STRING

transaction_channel_key

STRING

| | **encoded\_key**

STRING | | **funding\_sources**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand funding\_sources

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

interest_commission

NUMBER

share_percentage

NUMBER

| | **future\_payments\_acceptance**

STRING | | **guarantors**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand guarantors

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

| | **id**

STRING | | **interest\_commission**

NUMBER | | **interest\_from\_arrears\_accrued**

NUMBER | | **interest\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand interest\_settings

accrue_interest_after_maturity

BOOLEAN

interest_application_method

STRING

interest_balance_calculation_method

STRING

interest_calculation_method

STRING

interest_charge_frequency

STRING

interest_rate

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_spread

NUMBER

interest_type

STRING

| | **last\_account\_appraisal\_date**

DATE-TIME | | **last\_appraisal\_date**

DATE-TIME | | **last\_interest\_applied\_date**

DATE-TIME | | **last\_interest\_review\_date**

DATE-TIME | | **last\_locked\_date**

DATE-TIME | | **last\_modified\_date**

DATE-TIME | | **last\_set\_to\_arrears\_date**

DATE-TIME | | **last\_tax\_rate\_review\_date**

DATE-TIME | | **late\_payments\_recalculation\_method**

STRING | | **loan\_amount**

NUMBER | | **loan\_name**

STRING | | **locked\_operations**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **migration\_event\_key**

STRING | | **notes**

STRING | | **original\_account\_key**

STRING | | **payment\_method**

STRING | | **penalty\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand penalty\_settings

loan_penalty_calculation_method

STRING

penalty_rate

NUMBER

| | **prepayment\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand prepayment\_settings

apply_interest_on_prepayment_method

STRING

elements_recalculation_method

STRING

prepayment_recalculation_method

STRING

principal-paid_installment_status

STRING

| | **principal\_payment\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand principal\_payment\_settings

amount

NUMBER

encoded_key

STRING

include_fees_in_floor_amount

BOOLEAN

include_interest_in_floor_amount

BOOLEAN

percentage

NUMBER

principal_ceiling_value

NUMBER

principal_floor_value

NUMBER

principal_payment_method

STRING

total_due_amount_floor

NUMBER

total_due_payment

STRING

| | **product\_type\_key**

STRING | | **rescheduled\_account\_key**

STRING | | **schedule\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand schedule\_settings

default_first_repayment_due_date_offset

INTEGER

fixed_days_of_month

ARRAY

grace_period

INTEGER

grace_period_type

STRING

has_custom_schedule

BOOLEAN

payment_plan

ARRAY

amount

NUMBER

encoded_key

STRING

to_installment

INTEGER

periodic_payment

NUMBER

principal_repayment_interval

INTEGER

repayment_installments

INTEGER

repayment_period_count

INTEGER

repayment_period_unit

STRING

repayment_schedule_method

STRING

schedule_due_dates_method

STRING

short_month_handling_method

STRING

| | **settlement\_account\_key**

STRING | | **tax\_rate**

NUMBER | | **tranches**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand tranches

amount

NUMBER

disbursement_details

OBJECT

disbursement_transaction_key

STRING

expected_disbursement_date

DATE-TIME

encoded_key

STRING

tranch_number

STRING

| ### loan\_products This table contains information about loan products. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[loan_products schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/loan_products.json "Opens in new tab: loan_products schema on GitHub")

[Mambu API method](https://api.mambu.com/v1/#loan-products-get-all-loan-products "Opens in new tab: Mambu API method") | loan\_products table foreign keys | Join loan\_products with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = branches.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = branches.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = centres.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = centres.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = centres.custom_fields.id
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = clients.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = clients.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = clients.custom_fields.id
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = communications.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = communications.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = communications.custom_fields.id
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = credit_arrangements.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = credit_arrangements.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = custom_field_sets.id
```

```
loan_products.custom_field_values.custom_field.id = custom_field_sets.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = deposit_accounts.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = deposit_accounts.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
loan_products.custom_field_values.custom_field.id = deposit_products.custom_field_values.custom_field.id
```

```
loan_products.custom_field_values.custom_field_id = deposit_products.custom_field_values.custom_field.id
```

```
loan_products.custom_field_values.custom_field.id = deposit_products.custom_field_values.custom_field_id
```

```
loan_products.custom_field_values.custom_field_id = deposit_products.custom_field_values.custom_field_id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = deposit_transactions.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = deposit_transactions.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = deposit_transactions.custom_fields.id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = groups.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = groups.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = groups.custom_fields.id
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = loan_accounts.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = loan_accounts.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = loan_accounts.custom_fields.id
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = loan_transactions.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = loan_transactions.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = loan_transactions.custom_fields.id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = tasks.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = tasks.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = tasks.custom_fields.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
loan_products.custom_field_values.custom_field.custom_field_set.id = users.custom_fields.field_set_id
```

```
loan_products.custom_field_values.custom_field.id = users.custom_fields.id
```

```
loan_products.custom_field_values.custom_field_id = users.custom_fields.id
``` | loan\_products table schema | **account\_initial\_state**

STRING | | --- | | **account\_linking\_enabled**

BOOLEAN | | **accounting\_method**

STRING | | **activated**

BOOLEAN | | **allow\_arbitrary\_fees**

BOOLEAN | | **allow\_collateral**

BOOLEAN | | **allow\_guarantors**

BOOLEAN | | **amortization\_method**

STRING | | **apply\_interest\_on\_prepayment\_method**

STRING | | **arrears\_date\_calculation\_method**

STRING | | **arrears\_non\_working\_days\_method**

STRING | | **arrears\_tolerance\_period**

INTEGER | | **auto\_create\_linked\_accounts**

BOOLEAN | | **auto\_link\_accounts**

BOOLEAN | | **automatically\_close\_dormant\_accounts**

BOOLEAN | | **creation\_date**

DATE-TIME | | **custom\_field\_values**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_field\_values

amount

STRING

custom_field

OBJECT

amounts

OBJECT

custom_field_selection_options

ARRAY

encoded_key

STRING

score

STRING

value

STRING

custom_field_set

OBJECT

creation_date

DATE-TIME

encoded_key

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

type

STRING

usage

STRING

data_type

STRING

edit_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

custom_field_id

STRING

custom_field_key

STRING

custom_field_set_group_index

INTEGER

encoded_key

STRING

index_in_list

INTEGER

parent_key

STRING

value

STRING

| | **days\_in\_year**

STRING | | **declining\_balance\_prepayment\_recalculation**

STRING | | **default\_loan\_amount**

STRING | | **default\_num\_installments**

INTEGER | | **default\_principal\_repayment\_interval**

INTEGER | | **default\_repayment\_period\_count**

INTEGER | | **encoded\_key**

STRING | | **for\_hybrid\_groups**

BOOLEAN | | **for\_individuals**

BOOLEAN | | **for\_pure\_groups**

BOOLEAN | | **future\_payments\_acceptance**

STRING | | **grace\_period\_type**

STRING | | **id**

STRING | | **id\_generator\_type**

STRING | | **id\_pattern**

STRING | | **interest\_accrued\_accounting\_method**

STRING | | **interest\_application\_method**

STRING | | **interest\_balance\_calculation\_method**

STRING | | **interest\_calculation\_method**

STRING | | **interest\_charge\_frequency**

STRING | | **interest\_rate\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand interest\_rate\_settings

default_interest_rate

STRING

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

| | **is\_investor\_funds\_enabled**

BOOLEAN | | **last\_modified\_date**

DATE-TIME | | **late\_payments\_recalculation\_method**

STRING | | **line\_of\_credit\_requirement**

STRING | | **loan\_fees**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand loan\_fees

active

BOOLEAN

amoritization_profile

STRING

amortization_interval_settings

OBJECT

encoded_key

STRING

frequency

STRING

interval_count

INTEGER

period_count

INTEGER

period_unit

STRING

amount

STRING

amount_calculation_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

fee_product_rules

ARRAY

name

STRING

trigger

STRING

| | **loan\_penalty\_calculation\_method**

STRING | | **loan\_product\_rules**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **loan\_product\_type**

STRING | | **loan\_type**

STRING | | **max\_number\_of\_disbursement\_tranches**

INTEGER | | **payment\_method**

STRING | | **prepayment\_acceptance**

STRING | | **product\_description**

STRING | | **product\_name**

STRING | | **product\_security\_settings**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand product\_security\_settings

encoded_key

STRING

is_collateral_enabled

BOOLEAN

is_guarantors_enabled

BOOLEAN

is_investor_funds_enabled

BOOLEAN

required_guaranties

STRING

| | **repayment\_allocation\_order**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **repayment\_currency\_rounding**

STRING | | **repayment\_elements\_rounding\_method**

STRING | | **repayment\_period\_unit**

STRING | | **repayment\_rescheduling\_method**

STRING | | **repayment\_schedule\_edit\_options**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **repayment\_schedule\_method**

STRING | | **required\_guaranty\_percentage**

STRING | | **rounding\_repayment\_schedule\_method**

STRING | | **schedule\_due\_dates\_method**

STRING | | **schedule\_interest\_days\_count\_method**

STRING | | **settlement\_options**

STRING | | **taxes\_on\_fees\_enabled**

BOOLEAN | | **taxes\_on\_interest\_enabled**

BOOLEAN | | **taxes\_on\_penalty\_enabled**

BOOLEAN | | **templates**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand templates

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

amount

STRING

custom_field

OBJECT

amounts

OBJECT

custom_field_selection_options

ARRAY

encoded_key

STRING

score

STRING

value

STRING

custom_field_set

OBJECT

creation_date

DATE-TIME

encoded_key

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

type

STRING

usage

STRING

data_type

STRING

edit_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

custom_field_id

STRING

custom_field_key

STRING

custom_field_set_group_index

INTEGER

encoded_key

STRING

index_in_list

INTEGER

parent_key

STRING

value

STRING

default_interest_rate

STRING

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

active

BOOLEAN

amoritization_profile

STRING

amortization_interval_settings

OBJECT

encoded_key

STRING

frequency

STRING

interval_count

INTEGER

period_count

INTEGER

period_unit

STRING

amount

STRING

amount_calculation_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

fee_product_rules

ARRAY

name

STRING

trigger

STRING

encoded_key

STRING

is_collateral_enabled

BOOLEAN

is_guarantors_enabled

BOOLEAN

is_investor_funds_enabled

BOOLEAN

required_guaranties

STRING

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

| ### loan\_repayments This is a child table of `loan_accounts`, containing information exclusively about loan repayments. **Note**: In order to replicate this table, you must also set the [loan_account](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-account) table to replicate. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | encoded\_key | | | loan\_account | | **Useful links** | [loan_repayments schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/loan_repayments.json "Opens in new tab: loan_repayments schema on GitHub")

[Mambu API method](https://api.mambu.com/v1/#loan-accounts-get-repayments-for-a-loan-account "Opens in new tab: Mambu API method") | loan\_repayments table schema | **due\_date**

DATE-TIME | | --- | | **encoded\_key**

STRING | | **fees\_due**

NUMBER | | **fees\_paid**

NUMBER | | **interest\_due**

NUMBER | | **interest\_paid**

NUMBER | | **parent\_account\_key**

STRING | | **penalty\_due**

NUMBER | | **penalty\_paid**

NUMBER | | **principal\_due**

NUMBER | | **principal\_paid**

NUMBER | | **state**

STRING | | **tax\_fees\_due**

NUMBER | | **tax\_fees\_paid**

NUMBER | | **tax\_interest\_due**

NUMBER | | **tax\_interest\_paid**

NUMBER | | **tax\_penalty\_due**

NUMBER | | **tax\_penalty\_paid**

NUMBER | ### loan\_transactions This table contains information about loan transactions. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | encoded\_key | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | creation\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[loan_transactions schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/loan_transactions.json "Opens in new tab: loan_transactions schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#loantransactions-getall "Opens in new tab: Mambu API method") | loan\_transactions table foreign keys | Join loan\_transactions with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
loan_transactions.branch_key = branches.encoded_key
```

```
loan_transactions.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
loan_transactions.branch_key = centres.assigned_branch_key
```

```
loan_transactions.centre_key = centres.encoded_key
```

```
loan_transactions.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = centres.custom_fields.id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
loan_transactions.branch_key = deposit_transactions.branch_key
```

```
loan_transactions.centre_key = deposit_transactions.centre_key
```

```
loan_transactions.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = deposit_transactions.custom_fields.id
```

```
loan_transactions.transfer_details.linked_deposit_transaction_key = deposit_transactions.transfer_details.linked_deposit_transaction_key
```

```
loan_transactions.encoded_key = deposit_transactions.linked_loan_transaction_key
```

```
loan_transactions.linked_loan_transaction_key = deposit_transactions.linked_loan_transaction_key
```

```
loan_transactions.parent_loan_transaction_key = deposit_transactions.linked_loan_transaction_key
```

```
loan_transactions.transfer_details.linked_loan_transaction_key = deposit_transactions.linked_loan_transaction_key
```

```
loan_transactions.encoded_key = deposit_transactions.transfer_details.linked_loan_transaction_key
```

```
loan_transactions.linked_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key
```

```
loan_transactions.parent_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key
```

```
loan_transactions.transfer_details.linked_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key
```

```
loan_transactions.user_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
loan_transactions.branch_key = groups.assigned_branch_key
```

```
loan_transactions.centre_key = groups.assigned_centre_key
```

```
loan_transactions.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = groups.custom_fields.id
```

```
loan_transactions.user_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
loan_transactions.branch_key = loan_accounts.assigned_branch_key
```

```
loan_transactions.centre_key = loan_accounts.assigned_centre_key
```

```
loan_transactions.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = loan_accounts.custom_fields.id
```

```
loan_transactions.user_key = loan_accounts.assigned_user_key
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
loan_transactions.branch_key = users.access.managed_branches.branch_key
```

```
loan_transactions.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = users.custom_fields.id
```

```
loan_transactions.user_key = users.encoded_key
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
loan_transactions.centre_key = clients.assigned_centre_key
```

```
loan_transactions.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = clients.custom_fields.id
```

```
loan_transactions.user_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
loan_transactions.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = communications.custom_fields.id
```

```
loan_transactions.user_key = communications.user_key
```

```
loan_transactions.user_key = communications.sender_key
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
loan_transactions.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
loan_transactions.custom_fields.field_set_id = custom_field_sets.id
```

```
loan_transactions.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
loan_transactions.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
loan_transactions.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
loan_transactions.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
loan_transactions.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
loan_transactions.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
loan_transactions.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
loan_transactions.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
loan_transactions.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
loan_transactions.custom_fields.id = tasks.custom_fields.id
```

```
loan_transactions.user_key = tasks.created_by_user_key
```

```
loan_transactions.user_key = tasks.assigned_user_key
``` | | [activities](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#activities) | ```
loan_transactions.user_key = activities.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
loan_transactions.user_key = gl_journal_entries.user_key
``` | loan\_transactions table schema | **account\_balances**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand account\_balances

advance_position

NUMBER

arrears_position

NUMBER

expected_principal_redraw

NUMBER

principal_balance

NUMBER

redraw_balance

NUMBER

total_balance

NUMBER

deferred_interest_amount

NUMBER

fees_amount

NUMBER

fraction_amount

NUMBER

funders_interest_amount

NUMBER

funds_amount

NUMBER

interest_amount

NUMBER

interest_from_arrears_amount

NUMBER

organization_commission_amount

NUMBER

overdraft_amount

NUMBER

overdraft_fees_amount

NUMBER

overdraft_interest_amount

NUMBER

payment_holidays_interest_amount

NUMBER

penalty_amount

NUMBER

principal_amount

NUMBER

technical_overdraft_amount

NUMBER

technical_overdraft_interest_amount

NUMBER

advice

BOOLEAN

amount

NUMBER

card_acceptor

OBJECT

city

STRING

country

STRING

mcc

INTEGER

name

STRING

state

STRING

street

STRING

zip

STRING

card_token

STRING

currency_code

STRING

encoded_key

STRING

external_authorization_reference_id

STRING

external_reference_id

STRING

user_transaction_time

STRING

| | **centre\_key**

STRING | | **creation\_date**

DATE-TIME | | **currency**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand currency

code

STRING

field_set_id

STRING

value

STRING

| | **custom\_payment\_amounts**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_payment\_amounts

amount

NUMBER

custom_payment_amount_type

STRING

predefined_fee_key

STRING

tax_on_amount

NUMBER

amount

NUMBER

name

STRING

predefined_fee_key

STRING

tax_amount

NUMBER

trigger

STRING

| | **id**

STRING | | **installment\_encoded\_key**

STRING | | **linked\_loan\_transaction\_key**

STRING | | **migration\_event\_key**

STRING | | **notes**

STRING | | **original\_amount**

NUMBER | | **original\_currency\_code**

STRING | | **original\_transaction\_key**

STRING | | **parent\_account\_key**

STRING | | **parent\_loan\_transaction\_key**

STRING | | **prepayment\_recalculation\_method**

STRING | | **taxes**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand taxes

deferred_tax_on_interest_amount

NUMBER

tax_interest_from_arrears_amount

NUMBER

tax_on_fees_amount

NUMBER

tax_on_interest_amount

NUMBER

tax_on_interest_from_arrears_amount

NUMBER

tax_on_payment_holidays_interest

NUMBER

tax_on_penalty_amount

NUMBER

tax_rate

NUMBER

interest_settings

OBJECT

index_interest_rate

NUMBER

interest_rate

NUMBER

periodic_payment

NUMBER

principal_payment_amount

NUMBER

principal_payment_percentage

NUMBER

transaction_channel_id

STRING

transaction_channel_key

STRING

linked_deposit_transaction_key

STRING

linked_loan_transaction_key

STRING

| | **type**

STRING | | **user\_key**

STRING | | **value\_date**

DATE-TIME | ### tasks This table contains information about tasks. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[tasks schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/tasks.json "Opens in new tab: tasks schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#tasks-getall "Opens in new tab: Mambu API method") | tasks table foreign keys | Join tasks with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
tasks.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
tasks.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
tasks.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
tasks.custom_fields.id = centres.custom_fields.id
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
tasks.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
tasks.custom_fields.id = clients.custom_fields.id
```

```
tasks.created_by_user_key = clients.assigned_user_key
```

```
tasks.assigned_user_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
tasks.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
tasks.custom_fields.id = communications.custom_fields.id
```

```
tasks.created_by_user_key = communications.user_key
```

```
tasks.assigned_user_key = communications.user_key
```

```
tasks.created_by_user_key = communications.sender_key
```

```
tasks.assigned_user_key = communications.sender_key
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
tasks.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
tasks.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
tasks.custom_fields.field_set_id = custom_field_sets.id
```

```
tasks.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
tasks.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
tasks.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
tasks.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
tasks.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
tasks.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
tasks.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
tasks.custom_fields.id = deposit_transactions.custom_fields.id
```

```
tasks.created_by_user_key = deposit_transactions.user_key
```

```
tasks.assigned_user_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
tasks.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
tasks.custom_fields.id = groups.custom_fields.id
```

```
tasks.created_by_user_key = groups.assigned_user_key
```

```
tasks.assigned_user_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
tasks.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
tasks.custom_fields.id = loan_accounts.custom_fields.id
```

```
tasks.created_by_user_key = loan_accounts.assigned_user_key
```

```
tasks.assigned_user_key = loan_accounts.assigned_user_key
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
tasks.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
tasks.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
tasks.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
tasks.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
tasks.custom_fields.id = loan_transactions.custom_fields.id
```

```
tasks.created_by_user_key = loan_transactions.user_key
```

```
tasks.assigned_user_key = loan_transactions.user_key
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#users) | ```
tasks.custom_fields.field_set_id = users.custom_fields.field_set_id
```

```
tasks.custom_fields.id = users.custom_fields.id
```

```
tasks.created_by_user_key = users.encoded_key
```

```
tasks.assigned_user_key = users.encoded_key
``` | | [activities](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#activities) | ```
tasks.created_by_user_key = activities.user_key
```

```
tasks.assigned_user_key = activities.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
tasks.created_by_user_key = gl_journal_entries.user_key
```

```
tasks.assigned_user_key = gl_journal_entries.user_key
``` | tasks table schema | **assigned\_user\_key**

STRING | | --- | | **created\_by\_full\_name**

STRING | | **created\_by\_user\_key**

STRING | | **creation\_date**

DATE-TIME | | **custom\_fields**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand custom\_fields

field_set_id

STRING

value

STRING

| | **description**

STRING | | **due\_date**

DATE | | **encoded\_key**

STRING | | **id**

STRING | | **last\_modified\_date**

DATE-TIME | | **state**

STRING | | **status**

STRING | | **task\_link**

STRING | | **task\_link\_key**

STRING | | **task\_link\_type**

STRING | | **title**

STRING | ### users This table contains information about users. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome "Opens in new tab: Mambu documentation")

[users schema on GitHub](https://github.com/singer-io/tap-mambu/blob/master/tap_mambu/schemas/users.json "Opens in new tab: users schema on GitHub")

[Mambu API method](https://api.mambu.com/?http#users-getall "Opens in new tab: Mambu API method") | users table foreign keys | Join users with | on | | --- | --- | | [branches](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#branches) | ```
users.access.managed_branches.branch_key = branches.encoded_key
```

```
users.custom_fields.field_set_id = branches.custom_fields.field_set_id
```

```
users.custom_fields.id = branches.custom_fields.id
``` | | [centres](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#centres) | ```
users.access.managed_branches.branch_key = centres.assigned_branch_key
```

```
users.custom_fields.field_set_id = centres.custom_fields.field_set_id
```

```
users.custom_fields.id = centres.custom_fields.id
``` | | [deposit_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-transactions) | ```
users.access.managed_branches.branch_key = deposit_transactions.branch_key
```

```
users.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
```

```
users.custom_fields.id = deposit_transactions.custom_fields.id
```

```
users.encoded_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#groups) | ```
users.access.managed_branches.branch_key = groups.assigned_branch_key
```

```
users.custom_fields.field_set_id = groups.custom_fields.field_set_id
```

```
users.custom_fields.id = groups.custom_fields.id
```

```
users.encoded_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-accounts) | ```
users.access.managed_branches.branch_key = loan_accounts.assigned_branch_key
```

```
users.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
```

```
users.custom_fields.id = loan_accounts.custom_fields.id
```

```
users.encoded_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-transactions) | ```
users.access.managed_branches.branch_key = loan_transactions.branch_key
```

```
users.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
```

```
users.custom_fields.id = loan_transactions.custom_fields.id
```

```
users.encoded_key = loan_transactions.user_key
``` | | [clients](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#clients) | ```
users.custom_fields.field_set_id = clients.custom_fields.field_set_id
```

```
users.custom_fields.id = clients.custom_fields.id
```

```
users.encoded_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#communications) | ```
users.custom_fields.field_set_id = communications.custom_fields.field_set_id
```

```
users.custom_fields.id = communications.custom_fields.id
```

```
users.encoded_key = communications.user_key
```

```
users.encoded_key = communications.sender_key
``` | | [credit_arrangements](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#credit-arrangements) | ```
users.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
```

```
users.custom_fields.id = credit_arrangements.custom_fields.id
``` | | [custom_field_sets](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#custom-field-sets) | ```
users.custom_fields.field_set_id = custom_field_sets.id
```

```
users.custom_fields.id = custom_field_sets.custom_fields.id
``` | | [deposit_accounts](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-accounts) | ```
users.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
```

```
users.custom_fields.id = deposit_accounts.custom_fields.id
``` | | [deposit_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#deposit-products) | ```
users.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
```

```
users.custom_fields.id = deposit_products.custom_field_values.custom_field.id
```

```
users.custom_fields.id = deposit_products.custom_field_values.custom_field_id
``` | | [loan_products](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#loan-products) | ```
users.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
```

```
users.custom_fields.id = loan_products.custom_field_values.custom_field.id
```

```
users.custom_fields.id = loan_products.custom_field_values.custom_field_id
``` | | [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#tasks) | ```
users.custom_fields.field_set_id = tasks.custom_fields.field_set_id
```

```
users.custom_fields.id = tasks.custom_fields.id
```

```
users.encoded_key = tasks.created_by_user_key
```

```
users.encoded_key = tasks.assigned_user_key
``` | | [activities](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#activities) | ```
users.encoded_key = activities.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/stitch/integrations/saas/mambu/v2#gl-journal-entries) | ```
users.encoded_key = gl_journal_entries.user_key
``` | users table schema | **access**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand access

administrator_access

BOOLEAN

api_access

BOOLEAN

can_manage_all_branches

BOOLEAN

can_manage_entities_assigned_to_other_officers

STRING

credit_officer_access

BOOLEAN

mambu_access

BOOLEAN

managed_branches

ARRAY

branch_key

STRING

permissions

ARRAY

support_access

BOOLEAN

teller_access

BOOLEAN

field_set_id

STRING

value

STRING