# Mambu Mambu is a cloud-native, API-driven, composable banking and financial services platform. For more information about the API, see the [Mambu v2.0](https://api.mambu.com/?shell#Welcome) and [v1.0 APIs](https://api.mambu.com/v1/#welcome). See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#Schema) section for a list of objects available for replication. ## Preparing for authentication To access your data, you need to authenticate the connection with your account credentials. Information noteMake sure that the account you use has read access to the tables you want to fetch. To authenticate audit trail requests you must use an API key generated by an API consumer that has the Manage Audit Trail (MANAGE\_AUDIT\_TRAIL) permission assigned to it. For more information, see [API Consumers](https://support.mambu.com/docs/api-consumers) in Mambu documentation. You need a Mambu account with API access. In Mambu’s app, API access can be granted to any existing user. To find the time zone information: 1. Log into your Mambu account. 2. Go to Administration > General Setup > Organization Details. 3. Under Time Zone, copy the information. ## Creating the connection For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm). 1. Fill in the required connection properties. 2. Provide a name for the connection in Connection name. 3. Select Open connection metadata to define metadata for the connection when it has been created. 4. Click Create. Connection settings | Setting | Description | | --- | --- | | Data gateway | Select a Data Movement gateway if required by your use case.

Information note

This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.

For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). | | Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. | | Subdomain | Subdomain. Example: If the subdomain is `qlik.mambu.com`, enter `qlik` . | | Username | Mambu username. | | Password | Mambu password. | | Audit Trail API Key | Audit trail API key. | | Time Zone | Time defined in Mambu. | ## Schema Information note Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing. Depending on your destination, table and column names may not appear as they are outlined below. ### activities This table contains information about activities. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | encoded\_key | | **Replication Key** | timestamp | | **Useful links** | [Mambu documentation](https://support.mambu.com/docs/tracking-activities)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
activities.client_key = clients.encoded_key
```

```
activities.user_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
activities.client_key = groups.group_members.client_key
```

```
activities.user_key = groups.assigned_user_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
activities.user_key = deposit_transactions.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-journal-entries) | ```
activities.user_key = gl_journal_entries.user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
activities.user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
activities.user_key = loan_transactions.user_key
``` | | [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#tasks) | ```
activities.user_key = tasks.created_by_user_key
```

```
activities.user_key = tasks.assigned_user_key
``` | | [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
activities.user_key = users.encoded_key
``` | activities table schema | **assigned\_centre\_key**

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

STRING | | **branch\_key**

STRING | | **branch\_name**

STRING | | **centre\_key**

STRING | | **centre\_name**

STRING | | **client\_key**

STRING | | **client\_name**

STRING | | **encoded\_key**

STRING | | **field\_changes**

ARRAY

This is a nested data structure:

field_change_name: STRING
field_detail_key: STRING
field_detail_name: STRING
id: STRING
new_value: STRING
original_value: STRING

| | **gl\_account\_key**

STRING | | **gl\_accounts\_closure\_key**

STRING | | **group\_key**

STRING | | **group\_name**

STRING | | **line\_of\_credit\_key**

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

STRING | | **loan\_account\_name**

STRING | | **loan\_product\_key**

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

STRING | | **notes**

STRING | | **savings\_account\_key**

STRING | | **savings\_account\_name**

STRING | | **savings\_product\_key**

STRING | | **savings\_product\_name**

STRING | | **task\_key**

STRING | | **task\_name**

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** | CDC | | --- | --- | | **Replication Key** | occurred\_at | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#centres) | ```
branches.encoded_key = centres.assigned_branch_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
branches.encoded_key = deposit_transactions.branch_key
``` | | [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
branches.encoded_key = groups.assigned_branch_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
branches.encoded_key = loan_accounts.assigned_branch_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
branches.encoded_key = loan_transactions.branch_key
``` | | [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
branches.encoded_key = users.access.managed_branches.branch_key
``` | branches table schema | **addresses**

ARRAY

This is a nested data structure:

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:

creation_date: DATE-TIME
date: DATE
encoded_key: STRING
id: INTEGER
is_annually_recurring: BOOLEAN
name: STRING

| | **creation\_date**

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

ARRAY | | **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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-account) table to replicate. | **Replication Method** | Full Table | | --- | --- | | **Primary Keys** | deposit\_id

reference\_token | | | deposit-account | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#branches) | ```
centres.assigned_branch_key = branches.encoded_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
centres.assigned_branch_key = deposit_transactions.branch_key
```

```
centres.encoded_key = deposit_transactions.centre_key
``` | | [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
centres.assigned_branch_key = groups.assigned_branch_key
```

```
centres.encoded_key = groups.assigned_centre_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
centres.assigned_branch_key = loan_accounts.assigned_branch_key
```

```
centres.encoded_key = loan_accounts.assigned_centre_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
centres.assigned_branch_key = loan_transactions.branch_key
```

```
centres.encoded_key = loan_transactions.centre_key
``` | | [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
centres.assigned_branch_key = users.access.managed_branches.branch_key
``` | | [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
centres.encoded_key = clients.assigned_centre_key
``` | centres table schema | **addresses**

ARRAY

This is a nested data structure:

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 | | **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** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#centres) | ```
clients.assigned_centre_key = centres.encoded_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
clients.assigned_centre_key = deposit_transactions.centre_key
```

```
clients.assigned_user_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
clients.assigned_centre_key = groups.assigned_centre_key
```

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

```
clients.assigned_user_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
clients.assigned_centre_key = loan_accounts.assigned_centre_key
```

```
clients.assigned_user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
clients.assigned_centre_key = loan_transactions.centre_key
```

```
clients.assigned_user_key = loan_transactions.user_key
``` | | [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#activities) | ```
clients.encoded_key = activities.client_key
```

```
clients.assigned_user_key = activities.user_key
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#communications) | ```
clients.encoded_key = communications.client_key
```

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

```
clients.assigned_user_key = communications.sender_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-journal-entries) | ```
clients.assigned_user_key = gl_journal_entries.user_key
``` | | [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#tasks) | ```
clients.assigned_user_key = tasks.created_by_user_key
```

```
clients.assigned_user_key = tasks.assigned_user_key
``` | | [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
clients.assigned_user_key = users.encoded_key
``` | clients table schema | **activation\_date**

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

ARRAY

This is a nested data structure:

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

attachments: ARRAY, which is also a nested data structure:
- creation_date: DATE-TIME
- encoded_key: STRING
- file_name: STRING
- file_size: INTEGER
- id: INTEGER
- last_modified_date: DATE-TIME
- location: STRING
- name: STRING
- notes: STRING
- owner_key: STRING
- owner_type: STRING
- type: STRING
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

encoded_key: STRING
last_logged_in_date: DATE-TIME
portal_state: STRING

| | **preferred\_language**

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

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

STRING | | **state**

STRING | ### communications This table contains information about communications. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | encoded\_key | | **Replication Key** | creation\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
communications.client_key = clients.encoded_key
```

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

```
communications.sender_key = clients.assigned_user_key
``` | | [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
communications.client_key = groups.group_members.client_key
```

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

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

```
communications.sender_key = groups.assigned_user_key
``` | | [deposit_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-accounts) | ```
communications.deposit_account_key = deposit_accounts.encoded_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
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
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
communications.user_key = deposit_transactions.user_key
```

```
communications.sender_key = deposit_transactions.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-journal-entries) | ```
communications.user_key = gl_journal_entries.user_key
```

```
communications.sender_key = gl_journal_entries.user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
communications.user_key = loan_transactions.user_key
```

```
communications.sender_key = loan_transactions.user_key
``` | | [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#tasks) | ```
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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
communications.user_key = users.encoded_key
```

```
communications.sender_key = users.encoded_key
``` | communications table schema | **body**

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

STRING | | **creation\_date**

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

ARRAY | | **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** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-accounts) | ```
credit_arrangements.encoded_key = deposit_accounts.credit_arrangement_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
credit_arrangements.encoded_key = loan_accounts.credit_arrangement_key
``` | credit\_arrangements table schema | **amount**

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

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

NUMBER | | **closed\_date**

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

NUMBER | | **creation\_date**

DATE-TIME | | **currency**

OBJECT

This is a nested data structure: **code**: STRING. | | **custom\_fields**

ARRAY | | **encoded\_key**

STRING | | **expire\_date**

DATE-TIME | | **exposure\_limit\_type**

STRING | | **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** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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 schema | **available\_for**

STRING | | --- | | **creation\_date**

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

ARRAY | | **dependent\_field\_key**

STRING | | **display\_settings**

OBJECT

This is a nested data structure:

built_in_id: STRING
description: STRING
display_name: STRING
field_size: STRING
position: INTEGER

| | **edit\_rights**

OBJECT

This is a nested data structure:

all_users: BOOLEAN
roles: ARRAY, which is also a nested data structure.

available_options: ARRAY, which is also a nested data structure:
- score: NUMBER
- selection_key: STRING
- value: STRING
- position: INTEGER
for_selection_key: STRING
for_value: STRING

default: BOOLEAN
object_key: STRING
required: BOOLEAN

| | **value\_validation\_settings**

OBJECT

This is a nested data structure:

unique: BOOLEAN
validation_pattern: STRING

| | **view\_rights**

OBJECT

This is a nested data structure:

all_users: BOOLEAN
roles: ARRAY, which is also a nested data structure.

| ### deposit\_accounts This table contains information about deposit accounts. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#credit-arrangements) | ```
deposit_accounts.credit_arrangement_key = credit_arrangements.encoded_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
deposit_accounts.credit_arrangement_key = loan_accounts.credit_arrangement_key
```

```
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
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#communications) | ```
deposit_accounts.encoded_key = communications.deposit_account_key
``` | 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:

interest_accrued: NUMBER
negative_interest_accrued: NUMBER
overdraft_interest_accrued: NUMBER
technical_overdraft_interest_accrued: NUMBER

available_balance: NUMBER
blocked_balance: NUMBER
fees_due: NUMBER
forward_available_balance: 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

interest_payment_settings: OBJECT, which is also a nested data structure:
- interest_payment_dates: ARRAY, which is also a nested data structure:
  - day: INTEGER
  - month: INTEGER
- interest_payment_point: STRING
interest_rate_settings: OBJECT, which is also a nested data structure:
- 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, which is also a nested data structure:
  - encoed_key: STRING
  - ending_balance: NUMBER
  - ending_day: INTEGER
  - interest_rate: NUMBER
- interest_spread: NUMBER

| | **internal\_controls**

OBJECT

This is a nested data structure:

max_deposit_balance: NUMBER
max_withdrawal_amount: NUMBER
recommended_deposit_amount: NUMBER
target_amount: NUMBER

interest_rate_settings: OBJECT, which is also a nested data structure:
- encoded_key: STRING
- interest_charge_frequency: STRING
- interest_charge_frequency_count: STRING
- 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, which is also a nested data structure:
  - encoded_key: STRING
  - ending_balance: NUMBER
  - ending_day: INTEGER
  - interest_rate: NUMBER
- interest_spread: NUMBER

| | **overdraft\_settings**

OBJECT

This is a nested data structure:

allow_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** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[Mambu API method](https://api.mambu.com/v1/#savings-products-get-savings-products "Opens in new tab: Mambu API method") | deposit\_products table schema | **accounting\_settings**

OBJECT

This is a nested data structure:

accounting_method: STRING
accounting_rules: ARRAY, which is also a nested data structure:
- encoded_key: STRING
- financial_resource: STRING
- gl_account_key: STRING
interest_accrued_accounting_method: STRING

| | --- | | **availability\_settings**

OBJECT

This is a nested data structure:

available_for: ARRAY, which is also a nested data structure.
branch_settings: OBJECT, which is also a nested data structure:
- available_product_branches: ARRAY, which is also a nested data structure.
- for_all_branches: BOOLEAN

| | **category**

STRING | | **creation\_date**

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

OBJECT

This is a nested data structure: **credit\_arrangement\_requirement**, STRING. | | **currency\_settings**

OBJECT

This is a nested data structure: **currencies**: ARRAY, which is also a nested data structure:

code: STRING

allow_arbitrary_fees: BOOLEAN
fees: ARRAY, which is also a nested data structure:
- accounting_rules: ARRAY, which is also a nested data structure:
  - encoded_key: STRING
  - financial_resource: STRING
  - gl_account_key: STRING
- amount: NUMBER
- amount_calculation_method: STRING
- apply_date_method: STRING
- creation_date: DATE-TIME
- encoded_key: STRING
- fee_application: STRING
- id: STRING
- last_modified_date: DATE-TIME
- name: STRING
- state: STRING
- trigger: STRING

| | **id**

STRING | | **interest\_settings**

OBJECT

This is a nested data structure:

collect_interest_when_locked: BOOLEAN
days_in_year: STRING
interest_calculation_balance: STRING
interest_paid_into_account: BOOLEAN
interest_payment_settings: OBJECT, which is also a nested data structure:
- interest_payment_dates: ARRAY, which is also a nested data structure:
  - day: INTEGER
  - month: INTEGER
- interest_payment_point: STRING
interest_rate_settings: OBJECT, which is also a nested data structure:
- accrue_interest_after_maturity: BOOLEAN
- allow_negative_interest_rate: BOOLEAN
- encoded_key: STRING
- index_source_key: STRING
- interest_charge_frequency: STRING
- interest_charge_frequency_count: INTEGER
- interest_rate: OBJECT, whic is also a nested data structure:
  - default_value: NUMBER
  - max_value: NUMBER
  - min_value: NUMBER
- interest_rate_review_count: INTEGER
- interest_rate_review_unit: STRING
- interest_rate_source: STRING
- interest_rate_terms: STRING
- interest_rate_tiers: ARRAY, which is also a nested data structure:
  - encoded_key: STRING
  - ending_balance: NUMBER
  - ending_day: INTEGER
  - interest_rate: NUMBER
maximum_balance: NUMBER

| | **internal\_controls**

OBJECT

This is a nested data structure:

dormancy_period_days: INTEGER
max_withdrawal_amount: NUMBER
opening_balance: OBJECT, which is also a nested data structure:
- default_value: NUMBER
- max_value: NUMBER
- min_value: NUMBER
recommended_deposit_amount: NUMBER

| | **last\_modified\_date**

DATE-TIME | | **maturity\_settings**

OBJECT

This is a nested data structure:

maturity_period: OBJECT, which is also a nested data structure:
- default_value: NUMBER
- max_value: NUMBER
- min_value: NUMBER
maturity_period_unit: STRING

| | **name**

STRING | | **new\_account\_settings**

OBJECT

This is a nested data structure:

id_generator_type: STRING
id_pattern: STRING

| | **notes**

STRING | | **offset\_settings**

OBJECT

This is a nested data structure: **allow\_offset**, BOOLEAN.

type: STRING

| | **overdraft\_interest\_settings**

OBJECT

This is a nested data structure:

days_in_year: STRING
interest_calculation_balance: STRING
interest_rate_settings: OBJECT, which is also a nested data structure:
- index_source_key: STRING
- interest_charge_frequency: STRING
- interest_charge_frequency_count: INTEGER
- interest_rate: OBJECT, which is also a nested data structure:
  - default_value: NUMBER
  - max_value: NUMBER
  - min_value: NUMBER
- interest_rate_review_count: INTEGER
- interest_rate_review_unit: STRING
- interest_rate_source: STRING
- interest_rate_terms: STRING
- interest_rate_tiers:ARRAY, which is also a nested data structure:
  - encoded_key: STRING
  - ending_balance: STRING
  - interest_rate: NUMBER

| | **overdraft\_settings**

OBJECT

This is a nested data structure:

allow_overdraft: BOOLEAN
allow_technical_overdraft: BOOLEAN
max_overdraft_limit: NUMBER

| | **state**

STRING | | **tax\_settings**

OBJECT

This is a nested data structure: **withholding\_tax\_enabled**, BOOLEAN. | | **templates**

ARRAY

This is a nested data structure:

creation_date: DATE-TIME
encoded_key: STRING
last_modified_date: DATE-TIME
name: STRING
type: STRING

| | **type**

STRING | ### deposit\_transactions This table contains information about deposit transactions. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | encoded\_key | | **Replication Key** | creation\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#branches) | ```
deposit_transactions.branch_key = branches.encoded_key
``` | | [centres](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#centres) | ```
deposit_transactions.branch_key = centres.assigned_branch_key
```

```
deposit_transactions.centre_key = centres.encoded_key
``` | | [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
deposit_transactions.branch_key = groups.assigned_branch_key
```

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

```
deposit_transactions.user_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
deposit_transactions.branch_key = loan_accounts.assigned_branch_key
```

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

```
deposit_transactions.user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
deposit_transactions.branch_key = loan_transactions.branch_key
```

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

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

```
deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.encoded_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.user_key = loan_transactions.user_key
``` | | [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
deposit_transactions.branch_key = users.access.managed_branches.branch_key
```

```
deposit_transactions.user_key = users.encoded_key
``` | | [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
deposit_transactions.centre_key = clients.assigned_centre_key
```

```
deposit_transactions.user_key = clients.assigned_user_key
``` | | [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#activities) | ```
deposit_transactions.user_key = activities.user_key
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#communications) | ```
deposit_transactions.user_key = communications.user_key
```

```
deposit_transactions.user_key = communications.sender_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-journal-entries) | ```
deposit_transactions.user_key = gl_journal_entries.user_key
``` | | [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#tasks) | ```
deposit_transactions.user_key = tasks.created_by_user_key
```

```
deposit_transactions.user_key = tasks.assigned_user_key
``` | deposit\_transactions table schema | **account\_balances**

OBJECT

This is a nested data structure: **total\_balance**, NUMBER. | | --- | | **adjustment\_transaction\_key**

STRING | | **affected\_amounts**

OBJECT

This is a nested data structure:

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

advice: BOOLEAN
amount: NUMBER
card_acceptor: OBJECT, which is also a nested data structure:
- 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

amount: NUMBER
name: STRING
predefined_fee_key: STRING
tax_amount: NUMBER
trigger: STRING

| | **hold\_external\_reference\_id**

STRING | | **id**

STRING | | **interest\_accrued\_amounts**

OBJECT

This is a nested data structure:

interest_accrued: NUMBER
negative_interest_accrued: NUMBER
overdraft_interest_accrued: NUMBER
technical_overdraft_interest_accrued: NUMBER

creditor: OBJECT, which is also a nested data structure:
- name: STRING
creditor_account: OBJECT, which is also a nested data structure:
- currency: STRING
- identification: OBJECT, which is also a nested data structure:
  - iban: STRING
  - other: OBJECT, which is also a nested data structure:
    - identification: STRING
    - scheme: STRING
creditor_agent: OBJECT, which is also a nested data structure:
- financial_institution_identification: OBJECT, which is also a nested data structure:
  - bic: STRING
debtor: OBJECT, which is also a nested data structure:
- name: STRING
debtor_account: OBJECT, which is also a nested data structure:
- currency: STRING
- identification: OBJECT
  - iban: STRING
  - other: OBJECT, which is also a nested data structure:
    - identification: STRING
    - scheme: STRING
debtor_agent: OBJECT, which is also a nested data structure:
- financial_institution_identification: OBJECT, which is also a nested data structure:
  - bic: STRING
payment_identification: OBJECT, which is also a nested data structure:
- end_to_end_identification: STRING
- instruction_identification: STRING
- transaction_identification: STRING
payment_type_information: OBJECT, which is also a nested data structure:
- service_level: OBJECT, which is also a nested data structure:
  - code: STRING
remittance_information: OBJECT, which is also a nested data structure:
- structured: OBJECT, which is also a nested data structure:
  - creditor_reference_information: OBJECT, which is also a nested data structure:
    - reference: STRING
    - reference_issuer: STRING
    - reference_type: STRING

| | **payment\_order\_id**

STRING | | **taxes**

OBJECT

This is a nested data structure: **tax\_rate**: NUMBER. | | **terms**

OBJECT

This is a nested data structure:

interest_settings: OBJECT, which is also a nested data structure:
- index_interest_rate: NUMBER
- interest_rate: NUMBER
overdraft_interest_settings: OBJECT, which is also a nested data structure:
- index_interest_rate: NUMBER
- interest_rate: NUMBER
overdraft_settings: OBJECT, which is also a nested data structure:
- overdraft_limit: NUMBER

| | **till\_key**

STRING | | **transaction\_details**

OBJECT

This is a nested data structure:

transaction_channel_id: STRING
transaction_channel_key: STRING

| | **transfer\_details**

OBJECT

This is a nested data structure:

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** | CDC | | --- | --- | | **Primary Key** | gl\_code | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/#mambu-api-v2-gl-accounts)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#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: **code**, STRING. | | **custom\_fields**

ARRAY | | **description**

STRING | | **encoded\_key**

STRING | | **gl\_code**

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

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

STRING | | **name**

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

BOOLEAN | | **type**

STRING | | **usage**

STRING | ### gl\_journal\_entries This table contains information about general ledger entries. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | entry\_id | | **Replication Key** | booking\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/#mambu-api-v2-journal-entries)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-accounts) | ```
gl_journal_entries.gl_account.gl_code = gl_accounts.gl_code
``` | | [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#activities) | ```
gl_journal_entries.user_key = activities.user_key
``` | | [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
gl_journal_entries.user_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
gl_journal_entries.user_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
gl_journal_entries.user_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
gl_journal_entries.user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
gl_journal_entries.user_key = loan_transactions.user_key
``` | | [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
gl_journal_entries.user_key = users.encoded_key
``` | gl\_journal\_entries table schema | **account\_key**

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

NUMBER | | **assigned\_branch\_key**

STRING | | **booking\_date**

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

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

ARRAY | | **encoded\_key**

STRING | | **entry\_id**

INTEGER | | **foreign\_amount**

OBJECT

This is a nested data structure:

accounting_rate: OBJECT, which is also a nested data structure:
- 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, which is also a nested data structure:
- code: STRING

| | **gl\_account**

OBJECT

This is a nested data structure:

activated: BOOLEAN
allow_manual_journal_entries: BOOLEAN
balance: NUMBER
created_at: DATE-TIME
currency: OBJECT, which is also a nested data structure:
- code: STRING
description: STRING
encoded_key: STRING
gl_code: STRING
last_modified_date: DATE-TIME
migration_event_key: STRING
name: STRING
strip_trailing_zeros: BOOLEAN
type: STRING
usage: STRING

| | **notes**

STRING | | **product\_key**

STRING | | **product\_type**

STRING | | **reversal\_entry\_key**

STRING | | **transaction\_id**

STRING | | **type**

STRING | | **user\_key**

STRING | ### groups This table contains information about groups. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#branches) | ```
groups.assigned_branch_key = branches.encoded_key
``` | | [centres](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#centres) | ```
groups.assigned_branch_key = centres.assigned_branch_key
```

```
groups.assigned_centre_key = centres.encoded_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
groups.assigned_branch_key = deposit_transactions.branch_key
```

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

```
groups.assigned_user_key = deposit_transactions.user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
groups.assigned_branch_key = loan_accounts.assigned_branch_key
```

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

```
groups.assigned_user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
groups.assigned_branch_key = loan_transactions.branch_key
```

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

```
groups.assigned_user_key = loan_transactions.user_key
``` | | [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
groups.assigned_branch_key = users.access.managed_branches.branch_key
```

```
groups.assigned_user_key = users.encoded_key
``` | | [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
groups.assigned_centre_key = clients.assigned_centre_key
```

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

```
groups.assigned_user_key = clients.assigned_user_key
``` | | [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#activities) | ```
groups.group_members.client_key = activities.client_key
```

```
groups.assigned_user_key = activities.user_key
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#communications) | ```
groups.group_members.client_key = communications.client_key
```

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

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

```
groups.assigned_user_key = communications.sender_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-journal-entries) | ```
groups.assigned_user_key = gl_journal_entries.user_key
``` | | [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#tasks) | ```
groups.assigned_user_key = tasks.created_by_user_key
```

```
groups.assigned_user_key = tasks.assigned_user_key
``` | groups table schema | **addresses**

ARRAY

This is a nested data structure:

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 | | **email\_address**

STRING | | **encoded\_key**

STRING | | **group\_members**

ARRAY

This is a nested data structure:

client_key: STRING
role: ARRAY, which is also a nested data structure
- encoded_key: STRING
- group_role_name_key: STRING
- role_name: STRING
- role_name_id: STRING

| | **group\_name**

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

STRING | | **home\_phone**

STRING | | **id**

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

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

INTEGER | | **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** | Full Table | | --- | --- | | **Primary Key** | encoded\_key | | **Useful links** | [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 | **custom\_fields**

ARRAY | | --- | | **encoded\_key**

STRING | | **id**

STRING | | **name**

STRING | | **notes**

STRING | | **type**

STRING | ### installments This table contains information about installments for a loan. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | encoded\_key | | **Replication Key** | last\_paid\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/#mambu-api-v2-installments)

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

ARRAY | | --- | | **due\_date**

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

STRING | | **fee**

OBJECT

This is a nested data structure:

amount: OBJECT, which is also a nested data structure:
- due: NUMBER
- expected: NUMBER
- expected_unapplied: NUMBER
- paid: NUMBER
tax: OBJECT, which is also a nested data structure:
- due: NUMBER
- expected: NUMBER
- paid: NUMBER

| | **fee\_details**

ARRAY

This is a nested data structure:

amount: OBJECT, which is also a nested data structure:
- due: NUMBER
- expected: NUMBER
- paid: NUMBER
- reduced: NUMBER
encoded_key: STRING
id: STRING
name: STRING
tax: OBJECT, which is also a nested data structure:
- due: NUMBER
- expected: NUMBER
- paid: NUMBER
- reduced: NUMBER

| | **interest**

OBJECT

This is a nested data structure:

amount: OBJECT, which is also a nested data structure:
- due: NUMBER
- expected: NUMBER
- paid: NUMBER
- reduced: NUMBER
tax: OBJECT, which is also a nested data structure:
- due: NUMBER
- expected: NUMBER
- paid: NUMBER

amount: OBJECT, which is also a nested data structure:
- due: NUMBER
- expected: NUMBER
- paid: NUMBER
tax: OBJECT, which is also a nested data structure:
- due: NUMBER
- expected: NUMBER
- paid: NUMBER

| | **principal**

OBJECT

This is a nested data structure:

amount: OBJECT, which is also a nested data structure:
- due: NUMBER
- expected: NUMBER
- paid: NUMBER

| | **repaid\_date**

DATE-TIME | | **state**

STRING | ### interest\_accrual\_breakdown This table contains information about interest accruals. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | entry\_id | | **Replication Key** | creation\_date | 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 | | **custom\_fields**

ARRAY | | **entry\_id**

INTEGER | | **entry\_type**

STRING | | **foreign\_amount**

OBJECT

This is a nested data structure:

accounting_rate: OBJECT, which is also a nested data structure:
- encoded_key: STRING
- end_date: DATE-TIME
- from_currency_code: DATE-TIME
- rate: NUMBER
- start_date: DATE-TIME
- to_currency_code: STRING
amount: NUMBER
currency: : OBJECT, which is also a nested data structure:
- 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** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#branches) | ```
loan_accounts.assigned_branch_key = branches.encoded_key
``` | | [centres](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#centres) | ```
loan_accounts.assigned_branch_key = centres.assigned_branch_key
```

```
loan_accounts.assigned_centre_key = centres.encoded_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
loan_accounts.assigned_branch_key = deposit_transactions.branch_key
```

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

```
loan_accounts.assigned_user_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
loan_accounts.assigned_branch_key = groups.assigned_branch_key
```

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

```
loan_accounts.assigned_user_key = groups.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
loan_accounts.assigned_branch_key = loan_transactions.branch_key
```

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

```
loan_accounts.assigned_user_key = loan_transactions.user_key
``` | | [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
loan_accounts.assigned_branch_key = users.access.managed_branches.branch_key
```

```
loan_accounts.assigned_user_key = users.encoded_key
``` | | [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
loan_accounts.assigned_centre_key = clients.assigned_centre_key
```

```
loan_accounts.assigned_user_key = clients.assigned_user_key
``` | | [credit_arrangements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#credit-arrangements) | ```
loan_accounts.credit_arrangement_key = credit_arrangements.encoded_key
``` | | [deposit_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-accounts) | ```
loan_accounts.credit_arrangement_key = deposit_accounts.credit_arrangement_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 = deposit_accounts.encoded_key
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#communications) | ```
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
``` | | [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#activities) | ```
loan_accounts.assigned_user_key = activities.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-journal-entries) | ```
loan_accounts.assigned_user_key = gl_journal_entries.user_key
``` | | [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#tasks) | ```
loan_accounts.assigned_user_key = tasks.created_by_user_key
```

```
loan_accounts.assigned_user_key = tasks.assigned_user_key
``` | loan\_accounts table schema | **account\_arrears\_settings**

OBJECT

This is a nested data structure:

date_calculation_method: STRING
encoded_key: STRING
monthly_tolerance_day: INTEGER
non_working_days_method: STRING
tolerance_calculation_method: STRING
tolerance_floor_amount: NUMBER
tolerance_percentage_of_outstanding_principal: NUMBER
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:

amount: NUMBER
asset_name: STRING
deposit_account_key: STRING
encoded_key: STRING
guarantor_key: STRING
guarantor_type: STRING
original_amount: NUMBER
original_currency: OBJECT, which is also a nested data structure:
- code: STRING

fees_balance: NUMBER
fees_due: NUMBER
fees_paid: NUMBER
hold_balance: 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

disbursement_date: DATE-TIME
encoded_key: STRING
expected_disbursement_date: DATE-TIME
fees: ARRAY, which is also a nested data structure:
- amount: NUMBER
- encoded_key: STRING
- predefined_fee_encoded_key: STRING
first_repayment_date: DATE-TIME
transaction_details: OBJECT, which is also a nested data structure:
- 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:

amount: NUMBER
asset_name: STRING
deposit_account_key: STRING
encoded_key: STRING
guarantor_key: STRING
guarantor_type: STRING
id: STRING
interest_commission: NUMBER
share_percentage: NUMBER

| | **future\_payments\_acceptance**

STRING | | **guarantors**

ARRAY

This is a nested data structure:

amount: NUMBER
asset_name: STRING
deposit_account_key: STRING
encoded_key: STRING
guarantor_key: STRING
guarantor_type: STRING

account_interest_rate_settings: ARRAY, which is also a nested data structure:
- encoded_key: STRING
- index_source_key: STRING
- interest_rate: NUMBER
- interest_rate_ceiling_value: NUMBER
- interest_rate_floor_value: NUMBER
- interest_rate_review_count: INTEGER
- interest_rate_review_unit: STRING
- interest_rate_source: STRING
- interest_spread: NUMBER
- valid_from: DATE-TIME
accrue_interest_after_maturity: BOOLEAN
accrue_late_interest: 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

loan_penalty_calculation_method: STRING
penalty_rate: NUMBER

| | **planned\_installment\_fees**

ARRAY

This is a nested data structure:

amount: NUMBER
apply_on_date: DATE-TIME
encoded_key: STRING
installment_key: STRING
installment_number: INTEGER
predefined_fee_key: STRING

| | **prepayment\_settings**

OBJECT

This is a nested data structure:

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:

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 | | **redraw\_settings**

OBJECT

This is a nested data structure: **restrict\_next\_due\_withdrawal**, BOOLEAN. | | **rescheduled\_account\_key**

STRING | | **schedule\_settings**

OBJECT

This is a nested data structure:

billing_cycle: OBJECT, which is also a nested data structure:
- days: ARRAY, which is also a nested data structure.
default_first_repayment_due_date_offset: INTEGER
fixed_days_of_month: ARRAY, which is also a nested data structure.
grace_period: INTEGER
grace_period_type: STRING
has_custom_schedule: BOOLEAN
payment_plan: ARRAY, which is also a nested data structure:
- amount: NUMBER
- encoded_key: STRING
- to_installment: INTEGER
periodic_payment: NUMBER
preview_schedule: OBJECT, which is also a nested data structure:
- number_of_previewed_instalments: INTEGER
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

amount: NUMBER
disbursement_details: OBJECT, which is also a nested data structure:
- disbursement_transaction_key: STRING
- expected_disbursement_date: DATE-TIME
encoded_key: STRING
fees: ARRAY, which is also a nested data structure:
- amount: NUMBER
- encoded_key: STRING
- predefined_fee_encoded_key: STRING
tranche_number: INTEGER

| ### loan\_products This table contains information about loan products. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu API method](https://api.mambu.com/?shell#loan-products-getall "Opens in new tab: Mambu API method") | loan\_products table schema | **account\_link\_settings**

OBJECT

This is a nested data structure:

enabled: BOOLEAN
linkable_deposit_product_key: STRING
linked_account_options: ARRAY, which is also a nested data structure.
settlement_method: STRING

| | --- | | **accounting\_settings**

OBJECT

This is a nested data structure:

accounting_method: STRING
accounting_rules: ARRAY, which is also a nested data structure.
- encoded_key: STRING
- financial_resource: STRING
- gl_account_key: STRING
- transaction_channel_key: STRING
interest_accrual_calculation: STRING
interest_accrued_accounting_method: STRING

| | **adjust\_interest\_for\_first\_installment**

BOOLEAN | | **allow\_custom\_repayment\_allocation**

BOOLEAN | | **arrears\_settings**

OBJECT

This is a nested data structure:

date_calculation_method: STRING
encoded_key: STRING
monthly_tolerance_day: INTEGER
non_working_days_method: STRING
tolerance_calculation_method: STRING
tolerance_floor_amount: NUMBER
tolerance_percentage_of_outstanding_principal: OBJECT, which is also a nested data structure:
- default_value: NUMBER
- max_value: NUMBER
- min_value: NUMBER
tolerance_percentage_of_outstanding_principal: OBJECT, which is also a nested data structure:
- default_value: INTEGER
- encoded_key: STRING
- max_value: INTEGER
- min_value: INTEGER

| | **availability\_settings**

OBJECT

This is a nested data structure:

available_for: ARRAY, which is also a nested data structure.
branch_settings: OBJECT, which is also a nested data structure:
- available_product_branches: ARRAY, which is also a nested data structure.
- for_all_branches: BOOLEAN

| | **category**

STRING | | **creation\_date**

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

OBJECT

This is a nested data structure: **credit\_arrangement\_requirement**, STRING. | | **currency**

OBJECT

This is a nested data structure: **code**, STRING. | | **custom\_fields**

ARRAY | | **encoded\_key**

STRING | | **fees\_settings**

OBJECT

This is a nested data structure:

allow_arbitrary_fees: BOOLEAN
fees: ARRAY, which is also a nested data structure:
- accounting_rules: ARRAY, which is also a nested data structure:
  - encoded_key: STRING
  - financial_resource: STRING
  - gl_account_key: STRING
  - transaction_channel_key: STRING
- amortization_settings: OBJECT, which is also a nested data structure:
  - amortization_profile: STRING
  - encoded_key: STRING
  - fee_amortization_upon_reschedule_refinance_option: STRING
  - frequency: STRING
  - interval_count: INTEGER
  - interval_type: STRING
  - period_count: INTEGER
  - period_unit: STRING
- amount: NUMBER
- amount_calculation_method: STRING
- apply_date_method: STRING
- creation_date: DATE-TIME
- encoded_key: STRING
- fee_application: STRING
- id: STRING
- last_modified_date: DATE-TIME
- name: STRING
- percentage_amount: NUMBER
- state: STRING
- tax_settings: OBJECT, which is also a nested data structure:
  - taxable_calculation_method: STRING
- trigger: STRING

| | **funding\_settings**

OBJECT

This is a nested data structure:

enabled: BOOLEAN
funder_interest_commission: OBJECT, which is also a nested data structure:
- default_value: NUMBER
- encoded_key: STRING
- max_value: NUMBER
- min_value: NUMBER
funder_interest_commission_allocation_type: STRING
lock_funds_at_approval: BOOLEAN
organization_interest_commission: OBJECT, which is also a nested data structure:
- default_value: NUMBER
- encoded_key: STRING
- max_value: NUMBER
- min_value: NUMBER
required_funds: NUMBER

| | **grace\_period\_settings**

OBJECT

This is a nested data structure:

grace_period: OBJECT, which is also a nested data structure:
- default_value: NUMBER
- encoded_key: STRING
- max_value: NUMBER
- min_value: NUMBER
grace_period_type: STRING

| | **id**

STRING | | **interest\_settings**

OBJECT

This is a nested data structure:

accrue_late_interest: BOOLEAN
compounding_frequency: STRING
days_in_year: STRING
index_rate_settings: OBJECT, which is also a nested data structure:
- accrue_interest_after_maturity: BOOLEAN
- allow_negative_interest_rate: BOOLEAN
- encoded_key: STRING
- days_in_year: STRING
- index_source_key: STRING
- interest_charge_frequency: STRING
- interest_charge_frequency_count: INTEGER
- interest_rate: OBJECT, which is also a nested data structure:
  - default_value: NUMBER
  - max_value: NUMBER
  - min_value: NUMBER
- interest_rate_ceiling_value: NUMBER
- interest_rate_floor_value: NUMBER
- interest_rate_review_count: INTEGER
- interest_rate_review_unit: STRING
- interest_rate_source: STRING
- interest_rate_terms: STRING
- interest_rate_tiers: ARRAY, which is also a nested data structure:
  - encoded_key: STRING
  - ending_balance: NUMBER
  - interest_rate: NUMBER
interest_application_method: STRING
interest_balance_calculation_method: STRING
interest_calculation_method: STRING
interest_rate_settings:ARRAY, which is also a nested data structure:
- encoded_key: STRING
- index_source_key: STRING
- interest_rate: OBJECT, which is also a nested data structure:
  - default_value: NUMBER
  - max_value: NUMBER
  - min_value: NUMBER
- interest_rate_ceiling_value: NUMBER
- interest_rate_floor_value: NUMBER
- interest_rate_review_count: INTEGER
- interest_rate_review_unit: STRING
- interest_rate_source: STRING
interest_type: STRING
schedule_interest_days_count_method: STRING

| | **internal\_controls**

OBJECT

This is a nested data structure:

dormancy_period_days: INTEGER
four_eyes_principle: OBJECT, which is also a nested data structure:
- active_for_loan_approval: BOOLEAN
lock_settings: OBJECT, which is also a nested data structure:
- capping_constraint_type: STRING
- capping_method: STRING
- capping_percentage: NUMBER
- lock_period_days: INTEGER

| | **last\_modified\_date**

DATE-TIME | | **loan\_amount\_settings**

OBJECT

This is a nested data structure:

loan_amount: OBJECT, which is also a nested data structure:
- default_value: NUMBER
- encoded_key: STRING
- max_value: NUMBER
- min_value: NUMBER
tranche_settings: OBJECT, which is also a nested data structure:
- max_number_of_tranches: INTEGER

| | **name**

STRING | | **new\_account\_settings**

OBJECT

This is a nested data structure:

account_initial_state: STRING
id_generator_type: STRING
id_pattern: STRING

| | **notes**

STRING | | **offset\_settings**

OBJECT

This is a nested data structure: **allow\_offset**, BOOLEAN. | | **payment\_settings**

OBJECT

This is a nested data structure:

amortization_method: STRING
late_payments_recalculation_method: STRING
payment_method: STRING
prepayment_settings: OBJECT, which is also a nested datas structure:
- apply_interest_on_prepayment_method: STRING
- elements_recalculation_method: STRING
- future_payments_acceptance: STRING
- prepayment_acceptance: STRING
- prepayment_recalculation_method: STRING
- principal_paid_installment_status: STRING
principal_payment_settings: OBJECT, which is also a nested datas structure:
- amount: OBJECT, which is also a nested datas structure:
  - default_value: NUMBER
  - encoded_key: STRING
  - max_value: NUMBER
  - min_value: NUMBER
- default_principal_repayment_interval: INTEGER
- encoded_key: STRING
- include_fees_in_floor_amount: BOOLEAN
- include_interest_in_floor_amount: BOOLEAN
- percentage: OBJECT, which is also a nested datas structure:
  - default_value: NUMBER
  - encoded_key: STRING
  - max_value: NUMBER
  - min_value: NUMBER
- principal_ceiling_value: NUMBER
- principal_floor_value: NUMBER
- principal_payment_method: STRING
- total_due_amount_floor: NUMBER
- total_due_payment: STRING
repayment_allocation_order: ARRAY, which is also a nested data structure.

| | **penalty\_settings**

OBJECT

This is a nested data structure:

loan_penalty_calculation_method: STRING
loan_penalty_grace_period: STRING
penalty_rate: OBJECT, which is also a nested datas structure:
- default_value: NUMBER
- encoded_key: STRING
- max_value: NUMBER
- min_value: NUMBER

| | **redraw\_settings**

OBJECT

This is a nested data structure: **allow\_redraw**, BOOLEAN. | | **schedule\_settings**

OBJECT

This is a nested data structure:

billing_cycles: OBJECT, which is also a nested data struture:
- enabled: BOOLEAN
- start_days: ARRAY, which is also a nested data structure.
default_repayment_period_count: INTEGER
first_repayment_due_date_offset: OBJECT, which is also a nested datas structure:
- default_value: NUMBER
- encoded_key: STRING
- max_value: NUMBER
- min_value: NUMBER
fixed_days_of_month: ARRAY, which is also a nested data structure.
interest_accrual_since: STRING
num_installments: OBJECT, which is also a nested datas structure:
- default_value: NUMBER
- encoded_key: STRING
- max_value: NUMBER
- min_value: NUMBER
preview_schedule: OBJECT, which is also a nested datas structure:
- number_of_previewed_instalments: INTEGER
- preview_schedule_enabled: BOOLEAN
repayment_period_unit: STRING
repayment_rescheduling_method: STRING
repayment_schedule_edit_options: ARRAY, which is also a nested data structure.
repayment_schedule_method: STRING
preview_schedule: OBJECT, which is also a nested datas structure:
- repayment_currency_rounding: STRING
- repayment_elements_rounding_method: STRING
- rounding_repayment_schedule_method: STRING
schedule_due_dates_method: STRING
short_month_handling_method: STRING

| | **security\_settings**

OBJECT

This is a nested data structure:

is_collateral_enabled: BOOLEAN
is_guarantors_enabled: BOOLEAN
required_guaranties: NUMBER

| | **state**

STRING | | **tax\_settings**

OBJECT

This is a nested data structure:

tax_calculation_method: STRING
tax_source_key: STRING
taxes_on_fees_enabled: BOOLEAN
taxes_on_interest_enabled: BOOLEAN
taxes_on_penalty_enabled: BOOLEAN

| | **templates**

ARRAY

This is a nested data structure:

creation_date: DATE-TIME
encoded_key: STRING
last_modified_date: DATE-TIME
name: STRING
type: 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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-account) table to replicate. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | encoded\_key | | | loan-account | | **Useful links** | [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 | **assigned\_branch\_key**

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

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

STRING | | **custom\_settings**

ARRAY

This is a nested data structure:

encoded_key: STRING
loan_transaction_key: STRING
source: STRING
type: STRING

encoded_key: STRING
fee_due: NUMBER
index_in_list: NUMBER
predefined_fee_key: STRING
repayment_key: STRING
tax_on_fee_due: 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** | CDC | | --- | --- | | **Primary Key** | encoded\_key | | **Replication Key** | creation\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#branches) | ```
loan_transactions.branch_key = branches.encoded_key
``` | | [centres](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#centres) | ```
loan_transactions.branch_key = centres.assigned_branch_key
```

```
loan_transactions.centre_key = centres.encoded_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
loan_transactions.branch_key = deposit_transactions.branch_key
```

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

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

```
loan_transactions.encoded_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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
loan_transactions.branch_key = groups.assigned_branch_key
```

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

```
loan_transactions.user_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
loan_transactions.branch_key = loan_accounts.assigned_branch_key
```

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

```
loan_transactions.user_key = loan_accounts.assigned_user_key
``` | | [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
loan_transactions.branch_key = users.access.managed_branches.branch_key
```

```
loan_transactions.user_key = users.encoded_key
``` | | [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
loan_transactions.centre_key = clients.assigned_centre_key
```

```
loan_transactions.user_key = clients.assigned_user_key
``` | | [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#activities) | ```
loan_transactions.user_key = activities.user_key
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#communications) | ```
loan_transactions.user_key = communications.user_key
```

```
loan_transactions.user_key = communications.sender_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-journal-entries) | ```
loan_transactions.user_key = gl_journal_entries.user_key
``` | | [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#tasks) | ```
loan_transactions.user_key = tasks.created_by_user_key
```

```
loan_transactions.user_key = tasks.assigned_user_key
``` | loan\_transactions table schema | **account\_balances**

OBJECT

This is a nested data structure:

advance_position: NUMBER
arrears_position: NUMBER
expected_principal_redraw: NUMBER
principal_balance: NUMBER
redraw_balance: NUMBER
total_balance: NUMBER

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

STRING | | **affected\_amounts**

OBJECT

This is a nested data structure:

deferred_interest_amount: NUMBER
fees_amount: NUMBER
funders_interest_amount: NUMBER
interest_amount: NUMBER
interest_from_arrears_amount: NUMBER
organization_commission_amount: NUMBER
payment_holidays_interest_amount: NUMBER
penalty_amount: NUMBER
principal_amount: NUMBER

advice: BOOLEAN
amount: NUMBER
card_acceptor: OBJECT, which is also a nested data structure:
- 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: **code**, STRING. | | **custom\_fields**

ARRAY | | **custom\_payment\_amounts**

ARRAY

This is a nested data structure:

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

deferred_tax_on_interest_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

| | **terms**

OBJECT

This is a nested data structure:

interest_settings: OBJECT, which is also a nested data structure:
- index_interest_rate: NUMBER
- index_rate: NUMBER
periodic_payment: NUMBER
principal_payment_amount: NUMBER
principal_payment_percentage: NUMBER

| | **till\_key**

STRING | | **transaction\_details**

OBJECT

This is a nested data structure:

transaction_channel_id: STRING
transaction_channel_key: STRING

| | **transfer\_details**

OBJECT

This is a nested data structure:

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** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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 | | --- | --- | | [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#activities) | ```
tasks.created_by_user_key = activities.user_key
```

```
tasks.assigned_user_key = activities.user_key
``` | | [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
tasks.created_by_user_key = clients.assigned_user_key
```

```
tasks.assigned_user_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#communications) | ```
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
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
tasks.created_by_user_key = deposit_transactions.user_key
```

```
tasks.assigned_user_key = deposit_transactions.user_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-journal-entries) | ```
tasks.created_by_user_key = gl_journal_entries.user_key
```

```
tasks.assigned_user_key = gl_journal_entries.user_key
``` | | [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
tasks.created_by_user_key = loan_accounts.assigned_user_key
```

```
tasks.assigned_user_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
tasks.created_by_user_key = loan_transactions.user_key
```

```
tasks.assigned_user_key = loan_transactions.user_key
``` | | [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#users) | ```
tasks.created_by_user_key = users.encoded_key
```

```
tasks.assigned_user_key = users.encoded_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 | | **description**

STRING | | **due\_date**

DATE | | **encoded\_key**

STRING | | **id**

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

DATE-TIME | | **status**

STRING | | **task\_link\_key**

STRING | | **task\_link\_type**

STRING | | **template\_key**

STRING | | **title**

STRING | ### users This table contains information about users. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Replication Key** | last\_modified\_date | | **Useful links** | [Mambu documentation](https://api.mambu.com/?shell#welcome)

[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/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#branches) | ```
users.access.managed_branches.branch_key = branches.encoded_key
``` | | [centres](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#centres) | ```
users.access.managed_branches.branch_key = centres.assigned_branch_key
``` | | [deposit_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#deposit-transactions) | ```
users.access.managed_branches.branch_key = deposit_transactions.branch_key
```

```
users.encoded_key = deposit_transactions.user_key
``` | | [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#groups) | ```
users.access.managed_branches.branch_key = groups.assigned_branch_key
```

```
users.encoded_key = groups.assigned_user_key
``` | | [loan_accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-accounts) | ```
users.access.managed_branches.branch_key = loan_accounts.assigned_branch_key
```

```
users.encoded_key = loan_accounts.assigned_user_key
``` | | [loan_transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#loan-transactions) | ```
users.access.managed_branches.branch_key = loan_transactions.branch_key
```

```
users.encoded_key = loan_transactions.user_key
``` | | [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#activities) | ```
users.encoded_key = activities.user_key
``` | | [clients](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#clients) | ```
users.encoded_key = clients.assigned_user_key
``` | | [communications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#communications) | ```
users.encoded_key = communications.user_key
```

```
users.encoded_key = communications.sender_key
``` | | [gl_journal_entries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#gl-journal-entries) | ```
users.encoded_key = gl_journal_entries.user_key
``` | | [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Mambu.htm#tasks) | ```
users.encoded_key = tasks.created_by_user_key
```

```
users.encoded_key = tasks.assigned_user_key
``` | users table schema | **access**

OBJECT

This is a nested data structure:

administrator_access: BOOLEAN
api_access: BOOLEAN
can_manage_all_branches: BOOLEAN
can_manage_entities_assigned_to_other_officers: BOOLEAN
credit_officer_access: BOOLEAN
delivery_access: BOOLEAN
mambu_access: BOOLEAN
managed_branches: ARRAY, which is also a nested data structure:
- branch_key: STRING
permissions: ARRAY, which is also a nested data structure.
support_access: BOOLEAN
teller_access: BOOLEAN

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

STRING | | **creation\_date**

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

ARRAY | | **email**

STRING | | **encoded\_key**

STRING | | **first\_name**

STRING | | **home\_phone**

STRING | | **id**

STRING | | **language**

STRING | | **last\_logged\_in\_date**

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

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

STRING | | **mobile\_phone**

STRING | | **notes**

STRING | | **role**

OBJECT

This is a nested data structure:

encoded_key: STRING
id: STRING