Mambu
Mambu is a cloud-native, API-driven, composable banking and financial services platform.
For more information about the API, see the Mambu v2.0 and v1.0 APIs.
See the Schema section for a list of objects available for replication.Feature/Capability | Support details |
---|---|
Supported Qlik Talend Data Integration projects | Replication projects only. Data pipeline projects are not supported. |
Replication tasks:
Landing data in a data lake tasks:
| |
Manual metadata generation is not required. | |
Only the Change column data type operation is supported. | |
Replication of LOB columns (NCLOB, CLOB, and BLOB) | Not supported. |
Scheduled CDC | Required. This is how the target is kept up-to-date with changes to the source. For replication tasks, see Scheduling CDC for replication tasks For lake landing tasks, see Scheduling CDC for lake landing tasks |
Notifications | Partially supported |
Monitoring | CDC-only, as full load is not relevant for this connector. |
Automatic denesting of JSON column payloads | Not supported. JSON column payloads in source datasets are not denested automatically on the target. |
Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
To authenticate audit trail requests you must use an API key generated by an API consumer that has the Manage Audit Trail (MANAGE_AUDIT_TRAIL) permission assigned to it. For more information, see API Consumers in Mambu documentation.
You need a Mambu account with API access. In Mambu’s app, API access can be granted to any existing user.
Creating the connection
For more information, see Connecting to SaaS applications.
- Fill in the required connection properties.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create.
Setting | Description |
---|---|
Data gateway | Select a Data Movement gateway if required by your use case. Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None. For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement. |
Start Date | Enter the date, in the format |
Subdomain | Subdomain. Example: If the subdomain is qlik.mambu.com , enter qlik . |
Username | Mambu username. |
Password | Mambu password. |
Audit Trail API Key | Audit trail API key. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 4.
Depending on your destination, table and column names may not appear as they are outlined below.
activities
This table contains information about activities.
Replication Method | CDC |
Primary Key | encoded_key |
Replication Key | timestamp |
Useful links |
Join activities with | on |
---|---|
clients | activities.client_key = clients.encoded_key activities.user_key = clients.assigned_user_key |
communications | activities.client_key = communications.client_key activities.user_key = communications.user_key activities.user_key = communications.sender_key |
groups | activities.client_key = groups.group_members.client_key activities.user_key = groups.assigned_user_key |
deposit_transactions | activities.user_key = deposit_transactions.user_key |
gl_journal_entries | activities.user_key = gl_journal_entries.user_key |
loan_accounts | activities.user_key = loan_accounts.assigned_user_key |
loan_transactions | activities.user_key = loan_transactions.user_key |
tasks | activities.user_key = tasks.created_by_user_key activities.user_key = tasks.assigned_user_key |
users | activities.user_key = users.encoded_key |
assigned_centre_key STRING |
assigned_user_key STRING |
branch_key STRING |
branch_name STRING |
centre_key STRING |
centre_name STRING |
client_key STRING |
client_name STRING |
encoded_key STRING |
field_changes ARRAY This is a nested data structure:
|
gl_account_key STRING |
gl_accounts_closure_key STRING |
group_key STRING |
group_name STRING |
line_of_credit_key STRING |
loan_account_key STRING |
loan_account_name STRING |
loan_product_key STRING |
loan_product_name STRING |
notes STRING |
savings_account_key STRING |
savings_account_name STRING |
savings_product_key STRING |
savings_product_name STRING |
task_key STRING |
task_name STRING |
timestamp DATE-TIME |
transaction_id INTEGER |
type STRING |
user_key STRING |
user_name STRING |
audit_trail
This table contains information about activities that have been performed in the Mambu Core Banking system.
Replication Method | CDC |
Replication Key | occurred_at |
Useful links |
client_ip STRING |
event_source STRING |
occurred_at DATE-TIME |
request_method STRING |
request_payload STRING |
request_uri STRING |
resource STRING |
resource_fragment STRING |
response_code NUMBER |
response_payload STRING |
user_agent STRING |
username STRING |
branches
This table contains information about branches.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
Join branches with | on |
---|---|
centres | branches.encoded_key = centres.assigned_branch_key |
deposit_transactions | branches.encoded_key = deposit_transactions.branch_key |
groups | branches.encoded_key = groups.assigned_branch_key |
loan_accounts | branches.encoded_key = loan_accounts.assigned_branch_key |
loan_transactions | branches.encoded_key = loan_transactions.branch_key |
users | branches.encoded_key = users.access.managed_branches.branch_key |
addresses ARRAY This is a nested data structure:
|
branch_holidays ARRAY This is a nested data structure:
|
creation_date DATE-TIME |
custom_fields ARRAY |
email_address STRING |
encoded_key STRING |
id STRING |
last_modified_date DATE-TIME |
name STRING |
notes STRING |
phone_number STRING |
state STRING |
cards
This table contains information about cards.
Note: In order to replicate this table, you must also set the deposit-account table to replicate.
Replication Method | Full Table |
Primary Keys | deposit_id reference_token |
deposit-account | |
Useful links |
deposit_id STRING |
reference_token STRING |
centres
This table contains information about centres.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
Join centres with | on |
---|---|
branches | centres.assigned_branch_key = branches.encoded_key |
deposit_transactions | centres.assigned_branch_key = deposit_transactions.branch_key centres.encoded_key = deposit_transactions.centre_key |
groups | centres.assigned_branch_key = groups.assigned_branch_key centres.encoded_key = groups.assigned_centre_key |
loan_accounts | centres.assigned_branch_key = loan_accounts.assigned_branch_key centres.encoded_key = loan_accounts.assigned_centre_key |
loan_transactions | centres.assigned_branch_key = loan_transactions.branch_key centres.encoded_key = loan_transactions.centre_key |
users | centres.assigned_branch_key = users.access.managed_branches.branch_key |
clients | centres.encoded_key = clients.assigned_centre_key |
addresses ARRAY This is a nested data structure:
|
assigned_branch_key STRING |
creation_date DATE-TIME |
custom_fields ARRAY |
encoded_key STRING |
id STRING |
last_modified_date DATE-TIME |
meeting_day STRING |
name STRING |
notes STRING |
state STRING |
clients
This table contains information about clients.
Replication Method | Full Table |
Primary Key | id |
Useful links |
Join clients with | on |
---|---|
centres | clients.assigned_centre_key = centres.encoded_key |
deposit_transactions | clients.assigned_centre_key = deposit_transactions.centre_key clients.assigned_user_key = deposit_transactions.user_key |
groups | clients.assigned_centre_key = groups.assigned_centre_key clients.encoded_key = groups.group_members.client_key clients.assigned_user_key = groups.assigned_user_key |
loan_accounts | clients.assigned_centre_key = loan_accounts.assigned_centre_key clients.assigned_user_key = loan_accounts.assigned_user_key |
loan_transactions | clients.assigned_centre_key = loan_transactions.centre_key clients.assigned_user_key = loan_transactions.user_key |
activities | clients.encoded_key = activities.client_key clients.assigned_user_key = activities.user_key |
communications | clients.encoded_key = communications.client_key clients.assigned_user_key = communications.user_key clients.assigned_user_key = communications.sender_key |
gl_journal_entries | clients.assigned_user_key = gl_journal_entries.user_key |
tasks | clients.assigned_user_key = tasks.created_by_user_key clients.assigned_user_key = tasks.assigned_user_key |
users | clients.assigned_user_key = users.encoded_key |
activation_date DATE-TIME |
addresses ARRAY This is a nested data structure:
|
approved_date DATE-TIME |
assigned_branch_key STRING |
assigned_centre_key STRING |
assigned_user_key STRING |
birth_date DATE |
client_role_key STRING |
closed_date DATE-TIME |
creation_date DATE-TIME |
custom_fields ARRAY |
email_address STRING |
encoded_key STRING |
first_name STRING |
gender STRING |
group_keys ARRAY |
group_loan_cycle INTEGER |
home_phone STRING |
id STRING |
id_documents ARRAY This is a nested data structure:
|
last_modified_date DATE-TIME |
last_name STRING |
loan_cycle INTEGER |
middle_name STRING |
migration_event_key STRING |
mobile_phone STRING |
mobile_phone2 STRING |
notes STRING |
portal_settings OBJECT This is a nested data structure:
|
preferred_language STRING |
profile_picture_key STRING |
profile_signature_key STRING |
state STRING |
communications
This table contains information about communications.
Replication Method | CDC |
Primary Key | encoded_key |
Replication Key | creation_date |
Useful links |
Join communications with | on |
---|---|
activities | communications.client_key = activities.client_key communications.user_key = activities.user_key communications.sender_key = activities.user_key |
clients | communications.client_key = clients.encoded_key communications.user_key = clients.assigned_user_key communications.sender_key = clients.assigned_user_key |
groups | communications.client_key = groups.group_members.client_key communications.group_key = groups.encoded_key communications.user_key = groups.assigned_user_key communications.sender_key = groups.assigned_user_key |
deposit_accounts | communications.deposit_account_key = deposit_accounts.encoded_key |
loan_accounts | communications.deposit_account_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key communications.deposit_account_key = loan_accounts.funding_sources.deposit_account_key communications.deposit_account_key = loan_accounts.guarantors.deposit_account_key communications.loan_account_key = loan_accounts.encoded_key communications.user_key = loan_accounts.assigned_user_key communications.sender_key = loan_accounts.assigned_user_key |
deposit_transactions | communications.user_key = deposit_transactions.user_key communications.sender_key = deposit_transactions.user_key |
gl_journal_entries | communications.user_key = gl_journal_entries.user_key communications.sender_key = gl_journal_entries.user_key |
loan_transactions | communications.user_key = loan_transactions.user_key communications.sender_key = loan_transactions.user_key |
tasks | communications.user_key = tasks.created_by_user_key communications.sender_key = tasks.created_by_user_key communications.user_key = tasks.assigned_user_key communications.sender_key = tasks.assigned_user_key |
users | communications.user_key = users.encoded_key communications.sender_key = users.encoded_key |
body STRING |
client_key STRING |
creation_date DATE-TIME |
custom_fields ARRAY |
deposit_account_key STRING |
destination STRING |
encoded_key STRING |
event STRING |
failure_cause STRING |
failure_reason STRING |
group_key STRING |
loan_account_key STRING |
num_retries INTEGER |
reference_id STRING |
repayment_key STRING |
send_date DATE-TIME |
sender_key STRING |
state STRING |
subject STRING |
template_key STRING |
type STRING |
user_key STRING |
credit_arrangements
This table contains information about credit arrangements.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
Join credit_arrangements with | on |
---|---|
deposit_accounts | credit_arrangements.encoded_key = deposit_accounts.credit_arrangement_key |
loan_accounts | credit_arrangements.encoded_key = loan_accounts.credit_arrangement_key |
amount NUMBER |
approved_date DATE-TIME |
available_credit_amount NUMBER |
closed_date DATE-TIME |
consumed_credit_amount NUMBER |
creation_date DATE-TIME |
currency OBJECT This is a nested data structure: code: STRING. |
custom_fields ARRAY |
encoded_key STRING |
expire_date DATE-TIME |
exposure_limit_type STRING |
holder_key STRING |
holder_type STRING |
id STRING |
last_modified_date DATE-TIME |
notes STRING |
start_date DATE-TIME |
state STRING |
sub_state STRING |
custom_field_sets
This table contains information about custom field sets.
Replication Method | Full Table |
Primary Key | id |
Useful links |
available_for STRING |
creation_date DATE-TIME |
custom_fields ARRAY |
dependent_field_key STRING |
display_settings OBJECT This is a nested data structure:
|
edit_rights OBJECT This is a nested data structure:
|
encoded_key STRING |
id STRING |
last_modified_date DATE-TIME |
selection_options ARRAY This is a nested data structure:
|
state STRING |
type STRING |
usage ARRAY This is a nested data structure:
|
value_validation_settings OBJECT This is a nested data structure:
|
view_rights OBJECT This is a nested data structure:
|
deposit_accounts
This table contains information about deposit accounts.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
Join deposit_accounts with | on |
---|---|
credit_arrangements | deposit_accounts.credit_arrangement_key = credit_arrangements.encoded_key |
loan_accounts | deposit_accounts.credit_arrangement_key = loan_accounts.credit_arrangement_key deposit_accounts.encoded_key = loan_accounts.disbursement_details.transaction_details.target_deposit_account_key deposit_accounts.encoded_key = loan_accounts.funding_sources.deposit_account_key deposit_accounts.encoded_key = loan_accounts.guarantors.deposit_account_key |
communications | deposit_accounts.encoded_key = communications.deposit_account_key |
account_holder_key STRING |
account_holder_type STRING |
account_state STRING |
account_type STRING |
accrued_amounts OBJECT This is a nested data structure:
|
activation_date DATE-TIME |
approved_date DATE-TIME |
assigned_branch_key STRING |
assigned_centre_key STRING |
assigned_user_key STRING |
balances OBJECT This is a nested data structure:
|
closed_date DATE-TIME |
creation_date DATE-TIME |
credit_arrangement_key STRING |
currency_code STRING |
custom_fields ARRAY |
encoded_key STRING |
id STRING |
interest_settings OBJECT This is a nested data structure:
|
internal_controls OBJECT This is a nested data structure:
|
last_account_appraisal_date DATE-TIME |
last_interest_calculation_date DATE-TIME |
last_interest_stored_date DATE-TIME |
last_modified_date DATE-TIME |
last_overdraft_interest_review_date DATE-TIME |
last_set_to_arrears_date DATE-TIME |
linked_settlement_account_keys ARRAY |
locked_date DATE-TIME |
maturity_date DATE-TIME |
migration_event_key STRING |
name STRING |
notes STRING |
overdraft_interest_settings OBJECT This is a nested data structure:
|
overdraft_settings OBJECT This is a nested data structure:
|
product_type_key STRING |
withholding_tax_source_key STRING |
deposit_products
This table contains information about deposit (savings) products.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
accounting_settings OBJECT This is a nested data structure:
|
availability_settings OBJECT This is a nested data structure:
|
category STRING |
creation_date DATE-TIME |
credit_arrangement_settings OBJECT This is a nested data structure: credit_arrangement_requirement, STRING. |
currency_settings OBJECT This is a nested data structure: currencies: ARRAY, which is also a nested data structure:
|
custom_fields ARRAY |
encoded_key STRING |
fees_settings OBJECT This is a nested data structure:
|
id STRING |
interest_settings OBJECT This is a nested data structure:
|
internal_controls OBJECT This is a nested data structure:
|
last_modified_date DATE-TIME |
maturity_settings OBJECT This is a nested data structure:
|
name STRING |
new_account_settings OBJECT This is a nested data structure:
|
notes STRING |
offset_settings OBJECT This is a nested data structure: allow_offset, BOOLEAN.
|
overdraft_interest_settings OBJECT This is a nested data structure:
|
overdraft_settings OBJECT This is a nested data structure:
|
state STRING |
tax_settings OBJECT This is a nested data structure: withholding_tax_enabled, BOOLEAN. |
templates ARRAY This is a nested data structure:
|
type STRING |
deposit_transactions
This table contains information about deposit transactions.
Replication Method | CDC |
Primary Key | encoded_key |
Replication Key | creation_date |
Useful links |
Join deposit_transactions with | on |
---|---|
branches | deposit_transactions.branch_key = branches.encoded_key |
centres | deposit_transactions.branch_key = centres.assigned_branch_key deposit_transactions.centre_key = centres.encoded_key |
groups | deposit_transactions.branch_key = groups.assigned_branch_key deposit_transactions.centre_key = groups.assigned_centre_key deposit_transactions.user_key = groups.assigned_user_key |
loan_accounts | deposit_transactions.branch_key = loan_accounts.assigned_branch_key deposit_transactions.centre_key = loan_accounts.assigned_centre_key deposit_transactions.user_key = loan_accounts.assigned_user_key |
loan_transactions | deposit_transactions.branch_key = loan_transactions.branch_key deposit_transactions.centre_key = loan_transactions.centre_key deposit_transactions.transfer_details.linked_deposit_transaction_key = loan_transactions.transfer_details.linked_deposit_transaction_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.encoded_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.parent_loan_transaction_key deposit_transactions.transfer_details.linked_loan_transaction_key = loan_transactions.transfer_details.linked_loan_transaction_key deposit_transactions.user_key = loan_transactions.user_key |
users | deposit_transactions.branch_key = users.access.managed_branches.branch_key deposit_transactions.user_key = users.encoded_key |
clients | deposit_transactions.centre_key = clients.assigned_centre_key deposit_transactions.user_key = clients.assigned_user_key |
activities | deposit_transactions.user_key = activities.user_key |
communications | deposit_transactions.user_key = communications.user_key deposit_transactions.user_key = communications.sender_key |
gl_journal_entries | deposit_transactions.user_key = gl_journal_entries.user_key |
tasks | deposit_transactions.user_key = tasks.created_by_user_key deposit_transactions.user_key = tasks.assigned_user_key |
account_balances OBJECT This is a nested data structure: total_balance, NUMBER. |
adjustment_transaction_key STRING |
affected_amounts OBJECT This is a nested data structure:
|
amount NUMBER |
block_id STRING |
booking_date DATE-TIME |
branch_key STRING |
card_transaction OBJECT This is a nested data structure:
|
centre_key STRING |
creation_date DATE-TIME |
currency_code STRING |
custom_fields ARRAY |
encoded_key STRING |
external_id STRING |
fees ARRAY This is a nested data structure:
|
hold_external_reference_id STRING |
id STRING |
interest_accrued_amounts OBJECT This is a nested data structure:
|
migration_event_key STRING |
notes STRING |
original_transaction_key STRING |
parent_account_key STRING |
payment_details OBJECT This is a nested data structure:
|
payment_order_id STRING |
taxes OBJECT This is a nested data structure: tax_rate: NUMBER. |
terms OBJECT This is a nested data structure:
|
till_key STRING |
transaction_details OBJECT This is a nested data structure:
|
transfer_details OBJECT This is a nested data structure:
|
type STRING |
user_key STRING |
value_date DATE-TIME |
gl_accounts
This table contains information about general ledger accounts.
Replication Method | CDC |
Primary Key | gl_code |
Replication Key | last_modified_date |
Useful links |
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 This is a nested data structure: code, STRING. |
custom_fields ARRAY |
description STRING |
encoded_key STRING |
gl_code STRING |
last_modified_date DATE-TIME |
migration_event_key STRING |
name STRING |
strip_trailing_zeros BOOLEAN |
type STRING |
usage STRING |
gl_journal_entries
This table contains information about general ledger entries.
Replication Method | CDC |
Primary Key | entry_id |
Replication Key | booking_date |
Useful links |
Join gl_journal_entries with | on |
---|---|
gl_accounts | gl_journal_entries.gl_account.gl_code = gl_accounts.gl_code |
activities | gl_journal_entries.user_key = activities.user_key |
clients | gl_journal_entries.user_key = clients.assigned_user_key |
communications | gl_journal_entries.user_key = communications.user_key gl_journal_entries.user_key = communications.sender_key |
deposit_transactions | gl_journal_entries.user_key = deposit_transactions.user_key |
groups | gl_journal_entries.user_key = groups.assigned_user_key |
loan_accounts | gl_journal_entries.user_key = loan_accounts.assigned_user_key |
loan_transactions | gl_journal_entries.user_key = loan_transactions.user_key |
tasks | gl_journal_entries.user_key = tasks.created_by_user_key gl_journal_entries.user_key = tasks.assigned_user_key |
users | gl_journal_entries.user_key = users.encoded_key |
account_key STRING |
amount NUMBER |
assigned_branch_key STRING |
booking_date DATE-TIME |
creation_date DATE-TIME |
custom_fields ARRAY |
encoded_key STRING |
entry_id INTEGER |
foreign_amount OBJECT This is a nested data structure:
|
gl_account OBJECT This is a nested data structure:
|
notes STRING |
product_key STRING |
product_type STRING |
reversal_entry_key STRING |
transaction_id STRING |
type STRING |
user_key STRING |
groups
This table contains information about groups.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
Join groups with | on |
---|---|
branches | groups.assigned_branch_key = branches.encoded_key |
centres | groups.assigned_branch_key = centres.assigned_branch_key groups.assigned_centre_key = centres.encoded_key |
deposit_transactions | groups.assigned_branch_key = deposit_transactions.branch_key groups.assigned_centre_key = deposit_transactions.centre_key groups.assigned_user_key = deposit_transactions.user_key |
loan_accounts | groups.assigned_branch_key = loan_accounts.assigned_branch_key groups.assigned_centre_key = loan_accounts.assigned_centre_key groups.assigned_user_key = loan_accounts.assigned_user_key |
loan_transactions | groups.assigned_branch_key = loan_transactions.branch_key groups.assigned_centre_key = loan_transactions.centre_key groups.assigned_user_key = loan_transactions.user_key |
users | groups.assigned_branch_key = users.access.managed_branches.branch_key groups.assigned_user_key = users.encoded_key |
clients | groups.assigned_centre_key = clients.assigned_centre_key groups.group_members.client_key = clients.encoded_key groups.assigned_user_key = clients.assigned_user_key |
activities | groups.group_members.client_key = activities.client_key groups.assigned_user_key = activities.user_key |
communications | groups.group_members.client_key = communications.client_key groups.encoded_key = communications.group_key groups.assigned_user_key = communications.user_key groups.assigned_user_key = communications.sender_key |
gl_journal_entries | groups.assigned_user_key = gl_journal_entries.user_key |
tasks | groups.assigned_user_key = tasks.created_by_user_key groups.assigned_user_key = tasks.assigned_user_key |
addresses ARRAY This is a nested data structure:
|
assigned_branch_key STRING |
assigned_centre_key STRING |
assigned_user_key STRING |
creation_date DATE-TIME |
custom_fields ARRAY |
email_address STRING |
encoded_key STRING |
group_members ARRAY This is a nested data structure:
|
group_name STRING |
group_role_key STRING |
home_phone STRING |
id STRING |
last_modified_date DATE-TIME |
loan_cycle INTEGER |
migration_event_key STRING |
mobile_phone STRING |
notes STRING |
preferred_language STRING |
index_rate_sources
This table contains information about index rate sources.
Replication Method | Full Table |
Primary Key | encoded_key |
Useful links |
custom_fields ARRAY |
encoded_key STRING |
id STRING |
name STRING |
notes STRING |
type STRING |
installments
This table contains information about installments for a loan.
Replication Method | CDC |
Primary Key | encoded_key |
Replication Key | last_paid_date |
Useful links |
custom_fields ARRAY |
due_date DATE-TIME |
encoded_key STRING |
fee OBJECT This is a nested data structure:
|
fee_details ARRAY This is a nested data structure:
|
interest OBJECT This is a nested data structure:
|
is_payment_holiday BOOLEAN |
last_paid_date DATE-TIME |
number STRING |
parent_account_key STRING |
penalty OBJECT This is a nested data structure:
|
principal OBJECT This is a nested data structure:
|
repaid_date DATE-TIME |
state STRING |
interest_accrual_breakdown
This table contains information about interest accruals.
Replication Method | CDC |
Primary Key | entry_id |
Replication Key | creation_date |
account_id STRING |
account_key STRING |
amount NUMBER |
booking_date DATE-TIME |
branch_key STRING |
branch_name STRING |
creation_date DATE-TIME |
custom_fields ARRAY |
entry_id INTEGER |
entry_type STRING |
foreign_amount OBJECT This is a nested data structure:
|
gl_account_id STRING |
gl_account_key STRING |
gl_account_name STRING |
gl_account_type STRING |
parent_entry_id INTEGER |
product_id STRING |
product_key STRING |
product_type STRING |
transaction_id STRING |
loan_accounts
This table contains information about Loan Accounts.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
Join loan_accounts with | on |
---|---|
branches | loan_accounts.assigned_branch_key = branches.encoded_key |
centres | loan_accounts.assigned_branch_key = centres.assigned_branch_key loan_accounts.assigned_centre_key = centres.encoded_key |
deposit_transactions | loan_accounts.assigned_branch_key = deposit_transactions.branch_key loan_accounts.assigned_centre_key = deposit_transactions.centre_key loan_accounts.assigned_user_key = deposit_transactions.user_key |
groups | loan_accounts.assigned_branch_key = groups.assigned_branch_key loan_accounts.assigned_centre_key = groups.assigned_centre_key loan_accounts.assigned_user_key = groups.assigned_user_key |
loan_transactions | loan_accounts.assigned_branch_key = loan_transactions.branch_key loan_accounts.assigned_centre_key = loan_transactions.centre_key loan_accounts.assigned_user_key = loan_transactions.user_key |
users | loan_accounts.assigned_branch_key = users.access.managed_branches.branch_key loan_accounts.assigned_user_key = users.encoded_key |
clients | loan_accounts.assigned_centre_key = clients.assigned_centre_key loan_accounts.assigned_user_key = clients.assigned_user_key |
credit_arrangements | loan_accounts.credit_arrangement_key = credit_arrangements.encoded_key |
deposit_accounts | loan_accounts.credit_arrangement_key = deposit_accounts.credit_arrangement_key loan_accounts.disbursement_details.transaction_details.target_deposit_account_key = deposit_accounts.encoded_key loan_accounts.funding_sources.deposit_account_key = deposit_accounts.encoded_key loan_accounts.guarantors.deposit_account_key = deposit_accounts.encoded_key |
communications | loan_accounts.disbursement_details.transaction_details.target_deposit_account_key = communications.deposit_account_key loan_accounts.funding_sources.deposit_account_key = communications.deposit_account_key loan_accounts.guarantors.deposit_account_key = communications.deposit_account_key loan_accounts.encoded_key = communications.loan_account_key loan_accounts.assigned_user_key = communications.user_key loan_accounts.assigned_user_key = communications.sender_key |
activities | loan_accounts.assigned_user_key = activities.user_key |
gl_journal_entries | loan_accounts.assigned_user_key = gl_journal_entries.user_key |
tasks | loan_accounts.assigned_user_key = tasks.created_by_user_key loan_accounts.assigned_user_key = tasks.assigned_user_key |
account_arrears_settings OBJECT This is a nested data structure:
|
account_holder_key STRING |
account_holder_type STRING |
account_state STRING |
account_sub_state STRING |
accrued_interest NUMBER |
accrued_penalty NUMBER |
activation_transaction_key STRING |
allow_offset BOOLEAN |
approved_date DATE-TIME |
arrears_tolerance_period INTEGER |
assets ARRAY This is a nested data structure:
|
assigned_branch_key STRING |
assigned_centre_key STRING |
assigned_user_key STRING |
balances OBJECT This is a nested data structure:
|
closed_date DATE-TIME |
creation_date DATE-TIME |
credit_arrangement_key STRING |
currency OBJECT This is a nested data structure: code, STRING. |
custom_fields ARRAY |
days_in_arrears INTEGER |
days_late INTEGER |
disbursement_details OBJECT This is a nested data structure:
|
encoded_key STRING |
funding_sources ARRAY This is a nested data structure:
|
future_payments_acceptance STRING |
guarantors ARRAY This is a nested data structure:
|
id STRING |
interest_accrued_in_billing_cycle NUMBER |
interest_commission NUMBER |
interest_from_arrears_accrued NUMBER |
interest_settings OBJECT This is a nested data structure:
|
last_account_appraisal_date DATE-TIME |
last_interest_applied_date DATE-TIME |
last_interest_review_date DATE-TIME |
last_locked_date DATE-TIME |
last_modified_date DATE-TIME |
last_set_to_arrears_date DATE-TIME |
last_tax_rate_review_date DATE-TIME |
late_payments_recalculation_method STRING |
loan_amount NUMBER |
loan_name STRING |
locked_operations ARRAY |
migration_event_key STRING |
modify_interest_for_first_installment BOOLEAN |
notes STRING |
original_account_key STRING |
payment_holidays_accrued_interest NUMBER |
payment_method STRING |
penalty_settings OBJECT This is a nested data structure:
|
planned_installment_fees ARRAY This is a nested data structure:
|
prepayment_settings OBJECT This is a nested data structure:
|
principal_payment_settings OBJECT This is a nested data structure:
|
product_type_key STRING |
redraw_settings OBJECT This is a nested data structure: restrict_next_due_withdrawal, BOOLEAN. |
rescheduled_account_key STRING |
schedule_settings OBJECT This is a nested data structure:
|
settlement_account_key STRING |
tax_rate NUMBER |
termination_date DATE-TIME |
tranches ARRAY This is a nested data structure:
|
loan_products
This table contains information about loan products.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
account_link_settings OBJECT This is a nested data structure:
|
accounting_settings OBJECT This is a nested data structure:
|
adjust_interest_for_first_installment BOOLEAN |
allow_custom_repayment_allocation BOOLEAN |
arrears_settings OBJECT This is a nested data structure:
|
availability_settings OBJECT This is a nested data structure:
|
category STRING |
creation_date DATE-TIME |
credit_arrangement_settings OBJECT This is a nested data structure: credit_arrangement_requirement, STRING. |
currency OBJECT This is a nested data structure: code, STRING. |
custom_fields ARRAY |
encoded_key STRING |
fees_settings OBJECT This is a nested data structure:
|
funding_settings OBJECT This is a nested data structure:
|
grace_period_settings OBJECT This is a nested data structure:
|
id STRING |
interest_settings OBJECT This is a nested data structure:
|
internal_controls OBJECT This is a nested data structure:
|
last_modified_date DATE-TIME |
loan_amount_settings OBJECT This is a nested data structure:
|
name STRING |
new_account_settings OBJECT This is a nested data structure:
|
notes STRING |
offset_settings OBJECT This is a nested data structure: allow_offset, BOOLEAN. |
payment_settings OBJECT This is a nested data structure:
|
penalty_settings OBJECT This is a nested data structure:
|
redraw_settings OBJECT This is a nested data structure: allow_redraw, BOOLEAN. |
schedule_settings OBJECT This is a nested data structure:
|
security_settings OBJECT This is a nested data structure:
|
state STRING |
tax_settings OBJECT This is a nested data structure:
|
templates ARRAY This is a nested data structure:
|
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 |
assigned_branch_key STRING |
assigned_centre_key STRING |
assigned_user_key STRING |
custom_settings ARRAY This is a nested data structure:
|
due_date DATE-TIME |
encoded_key STRING |
fees_applied_due NUMBER |
fees_due NUMBER |
fees_paid NUMBER |
fees_unapplied_due NUMBER |
funders_interest_due NUMBER |
index NUMBER |
interest_due NUMBER |
interest_paid NUMBER |
last_paid_date DATE-TIME |
last_penalty_applied_date DATE-TIME |
notes STRING |
organization_commission_due NUMBER |
parent_account_key STRING |
penalty_due NUMBER |
penalty_paid NUMBER |
principal_due NUMBER |
principal_paid NUMBER |
repaid_date DATE-TIME |
repayment_unapplied_fee_details ARRAY This is a nested data structure:
|
state STRING |
tax_fees_due NUMBER |
tax_fees_paid NUMBER |
tax_interest_due NUMBER |
tax_interest_paid NUMBER |
tax_penalty_due NUMBER |
tax_penalty_paid NUMBER |
loan_transactions
This table contains information about loan transactions.
Replication Method | CDC |
Primary Key | encoded_key |
Replication Key | creation_date |
Useful links |
Join loan_transactions with | on |
---|---|
branches | loan_transactions.branch_key = branches.encoded_key |
centres | loan_transactions.branch_key = centres.assigned_branch_key loan_transactions.centre_key = centres.encoded_key |
deposit_transactions | loan_transactions.branch_key = deposit_transactions.branch_key loan_transactions.centre_key = deposit_transactions.centre_key loan_transactions.transfer_details.linked_deposit_transaction_key = deposit_transactions.transfer_details.linked_deposit_transaction_key loan_transactions.encoded_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.parent_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.transfer_details.linked_loan_transaction_key = deposit_transactions.transfer_details.linked_loan_transaction_key loan_transactions.user_key = deposit_transactions.user_key |
groups | loan_transactions.branch_key = groups.assigned_branch_key loan_transactions.centre_key = groups.assigned_centre_key loan_transactions.user_key = groups.assigned_user_key |
loan_accounts | loan_transactions.branch_key = loan_accounts.assigned_branch_key loan_transactions.centre_key = loan_accounts.assigned_centre_key loan_transactions.user_key = loan_accounts.assigned_user_key |
users | loan_transactions.branch_key = users.access.managed_branches.branch_key loan_transactions.user_key = users.encoded_key |
clients | loan_transactions.centre_key = clients.assigned_centre_key loan_transactions.user_key = clients.assigned_user_key |
activities | loan_transactions.user_key = activities.user_key |
communications | loan_transactions.user_key = communications.user_key loan_transactions.user_key = communications.sender_key |
gl_journal_entries | loan_transactions.user_key = gl_journal_entries.user_key |
tasks | loan_transactions.user_key = tasks.created_by_user_key loan_transactions.user_key = tasks.assigned_user_key |
account_balances OBJECT This is a nested data structure:
|
adjustment_transaction_key STRING |
affected_amounts OBJECT This is a nested data structure:
|
amount NUMBER |
booking_date DATE-TIME |
branch_key STRING |
card_transaction OBJECT This is a nested data structure:
|
centre_key STRING |
creation_date DATE-TIME |
currency OBJECT This is a nested data structure: code, STRING. |
custom_fields ARRAY |
custom_payment_amounts ARRAY This is a nested data structure:
|
encoded_key STRING |
external_id STRING |
fees ARRAY This is a nested data structure:
|
id STRING |
installment_encoded_key STRING |
migration_event_key STRING |
notes STRING |
original_amount NUMBER |
original_currency_code STRING |
original_transaction_key STRING |
parent_account_key STRING |
parent_loan_transaction_key STRING |
prepayment_recalculation_method STRING |
taxes OBJECT This is a nested data structure:
|
terms OBJECT This is a nested data structure:
|
till_key STRING |
transaction_details OBJECT This is a nested data structure:
|
transfer_details OBJECT This is a nested data structure:
|
type STRING |
user_key STRING |
value_date DATE-TIME |
tasks
This table contains information about tasks.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
Join tasks with | on |
---|---|
activities | tasks.created_by_user_key = activities.user_key tasks.assigned_user_key = activities.user_key |
clients | tasks.created_by_user_key = clients.assigned_user_key tasks.assigned_user_key = clients.assigned_user_key |
communications | tasks.created_by_user_key = communications.user_key tasks.assigned_user_key = communications.user_key tasks.created_by_user_key = communications.sender_key tasks.assigned_user_key = communications.sender_key |
deposit_transactions | tasks.created_by_user_key = deposit_transactions.user_key tasks.assigned_user_key = deposit_transactions.user_key |
gl_journal_entries | tasks.created_by_user_key = gl_journal_entries.user_key tasks.assigned_user_key = gl_journal_entries.user_key |
groups | tasks.created_by_user_key = groups.assigned_user_key tasks.assigned_user_key = groups.assigned_user_key |
loan_accounts | tasks.created_by_user_key = loan_accounts.assigned_user_key tasks.assigned_user_key = loan_accounts.assigned_user_key |
loan_transactions | tasks.created_by_user_key = loan_transactions.user_key tasks.assigned_user_key = loan_transactions.user_key |
users | tasks.created_by_user_key = users.encoded_key tasks.assigned_user_key = users.encoded_key |
assigned_user_key STRING |
created_by_full_name STRING |
created_by_user_key STRING |
creation_date DATE-TIME |
custom_fields ARRAY |
description STRING |
due_date DATE |
encoded_key STRING |
id INTEGER |
last_modified_date DATE-TIME |
status STRING |
task_link_key STRING |
task_link_type STRING |
template_key STRING |
title STRING |
users
This table contains information about users.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_date |
Useful links |
Join users with | on |
---|---|
branches | users.access.managed_branches.branch_key = branches.encoded_key |
centres | users.access.managed_branches.branch_key = centres.assigned_branch_key |
deposit_transactions | users.access.managed_branches.branch_key = deposit_transactions.branch_key users.encoded_key = deposit_transactions.user_key |
groups | users.access.managed_branches.branch_key = groups.assigned_branch_key users.encoded_key = groups.assigned_user_key |
loan_accounts | users.access.managed_branches.branch_key = loan_accounts.assigned_branch_key users.encoded_key = loan_accounts.assigned_user_key |
loan_transactions | users.access.managed_branches.branch_key = loan_transactions.branch_key users.encoded_key = loan_transactions.user_key |
activities | users.encoded_key = activities.user_key |
clients | users.encoded_key = clients.assigned_user_key |
communications | users.encoded_key = communications.user_key users.encoded_key = communications.sender_key |
gl_journal_entries | users.encoded_key = gl_journal_entries.user_key |
tasks | users.encoded_key = tasks.created_by_user_key users.encoded_key = tasks.assigned_user_key |
access OBJECT This is a nested data structure:
|
assigned_branch_key STRING |
creation_date DATE-TIME |
custom_fields ARRAY |
STRING |
encoded_key STRING |
first_name STRING |
home_phone STRING |
id STRING |
language STRING |
last_logged_in_date DATE-TIME |
last_modified_date DATE-TIME |
last_name STRING |
mobile_phone STRING |
notes STRING |
role OBJECT This is a nested data structure:
|
title STRING |
transaction_limits OBJECT |
two_factor_authentication BOOLEAN |
user_state STRING |
username STRING |