Mambu (v4) | 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 (v4) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on February 23, 2023	Supported by	[Stitch] (https://community.qlik.com/t5/Support/ct-p/qlikSupport)
Stitch plan	Standard	API availability	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 4 of this integration.

This is the latest version of the Mambu 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

assigned_centre_key

STRING

assigned_user_key

STRING

branch_key

STRING

branch_name

STRING

centre_key

STRING

centre_name

STRING

client_key

STRING

client_name

STRING

encoded_key

STRING

field_changes

ARRAY

Click to expand field_changes

field_change_name

STRING

field_detail_key

STRING

field_detail_name

STRING

INTEGER

new_value

STRING

original_value

STRING

gl_account_key

STRING

gl_accounts_closure_key

STRING

group_key

STRING

group_name

STRING

line_of_credit_key

STRING

loan_account_key

STRING

loan_account_name

STRING

loan_product_key

STRING

loan_product_name

STRING

notes

STRING

savings_account_key

STRING

savings_account_name

STRING

savings_product_key

STRING

savings_product_name

STRING

task_key

STRING

task_name

STRING

timestamp

DATE-TIME

transaction_id

INTEGER

type

STRING

user_key

STRING

user_name

STRING

audit_trail

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

Replication Method

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
deposit_transactions	branches.encoded_key = deposit_transactions.branch_key
groups	branches.encoded_key = groups.assigned_branch_key
loan_accounts	branches.encoded_key = loan_accounts.assigned_branch_key
loan_transactions	branches.encoded_key = loan_transactions.branch_key
users	branches.encoded_key = users.access.managed_branches.branch_key

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

INTEGER

is_annually_recurring

BOOLEAN

name

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

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
deposit_transactions	centres.assigned_branch_key = deposit_transactions.branch_key centres.encoded_key = deposit_transactions.centre_key
groups	centres.assigned_branch_key = groups.assigned_branch_key centres.encoded_key = groups.assigned_centre_key
loan_accounts	centres.assigned_branch_key = loan_accounts.assigned_branch_key centres.encoded_key = loan_accounts.assigned_centre_key
loan_transactions	centres.assigned_branch_key = loan_transactions.branch_key centres.encoded_key = loan_transactions.centre_key
users	centres.assigned_branch_key = users.access.managed_branches.branch_key
clients	centres.encoded_key = clients.assigned_centre_key

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

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

Full Table

Primary Key

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
deposit_transactions	clients.assigned_centre_key = deposit_transactions.centre_key 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.assigned_user_key = groups.assigned_user_key
loan_accounts	clients.assigned_centre_key = loan_accounts.assigned_centre_key clients.assigned_user_key = loan_accounts.assigned_user_key
loan_transactions	clients.assigned_centre_key = loan_transactions.centre_key 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.assigned_user_key = communications.user_key clients.assigned_user_key = communications.sender_key
gl_journal_entries	clients.assigned_user_key = gl_journal_entries.user_key
tasks	clients.assigned_user_key = tasks.created_by_user_key clients.assigned_user_key = tasks.assigned_user_key
users	clients.assigned_user_key = users.encoded_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

email_address

STRING

encoded_key

STRING

first_name

STRING

gender

STRING

group_keys

ARRAY

group_loan_cycle

INTEGER

home_phone

STRING

id_documents

ARRAY

Click to expand id_documents

attachments

ARRAY

Click to expand attachments

creation_date

DATE-TIME

encoded_key

STRING

file_name

STRING

file_size

INTEGER

last_modified_date

DATE-TIME

location

STRING

name

STRING

notes

STRING

owner_key

STRING

owner_type

STRING

type

STRING

client_key

STRING

document_id

STRING

document_type

STRING

encoded_key

STRING

identification_document_template_key

STRING

index_in_list

INTEGER

issuing_authority

STRING

valid_until

DATE

last_modified_date

DATE-TIME

last_name

STRING

loan_cycle

INTEGER

middle_name

STRING

migration_event_key

STRING

mobile_phone

STRING

mobile_phone2

STRING

notes

STRING

portal_settings

OBJECT

Click to expand portal_settings

encoded_key

STRING

last_logged_in_date

DATE-TIME

portal_state

STRING

preferred_language

STRING

profile_picture_key

STRING

profile_signature_key

STRING

state

STRING

communications

This table contains information about communications.

Replication Method	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.user_key = clients.assigned_user_key communications.sender_key = clients.assigned_user_key
groups	communications.client_key = groups.group_members.client_key communications.group_key = groups.encoded_key communications.user_key = groups.assigned_user_key communications.sender_key = groups.assigned_user_key
deposit_accounts	communications.deposit_account_key = deposit_accounts.encoded_key
loan_accounts	communications.deposit_account_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key communications.deposit_account_key = loan_accounts.funding_sources.deposit_account_key communications.deposit_account_key = loan_accounts.guarantors.deposit_account_key communications.loan_account_key = loan_accounts.encoded_key communications.user_key = loan_accounts.assigned_user_key communications.sender_key = loan_accounts.assigned_user_key
deposit_transactions	communications.user_key = deposit_transactions.user_key communications.sender_key = deposit_transactions.user_key
gl_journal_entries	communications.user_key = gl_journal_entries.user_key communications.sender_key = gl_journal_entries.user_key
loan_transactions	communications.user_key = loan_transactions.user_key communications.sender_key = loan_transactions.user_key
tasks	communications.user_key = tasks.created_by_user_key communications.sender_key = tasks.created_by_user_key communications.user_key = tasks.assigned_user_key communications.sender_key = tasks.assigned_user_key
users	communications.user_key = users.encoded_key communications.sender_key = users.encoded_key

communications table schema

body

STRING

client_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

deposit_account_key

STRING

destination

STRING

encoded_key

STRING

event

STRING

failure_cause

STRING

failure_reason

STRING

group_key

STRING

loan_account_key

STRING

num_retries

INTEGER

reference_id

STRING

repayment_key

STRING

send_date

DATE-TIME

sender_key

STRING

state

STRING

subject

STRING

template_key

STRING

type

STRING

user_key

STRING

credit_arrangements

This table contains information about credit arrangements.

Replication Method	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
loan_accounts	credit_arrangements.encoded_key = loan_accounts.credit_arrangement_key

credit_arrangements table schema

amount

NUMBER

approved_date

DATE-TIME

available_credit_amount

NUMBER

closed_date

DATE-TIME

consumed_credit_amount

NUMBER

creation_date

DATE-TIME

currency

OBJECT

Click to expand currency

code

STRING

custom_fields

ARRAY

encoded_key

STRING

expire_date

DATE-TIME

exposure_limit_type

STRING

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 schema

available_for

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

dependent_field_key

STRING

display_settings

OBJECT

Click to expand display_settings

built_in_id

STRING

description

STRING

display_name

STRING

field_size

STRING

position

INTEGER

edit_rights

OBJECT

Click to expand edit_rights

all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

last_modified_date

DATE-TIME

selection_options

ARRAY

Click to expand selection_options

available_options

ARRAY

Click to expand available_options

score

NUMBER

selection_key

STRING

value

STRING

for_selection_key

STRING

for_value

STRING

state

STRING

type

STRING

usage

ARRAY

Click to expand usage

default

BOOLEAN

object_key

STRING

required

BOOLEAN

value_validation_settings

OBJECT

Click to expand value_validation_settings

unique

BOOLEAN

validation_pattern

STRING

view_rights

OBJECT

Click to expand view_rights

all_users

BOOLEAN

roles

ARRAY

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
loan_accounts	deposit_accounts.credit_arrangement_key = loan_accounts.credit_arrangement_key deposit_accounts.encoded_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key deposit_accounts.encoded_key = loan_accounts.funding_sources.deposit_account_key deposit_accounts.encoded_key = loan_accounts.guarantors.deposit_account_key
communications	deposit_accounts.encoded_key = communications.deposit_account_key

Join deposit_accounts with

credit_arrangements

deposit_accounts.credit_arrangement_key = credit_arrangements.encoded_key

loan_accounts

deposit_accounts.credit_arrangement_key = loan_accounts.credit_arrangement_key

deposit_accounts.encoded_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key

deposit_accounts.encoded_key = loan_accounts.funding_sources.deposit_account_key

deposit_accounts.encoded_key = loan_accounts.guarantors.deposit_account_key

communications

deposit_accounts.encoded_key = communications.deposit_account_key

deposit_accounts table schema

account_holder_key

STRING

account_holder_type

STRING

account_state

STRING

account_type

STRING

accrued_amounts

OBJECT

Click to expand accrued_amounts

interest_accrued

NUMBER

negative_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

blocked_balance

NUMBER

fees_due

NUMBER

forward_available_balance

NUMBER

hold_balance

NUMBER

locked_balance

NUMBER

overdraft_amount

NUMBER

overdraft_interest_due

NUMBER

technical_overdraft_amount

NUMBER

technical_overdraft_interest_due

NUMBER

total_balance

NUMBER

closed_date

DATE-TIME

creation_date

DATE-TIME

credit_arrangement_key

STRING

currency_code

STRING

custom_fields

ARRAY

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_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

internal_controls

OBJECT

Click to expand internal_controls

max_deposit_balance

NUMBER

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_set_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

allow_overdraft

BOOLEAN

overdraft_expiry_date

DATE-TIME

overdraft_limit

NUMBER

product_type_key

STRING

withholding_tax_source_key

STRING

deposit_products

This table contains information about deposit (savings) products.

Replication Method	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 schema

accounting_settings

OBJECT

Click to expand accounting_settings

accounting_method

STRING

accounting_rules

ARRAY

Click to expand accounting_rules

encoded_key

STRING

financial_resource

STRING

gl_account_key

STRING

interest_accrued_accounting_method

STRING

availability_settings

OBJECT

Click to expand availability_settings

available_for

ARRAY

branch_settings

OBJECT

Click to expand branch_settings

available_product_branches

ARRAY

for_all_branches

BOOLEAN

category

STRING

creation_date

DATE-TIME

credit_arrangement_settings

OBJECT

Click to expand credit_arrangement_settings

credit_arrangement_requirement

STRING

currency_settings

OBJECT

Click to expand currency_settings

currencies

ARRAY

Click to expand currencies

code

STRING

custom_fields

ARRAY

encoded_key

STRING

fees_settings

OBJECT

Click to expand fees_settings

allow_arbitrary_fees

BOOLEAN

fees

ARRAY

Click to expand fees

accounting_rules

ARRAY

Click to expand accounting_rules

encoded_key

STRING

financial_resource

STRING

gl_account_key

STRING

amount

NUMBER

amount_calculation_method

STRING

apply_date_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

last_modified_date

DATE-TIME

name

STRING

state

STRING

trigger

STRING

interest_settings

OBJECT

Click to expand interest_settings

collect_interest_when_locked

BOOLEAN

days_in_year

STRING

interest_calculation_balance

STRING

interest_paid_into_account

BOOLEAN

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

accrue_interest_after_maturity

BOOLEAN

allow_negative_interest_rate

BOOLEAN

encoded_key

STRING

index_source_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate

OBJECT

Click to expand interest_rate

default_value

NUMBER

max_value

NUMBER

min_value

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

Click to expand interest_rate_tiers

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

maximum_balance

NUMBER

internal_controls

OBJECT

Click to expand internal_controls

dormancy_period_days

INTEGER

max_withdrawal_amount

NUMBER

opening_balance

OBJECT

Click to expand opening_balance

default_value

NUMBER

max_value

NUMBER

min_value

NUMBER

recommended_deposit_amount

NUMBER

last_modified_date

DATE-TIME

maturity_settings

OBJECT

Click to expand maturity_settings

maturity_period

OBJECT

Click to expand maturity_period

default_value

INTEGER

max_value

INTEGER

min_value

INTEGER

maturity_period_unit

STRING

name

STRING

new_account_settings

OBJECT

Click to expand new_account_settings

id_generator_type

STRING

id_pattern

STRING

notes

STRING

offset_settings

OBJECT

Click to expand offset_settings

allow_offset

BOOLEAN

overdraft_interest_settings

OBJECT

Click to expand overdraft_interest_settings

days_in_year

STRING

interest_calculation_balance

STRING

interest_rate_settings

OBJECT

Click to expand interest_rate_settings

index_source_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate

OBJECT

Click to expand interest_rate

default_value

NUMBER

max_value

NUMBER

min_value

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

Click to expand interest_rate_tiers

encoded_key

STRING

ending_balance

NUMBER

interest_rate

NUMBER

overdraft_settings

OBJECT

Click to expand overdraft_settings

allow_overdraft

BOOLEAN

allow_technical_overdraft

BOOLEAN

max_overdraft_limit

NUMBER

state

STRING

tax_settings

OBJECT

Click to expand tax_settings

withholding_tax_enabled

BOOLEAN

templates

ARRAY

Click to expand templates

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

type

STRING

deposit_transactions

This table contains information about deposit transactions.

Replication Method	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
centres	deposit_transactions.branch_key = centres.assigned_branch_key deposit_transactions.centre_key = centres.encoded_key
groups	deposit_transactions.branch_key = groups.assigned_branch_key deposit_transactions.centre_key = groups.assigned_centre_key deposit_transactions.user_key = groups.assigned_user_key
loan_accounts	deposit_transactions.branch_key = loan_accounts.assigned_branch_key deposit_transactions.centre_key = loan_accounts.assigned_centre_key deposit_transactions.user_key = loan_accounts.assigned_user_key
loan_transactions	deposit_transactions.branch_key = loan_transactions.branch_key deposit_transactions.centre_key = loan_transactions.centre_key deposit_transactions.transfer_details.linked_deposit_transaction_key = loan_transactions.transfer_details.linked_deposit_transaction_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.encoded_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.parent_loan_transaction_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.transfer_details.linked_loan_transaction_key deposit_transactions.user_key = loan_transactions.user_key
users	deposit_transactions.branch_key = users.access.managed_branches.branch_key deposit_transactions.user_key = users.encoded_key
clients	deposit_transactions.centre_key = clients.assigned_centre_key deposit_transactions.user_key = clients.assigned_user_key
activities	deposit_transactions.user_key = activities.user_key
communications	deposit_transactions.user_key = communications.user_key deposit_transactions.user_key = communications.sender_key
gl_journal_entries	deposit_transactions.user_key = gl_journal_entries.user_key
tasks	deposit_transactions.user_key = tasks.created_by_user_key deposit_transactions.user_key = tasks.assigned_user_key

deposit_transactions table schema

account_balances

OBJECT

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

block_id

STRING

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_code

STRING

custom_fields

ARRAY

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

hold_external_reference_id

STRING

interest_accrued_amounts

OBJECT

Click to expand interest_accrued_amounts

interest_accrued

NUMBER

negative_interest_accrued

NUMBER

overdraft_interest_accrued

NUMBER

technical_overdraft_interest_accrued

NUMBER

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

payment_order_id

STRING

taxes

OBJECT

Click to expand taxes

tax_rate

NUMBER

terms

OBJECT

Click to expand terms

interest_settings

OBJECT

Click to expand interest_settings

index_interest_rate

NUMBER

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

custom_fields

ARRAY

description

STRING

encoded_key

STRING

gl_code

STRING

last_modified_date

DATE-TIME

migration_event_key

STRING

name

STRING

strip_trailing_zeros

BOOLEAN

type

STRING

usage

STRING

gl_journal_entries

This table contains information about general ledger entries.

Replication Method	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

assigned_branch_key

STRING

booking_date

DATE-TIME

creation_date

DATE-TIME

custom_fields

ARRAY

encoded_key

STRING

entry_id

INTEGER

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

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

description

STRING

encoded_key

STRING

gl_code

STRING

last_modified_date

DATE-TIME

migration_event_key

STRING

name

STRING

strip_trailing_zeros

BOOLEAN

type

STRING

usage

STRING

notes

STRING

product_key

STRING

product_type

STRING

reversal_entry_key

STRING

transaction_id

STRING

type

STRING

user_key

STRING

groups

This table contains information about groups.

Replication Method	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
centres	groups.assigned_branch_key = centres.assigned_branch_key groups.assigned_centre_key = centres.encoded_key
deposit_transactions	groups.assigned_branch_key = deposit_transactions.branch_key groups.assigned_centre_key = deposit_transactions.centre_key groups.assigned_user_key = deposit_transactions.user_key
loan_accounts	groups.assigned_branch_key = loan_accounts.assigned_branch_key groups.assigned_centre_key = loan_accounts.assigned_centre_key groups.assigned_user_key = loan_accounts.assigned_user_key
loan_transactions	groups.assigned_branch_key = loan_transactions.branch_key groups.assigned_centre_key = loan_transactions.centre_key groups.assigned_user_key = loan_transactions.user_key
users	groups.assigned_branch_key = users.access.managed_branches.branch_key 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.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.encoded_key = communications.group_key groups.assigned_user_key = communications.user_key groups.assigned_user_key = communications.sender_key
gl_journal_entries	groups.assigned_user_key = gl_journal_entries.user_key
tasks	groups.assigned_user_key = tasks.created_by_user_key groups.assigned_user_key = tasks.assigned_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

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

role_name_id

STRING

group_name

STRING

group_role_key

STRING

home_phone

STRING

last_modified_date

DATE-TIME

loan_cycle

INTEGER

migration_event_key

STRING

mobile_phone

STRING

notes

STRING

preferred_language

STRING

index_rate_sources

This table contains information about index rate sources.

Replication Method

Full Table

Primary Key

encoded_key

Useful links

index_rate_sources schema on GitHub

Mambu API method

index_rate_sources table schema

custom_fields

ARRAY

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

custom_fields

ARRAY

due_date

DATE-TIME

encoded_key

STRING

fee

OBJECT

Click to expand fee

amount

OBJECT

Click to expand amount

due

NUMBER

expected

NUMBER

expected_unapplied

NUMBER

paid

NUMBER

tax

OBJECT

Click to expand tax

due

NUMBER

expected

NUMBER

paid

NUMBER

fee_details

ARRAY

Click to expand fee_details

amount

OBJECT

Click to expand amount

due

NUMBER

expected

NUMBER

paid

NUMBER

reduced

NUMBER

encoded_key

STRING

name

STRING

tax

OBJECT

Click to expand tax

due

NUMBER

expected

NUMBER

paid

NUMBER

reduced

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

is_payment_holiday

BOOLEAN

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

custom_fields

ARRAY

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
centres	loan_accounts.assigned_branch_key = centres.assigned_branch_key loan_accounts.assigned_centre_key = centres.encoded_key
deposit_transactions	loan_accounts.assigned_branch_key = deposit_transactions.branch_key loan_accounts.assigned_centre_key = deposit_transactions.centre_key loan_accounts.assigned_user_key = deposit_transactions.user_key
groups	loan_accounts.assigned_branch_key = groups.assigned_branch_key loan_accounts.assigned_centre_key = groups.assigned_centre_key loan_accounts.assigned_user_key = groups.assigned_user_key
loan_transactions	loan_accounts.assigned_branch_key = loan_transactions.branch_key loan_accounts.assigned_centre_key = loan_transactions.centre_key loan_accounts.assigned_user_key = loan_transactions.user_key
users	loan_accounts.assigned_branch_key = users.access.managed_branches.branch_key loan_accounts.assigned_user_key = users.encoded_key
clients	loan_accounts.assigned_centre_key = clients.assigned_centre_key loan_accounts.assigned_user_key = clients.assigned_user_key
credit_arrangements	loan_accounts.credit_arrangement_key = credit_arrangements.encoded_key
deposit_accounts	loan_accounts.credit_arrangement_key = deposit_accounts.credit_arrangement_key loan_accounts.disbursement_details.transaction_details.target_deposit_account_key = deposit_accounts.encoded_key loan_accounts.funding_sources.deposit_account_key = deposit_accounts.encoded_key loan_accounts.guarantors.deposit_account_key = deposit_accounts.encoded_key
communications	loan_accounts.disbursement_details.transaction_details.target_deposit_account_key = communications.deposit_account_key loan_accounts.funding_sources.deposit_account_key = communications.deposit_account_key loan_accounts.guarantors.deposit_account_key = communications.deposit_account_key loan_accounts.encoded_key = communications.loan_account_key loan_accounts.assigned_user_key = communications.user_key loan_accounts.assigned_user_key = communications.sender_key
activities	loan_accounts.assigned_user_key = activities.user_key
gl_journal_entries	loan_accounts.assigned_user_key = gl_journal_entries.user_key
tasks	loan_accounts.assigned_user_key = tasks.created_by_user_key loan_accounts.assigned_user_key = tasks.assigned_user_key

loan_accounts table schema

account_arrears_settings

OBJECT

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_floor_amount

NUMBER

tolerance_percentage_of_outstanding_principal

NUMBER

tolerance_period

INTEGER

account_holder_key

STRING

account_holder_type

STRING

account_state

STRING

account_sub_state

STRING

accrued_interest

NUMBER

accrued_penalty

NUMBER

activation_transaction_key

STRING

allow_offset

BOOLEAN

approved_date

DATE-TIME

arrears_tolerance_period

INTEGER

assets

ARRAY

Click to expand assets

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

original_amount

NUMBER

original_currency

OBJECT

Click to expand original_currency

code

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

hold_balance

NUMBER

interest_balance

NUMBER

interest_due

NUMBER

interest_from_arrears_balance

NUMBER

interest_from_arrears_due

NUMBER

interest_from_arrears_paid

NUMBER

interest_paid

NUMBER

penalty_balance

NUMBER

penalty_due

NUMBER

penalty_paid

NUMBER

principal_balance

NUMBER

principal_due

NUMBER

principal_paid

NUMBER

redraw_balance

NUMBER

closed_date

DATE-TIME

creation_date

DATE-TIME

credit_arrangement_key

STRING

currency

OBJECT

Click to expand currency

code

STRING

custom_fields

ARRAY

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_accrued_in_billing_cycle

NUMBER

interest_commission

NUMBER

interest_from_arrears_accrued

NUMBER

interest_settings

OBJECT

Click to expand interest_settings

account_interest_rate_settings

ARRAY

Click to expand account_interest_rate_settings

encoded_key

STRING

index_source_key

STRING

interest_rate

NUMBER

interest_rate_ceiling_value

NUMBER

interest_rate_floor_value

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_spread

NUMBER

valid_from

DATE-TIME

accrue_interest_after_maturity

BOOLEAN

accrue_late_interest

BOOLEAN

interest_application_method

STRING

interest_balance_calculation_method

STRING

interest_calculation_method

STRING

interest_charge_frequency

STRING

interest_rate

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_spread

NUMBER

interest_type

STRING

last_account_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

modify_interest_for_first_installment

BOOLEAN

notes

STRING

original_account_key

STRING

payment_holidays_accrued_interest

NUMBER

payment_method

STRING

penalty_settings

OBJECT

Click to expand penalty_settings

loan_penalty_calculation_method

STRING

penalty_rate

NUMBER

planned_installment_fees

ARRAY

Click to expand planned_installment_fees

amount

NUMBER

apply_on_date

DATE-TIME

encoded_key

STRING

installment_key

STRING

installment_number

INTEGER

predefined_fee_key

STRING

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

redraw_settings

OBJECT

Click to expand redraw_settings

restrict_next_due_withdrawal

BOOLEAN

rescheduled_account_key

STRING

schedule_settings

OBJECT

Click to expand schedule_settings

billing_cycle

OBJECT

Click to expand billing_cycle

days

ARRAY

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

preview_schedule

OBJECT

Click to expand preview_schedule

number_of_previewed_instalments

INTEGER

principal_repayment_interval

INTEGER

repayment_installments

INTEGER

repayment_period_count

INTEGER

repayment_period_unit

STRING

repayment_schedule_method

STRING

schedule_due_dates_method

STRING

short_month_handling_method

STRING

settlement_account_key

STRING

tax_rate

NUMBER

termination_date

DATE-TIME

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

fees

ARRAY

Click to expand fees

amount

NUMBER

encoded_key

STRING

predefined_fee_encoded_key

STRING

tranche_number

INTEGER

loan_products

This table contains information about loan products.

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

loan_products table schema

account_link_settings

OBJECT

Click to expand account_link_settings

enabled

BOOLEAN

linkable_deposit_product_key

STRING

linked_account_options

ARRAY

settlement_method

STRING

accounting_settings

OBJECT

Click to expand accounting_settings

accounting_method

STRING

accounting_rules

ARRAY

Click to expand accounting_rules

encoded_key

STRING

financial_resource

STRING

gl_account_key

STRING

transaction_channel_key

STRING

interest_accrual_calculation

STRING

interest_accrued_accounting_method

STRING

adjust_interest_for_first_installment

BOOLEAN

allow_custom_repayment_allocation

BOOLEAN

arrears_settings

OBJECT

Click to expand arrears_settings

date_calculation_method

STRING

encoded_key

STRING

monthly_tolerance_day

INTEGER

non_working_days_method

STRING

tolerance_calculation_method

STRING

tolerance_floor_amount

NUMBER

tolerance_percentage_of_outstanding_principal

OBJECT

Click to expand tolerance_percentage_of_outstanding_principal

default_value

NUMBER

max_value

NUMBER

min_value

NUMBER

tolerance_period

OBJECT

Click to expand tolerance_period

default_value

INTEGER

encoded_key

STRING

max_value

INTEGER

min_value

INTEGER

availability_settings

OBJECT

Click to expand availability_settings

available_for

ARRAY

branch_settings

OBJECT

Click to expand branch_settings

available_product_branches

ARRAY

for_all_branches

BOOLEAN

category

STRING

creation_date

DATE-TIME

credit_arrangement_settings

OBJECT

Click to expand credit_arrangement_settings

credit_arrangement_requirement

STRING

currency

OBJECT

Click to expand currency

code

STRING

custom_fields

ARRAY

encoded_key

STRING

fees_settings

OBJECT

Click to expand fees_settings

allow_arbitrary_fees

BOOLEAN

fees

ARRAY

Click to expand fees

accounting_rules

ARRAY

Click to expand accounting_rules

encoded_key

STRING

financial_resource

STRING

gl_account_key

STRING

transaction_channel_key

STRING

amortization_settings

OBJECT

Click to expand amortization_settings

amortization_profile

STRING

encoded_key

STRING

fee_amortization_upon_reschedule_refinance_option

STRING

frequency

STRING

interval_count

INTEGER

interval_type

STRING

period_count

INTEGER

period_unit

STRING

amount

NUMBER

amount_calculation_method

STRING

apply_date_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

last_modified_date

DATE-TIME

name

STRING

percentage_amount

NUMBER

state

STRING

tax_settings

OBJECT

Click to expand tax_settings

taxable_calculation_method

STRING

trigger

STRING

funding_settings

OBJECT

Click to expand funding_settings

enabled

BOOLEAN

funder_interest_commission

OBJECT

Click to expand funder_interest_commission

default_value

NUMBER

encoded_key

STRING

max_value

NUMBER

min_value

NUMBER

funder_interest_commission_allocation_type

STRING

lock_funds_at_approval

BOOLEAN

organization_interest_commission

OBJECT

Click to expand organization_interest_commission

default_value

NUMBER

encoded_key

STRING

max_value

NUMBER

min_value

NUMBER

required_funds

NUMBER

grace_period_settings

OBJECT

Click to expand grace_period_settings

grace_period

OBJECT

Click to expand grace_period

default_value

INTEGER

encoded_key

STRING

max_value

INTEGER

min_value

INTEGER

grace_period_type

STRING

interest_settings

OBJECT

Click to expand interest_settings

accrue_late_interest

BOOLEAN

compounding_frequency

STRING

days_in_year

STRING

index_rate_settings

OBJECT

Click to expand index_rate_settings

accrue_interest_after_maturity

BOOLEAN

allow_negative_interest_rate

BOOLEAN

encoded_key

STRING

index_source_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate

OBJECT

Click to expand interest_rate

default_value

NUMBER

max_value

NUMBER

min_value

NUMBER

interest_rate_ceiling_value

NUMBER

interest_rate_floor_value

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

Click to expand interest_rate_tiers

encoded_key

STRING

ending_balance

NUMBER

interest_rate

NUMBER

interest_application_method

STRING

interest_balance_calculation_method

STRING

interest_calculation_method

STRING

interest_rate_settings

ARRAY

Click to expand interest_rate_settings

encoded_key

STRING

index_source_key

STRING

interest_rate

OBJECT

Click to expand interest_rate

default_value

NUMBER

max_value

NUMBER

min_value

NUMBER

interest_rate_ceiling_value

NUMBER

interest_rate_floor_value

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_type

STRING

schedule_interest_days_count_method

STRING

internal_controls

OBJECT

Click to expand internal_controls

dormancy_period_days

INTEGER

four_eyes_principle

OBJECT

Click to expand four_eyes_principle

active_for_loan_approval

BOOLEAN

lock_settings

OBJECT

Click to expand lock_settings

capping_constraint_type

STRING

capping_method

STRING

capping_percentage

NUMBER

lock_period_days

INTEGER

last_modified_date

DATE-TIME

loan_amount_settings

OBJECT

Click to expand loan_amount_settings

loan_amount

OBJECT

Click to expand loan_amount

default_value

NUMBER

encoded_key

STRING

max_value

NUMBER

min_value

NUMBER

tranche_settings

OBJECT

Click to expand tranche_settings

max_number_of_tranches

INTEGER

name

STRING

new_account_settings

OBJECT

Click to expand new_account_settings

account_initial_state

STRING

id_generator_type

STRING

id_pattern

STRING

notes

STRING

offset_settings

OBJECT

Click to expand offset_settings

allow_offset

BOOLEAN

payment_settings

OBJECT

Click to expand payment_settings

amortization_method

STRING

late_payments_recalculation_method

STRING

payment_method

STRING

prepayment_settings

OBJECT

Click to expand prepayment_settings

apply_interest_on_prepayment_method

STRING

elements_recalculation_method

STRING

future_payments_acceptance

STRING

prepayment_acceptance

STRING

prepayment_recalculation_method

STRING

principal_paid_installment_status

STRING

principal_payment_settings

OBJECT

Click to expand principal_payment_settings

amount

OBJECT

Click to expand amount

default_value

NUMBER

encoded_key

STRING

max_value

NUMBER

min_value

NUMBER

default_principal_repayment_interval

INTEGER

encoded_key

STRING

include_fees_in_floor_amount

BOOLEAN

include_interest_in_floor_amount

BOOLEAN

percentage

OBJECT

Click to expand percentage

default_value

NUMBER

encoded_key

STRING

max_value

NUMBER

min_value

NUMBER

principal_ceiling_value

NUMBER

principal_floor_value

NUMBER

principal_payment_method

STRING

total_due_amount_floor

NUMBER

total_due_payment

STRING

repayment_allocation_order

ARRAY

penalty_settings

OBJECT

Click to expand penalty_settings

loan_penalty_calculation_method

STRING

loan_penalty_grace_period

INTEGER

penalty_rate

OBJECT

Click to expand penalty_rate

default_value

NUMBER

encoded_key

STRING

max_value

NUMBER

min_value

NUMBER

redraw_settings

OBJECT

Click to expand redraw_settings

allow_redraw

BOOLEAN

schedule_settings

OBJECT

Click to expand schedule_settings

billing_cycles

OBJECT

Click to expand billing_cycles

enabled

BOOLEAN

start_days

ARRAY

default_repayment_period_count

INTEGER

first_repayment_due_date_offset

OBJECT

Click to expand first_repayment_due_date_offset

default_value

INTEGER

encoded_key

STRING

max_value

INTEGER

min_value

INTEGER

fixed_days_of_month

ARRAY

interest_accrual_since

STRING

num_installments

OBJECT

Click to expand num_installments

default_value

INTEGER

encoded_key

STRING

max_value

INTEGER

min_value

INTEGER

preview_schedule

OBJECT

Click to expand preview_schedule

number_of_previewed_instalments

INTEGER

preview_schedule_enabled

BOOLEAN

repayment_period_unit

STRING

repayment_rescheduling_method

STRING

repayment_schedule_edit_options

ARRAY

repayment_schedule_method

STRING

rounding_settings

OBJECT

Click to expand rounding_settings

repayment_currency_rounding

STRING

repayment_elements_rounding_method

STRING

rounding_repayment_schedule_method

STRING

schedule_due_dates_method

STRING

short_month_handling_method

STRING

security_settings

OBJECT

Click to expand security_settings

is_collateral_enabled

BOOLEAN

is_guarantors_enabled

BOOLEAN

required_guaranties

NUMBER

state

STRING

tax_settings

OBJECT

Click to expand tax_settings

tax_calculation_method

STRING

tax_source_key

STRING

taxes_on_fees_enabled

BOOLEAN

taxes_on_interest_enabled

BOOLEAN

taxes_on_penalty_enabled

BOOLEAN

templates

ARRAY

Click to expand templates

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

type

STRING

loan_repayments

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

Note: In order to replicate this table, you must also set the loan-account 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

assigned_branch_key

STRING

assigned_centre_key

STRING

assigned_user_key

STRING

custom_settings

ARRAY

Click to expand custom_settings

encoded_key

STRING

loan_transaction_key

STRING

source

STRING

type

STRING

due_date

DATE-TIME

encoded_key

STRING

fees_applied_due

NUMBER

fees_due

NUMBER

fees_paid

NUMBER

fees_unapplied_due

NUMBER

funders_interest_due

NUMBER

index

NUMBER

interest_due

NUMBER

interest_paid

NUMBER

last_paid_date

DATE-TIME

last_penalty_applied_date

DATE-TIME

notes

STRING

organization_commission_due

NUMBER

parent_account_key

STRING

penalty_due

NUMBER

penalty_paid

NUMBER

principal_due

NUMBER

principal_paid

NUMBER

repaid_date

DATE-TIME

repayment_unapplied_fee_details

ARRAY

Click to expand repayment_unapplied_fee_details

encoded_key

STRING

fee_due

NUMBER

index_in_list

NUMBER

predefined_fee_key

STRING

repayment_key

STRING

tax_on_fee_due

NUMBER

state

STRING

tax_fees_due

NUMBER

tax_fees_paid

NUMBER

tax_interest_due

NUMBER

tax_interest_paid

NUMBER

tax_penalty_due

NUMBER

tax_penalty_paid

NUMBER

loan_transactions

This table contains information about loan transactions.

Replication Method	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
centres	loan_transactions.branch_key = centres.assigned_branch_key loan_transactions.centre_key = centres.encoded_key
deposit_transactions	loan_transactions.branch_key = deposit_transactions.branch_key loan_transactions.centre_key = deposit_transactions.centre_key loan_transactions.transfer_details.linked_deposit_transaction_key = deposit_transactions.transfer_details.linked_deposit_transaction_key loan_transactions.encoded_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.parent_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.transfer_details.linked_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.user_key = deposit_transactions.user_key
groups	loan_transactions.branch_key = groups.assigned_branch_key loan_transactions.centre_key = groups.assigned_centre_key loan_transactions.user_key = groups.assigned_user_key
loan_accounts	loan_transactions.branch_key = loan_accounts.assigned_branch_key loan_transactions.centre_key = loan_accounts.assigned_centre_key loan_transactions.user_key = loan_accounts.assigned_user_key
users	loan_transactions.branch_key = users.access.managed_branches.branch_key loan_transactions.user_key = users.encoded_key
clients	loan_transactions.centre_key = clients.assigned_centre_key loan_transactions.user_key = clients.assigned_user_key
activities	loan_transactions.user_key = activities.user_key
communications	loan_transactions.user_key = communications.user_key loan_transactions.user_key = communications.sender_key
gl_journal_entries	loan_transactions.user_key = gl_journal_entries.user_key
tasks	loan_transactions.user_key = tasks.created_by_user_key loan_transactions.user_key = tasks.assigned_user_key

loan_transactions table schema

account_balances

OBJECT

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

funders_interest_amount

NUMBER

interest_amount

NUMBER

interest_from_arrears_amount

NUMBER

organization_commission_amount

NUMBER

payment_holidays_interest_amount

NUMBER

penalty_amount

NUMBER

principal_amount

NUMBER

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

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

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_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
activities	tasks.created_by_user_key = activities.user_key tasks.assigned_user_key = activities.user_key
clients	tasks.created_by_user_key = clients.assigned_user_key tasks.assigned_user_key = clients.assigned_user_key
communications	tasks.created_by_user_key = communications.user_key tasks.assigned_user_key = communications.user_key tasks.created_by_user_key = communications.sender_key tasks.assigned_user_key = communications.sender_key
deposit_transactions	tasks.created_by_user_key = deposit_transactions.user_key tasks.assigned_user_key = deposit_transactions.user_key
gl_journal_entries	tasks.created_by_user_key = gl_journal_entries.user_key tasks.assigned_user_key = gl_journal_entries.user_key
groups	tasks.created_by_user_key = groups.assigned_user_key tasks.assigned_user_key = groups.assigned_user_key
loan_accounts	tasks.created_by_user_key = loan_accounts.assigned_user_key tasks.assigned_user_key = loan_accounts.assigned_user_key
loan_transactions	tasks.created_by_user_key = loan_transactions.user_key tasks.assigned_user_key = loan_transactions.user_key
users	tasks.created_by_user_key = users.encoded_key tasks.assigned_user_key = users.encoded_key

tasks table schema

assigned_user_key

STRING

created_by_full_name

STRING

created_by_user_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

description

STRING

due_date

DATE

encoded_key

STRING

INTEGER

last_modified_date

DATE-TIME

status

STRING

task_link_key

STRING

task_link_type

STRING

template_key

STRING

title

STRING

users

This table contains information about users.

Replication Method	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
centres	users.access.managed_branches.branch_key = centres.assigned_branch_key
deposit_transactions	users.access.managed_branches.branch_key = deposit_transactions.branch_key users.encoded_key = deposit_transactions.user_key
groups	users.access.managed_branches.branch_key = groups.assigned_branch_key users.encoded_key = groups.assigned_user_key
loan_accounts	users.access.managed_branches.branch_key = loan_accounts.assigned_branch_key users.encoded_key = loan_accounts.assigned_user_key
loan_transactions	users.access.managed_branches.branch_key = loan_transactions.branch_key users.encoded_key = loan_transactions.user_key
activities	users.encoded_key = activities.user_key
clients	users.encoded_key = clients.assigned_user_key
communications	users.encoded_key = communications.user_key users.encoded_key = communications.sender_key
gl_journal_entries	users.encoded_key = gl_journal_entries.user_key
tasks	users.encoded_key = tasks.created_by_user_key users.encoded_key = tasks.assigned_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

BOOLEAN

credit_officer_access

BOOLEAN

delivery_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

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

role

OBJECT

Click to expand role

encoded_key

STRING

title

STRING

transaction_limits

OBJECT

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