Mambu integration summary

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

Mambu feature snapshot

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

STITCH
Release status Supported by

Stitch

Stitch plan

Standard

API availability

Not available

Singer GitHub repository

singer-io/tap-mambu

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Mambu

Mambu setup requirements

To set up Mambu in Stitch, you need:

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


Step 1: Add Mambu as a Stitch data source

  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

branch_name

STRING

client_key

STRING

client_name

STRING

encoded_key

STRING

field_changes

ARRAY

branchKey

STRING

clientKey

STRING

field_change_name

STRING

id

INTEGER

loanAccountKey

STRING

loanProductKey

STRING

new_value

STRING

original_value

STRING

transaction_id

INTEGER

loan_account_name

STRING

loan_product_name

STRING

notes

STRING

timestamp

DATE-TIME

transaction_ID

INTEGER

type

STRING

user_key

STRING

user_name

STRING

audit_trail

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

Replication Method

Key-based Incremental

Replication Key

occurred_at

Useful links

Mambu documentation

audit_trail schema on GitHub

Mambu API method

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
branches.custom_fields.field_set_id = centres.custom_fields.field_set_id
branches.custom_fields.id = centres.custom_fields.id
deposit_transactions
branches.encoded_key = deposit_transactions.branch_key
branches.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
branches.custom_fields.id = deposit_transactions.custom_fields.id
groups
branches.encoded_key = groups.assigned_branch_key
branches.custom_fields.field_set_id = groups.custom_fields.field_set_id
branches.custom_fields.id = groups.custom_fields.id
loan_accounts
branches.encoded_key = loan_accounts.assigned_branch_key
branches.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
branches.custom_fields.id = loan_accounts.custom_fields.id
loan_transactions
branches.encoded_key = loan_transactions.branch_key
branches.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
branches.custom_fields.id = loan_transactions.custom_fields.id
users
branches.encoded_key = users.access.managed_branches.branch_key
branches.custom_fields.field_set_id = users.custom_fields.field_set_id
branches.custom_fields.id = users.custom_fields.id
clients
branches.custom_fields.field_set_id = clients.custom_fields.field_set_id
branches.custom_fields.id = clients.custom_fields.id
communications
branches.custom_fields.field_set_id = communications.custom_fields.field_set_id
branches.custom_fields.id = communications.custom_fields.id
credit_arrangements
branches.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
branches.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets
branches.custom_fields.field_set_id = custom_field_sets.id
branches.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts
branches.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
branches.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products
branches.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
branches.custom_fields.id = deposit_products.custom_field_values.custom_field.id
branches.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products
branches.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
branches.custom_fields.id = loan_products.custom_field_values.custom_field.id
branches.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks
branches.custom_fields.field_set_id = tasks.custom_fields.field_set_id
branches.custom_fields.id = tasks.custom_fields.id

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

is_anually_recurring

BOOLEAN

name

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

field_set_id

STRING

id

STRING

value

STRING

email_address

STRING

encoded_key

STRING

id

STRING

last_modified_date

DATE-TIME

name

STRING

notes

STRING

phone_number

STRING

state

STRING

cards

This table contains information about cards.

Note: In order to replicate this table, you must also set the deposit_account 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
centres.custom_fields.field_set_id = branches.custom_fields.field_set_id
centres.custom_fields.id = branches.custom_fields.id
deposit_transactions
centres.assigned_branch_key = deposit_transactions.branch_key
centres.encoded_key = deposit_transactions.centre_key
centres.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
centres.custom_fields.id = deposit_transactions.custom_fields.id
groups
centres.assigned_branch_key = groups.assigned_branch_key
centres.encoded_key = groups.assigned_centre_key
centres.custom_fields.field_set_id = groups.custom_fields.field_set_id
centres.custom_fields.id = groups.custom_fields.id
loan_accounts
centres.assigned_branch_key = loan_accounts.assigned_branch_key
centres.encoded_key = loan_accounts.assigned_centre_key
centres.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
centres.custom_fields.id = loan_accounts.custom_fields.id
loan_transactions
centres.assigned_branch_key = loan_transactions.branch_key
centres.encoded_key = loan_transactions.centre_key
centres.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
centres.custom_fields.id = loan_transactions.custom_fields.id
users
centres.assigned_branch_key = users.access.managed_branches.branch_key
centres.custom_fields.field_set_id = users.custom_fields.field_set_id
centres.custom_fields.id = users.custom_fields.id
clients
centres.encoded_key = clients.assigned_centre_key
centres.custom_fields.field_set_id = clients.custom_fields.field_set_id
centres.custom_fields.id = clients.custom_fields.id
communications
centres.custom_fields.field_set_id = communications.custom_fields.field_set_id
centres.custom_fields.id = communications.custom_fields.id
credit_arrangements
centres.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
centres.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets
centres.custom_fields.field_set_id = custom_field_sets.id
centres.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts
centres.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
centres.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products
centres.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
centres.custom_fields.id = deposit_products.custom_field_values.custom_field.id
centres.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products
centres.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
centres.custom_fields.id = loan_products.custom_field_values.custom_field.id
centres.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks
centres.custom_fields.field_set_id = tasks.custom_fields.field_set_id
centres.custom_fields.id = tasks.custom_fields.id

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

field_set_id

STRING

id

STRING

value

STRING

encoded_key

STRING

id

STRING

last_modified_date

DATE-TIME

meeting_day

STRING

name

STRING

notes

STRING

state

STRING

clients

This table contains information about clients.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

clients schema on GitHub

Mambu API method

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

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

field_set_id

STRING

id

STRING

value

STRING

email_address

STRING

encoded_key

STRING

first_name

STRING

gender

STRING

group_loan_cycle

INTEGER

home_phone

STRING

id

STRING

id_documents

ARRAY

client_key

STRING

document_id

STRING

document_type

STRING

encoded_key

STRING

identification_document_template_key

STRING

index_in_list

INTEGER

issuing_authority

STRING

valid_until

DATE

last_modified_date

DATE-TIME

last_name

STRING

middle_name

STRING

migration_event_key

STRING

mobile_phone

STRING

notes

STRING

preferred_language

STRING

profile_picture_key

STRING

profile_signature_key

STRING

state

STRING

communications

This table contains information about communications.

Replication Method

Key-based Incremental

Primary Key

encoded_key

Replication Key

creation_date

Useful links

Mambu documentation

communications schema on GitHub

Mambu API method

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

body

STRING

client_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

field_set_id

STRING

id

STRING

value

STRING

deposit_account_key

STRING

destination

STRING

encoded_key

STRING

event

STRING

failure_cause

STRING

failure_reason

STRING

group_key

STRING

loan_account_key

STRING

num_retries

INTEGER

reference_id

STRING

repayment_key

STRING

send_date

DATE-TIME

sender_key

STRING

state

STRING

subject

STRING

template_key

STRING

type

STRING

user_key

STRING

credit_arrangements

This table contains information about credit arrangements.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

credit_arrangements schema on GitHub

Mambu API method

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

amount

NUMBER

approved_date

DATE-TIME

available_credit_amount

NUMBER

consumed_credit_amount

NUMBER

creation_date

DATE-TIME

custom_fields

ARRAY

field_set_id

STRING

id

STRING

value

STRING

encoded_key

STRING

expire_date

DATE-TIME

holder_key

STRING

holder_type

STRING

id

STRING

last_modified_date

DATE-TIME

notes

STRING

start_date

DATE-TIME

state

STRING

sub_state

STRING

custom_field_sets

This table contains information about custom field sets.

Replication Method

Full Table

Primary Key

id

Useful links

Mambu documentation

custom_field_sets schema on GitHub

Mambu API method

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

created_date

DATE-TIME

custom_fields

ARRAY

amounts

OBJECT

custom_field_product_settings

ARRAY

custom_field_encoded_key

STRING

encoded_key

STRING

is_default

BOOLEAN

is_required

BOOLEAN

link_type

STRING

product_key

STRING

custom_field_selection_options

ARRAY

encoded_key

STRING

is_default

BOOLEAN

score

STRING

value

STRING

data_type

STRING

edit_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

id

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

id

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

notes

STRING

type

STRING

usage

STRING

deposit_accounts

This table contains information about deposit accounts.

Replication Method

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
deposit_accounts.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
deposit_accounts.custom_fields.id = credit_arrangements.custom_fields.id
loan_accounts
deposit_accounts.credit_arrangement_key = loan_accounts.credit_arrangement_key
deposit_accounts.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
deposit_accounts.custom_fields.id = loan_accounts.custom_fields.id
deposit_accounts.encoded_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key
deposit_accounts.encoded_key = loan_accounts.funding_sources.deposit_account_key
deposit_accounts.encoded_key = loan_accounts.guarantors.deposit_account_key
branches
deposit_accounts.custom_fields.field_set_id = branches.custom_fields.field_set_id
deposit_accounts.custom_fields.id = branches.custom_fields.id
centres
deposit_accounts.custom_fields.field_set_id = centres.custom_fields.field_set_id
deposit_accounts.custom_fields.id = centres.custom_fields.id
clients
deposit_accounts.custom_fields.field_set_id = clients.custom_fields.field_set_id
deposit_accounts.custom_fields.id = clients.custom_fields.id
communications
deposit_accounts.custom_fields.field_set_id = communications.custom_fields.field_set_id
deposit_accounts.custom_fields.id = communications.custom_fields.id
deposit_accounts.encoded_key = communications.deposit_account_key
custom_field_sets
deposit_accounts.custom_fields.field_set_id = custom_field_sets.id
deposit_accounts.custom_fields.id = custom_field_sets.custom_fields.id
deposit_products
deposit_accounts.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
deposit_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field.id
deposit_accounts.custom_fields.id = deposit_products.custom_field_values.custom_field_id
deposit_transactions
deposit_accounts.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
deposit_accounts.custom_fields.id = deposit_transactions.custom_fields.id
groups
deposit_accounts.custom_fields.field_set_id = groups.custom_fields.field_set_id
deposit_accounts.custom_fields.id = groups.custom_fields.id
loan_products
deposit_accounts.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
deposit_accounts.custom_fields.id = loan_products.custom_field_values.custom_field.id
deposit_accounts.custom_fields.id = loan_products.custom_field_values.custom_field_id
loan_transactions
deposit_accounts.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
deposit_accounts.custom_fields.id = loan_transactions.custom_fields.id
tasks
deposit_accounts.custom_fields.field_set_id = tasks.custom_fields.field_set_id
deposit_accounts.custom_fields.id = tasks.custom_fields.id
users
deposit_accounts.custom_fields.field_set_id = users.custom_fields.field_set_id
deposit_accounts.custom_fields.id = users.custom_fields.id

account_holder_key

STRING

account_holder_type

STRING

account_state

STRING

account_type

STRING

accrued_amounts

OBJECT

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

fees_due

NUMBER

hold_balance

NUMBER

locked_balance

NUMBER

overdraft_amount

NUMBER

overdraft_interest_due

NUMBER

technical_overdraft_amount

NUMBER

technical_overdraft_interest_due

NUMBER

total_balance

NUMBER

closed_date

DATE-TIME

creation_date

DATE-TIME

credit_arrangement_key

STRING

currency_code

STRING

custom_fields

ARRAY

field_set_id

STRING

id

STRING

value

STRING

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_terms

STRING

interest_rate_tiers

ARRAY

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

internal_controls

OBJECT

max_withdrawal_amount

NUMBER

recommended_deposit_amount

NUMBER

target_amount

NUMBER

last_account_appraisal_date

DATE-TIME

last_interest_calculation_date

DATE-TIME

last_interest_stored_date

DATE-TIME

last_modified_date

DATE-TIME

last_overdraft_interest_review_date

DATE-TIME

last_sent_to_arrears_date

DATE-TIME

linked_settlement_account_keys

ARRAY

locked_date

DATE-TIME

maturity_date

DATE-TIME

migration_event_key

STRING

name

STRING

notes

STRING

overdraft_interest_settings

OBJECT

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

allowed_overdraft

BOOLEAN

overdraft_expiry_date

DATE-TIME

overdraft_limit

NUMBER

product_type_key

STRING

withholding_tax_source_key

STRING

deposit_products

This table contains information about deposit (savings) products.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

deposit_products schema on GitHub

Mambu API method

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

accounting_method

STRING

activated

BOOLEAN

allow_arbitrary_fees

BOOLEAN

allow_offset

BOOLEAN

allow_overdraft

BOOLEAN

allow_technical_overdraft

BOOLEAN

available_product_branches

ARRAY

branch_key

STRING

encoded_key

STRING

collect_interest_when_locked

BOOLEAN

creation_date

DATE-TIME

currencies

ARRAY

code

STRING

creation_date

DATE-TIME

currency_symbol_position

STRING

digits_after_decimal

INTEGER

is_base_currency

BOOLEAN

last_modified_date

DATE-TIME

name

STRING

symbol

STRING

custom_field_values

ARRAY

amount

STRING

custom_field

OBJECT

amounts

OBJECT

custom_field_selection_options

ARRAY

encoded_key

STRING

score

STRING

value

STRING

custom_field_set

OBJECT

creation_date

DATE-TIME

encoded_key

STRING

id

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

type

STRING

usage

STRING

data_type

STRING

edit_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

id

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

custom_field_id

STRING

custom_field_key

STRING

custom_field_set_group_index

INTEGER

encoded_key

STRING

index_in_list

INTEGER

parent_key

STRING

value

STRING

description

STRING

encoded_key

STRING

for_all_branches

BOOLEAN

for_groups

BOOLEAN

for_individuals

BOOLEAN

id

STRING

id_generator_type

STRING

id_pattern

STRING

interest_accrued_accounting_method

STRING

interest_calculation_balance

STRING

interest_days_in_year

STRING

interest_paid_into_account

BOOLEAN

interest_payment_point

STRING

interest_rate_settings

OBJECT

accrue_interest_after_maturity

BOOLEAN

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

last_modified_date

DATE-TIME

line_of_credit_requirement

STRING

maturity_period_limit

STRING

max_overdraft_limit

STRING

min_opening_balance

STRING

name

STRING

overdraft_days_in_year

STRING

overdraft_interest_rate_settings

OBJECT

accrue_interest_after_maturity

BOOLEAN

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

interest_rate_tiers

ARRAY

encoded_key

STRING

ending_balance

NUMBER

ending_day

INTEGER

interest_rate

NUMBER

product_type

STRING

savings_fees

ARRAY

active

BOOLEAN

amortization_profile

STRING

amount

STRING

amount_calculation_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_amortization_upon_reschedule_option

STRING

fee_application

STRING

fee_product_rules

ARRAY

name

STRING

trigger

STRING

savings_product_rules

ARRAY

templates

ARRAY

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

withholding_tax_enabled

BOOLEAN

deposit_transactions

This table contains information about deposit transactions.

Replication Method

Key-based Incremental

Primary Key

encoded_key

Replication Key

creation_date

Useful links

Mambu documentation

deposit_transactions schema on GitHub

Mambu API method

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

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

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

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

field_set_id

STRING

id

STRING

value

STRING

encoded_key

STRING

external_id

STRING

fees

ARRAY

amount

NUMBER

name

STRING

predefined_fee_key

STRING

tax_amount

NUMBER

trigger

STRING

id

STRING

linked_loan_transaction_key

STRING

migration_event_key

STRING

notes

STRING

original_transaction_key

STRING

parent_account_key

STRING

payment_details

OBJECT

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

taxes

OBJECT

tax_rate

NUMBER

terms

OBJECT

interest_settings

OBJECT

interest_rate

NUMBER

overdraft_interest_settings

OBJECT

index_interest_rate

NUMBER

interest_rate

NUMBER

overdraft_settings

OBJECT

overdraft_limit

NUMBER

till_key

STRING

transaction_details

OBJECT

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

code

STRING

currency_symbol_position

STRING

digits_after_decimal

INTEGER

is_base_currency

BOOLEAN

last_modified_date

DATE-TIME

name

STRING

symbol

STRING

encoded_key

STRING

entry_id

STRING

gl_code

STRING

last_modified_date

DATE-TIME

name

STRING

strip_trailing_zeros

BOOLEAN

type

STRING

usage

STRING

gl_journal_entries

This table contains information about general ledger entries.

Replication Method

Key-based Incremental

Primary Key

entry_id

Replication Key

booking_date

Useful links

Mambu documentation

gl_journal_entries schema on GitHub

Mambu API method

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

booking_date

DATE-TIME

creation_date

DATE-TIME

encoded_key

STRING

entry_date

DATE-TIME

entry_id

STRING

gl_account

OBJECT

activated

BOOLEAN

allow_manual_journal_entries

BOOLEAN

balance

NUMBER

creation_date

DATE-TIME

currency

OBJECT

code

STRING

currency_symbol_position

STRING

digits_after_decimal

INTEGER

is_base_currency

BOOLEAN

last_modified_date

DATE-TIME

name

STRING

symbol

STRING

encoded_key

STRING

entry_id

STRING

gl_code

STRING

last_modified_date

DATE-TIME

name

STRING

strip_trailing_zeros

BOOLEAN

type

STRING

usage

STRING

product_key

STRING

transaction_id

STRING

type

STRING

user_key

STRING

groups

This table contains information about groups.

Replication Method

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
groups.custom_fields.field_set_id = branches.custom_fields.field_set_id
groups.custom_fields.id = branches.custom_fields.id
centres
groups.assigned_branch_key = centres.assigned_branch_key
groups.assigned_centre_key = centres.encoded_key
groups.custom_fields.field_set_id = centres.custom_fields.field_set_id
groups.custom_fields.id = centres.custom_fields.id
deposit_transactions
groups.assigned_branch_key = deposit_transactions.branch_key
groups.assigned_centre_key = deposit_transactions.centre_key
groups.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
groups.custom_fields.id = deposit_transactions.custom_fields.id
groups.assigned_user_key = deposit_transactions.user_key
loan_accounts
groups.assigned_branch_key = loan_accounts.assigned_branch_key
groups.assigned_centre_key = loan_accounts.assigned_centre_key
groups.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
groups.custom_fields.id = loan_accounts.custom_fields.id
groups.assigned_user_key = loan_accounts.assigned_user_key
loan_transactions
groups.assigned_branch_key = loan_transactions.branch_key
groups.assigned_centre_key = loan_transactions.centre_key
groups.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
groups.custom_fields.id = loan_transactions.custom_fields.id
groups.assigned_user_key = loan_transactions.user_key
users
groups.assigned_branch_key = users.access.managed_branches.branch_key
groups.custom_fields.field_set_id = users.custom_fields.field_set_id
groups.custom_fields.id = users.custom_fields.id
groups.assigned_user_key = users.encoded_key
clients
groups.assigned_centre_key = clients.assigned_centre_key
groups.group_members.client_key = clients.encoded_key
groups.custom_fields.field_set_id = clients.custom_fields.field_set_id
groups.custom_fields.id = clients.custom_fields.id
groups.assigned_user_key = clients.assigned_user_key
activities
groups.group_members.client_key = activities.client_key
groups.assigned_user_key = activities.user_key
communications
groups.group_members.client_key = communications.client_key
groups.custom_fields.field_set_id = communications.custom_fields.field_set_id
groups.custom_fields.id = communications.custom_fields.id
groups.encoded_key = communications.group_key
groups.assigned_user_key = communications.user_key
groups.assigned_user_key = communications.sender_key
credit_arrangements
groups.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
groups.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets
groups.custom_fields.field_set_id = custom_field_sets.id
groups.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts
groups.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
groups.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products
groups.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
groups.custom_fields.id = deposit_products.custom_field_values.custom_field.id
groups.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products
groups.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
groups.custom_fields.id = loan_products.custom_field_values.custom_field.id
groups.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks
groups.custom_fields.field_set_id = tasks.custom_fields.field_set_id
groups.custom_fields.id = tasks.custom_fields.id
groups.assigned_user_key = tasks.created_by_user_key
groups.assigned_user_key = tasks.assigned_user_key
gl_journal_entries
groups.assigned_user_key = gl_journal_entries.user_key

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

field_set_id

STRING

id

STRING

value

STRING

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

group_name

STRING

group_role_key

STRING

home_phone

STRING

id

STRING

last_modified_date

DATE-TIME

loan_cycle

STRING

migration_event_key

STRING

mobile_phone

STRING

notes

STRING

preferred_language

STRING

index_rate_sources

This table contains information about index rate sources.

Replication Method

Full Table

Primary Key

encoded_key

Useful links

index_rate_sources schema on GitHub

Mambu API method

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

due_date

DATE-TIME

encoded_key

STRING

fee

OBJECT

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

interest

OBJECT

amount

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

tax

OBJECT

due

NUMBER

expected

NUMBER

paid

NUMBER

last_paid_date

DATE-TIME

number

STRING

parent_account_key

STRING

penalty

OBJECT

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

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

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

assigned_branch_key

STRING

assigned_centre_key

STRING

assigned_user_key

STRING

balances

OBJECT

fees_balance

NUMBER

fees_due

NUMBER

fees_paid

NUMBER

interest_balance

NUMBER

interest_due

NUMBER

interest_from_arrears_balance

NUMBER

interest_from_arrears_due

NUMBER

interest_from_arrears_paid

NUMBER

interest_paid

NUMBER

penalty_balance

NUMBER

penalty_due

NUMBER

penalty_paid

NUMBER

principal_balance

NUMBER

principal_due

NUMBER

principal_paid

NUMBER

redraw_balance

NUMBER

closed_date

DATE-TIME

creation_date

DATE-TIME

credit_arrangement_key

STRING

currency

OBJECT

custom_fields

ARRAY

field_set_id

STRING

id

STRING

value

STRING

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_commission

NUMBER

interest_from_arrears_accrued

NUMBER

interest_settings

OBJECT

accrue_interest_after_maturity

BOOLEAN

interest_application_method

STRING

interest_balance_calculation_method

STRING

interest_calculation_method

STRING

interest_charge_frequency

STRING

interest_rate

NUMBER

interest_rate_review_count

INTEGER

interest_rate_review_unit

STRING

interest_rate_source

STRING

interest_spread

NUMBER

interest_type

STRING

last_account_appraisal_date

DATE-TIME

last_appraisal_date

DATE-TIME

last_interest_applied_date

DATE-TIME

last_interest_review_date

DATE-TIME

last_locked_date

DATE-TIME

last_modified_date

DATE-TIME

last_set_to_arrears_date

DATE-TIME

last_tax_rate_review_date

DATE-TIME

late_payments_recalculation_method

STRING

loan_amount

NUMBER

loan_name

STRING

locked_operations

ARRAY

migration_event_key

STRING

notes

STRING

original_account_key

STRING

payment_method

STRING

penalty_settings

OBJECT

loan_penalty_calculation_method

STRING

penalty_rate

NUMBER

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

rescheduled_account_key

STRING

schedule_settings

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

principal_repayment_interval

INTEGER

repayment_installments

INTEGER

repayment_period_count

INTEGER

repayment_period_unit

STRING

repayment_schedule_method

STRING

schedule_due_dates_method

STRING

short_month_handling_method

STRING

settlement_account_key

STRING

tax_rate

NUMBER

tranches

ARRAY

amount

NUMBER

disbursement_details

OBJECT

disbursement_transaction_key

STRING

expected_disbursement_date

DATE-TIME

encoded_key

STRING

tranch_number

STRING

loan_products

This table contains information about loan products.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

loan_products schema on GitHub

Mambu API method

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

account_initial_state

STRING

account_linking_enabled

BOOLEAN

accounting_method

STRING

activated

BOOLEAN

allow_arbitrary_fees

BOOLEAN

allow_collateral

BOOLEAN

allow_guarantors

BOOLEAN

amortization_method

STRING

apply_interest_on_prepayment_method

STRING

arrears_date_calculation_method

STRING

arrears_non_working_days_method

STRING

arrears_tolerance_period

INTEGER

auto_create_linked_accounts

BOOLEAN

auto_link_accounts

BOOLEAN

automatically_close_dormant_accounts

BOOLEAN

creation_date

DATE-TIME

custom_field_values

ARRAY

amount

STRING

custom_field

OBJECT

amounts

OBJECT

custom_field_selection_options

ARRAY

encoded_key

STRING

score

STRING

value

STRING

custom_field_set

OBJECT

creation_date

DATE-TIME

encoded_key

STRING

id

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

type

STRING

usage

STRING

data_type

STRING

edit_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

id

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

custom_field_id

STRING

custom_field_key

STRING

custom_field_set_group_index

INTEGER

encoded_key

STRING

index_in_list

INTEGER

parent_key

STRING

value

STRING

days_in_year

STRING

declining_balance_prepayment_recalculation

STRING

default_loan_amount

STRING

default_num_installments

INTEGER

default_principal_repayment_interval

INTEGER

default_repayment_period_count

INTEGER

encoded_key

STRING

for_hybrid_groups

BOOLEAN

for_individuals

BOOLEAN

for_pure_groups

BOOLEAN

future_payments_acceptance

STRING

grace_period_type

STRING

id

STRING

id_generator_type

STRING

id_pattern

STRING

interest_accrued_accounting_method

STRING

interest_application_method

STRING

interest_balance_calculation_method

STRING

interest_calculation_method

STRING

interest_charge_frequency

STRING

interest_rate_settings

OBJECT

default_interest_rate

STRING

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

is_investor_funds_enabled

BOOLEAN

last_modified_date

DATE-TIME

late_payments_recalculation_method

STRING

line_of_credit_requirement

STRING

loan_fees

ARRAY

active

BOOLEAN

amoritization_profile

STRING

amortization_interval_settings

OBJECT

encoded_key

STRING

frequency

STRING

interval_count

INTEGER

period_count

INTEGER

period_unit

STRING

amount

STRING

amount_calculation_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

fee_product_rules

ARRAY

name

STRING

trigger

STRING

loan_penalty_calculation_method

STRING

loan_product_rules

ARRAY

loan_product_type

STRING

loan_type

STRING

max_number_of_disbursement_tranches

INTEGER

payment_method

STRING

prepayment_acceptance

STRING

product_description

STRING

product_name

STRING

product_security_settings

OBJECT

encoded_key

STRING

is_collateral_enabled

BOOLEAN

is_guarantors_enabled

BOOLEAN

is_investor_funds_enabled

BOOLEAN

required_guaranties

STRING

repayment_allocation_order

ARRAY

repayment_currency_rounding

STRING

repayment_elements_rounding_method

STRING

repayment_period_unit

STRING

repayment_rescheduling_method

STRING

repayment_schedule_edit_options

ARRAY

repayment_schedule_method

STRING

required_guaranty_percentage

STRING

rounding_repayment_schedule_method

STRING

schedule_due_dates_method

STRING

schedule_interest_days_count_method

STRING

settlement_options

STRING

taxes_on_fees_enabled

BOOLEAN

taxes_on_interest_enabled

BOOLEAN

taxes_on_penalty_enabled

BOOLEAN

templates

ARRAY

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

loan_products

This table contains information about loan products.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

loan_products schema on GitHub

Mambu API method

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

account_initial_state

STRING

account_linking_enabled

BOOLEAN

accounting_method

STRING

activated

BOOLEAN

allow_arbitrary_fees

BOOLEAN

allow_collateral

BOOLEAN

allow_guarantors

BOOLEAN

amortization_method

STRING

apply_interest_on_prepayment_method

STRING

arrears_date_calculation_method

STRING

arrears_non_working_days_method

STRING

arrears_tolerance_period

INTEGER

auto_create_linked_accounts

BOOLEAN

auto_link_accounts

BOOLEAN

automatically_close_dormant_accounts

BOOLEAN

creation_date

DATE-TIME

custom_field_values

ARRAY

amount

STRING

custom_field

OBJECT

amounts

OBJECT

custom_field_selection_options

ARRAY

encoded_key

STRING

score

STRING

value

STRING

custom_field_set

OBJECT

creation_date

DATE-TIME

encoded_key

STRING

id

STRING

index_in_list

INTEGER

last_modified_date

DATE-TIME

name

STRING

type

STRING

usage

STRING

data_type

STRING

edit_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

encoded_key

STRING

id

STRING

index_in_list

INTEGER

is_default

BOOLEAN

is_required

BOOLEAN

name

STRING

state

STRING

type

STRING

unique

BOOLEAN

value_length

STRING

values

ARRAY

view_rights

OBJECT

encoded_key

STRING

is_accessible_by_all_users

BOOLEAN

roles

ARRAY

custom_field_id

STRING

custom_field_key

STRING

custom_field_set_group_index

INTEGER

encoded_key

STRING

index_in_list

INTEGER

parent_key

STRING

value

STRING

days_in_year

STRING

declining_balance_prepayment_recalculation

STRING

default_loan_amount

STRING

default_num_installments

INTEGER

default_principal_repayment_interval

INTEGER

default_repayment_period_count

INTEGER

encoded_key

STRING

for_hybrid_groups

BOOLEAN

for_individuals

BOOLEAN

for_pure_groups

BOOLEAN

future_payments_acceptance

STRING

grace_period_type

STRING

id

STRING

id_generator_type

STRING

id_pattern

STRING

interest_accrued_accounting_method

STRING

interest_application_method

STRING

interest_balance_calculation_method

STRING

interest_calculation_method

STRING

interest_charge_frequency

STRING

interest_rate_settings

OBJECT

default_interest_rate

STRING

encoded_key

STRING

interest_charge_frequency

STRING

interest_charge_frequency_count

INTEGER

interest_rate_source

STRING

interest_rate_terms

STRING

is_investor_funds_enabled

BOOLEAN

last_modified_date

DATE-TIME

late_payments_recalculation_method

STRING

line_of_credit_requirement

STRING

loan_fees

ARRAY

active

BOOLEAN

amoritization_profile

STRING

amortization_interval_settings

OBJECT

encoded_key

STRING

frequency

STRING

interval_count

INTEGER

period_count

INTEGER

period_unit

STRING

amount

STRING

amount_calculation_method

STRING

creation_date

DATE-TIME

encoded_key

STRING

fee_application

STRING

fee_product_rules

ARRAY

name

STRING

trigger

STRING

loan_penalty_calculation_method

STRING

loan_product_rules

ARRAY

loan_product_type

STRING

loan_type

STRING

max_number_of_disbursement_tranches

INTEGER

payment_method

STRING

prepayment_acceptance

STRING

product_description

STRING

product_name

STRING

product_security_settings

OBJECT

encoded_key

STRING

is_collateral_enabled

BOOLEAN

is_guarantors_enabled

BOOLEAN

is_investor_funds_enabled

BOOLEAN

required_guaranties

STRING

repayment_allocation_order

ARRAY

repayment_currency_rounding

STRING

repayment_elements_rounding_method

STRING

repayment_period_unit

STRING

repayment_rescheduling_method

STRING

repayment_schedule_edit_options

ARRAY

repayment_schedule_method

STRING

required_guaranty_percentage

STRING

rounding_repayment_schedule_method

STRING

schedule_due_dates_method

STRING

schedule_interest_days_count_method

STRING

settlement_options

STRING

taxes_on_fees_enabled

BOOLEAN

taxes_on_interest_enabled

BOOLEAN

taxes_on_penalty_enabled

BOOLEAN

templates

ARRAY

creation_date

DATE-TIME

encoded_key

STRING

last_modified_date

DATE-TIME

name

STRING

type

STRING

loan_repayments

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

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

Replication Method

Full Table

Primary Key

encoded_key

loan_account

Useful links

loan_repayments schema on GitHub

Mambu API method

due_date

DATE-TIME

encoded_key

STRING

fees_due

NUMBER

fees_paid

NUMBER

interest_due

NUMBER

interest_paid

NUMBER

parent_account_key

STRING

penalty_due

NUMBER

penalty_paid

NUMBER

principal_due

NUMBER

principal_paid

NUMBER

state

STRING

tax_fees_due

NUMBER

tax_fees_paid

NUMBER

tax_interest_due

NUMBER

tax_interest_paid

NUMBER

tax_penalty_due

NUMBER

tax_penalty_paid

NUMBER

loan_transactions

This table contains information about loan transactions.

Replication Method

Key-based Incremental

Primary Key

encoded_key

Replication Key

creation_date

Useful links

Mambu documentation

loan_transactions schema on GitHub

Mambu API method

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

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

fraction_amount

NUMBER

funders_interest_amount

NUMBER

funds_amount

NUMBER

interest_amount

NUMBER

interest_from_arrears_amount

NUMBER

organization_commission_amount

NUMBER

overdraft_amount

NUMBER

overdraft_fees_amount

NUMBER

overdraft_interest_amount

NUMBER

payment_holidays_interest_amount

NUMBER

penalty_amount

NUMBER

principal_amount

NUMBER

technical_overdraft_amount

NUMBER

technical_overdraft_interest_amount

NUMBER

amount

NUMBER

booking_date

DATE-TIME

branch_key

STRING

card_transaction

OBJECT

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

field_set_id

STRING

id

STRING

value

STRING

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

linked_loan_transaction_key

STRING

migration_event_key

STRING

notes

STRING

original_amount

NUMBER

original_currency_code

STRING

original_transaction_key

STRING

parent_account_key

STRING

parent_loan_transaction_key

STRING

prepayment_recalculation_method

STRING

taxes

OBJECT

deferred_tax_on_interest_amount

NUMBER

tax_interest_from_arrears_amount

NUMBER

tax_on_fees_amount

NUMBER

tax_on_interest_amount

NUMBER

tax_on_interest_from_arrears_amount

NUMBER

tax_on_payment_holidays_interest

NUMBER

tax_on_penalty_amount

NUMBER

tax_rate

NUMBER

terms

OBJECT

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
branches
tasks.custom_fields.field_set_id = branches.custom_fields.field_set_id
tasks.custom_fields.id = branches.custom_fields.id
centres
tasks.custom_fields.field_set_id = centres.custom_fields.field_set_id
tasks.custom_fields.id = centres.custom_fields.id
clients
tasks.custom_fields.field_set_id = clients.custom_fields.field_set_id
tasks.custom_fields.id = clients.custom_fields.id
tasks.created_by_user_key = clients.assigned_user_key
tasks.assigned_user_key = clients.assigned_user_key
communications
tasks.custom_fields.field_set_id = communications.custom_fields.field_set_id
tasks.custom_fields.id = communications.custom_fields.id
tasks.created_by_user_key = communications.user_key
tasks.assigned_user_key = communications.user_key
tasks.created_by_user_key = communications.sender_key
tasks.assigned_user_key = communications.sender_key
credit_arrangements
tasks.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
tasks.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets
tasks.custom_fields.field_set_id = custom_field_sets.id
tasks.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts
tasks.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
tasks.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products
tasks.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
tasks.custom_fields.id = deposit_products.custom_field_values.custom_field.id
tasks.custom_fields.id = deposit_products.custom_field_values.custom_field_id
deposit_transactions
tasks.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
tasks.custom_fields.id = deposit_transactions.custom_fields.id
tasks.created_by_user_key = deposit_transactions.user_key
tasks.assigned_user_key = deposit_transactions.user_key
groups
tasks.custom_fields.field_set_id = groups.custom_fields.field_set_id
tasks.custom_fields.id = groups.custom_fields.id
tasks.created_by_user_key = groups.assigned_user_key
tasks.assigned_user_key = groups.assigned_user_key
loan_accounts
tasks.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
tasks.custom_fields.id = loan_accounts.custom_fields.id
tasks.created_by_user_key = loan_accounts.assigned_user_key
tasks.assigned_user_key = loan_accounts.assigned_user_key
loan_products
tasks.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
tasks.custom_fields.id = loan_products.custom_field_values.custom_field.id
tasks.custom_fields.id = loan_products.custom_field_values.custom_field_id
loan_transactions
tasks.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
tasks.custom_fields.id = loan_transactions.custom_fields.id
tasks.created_by_user_key = loan_transactions.user_key
tasks.assigned_user_key = loan_transactions.user_key
users
tasks.custom_fields.field_set_id = users.custom_fields.field_set_id
tasks.custom_fields.id = users.custom_fields.id
tasks.created_by_user_key = users.encoded_key
tasks.assigned_user_key = users.encoded_key
activities
tasks.created_by_user_key = activities.user_key
tasks.assigned_user_key = activities.user_key
gl_journal_entries
tasks.created_by_user_key = gl_journal_entries.user_key
tasks.assigned_user_key = gl_journal_entries.user_key

assigned_user_key

STRING

created_by_full_name

STRING

created_by_user_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

field_set_id

STRING

id

STRING

value

STRING

description

STRING

due_date

DATE

encoded_key

STRING

id

STRING

last_modified_date

DATE-TIME

state

STRING

status

STRING

task_link

STRING

task_link_key

STRING

task_link_type

STRING

title

STRING

users

This table contains information about users.

Replication Method

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
users.custom_fields.field_set_id = branches.custom_fields.field_set_id
users.custom_fields.id = branches.custom_fields.id
centres
users.access.managed_branches.branch_key = centres.assigned_branch_key
users.custom_fields.field_set_id = centres.custom_fields.field_set_id
users.custom_fields.id = centres.custom_fields.id
deposit_transactions
users.access.managed_branches.branch_key = deposit_transactions.branch_key
users.custom_fields.field_set_id = deposit_transactions.custom_fields.field_set_id
users.custom_fields.id = deposit_transactions.custom_fields.id
users.encoded_key = deposit_transactions.user_key
groups
users.access.managed_branches.branch_key = groups.assigned_branch_key
users.custom_fields.field_set_id = groups.custom_fields.field_set_id
users.custom_fields.id = groups.custom_fields.id
users.encoded_key = groups.assigned_user_key
loan_accounts
users.access.managed_branches.branch_key = loan_accounts.assigned_branch_key
users.custom_fields.field_set_id = loan_accounts.custom_fields.field_set_id
users.custom_fields.id = loan_accounts.custom_fields.id
users.encoded_key = loan_accounts.assigned_user_key
loan_transactions
users.access.managed_branches.branch_key = loan_transactions.branch_key
users.custom_fields.field_set_id = loan_transactions.custom_fields.field_set_id
users.custom_fields.id = loan_transactions.custom_fields.id
users.encoded_key = loan_transactions.user_key
clients
users.custom_fields.field_set_id = clients.custom_fields.field_set_id
users.custom_fields.id = clients.custom_fields.id
users.encoded_key = clients.assigned_user_key
communications
users.custom_fields.field_set_id = communications.custom_fields.field_set_id
users.custom_fields.id = communications.custom_fields.id
users.encoded_key = communications.user_key
users.encoded_key = communications.sender_key
credit_arrangements
users.custom_fields.field_set_id = credit_arrangements.custom_fields.field_set_id
users.custom_fields.id = credit_arrangements.custom_fields.id
custom_field_sets
users.custom_fields.field_set_id = custom_field_sets.id
users.custom_fields.id = custom_field_sets.custom_fields.id
deposit_accounts
users.custom_fields.field_set_id = deposit_accounts.custom_fields.field_set_id
users.custom_fields.id = deposit_accounts.custom_fields.id
deposit_products
users.custom_fields.field_set_id = deposit_products.custom_field_values.custom_field.custom_field_set.id
users.custom_fields.id = deposit_products.custom_field_values.custom_field.id
users.custom_fields.id = deposit_products.custom_field_values.custom_field_id
loan_products
users.custom_fields.field_set_id = loan_products.custom_field_values.custom_field.custom_field_set.id
users.custom_fields.id = loan_products.custom_field_values.custom_field.id
users.custom_fields.id = loan_products.custom_field_values.custom_field_id
tasks
users.custom_fields.field_set_id = tasks.custom_fields.field_set_id
users.custom_fields.id = tasks.custom_fields.id
users.encoded_key = tasks.created_by_user_key
users.encoded_key = tasks.assigned_user_key
activities
users.encoded_key = activities.user_key
gl_journal_entries
users.encoded_key = gl_journal_entries.user_key

access

OBJECT

administrator_access

BOOLEAN

api_access

BOOLEAN

can_manage_all_branches

BOOLEAN

can_manage_entities_assigned_to_other_officers

STRING

credit_officer_access

BOOLEAN

mambu_access

BOOLEAN

managed_branches

ARRAY

permissions

ARRAY

support_access

BOOLEAN

teller_access

BOOLEAN

assigned_branch_key

STRING

creation_date

DATE-TIME

custom_fields

ARRAY

field_set_id

STRING

id

STRING

value

STRING

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

title

STRING

two_factor_authentication

BOOLEAN

user_state

STRING

username

STRING


Questions? Feedback?

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