Mambu (v2) | Stitch Documentation

Mambu extraction is supported by Stitch
This integration is powered by Singer's Mambu tap and certified by Stitch. Check out and contribute to the repo on GitHub.

For support, contact Support.

Mambu integration summary

Stitch’s Mambu integration replicates data using the Mambu v2.0 and v1.0 APIs. Refer to the Schema section for a list of objects available for replication.

Mambu feature snapshot

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

STITCH
Release status		Supported by	[Stitch] (https://community.qlik.com/t5/Support/ct-p/qlikSupport)
Stitch plan	Standard	API availability	Not available
Singer GitHub repository	singer-io/tap-mambu
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Mambu

Mambu setup requirements

To set up Mambu in Stitch, you need:

A Mambu account with API access. The Mambu integration requires an account login with API access. In Mambu’s app, API access can be granted to any existing user.

Step 1: Add Mambu as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Mambu icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Mambu” would create a schema called stitch_mambu in the destination. Note: Schema names cannot be changed after you save the integration.
In the Subdomain field, enter your Mambu subdomain. For example: If the subdomain were stitch.mambu.com, only stitch would be entered into this field.
In the Username and Password fields, enter the username and password of the Mambu user with Mambu API access.

Step 2: Define the historical replication start date

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

Change this setting if you want to replicate data beyond Mambu’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Mambu integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

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

For Mambu integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

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

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

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

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

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

Mambu table reference

Schemas and versioning

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

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

Table and column names in your destination

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

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

activities

This table contains information about activities.

Replication Method	Key-based Incremental
Primary Key	encoded_key
Replication Key	timestamp
Useful links	Mambu documentation activities schema on GitHub Mambu API method

activities table foreign keys

Join activities with	on
clients	activities.client_key = clients.encoded_key activities.user_key = clients.assigned_user_key
communications	activities.client_key = communications.client_key activities.user_key = communications.user_key activities.user_key = communications.sender_key
groups	activities.client_key = groups.group_members.client_key activities.user_key = groups.assigned_user_key
deposit_transactions	activities.user_key = deposit_transactions.user_key
gl_journal_entries	activities.user_key = gl_journal_entries.user_key
loan_accounts	activities.user_key = loan_accounts.assigned_user_key
loan_transactions	activities.user_key = loan_transactions.user_key
tasks	activities.user_key = tasks.created_by_user_key activities.user_key = tasks.assigned_user_key
users	activities.user_key = users.encoded_key

activities table schema

branch_name

STRING

client_key

STRING

client_name

STRING

encoded_key

STRING

field_changes

ARRAY

Click to expand field_changes

branchKey

STRING

clientKey

STRING

field_change_name

STRING

INTEGER

loanAccountKey

STRING

loanProductKey

STRING

new_value

STRING

original_value

STRING

transaction_id

INTEGER

loan_account_name

STRING

loan_product_name

STRING

notes

STRING

timestamp

DATE-TIME

transaction_ID

INTEGER

type

STRING

user_key

STRING

user_name

STRING

audit_trail

This table contains information about activities that have been performed in the Mambu Core Banking system.

Replication Method

Key-based Incremental

Replication Key

occurred_at

Useful links

Mambu documentation

audit_trail schema on GitHub

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	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation branches schema on GitHub Mambu API method

branches table foreign keys

Join branches with	on
centres	branches.encoded_key = centres.assigned_branch_key branches.custom_fields.field_set_id = centres.custom_fields.field_set_id branches.custom_fields.id = centres.custom_fields.id
deposit_transactions	branches.encoded_key = deposit_transactions.branch_key branches.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id branches.custom_fields.id = deposit_transactions.custom_fields.id
groups	branches.encoded_key = groups.assigned_branch_key branches.custom_fields.field_set_id = groups.custom_fields.field_set_id branches.custom_fields.id = groups.custom_fields.id
loan_accounts	branches.encoded_key = loan_accounts.assigned_branch_key branches.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id branches.custom_fields.id = loan_accounts.custom_fields.id
loan_transactions	branches.encoded_key = loan_transactions.branch_key branches.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id branches.custom_fields.id = loan_transactions.custom_fields.id
users	branches.encoded_key = users.access.managed_branches.branch_key branches.custom_fields.field_set_id = users.custom_fields.field_set_id branches.custom_fields.id = users.custom_fields.id
clients	branches.custom_fields.field_set_id = clients.custom_fields.field_set_id branches.custom_fields.id = clients.custom_fields.id
communications	branches.custom_fields.field_set_id = communications.custom_fields.field_set_id branches.custom_fields.id = communications.custom_fields.id
credit_arrangements	branches.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id branches.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets	branches.custom_fields.field_set_id = custom_field_sets.id branches.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts	branches.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id branches.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products	branches.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id branches.custom_fields.id = deposit_products.custom_field_values.custom_field.id branches.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products	branches.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id branches.custom_fields.id = loan_products.custom_field_values.custom_field.id branches.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks	branches.custom_fields.field_set_id = tasks.custom_fields.field_set_id branches.custom_fields.id = tasks.custom_fields.id

branches table schema

addresses

ARRAY

Click to expand addresses

city

STRING

country

STRING

encoded_key

STRING

index_in_list

INTEGER

latitude

NUMBER

line1

STRING

line2

STRING

longitude

NUMBER

parent_key

STRING

postcode

STRING

region

STRING

branch_holidays

ARRAY

Click to expand branch_holidays

creation_date

DATE-TIME

date

DATE

encoded_key

STRING

is_anually_recurring

BOOLEAN

name

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

email_address

STRING

encoded_key

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 table to replicate.

Replication Method	Full Table
Primary Keys	deposit_id reference_token
	deposit_account
Useful links	Mambu documentation cards schema on GitHub Mambu API method

cards table schema

deposit_id

STRING

reference_token

STRING

centres

This table contains information about centres.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation centres schema on GitHub Mambu API method

centres table foreign keys

Join centres with	on
branches	centres.assigned_branch_key = branches.encoded_key centres.custom_fields.field_set_id = branches.custom_fields.field_set_id centres.custom_fields.id = branches.custom_fields.id
deposit_transactions	centres.assigned_branch_key = deposit_transactions.branch_key centres.encoded_key = deposit_transactions.centre_key centres.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id centres.custom_fields.id = deposit_transactions.custom_fields.id
groups	centres.assigned_branch_key = groups.assigned_branch_key centres.encoded_key = groups.assigned_centre_key centres.custom_fields.field_set_id = groups.custom_fields.field_set_id centres.custom_fields.id = groups.custom_fields.id
loan_accounts	centres.assigned_branch_key = loan_accounts.assigned_branch_key centres.encoded_key = loan_accounts.assigned_centre_key centres.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id centres.custom_fields.id = loan_accounts.custom_fields.id
loan_transactions	centres.assigned_branch_key = loan_transactions.branch_key centres.encoded_key = loan_transactions.centre_key centres.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id centres.custom_fields.id = loan_transactions.custom_fields.id
users	centres.assigned_branch_key = users.access.managed_branches.branch_key centres.custom_fields.field_set_id = users.custom_fields.field_set_id centres.custom_fields.id = users.custom_fields.id
clients	centres.encoded_key = clients.assigned_centre_key centres.custom_fields.field_set_id = clients.custom_fields.field_set_id centres.custom_fields.id = clients.custom_fields.id
communications	centres.custom_fields.field_set_id = communications.custom_fields.field_set_id centres.custom_fields.id = communications.custom_fields.id
credit_arrangements	centres.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id centres.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets	centres.custom_fields.field_set_id = custom_field_sets.id centres.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts	centres.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id centres.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products	centres.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id centres.custom_fields.id = deposit_products.custom_field_values.custom_field.id centres.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products	centres.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id centres.custom_fields.id = loan_products.custom_field_values.custom_field.id centres.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks	centres.custom_fields.field_set_id = tasks.custom_fields.field_set_id centres.custom_fields.id = tasks.custom_fields.id

centres table schema

addresses

ARRAY

Click to expand addresses

city

STRING

country

STRING

encoded_key

STRING

index_in_list

INTEGER

latitude

NUMBER

line1

STRING

line2

STRING

longitude

NUMBER

parent_key

STRING

postcode

STRING

region

STRING

assigned_branch_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

encoded_key

STRING

last_modified_date

DATE-TIME

meeting_day

STRING

name

STRING

notes

STRING

state

STRING

clients

This table contains information about clients.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation clients schema on GitHub Mambu API method

clients table foreign keys

Join clients with	on
centres	clients.assigned_centre_key = centres.encoded_key clients.custom_fields.field_set_id = centres.custom_fields.field_set_id clients.custom_fields.id = centres.custom_fields.id
deposit_transactions	clients.assigned_centre_key = deposit_transactions.centre_key clients.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id clients.custom_fields.id = deposit_transactions.custom_fields.id clients.assigned_user_key = deposit_transactions.user_key
groups	clients.assigned_centre_key = groups.assigned_centre_key clients.encoded_key = groups.group_members.client_key clients.custom_fields.field_set_id = groups.custom_fields.field_set_id clients.custom_fields.id = groups.custom_fields.id clients.assigned_user_key = groups.assigned_user_key
loan_accounts	clients.assigned_centre_key = loan_accounts.assigned_centre_key clients.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id clients.custom_fields.id = loan_accounts.custom_fields.id clients.assigned_user_key = loan_accounts.assigned_user_key
loan_transactions	clients.assigned_centre_key = loan_transactions.centre_key clients.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id clients.custom_fields.id = loan_transactions.custom_fields.id clients.assigned_user_key = loan_transactions.user_key
activities	clients.encoded_key = activities.client_key clients.assigned_user_key = activities.user_key
communications	clients.encoded_key = communications.client_key clients.custom_fields.field_set_id = communications.custom_fields.field_set_id clients.custom_fields.id = communications.custom_fields.id clients.assigned_user_key = communications.user_key clients.assigned_user_key = communications.sender_key
branches	clients.custom_fields.field_set_id = branches.custom_fields.field_set_id clients.custom_fields.id = branches.custom_fields.id
credit_arrangements	clients.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id clients.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets	clients.custom_fields.field_set_id = custom_field_sets.id clients.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts	clients.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id clients.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products	clients.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id clients.custom_fields.id = deposit_products.custom_field_values.custom_field.id clients.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products	clients.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id clients.custom_fields.id = loan_products.custom_field_values.custom_field.id clients.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks	clients.custom_fields.field_set_id = tasks.custom_fields.field_set_id clients.custom_fields.id = tasks.custom_fields.id clients.assigned_user_key = tasks.created_by_user_key clients.assigned_user_key = tasks.assigned_user_key
users	clients.custom_fields.field_set_id = users.custom_fields.field_set_id clients.custom_fields.id = users.custom_fields.id clients.assigned_user_key = users.encoded_key
gl_journal_entries	clients.assigned_user_key = gl_journal_entries.user_key

clients table schema

activation_date

DATE-TIME

addresses

ARRAY

Click to expand addresses

city

STRING

country

STRING

encoded_key

STRING

index_in_list

INTEGER

latitude

NUMBER

line1

STRING

line2

STRING

longitude

NUMBER

parent_key

STRING

postcode

STRING

region

STRING

approved_date

DATE-TIME

assigned_branch_key

STRING

assigned_centre_key

STRING

assigned_user_key

STRING

birth_date

DATE

client_role_key

STRING

closed_date

DATE-TIME

creation_date

DATE-TIME

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

email_address

STRING

encoded_key

STRING

first_name

STRING

gender

STRING

group_loan_cycle

INTEGER

home_phone

STRING

id_documents

ARRAY

Click to expand id_documents

client_key

STRING

document_id

STRING

document_type

STRING

encoded_key

STRING

identification_document_template_key

STRING

index_in_list

INTEGER

issuing_authority

STRING

valid_until

DATE

last_modified_date

DATE-TIME

last_name

STRING

middle_name

STRING

migration_event_key

STRING

mobile_phone

STRING

notes

STRING

preferred_language

STRING

profile_picture_key

STRING

profile_signature_key

STRING

state

STRING

communications

This table contains information about communications.

Replication Method	Key-based Incremental
Primary Key	encoded_key
Replication Key	creation_date
Useful links	Mambu documentation communications schema on GitHub Mambu API method

communications table foreign keys

Join communications with	on
activities	communications.client_key = activities.client_key communications.user_key = activities.user_key communications.sender_key = activities.user_key
clients	communications.client_key = clients.encoded_key communications.custom_fields.field_set_id = clients.custom_fields.field_set_id communications.custom_fields.id = clients.custom_fields.id communications.user_key = clients.assigned_user_key communications.sender_key = clients.assigned_user_key
groups	communications.client_key = groups.group_members.client_key communications.custom_fields.field_set_id = groups.custom_fields.field_set_id communications.custom_fields.id = groups.custom_fields.id communications.group_key = groups.encoded_key communications.user_key = groups.assigned_user_key communications.sender_key = groups.assigned_user_key
branches	communications.custom_fields.field_set_id = branches.custom_fields.field_set_id communications.custom_fields.id = branches.custom_fields.id
centres	communications.custom_fields.field_set_id = centres.custom_fields.field_set_id communications.custom_fields.id = centres.custom_fields.id
credit_arrangements	communications.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id communications.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets	communications.custom_fields.field_set_id = custom_field_sets.id communications.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts	communications.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id communications.custom_fields.id = deposit_accounts.custom_fields.id communications.deposit_account_key = deposit_accounts.encoded_key
deposit_products	communications.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id communications.custom_fields.id = deposit_products.custom_field_values.custom_field.id communications.custom_fields.id = deposit_products.custom_field_values.custom_field_id
deposit_transactions	communications.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id communications.custom_fields.id = deposit_transactions.custom_fields.id communications.user_key = deposit_transactions.user_key communications.sender_key = deposit_transactions.user_key
loan_accounts	communications.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id communications.custom_fields.id = loan_accounts.custom_fields.id communications.deposit_account_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key communications.deposit_account_key = loan_accounts.funding_sources.deposit_account_key communications.deposit_account_key = loan_accounts.guarantors.deposit_account_key communications.loan_account_key = loan_accounts.encoded_key communications.user_key = loan_accounts.assigned_user_key communications.sender_key = loan_accounts.assigned_user_key
loan_products	communications.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id communications.custom_fields.id = loan_products.custom_field_values.custom_field.id communications.custom_fields.id = loan_products.custom_field_values.custom_field_id
loan_transactions	communications.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id communications.custom_fields.id = loan_transactions.custom_fields.id communications.user_key = loan_transactions.user_key communications.sender_key = loan_transactions.user_key
tasks	communications.custom_fields.field_set_id = tasks.custom_fields.field_set_id communications.custom_fields.id = tasks.custom_fields.id communications.user_key = tasks.created_by_user_key communications.sender_key = tasks.created_by_user_key communications.user_key = tasks.assigned_user_key communications.sender_key = tasks.assigned_user_key
users	communications.custom_fields.field_set_id = users.custom_fields.field_set_id communications.custom_fields.id = users.custom_fields.id communications.user_key = users.encoded_key communications.sender_key = users.encoded_key
gl_journal_entries	communications.user_key = gl_journal_entries.user_key communications.sender_key = gl_journal_entries.user_key

communications table schema

body

STRING

client_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

deposit_account_key

STRING

destination

STRING

encoded_key

STRING

event

STRING

failure_cause

STRING

failure_reason

STRING

group_key

STRING

loan_account_key

STRING

num_retries

INTEGER

reference_id

STRING

repayment_key

STRING

send_date

DATE-TIME

sender_key

STRING

state

STRING

subject

STRING

template_key

STRING

type

STRING

user_key

STRING

credit_arrangements

This table contains information about credit arrangements.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation credit_arrangements schema on GitHub Mambu API method

credit_arrangements table foreign keys

Join credit_arrangements with	on
deposit_accounts	credit_arrangements.encoded_key = deposit_accounts.credit_arrangement_key credit_arrangements.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id credit_arrangements.custom_fields.id = deposit_accounts.custom_fields.id
loan_accounts	credit_arrangements.encoded_key = loan_accounts.credit_arrangement_key credit_arrangements.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id credit_arrangements.custom_fields.id = loan_accounts.custom_fields.id
branches	credit_arrangements.custom_fields.field_set_id = branches.custom_fields.field_set_id credit_arrangements.custom_fields.id = branches.custom_fields.id
centres	credit_arrangements.custom_fields.field_set_id = centres.custom_fields.field_set_id credit_arrangements.custom_fields.id = centres.custom_fields.id
clients	credit_arrangements.custom_fields.field_set_id = clients.custom_fields.field_set_id credit_arrangements.custom_fields.id = clients.custom_fields.id
communications	credit_arrangements.custom_fields.field_set_id = communications.custom_fields.field_set_id credit_arrangements.custom_fields.id = communications.custom_fields.id
custom_field_sets	credit_arrangements.custom_fields.field_set_id = custom_field_sets.id credit_arrangements.custom_fields.id = custom_field_sets.custom_fields.id
deposit_products	credit_arrangements.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id credit_arrangements.custom_fields.id = deposit_products.custom_field_values.custom_field.id credit_arrangements.custom_fields.id = deposit_products.custom_field_values.custom_field_id
deposit_transactions	credit_arrangements.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id credit_arrangements.custom_fields.id = deposit_transactions.custom_fields.id
groups	credit_arrangements.custom_fields.field_set_id = groups.custom_fields.field_set_id credit_arrangements.custom_fields.id = groups.custom_fields.id
loan_products	credit_arrangements.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id credit_arrangements.custom_fields.id = loan_products.custom_field_values.custom_field.id credit_arrangements.custom_fields.id = loan_products.custom_field_values.custom_field_id
loan_transactions	credit_arrangements.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id credit_arrangements.custom_fields.id = loan_transactions.custom_fields.id
tasks	credit_arrangements.custom_fields.field_set_id = tasks.custom_fields.field_set_id credit_arrangements.custom_fields.id = tasks.custom_fields.id
users	credit_arrangements.custom_fields.field_set_id = users.custom_fields.field_set_id credit_arrangements.custom_fields.id = users.custom_fields.id

credit_arrangements table schema

amount

NUMBER

approved_date

DATE-TIME

available_credit_amount

NUMBER

consumed_credit_amount

NUMBER

creation_date

DATE-TIME

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

encoded_key

STRING

expire_date

DATE-TIME

holder_key

STRING

holder_type

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

Useful links

Mambu documentation

custom_field_sets schema on GitHub

Mambu API method

custom_field_sets table foreign keys

Join custom_field_sets with	on
branches	custom_field_sets.id = branches.custom_fields.field_set_id custom_field_sets.custom_fields.id = branches.custom_fields.id
centres	custom_field_sets.id = centres.custom_fields.field_set_id custom_field_sets.custom_fields.id = centres.custom_fields.id
clients	custom_field_sets.id = clients.custom_fields.field_set_id custom_field_sets.custom_fields.id = clients.custom_fields.id
communications	custom_field_sets.id = communications.custom_fields.field_set_id custom_field_sets.custom_fields.id = communications.custom_fields.id
credit_arrangements	custom_field_sets.id = credit_arrangements.custom_fields.field_set_id custom_field_sets.custom_fields.id = credit_arrangements.custom_fields.id
deposit_accounts	custom_field_sets.id = deposit_accounts.custom_fields.field_set_id custom_field_sets.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products	custom_field_sets.id = deposit_products.custom_field_values.custom_field.custom_field_set.id custom_field_sets.custom_fields.id = deposit_products.custom_field_values.custom_field.id custom_field_sets.custom_fields.id = deposit_products.custom_field_values.custom_field_id
deposit_transactions	custom_field_sets.id = deposit_transactions.custom_fields.field_set_id custom_field_sets.custom_fields.id = deposit_transactions.custom_fields.id
groups	custom_field_sets.id = groups.custom_fields.field_set_id custom_field_sets.custom_fields.id = groups.custom_fields.id
loan_accounts	custom_field_sets.id = loan_accounts.custom_fields.field_set_id custom_field_sets.custom_fields.id = loan_accounts.custom_fields.id
loan_products	custom_field_sets.id = loan_products.custom_field_values.custom_field.custom_field_set.id custom_field_sets.custom_fields.id = loan_products.custom_field_values.custom_field.id custom_field_sets.custom_fields.id = loan_products.custom_field_values.custom_field_id
loan_transactions	custom_field_sets.id = loan_transactions.custom_fields.field_set_id custom_field_sets.custom_fields.id = loan_transactions.custom_fields.id
tasks	custom_field_sets.id = tasks.custom_fields.field_set_id custom_field_sets.custom_fields.id = tasks.custom_fields.id
users	custom_field_sets.id = users.custom_fields.field_set_id custom_field_sets.custom_fields.id = users.custom_fields.id

custom_field_sets table schema

created_date

DATE-TIME

custom_fields

ARRAY

Click to expand custom_fields

amounts

OBJECT

custom_field_product_settings

ARRAY

Click to expand custom_field_product_settings

custom_field_encoded_key

STRING

encoded_key

STRING

is_default

BOOLEAN

is_required

BOOLEAN

link_type

STRING

product_key

STRING

custom_field_selection_options

ARRAY

Click to expand custom_field_selection_options

encoded_key

STRING

is_default

BOOLEAN

score

STRING

value

STRING

data_type

STRING

edit_rights

OBJECT

Click to expand edit_rights

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

Click to expand view_rights

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

notes

STRING

type

STRING

usage

STRING

deposit_accounts

This table contains information about deposit accounts.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation deposit_accounts schema on GitHub Mambu API method

deposit_accounts table foreign keys

Join deposit_accounts with	on
credit_arrangements	deposit_accounts.credit_arrangement_key = credit_arrangements.encoded_key deposit_accounts.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id deposit_accounts.custom_fields.id = credit_arrangements.custom_fields.id
loan_accounts	deposit_accounts.credit_arrangement_key = loan_accounts.credit_arrangement_key deposit_accounts.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id deposit_accounts.custom_fields.id = loan_accounts.custom_fields.id deposit_accounts.encoded_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key deposit_accounts.encoded_key = loan_accounts.funding_sources.deposit_account_key deposit_accounts.encoded_key = loan_accounts.guarantors.deposit_account_key
branches	deposit_accounts.custom_fields.field_set_id = branches.custom_fields.field_set_id deposit_accounts.custom_fields.id = branches.custom_fields.id
centres	deposit_accounts.custom_fields.field_set_id = centres.custom_fields.field_set_id deposit_accounts.custom_fields.id = centres.custom_fields.id
clients	deposit_accounts.custom_fields.field_set_id = clients.custom_fields.field_set_id deposit_accounts.custom_fields.id = clients.custom_fields.id
communications	deposit_accounts.custom_fields.field_set_id = communications.custom_fields.field_set_id deposit_accounts.custom_fields.id = communications.custom_fields.id deposit_accounts.encoded_key = communications.deposit_account_key
custom_field_sets	deposit_accounts.custom_fields.field_set_id = custom_field_sets.id deposit_accounts.custom_fields.id = custom_field_sets.custom_fields.id
deposit_products	deposit_accounts.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id deposit_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field.id deposit_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field_id
deposit_transactions	deposit_accounts.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id deposit_accounts.custom_fields.id = deposit_transactions.custom_fields.id
groups	deposit_accounts.custom_fields.field_set_id = groups.custom_fields.field_set_id deposit_accounts.custom_fields.id = groups.custom_fields.id
loan_products	deposit_accounts.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id deposit_accounts.custom_fields.id = loan_products.custom_field_values.custom_field.id deposit_accounts.custom_fields.id = loan_products.custom_field_values.custom_field_id
loan_transactions	deposit_accounts.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id deposit_accounts.custom_fields.id = loan_transactions.custom_fields.id
tasks	deposit_accounts.custom_fields.field_set_id = tasks.custom_fields.field_set_id deposit_accounts.custom_fields.id = tasks.custom_fields.id
users	deposit_accounts.custom_fields.field_set_id = users.custom_fields.field_set_id deposit_accounts.custom_fields.id = users.custom_fields.id

deposit_accounts table schema

account_holder_key

STRING

account_holder_type

STRING

account_state

STRING

account_type

STRING

accrued_amounts

OBJECT

Click to expand accrued_amounts

interest_accrued

NUMBER

overdraft_interest_accrued

NUMBER

technical_overdraft_interest_accrued

NUMBER

activation_date

DATE-TIME

approved_date

DATE-TIME

assigned_branch_key

STRING

assigned_centre_key

STRING

assigned_user_key

STRING

balances

OBJECT

Click to expand balances

available_balance

NUMBER

fees_due

NUMBER

hold_balance

NUMBER

locked_balance

NUMBER

overdraft_amount

NUMBER

overdraft_interest_due

NUMBER

technical_overdraft_amount

NUMBER

technical_overdraft_interest_due

NUMBER

total_balance

NUMBER

closed_date

DATE-TIME

creation_date

DATE-TIME

credit_arrangement_key

STRING

currency_code

STRING

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

encoded_key

STRING

interest_settings

OBJECT

Click to expand interest_settings

interest_payment_settings

OBJECT

Click to expand interest_payment_settings

interest_payment_dates

ARRAY

Click to expand interest_payment_dates

day

INTEGER

month

INTEGER

interest_payment_point

STRING

interest_rate_settings

OBJECT

Click to expand interest_rate_settings

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate

NUMBER

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

Click to expand interest_rate_tiers

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

internal_controls

OBJECT

Click to expand internal_controls

max_withdrawal_amount

NUMBER

recommended_deposit_amount

NUMBER

target_amount

NUMBER

last_account_appraisal_date

DATE-TIME

last_interest_calculation_date

DATE-TIME

last_interest_stored_date

DATE-TIME

last_modified_date

DATE-TIME

last_overdraft_interest_review_date

DATE-TIME

last_sent_to_arrears_date

DATE-TIME

linked_settlement_account_keys

ARRAY

locked_date

DATE-TIME

maturity_date

DATE-TIME

migration_event_key

STRING

name

STRING

notes

STRING

overdraft_interest_settings

OBJECT

Click to expand overdraft_interest_settings

interest_rate_settings

OBJECT

Click to expand interest_rate_settings

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

Click to expand interest_rate_tiers

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

interest_spread

NUMBER

overdraft_settings

OBJECT

Click to expand overdraft_settings

allowed_overdraft

BOOLEAN

overdraft_expiry_date

DATE-TIME

overdraft_limit

NUMBER

product_type_key

STRING

withholding_tax_source_key

STRING

deposit_products

This table contains information about deposit (savings) products.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation deposit_products schema on GitHub Mambu API method

deposit_products table foreign keys

Join deposit_products with	on
branches	deposit_products.custom_field_values.custom_field.custom_field_set.id = branches.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = branches.custom_fields.id deposit_products.custom_field_values.custom_field_id = branches.custom_fields.id
centres	deposit_products.custom_field_values.custom_field.custom_field_set.id = centres.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = centres.custom_fields.id deposit_products.custom_field_values.custom_field_id = centres.custom_fields.id
clients	deposit_products.custom_field_values.custom_field.custom_field_set.id = clients.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = clients.custom_fields.id deposit_products.custom_field_values.custom_field_id = clients.custom_fields.id
communications	deposit_products.custom_field_values.custom_field.custom_field_set.id = communications.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = communications.custom_fields.id deposit_products.custom_field_values.custom_field_id = communications.custom_fields.id
credit_arrangements	deposit_products.custom_field_values.custom_field.custom_field_set.id = credit_arrangements.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = credit_arrangements.custom_fields.id deposit_products.custom_field_values.custom_field_id = credit_arrangements.custom_fields.id
custom_field_sets	deposit_products.custom_field_values.custom_field.custom_field_set.id = custom_field_sets.id deposit_products.custom_field_values.custom_field.id = custom_field_sets.custom_fields.id deposit_products.custom_field_values.custom_field_id = custom_field_sets.custom_fields.id
deposit_accounts	deposit_products.custom_field_values.custom_field.custom_field_set.id = deposit_accounts.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = deposit_accounts.custom_fields.id deposit_products.custom_field_values.custom_field_id = deposit_accounts.custom_fields.id
deposit_transactions	deposit_products.custom_field_values.custom_field.custom_field_set.id = deposit_transactions.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = deposit_transactions.custom_fields.id deposit_products.custom_field_values.custom_field_id = deposit_transactions.custom_fields.id
groups	deposit_products.custom_field_values.custom_field.custom_field_set.id = groups.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = groups.custom_fields.id deposit_products.custom_field_values.custom_field_id = groups.custom_fields.id
loan_accounts	deposit_products.custom_field_values.custom_field.custom_field_set.id = loan_accounts.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = loan_accounts.custom_fields.id deposit_products.custom_field_values.custom_field_id = loan_accounts.custom_fields.id
loan_products	deposit_products.custom_field_values.custom_field.custom_field_set.id = loan_products.custom_field_values.custom_field.custom_field_set.id deposit_products.custom_field_values.custom_field.id = loan_products.custom_field_values.custom_field.id deposit_products.custom_field_values.custom_field_id = loan_products.custom_field_values.custom_field.id deposit_products.custom_field_values.custom_field.id = loan_products.custom_field_values.custom_field_id deposit_products.custom_field_values.custom_field_id = loan_products.custom_field_values.custom_field_id
loan_transactions	deposit_products.custom_field_values.custom_field.custom_field_set.id = loan_transactions.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = loan_transactions.custom_fields.id deposit_products.custom_field_values.custom_field_id = loan_transactions.custom_fields.id
tasks	deposit_products.custom_field_values.custom_field.custom_field_set.id = tasks.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = tasks.custom_fields.id deposit_products.custom_field_values.custom_field_id = tasks.custom_fields.id
users	deposit_products.custom_field_values.custom_field.custom_field_set.id = users.custom_fields.field_set_id deposit_products.custom_field_values.custom_field.id = users.custom_fields.id deposit_products.custom_field_values.custom_field_id = users.custom_fields.id

deposit_products table schema

accounting_method

STRING

activated

BOOLEAN

allow_arbitrary_fees

BOOLEAN

allow_offset

BOOLEAN

allow_overdraft

BOOLEAN

allow_technical_overdraft

BOOLEAN

available_product_branches

ARRAY

Click to expand available_product_branches

branch_key

STRING

encoded_key

STRING

collect_interest_when_locked

BOOLEAN

creation_date

DATE-TIME

currencies

ARRAY

Click to expand currencies

code

STRING

creation_date

DATE-TIME

currency_symbol_position

STRING

digits_after_decimal

INTEGER

is_base_currency

BOOLEAN

last_modified_date

DATE-TIME

name

STRING

symbol

STRING

custom_field_values

ARRAY

Click to expand custom_field_values

amount

STRING

custom_field

OBJECT

Click to expand custom_field

amounts

OBJECT

custom_field_selection_options

ARRAY

Click to expand custom_field_selection_options

encoded_key

STRING

score

STRING

value

STRING

custom_field_set

OBJECT

Click to expand custom_field_set

creation_date

DATE-TIME

encoded_key

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

type

STRING

usage

STRING

data_type

STRING

edit_rights

OBJECT

Click to expand edit_rights

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

Click to expand view_rights

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

custom_field_id

STRING

custom_field_key

STRING

custom_field_set_group_index

INTEGER

encoded_key

STRING

index_in_list

INTEGER

parent_key

STRING

value

STRING

description

STRING

encoded_key

STRING

for_all_branches

BOOLEAN

for_groups

BOOLEAN

for_individuals

BOOLEAN

STRING

id_generator_type

STRING

id_pattern

STRING

interest_accrued_accounting_method

STRING

interest_calculation_balance

STRING

interest_days_in_year

STRING

interest_paid_into_account

BOOLEAN

interest_payment_point

STRING

interest_rate_settings

OBJECT

Click to expand interest_rate_settings

accrue_interest_after_maturity

BOOLEAN

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

Click to expand interest_rate_tiers

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

last_modified_date

DATE-TIME

line_of_credit_requirement

STRING

maturity_period_limit

STRING

max_overdraft_limit

STRING

min_opening_balance

STRING

name

STRING

overdraft_days_in_year

STRING

overdraft_interest_rate_settings

OBJECT

Click to expand overdraft_interest_rate_settings

accrue_interest_after_maturity

BOOLEAN

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

Click to expand interest_rate_tiers

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

product_type

STRING

savings_fees

ARRAY

Click to expand savings_fees

active

BOOLEAN

amortization_profile

STRING

amount

STRING

amount_calculation_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_amortization_upon_reschedule_option

STRING

fee_application

STRING

fee_product_rules

ARRAY

name

STRING

trigger

STRING

savings_product_rules

ARRAY

templates

ARRAY

Click to expand templates

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

withholding_tax_enabled

BOOLEAN

deposit_transactions

This table contains information about deposit transactions.

Replication Method	Key-based Incremental
Primary Key	encoded_key
Replication Key	creation_date
Useful links	Mambu documentation deposit_transactions schema on GitHub Mambu API method

deposit_transactions table foreign keys

Join deposit_transactions with	on
branches	deposit_transactions.branch_key = branches.encoded_key deposit_transactions.custom_fields.field_set_id = branches.custom_fields.field_set_id deposit_transactions.custom_fields.id = branches.custom_fields.id
centres	deposit_transactions.branch_key = centres.assigned_branch_key deposit_transactions.centre_key = centres.encoded_key deposit_transactions.custom_fields.field_set_id = centres.custom_fields.field_set_id deposit_transactions.custom_fields.id = centres.custom_fields.id
groups	deposit_transactions.branch_key = groups.assigned_branch_key deposit_transactions.centre_key = groups.assigned_centre_key deposit_transactions.custom_fields.field_set_id = groups.custom_fields.field_set_id deposit_transactions.custom_fields.id = groups.custom_fields.id deposit_transactions.user_key = groups.assigned_user_key
loan_accounts	deposit_transactions.branch_key = loan_accounts.assigned_branch_key deposit_transactions.centre_key = loan_accounts.assigned_centre_key deposit_transactions.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id deposit_transactions.custom_fields.id = loan_accounts.custom_fields.id deposit_transactions.user_key = loan_accounts.assigned_user_key
loan_transactions	deposit_transactions.branch_key = loan_transactions.branch_key deposit_transactions.centre_key = loan_transactions.centre_key deposit_transactions.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id deposit_transactions.custom_fields.id = loan_transactions.custom_fields.id deposit_transactions.transfer_details.linked_deposit_transaction_key = loan_transactions.transfer_details.linked_deposit_transaction_key deposit_transactions.linked_loan_transaction_key = loan_transactions.encoded_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.encoded_key deposit_transactions.linked_loan_transaction_key = loan_transactions.linked_loan_transaction_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.linked_loan_transaction_key deposit_transactions.linked_loan_transaction_key = loan_transactions.parent_loan_transaction_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.parent_loan_transaction_key deposit_transactions.linked_loan_transaction_key = loan_transactions.transfer_details.linked_loan_transaction_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.transfer_details.linked_loan_transaction_key deposit_transactions.user_key = loan_transactions.user_key
users	deposit_transactions.branch_key = users.access.managed_branches.branch_key deposit_transactions.custom_fields.field_set_id = users.custom_fields.field_set_id deposit_transactions.custom_fields.id = users.custom_fields.id deposit_transactions.user_key = users.encoded_key
clients	deposit_transactions.centre_key = clients.assigned_centre_key deposit_transactions.custom_fields.field_set_id = clients.custom_fields.field_set_id deposit_transactions.custom_fields.id = clients.custom_fields.id deposit_transactions.user_key = clients.assigned_user_key
communications	deposit_transactions.custom_fields.field_set_id = communications.custom_fields.field_set_id deposit_transactions.custom_fields.id = communications.custom_fields.id deposit_transactions.user_key = communications.user_key deposit_transactions.user_key = communications.sender_key
credit_arrangements	deposit_transactions.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id deposit_transactions.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets	deposit_transactions.custom_fields.field_set_id = custom_field_sets.id deposit_transactions.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts	deposit_transactions.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id deposit_transactions.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products	deposit_transactions.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id deposit_transactions.custom_fields.id = deposit_products.custom_field_values.custom_field.id deposit_transactions.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products	deposit_transactions.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id deposit_transactions.custom_fields.id = loan_products.custom_field_values.custom_field.id deposit_transactions.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks	deposit_transactions.custom_fields.field_set_id = tasks.custom_fields.field_set_id deposit_transactions.custom_fields.id = tasks.custom_fields.id deposit_transactions.user_key = tasks.created_by_user_key deposit_transactions.user_key = tasks.assigned_user_key
activities	deposit_transactions.user_key = activities.user_key
gl_journal_entries	deposit_transactions.user_key = gl_journal_entries.user_key

deposit_transactions table schema

account_balances

OBJECT

Click to expand account_balances

total_balance

NUMBER

adjustment_transaction_key

STRING

affected_amounts

OBJECT

Click to expand affected_amounts

fees_amount

NUMBER

fraction_amount

NUMBER

funds_amount

NUMBER

interest_amount

NUMBER

overdraft_amount

NUMBER

overdraft_fees_amount

NUMBER

overdraft_interest_amount

NUMBER

technical_overdraft_amount

NUMBER

technical_overdraft_interest_amount

NUMBER

amount

NUMBER

booking_date

DATE-TIME

branch_key

STRING

card_transaction

OBJECT

Click to expand card_transaction

advice

BOOLEAN

amount

NUMBER

card_acceptor

OBJECT

Click to expand card_acceptor

city

STRING

country

STRING

mcc

INTEGER

name

STRING

state

STRING

zip

STRING

card_token

STRING

currency_code

STRING

encoded_key

STRING

external_authorization_reference_id

STRING

external_reference_id

STRING

user_transaction_time

STRING

centre_key

STRING

creation_date

DATE-TIME

currency_code

STRING

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

encoded_key

STRING

external_id

STRING

fees

ARRAY

Click to expand fees

amount

NUMBER

name

STRING

predefined_fee_key

STRING

tax_amount

NUMBER

trigger

STRING

linked_loan_transaction_key

STRING

migration_event_key

STRING

notes

STRING

original_transaction_key

STRING

parent_account_key

STRING

payment_details

OBJECT

Click to expand payment_details

creditor

OBJECT

Click to expand creditor

name

STRING

creditor_account

OBJECT

Click to expand creditor_account

currency

STRING

identification

OBJECT

Click to expand identification

iban

STRING

other

OBJECT

Click to expand other

identification

STRING

scheme

STRING

creditor_agent

OBJECT

Click to expand creditor_agent

financial_institution_identification

OBJECT

Click to expand financial_institution_identification

bic

STRING

debtor

OBJECT

Click to expand debtor

name

STRING

debtor_account

OBJECT

Click to expand debtor_account

currency

STRING

identification

OBJECT

Click to expand identification

iban

STRING

other

OBJECT

Click to expand other

identification

STRING

scheme

STRING

debtor_agent

OBJECT

Click to expand debtor_agent

financial_institution_identification

OBJECT

Click to expand financial_institution_identification

bic

STRING

payment_identification

OBJECT

Click to expand payment_identification

end_to_end_identification

STRING

instruction_identification

STRING

transaction_identification

STRING

payment_type_information

OBJECT

Click to expand payment_type_information

service_level

OBJECT

Click to expand service_level

code

STRING

remittance_information

OBJECT

Click to expand remittance_information

structured

OBJECT

Click to expand structured

creditor_reference_information

OBJECT

Click to expand creditor_reference_information

reference

STRING

reference_issuer

STRING

reference_type

STRING

unstructured

STRING

taxes

OBJECT

Click to expand taxes

tax_rate

NUMBER

terms

OBJECT

Click to expand terms

interest_settings

OBJECT

Click to expand interest_settings

interest_rate

NUMBER

overdraft_interest_settings

OBJECT

Click to expand overdraft_interest_settings

index_interest_rate

NUMBER

interest_rate

NUMBER

overdraft_settings

OBJECT

Click to expand overdraft_settings

overdraft_limit

NUMBER

till_key

STRING

transaction_details

OBJECT

Click to expand transaction_details

transaction_channel_id

STRING

transaction_channel_key

STRING

transfer_details

OBJECT

Click to expand transfer_details

linked_deposit_transaction_key

STRING

linked_loan_transaction_key

STRING

type

STRING

user_key

STRING

value_date

DATE-TIME

gl_accounts

This table contains information about general ledger accounts.

Replication Method	Key-based Incremental
Primary Key	gl_code
Replication Key	last_modified_date
Useful links	Mambu documentation gl_accounts schema on GitHub Mambu API method

gl_accounts table foreign keys

Join gl_accounts with	on
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

Click to expand currency

code

STRING

currency_symbol_position

STRING

digits_after_decimal

INTEGER

is_base_currency

BOOLEAN

last_modified_date

DATE-TIME

name

STRING

symbol

STRING

encoded_key

STRING

entry_id

STRING

gl_code

STRING

last_modified_date

DATE-TIME

name

STRING

strip_trailing_zeros

BOOLEAN

type

STRING

usage

STRING

gl_journal_entries

This table contains information about general ledger entries.

Replication Method	Key-based Incremental
Primary Key	entry_id
Replication Key	booking_date
Useful links	Mambu documentation gl_journal_entries schema on GitHub Mambu API method

gl_journal_entries table foreign keys

Join gl_journal_entries with	on
gl_accounts	gl_journal_entries.gl_account.gl_code = gl_accounts.gl_code
activities	gl_journal_entries.user_key = activities.user_key
clients	gl_journal_entries.user_key = clients.assigned_user_key
communications	gl_journal_entries.user_key = communications.user_key gl_journal_entries.user_key = communications.sender_key
deposit_transactions	gl_journal_entries.user_key = deposit_transactions.user_key
groups	gl_journal_entries.user_key = groups.assigned_user_key
loan_accounts	gl_journal_entries.user_key = loan_accounts.assigned_user_key
loan_transactions	gl_journal_entries.user_key = loan_transactions.user_key
tasks	gl_journal_entries.user_key = tasks.created_by_user_key gl_journal_entries.user_key = tasks.assigned_user_key
users	gl_journal_entries.user_key = users.encoded_key

gl_journal_entries table schema

account_key

STRING

amount

NUMBER

booking_date

DATE-TIME

creation_date

DATE-TIME

encoded_key

STRING

entry_date

DATE-TIME

entry_id

STRING

gl_account

OBJECT

Click to expand gl_account

activated

BOOLEAN

allow_manual_journal_entries

BOOLEAN

balance

NUMBER

creation_date

DATE-TIME

currency

OBJECT

Click to expand currency

code

STRING

currency_symbol_position

STRING

digits_after_decimal

INTEGER

is_base_currency

BOOLEAN

last_modified_date

DATE-TIME

name

STRING

symbol

STRING

encoded_key

STRING

entry_id

STRING

gl_code

STRING

last_modified_date

DATE-TIME

name

STRING

strip_trailing_zeros

BOOLEAN

type

STRING

usage

STRING

product_key

STRING

transaction_id

STRING

type

STRING

user_key

STRING

groups

This table contains information about groups.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation groups schema on GitHub Mambu API method

groups table foreign keys

Join groups with	on
branches	groups.assigned_branch_key = branches.encoded_key groups.custom_fields.field_set_id = branches.custom_fields.field_set_id groups.custom_fields.id = branches.custom_fields.id
centres	groups.assigned_branch_key = centres.assigned_branch_key groups.assigned_centre_key = centres.encoded_key groups.custom_fields.field_set_id = centres.custom_fields.field_set_id groups.custom_fields.id = centres.custom_fields.id
deposit_transactions	groups.assigned_branch_key = deposit_transactions.branch_key groups.assigned_centre_key = deposit_transactions.centre_key groups.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id groups.custom_fields.id = deposit_transactions.custom_fields.id groups.assigned_user_key = deposit_transactions.user_key
loan_accounts	groups.assigned_branch_key = loan_accounts.assigned_branch_key groups.assigned_centre_key = loan_accounts.assigned_centre_key groups.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id groups.custom_fields.id = loan_accounts.custom_fields.id groups.assigned_user_key = loan_accounts.assigned_user_key
loan_transactions	groups.assigned_branch_key = loan_transactions.branch_key groups.assigned_centre_key = loan_transactions.centre_key groups.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id groups.custom_fields.id = loan_transactions.custom_fields.id groups.assigned_user_key = loan_transactions.user_key
users	groups.assigned_branch_key = users.access.managed_branches.branch_key groups.custom_fields.field_set_id = users.custom_fields.field_set_id groups.custom_fields.id = users.custom_fields.id groups.assigned_user_key = users.encoded_key
clients	groups.assigned_centre_key = clients.assigned_centre_key groups.group_members.client_key = clients.encoded_key groups.custom_fields.field_set_id = clients.custom_fields.field_set_id groups.custom_fields.id = clients.custom_fields.id groups.assigned_user_key = clients.assigned_user_key
activities	groups.group_members.client_key = activities.client_key groups.assigned_user_key = activities.user_key
communications	groups.group_members.client_key = communications.client_key groups.custom_fields.field_set_id = communications.custom_fields.field_set_id groups.custom_fields.id = communications.custom_fields.id groups.encoded_key = communications.group_key groups.assigned_user_key = communications.user_key groups.assigned_user_key = communications.sender_key
credit_arrangements	groups.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id groups.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets	groups.custom_fields.field_set_id = custom_field_sets.id groups.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts	groups.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id groups.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products	groups.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id groups.custom_fields.id = deposit_products.custom_field_values.custom_field.id groups.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products	groups.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id groups.custom_fields.id = loan_products.custom_field_values.custom_field.id groups.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks	groups.custom_fields.field_set_id = tasks.custom_fields.field_set_id groups.custom_fields.id = tasks.custom_fields.id groups.assigned_user_key = tasks.created_by_user_key groups.assigned_user_key = tasks.assigned_user_key
gl_journal_entries	groups.assigned_user_key = gl_journal_entries.user_key

groups table schema

addresses

ARRAY

Click to expand addresses

city

STRING

country

STRING

encoded_key

STRING

index_in_list

INTEGER

latitude

NUMBER

line1

STRING

line2

STRING

longitude

NUMBER

parent_key

STRING

postcode

STRING

region

STRING

assigned_branch_key

STRING

assigned_centre_key

STRING

assigned_user_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

email_address

STRING

encoded_key

STRING

group_members

ARRAY

Click to expand group_members

client_key

STRING

roles

ARRAY

Click to expand roles

encoded_key

STRING

group_role_name_key

STRING

role_name

STRING

group_name

STRING

group_role_key

STRING

home_phone

STRING

last_modified_date

DATE-TIME

loan_cycle

STRING

migration_event_key

STRING

mobile_phone

STRING

notes

STRING

preferred_language

STRING

index_rate_sources

This table contains information about index rate sources.

Replication Method

Full Table

Primary Key

encoded_key

Useful links

index_rate_sources schema on GitHub

Mambu API method

index_rate_sources table schema

encoded_key

STRING

name

STRING

notes

STRING

type

STRING

installments

This table contains information about installments for a loan.

Replication Method	Key-based Incremental
Primary Key	encoded_key
Replication Key	last_paid_date
Useful links	Mambu documentation installments schema on GitHub Mambu API method

installments table schema

due_date

DATE-TIME

encoded_key

STRING

fee

OBJECT

Click to expand fee

amount

OBJECT

Click to expand amount

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

Click to expand tax

due

NUMBER

expected

NUMBER

paid

NUMBER

interest

OBJECT

Click to expand interest

amount

OBJECT

Click to expand amount

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

Click to expand tax

due

NUMBER

expected

NUMBER

paid

NUMBER

last_paid_date

DATE-TIME

number

STRING

parent_account_key

STRING

penalty

OBJECT

Click to expand penalty

amount

OBJECT

Click to expand amount

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

Click to expand tax

due

NUMBER

expected

NUMBER

paid

NUMBER

principal

OBJECT

Click to expand principal

amount

OBJECT

Click to expand amount

due

NUMBER

expected

NUMBER

paid

NUMBER

repaid_date

DATE-TIME

state

STRING

interest_accrual_breakdown

This table contains information about interest accruals.

Replication Method	Key-based Incremental
Primary Key	entry_id
Replication Key	creation_date
Useful links	interest_accrual_breakdown schema on GitHub

interest_accrual_breakdown table schema

account_id

STRING

account_key

STRING

amount

NUMBER

booking_date

DATE-TIME

branch_key

STRING

branch_name

STRING

creation_date

DATE-TIME

entry_id

INTEGER

entry_type

STRING

foreign_amount

OBJECT

Click to expand foreign_amount

accounting_rate

OBJECT

Click to expand accounting_rate

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

Click to expand currency

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	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation loan_accounts schema on GitHub Mambu API method

loan_accounts table foreign keys

Join loan_accounts with	on
branches	loan_accounts.assigned_branch_key = branches.encoded_key loan_accounts.custom_fields.field_set_id = branches.custom_fields.field_set_id loan_accounts.custom_fields.id = branches.custom_fields.id
centres	loan_accounts.assigned_branch_key = centres.assigned_branch_key loan_accounts.assigned_centre_key = centres.encoded_key loan_accounts.custom_fields.field_set_id = centres.custom_fields.field_set_id loan_accounts.custom_fields.id = centres.custom_fields.id
deposit_transactions	loan_accounts.assigned_branch_key = deposit_transactions.branch_key loan_accounts.assigned_centre_key = deposit_transactions.centre_key loan_accounts.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id loan_accounts.custom_fields.id = deposit_transactions.custom_fields.id loan_accounts.assigned_user_key = deposit_transactions.user_key
groups	loan_accounts.assigned_branch_key = groups.assigned_branch_key loan_accounts.assigned_centre_key = groups.assigned_centre_key loan_accounts.custom_fields.field_set_id = groups.custom_fields.field_set_id loan_accounts.custom_fields.id = groups.custom_fields.id loan_accounts.assigned_user_key = groups.assigned_user_key
loan_transactions	loan_accounts.assigned_branch_key = loan_transactions.branch_key loan_accounts.assigned_centre_key = loan_transactions.centre_key loan_accounts.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id loan_accounts.custom_fields.id = loan_transactions.custom_fields.id loan_accounts.assigned_user_key = loan_transactions.user_key
users	loan_accounts.assigned_branch_key = users.access.managed_branches.branch_key loan_accounts.custom_fields.field_set_id = users.custom_fields.field_set_id loan_accounts.custom_fields.id = users.custom_fields.id loan_accounts.assigned_user_key = users.encoded_key
clients	loan_accounts.assigned_centre_key = clients.assigned_centre_key loan_accounts.custom_fields.field_set_id = clients.custom_fields.field_set_id loan_accounts.custom_fields.id = clients.custom_fields.id loan_accounts.assigned_user_key = clients.assigned_user_key
credit_arrangements	loan_accounts.credit_arrangement_key = credit_arrangements.encoded_key loan_accounts.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id loan_accounts.custom_fields.id = credit_arrangements.custom_fields.id
deposit_accounts	loan_accounts.credit_arrangement_key = deposit_accounts.credit_arrangement_key loan_accounts.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id loan_accounts.custom_fields.id = deposit_accounts.custom_fields.id loan_accounts.disbursement_details.transaction_details.target_deposit_account_key = deposit_accounts.encoded_key loan_accounts.funding_sources.deposit_account_key = deposit_accounts.encoded_key loan_accounts.guarantors.deposit_account_key = deposit_accounts.encoded_key
communications	loan_accounts.custom_fields.field_set_id = communications.custom_fields.field_set_id loan_accounts.custom_fields.id = communications.custom_fields.id loan_accounts.disbursement_details.transaction_details.target_deposit_account_key = communications.deposit_account_key loan_accounts.funding_sources.deposit_account_key = communications.deposit_account_key loan_accounts.guarantors.deposit_account_key = communications.deposit_account_key loan_accounts.encoded_key = communications.loan_account_key loan_accounts.assigned_user_key = communications.user_key loan_accounts.assigned_user_key = communications.sender_key
custom_field_sets	loan_accounts.custom_fields.field_set_id = custom_field_sets.id loan_accounts.custom_fields.id = custom_field_sets.custom_fields.id
deposit_products	loan_accounts.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id loan_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field.id loan_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products	loan_accounts.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id loan_accounts.custom_fields.id = loan_products.custom_field_values.custom_field.id loan_accounts.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks	loan_accounts.custom_fields.field_set_id = tasks.custom_fields.field_set_id loan_accounts.custom_fields.id = tasks.custom_fields.id loan_accounts.assigned_user_key = tasks.created_by_user_key loan_accounts.assigned_user_key = tasks.assigned_user_key
activities	loan_accounts.assigned_user_key = activities.user_key
gl_journal_entries	loan_accounts.assigned_user_key = gl_journal_entries.user_key

loan_accounts table schema

account_arrears_settings

OBJECT

Click to expand account_arrears_settings

date_calculation_method

STRING

encoded_key

STRING

monthly_tolerance_day

INTEGER

non_working_days_method

STRING

tolerance_calculation_method

STRING

tolerance_period

INTEGER

account_holder_key

STRING

account_holder_type

STRING

account_state

STRING

account_sub_state

STRING

accrued_interest

NUMBER

accrued_penalty

NUMBER

activation_transaction_key

STRING

allow_offset

BOOLEAN

approved_date

DATE-TIME

arrears_tolerance_period

INTEGER

assets

ARRAY

Click to expand assets

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

assigned_branch_key

STRING

assigned_centre_key

STRING

assigned_user_key

STRING

balances

OBJECT

Click to expand balances

fees_balance

NUMBER

fees_due

NUMBER

fees_paid

NUMBER

interest_balance

NUMBER

interest_due

NUMBER

interest_from_arrears_balance

NUMBER

interest_from_arrears_due

NUMBER

interest_from_arrears_paid

NUMBER

interest_paid

NUMBER

penalty_balance

NUMBER

penalty_due

NUMBER

penalty_paid

NUMBER

principal_balance

NUMBER

principal_due

NUMBER

principal_paid

NUMBER

redraw_balance

NUMBER

closed_date

DATE-TIME

creation_date

DATE-TIME

credit_arrangement_key

STRING

currency

OBJECT

Click to expand currency

code

STRING

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

days_in_arrears

INTEGER

days_late

INTEGER

disbursement_details

OBJECT

Click to expand disbursement_details

disbursement_date

DATE-TIME

encoded_key

STRING

expected_disbursement_date

DATE-TIME

fees

ARRAY

Click to expand fees

amount

NUMBER

encoded_key

STRING

predefined_fee_encoded_key

STRING

first_repayment_date

DATE-TIME

transaction_details

OBJECT

Click to expand transaction_details

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

Click to expand funding_sources

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

interest_commission

NUMBER

share_percentage

NUMBER

future_payments_acceptance

STRING

guarantors

ARRAY

Click to expand guarantors

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

interest_commission

NUMBER

interest_from_arrears_accrued

NUMBER

interest_settings

OBJECT

Click to expand interest_settings

accrue_interest_after_maturity

BOOLEAN

interest_application_method

STRING

interest_balance_calculation_method

STRING

interest_calculation_method

STRING

interest_charge_frequency

STRING

interest_rate

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_spread

NUMBER

interest_type

STRING

last_account_appraisal_date

DATE-TIME

last_appraisal_date

DATE-TIME

last_interest_applied_date

DATE-TIME

last_interest_review_date

DATE-TIME

last_locked_date

DATE-TIME

last_modified_date

DATE-TIME

last_set_to_arrears_date

DATE-TIME

last_tax_rate_review_date

DATE-TIME

late_payments_recalculation_method

STRING

loan_amount

NUMBER

loan_name

STRING

locked_operations

ARRAY

migration_event_key

STRING

notes

STRING

original_account_key

STRING

payment_method

STRING

penalty_settings

OBJECT

Click to expand penalty_settings

loan_penalty_calculation_method

STRING

penalty_rate

NUMBER

prepayment_settings

OBJECT

Click to expand prepayment_settings

apply_interest_on_prepayment_method

STRING

elements_recalculation_method

STRING

prepayment_recalculation_method

STRING

principal-paid_installment_status

STRING

principal_payment_settings

OBJECT

Click to expand principal_payment_settings

amount

NUMBER

encoded_key

STRING

include_fees_in_floor_amount

BOOLEAN

include_interest_in_floor_amount

BOOLEAN

percentage

NUMBER

principal_ceiling_value

NUMBER

principal_floor_value

NUMBER

principal_payment_method

STRING

total_due_amount_floor

NUMBER

total_due_payment

STRING

product_type_key

STRING

rescheduled_account_key

STRING

schedule_settings

OBJECT

Click to expand schedule_settings

default_first_repayment_due_date_offset

INTEGER

fixed_days_of_month

ARRAY

grace_period

INTEGER

grace_period_type

STRING

has_custom_schedule

BOOLEAN

payment_plan

ARRAY

Click to expand payment_plan

amount

NUMBER

encoded_key

STRING

to_installment

INTEGER

periodic_payment

NUMBER

principal_repayment_interval

INTEGER

repayment_installments

INTEGER

repayment_period_count

INTEGER

repayment_period_unit

STRING

repayment_schedule_method

STRING

schedule_due_dates_method

STRING

short_month_handling_method

STRING

settlement_account_key

STRING

tax_rate

NUMBER

tranches

ARRAY

Click to expand tranches

amount

NUMBER

disbursement_details

OBJECT

Click to expand disbursement_details

disbursement_transaction_key

STRING

expected_disbursement_date

DATE-TIME

encoded_key

STRING

tranch_number

STRING

loan_products

This table contains information about loan products.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation loan_products schema on GitHub Mambu API method

loan_products table foreign keys

Join loan_products with	on
branches	loan_products.custom_field_values.custom_field.custom_field_set.id = branches.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = branches.custom_fields.id loan_products.custom_field_values.custom_field_id = branches.custom_fields.id
centres	loan_products.custom_field_values.custom_field.custom_field_set.id = centres.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = centres.custom_fields.id loan_products.custom_field_values.custom_field_id = centres.custom_fields.id
clients	loan_products.custom_field_values.custom_field.custom_field_set.id = clients.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = clients.custom_fields.id loan_products.custom_field_values.custom_field_id = clients.custom_fields.id
communications	loan_products.custom_field_values.custom_field.custom_field_set.id = communications.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = communications.custom_fields.id loan_products.custom_field_values.custom_field_id = communications.custom_fields.id
credit_arrangements	loan_products.custom_field_values.custom_field.custom_field_set.id = credit_arrangements.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = credit_arrangements.custom_fields.id loan_products.custom_field_values.custom_field_id = credit_arrangements.custom_fields.id
custom_field_sets	loan_products.custom_field_values.custom_field.custom_field_set.id = custom_field_sets.id loan_products.custom_field_values.custom_field.id = custom_field_sets.custom_fields.id loan_products.custom_field_values.custom_field_id = custom_field_sets.custom_fields.id
deposit_accounts	loan_products.custom_field_values.custom_field.custom_field_set.id = deposit_accounts.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = deposit_accounts.custom_fields.id loan_products.custom_field_values.custom_field_id = deposit_accounts.custom_fields.id
deposit_products	loan_products.custom_field_values.custom_field.custom_field_set.id = deposit_products.custom_field_values.custom_field.custom_field_set.id loan_products.custom_field_values.custom_field.id = deposit_products.custom_field_values.custom_field.id loan_products.custom_field_values.custom_field_id = deposit_products.custom_field_values.custom_field.id loan_products.custom_field_values.custom_field.id = deposit_products.custom_field_values.custom_field_id loan_products.custom_field_values.custom_field_id = deposit_products.custom_field_values.custom_field_id
deposit_transactions	loan_products.custom_field_values.custom_field.custom_field_set.id = deposit_transactions.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = deposit_transactions.custom_fields.id loan_products.custom_field_values.custom_field_id = deposit_transactions.custom_fields.id
groups	loan_products.custom_field_values.custom_field.custom_field_set.id = groups.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = groups.custom_fields.id loan_products.custom_field_values.custom_field_id = groups.custom_fields.id
loan_accounts	loan_products.custom_field_values.custom_field.custom_field_set.id = loan_accounts.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = loan_accounts.custom_fields.id loan_products.custom_field_values.custom_field_id = loan_accounts.custom_fields.id
loan_transactions	loan_products.custom_field_values.custom_field.custom_field_set.id = loan_transactions.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = loan_transactions.custom_fields.id loan_products.custom_field_values.custom_field_id = loan_transactions.custom_fields.id
tasks	loan_products.custom_field_values.custom_field.custom_field_set.id = tasks.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = tasks.custom_fields.id loan_products.custom_field_values.custom_field_id = tasks.custom_fields.id
users	loan_products.custom_field_values.custom_field.custom_field_set.id = users.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = users.custom_fields.id loan_products.custom_field_values.custom_field_id = users.custom_fields.id

loan_products table schema

account_initial_state

STRING

account_linking_enabled

BOOLEAN

accounting_method

STRING

activated

BOOLEAN

allow_arbitrary_fees

BOOLEAN

allow_collateral

BOOLEAN

allow_guarantors

BOOLEAN

amortization_method

STRING

apply_interest_on_prepayment_method

STRING

arrears_date_calculation_method

STRING

arrears_non_working_days_method

STRING

arrears_tolerance_period

INTEGER

auto_create_linked_accounts

BOOLEAN

auto_link_accounts

BOOLEAN

automatically_close_dormant_accounts

BOOLEAN

creation_date

DATE-TIME

custom_field_values

ARRAY

Click to expand custom_field_values

amount

STRING

custom_field

OBJECT

Click to expand custom_field

amounts

OBJECT

custom_field_selection_options

ARRAY

Click to expand custom_field_selection_options

encoded_key

STRING

score

STRING

value

STRING

custom_field_set

OBJECT

Click to expand custom_field_set

creation_date

DATE-TIME

encoded_key

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

type

STRING

usage

STRING

data_type

STRING

edit_rights

OBJECT

Click to expand edit_rights

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

Click to expand view_rights

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

custom_field_id

STRING

custom_field_key

STRING

custom_field_set_group_index

INTEGER

encoded_key

STRING

index_in_list

INTEGER

parent_key

STRING

value

STRING

days_in_year

STRING

declining_balance_prepayment_recalculation

STRING

default_loan_amount

STRING

default_num_installments

INTEGER

default_principal_repayment_interval

INTEGER

default_repayment_period_count

INTEGER

encoded_key

STRING

for_hybrid_groups

BOOLEAN

for_individuals

BOOLEAN

for_pure_groups

BOOLEAN

future_payments_acceptance

STRING

grace_period_type

STRING

id_generator_type

STRING

id_pattern

STRING

interest_accrued_accounting_method

STRING

interest_application_method

STRING

interest_balance_calculation_method

STRING

interest_calculation_method

STRING

interest_charge_frequency

STRING

interest_rate_settings

OBJECT

Click to expand interest_rate_settings

default_interest_rate

STRING

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

is_investor_funds_enabled

BOOLEAN

last_modified_date

DATE-TIME

late_payments_recalculation_method

STRING

line_of_credit_requirement

STRING

loan_fees

ARRAY

Click to expand loan_fees

active

BOOLEAN

amoritization_profile

STRING

amortization_interval_settings

OBJECT

Click to expand amortization_interval_settings

encoded_key

STRING

frequency

STRING

interval_count

INTEGER

period_count

INTEGER

period_unit

STRING

amount

STRING

amount_calculation_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

fee_product_rules

ARRAY

name

STRING

trigger

STRING

loan_penalty_calculation_method

STRING

loan_product_rules

ARRAY

loan_product_type

STRING

loan_type

STRING

max_number_of_disbursement_tranches

INTEGER

payment_method

STRING

prepayment_acceptance

STRING

product_description

STRING

product_name

STRING

product_security_settings

OBJECT

Click to expand product_security_settings

encoded_key

STRING

is_collateral_enabled

BOOLEAN

is_guarantors_enabled

BOOLEAN

is_investor_funds_enabled

BOOLEAN

required_guaranties

STRING

repayment_allocation_order

ARRAY

repayment_currency_rounding

STRING

repayment_elements_rounding_method

STRING

repayment_period_unit

STRING

repayment_rescheduling_method

STRING

repayment_schedule_edit_options

ARRAY

repayment_schedule_method

STRING

required_guaranty_percentage

STRING

rounding_repayment_schedule_method

STRING

schedule_due_dates_method

STRING

schedule_interest_days_count_method

STRING

settlement_options

STRING

taxes_on_fees_enabled

BOOLEAN

taxes_on_interest_enabled

BOOLEAN

taxes_on_penalty_enabled

BOOLEAN

templates

ARRAY

Click to expand templates

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

loan_products

This table contains information about loan products.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation loan_products schema on GitHub Mambu API method

loan_products table foreign keys

Join loan_products with	on
branches	loan_products.custom_field_values.custom_field.custom_field_set.id = branches.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = branches.custom_fields.id loan_products.custom_field_values.custom_field_id = branches.custom_fields.id
centres	loan_products.custom_field_values.custom_field.custom_field_set.id = centres.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = centres.custom_fields.id loan_products.custom_field_values.custom_field_id = centres.custom_fields.id
clients	loan_products.custom_field_values.custom_field.custom_field_set.id = clients.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = clients.custom_fields.id loan_products.custom_field_values.custom_field_id = clients.custom_fields.id
communications	loan_products.custom_field_values.custom_field.custom_field_set.id = communications.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = communications.custom_fields.id loan_products.custom_field_values.custom_field_id = communications.custom_fields.id
credit_arrangements	loan_products.custom_field_values.custom_field.custom_field_set.id = credit_arrangements.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = credit_arrangements.custom_fields.id loan_products.custom_field_values.custom_field_id = credit_arrangements.custom_fields.id
custom_field_sets	loan_products.custom_field_values.custom_field.custom_field_set.id = custom_field_sets.id loan_products.custom_field_values.custom_field.id = custom_field_sets.custom_fields.id loan_products.custom_field_values.custom_field_id = custom_field_sets.custom_fields.id
deposit_accounts	loan_products.custom_field_values.custom_field.custom_field_set.id = deposit_accounts.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = deposit_accounts.custom_fields.id loan_products.custom_field_values.custom_field_id = deposit_accounts.custom_fields.id
deposit_products	loan_products.custom_field_values.custom_field.custom_field_set.id = deposit_products.custom_field_values.custom_field.custom_field_set.id loan_products.custom_field_values.custom_field.id = deposit_products.custom_field_values.custom_field.id loan_products.custom_field_values.custom_field_id = deposit_products.custom_field_values.custom_field.id loan_products.custom_field_values.custom_field.id = deposit_products.custom_field_values.custom_field_id loan_products.custom_field_values.custom_field_id = deposit_products.custom_field_values.custom_field_id
deposit_transactions	loan_products.custom_field_values.custom_field.custom_field_set.id = deposit_transactions.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = deposit_transactions.custom_fields.id loan_products.custom_field_values.custom_field_id = deposit_transactions.custom_fields.id
groups	loan_products.custom_field_values.custom_field.custom_field_set.id = groups.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = groups.custom_fields.id loan_products.custom_field_values.custom_field_id = groups.custom_fields.id
loan_accounts	loan_products.custom_field_values.custom_field.custom_field_set.id = loan_accounts.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = loan_accounts.custom_fields.id loan_products.custom_field_values.custom_field_id = loan_accounts.custom_fields.id
loan_transactions	loan_products.custom_field_values.custom_field.custom_field_set.id = loan_transactions.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = loan_transactions.custom_fields.id loan_products.custom_field_values.custom_field_id = loan_transactions.custom_fields.id
tasks	loan_products.custom_field_values.custom_field.custom_field_set.id = tasks.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = tasks.custom_fields.id loan_products.custom_field_values.custom_field_id = tasks.custom_fields.id
users	loan_products.custom_field_values.custom_field.custom_field_set.id = users.custom_fields.field_set_id loan_products.custom_field_values.custom_field.id = users.custom_fields.id loan_products.custom_field_values.custom_field_id = users.custom_fields.id

loan_products table schema

account_initial_state

STRING

account_linking_enabled

BOOLEAN

accounting_method

STRING

activated

BOOLEAN

allow_arbitrary_fees

BOOLEAN

allow_collateral

BOOLEAN

allow_guarantors

BOOLEAN

amortization_method

STRING

apply_interest_on_prepayment_method

STRING

arrears_date_calculation_method

STRING

arrears_non_working_days_method

STRING

arrears_tolerance_period

INTEGER

auto_create_linked_accounts

BOOLEAN

auto_link_accounts

BOOLEAN

automatically_close_dormant_accounts

BOOLEAN

creation_date

DATE-TIME

custom_field_values

ARRAY

Click to expand custom_field_values

amount

STRING

custom_field

OBJECT

Click to expand custom_field

amounts

OBJECT

custom_field_selection_options

ARRAY

Click to expand custom_field_selection_options

encoded_key

STRING

score

STRING

value

STRING

custom_field_set

OBJECT

Click to expand custom_field_set

creation_date

DATE-TIME

encoded_key

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

type

STRING

usage

STRING

data_type

STRING

edit_rights

OBJECT

Click to expand edit_rights

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

Click to expand view_rights

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

custom_field_id

STRING

custom_field_key

STRING

custom_field_set_group_index

INTEGER

encoded_key

STRING

index_in_list

INTEGER

parent_key

STRING

value

STRING

days_in_year

STRING

declining_balance_prepayment_recalculation

STRING

default_loan_amount

STRING

default_num_installments

INTEGER

default_principal_repayment_interval

INTEGER

default_repayment_period_count

INTEGER

encoded_key

STRING

for_hybrid_groups

BOOLEAN

for_individuals

BOOLEAN

for_pure_groups

BOOLEAN

future_payments_acceptance

STRING

grace_period_type

STRING

id_generator_type

STRING

id_pattern

STRING

interest_accrued_accounting_method

STRING

interest_application_method

STRING

interest_balance_calculation_method

STRING

interest_calculation_method

STRING

interest_charge_frequency

STRING

interest_rate_settings

OBJECT

Click to expand interest_rate_settings

default_interest_rate

STRING

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

is_investor_funds_enabled

BOOLEAN

last_modified_date

DATE-TIME

late_payments_recalculation_method

STRING

line_of_credit_requirement

STRING

loan_fees

ARRAY

Click to expand loan_fees

active

BOOLEAN

amoritization_profile

STRING

amortization_interval_settings

OBJECT

Click to expand amortization_interval_settings

encoded_key

STRING

frequency

STRING

interval_count

INTEGER

period_count

INTEGER

period_unit

STRING

amount

STRING

amount_calculation_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

fee_product_rules

ARRAY

name

STRING

trigger

STRING

loan_penalty_calculation_method

STRING

loan_product_rules

ARRAY

loan_product_type

STRING

loan_type

STRING

max_number_of_disbursement_tranches

INTEGER

payment_method

STRING

prepayment_acceptance

STRING

product_description

STRING

product_name

STRING

product_security_settings

OBJECT

Click to expand product_security_settings

encoded_key

STRING

is_collateral_enabled

BOOLEAN

is_guarantors_enabled

BOOLEAN

is_investor_funds_enabled

BOOLEAN

required_guaranties

STRING

repayment_allocation_order

ARRAY

repayment_currency_rounding

STRING

repayment_elements_rounding_method

STRING

repayment_period_unit

STRING

repayment_rescheduling_method

STRING

repayment_schedule_edit_options

ARRAY

repayment_schedule_method

STRING

required_guaranty_percentage

STRING

rounding_repayment_schedule_method

STRING

schedule_due_dates_method

STRING

schedule_interest_days_count_method

STRING

settlement_options

STRING

taxes_on_fees_enabled

BOOLEAN

taxes_on_interest_enabled

BOOLEAN

taxes_on_penalty_enabled

BOOLEAN

templates

ARRAY

Click to expand templates

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

loan_repayments

This is a child table of loan_accounts, containing information exclusively about loan repayments.

Note: In order to replicate this table, you must also set the loan_account table to replicate.

Replication Method	Full Table
Primary Key	encoded_key
	loan_account
Useful links	loan_repayments schema on GitHub Mambu API method

loan_repayments table schema

due_date

DATE-TIME

encoded_key

STRING

fees_due

NUMBER

fees_paid

NUMBER

interest_due

NUMBER

interest_paid

NUMBER

parent_account_key

STRING

penalty_due

NUMBER

penalty_paid

NUMBER

principal_due

NUMBER

principal_paid

NUMBER

state

STRING

tax_fees_due

NUMBER

tax_fees_paid

NUMBER

tax_interest_due

NUMBER

tax_interest_paid

NUMBER

tax_penalty_due

NUMBER

tax_penalty_paid

NUMBER

loan_transactions

This table contains information about loan transactions.

Replication Method	Key-based Incremental
Primary Key	encoded_key
Replication Key	creation_date
Useful links	Mambu documentation loan_transactions schema on GitHub Mambu API method

loan_transactions table foreign keys

Join loan_transactions with	on
branches	loan_transactions.branch_key = branches.encoded_key loan_transactions.custom_fields.field_set_id = branches.custom_fields.field_set_id loan_transactions.custom_fields.id = branches.custom_fields.id
centres	loan_transactions.branch_key = centres.assigned_branch_key loan_transactions.centre_key = centres.encoded_key loan_transactions.custom_fields.field_set_id = centres.custom_fields.field_set_id loan_transactions.custom_fields.id = centres.custom_fields.id
deposit_transactions	loan_transactions.branch_key = deposit_transactions.branch_key loan_transactions.centre_key = deposit_transactions.centre_key loan_transactions.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id loan_transactions.custom_fields.id = deposit_transactions.custom_fields.id loan_transactions.transfer_details.linked_deposit_transaction_key = deposit_transactions.transfer_details.linked_deposit_transaction_key loan_transactions.encoded_key = deposit_transactions.linked_loan_transaction_key loan_transactions.linked_loan_transaction_key = deposit_transactions.linked_loan_transaction_key loan_transactions.parent_loan_transaction_key = deposit_transactions.linked_loan_transaction_key loan_transactions.transfer_details.linked_loan_transaction_key = deposit_transactions.linked_loan_transaction_key loan_transactions.encoded_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.linked_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.parent_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.transfer_details.linked_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.user_key = deposit_transactions.user_key
groups	loan_transactions.branch_key = groups.assigned_branch_key loan_transactions.centre_key = groups.assigned_centre_key loan_transactions.custom_fields.field_set_id = groups.custom_fields.field_set_id loan_transactions.custom_fields.id = groups.custom_fields.id loan_transactions.user_key = groups.assigned_user_key
loan_accounts	loan_transactions.branch_key = loan_accounts.assigned_branch_key loan_transactions.centre_key = loan_accounts.assigned_centre_key loan_transactions.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id loan_transactions.custom_fields.id = loan_accounts.custom_fields.id loan_transactions.user_key = loan_accounts.assigned_user_key
users	loan_transactions.branch_key = users.access.managed_branches.branch_key loan_transactions.custom_fields.field_set_id = users.custom_fields.field_set_id loan_transactions.custom_fields.id = users.custom_fields.id loan_transactions.user_key = users.encoded_key
clients	loan_transactions.centre_key = clients.assigned_centre_key loan_transactions.custom_fields.field_set_id = clients.custom_fields.field_set_id loan_transactions.custom_fields.id = clients.custom_fields.id loan_transactions.user_key = clients.assigned_user_key
communications	loan_transactions.custom_fields.field_set_id = communications.custom_fields.field_set_id loan_transactions.custom_fields.id = communications.custom_fields.id loan_transactions.user_key = communications.user_key loan_transactions.user_key = communications.sender_key
credit_arrangements	loan_transactions.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id loan_transactions.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets	loan_transactions.custom_fields.field_set_id = custom_field_sets.id loan_transactions.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts	loan_transactions.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id loan_transactions.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products	loan_transactions.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id loan_transactions.custom_fields.id = deposit_products.custom_field_values.custom_field.id loan_transactions.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products	loan_transactions.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id loan_transactions.custom_fields.id = loan_products.custom_field_values.custom_field.id loan_transactions.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks	loan_transactions.custom_fields.field_set_id = tasks.custom_fields.field_set_id loan_transactions.custom_fields.id = tasks.custom_fields.id loan_transactions.user_key = tasks.created_by_user_key loan_transactions.user_key = tasks.assigned_user_key
activities	loan_transactions.user_key = activities.user_key
gl_journal_entries	loan_transactions.user_key = gl_journal_entries.user_key

loan_transactions table schema

account_balances

OBJECT

Click to expand account_balances

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

Click to expand affected_amounts

deferred_interest_amount

NUMBER

fees_amount

NUMBER

fraction_amount

NUMBER

funders_interest_amount

NUMBER

funds_amount

NUMBER

interest_amount

NUMBER

interest_from_arrears_amount

NUMBER

organization_commission_amount

NUMBER

overdraft_amount

NUMBER

overdraft_fees_amount

NUMBER

overdraft_interest_amount

NUMBER

payment_holidays_interest_amount

NUMBER

penalty_amount

NUMBER

principal_amount

NUMBER

technical_overdraft_amount

NUMBER

technical_overdraft_interest_amount

NUMBER

amount

NUMBER

booking_date

DATE-TIME

branch_key

STRING

card_transaction

OBJECT

Click to expand card_transaction

advice

BOOLEAN

amount

NUMBER

card_acceptor

OBJECT

Click to expand card_acceptor

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

Click to expand currency

code

STRING

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

custom_payment_amounts

ARRAY

Click to expand custom_payment_amounts

amount

NUMBER

custom_payment_amount_type

STRING

predefined_fee_key

STRING

tax_on_amount

NUMBER

encoded_key

STRING

external_id

STRING

fees

ARRAY

Click to expand fees

amount

NUMBER

name

STRING

predefined_fee_key

STRING

tax_amount

NUMBER

trigger

STRING

installment_encoded_key

STRING

linked_loan_transaction_key

STRING

migration_event_key

STRING

notes

STRING

original_amount

NUMBER

original_currency_code

STRING

original_transaction_key

STRING

parent_account_key

STRING

parent_loan_transaction_key

STRING

prepayment_recalculation_method

STRING

taxes

OBJECT

Click to expand taxes

deferred_tax_on_interest_amount

NUMBER

tax_interest_from_arrears_amount

NUMBER

tax_on_fees_amount

NUMBER

tax_on_interest_amount

NUMBER

tax_on_interest_from_arrears_amount

NUMBER

tax_on_payment_holidays_interest

NUMBER

tax_on_penalty_amount

NUMBER

tax_rate

NUMBER

terms

OBJECT

Click to expand terms

interest_settings

OBJECT

Click to expand interest_settings

index_interest_rate

NUMBER

interest_rate

NUMBER

periodic_payment

NUMBER

principal_payment_amount

NUMBER

principal_payment_percentage

NUMBER

till_key

STRING

transaction_details

OBJECT

Click to expand transaction_details

transaction_channel_id

STRING

transaction_channel_key

STRING

transfer_details

OBJECT

Click to expand transfer_details

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	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation tasks schema on GitHub Mambu API method

tasks table foreign keys

Join tasks with	on
branches	tasks.custom_fields.field_set_id = branches.custom_fields.field_set_id tasks.custom_fields.id = branches.custom_fields.id
centres	tasks.custom_fields.field_set_id = centres.custom_fields.field_set_id tasks.custom_fields.id = centres.custom_fields.id
clients	tasks.custom_fields.field_set_id = clients.custom_fields.field_set_id tasks.custom_fields.id = clients.custom_fields.id tasks.created_by_user_key = clients.assigned_user_key tasks.assigned_user_key = clients.assigned_user_key
communications	tasks.custom_fields.field_set_id = communications.custom_fields.field_set_id tasks.custom_fields.id = communications.custom_fields.id tasks.created_by_user_key = communications.user_key tasks.assigned_user_key = communications.user_key tasks.created_by_user_key = communications.sender_key tasks.assigned_user_key = communications.sender_key
credit_arrangements	tasks.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id tasks.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets	tasks.custom_fields.field_set_id = custom_field_sets.id tasks.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts	tasks.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id tasks.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products	tasks.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id tasks.custom_fields.id = deposit_products.custom_field_values.custom_field.id tasks.custom_fields.id = deposit_products.custom_field_values.custom_field_id
deposit_transactions	tasks.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id tasks.custom_fields.id = deposit_transactions.custom_fields.id tasks.created_by_user_key = deposit_transactions.user_key tasks.assigned_user_key = deposit_transactions.user_key
groups	tasks.custom_fields.field_set_id = groups.custom_fields.field_set_id tasks.custom_fields.id = groups.custom_fields.id tasks.created_by_user_key = groups.assigned_user_key tasks.assigned_user_key = groups.assigned_user_key
loan_accounts	tasks.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id tasks.custom_fields.id = loan_accounts.custom_fields.id tasks.created_by_user_key = loan_accounts.assigned_user_key tasks.assigned_user_key = loan_accounts.assigned_user_key
loan_products	tasks.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id tasks.custom_fields.id = loan_products.custom_field_values.custom_field.id tasks.custom_fields.id = loan_products.custom_field_values.custom_field_id
loan_transactions	tasks.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id tasks.custom_fields.id = loan_transactions.custom_fields.id tasks.created_by_user_key = loan_transactions.user_key tasks.assigned_user_key = loan_transactions.user_key
users	tasks.custom_fields.field_set_id = users.custom_fields.field_set_id tasks.custom_fields.id = users.custom_fields.id tasks.created_by_user_key = users.encoded_key tasks.assigned_user_key = users.encoded_key
activities	tasks.created_by_user_key = activities.user_key tasks.assigned_user_key = activities.user_key
gl_journal_entries	tasks.created_by_user_key = gl_journal_entries.user_key tasks.assigned_user_key = gl_journal_entries.user_key

tasks table schema

assigned_user_key

STRING

created_by_full_name

STRING

created_by_user_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

description

STRING

due_date

DATE

encoded_key

STRING

last_modified_date

DATE-TIME

state

STRING

status

STRING

task_link

STRING

task_link_key

STRING

task_link_type

STRING

title

STRING

users

This table contains information about users.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	last_modified_date
Useful links	Mambu documentation users schema on GitHub Mambu API method

users table foreign keys

Join users with	on
branches	users.access.managed_branches.branch_key = branches.encoded_key users.custom_fields.field_set_id = branches.custom_fields.field_set_id users.custom_fields.id = branches.custom_fields.id
centres	users.access.managed_branches.branch_key = centres.assigned_branch_key users.custom_fields.field_set_id = centres.custom_fields.field_set_id users.custom_fields.id = centres.custom_fields.id
deposit_transactions	users.access.managed_branches.branch_key = deposit_transactions.branch_key users.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id users.custom_fields.id = deposit_transactions.custom_fields.id users.encoded_key = deposit_transactions.user_key
groups	users.access.managed_branches.branch_key = groups.assigned_branch_key users.custom_fields.field_set_id = groups.custom_fields.field_set_id users.custom_fields.id = groups.custom_fields.id users.encoded_key = groups.assigned_user_key
loan_accounts	users.access.managed_branches.branch_key = loan_accounts.assigned_branch_key users.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id users.custom_fields.id = loan_accounts.custom_fields.id users.encoded_key = loan_accounts.assigned_user_key
loan_transactions	users.access.managed_branches.branch_key = loan_transactions.branch_key users.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id users.custom_fields.id = loan_transactions.custom_fields.id users.encoded_key = loan_transactions.user_key
clients	users.custom_fields.field_set_id = clients.custom_fields.field_set_id users.custom_fields.id = clients.custom_fields.id users.encoded_key = clients.assigned_user_key
communications	users.custom_fields.field_set_id = communications.custom_fields.field_set_id users.custom_fields.id = communications.custom_fields.id users.encoded_key = communications.user_key users.encoded_key = communications.sender_key
credit_arrangements	users.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id users.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets	users.custom_fields.field_set_id = custom_field_sets.id users.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts	users.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id users.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products	users.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id users.custom_fields.id = deposit_products.custom_field_values.custom_field.id users.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products	users.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id users.custom_fields.id = loan_products.custom_field_values.custom_field.id users.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks	users.custom_fields.field_set_id = tasks.custom_fields.field_set_id users.custom_fields.id = tasks.custom_fields.id users.encoded_key = tasks.created_by_user_key users.encoded_key = tasks.assigned_user_key
activities	users.encoded_key = activities.user_key
gl_journal_entries	users.encoded_key = gl_journal_entries.user_key

users table schema

access

OBJECT

Click to expand access

administrator_access

BOOLEAN

api_access

BOOLEAN

can_manage_all_branches

BOOLEAN

can_manage_entities_assigned_to_other_officers

STRING

credit_officer_access

BOOLEAN

mambu_access

BOOLEAN

managed_branches

ARRAY

Click to expand managed_branches

branch_key

STRING

permissions

ARRAY

support_access

BOOLEAN

teller_access

BOOLEAN

assigned_branch_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

Click to expand custom_fields

field_set_id

STRING

value

STRING

email

STRING

encoded_key

STRING

first_name

STRING

home_phone

STRING

language

STRING

last_logged_in_date

DATE-TIME

last_modified_date

DATE-TIME

last_name

STRING

mobile_phone

STRING

notes

STRING

title

STRING

two_factor_authentication

BOOLEAN

user_state

STRING

username

STRING

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Third-Party Downtime Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues