# Mambu schema ERD

Table and field reference for the Fivetran Mambu connector.

## Table & Field Reference

### group_address

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| groups_encoded_key | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| index_in_list | Unknown |  |
| latitude | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| longitude | Unknown |  |
| parent_key | Unknown |  |
| postcode | Unknown |  |
| region | Unknown |  |

### group_members_role

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| group_member_index | Unknown | PK, FK |
| groups_encoded_key | Unknown | PK, FK |
| group_role_name_key | Unknown |  |
| role_name | Unknown |  |
| role_name_id | Unknown |  |

### group_member

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| client_key | Unknown | FK |
| groups_encoded_key | Unknown | FK |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| assigned_branch_key | Unknown | FK |
| assigned_centre_key | Unknown | FK |
| assigned_user_key | Unknown | FK |
| creation_date | Unknown |  |
| email_address | Unknown |  |
| group_name | Unknown |  |
| group_role_key | Unknown |  |
| home_phone | Unknown |  |
| id | Unknown |  |
| last_modified_date | Instant |  |
| legal_form_type | Unknown |  |
| loan_cycle | Unknown |  |
| migration_event_key | Unknown |  |
| mobile_phone | Unknown |  |
| note | Unknown |  |
| preferred_language | Unknown |  |

### custom_field_usage

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| custom_field_encoded_key | Unknown | PK, FK |
| defaults | Unknown |  |
| object_key | Unknown |  |
| required | Unknown |  |

### custom_field_available_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| custom_field_encoded_key | Unknown | PK, FK |
| custom_field_selection_option_index | Unknown | PK, FK |
| score | Unknown |  |
| selection_key | Unknown |  |
| value | Unknown |  |

### custom_field_selection_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| custom_field_encoded_key | Unknown | PK, FK |
| for_selection_key | Unknown |  |
| for_value | Unknown |  |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| custom_field_set_custom_field_encoded_key | Unknown | FK |
| available_for | Unknown |  |
| creation_date | Unknown |  |
| dependent_field_key | Unknown |  |
| display_settings_built_in_id | Unknown |  |
| display_settings_description | Unknown |  |
| display_settings_display_name | Unknown |  |
| display_settings_field_size | Unknown |  |
| display_settings_name | Unknown |  |
| display_settings_position | Unknown |  |
| edit_rights_all_user | Unknown |  |
| edit_rights_role | Json |  |
| id | Unknown |  |
| last_modified_date | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| uniques | Unknown |  |
| validation_pattern | Unknown |  |
| view_rights_all_user | Unknown |  |
| view_rights_role | Json |  |

### deposit_transaction_fee

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deposit_transaction_encoded_key | Unknown | PK, FK |
| amount | Unknown |  |
| name | Unknown |  |
| predefined_fee_key | Unknown |  |
| tax_amount | Unknown |  |
| trigger | Unknown |  |

### deposit_transaction

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_account_encoded_key | Unknown | FK |
| account_balances_total_balance | Unknown |  |
| adjustment_transaction_key | Unknown |  |
| affected_amounts_fees_amount | Unknown |  |
| affected_amounts_fraction_amount | Unknown |  |
| affected_amounts_funds_amount | Unknown |  |
| affected_amounts_interest_amount | Unknown |  |
| affected_amounts_overdraft_amount | Unknown |  |
| affected_amounts_overdraft_fees_amount | Unknown |  |
| affected_amounts_overdraft_interest_amount | Unknown |  |
| affected_amounts_technical_overdraft_amount | Unknown |  |
| affected_amounts_technical_overdraft_interest_amount | Unknown |  |
| amount | Unknown |  |
| block_id | Unknown |  |
| booking_date | Unknown |  |
| branch_key | Unknown |  |
| card_acceptor_city | Unknown |  |
| card_acceptor_country | Unknown |  |
| card_acceptor_mcc | Unknown |  |
| card_acceptor_name | Unknown |  |
| card_acceptor_state | Unknown |  |
| card_acceptor_street | Unknown |  |
| card_acceptor_zip | Unknown |  |
| card_transaction_advice | Unknown |  |
| card_transaction_amount | Unknown |  |
| card_transaction_card_token | Unknown |  |
| card_transaction_currency_code | Unknown |  |
| card_transaction_encoded_key | Unknown |  |
| card_transaction_external_authorization_reference_id | Unknown |  |
| card_transaction_external_reference_id | Unknown |  |
| card_transaction_user_transaction_time | Unknown |  |
| centre_key | Unknown |  |
| creation_date | Unknown |  |
| currency_code | Unknown |  |
| external_id | Unknown |  |
| hold_external_reference_id | Unknown |  |
| id | Unknown |  |
| interest_accrued_amounts_interest_accrued | Unknown |  |
| interest_accrued_amounts_negative_interest_accrued | Unknown |  |
| interest_accrued_amounts_overdraft_interest_accrued | Unknown |  |
| interest_accrued_amounts_technical_overdraft_interest_accrued | Unknown |  |
| linked_deposit_transaction_key | Unknown |  |
| linked_loan_transaction_key | Unknown |  |
| migration_event_key | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| original_transaction_key | Unknown |  |
| parent_account_key | Unknown |  |
| payment_details_creditor_account_currency | Unknown |  |
| payment_details_creditor_account_identification_iban | Unknown |  |
| payment_details_creditor_account_identification_other_identification | Unknown |  |
| payment_details_creditor_account_identification_other_scheme | Unknown |  |
| payment_details_creditor_agent_financial_institution_identification_bic | Unknown |  |
| payment_details_creditor_name | Unknown |  |
| payment_details_debtor_account_currency | Unknown |  |
| payment_details_debtor_account_identification_iban | Unknown |  |
| payment_details_debtor_account_identification_other_identification | Unknown |  |
| payment_details_debtor_account_identification_other_scheme | Unknown |  |
| payment_details_debtor_agent_financial_institution_identification_bic | Unknown |  |
| payment_details_debtor_name | Unknown |  |
| payment_details_payment_identification_end_to_end_identification | Unknown |  |
| payment_details_payment_identification_instruction_identification | Unknown |  |
| payment_details_payment_identification_transaction_identification | Unknown |  |
| payment_details_payment_type_information_service_level_code | Unknown |  |
| payment_details_remittance_information_structured_creditor_reference_information_reference | Unknown |  |
| payment_details_remittance_information_structured_creditor_reference_information_reference_issuer | Unknown |  |
| payment_details_remittance_information_structured_creditor_reference_information_reference_type | Unknown |  |
| payment_details_remittance_information_unstructured | Unknown |  |
| payment_order_id | Unknown |  |
| taxes_tax_rate | Unknown |  |
| terms_interest_settings_index_interest_rate | Unknown |  |
| terms_interest_settings_interest_rate | Unknown |  |
| terms_overdraft_interest_settings_index_interest_rate | Unknown |  |
| terms_overdraft_interest_settings_interest_rate | Unknown |  |
| terms_overdraft_settings_overdraft_limit | Unknown |  |
| till_key | Unknown |  |
| transaction_channel_id | Unknown |  |
| transaction_channel_key | Unknown |  |
| type | Unknown |  |
| user_key | Unknown |  |
| value_date | Unknown |  |

### centre_address

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| centre_encoded_key | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| index_in_list | Unknown |  |
| latitude | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| longitude | Unknown |  |
| parent_key | Unknown |  |
| postcode | Unknown |  |
| region | Unknown |  |

### centre

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| assigned_branch_key | Unknown | FK |
| creation_date | Unknown |  |
| id | Unknown |  |
| last_modified_date | Instant |  |
| meeting_day | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| state | Unknown |  |
| custom_** |  |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| assigned_user_key | Unknown | FK |
| created_by_full_name | Unknown |  |
| created_by_user_key | Unknown |  |
| creation_date | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| id | Unknown |  |
| last_modified_date | Unknown |  |
| status | Unknown |  |
| task_link_key | Unknown |  |
| task_link_type | Unknown |  |
| template_key | Unknown |  |
| title | Unknown |  |

### deposit_account_authorization_hold

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_account_encoded_key | Unknown | FK |
| account_id | Unknown |  |
| account_key | Unknown |  |
| advice | Unknown |  |
| amount | Unknown |  |
| available_balance | Unknown |  |
| balance_currency_code | Unknown |  |
| card_token | Unknown |  |
| card_type | Unknown |  |
| creation_date | Unknown |  |
| credit_debit_indicator | Unknown |  |
| credit_limit | Unknown |  |
| currency_code | Unknown |  |
| custom_expiration_period | Unknown |  |
| exchange_rate | Unknown |  |
| external_reference_id | Unknown |  |
| original_amount | Unknown |  |
| original_currency | Unknown |  |
| reference_date_for_expiration | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| total_balance | Unknown |  |
| user_transaction_time | Unknown |  |

### loan_account_authorization_hold

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_account_encoded_key | Unknown | FK |
| account_key | Unknown |  |
| advice | Unknown |  |
| amount | Unknown |  |
| balances_account_id | Unknown |  |
| balances_available_balance | Unknown |  |
| balances_card_type | Unknown |  |
| balances_credit_limit | Unknown |  |
| balances_currency_code | Unknown |  |
| balances_total_balance | Unknown |  |
| creation_date | Unknown |  |
| credit_debit_indicator | Unknown |  |
| currency_code | Unknown |  |
| custom_expiration_period | Unknown |  |
| exchange_rate | Unknown |  |
| external_reference_id | Unknown |  |
| original_currency | Unknown |  |
| reference_date_for_expiration | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |

### loan_account_card

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| loan_account_encoded_key | Unknown | PK, FK |
| reference_token | Unknown |  |

### deposit_account_card

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| deposit_account_encoded_key | Unknown | PK, FK |
| reference_token | Unknown |  |

### loan_product_interest_rate_tier

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_product_index_rate_settings_encoded_key | Unknown | PK |
| loan_product_encoded_key | Unknown | PK, FK |
| ending_balance | Unknown |  |
| interest_rate | Unknown |  |

### loan_product_interest_rate_setting

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_product_encoded_key | Unknown | FK |
| index_source_key | Unknown |  |
| interest_rate_ceiling_value | Unknown |  |
| interest_rate_default_value | Unknown |  |
| interest_rate_floor_value | Unknown |  |
| interest_rate_max_value | Unknown |  |
| interest_rate_min_value | Unknown |  |
| interest_rate_review_count | Unknown |  |
| interest_rate_review_unit | Unknown |  |
| interest_rate_source | Unknown |  |

### loan_product_fee_settings_accounting_rule

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_product_encoded_key | Unknown | PK, FK |
| loan_product_fee_encoded_key | Unknown | PK, FK |
| financial_resource | Unknown |  |
| gl_account_key | Unknown |  |
| transaction_channel_key | Unknown |  |

### loan_product_fee

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_product_encoded_key | Unknown | FK |
| amortization_settings_amortization_profile | Unknown |  |
| amortization_settings_encoded_key | Unknown |  |
| amortization_settings_fee_amortization_upon_reschedule_refinance_option | Unknown |  |
| amortization_settings_frequency | Unknown |  |
| amortization_settings_interval_count | Unknown |  |
| amortization_settings_interval_type | Unknown |  |
| amortization_settings_period_count | Unknown |  |
| amortization_settings_period_unit | Unknown |  |
| amount | Unknown |  |
| amount_calculation_function_name | Unknown |  |
| amount_calculation_method | Unknown |  |
| apply_date_method | Unknown |  |
| creation_date | Unknown |  |
| fee_application | Unknown |  |
| id | Unknown |  |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| percentage_amount | Unknown |  |
| state | Unknown |  |
| tax_settings_taxable_calculation_method | Unknown |  |
| trigger | Unknown |  |

### loan_product_accounting_settings_rule

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_product_encoded_key | Unknown | FK |
| financial_resource | Unknown |  |
| gl_account_key | Unknown |  |
| transaction_channel_key | Unknown |  |

### loan_product_template

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_product_encoded_key | Unknown | FK |
| creation_date | Unknown |  |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### loan_product

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| account_link_settings_enabled | Unknown |  |
| account_link_settings_linkable_deposit_product_key | Unknown |  |
| account_link_settings_linked_account_option | Json |  |
| account_link_settings_settlement_method | Unknown |  |
| accounting_settings_interest_accrual_calculation | Unknown |  |
| accounting_settings_interest_accrued_method | Unknown |  |
| accounting_settings_method | Unknown |  |
| accrue_late_interest | Unknown |  |
| adjust_interest_for_first_installment | Unknown |  |
| allow_custom_repayment_allocation | Unknown |  |
| arrears_settings_date_calculation_method | Unknown |  |
| arrears_settings_encoded_key | Unknown |  |
| arrears_settings_monthly_tolerance_day | Unknown |  |
| arrears_settings_non_working_days_method | Unknown |  |
| arrears_settings_tolerance_calculation_method | Unknown |  |
| arrears_settings_tolerance_floor_amount | Unknown |  |
| arrears_settings_tolerance_percentage_of_outstanding_principal_default_value | Unknown |  |
| arrears_settings_tolerance_percentage_of_outstanding_principal_max_value | Unknown |  |
| arrears_settings_tolerance_percentage_of_outstanding_principal_min_value | Unknown |  |
| arrears_settings_tolerance_period_default_value | Unknown |  |
| arrears_settings_tolerance_period_encoded_key | Unknown |  |
| arrears_settings_tolerance_period_max_value | Unknown |  |
| arrears_settings_tolerance_period_min_value | Unknown |  |
| availability_settings_available_for | Json |  |
| billing_cycle_enabledschedule_settings_ | Unknown |  |
| billing_cycle_start_dayschedule_settings_ | Json |  |
| branch_settings_available_product_branch | Json |  |
| branch_settings_for_all_branch | Unknown |  |
| category | Unknown |  |
| compounding_frequency | Unknown |  |
| creation_date | Unknown |  |
| credit_arrangement_requirement | Unknown |  |
| currency_code | Unknown |  |
| days_in_year | Unknown |  |
| default_repayment_period_countschedule_settings_ | Unknown |  |
| due_dates_methodschedule_settings_ | Unknown |  |
| fee_settings_allow_arbitrary_fee | Unknown |  |
| first_repayment_due_date_offset_default_valueschedule_settings_ | Unknown |  |
| first_repayment_due_date_offset_encoded_keyschedule_settings_ | Unknown |  |
| first_repayment_due_date_offset_max_valueschedule_settings_ | Unknown |  |
| first_repayment_due_date_offset_min_valueschedule_settings_ | Unknown |  |
| fixed_days_of_monthschedule_settings_ | Json |  |
| funding_settings_enabled | Unknown |  |
| funding_settings_funder_interest_commission_allocation_type | Unknown |  |
| funding_settings_funder_interest_commission_default_value | Unknown |  |
| funding_settings_funder_interest_commission_encoded_key | Unknown |  |
| funding_settings_funder_interest_commission_max_value | Unknown |  |
| funding_settings_funder_interest_commission_min_value | Unknown |  |
| funding_settings_lock_funds_at_approval | Unknown |  |
| funding_settings_organization_interest_commission_default_value | Unknown |  |
| funding_settings_organization_interest_commission_encoded_key | Unknown |  |
| funding_settings_organization_interest_commission_max_value | Unknown |  |
| funding_settings_organization_interest_commission_min_value | Unknown |  |
| funding_settings_required_fund | Unknown |  |
| grace_period_default_value | Unknown |  |
| grace_period_encoded_key | Unknown |  |
| grace_period_max_value | Unknown |  |
| grace_period_min_value | Unknown |  |
| grace_period_type | Unknown |  |
| id | Unknown |  |
| index_rate_settings_accrue_interest_after_maturity | Unknown |  |
| index_rate_settings_allow_negative_interest_rate | Unknown |  |
| index_rate_settings_encoded_key | Unknown |  |
| index_rate_settings_index_source_key | Unknown |  |
| index_rate_settings_interest_charge_frequency | Unknown |  |
| index_rate_settings_interest_charge_frequency_count | Unknown |  |
| index_rate_settings_interest_rate_ceiling_value | Unknown |  |
| index_rate_settings_interest_rate_floor_value | Unknown |  |
| index_rate_settings_interest_rate_review_count | Unknown |  |
| index_rate_settings_interest_rate_review_unit | Unknown |  |
| index_rate_settings_interest_rate_source | Unknown |  |
| index_rate_settings_interest_rate_term | Unknown |  |
| interest_accrual_sinceschedule_settings_ | Unknown |  |
| interest_application_method | Unknown |  |
| interest_balance_calculation_method | Unknown |  |
| interest_calculation_method | Unknown |  |
| interest_rate_default_value | Unknown |  |
| interest_rate_max_value | Unknown |  |
| interest_rate_min_value | Unknown |  |
| interest_rate_source | Unknown |  |
| interest_type | Unknown |  |
| internal_controls_dormancy_period_day | Unknown |  |
| internal_controls_four_eyes_principle_active_for_loan_approval | Unknown |  |
| internal_controls_lock_settings_capping_constraint_type | Unknown |  |
| internal_controls_lock_settings_capping_method | Unknown |  |
| internal_controls_lock_settings_capping_percentage | Unknown |  |
| internal_controls_lock_settings_lock_period_day | Unknown |  |
| last_modified_date | Instant |  |
| loan_amount_default_value | Unknown |  |
| loan_amount_encoded_key | Unknown |  |
| loan_amount_max_value | Unknown |  |
| loan_amount_min_value | Unknown |  |
| name | Unknown |  |
| new_account_settings_account_initial_state | Unknown |  |
| new_account_settings_id_generator_type | Unknown |  |
| new_account_settings_id_pattern | Unknown |  |
| note | Unknown |  |
| num_installment_default_valueschedule_settings_ | Unknown |  |
| num_installment_encoded_keyschedule_settings_ | Unknown |  |
| num_installment_max_valueschedule_settings_ | Unknown |  |
| num_installment_min_valueschedule_settings_ | Unknown |  |
| number_of_previewed_instalmentschedule_settings_ | Unknown |  |
| offset_settings_allow_offset | Unknown |  |
| payment_settings_amortization_method | Unknown |  |
| payment_settings_late_payments_recalculation_method | Unknown |  |
| payment_settings_payment_method | Unknown |  |
| payment_settings_repayment_allocation_order | Json |  |
| penalty_settings_loan_penalty_calculation_method | Unknown |  |
| penalty_settings_loan_penalty_grace_period | Unknown |  |
| penalty_settings_penalty_rate_default_value | Unknown |  |
| penalty_settings_penalty_rate_encoded_key | Unknown |  |
| penalty_settings_penalty_rate_max_value | Unknown |  |
| penalty_settings_penalty_rate_min_value | Unknown |  |
| prepayment_settings_apply_interest_on_prepayment_method | Unknown |  |
| prepayment_settings_elements_recalculation_method | Unknown |  |
| prepayment_settings_future_payments_acceptance | Unknown |  |
| prepayment_settings_prepayment_acceptance | Unknown |  |
| prepayment_settings_prepayment_recalculation_method | Unknown |  |
| prepayment_settings_principal_paid_installment_status | Unknown |  |
| preview_schedule_enabledschedule_settings_ | Unknown |  |
| principal_payment_settings_amount_default_value | Unknown |  |
| principal_payment_settings_amount_encoded_key | Unknown |  |
| principal_payment_settings_amount_max_value | Unknown |  |
| principal_payment_settings_amount_min_value | Unknown |  |
| principal_payment_settings_default_principal_repayment_interval | Unknown |  |
| principal_payment_settings_encoded_key | Unknown |  |
| principal_payment_settings_include_fees_in_floor_amount | Unknown |  |
| principal_payment_settings_include_interest_in_floor_amount | Unknown |  |
| principal_payment_settings_percentage_default_value | Unknown |  |
| principal_payment_settings_percentage_encoded_key | Unknown |  |
| principal_payment_settings_percentage_max_value | Unknown |  |
| principal_payment_settings_percentage_min_value | Unknown |  |
| principal_payment_settings_principal_ceiling_value | Unknown |  |
| principal_payment_settings_principal_floor_value | Unknown |  |
| principal_payment_settings_principal_payment_method | Unknown |  |
| principal_payment_settings_total_due_amount_floor | Unknown |  |
| principal_payment_settings_total_due_payment | Unknown |  |
| redraw_settings_allow_redraw | Unknown |  |
| repayment_currency_roundingschedule_settings_ | Unknown |  |
| repayment_elements_rounding_methodschedule_settings_ | Unknown |  |
| repayment_methodschedule_settings_ | Unknown |  |
| repayment_period_unitschedule_settings_ | Unknown |  |
| repayment_rescheduling_methodschedule_settings_ | Unknown |  |
| repayment_schedule_edit_optionschedule_settings_ | Json |  |
| repayment_schedule_methodschedule_settings_ | Unknown |  |
| rounding_repayment_schedule_methodschedule_settings_ | Unknown |  |
| schedule_interest_days_count_method | Unknown |  |
| security_settings_is_collateral_enabled | Unknown |  |
| security_settings_is_guarantors_enabled | Unknown |  |
| security_settings_required_guaranty | Unknown |  |
| short_month_handling_methodschedule_settings_ | Unknown |  |
| state | Unknown |  |
| tax_settings_tax_calculation_method | Unknown |  |
| tax_settings_tax_source_key | Unknown |  |
| tax_settings_taxes_on_fees_enabled | Unknown |  |
| tax_settings_taxes_on_interest_enabled | Unknown |  |
| tax_settings_taxes_on_penalty_enabled | Unknown |  |
| tranche_settings_max_number_of_tranche | Unknown |  |
| type | Unknown |  |

### user_access_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_encoded_key | Unknown | PK, FK |
| permission | Unknown |  |

### user_managed_branch

| Column | Type | Keys |
| --- | --- | --- |
| branch_key | Unknown | PK |
| users_encoded_key | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| assigned_branch_key | Unknown | FK |
| role_id | Unknown | FK |
| administrator_access | Unknown |  |
| api_access | Unknown |  |
| can_manage_all_branch | Unknown |  |
| can_manage_entities_assigned_to_other_officer | Unknown |  |
| creation_date | Unknown |  |
| credit_officer_access | Unknown |  |
| delivery_access | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| home_phone | Unknown |  |
| id | Unknown |  |
| languages | Unknown |  |
| last_logged_in_date | Unknown |  |
| last_modified_date | Unknown |  |
| last_name | Unknown |  |
| mambu_access | Unknown |  |
| mobile_phone | Unknown |  |
| note | Unknown |  |
| role_encoded_key | Unknown |  |
| support_access | Unknown |  |
| teller_access | Unknown |  |
| title | Unknown |  |
| transaction_limits_property_1 | Unknown |  |
| transaction_limits_property_2 | Unknown |  |
| two_factor_authentication | Unknown |  |
| user_name | Unknown |  |
| user_state | Unknown |  |

### transaction_channel_usage_right

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_channel_encoded_key | Unknown | PK, FK |
| usage_right | Unknown |  |

### transaction_channel_deposit_constraint

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| transaction_channel_encoded_key | Unknown | PK, FK |
| criteria | Unknown |  |
| operator | Unknown |  |
| second_value | Unknown |  |
| value | Unknown |  |
| values | Json |  |

### transaction_channel_loan_constraint

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| transaction_channel_encoded_key | Unknown | PK, FK |
| criteria | Unknown |  |
| operator | Unknown |  |
| second_value | Unknown |  |
| value | Unknown |  |
| values | Json |  |

### transaction_channel

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| available_for_all | Unknown |  |
| deposit_constraints_match_filters_option | Unknown |  |
| deposit_constraints_usage | Unknown |  |
| gl_account | Unknown |  |
| id | Unknown |  |
| is_default | Unknown |  |
| loan_constraints_match_filters_option | Unknown |  |
| loan_constraints_usage | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |

### journal_entry

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| assigned_branch_key | Unknown | FK |
| user_key | Unknown | FK |
| account_key | Unknown |  |
| accounting_rate | Unknown |  |
| accounting_rate_encoded_key | Unknown |  |
| accounting_rate_end_date | Unknown |  |
| accounting_rate_from_currency_code | Unknown |  |
| accounting_rate_start_date | Unknown |  |
| accounting_rate_to_currency_code | Unknown |  |
| amount | Unknown |  |
| booking_date | Unknown |  |
| creation_date | Unknown |  |
| entry_id | Unknown |  |
| foreign_amount | Unknown |  |
| foreign_currency_code | Unknown |  |
| gl_account_activated | Unknown |  |
| gl_account_allow_manual_journal_entry | Unknown |  |
| gl_account_balance | Unknown |  |
| gl_account_code | Unknown |  |
| gl_account_creation_date | Unknown |  |
| gl_account_currency_code | Unknown |  |
| gl_account_description | Unknown |  |
| gl_account_encoded_key | Unknown |  |
| gl_account_last_modified_date | Unknown |  |
| gl_account_migration_event_key | Unknown |  |
| gl_account_name | Unknown |  |
| gl_account_strip_trailing_zero | Unknown |  |
| gl_account_type | Unknown |  |
| gl_account_usage | Unknown |  |
| note | Unknown |  |
| product_key | Unknown |  |
| product_type | Unknown |  |
| reversal_entry_key | Unknown |  |
| transaction_id | Unknown |  |
| type | Unknown |  |

### loan_account_asset

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_account_key | Unknown | FK |
| loan_account_encoded_key | Unknown | FK |
| amount | Unknown |  |
| asset_name | Unknown |  |
| currency_code | Unknown |  |
| guarantor_key | Unknown |  |
| guarantor_type | Unknown |  |
| original_amount | Unknown |  |
| custom_** |  |  |

### loan_account_disbursement_fee

| Column | Type | Keys |
| --- | --- | --- |
| disbursement_encoded_key | Unknown | PK |
| encoded_key | Unknown | PK |
| loan_account_encoded_key | Unknown | PK, FK |
| amount | Unknown |  |
| percentage | Unknown |  |
| pre_defined_fee_encoded_key | Unknown |  |

### loan_account_funding_source

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_account_encoded_key | Unknown | FK |
| amount | Unknown |  |
| asset_name | Unknown |  |
| deposit_account_key | Unknown |  |
| guarantor_key | Unknown |  |
| guarantor_type | Unknown |  |
| id | Unknown |  |
| interest_commission | Unknown |  |
| share_percentage | Unknown |  |

### loan_account_guarantor

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_account_key | Unknown | FK |
| loan_account_encoded_key | Unknown | FK |
| amount | Unknown |  |
| asset_name | Unknown |  |
| guarantor_key | Unknown |  |
| guarantor_type | Unknown |  |
| custom_** |  |  |

### loan_account_locked_operation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| loan_account_encoded_key | Unknown | PK, FK |
| locked_operation | Unknown |  |

### loan_account_planned_installment_fee

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| installment_key | Unknown | FK |
| loan_account_encoded_key | Unknown | FK |
| amount | Unknown |  |
| apply_on_date | Unknown |  |
| installment_number | Unknown |  |
| pre_defined_fee_key | Unknown |  |

### loan_account_payment_plan

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_account_encoded_key | Unknown | FK |
| amount | Unknown |  |
| to_installment | Unknown |  |

### loan_account_tranche_fee

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_account_encoded_key | Unknown | PK, FK |
| loan_account_tranche_encoded_key | Unknown | PK, FK |
| amount | Unknown |  |
| percentage | Unknown |  |
| pre_defined_fee_encoded_key | Unknown |  |

### loan_account_tranche

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_account_encoded_key | Unknown | FK |
| amount | Unknown |  |
| disbursement_details_disbursement_transaction_key | Unknown |  |
| disbursement_details_expected_disbursement_date | Unknown |  |
| tranche_number | Unknown |  |

### loan_account

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| assigned_branch_key | Unknown | FK |
| assigned_centre_key | Unknown | FK |
| assigned_user_key | Unknown | FK |
| product_type_key | Unknown | FK |
| account_holder_key | Unknown |  |
| account_holder_type | Unknown |  |
| account_state | Unknown |  |
| account_sub_state | Unknown |  |
| accrue_interest_after_maturity | Unknown |  |
| accrued_interest | Unknown |  |
| accrued_penalty | Unknown |  |
| activation_transaction_key | Unknown |  |
| allow_offset | Unknown |  |
| approved_date | Unknown |  |
| arrears_tolerance_period | Unknown |  |
| closed_date | Unknown |  |
| creation_date | Unknown |  |
| credit_arrangement_key | Unknown |  |
| days_in_arrear | Unknown |  |
| days_late | Unknown |  |
| disbursement_date | Unknown |  |
| disbursement_encoded_key | Unknown |  |
| disbursement_expected_date | Unknown |  |
| disbursement_first_repayment_date | Unknown |  |
| fees_balance | Unknown |  |
| fees_due_balance | Unknown |  |
| fees_paid_balance | Unknown |  |
| future_payments_acceptance | Unknown |  |
| has_custom_schedule | Unknown |  |
| hold_balance | Unknown |  |
| id | Unknown |  |
| interest_accrued_in_billing_cycle | Unknown |  |
| interest_balance | Unknown |  |
| interest_charge_frequency | Unknown |  |
| interest_commission | Unknown |  |
| interest_due_balance | Unknown |  |
| interest_from_arrears_accrued | Unknown |  |
| interest_from_arrears_balance | Unknown |  |
| interest_from_arrears_due_balance | Unknown |  |
| interest_from_arrears_paid_balance | Unknown |  |
| interest_paid_balance | Unknown |  |
| interest_rate_review_count | Unknown |  |
| interest_rate_review_unit | Unknown |  |
| interest_rate_source | Unknown |  |
| interest_spread | Unknown |  |
| last_account_appraisal_date | Unknown |  |
| last_interest_applied_date | Unknown |  |
| last_interest_review_date | Unknown |  |
| last_locked_date | Unknown |  |
| last_modified_date | Instant |  |
| last_set_to_arrears_date | Unknown |  |
| last_tax_rate_review_date | Unknown |  |
| late_payments_recalculation_method | Unknown |  |
| loan_amount | Unknown |  |
| loan_name | Unknown |  |
| locked_account_total_due_type | Unknown |  |
| migration_event_key | Unknown |  |
| modify_interest_for_first_installment | Unknown |  |
| note | Unknown |  |
| original_account_key | Unknown |  |
| payment_holidays_accrued_interest | Unknown |  |
| payment_method | Unknown |  |
| penalty_balance | Unknown |  |
| penalty_due_balance | Unknown |  |
| penalty_paid_balance | Unknown |  |
| periodic_payment | Unknown |  |
| principal_balance | Unknown |  |
| principal_due_balance | Unknown |  |
| principal_paid_balance | Unknown |  |
| redraw_balance | Unknown |  |
| redraw_restrict_next_due_withdrawal | Unknown |  |
| repayment_installments | Unknown |  |
| rescheduled_account_key | Unknown |  |
| settlement_account_key | Unknown |  |
| tax_rate | Unknown |  |
| termination_date | Unknown |  |
| transaction_channel_id | Unknown |  |
| transaction_channel_key | Unknown |  |
| transaction_encoded_key | Unknown |  |
| transaction_internal_transfer | Unknown |  |
| transaction_target_deposit_account_key | Unknown |  |
| custom_** |  |  |

### deposit_account_over_draft_interest_rate_tier

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_account_encoded_key | Unknown | PK, FK |
| ending_day | Unknown |  |

### deposit_account

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| account_holder_key | Unknown | FK |
| assigned_branch_key | Unknown | FK |
| assigned_centre_key | Unknown | FK |
| assigned_user_key | Unknown | FK |
| product_type_key | Unknown | FK |
| account_holder_type | Unknown |  |
| account_state | Unknown |  |
| account_type | Unknown |  |
| activation_date | Unknown |  |
| allow_over_draft | Unknown |  |
| approved_date | Unknown |  |
| available_balance | Unknown |  |
| blocked_balance | Unknown |  |
| closed_date | Unknown |  |
| creation_date | Unknown |  |
| credit_arrangement_key | Unknown |  |
| fees_due | Unknown |  |
| forward_available_balance | Unknown |  |
| hold_balance | Unknown |  |
| id | Unknown |  |
| interest_rate_settings_encoded_key | Unknown |  |
| interest_spread | Unknown |  |
| internal_controls_max_deposit_balance | Unknown |  |
| internal_controls_target_amount | Unknown |  |
| last_account_appraisal_date | Unknown |  |
| last_interest_calculation_date | Unknown |  |
| last_interest_review_date | Unknown |  |
| last_interest_stored_date | Unknown |  |
| last_modified_date | Unknown |  |
| last_over_draft_interest_review_date | Unknown |  |
| last_set_to_arrears_date | Unknown |  |
| linked_settlement_account_key | Json |  |
| locked_balance | Unknown |  |
| locked_date | Unknown |  |
| maturity_date | Unknown |  |
| migration_event_key | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| over_draft_amount | Unknown |  |
| over_draft_expiry_date | Unknown |  |
| over_draft_interest_due | Unknown |  |
| over_draft_interest_rate_encoded_key | Unknown |  |
| over_draft_interest_spread | Unknown |  |
| over_draft_limit | Unknown |  |
| technical_over_draft_amount | Unknown |  |
| technical_over_draft_interest_due | Unknown |  |
| total_balance | Unknown |  |
| with_holding_tax_source_key | Unknown |  |

### deposit_product_fee_settings_accounting_rule

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_product_encoded_key | Unknown | PK, FK |
| deposit_product_fee_encoded_key | Unknown | PK, FK |
| financial_resource | Unknown |  |
| gl_account_key | Unknown |  |

### deposit_product_fee

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_product_encoded_key | Unknown | FK |
| amount | Unknown |  |
| amount_calculation_function_name | Unknown |  |
| amount_calculation_method | Unknown |  |
| apply_date_method | Unknown |  |
| creation_date | Unknown |  |
| fee_application | Unknown |  |
| id | Unknown |  |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |
| trigger | Unknown |  |

### deposit_product_currency

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deposit_product_encoded_key | Unknown | PK, FK |
| currency_code | Unknown |  |

### deposit_product_over_draft_interest_rate_settings_tier

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_product_encoded_key | Unknown | FK |
| ending_balance | Unknown |  |
| interest_rate | Unknown |  |

### deposit_product_template

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_product_encoded_key | Unknown | FK |
| creation_date | Unknown |  |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### deposit_product_interest_payment_date

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deposit_product_encoded_key | Unknown | FK |
| day | Unknown |  |
| month | Unknown |  |

### deposit_product_interest_rate_tier

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_product_encoded_key | Unknown | PK, FK |
| ending_balance | Unknown |  |
| ending_day | Unknown |  |
| interest_rate | Unknown |  |

### deposit_product_accounting_settings_rule

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| deposit_product_encoded_key | Unknown | FK |
| financial_resource | Unknown |  |
| gl_account_key | Unknown |  |

### deposit_product

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| accounting_settings_interest_accrued_method | Unknown |  |
| accounting_settings_method | Unknown |  |
| accrue_interest_rate_settings_after_maturity | Unknown |  |
| allow_negative_interest_rate_settings | Unknown |  |
| allow_technical_over_draft | Unknown |  |
| available_for | Json |  |
| available_product_branch | Json |  |
| category | Unknown |  |
| creation_date | Unknown |  |
| credit_arrangement_requirement | Unknown |  |
| fee_settings_allow_arbitrary_fee | Unknown |  |
| for_all_branch | Unknown |  |
| id | Unknown |  |
| interest_payment_settings_point | Unknown |  |
| interest_rate_default_value | Unknown |  |
| interest_rate_max_value | Unknown |  |
| interest_rate_min_value | Unknown |  |
| interest_rate_settings_charge_frequency | Unknown |  |
| interest_rate_settings_charge_frequency_count | Unknown |  |
| interest_rate_settings_encoded_key | Unknown |  |
| interest_rate_settings_index_source_key | Unknown |  |
| interest_rate_settings_review_count | Unknown |  |
| interest_rate_settings_review_unit | Unknown |  |
| interest_rate_settings_source | Unknown |  |
| interest_rate_settings_term | Unknown |  |
| interest_settings_calculation_balance | Unknown |  |
| interest_settings_collect_interest_when_locked | Unknown |  |
| interest_settings_days_in_year | Unknown |  |
| interest_settings_gains_provided_end_date | Unknown |  |
| interest_settings_gains_provided_start_date | Unknown |  |
| interest_settings_maximum_balance | Unknown |  |
| interest_settings_paid_into_account | Unknown |  |
| internal_controls_dormancy_period_day | Unknown |  |
| internal_controls_max_withdrawal_amount | Unknown |  |
| internal_controls_opening_balance_default_value | Unknown |  |
| internal_controls_opening_balance_max_value | Unknown |  |
| internal_controls_opening_balance_min_value | Unknown |  |
| internal_controls_recommended_deposit_amount | Unknown |  |
| last_modified_date | Unknown |  |
| maturity_period_default_value | Unknown |  |
| maturity_period_max_value | Unknown |  |
| maturity_period_min_value | Unknown |  |
| maturity_settings_period_unit | Unknown |  |
| name | Unknown |  |
| new_account_settings_id_generator_type | Unknown |  |
| new_account_settings_id_pattern | Unknown |  |
| note | Unknown |  |
| offset_settings_allow_offset | Unknown |  |
| over_draft_interest_rate_settings_charge_frequency | Unknown |  |
| over_draft_interest_rate_settings_charge_frequency_count | Unknown |  |
| over_draft_interest_rate_settings_default_value | Unknown |  |
| over_draft_interest_rate_settings_index_source_key | Unknown |  |
| over_draft_interest_rate_settings_max_value | Unknown |  |
| over_draft_interest_rate_settings_min_value | Unknown |  |
| over_draft_interest_rate_settings_review_count | Unknown |  |
| over_draft_interest_rate_settings_review_unit | Unknown |  |
| over_draft_interest_rate_settings_source | Unknown |  |
| over_draft_interest_rate_settings_term | Unknown |  |
| over_draft_interest_settings_days_in_year | Unknown |  |
| over_draft_interest_settings_interest_calculation_balance | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| with_holding_tax_enabled | Unknown |  |
| custom_** |  |  |

### loan_account_schedule_fee_detail

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_account_schedule_encoded_key | Unknown | FK |
| amount_reduced | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| tax_reduced | Unknown |  |

### loan_account_schedule

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| loan_account_key | Unknown | FK |
| due_date | Unknown |  |
| fee_amount_due | Unknown |  |
| fee_amount_expected | Unknown |  |
| fee_amount_paid | Unknown |  |
| fee_tax_due | Unknown |  |
| fee_tax_expected | Unknown |  |
| fee_tax_paid | Unknown |  |
| interest_amount_due | Unknown |  |
| interest_amount_expected | Unknown |  |
| interest_amount_paid | Unknown |  |
| interest_tax_due | Unknown |  |
| interest_tax_expected | Unknown |  |
| interest_tax_paid | Unknown |  |
| is_payment_holiday | Unknown |  |
| last_paid_date | Unknown |  |
| number | Unknown |  |
| penalty_amount_due | Unknown |  |
| penalty_amount_expected | Unknown |  |
| penalty_amount_paid | Unknown |  |
| penalty_tax_due | Unknown |  |
| penalty_tax_expected | Unknown |  |
| penalty_tax_paid | Unknown |  |
| principal_amount_due | Unknown |  |
| principal_amount_expected | Unknown |  |
| principal_amount_paid | Unknown |  |
| repaid_date | Unknown |  |
| state | Unknown |  |

### loan_transaction_custom_payment_amount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| loan_transaction_encoded_key | Unknown | PK, FK |
| amount | Unknown |  |
| custom_payment_amount_type | Unknown |  |
| pre_defined_fee_key | Unknown |  |
| tax_on_amount | Unknown |  |

### loan_transaction_fee

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| loan_transaction_encoded_key | Unknown | PK, FK |
| amount | Unknown |  |
| name | Unknown |  |
| pre_defined_fee_key | Unknown |  |
| tax_amount | Unknown |  |
| trigger | Unknown |  |

### loan_transaction

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| branch_key | Unknown | FK |
| centre_key | Unknown | FK |
| installment_encoded_key | Unknown | FK |
| loan_account_key | Unknown | FK |
| transaction_channel_key | Unknown | FK |
| user_key | Unknown | FK |
| account_balances_advance_position | Unknown |  |
| account_balances_arrears_position | Unknown |  |
| account_balances_expected_principal_redraw | Unknown |  |
| account_balances_principal_balance | Unknown |  |
| account_balances_redraw_balance | Unknown |  |
| account_balances_total_balance | Unknown |  |
| adjustment_transaction_key | Unknown |  |
| affected_deferred_interest_amount | Unknown |  |
| affected_fees_amount | Unknown |  |
| affected_funders_interest_amount | Unknown |  |
| affected_interest_amount | Unknown |  |
| affected_interest_from_arrears_amount | Unknown |  |
| affected_organization_commission_amount | Unknown |  |
| affected_payment_holidays_interest_amount | Unknown |  |
| affected_penalty_amount | Unknown |  |
| affected_principal_amount | Unknown |  |
| amount | Unknown |  |
| booking_date | Unknown |  |
| card_acceptor_city | Unknown |  |
| card_acceptor_country | Unknown |  |
| card_acceptor_mcc | Unknown |  |
| card_acceptor_name | Unknown |  |
| card_acceptor_state | Unknown |  |
| card_acceptor_street | Unknown |  |
| card_acceptor_zip | Unknown |  |
| card_token | Unknown |  |
| card_transaction_advice | Unknown |  |
| card_transaction_amount | Unknown |  |
| card_transaction_currency_code | Unknown |  |
| card_transaction_encoded_key | Unknown |  |
| card_transaction_external_authorization_reference_id | Unknown |  |
| card_transaction_external_reference_id | Unknown |  |
| creation_date | Unknown |  |
| currency_code | Unknown |  |
| external_id | Unknown |  |
| id | Unknown |  |
| migration_event_key | Unknown |  |
| note | Unknown |  |
| original_amount | Unknown |  |
| original_currency_code | Unknown |  |
| original_transaction_key | Unknown |  |
| parent_loan_transaction_key | Unknown |  |
| pre_payment_recalculation_method | Unknown |  |
| taxes_deferred_tax_on_interest_amount | Unknown |  |
| taxes_tax_on_fees_amount | Unknown |  |
| taxes_tax_on_interest_amount | Unknown |  |
| taxes_tax_on_interest_from_arrears_amount | Unknown |  |
| taxes_tax_on_payment_holidays_interest | Unknown |  |
| taxes_tax_on_penalty_amount | Unknown |  |
| taxes_tax_rate | Unknown |  |
| terms_interest_settings_index_interest_rate | Unknown |  |
| terms_interest_settings_interest_rate | Unknown |  |
| terms_periodic_payment | Unknown |  |
| terms_principal_payment_amount | Unknown |  |
| terms_principal_payment_percentage | Unknown |  |
| till_key | Unknown |  |
| transaction_details_transaction_channel_id | Unknown |  |
| transaction_details_transaction_channel_key | Unknown |  |
| transfer_details_linked_deposit_transaction_key | Unknown |  |
| transfer_details_linked_loan_transaction_key | Unknown |  |
| type | Unknown |  |
| user_transaction_time | Unknown |  |
| value_date | Unknown |  |
| custom_** |  |  |

### custom_field_set_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| custom_field_set_encoded_key | Unknown | FK |
| id | Unknown |  |

### custom_field_set

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| available_for | Unknown |  |
| built_in | Unknown |  |
| creation_date | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| field_set_type | Unknown |  |
| id | Unknown |  |
| position | Unknown |  |

### client_role

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| client_encoded_key | Unknown | FK |
| can_guarantee | Unknown |  |
| can_open_account | Unknown |  |
| client_type | Unknown |  |
| creation_date | Unknown |  |
| description | Unknown |  |
| id | Unknown |  |
| id_pattern | Unknown |  |
| name | Unknown |  |
| require_id | Unknown |  |
| use_default_address | Unknown |  |

### branch_address

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| branch_encoded_key | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| index_in_list | Unknown |  |
| latitude | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| longitude | Unknown |  |
| postcode | Unknown |  |
| region | Unknown |  |

### branch_holiday

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| branch_encoded_key | Unknown | FK |
| creation_date | Unknown |  |
| date | Unknown |  |
| id | Unknown |  |
| is_annually_recurring | Unknown |  |
| name | Unknown |  |

### branch

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| creation_date | Unknown |  |
| email_address | Unknown |  |
| id | Unknown |  |
| last_modified_date | Instant |  |
| name | Unknown |  |
| note | Unknown |  |
| phone_number | Unknown |  |
| state | Unknown |  |
| custom_** |  |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| base_currency | Unknown |  |
| code | Unknown |  |
| creation_date | Unknown |  |
| currency_symbol_position | Unknown |  |
| digits_after_decimal | Unknown |  |
| last_modified_date | Unknown |  |
| name | Unknown |  |
| numeric_code | Unknown |  |
| symbol | Unknown |  |
| type | Unknown |  |

### credit_arrangement

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| holder_key | Unknown | FK |
| amount | Unknown |  |
| approved_date | Unknown |  |
| available_credit_amount | Unknown |  |
| closed_date | Unknown |  |
| consumed_credit_amount | Unknown |  |
| creation_date | Unknown |  |
| currency_code | Unknown |  |
| expire_date | Unknown |  |
| exposure_limit_type | Unknown |  |
| holder_type | Unknown |  |
| id | Unknown |  |
| last_modified_date | Unknown |  |
| note | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| sub_state | Unknown |  |

### client_address

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| client_encoded_key | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| index_in_list | Unknown |  |
| latitude | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| longitude | Unknown |  |
| parent_key | Unknown |  |
| postcode | Unknown |  |
| region | Unknown |  |

### client_id_document_attachment

| Column | Type | Keys |
| --- | --- | --- |
| client_id_document_client_key | Unknown | PK |
| encoded_key | Unknown | PK |
| client_id_document_encoded_key | Unknown | PK, FK |
| creation_date | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| id | Unknown |  |
| last_modified_date | Unknown |  |
| location | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| owner_key | Unknown |  |
| owner_type | Unknown |  |
| type | Unknown |  |

### client_id_document

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| client_key | Unknown | FK |
| document_id | Unknown |  |
| document_type | Unknown |  |
| identification_document_template_key | Unknown |  |
| index_in_list | Unknown |  |
| issuing_authority | Unknown |  |
| valid_until | Unknown |  |

### client

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| assigned_branch_key | Unknown | FK |
| assigned_centre_key | Unknown | FK |
| assigned_user_key | Unknown | FK |
| client_role_key | Unknown | FK |
| activation_date | Unknown |  |
| approved_date | Unknown |  |
| birth_date | Unknown |  |
| closed_date | Unknown |  |
| creation_date | Unknown |  |
| email_address | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| group_keys | Json |  |
| group_loan_cycle | Unknown |  |
| home_phone | Unknown |  |
| id | Unknown |  |
| last_modified_date | Instant |  |
| last_name | Unknown |  |
| loan_cycle | Unknown |  |
| middle_name | Unknown |  |
| migration_event_key | Unknown |  |
| mobile_phone | Unknown |  |
| mobile_phone_2 | Unknown |  |
| note | Unknown |  |
| portal_settings_encoded_key | Unknown |  |
| portal_settings_last_logged_in_date | Unknown |  |
| portal_state | Unknown |  |
| preferred_language | Unknown |  |
| profile_picture_key | Unknown |  |
| profile_signature_key | Unknown |  |
| state | Unknown |  |
| custom_** |  |  |

### user_role_access_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_role_id | Unknown | PK, FK |
| permission | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| administrator_access | Unknown |  |
| api_access | Unknown |  |
| creation_date | Unknown |  |
| credit_officer_access | Unknown |  |
| delivery_access | Unknown |  |
| encoded_key | Unknown |  |
| last_modified_date | Unknown |  |
| mambu_access | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| support_access | Unknown |  |
| teller_access | Unknown |  |

### accounting_report_item

| Column | Type | Keys |
| --- | --- | --- |
| encoded_key | Unknown | PK |
| amounts_closing_balance | Unknown |  |
| amounts_credit | Unknown |  |
| amounts_debit | Unknown |  |
| amounts_net_change | Unknown |  |
| amounts_opening_balance | Unknown |  |
| foreign_amounts_closing_balance | Unknown |  |
| foreign_amounts_credit | Unknown |  |
| foreign_amounts_debit | Unknown |  |
| foreign_amounts_net_change | Unknown |  |
| foreign_amounts_opening_balance | Unknown |  |
| gl_account_activated | Unknown |  |
| gl_account_allow_manual_journal_entry | Unknown |  |
| gl_account_balance | Unknown |  |
| gl_account_code | Unknown |  |
| gl_account_creation_date | Unknown |  |
| gl_account_currency_code | Unknown |  |
| gl_account_description | Unknown |  |
| gl_account_last_modified_date | Unknown |  |
| gl_account_migration_event_key | Unknown |  |
| gl_account_name | Unknown |  |
| gl_account_strip_trailing_zero | Unknown |  |
| gl_account_type | Unknown |  |
| gl_account_usage | Unknown |  |

## Relationships

- group_address(groups_encoded_key) → groups(encoded_key)
- group_members_role(groups_encoded_key) → group_member(groups_encoded_key)
- group_members_role(group_member_index) → group_member(index)
- group_member(client_key) → client(encoded_key)
- group_member(groups_encoded_key) → groups(encoded_key)
- groups(assigned_branch_key) → branch(encoded_key)
- groups(assigned_user_key) → users(encoded_key)
- groups(assigned_centre_key) → centre(encoded_key)
- custom_field_usage(custom_field_encoded_key) → custom_field(encoded_key)
- custom_field_available_option(custom_field_encoded_key) → custom_field_selection_option(custom_field_encoded_key)
- custom_field_available_option(custom_field_selection_option_index) → custom_field_selection_option(index)
- custom_field_selection_option(custom_field_encoded_key) → custom_field(encoded_key)
- custom_field(custom_field_set_custom_field_encoded_key) → custom_field_set_custom_field(encoded_key)
- deposit_transaction_fee(deposit_transaction_encoded_key) → deposit_transaction(encoded_key)
- deposit_transaction(deposit_account_encoded_key) → deposit_account(encoded_key)
- centre_address(centre_encoded_key) → centre(encoded_key)
- centre(assigned_branch_key) → branch(encoded_key)
- task(assigned_user_key) → users(encoded_key)
- deposit_account_authorization_hold(deposit_account_encoded_key) → deposit_account(encoded_key)
- loan_account_authorization_hold(loan_account_encoded_key) → loan_account(encoded_key)
- loan_account_card(loan_account_encoded_key) → loan_account(encoded_key)
- deposit_account_card(deposit_account_encoded_key) → deposit_account(encoded_key)
- loan_product_interest_rate_tier(loan_product_encoded_key) → loan_product(encoded_key)
- loan_product_interest_rate_setting(loan_product_encoded_key) → loan_product(encoded_key)
- loan_product_fee_settings_accounting_rule(loan_product_fee_encoded_key) → loan_product_fee(encoded_key)
- loan_product_fee_settings_accounting_rule(loan_product_encoded_key) → loan_product_fee(loan_product_encoded_key)
- loan_product_fee(loan_product_encoded_key) → loan_product(encoded_key)
- loan_product_accounting_settings_rule(loan_product_encoded_key) → loan_product(encoded_key)
- loan_product_template(loan_product_encoded_key) → loan_product(encoded_key)
- user_access_permission(users_encoded_key) → users(encoded_key)
- user_managed_branch(users_encoded_key) → users(encoded_key)
- users(assigned_branch_key) → branch(encoded_key)
- users(role_id) → user_role(id)
- transaction_channel_usage_right(transaction_channel_encoded_key) → transaction_channel(encoded_key)
- transaction_channel_deposit_constraint(transaction_channel_encoded_key) → transaction_channel(encoded_key)
- transaction_channel_loan_constraint(transaction_channel_encoded_key) → transaction_channel(encoded_key)
- journal_entry(assigned_branch_key) → branch(encoded_key)
- journal_entry(user_key) → users(encoded_key)
- loan_account_asset(deposit_account_key) → deposit_account(encoded_key)
- loan_account_asset(loan_account_encoded_key) → loan_account(encoded_key)
- loan_account_disbursement_fee(loan_account_encoded_key) → loan_account(encoded_key)
- loan_account_funding_source(loan_account_encoded_key) → loan_account(encoded_key)
- loan_account_guarantor(deposit_account_key) → deposit_account(encoded_key)
- loan_account_guarantor(loan_account_encoded_key) → loan_account(encoded_key)
- loan_account_locked_operation(loan_account_encoded_key) → loan_account(encoded_key)
- loan_account_planned_installment_fee(installment_key) → loan_account_schedule(encoded_key)
- loan_account_planned_installment_fee(loan_account_encoded_key) → loan_account(encoded_key)
- loan_account_payment_plan(loan_account_encoded_key) → loan_account(encoded_key)
- loan_account_tranche_fee(loan_account_encoded_key) → loan_account_tranche(loan_account_encoded_key)
- loan_account_tranche_fee(loan_account_tranche_encoded_key) → loan_account_tranche(encoded_key)
- loan_account_tranche(loan_account_encoded_key) → loan_account(encoded_key)
- loan_account(assigned_branch_key) → branch(encoded_key)
- loan_account(assigned_user_key) → users(encoded_key)
- loan_account(product_type_key) → loan_product(encoded_key)
- loan_account(assigned_centre_key) → centre(encoded_key)
- deposit_account_over_draft_interest_rate_tier(deposit_account_encoded_key) → deposit_account(encoded_key)
- deposit_account(assigned_branch_key) → branch(encoded_key)
- deposit_account(assigned_user_key) → users(encoded_key)
- deposit_account(product_type_key) → deposit_product(encoded_key)
- deposit_account(assigned_centre_key) → centre(encoded_key)
- deposit_account(account_holder_key) → client(encoded_key)
- deposit_product_fee_settings_accounting_rule(deposit_product_fee_encoded_key) → deposit_product_fee(encoded_key)
- deposit_product_fee_settings_accounting_rule(deposit_product_encoded_key) → deposit_product_fee(deposit_product_encoded_key)
- deposit_product_fee(deposit_product_encoded_key) → deposit_product(encoded_key)
- deposit_product_currency(deposit_product_encoded_key) → deposit_product(encoded_key)
- deposit_product_over_draft_interest_rate_settings_tier(deposit_product_encoded_key) → deposit_product(encoded_key)
- deposit_product_template(deposit_product_encoded_key) → deposit_product(encoded_key)
- deposit_product_interest_payment_date(deposit_product_encoded_key) → deposit_product(encoded_key)
- deposit_product_interest_rate_tier(deposit_product_encoded_key) → deposit_product(encoded_key)
- deposit_product_accounting_settings_rule(deposit_product_encoded_key) → deposit_product(encoded_key)
- loan_account_schedule_fee_detail(loan_account_schedule_encoded_key) → loan_account_schedule(encoded_key)
- loan_account_schedule(loan_account_key) → loan_account(encoded_key)
- loan_transaction_custom_payment_amount(loan_transaction_encoded_key) → loan_transaction(encoded_key)
- loan_transaction_fee(loan_transaction_encoded_key) → loan_transaction(encoded_key)
- loan_transaction(loan_account_key) → loan_account(encoded_key)
- loan_transaction(centre_key) → centre(encoded_key)
- loan_transaction(installment_encoded_key) → loan_account_schedule(encoded_key)
- loan_transaction(user_key) → users(encoded_key)
- loan_transaction(branch_key) → branch(encoded_key)
- loan_transaction(transaction_channel_key) → transaction_channel(encoded_key)
- custom_field_set_custom_field(custom_field_set_encoded_key) → custom_field_set(encoded_key)
- client_role(client_encoded_key) → client(encoded_key)
- branch_address(branch_encoded_key) → branch(encoded_key)
- branch_holiday(branch_encoded_key) → branch(encoded_key)
- credit_arrangement(holder_key) → groups(encoded_key)
- client_address(client_encoded_key) → client(encoded_key)
- client_id_document_attachment(client_id_document_encoded_key) → client_id_document(encoded_key)
- client_id_document(client_key) → client(encoded_key)
- client(assigned_branch_key) → branch(encoded_key)
- client(assigned_user_key) → users(encoded_key)
- client(assigned_centre_key) → centre(encoded_key)
- client(client_role_key) → client_role(encoded_key)
- user_role_access_permission(user_role_id) → user_role(id)