Mambu

Explore the interactive ERD

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	PKFK
`groups_encoded_key`	Unknown	PKFK
`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	PKFK
`defaults`	Unknown
`object_key`	Unknown
`required`	Unknown

custom_field_available_option

Column	Type	Keys
`index`	Unknown	PK
`custom_field_encoded_key`	Unknown	PKFK
`custom_field_selection_option_index`	Unknown	PKFK
`score`	Unknown
`selection_key`	Unknown
`value`	Unknown

custom_field_selection_option

Column	Type	Keys
`index`	Unknown	PK
`custom_field_encoded_key`	Unknown	PKFK
`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	PKFK
`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	PKFK
`reference_token`	Unknown

deposit_account_card

Column	Type	Keys
`_fivetran_id`	String	PK
`deposit_account_encoded_key`	Unknown	PKFK
`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	PKFK
`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	PKFK
`loan_product_fee_encoded_key`	Unknown	PKFK
`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	PKFK
`permission`	Unknown

user_managed_branch

Column	Type	Keys
`branch_key`	Unknown	PK
`users_encoded_key`	Unknown	PKFK

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	PKFK
`usage_right`	Unknown

transaction_channel_deposit_constraint

Column	Type	Keys
`_fivetran_id`	String	PK
`transaction_channel_encoded_key`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`loan_account_tranche_encoded_key`	Unknown	PKFK
`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	PKFK
`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	PKFK
`deposit_product_fee_encoded_key`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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