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

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

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Mambu icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Mambu” would create a schema called stitch_mambu in the destination. Note: Schema names cannot be changed after you save the integration.

  5. In the Subdomain field, enter your Mambu subdomain. For example: If the subdomain were stitch.mambu.com, only stitch would be entered into this field.
  6. In the Username and Password fields, enter the username and password of the Mambu user with Mambu API access.

Step 2: Define the historical replication start date

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

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

Step 3: Create a replication schedule

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:

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

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:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

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

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

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.


Mambu table reference

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

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

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

field_change_name

STRING

field_detail_key

STRING

field_detail_name

STRING

id

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

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

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

addresses

ARRAY

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

creation_date

DATE-TIME

date

DATE

encoded_key

STRING

id

INTEGER

is_annually_recurring

BOOLEAN

name

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

email_address

STRING

encoded_key

STRING

id

STRING

last_modified_date

DATE-TIME

name

STRING

notes

STRING

phone_number

STRING

state

STRING

cards

This table contains information about cards.

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

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

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

addresses

ARRAY

city

STRING

country

STRING

encoded_key

STRING

index_in_list

INTEGER

latitude

NUMBER

line1

STRING

line2

STRING

longitude

NUMBER

parent_key

STRING

postcode

STRING

region

STRING

assigned_branch_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

encoded_key

STRING

id

STRING

last_modified_date

DATE-TIME

meeting_day

STRING

name

STRING

notes

STRING

state

STRING

clients

This table contains information about clients.

Replication Method

Full Table

Primary Key

id

Useful links

Mambu documentation

clients schema on GitHub

Mambu API method

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

activation_date

DATE-TIME

addresses

ARRAY

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

STRING

id_documents

ARRAY

attachments

ARRAY

creation_date

DATE-TIME

encoded_key

STRING

file_name

STRING

file_size

INTEGER

id

INTEGER

last_modified_date

DATE-TIME

location

STRING

name

STRING

notes

STRING

owner_key

STRING

owner_type

STRING

type

STRING

client_key

STRING

document_id

STRING

document_type

STRING

encoded_key

STRING

identification_document_template_key

STRING

index_in_list

INTEGER

issuing_authority

STRING

valid_until

DATE

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

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

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

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

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

amount

NUMBER

approved_date

DATE-TIME

available_credit_amount

NUMBER

closed_date

DATE-TIME

consumed_credit_amount

NUMBER

creation_date

DATE-TIME

currency

OBJECT

custom_fields

ARRAY

encoded_key

STRING

expire_date

DATE-TIME

exposure_limit_type

STRING

holder_key

STRING

holder_type

STRING

id

STRING

last_modified_date

DATE-TIME

notes

STRING

start_date

DATE-TIME

state

STRING

sub_state

STRING

custom_field_sets

This table contains information about custom field sets.

Replication Method

Full Table

Primary Key

id

Useful links

Mambu documentation

custom_field_sets schema on GitHub

Mambu API method

available_for

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

dependent_field_key

STRING

display_settings

OBJECT

built_in_id

STRING

description

STRING

display_name

STRING

field_size

STRING

position

INTEGER

edit_rights

OBJECT

all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

id

STRING

last_modified_date

DATE-TIME

selection_options

ARRAY

available_options

ARRAY

score

NUMBER

selection_key

STRING

value

STRING

for_selection_key

STRING

for_value

STRING

state

STRING

type

STRING

usage

ARRAY

default

BOOLEAN

object_key

STRING

required

BOOLEAN

value_validation_settings

OBJECT

unique

BOOLEAN

validation_pattern

STRING

view_rights

OBJECT

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

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

account_holder_key

STRING

account_holder_type

STRING

account_state

STRING

account_type

STRING

accrued_amounts

OBJECT

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

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

id

STRING

interest_settings

OBJECT

interest_payment_settings

OBJECT

interest_payment_dates

ARRAY

day

INTEGER

month

INTEGER

interest_payment_point

STRING

interest_rate_settings

OBJECT

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

interest_spread

NUMBER

internal_controls

OBJECT

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

interest_rate_settings

OBJECT

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

interest_spread

NUMBER

overdraft_settings

OBJECT

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

accounting_settings

OBJECT

accounting_method

STRING

accounting_rules

ARRAY

encoded_key

STRING

financial_resource

STRING

gl_account_key

STRING

interest_accrued_accounting_method

STRING

availability_settings

OBJECT

available_for

ARRAY

branch_settings

OBJECT

available_product_branches

ARRAY

for_all_branches

BOOLEAN

category

STRING

creation_date

DATE-TIME

credit_arrangement_settings

OBJECT

credit_arrangement_requirement

STRING

currency_settings

OBJECT

custom_fields

ARRAY

encoded_key

STRING

fees_settings

OBJECT

allow_arbitrary_fees

BOOLEAN

fees

ARRAY

accounting_rules

ARRAY

encoded_key

STRING

financial_resource

STRING

gl_account_key

STRING

amount

NUMBER

amount_calculation_method

STRING

apply_date_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

id

STRING

last_modified_date

DATE-TIME

name

STRING

state

STRING

trigger

STRING

id

STRING

interest_settings

OBJECT

collect_interest_when_locked

BOOLEAN

days_in_year

STRING

interest_calculation_balance

STRING

interest_paid_into_account

BOOLEAN

interest_payment_settings

OBJECT

interest_payment_dates

ARRAY

day

INTEGER

month

INTEGER

interest_payment_point

STRING

interest_rate_settings

OBJECT

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

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

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

maximum_balance

NUMBER

internal_controls

OBJECT

dormancy_period_days

INTEGER

max_withdrawal_amount

NUMBER

opening_balance

OBJECT

default_value

NUMBER

max_value

NUMBER

min_value

NUMBER

recommended_deposit_amount

NUMBER

last_modified_date

DATE-TIME

maturity_settings

OBJECT

maturity_period

OBJECT

default_value

INTEGER

max_value

INTEGER

min_value

INTEGER

maturity_period_unit

STRING

name

STRING

new_account_settings

OBJECT

id_generator_type

STRING

id_pattern

STRING

notes

STRING

offset_settings

OBJECT

allow_offset

BOOLEAN

overdraft_interest_settings

OBJECT

days_in_year

STRING

interest_calculation_balance

STRING

interest_rate_settings

OBJECT

index_source_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate

OBJECT

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

encoded_key

STRING

ending_balance

NUMBER

interest_rate

NUMBER

overdraft_settings

OBJECT

allow_overdraft

BOOLEAN

allow_technical_overdraft

BOOLEAN

max_overdraft_limit

NUMBER

state

STRING

tax_settings

OBJECT

withholding_tax_enabled

BOOLEAN

templates

ARRAY

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

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

account_balances

OBJECT

total_balance

NUMBER

adjustment_transaction_key

STRING

affected_amounts

OBJECT

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

advice

BOOLEAN

amount

NUMBER

card_acceptor

OBJECT

city

STRING

country

STRING

mcc

INTEGER

name

STRING

state

STRING

street

STRING

zip

STRING

card_token

STRING

currency_code

STRING

encoded_key

STRING

external_authorization_reference_id

STRING

external_reference_id

STRING

user_transaction_time

STRING

centre_key

STRING

creation_date

DATE-TIME

currency_code

STRING

custom_fields

ARRAY

encoded_key

STRING

external_id

STRING

fees

ARRAY

amount

NUMBER

name

STRING

predefined_fee_key

STRING

tax_amount

NUMBER

trigger

STRING

hold_external_reference_id

STRING

id

STRING

interest_accrued_amounts

OBJECT

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

creditor

OBJECT

creditor_account

OBJECT

currency

STRING

identification

OBJECT

iban

STRING

other

OBJECT

identification

STRING

scheme

STRING

creditor_agent

OBJECT

financial_institution_identification

OBJECT

debtor

OBJECT

debtor_account

OBJECT

currency

STRING

identification

OBJECT

iban

STRING

other

OBJECT

identification

STRING

scheme

STRING

debtor_agent

OBJECT

financial_institution_identification

OBJECT

payment_identification

OBJECT

end_to_end_identification

STRING

instruction_identification

STRING

transaction_identification

STRING

payment_type_information

OBJECT

remittance_information

OBJECT

structured

OBJECT

creditor_reference_information

OBJECT

reference

STRING

reference_issuer

STRING

reference_type

STRING

unstructured

STRING

payment_order_id

STRING

taxes

OBJECT

tax_rate

NUMBER

terms

OBJECT

interest_settings

OBJECT

index_interest_rate

NUMBER

interest_rate

NUMBER

overdraft_interest_settings

OBJECT

index_interest_rate

NUMBER

interest_rate

NUMBER

overdraft_settings

OBJECT

overdraft_limit

NUMBER

till_key

STRING

transaction_details

OBJECT

transaction_channel_id

STRING

transaction_channel_key

STRING

transfer_details

OBJECT

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

Join gl_accounts with on
gl_journal_entries
gl_accounts.gl_code = gl_journal_entries.gl_account.gl_code

activated

BOOLEAN

allow_manual_journal_entries

BOOLEAN

balance

NUMBER

creation_date

DATE-TIME

currency

OBJECT

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

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

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

accounting_rate

OBJECT

encoded_key

STRING

end_date

DATE-TIME

from_currency_code

STRING

rate

NUMBER

start_date

DATE-TIME

to_currency_code

STRING

amount

NUMBER

currency

OBJECT

gl_account

OBJECT

activated

BOOLEAN

allow_manual_journal_entries

BOOLEAN

balance

NUMBER

creation_date

DATE-TIME

currency

OBJECT

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

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

addresses

ARRAY

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

client_key

STRING

roles

ARRAY

encoded_key

STRING

group_role_name_key

STRING

role_name

STRING

role_name_id

STRING

group_name

STRING

group_role_key

STRING

home_phone

STRING

id

STRING

last_modified_date

DATE-TIME

loan_cycle

INTEGER

migration_event_key

STRING

mobile_phone

STRING

notes

STRING

preferred_language

STRING

index_rate_sources

This table contains information about index rate sources.

Replication Method

Full Table

Primary Key

encoded_key

Useful links

index_rate_sources schema on GitHub

Mambu API method

custom_fields

ARRAY

encoded_key

STRING

id

STRING

name

STRING

notes

STRING

type

STRING

installments

This table contains information about installments for a loan.

Replication Method

Key-based Incremental

Primary Key

encoded_key

Replication Key

last_paid_date

Useful links

Mambu documentation

installments schema on GitHub

Mambu API method

custom_fields

ARRAY

due_date

DATE-TIME

encoded_key

STRING

fee

OBJECT

amount

OBJECT

due

NUMBER

expected

NUMBER

expected_unapplied

NUMBER

paid

NUMBER

tax

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

fee_details

ARRAY

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

reduced

NUMBER

encoded_key

STRING

id

STRING

name

STRING

tax

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

reduced

NUMBER

interest

OBJECT

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

is_payment_holiday

BOOLEAN

last_paid_date

DATE-TIME

number

STRING

parent_account_key

STRING

penalty

OBJECT

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

principal

OBJECT

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

repaid_date

DATE-TIME

state

STRING

interest_accrual_breakdown

This table contains information about interest accruals.

Replication Method

Key-based Incremental

Primary Key

entry_id

Replication Key

creation_date

Useful links

interest_accrual_breakdown schema on GitHub

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

accounting_rate

OBJECT

encoded_key

STRING

end_date

DATE-TIME

from_currency_code

STRING

rate

NUMBER

start_date

DATE-TIME

to_currency_code

STRING

amount

NUMBER

currency

OBJECT

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

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

account_arrears_settings

OBJECT

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

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

original_amount

NUMBER

original_currency

OBJECT

assigned_branch_key

STRING

assigned_centre_key

STRING

assigned_user_key

STRING

balances

OBJECT

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

custom_fields

ARRAY

days_in_arrears

INTEGER

days_late

INTEGER

disbursement_details

OBJECT

disbursement_date

DATE-TIME

encoded_key

STRING

expected_disbursement_date

DATE-TIME

fees

ARRAY

amount

NUMBER

encoded_key

STRING

predefined_fee_encoded_key

STRING

first_repayment_date

DATE-TIME

transaction_details

OBJECT

encoded_key

STRING

internal_transfer

BOOLEAN

target_deposit_account_key

STRING

transaction_channel_id

STRING

transaction_channel_key

STRING

encoded_key

STRING

funding_sources

ARRAY

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

id

STRING

interest_commission

NUMBER

share_percentage

NUMBER

future_payments_acceptance

STRING

guarantors

ARRAY

amount

NUMBER

asset_name

STRING

deposit_account_key

STRING

encoded_key

STRING

guarantor_key

STRING

guarantor_type

STRING

id

STRING

interest_accrued_in_billing_cycle

NUMBER

interest_commission

NUMBER

interest_from_arrears_accrued

NUMBER

interest_settings

OBJECT

account_interest_rate_settings

ARRAY

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

loan_penalty_calculation_method

STRING

penalty_rate

NUMBER

planned_installment_fees

ARRAY

amount

NUMBER

apply_on_date

DATE-TIME

encoded_key

STRING

installment_key

STRING

installment_number

INTEGER

predefined_fee_key

STRING

prepayment_settings

OBJECT

apply_interest_on_prepayment_method

STRING

elements_recalculation_method

STRING

prepayment_recalculation_method

STRING

principal_paid_installment_status

STRING

principal_payment_settings

OBJECT

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

restrict_next_due_withdrawal

BOOLEAN

rescheduled_account_key

STRING

schedule_settings

OBJECT

billing_cycle

OBJECT

default_first_repayment_due_date_offset

INTEGER

fixed_days_of_month

ARRAY

grace_period

INTEGER

grace_period_type

STRING

has_custom_schedule

BOOLEAN

payment_plan

ARRAY

amount

NUMBER

encoded_key

STRING

to_installment

INTEGER

periodic_payment

NUMBER

preview_schedule

OBJECT

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

amount

NUMBER

disbursement_details

OBJECT

disbursement_transaction_key

STRING

expected_disbursement_date

DATE-TIME

encoded_key

STRING

fees

ARRAY

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

account_link_settings

OBJECT

accounting_settings

OBJECT

accounting_method

STRING

accounting_rules

ARRAY

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

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

default_value

NUMBER

max_value

NUMBER

min_value

NUMBER

tolerance_period

OBJECT

default_value

INTEGER

encoded_key

STRING

max_value

INTEGER

min_value

INTEGER

availability_settings

OBJECT

available_for

ARRAY

branch_settings

OBJECT

available_product_branches

ARRAY

for_all_branches

BOOLEAN

category

STRING

creation_date

DATE-TIME

credit_arrangement_settings

OBJECT

credit_arrangement_requirement

STRING

currency

OBJECT

custom_fields

ARRAY

encoded_key

STRING

fees_settings

OBJECT

allow_arbitrary_fees

BOOLEAN

fees

ARRAY

accounting_rules

ARRAY

encoded_key

STRING

financial_resource

STRING

gl_account_key

STRING

transaction_channel_key

STRING

amortization_settings

OBJECT

amortization_profile

STRING

encoded_key

STRING

fee_amortization_upon_reschedule_refinance_option

STRING

frequency

STRING

interval_count

INTEGER

interval_type

STRING

period_count

INTEGER

period_unit

STRING

amount

NUMBER

amount_calculation_method

STRING

apply_date_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

id

STRING

last_modified_date

DATE-TIME

name

STRING

percentage_amount

NUMBER

state

STRING

tax_settings

OBJECT

taxable_calculation_method

STRING

trigger

STRING

funding_settings

OBJECT

enabled

BOOLEAN

funder_interest_commission

OBJECT

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

default_value

NUMBER

encoded_key

STRING

max_value

NUMBER

min_value

NUMBER

required_funds

NUMBER

grace_period_settings

OBJECT

grace_period

OBJECT

default_value

INTEGER

encoded_key

STRING

max_value

INTEGER

min_value

INTEGER

grace_period_type

STRING

id

STRING

interest_settings

OBJECT

accrue_late_interest

BOOLEAN

compounding_frequency

STRING

days_in_year

STRING

index_rate_settings

OBJECT

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

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

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

encoded_key

STRING

index_source_key

STRING

interest_rate

OBJECT

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

dormancy_period_days

INTEGER

four_eyes_principle

OBJECT

active_for_loan_approval

BOOLEAN

lock_settings

OBJECT

capping_constraint_type

STRING

capping_method

STRING

capping_percentage

NUMBER

lock_period_days

INTEGER

last_modified_date

DATE-TIME

loan_amount_settings

OBJECT

loan_amount

OBJECT

default_value

NUMBER

encoded_key

STRING

max_value

NUMBER

min_value

NUMBER

tranche_settings

OBJECT

max_number_of_tranches

INTEGER

name

STRING

new_account_settings

OBJECT

account_initial_state

STRING

id_generator_type

STRING

id_pattern

STRING

notes

STRING

offset_settings

OBJECT

allow_offset

BOOLEAN

payment_settings

OBJECT

amortization_method

STRING

late_payments_recalculation_method

STRING

payment_method

STRING

prepayment_settings

OBJECT

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

amount

OBJECT

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

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

loan_penalty_calculation_method

STRING

loan_penalty_grace_period

INTEGER

penalty_rate

OBJECT

default_value

NUMBER

encoded_key

STRING

max_value

NUMBER

min_value

NUMBER

redraw_settings

OBJECT

allow_redraw

BOOLEAN

schedule_settings

OBJECT

billing_cycles

OBJECT

enabled

BOOLEAN

start_days

ARRAY

default_repayment_period_count

INTEGER

first_repayment_due_date_offset

OBJECT

default_value

INTEGER

encoded_key

STRING

max_value

INTEGER

min_value

INTEGER

fixed_days_of_month

ARRAY

interest_accrual_since

STRING

num_installments

OBJECT

default_value

INTEGER

encoded_key

STRING

max_value

INTEGER

min_value

INTEGER

preview_schedule

OBJECT

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

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

is_collateral_enabled

BOOLEAN

is_guarantors_enabled

BOOLEAN

required_guaranties

NUMBER

state

STRING

tax_settings

OBJECT

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

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

assigned_branch_key

STRING

assigned_centre_key

STRING

assigned_user_key

STRING

custom_settings

ARRAY

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

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

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

account_balances

OBJECT

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

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

advice

BOOLEAN

amount

NUMBER

card_acceptor

OBJECT

city

STRING

country

STRING

mcc

INTEGER

name

STRING

state

STRING

street

STRING

zip

STRING

card_token

STRING

currency_code

STRING

encoded_key

STRING

external_authorization_reference_id

STRING

external_reference_id

STRING

user_transaction_time

STRING

centre_key

STRING

creation_date

DATE-TIME

currency

OBJECT

custom_fields

ARRAY

custom_payment_amounts

ARRAY

amount

NUMBER

custom_payment_amount_type

STRING

predefined_fee_key

STRING

tax_on_amount

NUMBER

encoded_key

STRING

external_id

STRING

fees

ARRAY

amount

NUMBER

name

STRING

predefined_fee_key

STRING

tax_amount

NUMBER

trigger

STRING

id

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

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

interest_settings

OBJECT

index_interest_rate

NUMBER

interest_rate

NUMBER

periodic_payment

NUMBER

principal_payment_amount

NUMBER

principal_payment_percentage

NUMBER

till_key

STRING

transaction_details

OBJECT

transaction_channel_id

STRING

transaction_channel_key

STRING

transfer_details

OBJECT

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

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

assigned_user_key

STRING

created_by_full_name

STRING

created_by_user_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

description

STRING

due_date

DATE

encoded_key

STRING

id

INTEGER

last_modified_date

DATE-TIME

status

STRING

task_link_key

STRING

task_link_type

STRING

template_key

STRING

title

STRING

users

This table contains information about users.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

users schema on GitHub

Mambu API method

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

access

OBJECT

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

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

id

STRING

language

STRING

last_logged_in_date

DATE-TIME

last_modified_date

DATE-TIME

last_name

STRING

mobile_phone

STRING

notes

STRING

role

OBJECT

encoded_key

STRING

id

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.