Table	Fields	Primary Key	Type	Metadata
xxx_testid	id: INT32 nic: VARCHAR		none	<nil><nil>
xxx_migrate_skip	id: INT32 loanID: INT32 skip: INT32 note: VARCHAR		none	<nil><nil>
x_table_column_code_mappings	column_alias_name: VARCHAR code_id: INT32	column_alias_name	none	<nil><nil>
x_registered_table	registered_table_name: VARCHAR application_table_name: VARCHAR entity_subtype: VARCHAR category: INT32	registered_table_name	none	<nil><nil>
twofactor_configuration	id: INT64 name: VARCHAR value: VARCHAR	id	none	<nil><nil>
twofactor_access_token	id: INT64 token: VARCHAR appuser_id: INT64 valid_from: DATETIME valid_to: DATETIME enabled: BIT	id	none	<nil><nil>
topic_subscriber	id: INT64 topic_id: INT64 user_id: INT64 subscription_date: DATE	id	none	<nil><nil>
topic	id: INT64 title: VARCHAR enabled: BIT entity_id: INT64 entity_type: TEXT member_type: TEXT	id	none	<nil><nil>
stretchy_report_parameter	id: INT32 report_id: INT32 parameter_id: INT32 report_parameter_name: VARCHAR	id	none	<nil><nil>
stretchy_report	id: INT32 report_name: VARCHAR report_type: VARCHAR report_subtype: VARCHAR report_category: VARCHAR report_sql: TEXT description: TEXT core_report: BIT use_report: BIT self_service_user_report: BIT	id	none	<nil><nil>
stretchy_parameter	id: INT32 parameter_name: VARCHAR parameter_variable: VARCHAR parameter_label: VARCHAR parameter_displayType: VARCHAR parameter_FormatType: VARCHAR parameter_default: VARCHAR special: VARCHAR selectOne: VARCHAR selectAll: VARCHAR parameter_sql: TEXT parent_id: INT32	id	none	<nil><nil>
sms_messages_outbound	id: INT64 group_id: INT64 client_id: INT64 staff_id: INT64 status_enum: INT32 mobile_no: VARCHAR message: VARCHAR campaign_id: INT64 external_id: VARCHAR submittedon_date: DATE delivered_on_date: DATETIME is_notification: BIT	id	none	<nil><nil>
sms_campaign	id: INT64 campaign_name: VARCHAR campaign_type: INT32 campaign_trigger_type: INT32 report_id: INT32 provider_id: INT64 param_value: TEXT status_enum: INT32 message: TEXT submittedon_date: DATE submittedon_userid: INT64 approvedon_date: DATE approvedon_userid: INT64 closedon_date: DATE closedon_userid: INT64 recurrence: VARCHAR next_trigger_date: DATETIME last_trigger_date: DATETIME recurrence_start_date: DATETIME is_visible: BIT is_notification: BIT	id	none	<nil><nil>
scheduler_detail	id: INT16 is_suspended: BIT execute_misfired_jobs: BIT reset_scheduler_on_bootup: BIT	id	none	<nil><nil>
scheduled_email_messages_outbound	id: INT64 group_id: INT64 client_id: INT64 staff_id: INT64 email_campaign_id: INT64 status_enum: INT32 email_address: VARCHAR email_subject: VARCHAR message: TEXT campaign_name: VARCHAR submittedon_date: DATE error_message: TEXT	id	none	<nil><nil>
scheduled_email_configuration	id: INT32 name: VARCHAR value: VARCHAR	id	none	<nil><nil>
scheduled_email_campaign	id: INT64 campaign_name: VARCHAR campaign_type: INT32 businessRule_id: INT32 param_value: TEXT status_enum: INT32 email_subject: VARCHAR email_message: TEXT email_attachment_file_format: VARCHAR stretchy_report_id: INT32 stretchy_report_param_map: TEXT closedon_date: DATE closedon_userid: INT64 submittedon_date: DATE submittedon_userid: INT64 approvedon_date: DATE approvedon_userid: INT64 recurrence: VARCHAR next_trigger_date: DATETIME last_trigger_date: DATETIME recurrence_start_date: DATETIME is_visible: BIT previous_run_error_log: TEXT previous_run_error_message: TEXT previous_run_status: VARCHAR	id	none	<nil><nil>
savings_posting_errors_2024_12_23	sav_id: INT64 sat_id: INT64 agje_id: INT64		none	<nil><nil>
rpt_sequence	id: INT32	id	none	<nil><nil>
request_audit_table	id: INT64 lastname: VARCHAR username: VARCHAR mobile_number: VARCHAR firstname: VARCHAR authentication_token: VARCHAR password: VARCHAR email: VARCHAR client_id: INT64 created_date: DATE account_number: VARCHAR	id	none	<nil><nil>
ref_loan_transaction_processing_strategy	id: INT64 code: VARCHAR name: VARCHAR sort_order: INT32	id	none	<nil><nil>
r_enum_value	enum_name: VARCHAR enum_id: INT32 enum_message_property: VARCHAR enum_value: VARCHAR enum_type: BIT	enum_name enum_id	none	<nil><nil>
ppi_scores	id: INT64 score_from: INT32 score_to: INT32	id	none	<nil><nil>
ppi_likelihoods_ppi	id: INT64 likelihood_id: INT64 ppi_name: VARCHAR enabled: INT32	id	none	<nil><nil>
ppi_likelihoods	id: INT64 code: VARCHAR name: VARCHAR	id	none	<nil><nil>
portfolio_commands_bm_approval	m_portfolio_command_source_id: INT32 loan_id: INT32 id: INT32	id	none	<nil><nil>
oauth_refresh_token	token_id: VARCHAR token: BLOB authentication: BLOB		none	<nil><nil>
oauth_client_details	client_id: VARCHAR resource_ids: VARCHAR client_secret: VARCHAR scope: VARCHAR authorized_grant_types: VARCHAR web_server_redirect_uri: VARCHAR authorities: VARCHAR access_token_validity: INT32 refresh_token_validity: INT32 additional_information: VARCHAR autoapprove: BIT	client_id	none	<nil><nil>
oauth_access_token	token_id: VARCHAR token: BLOB authentication_id: VARCHAR user_name: VARCHAR client_id: VARCHAR authentication: BLOB refresh_token: VARCHAR		none	<nil><nil>
notification_mapper	id: INT64 notification_id: INT64 user_id: INT64 is_read: BIT created_at: DATETIME	id	none	<nil><nil>
notification_generator	id: INT64 object_type: TEXT object_identifier: INT64 action: TEXT actor: INT64 is_system_generated: BIT notification_content: TEXT created_at: DATETIME	id	none	<nil><nil>
mix_xbrl_namespace	id: INT32 prefix: VARCHAR url: VARCHAR	id	none	<nil><nil>
mix_taxonomy_mapping	id: INT32 identifier: VARCHAR config: VARCHAR last_update_date: DATETIME currency: VARCHAR	id	none	<nil><nil>
mix_taxonomy	id: INT32 name: VARCHAR namespace_id: INT32 dimension: VARCHAR type: INT32 description: VARCHAR need_mapping: BIT	id	none	<nil><nil>
migration_initial_loan_skip	id: INT32 loan_id: INT64 no_of_skips: INT32 skip_days: INT32	id	none	<nil><nil>
m_working_days	id: INT64 recurrence: VARCHAR repayment_rescheduling_enum: INT16 extend_term_daily_repayments: BIT extend_term_holiday_repayment: BIT	id	none	<nil><nil>
m_trial_balance	office_id: INT64 account_id: INT64 amount: DECIMAL entry_date: DATE created_date: DATE closing_balance: DECIMAL		none	<nil><nil>
m_templatemappers	id: INT64 mapperkey: VARCHAR mapperorder: INT32 mappervalue: VARCHAR	id	none	<nil><nil>
m_template_m_templatemappers	m_template_id: INT64 mappers_id: INT64		none	<nil><nil>
m_template	id: INT64 name: VARCHAR text: TEXT entity: INT32 type: INT32	id	none	<nil><nil>
m_tellers	id: INT64 office_id: INT64 debit_account_id: INT64 credit_account_id: INT64 name: VARCHAR description: VARCHAR valid_from: DATE valid_to: DATE state: INT16	id	none	<nil><nil>
m_tax_group_mappings	id: INT64 tax_group_id: INT64 tax_component_id: INT64 start_date: DATE end_date: DATE createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME	id	none	<nil><nil>
m_tax_group	id: INT64 name: VARCHAR createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME	id	none	<nil><nil>
m_tax_component_history	id: INT64 tax_component_id: INT64 percentage: DECIMAL start_date: DATE end_date: DATE createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME	id	none	<nil><nil>
m_tax_component	id: INT64 name: VARCHAR percentage: DECIMAL debit_account_type_enum: INT16 debit_account_id: INT64 credit_account_type_enum: INT16 credit_account_id: INT64 start_date: DATE createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME	id	none	<nil><nil>
m_surveys	id: INT64 a_key: VARCHAR a_name: VARCHAR description: VARCHAR country_code: VARCHAR valid_from: DATETIME valid_to: DATETIME	id	none	<nil><nil>
m_survey_scorecards	id: INT64 survey_id: INT64 question_id: INT64 response_id: INT64 user_id: INT64 client_id: INT64 created_on: DATETIME a_value: INT32	id	none	<nil><nil>
m_survey_responses	id: INT64 question_id: INT64 a_text: VARCHAR a_value: INT32 sequence_no: INT32	id	none	<nil><nil>
m_survey_questions	id: INT64 survey_id: INT64 component_key: VARCHAR a_key: VARCHAR a_text: VARCHAR description: VARCHAR sequence_no: INT32	id	none	<nil><nil>
m_survey_lookup_tables	id: INT64 survey_id: INT64 a_key: VARCHAR description: INT32 value_from: INT32 value_to: INT32 score: DECIMAL	id	none	<nil><nil>
m_survey_components	id: INT64 survey_id: INT64 a_key: VARCHAR a_text: VARCHAR description: VARCHAR sequence_no: INT32	id	none	<nil><nil>
m_staff_assignment_history	id: INT64 centre_id: INT64 staff_id: INT64 start_date: DATE end_date: DATE createdby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME lastmodifiedby_id: INT64	id	none	<nil><nil>
m_staff	id: INT64 is_loan_officer: BIT office_id: INT64 firstname: VARCHAR lastname: VARCHAR display_name: VARCHAR mobile_no: VARCHAR external_id: VARCHAR organisational_role_enum: INT16 organisational_role_parent_staff_id: INT64 is_active: BIT joining_date: DATE image_id: INT64 email_address: VARCHAR	id	none	<nil><nil>
m_share_product_market_price	id: INT64 product_id: INT64 from_date: DATE share_value: DECIMAL	id	none	<nil><nil>
m_share_product_dividend_pay_out	id: INT64 product_id: INT64 amount: DECIMAL dividend_period_start_date: DATE dividend_period_end_date: DATE status: INT16 createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME	id	none	<nil><nil>
m_share_product_charge	product_id: INT64 charge_id: INT64	product_id charge_id	none	<nil><nil>
m_share_product	id: INT64 name: VARCHAR short_name: VARCHAR external_id: VARCHAR description: VARCHAR start_date: DATETIME end_date: DATETIME currency_code: VARCHAR currency_digits: INT16 currency_multiplesof: INT16 total_shares: INT64 issued_shares: INT64 totalsubscribed_shares: INT64 unit_price: DECIMAL capital_amount: DECIMAL minimum_client_shares: INT64 nominal_client_shares: INT64 maximum_client_shares: INT64 minimum_active_period_frequency: DECIMAL minimum_active_period_frequency_enum: INT16 lockin_period_frequency: DECIMAL lockin_period_frequency_enum: INT16 allow_dividends_inactive_clients: BIT createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME accounting_type: INT16	id	none	<nil><nil>
m_share_account_transactions	id: INT64 account_id: INT64 transaction_date: DATE total_shares: INT64 unit_price: DECIMAL amount: DECIMAL charge_amount: DECIMAL amount_paid: DECIMAL status_enum: INT16 type_enum: INT16 is_active: BIT	id	none	<nil><nil>
m_share_account_dividend_details	id: INT64 dividend_pay_out_id: INT64 account_id: INT64 amount: DECIMAL status: INT16 savings_transaction_id: INT64	id	none	<nil><nil>
m_share_account_charge_paid_by	id: INT64 share_transaction_id: INT64 charge_transaction_id: INT64 amount: DECIMAL	id	none	<nil><nil>
m_share_account_charge	id: INT64 account_id: INT64 charge_id: INT64 charge_time_enum: INT16 charge_calculation_enum: INT16 charge_payment_mode_enum: INT16 calculation_percentage: DECIMAL calculation_on_amount: DECIMAL charge_amount_or_percentage: DECIMAL amount: DECIMAL amount_paid_derived: DECIMAL amount_waived_derived: DECIMAL amount_writtenoff_derived: DECIMAL amount_outstanding_derived: DECIMAL is_paid_derived: BIT waived: BIT min_cap: DECIMAL max_cap: DECIMAL is_active: BIT	id	none	<nil><nil>
m_share_account	id: INT64 account_no: VARCHAR product_id: INT64 client_id: INT64 external_id: VARCHAR status_enum: INT16 total_approved_shares: INT64 total_pending_shares: INT64 submitted_date: DATE submitted_userid: INT64 approved_date: DATE approved_userid: INT64 rejected_date: DATE rejected_userid: INT64 activated_date: DATE activated_userid: INT64 closed_date: DATE closed_userid: INT64 currency_code: VARCHAR currency_digits: INT16 currency_multiplesof: INT16 savings_account_id: INT64 minimum_active_period_frequency: DECIMAL minimum_active_period_frequency_enum: INT16 lockin_period_frequency: DECIMAL lockin_period_frequency_enum: INT16 allow_dividends_inactive_clients: BIT created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME	id	none	<nil><nil>
m_selfservice_user_client_mapping	id: INT64 appuser_id: INT64 client_id: INT64	id	none	<nil><nil>
m_selfservice_beneficiaries_tpt	id: INT64 app_user_id: INT64 name: VARCHAR office_id: INT64 client_id: INT64 account_id: INT64 account_type: INT16 transfer_limit: INT64 is_active: BIT	id	none	<nil><nil>
m_savings_product_charge	savings_product_id: INT64 charge_id: INT64	savings_product_id charge_id	none	<nil><nil>
m_savings_product	id: INT64 name: VARCHAR short_name: VARCHAR description: VARCHAR deposit_type_enum: INT16 currency_code: VARCHAR currency_digits: INT16 currency_multiplesof: INT16 nominal_annual_interest_rate: DECIMAL interest_compounding_period_enum: INT16 interest_posting_period_enum: INT16 interest_calculation_type_enum: INT16 interest_calculation_days_in_year_type_enum: INT16 min_required_opening_balance: DECIMAL lockin_period_frequency: DECIMAL lockin_period_frequency_enum: INT16 accounting_type: INT16 withdrawal_fee_amount: DECIMAL withdrawal_fee_type_enum: INT16 withdrawal_fee_for_transfer: BIT allow_overdraft: BIT overdraft_limit: DECIMAL nominal_annual_interest_rate_overdraft: DECIMAL min_overdraft_for_interest_calculation: DECIMAL min_required_balance: DECIMAL enforce_min_required_balance: BIT min_balance_for_interest_calculation: DECIMAL withhold_tax: BIT tax_group_id: INT64 is_dormancy_tracking_active: BIT days_to_inactive: INT32 days_to_dormancy: INT32 days_to_escheat: INT32	id	none	<nil><nil>
m_savings_officer_assignment_history	id: INT64 account_id: INT64 savings_officer_id: INT64 start_date: DATE end_date: DATE createdby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME lastmodifiedby_id: INT64	id	none	<nil><nil>
m_savings_interest_incentives	id: INT64 deposit_account_interest_rate_slab_id: INT64 entiry_type: INT16 attribute_name: INT16 condition_type: INT16 attribute_value: VARCHAR incentive_type: INT16 amount: DECIMAL	id	none	<nil><nil>
m_savings_account_transaction_tax_details	id: INT64 savings_transaction_id: INT64 tax_component_id: INT64 amount: DECIMAL	id	none	<nil><nil>
m_savings_account_transaction	id: INT64 savings_account_id: INT64 office_id: INT64 payment_detail_id: INT64 transaction_type_enum: INT16 is_reversed: BIT transaction_date: DATE amount: DECIMAL overdraft_amount_derived: DECIMAL balance_end_date_derived: DATE balance_number_of_days_derived: INT32 running_balance_derived: DECIMAL cumulative_balance_derived: DECIMAL created_date: DATETIME appuser_id: INT64 is_manual: BIT release_id_of_hold_amount: INT64 is_loan_disbursement: BIT ref_no: VARCHAR	id	none	<nil><nil>
m_savings_account_interest_rate_slab	id: INT64 savings_account_interest_rate_chart_id: INT64 description: VARCHAR period_type_enum: INT16 from_period: INT32 to_period: INT32 amount_range_from: DECIMAL amount_range_to: DECIMAL annual_interest_rate: DECIMAL currency_code: VARCHAR	id	none	<nil><nil>
m_savings_account_interest_rate_chart	id: INT64 savings_account_id: INT64 name: VARCHAR description: VARCHAR from_date: DATE end_date: DATE is_primary_grouping_by_amount: BIT	id	none	<nil><nil>
m_savings_account_charge_paid_by	id: INT64 savings_account_transaction_id: INT64 savings_account_charge_id: INT64 amount: DECIMAL	id	none	<nil><nil>
m_savings_account_charge	id: INT64 savings_account_id: INT64 charge_id: INT64 is_penalty: BIT charge_time_enum: INT16 charge_due_date: DATE fee_on_month: INT16 fee_on_day: INT16 fee_interval: INT16 free_withdrawal_count: INT32 charge_reset_date: DATE charge_calculation_enum: INT16 calculation_percentage: DECIMAL calculation_on_amount: DECIMAL amount: DECIMAL amount_paid_derived: DECIMAL amount_waived_derived: DECIMAL amount_writtenoff_derived: DECIMAL amount_outstanding_derived: DECIMAL is_paid_derived: BIT waived: BIT is_active: BIT inactivated_on_date: DATE	id	none	<nil><nil>
m_savings_account	id: INT64 account_no: VARCHAR external_id: VARCHAR client_id: INT64 group_id: INT64 gsim_id: INT64 product_id: INT64 field_officer_id: INT64 status_enum: INT16 sub_status_enum: INT16 account_type_enum: INT16 deposit_type_enum: INT16 submittedon_date: DATE submittedon_userid: INT64 approvedon_date: DATE approvedon_userid: INT64 rejectedon_date: DATE rejectedon_userid: INT64 withdrawnon_date: DATE withdrawnon_userid: INT64 activatedon_date: DATE activatedon_userid: INT64 closedon_date: DATE closedon_userid: INT64 currency_code: VARCHAR currency_digits: INT16 currency_multiplesof: INT16 nominal_annual_interest_rate: DECIMAL interest_compounding_period_enum: INT16 interest_posting_period_enum: INT16 interest_calculation_type_enum: INT16 interest_calculation_days_in_year_type_enum: INT16 min_required_opening_balance: DECIMAL lockin_period_frequency: DECIMAL lockin_period_frequency_enum: INT16 withdrawal_fee_for_transfer: BIT allow_overdraft: BIT overdraft_limit: DECIMAL nominal_annual_interest_rate_overdraft: DECIMAL min_overdraft_for_interest_calculation: DECIMAL lockedin_until_date_derived: DATE total_deposits_derived: DECIMAL total_withdrawals_derived: DECIMAL total_withdrawal_fees_derived: DECIMAL total_fees_charge_derived: DECIMAL total_penalty_charge_derived: DECIMAL total_annual_fees_derived: DECIMAL total_interest_earned_derived: DECIMAL total_interest_posted_derived: DECIMAL total_overdraft_interest_derived: DECIMAL total_withhold_tax_derived: DECIMAL account_balance_derived: DECIMAL min_required_balance: DECIMAL enforce_min_required_balance: BIT min_balance_for_interest_calculation: DECIMAL start_interest_calculation_date: DATE on_hold_funds_derived: DECIMAL version: INT32 withhold_tax: BIT tax_group_id: INT64 last_interest_calculation_date: DATE total_savings_amount_on_hold: DECIMAL interest_posted_till_date: DATE	id	none	<nil><nil>
m_role_permission	role_id: INT64 permission_id: INT64	role_id permission_id	none	<nil><nil>
m_role	id: INT64 name: VARCHAR description: VARCHAR is_disabled: BIT	id	none	<nil><nil>
m_report_mailing_job_run_history	id: INT64 job_id: INT64 start_datetime: DATETIME end_datetime: DATETIME status: VARCHAR error_message: TEXT error_log: TEXT	id	none	<nil><nil>
m_report_mailing_job_configuration	id: INT32 name: VARCHAR value: VARCHAR	id	none	<nil><nil>
m_report_mailing_job	id: INT64 name: VARCHAR description: TEXT start_datetime: DATETIME recurrence: VARCHAR created_date: DATE createdby_id: INT64 lastmodified_date: DATE lastmodifiedby_id: INT64 email_recipients: TEXT email_subject: VARCHAR email_message: TEXT email_attachment_file_format: VARCHAR stretchy_report_id: INT32 stretchy_report_param_map: TEXT previous_run_datetime: DATETIME next_run_datetime: DATETIME previous_run_status: VARCHAR previous_run_error_log: TEXT previous_run_error_message: TEXT number_of_runs: INT32 is_active: BIT is_deleted: BIT run_as_userid: INT64	id	none	<nil><nil>
m_repayment_with_post_dated_checks	id: INT64 check_no: INT64 amount: DECIMAL loan_id: INT64 repayment_id: INT64 account_no: INT64 bank_name: VARCHAR repayment_date: DATE status: INT16	id	none	<nil><nil>
m_rate	id: INT64 name: VARCHAR percentage: DECIMAL active: BIT product_apply: INT16 created_date: DATETIME createdby_id: INT64 lastmodifiedby_id: INT64 lastmodified_date: DATETIME approve_user: INT64	id	none	<nil><nil>
m_provisioning_history	id: INT64 journal_entry_created: BIT createdby_id: INT64 created_date: DATE lastmodifiedby_id: INT64 lastmodified_date: DATE	id	none	<nil><nil>
m_provisioning_criteria_definition	id: INT64 criteria_id: INT64 category_id: INT64 min_age: INT64 max_age: INT64 provision_percentage: DECIMAL liability_account: INT64 expense_account: INT64	id	none	<nil><nil>
m_provisioning_criteria	id: INT64 criteria_name: VARCHAR createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME	id	none	<nil><nil>
m_provision_category	id: INT64 category_name: VARCHAR description: VARCHAR	id	none	<nil><nil>
m_product_mix	id: INT64 product_id: INT64 restricted_product_id: INT64	id	none	<nil><nil>
m_product_loan_variations_borrower_cycle	id: INT64 loan_product_id: INT64 borrower_cycle_number: INT32 value_condition: INT32 param_type: INT32 default_value: DECIMAL max_value: DECIMAL min_value: DECIMAL	id	none	<nil><nil>
m_product_loan_variable_installment_config	id: INT64 loan_product_id: INT64 minimum_gap: INT32 maximum_gap: INT32	id	none	<nil><nil>
m_product_loan_recalculation_details	id: INT64 product_id: INT64 compound_type_enum: INT16 reschedule_strategy_enum: INT16 rest_frequency_type_enum: INT16 rest_frequency_interval: INT16 arrears_based_on_original_schedule: BIT pre_close_interest_calculation_strategy: INT16 compounding_frequency_type_enum: INT16 compounding_frequency_interval: INT16 rest_frequency_nth_day_enum: INT32 rest_frequency_on_day: INT32 rest_frequency_weekday_enum: INT32 compounding_frequency_nth_day_enum: INT32 compounding_frequency_on_day: INT32 compounding_frequency_weekday_enum: INT32 is_compounding_to_be_posted_as_transaction: BIT allow_compounding_on_eod: BIT	id	none	<nil><nil>
m_product_loan_rate	product_loan_id: INT64 rate_id: INT64	product_loan_id rate_id	none	<nil><nil>
m_product_loan_guarantee_details	id: INT64 loan_product_id: INT64 mandatory_guarantee: DECIMAL minimum_guarantee_from_own_funds: DECIMAL minimum_guarantee_from_guarantor_funds: DECIMAL	id	none	<nil><nil>
m_product_loan_floating_rates	id: INT64 loan_product_id: INT64 floating_rates_id: INT64 interest_rate_differential: DECIMAL min_differential_lending_rate: DECIMAL default_differential_lending_rate: DECIMAL max_differential_lending_rate: DECIMAL is_floating_interest_rate_calculation_allowed: BIT	id	none	<nil><nil>
m_product_loan_configurable_attributes	id: INT64 loan_product_id: INT64 amortization_method_enum: BIT interest_method_enum: BIT loan_transaction_strategy_id: BIT interest_calculated_in_period_enum: BIT arrearstolerance_amount: BIT repay_every: BIT moratorium: BIT grace_on_arrears_ageing: BIT	id	none	<nil><nil>
m_product_loan_charge	product_loan_id: INT64 charge_id: INT64	product_loan_id charge_id	none	<nil><nil>
m_product_loan	id: INT64 short_name: VARCHAR currency_code: VARCHAR currency_digits: INT16 currency_multiplesof: INT16 principal_amount: DECIMAL min_principal_amount: DECIMAL max_principal_amount: DECIMAL arrearstolerance_amount: DECIMAL name: VARCHAR description: VARCHAR fund_id: INT64 is_linked_to_floating_interest_rates: BIT allow_variabe_installments: BIT nominal_interest_rate_per_period: DECIMAL min_nominal_interest_rate_per_period: DECIMAL max_nominal_interest_rate_per_period: DECIMAL interest_period_frequency_enum: INT16 annual_nominal_interest_rate: DECIMAL interest_method_enum: INT16 interest_calculated_in_period_enum: INT16 allow_partial_period_interest_calcualtion: BIT repay_every: INT16 repayment_period_frequency_enum: INT16 number_of_repayments: INT16 min_number_of_repayments: INT16 max_number_of_repayments: INT16 grace_on_principal_periods: INT16 recurring_moratorium_principal_periods: INT16 grace_on_interest_periods: INT16 grace_interest_free_periods: INT16 amortization_method_enum: INT16 accounting_type: INT16 loan_transaction_strategy_id: INT64 external_id: VARCHAR include_in_borrower_cycle: BIT use_borrower_cycle: BIT start_date: DATE close_date: DATE allow_multiple_disbursals: BIT max_disbursals: INT32 max_outstanding_loan_balance: DECIMAL grace_on_arrears_ageing: INT16 overdue_days_for_npa: INT16 days_in_month_enum: INT16 days_in_year_enum: INT16 interest_recalculation_enabled: BIT min_days_between_disbursal_and_first_repayment: INT32 hold_guarantee_funds: BIT principal_threshold_for_last_installment: DECIMAL account_moves_out_of_npa_only_on_arrears_completion: BIT can_define_fixed_emi_amount: BIT instalment_amount_in_multiples_of: DECIMAL can_use_for_topup: BIT sync_expected_with_disbursement_date: BIT is_equal_amortization: BIT fixed_principal_percentage_per_installment: DECIMAL	id	none	<nil><nil>
m_portfolio_command_source	id: INT64 action_name: VARCHAR entity_name: VARCHAR office_id: INT64 group_id: INT64 client_id: INT64 loan_id: INT64 savings_account_id: INT64 api_get_url: VARCHAR resource_id: INT64 subresource_id: INT64 command_as_json: TEXT maker_id: INT64 made_on_date: DATETIME checker_id: INT64 checked_on_date: DATETIME processing_result_enum: INT16 product_id: INT64 transaction_id: VARCHAR creditbureau_id: INT64 organisation_creditbureau_id: INT64	id	none	<nil><nil>
m_portfolio_account_associations	id: INT64 loan_account_id: INT64 savings_account_id: INT64 linked_loan_account_id: INT64 linked_savings_account_id: INT64 association_type_enum: INT16 is_active: BIT	id	none	<nil><nil>
m_pocket_accounts_mapping	id: INT64 pocket_id: INT64 account_id: INT64 account_type: INT32 account_number: VARCHAR	id	none	<nil><nil>
m_pocket	id: INT64 app_user_id: INT64	id	none	<nil><nil>
m_permission	id: INT64 grouping: VARCHAR code: VARCHAR entity_name: VARCHAR action_name: VARCHAR can_maker_checker: BIT	id	none	<nil><nil>
m_payment_type	id: INT32 value: VARCHAR description: VARCHAR is_cash_payment: BIT order_position: INT32	id	none	<nil><nil>
m_payment_detail	id: INT64 payment_type_id: INT32 account_number: VARCHAR check_number: VARCHAR receipt_number: VARCHAR bank_number: VARCHAR routing_code: VARCHAR	id	none	<nil><nil>
m_password_validation_policy	id: INT32 regex: TEXT description: TEXT active: BIT key: VARCHAR	id	none	<nil><nil>
m_organisation_currency	id: INT64 code: VARCHAR decimal_places: INT16 currency_multiplesof: INT16 name: VARCHAR display_symbol: VARCHAR internationalized_name_code: VARCHAR	id	none	<nil><nil>
m_organisation_creditbureau	id: INT64 alias: VARCHAR creditbureau_id: INT64 isActive: BIT	id	none	<nil><nil>
m_office_transaction	id: INT64 from_office_id: INT64 to_office_id: INT64 currency_code: VARCHAR currency_digits: INT32 transaction_amount: DECIMAL transaction_date: DATE description: VARCHAR	id	none	<nil><nil>
m_office	id: INT64 parent_id: INT64 hierarchy: VARCHAR external_id: VARCHAR name: VARCHAR opening_date: DATE	id	none	<nil><nil>
m_note	id: INT64 client_id: INT64 group_id: INT64 loan_id: INT64 loan_transaction_id: INT64 savings_account_id: INT64 savings_account_transaction_id: INT64 share_account_id: INT64 note_type_enum: INT16 note: VARCHAR created_date: DATETIME createdby_id: INT64 lastmodified_date: DATETIME lastmodifiedby_id: INT64	id	none	<nil><nil>
m_meeting	id: INT64 calendar_instance_id: INT64 meeting_date: DATE	id	none	<nil><nil>
m_mandatory_savings_schedule	id: INT64 savings_account_id: INT64 fromdate: DATE duedate: DATE installment: INT16 deposit_amount: DECIMAL deposit_amount_completed_derived: DECIMAL total_paid_in_advance_derived: DECIMAL total_paid_late_derived: DECIMAL completed_derived: BIT obligations_met_on_date: DATE createdby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME lastmodifiedby_id: INT64	id	none	<nil><nil>
m_loanproduct_provisioning_mapping	id: INT64 product_id: INT64 criteria_id: INT64	id	none	<nil><nil>
m_loanproduct_provisioning_entry	id: INT64 history_id: INT64 criteria_id: INT64 currency_code: VARCHAR office_id: INT64 product_id: INT64 category_id: INT64 overdue_in_days: INT64 reseve_amount: DECIMAL liability_account: INT64 expense_account: INT64	id	none	<nil><nil>
m_loan_transaction_repayment_schedule_mapping	id: INT64 loan_transaction_id: INT64 loan_repayment_schedule_id: INT64 amount: DECIMAL principal_portion_derived: DECIMAL interest_portion_derived: DECIMAL fee_charges_portion_derived: DECIMAL penalty_charges_portion_derived: DECIMAL	id	none	<nil><nil>
m_loan_transaction_accrual_correction_2025_07_05	id: INT64 loan_id: INT64 office_id: INT64 payment_detail_id: INT64 is_reversed: BIT external_id: VARCHAR transaction_type_enum: INT16 transaction_date: DATE amount: DECIMAL principal_portion_derived: DECIMAL interest_portion_derived: DECIMAL fee_charges_portion_derived: DECIMAL penalty_charges_portion_derived: DECIMAL overpayment_portion_derived: DECIMAL unrecognized_income_portion: DECIMAL outstanding_loan_balance_derived: DECIMAL submitted_on_date: DATE manually_adjusted_or_reversed: BIT created_date: DATETIME appuser_id: INT64	id	none	<nil><nil>
m_loan_transaction	id: INT64 loan_id: INT64 office_id: INT64 payment_detail_id: INT64 is_reversed: BIT external_id: VARCHAR transaction_type_enum: INT16 transaction_date: DATE amount: DECIMAL principal_portion_derived: DECIMAL interest_portion_derived: DECIMAL fee_charges_portion_derived: DECIMAL penalty_charges_portion_derived: DECIMAL overpayment_portion_derived: DECIMAL unrecognized_income_portion: DECIMAL outstanding_loan_balance_derived: DECIMAL submitted_on_date: DATE manually_adjusted_or_reversed: BIT created_date: DATETIME appuser_id: INT64	id	none	<nil><nil>
m_loan_tranche_disbursement_charge	id: INT64 loan_charge_id: INT64 disbursement_detail_id: INT64	id	none	<nil><nil>
m_loan_tranche_charges	id: INT64 loan_id: INT64 charge_id: INT64	id	none	<nil><nil>
m_loan_topup	id: INT64 loan_id: INT64 closure_loan_id: INT64 account_transfer_details_id: INT64 topup_amount: DECIMAL	id	none	<nil><nil>
m_loan_term_variations	id: INT64 loan_id: INT64 term_type: INT16 applicable_date: DATE decimal_value: DECIMAL date_value: DATE is_specific_to_installment: BIT applied_on_loan_status: INT16 is_active: BIT parent_id: INT64	id	none	<nil><nil>
m_loan_reschedule_request_term_variations_mapping	id: INT64 loan_reschedule_request_id: INT64 loan_term_variations_id: INT64	id	none	<nil><nil>
m_loan_reschedule_request	id: INT64 loan_id: INT64 status_enum: INT16 reschedule_from_installment: INT16 reschedule_from_date: DATE recalculate_interest: BIT reschedule_reason_cv_id: INT32 reschedule_reason_comment: VARCHAR submitted_on_date: DATE submitted_by_user_id: INT64 approved_on_date: DATE approved_by_user_id: INT64 rejected_on_date: DATE rejected_by_user_id: INT64	id	none	<nil><nil>
m_loan_repayment_schedule_history	id: INT64 loan_id: INT64 loan_reschedule_request_id: INT64 fromdate: DATE duedate: DATE installment: INT16 principal_amount: DECIMAL interest_amount: DECIMAL fee_charges_amount: DECIMAL penalty_charges_amount: DECIMAL createdby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME lastmodifiedby_id: INT64 version: INT32	id	none	<nil><nil>
m_loan_repayment_schedule	id: INT64 loan_id: INT64 fromdate: DATE duedate: DATE installment: INT16 principal_amount: DECIMAL principal_completed_derived: DECIMAL principal_writtenoff_derived: DECIMAL interest_amount: DECIMAL interest_completed_derived: DECIMAL interest_writtenoff_derived: DECIMAL interest_waived_derived: DECIMAL accrual_interest_derived: DECIMAL reschedule_interest_portion: DECIMAL fee_charges_amount: DECIMAL fee_charges_completed_derived: DECIMAL fee_charges_writtenoff_derived: DECIMAL fee_charges_waived_derived: DECIMAL accrual_fee_charges_derived: DECIMAL penalty_charges_amount: DECIMAL penalty_charges_completed_derived: DECIMAL penalty_charges_writtenoff_derived: DECIMAL penalty_charges_waived_derived: DECIMAL accrual_penalty_charges_derived: DECIMAL total_paid_in_advance_derived: DECIMAL total_paid_late_derived: DECIMAL completed_derived: BIT obligations_met_on_date: DATE createdby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME lastmodifiedby_id: INT64 recalculated_interest_component: BIT	id	none	<nil><nil>
m_loan_recalculation_details	id: INT64 loan_id: INT64 compound_type_enum: INT16 reschedule_strategy_enum: INT16 rest_frequency_type_enum: INT16 rest_frequency_interval: INT16 compounding_frequency_type_enum: INT16 compounding_frequency_interval: INT16 rest_frequency_nth_day_enum: INT32 rest_frequency_on_day: INT32 rest_frequency_weekday_enum: INT32 compounding_frequency_nth_day_enum: INT32 compounding_frequency_on_day: INT32 is_compounding_to_be_posted_as_transaction: BIT compounding_frequency_weekday_enum: INT32 allow_compounding_on_eod: BIT	id	none	<nil><nil>
m_loan_rate	loan_id: INT64 rate_id: INT64	loan_id rate_id	none	<nil><nil>
m_loan_product_category	id: INT32 loan_product_id: INT32 short_code: VARCHAR loan_category1: VARCHAR loan_category2: INT32 approval_category: VARCHAR flat_interest_rate: VARCHAR	id	none	<nil><nil>
m_loan_paid_in_advance	loan_id: INT64 principal_in_advance_derived: DECIMAL interest_in_advance_derived: DECIMAL fee_charges_in_advance_derived: DECIMAL penalty_charges_in_advance_derived: DECIMAL total_in_advance_derived: DECIMAL	loan_id	none	<nil><nil>
m_loan_overdue_installment_charge	id: INT64 loan_charge_id: INT64 loan_schedule_id: INT64 frequency_number: INT32	id	none	<nil><nil>
m_loan_officer_assignment_history	id: INT64 loan_id: INT64 loan_officer_id: INT64 start_date: DATE end_date: DATE createdby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME lastmodifiedby_id: INT64	id	none	<nil><nil>
m_loan_interest_recalculation_additional_details	id: INT64 loan_repayment_schedule_id: INT64 effective_date: DATE amount: DECIMAL	id	none	<nil><nil>
m_loan_installment_charge	id: INT64 loan_charge_id: INT64 loan_schedule_id: INT64 due_date: DATE amount: DECIMAL amount_paid_derived: DECIMAL amount_waived_derived: DECIMAL amount_writtenoff_derived: DECIMAL amount_outstanding_derived: DECIMAL is_paid_derived: BIT waived: BIT amount_through_charge_payment: DECIMAL	id	none	<nil><nil>
m_loan_disbursement_detail	id: INT64 loan_id: INT64 expected_disburse_date: DATETIME disbursedon_date: DATETIME principal: DECIMAL net_disbursal_amount: DECIMAL	id	none	<nil><nil>
m_loan_collateral_management	id: INT64 quantity: DECIMAL loan_id: INT64 client_collateral_id: INT64 is_released: BIT transaction_id: INT64	id	none	<nil><nil>
m_loan_collateral	id: INT64 loan_id: INT64 type_cv_id: INT32 value: DECIMAL description: VARCHAR	id	none	<nil><nil>
m_loan_charge_paid_by_accrual_correction_2025_07_05	id: INT64 loan_transaction_id: INT64 loan_charge_id: INT64 amount: DECIMAL installment_number: INT16	id	none	<nil><nil>
m_loan_charge_paid_by	id: INT64 loan_transaction_id: INT64 loan_charge_id: INT64 amount: DECIMAL installment_number: INT16	id	none	<nil><nil>
m_loan_charge	id: INT64 loan_id: INT64 charge_id: INT64 is_penalty: BIT charge_time_enum: INT16 due_for_collection_as_of_date: DATE charge_calculation_enum: INT16 charge_payment_mode_enum: INT16 calculation_percentage: DECIMAL calculation_on_amount: DECIMAL charge_amount_or_percentage: DECIMAL amount: DECIMAL amount_paid_derived: DECIMAL amount_waived_derived: DECIMAL amount_writtenoff_derived: DECIMAL amount_outstanding_derived: DECIMAL is_paid_derived: BIT waived: BIT min_cap: DECIMAL max_cap: DECIMAL is_active: BIT	id	none	<nil><nil>
m_loan_arrears_aging	loan_id: INT64 principal_overdue_derived: DECIMAL interest_overdue_derived: DECIMAL fee_charges_overdue_derived: DECIMAL penalty_charges_overdue_derived: DECIMAL total_overdue_derived: DECIMAL overdue_since_date_derived: DATE	loan_id	none	<nil><nil>
m_loan	id: INT64 account_no: VARCHAR external_id: VARCHAR client_id: INT64 group_id: INT64 glim_id: INT64 product_id: INT64 fund_id: INT64 loan_officer_id: INT64 loanpurpose_cv_id: INT32 loan_status_id: INT16 loan_type_enum: INT16 currency_code: VARCHAR currency_digits: INT16 currency_multiplesof: INT16 principal_amount_proposed: DECIMAL principal_amount: DECIMAL approved_principal: DECIMAL net_disbursal_amount: DECIMAL arrearstolerance_amount: DECIMAL is_floating_interest_rate: BIT interest_rate_differential: DECIMAL nominal_interest_rate_per_period: DECIMAL interest_period_frequency_enum: INT16 annual_nominal_interest_rate: DECIMAL interest_method_enum: INT16 interest_calculated_in_period_enum: INT16 allow_partial_period_interest_calcualtion: BIT term_frequency: INT16 term_period_frequency_enum: INT16 repay_every: INT16 repayment_period_frequency_enum: INT16 number_of_repayments: INT16 grace_on_principal_periods: INT16 recurring_moratorium_principal_periods: INT16 grace_on_interest_periods: INT16 grace_interest_free_periods: INT16 amortization_method_enum: INT16 submittedon_date: DATE submittedon_userid: INT64 approvedon_date: DATE approvedon_userid: INT64 expected_disbursedon_date: DATE expected_firstrepaymenton_date: DATE interest_calculated_from_date: DATE disbursedon_date: DATE disbursedon_userid: INT64 expected_maturedon_date: DATE maturedon_date: DATE closedon_date: DATE closedon_userid: INT64 total_charges_due_at_disbursement_derived: DECIMAL principal_disbursed_derived: DECIMAL principal_repaid_derived: DECIMAL principal_writtenoff_derived: DECIMAL principal_outstanding_derived: DECIMAL interest_charged_derived: DECIMAL interest_repaid_derived: DECIMAL interest_waived_derived: DECIMAL interest_writtenoff_derived: DECIMAL interest_outstanding_derived: DECIMAL fee_charges_charged_derived: DECIMAL fee_charges_repaid_derived: DECIMAL fee_charges_waived_derived: DECIMAL fee_charges_writtenoff_derived: DECIMAL fee_charges_outstanding_derived: DECIMAL penalty_charges_charged_derived: DECIMAL penalty_charges_repaid_derived: DECIMAL penalty_charges_waived_derived: DECIMAL penalty_charges_writtenoff_derived: DECIMAL penalty_charges_outstanding_derived: DECIMAL total_expected_repayment_derived: DECIMAL total_repayment_derived: DECIMAL total_expected_costofloan_derived: DECIMAL total_costofloan_derived: DECIMAL total_waived_derived: DECIMAL total_writtenoff_derived: DECIMAL total_outstanding_derived: DECIMAL total_overpaid_derived: DECIMAL rejectedon_date: DATE rejectedon_userid: INT64 rescheduledon_date: DATE rescheduledon_userid: INT64 withdrawnon_date: DATE withdrawnon_userid: INT64 writtenoffon_date: DATE loan_transaction_strategy_id: INT64 sync_disbursement_with_meeting: BIT loan_counter: INT16 loan_product_counter: INT16 fixed_emi_amount: DECIMAL max_outstanding_loan_balance: DECIMAL grace_on_arrears_ageing: INT16 is_npa: BIT total_recovered_derived: DECIMAL accrued_till: DATE interest_recalcualated_on: DATE days_in_month_enum: INT16 days_in_year_enum: INT16 interest_recalculation_enabled: BIT guarantee_amount_derived: DECIMAL create_standing_instruction_at_disbursement: BIT version: INT32 writeoff_reason_cv_id: INT32 loan_sub_status_id: INT16 is_topup: BIT is_equal_amortization: BIT fixed_principal_percentage_per_installment: DECIMAL	id	none	<nil><nil>
m_interest_rate_slab	id: INT64 interest_rate_chart_id: INT64 description: VARCHAR period_type_enum: INT16 from_period: INT32 to_period: INT32 amount_range_from: DECIMAL amount_range_to: DECIMAL annual_interest_rate: DECIMAL currency_code: VARCHAR	id	none	<nil><nil>
m_interest_rate_chart	id: INT64 name: VARCHAR description: VARCHAR from_date: DATE end_date: DATE is_primary_grouping_by_amount: BIT	id	none	<nil><nil>
m_interest_incentives	id: INT64 interest_rate_slab_id: INT64 entiry_type: INT16 attribute_name: INT16 condition_type: INT16 attribute_value: VARCHAR incentive_type: INT16 amount: DECIMAL	id	none	<nil><nil>
m_import_document	id: INT64 document_id: INT32 import_time: DATETIME end_time: DATETIME entity_type: INT8 completed: BIT total_records: INT64 success_count: INT64 failure_count: INT64 createdby_id: INT64	id	none	<nil><nil>
m_image	id: INT64 location: VARCHAR storage_type_enum: INT16	id	none	<nil><nil>
m_hook_templates	id: INT16 name: VARCHAR	id	none	<nil><nil>
m_hook_schema	id: INT16 hook_template_id: INT16 field_type: VARCHAR field_name: VARCHAR placeholder: VARCHAR optional: BIT	id	none	<nil><nil>
m_hook_registered_events	id: INT64 hook_id: INT64 entity_name: VARCHAR action_name: VARCHAR	id	none	<nil><nil>
m_hook_configuration	id: INT64 hook_id: INT64 field_type: VARCHAR field_name: VARCHAR field_value: VARCHAR	id	none	<nil><nil>
m_hook	id: INT64 template_id: INT16 is_active: BIT name: VARCHAR createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME ugd_template_id: INT64	id	none	<nil><nil>
m_holiday_office	holiday_id: INT64 office_id: INT64	holiday_id office_id	none	<nil><nil>
m_holiday	id: INT64 name: VARCHAR from_date: DATETIME to_date: DATETIME repayments_rescheduled_to: DATETIME status_enum: INT32 processed: BIT description: VARCHAR rescheduling_type: INT32	id	none	<nil><nil>
m_guarantor_transaction	id: INT64 guarantor_fund_detail_id: INT64 loan_transaction_id: INT64 deposit_on_hold_transaction_id: INT64 is_reversed: BIT	id	none	<nil><nil>
m_guarantor_funding_details	id: INT64 guarantor_id: INT64 account_associations_id: INT64 amount: DECIMAL amount_released_derived: DECIMAL amount_remaining_derived: DECIMAL amount_transfered_derived: DECIMAL status_enum: INT16	id	none	<nil><nil>
m_guarantor	id: INT64 loan_id: INT64 client_reln_cv_id: INT32 type_enum: INT16 entity_id: INT64 firstname: VARCHAR lastname: VARCHAR dob: DATE address_line_1: VARCHAR address_line_2: VARCHAR city: VARCHAR state: VARCHAR country: VARCHAR zip: VARCHAR house_phone_number: VARCHAR mobile_number: VARCHAR comment: VARCHAR is_active: BIT	id	none	<nil><nil>
m_group_roles	id: INT64 client_id: INT64 group_id: INT64 role_cv_id: INT32	id	none	<nil><nil>
m_group_level	id: INT32 parent_id: INT32 super_parent: BIT level_name: VARCHAR recursable: BIT can_have_clients: BIT	id	none	<nil><nil>
m_group_client	group_id: INT64 client_id: INT64	group_id client_id	none	<nil><nil>
m_group	id: INT64 external_id: VARCHAR status_enum: INT32 activation_date: DATE office_id: INT64 staff_id: INT64 parent_id: INT64 level_id: INT32 display_name: VARCHAR hierarchy: VARCHAR closure_reason_cv_id: INT32 closedon_date: DATE activatedon_userid: INT64 submittedon_date: DATE submittedon_userid: INT64 closedon_userid: INT64 account_no: VARCHAR	id	none	<nil><nil>
m_fund	id: INT64 name: VARCHAR external_id: VARCHAR	id	none	<nil><nil>
m_floating_rates_periods	id: INT64 floating_rates_id: INT64 from_date: DATETIME interest_rate: DECIMAL is_differential_to_base_lending_rate: BIT is_active: BIT createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME	id	none	<nil><nil>
m_floating_rates	id: INT64 name: VARCHAR is_base_lending_rate: BIT is_active: BIT createdby_id: INT64 created_date: DATETIME lastmodifiedby_id: INT64 lastmodified_date: DATETIME	id	none	<nil><nil>
m_field_configuration	id: INT64 entity: VARCHAR subentity: VARCHAR field: VARCHAR is_enabled: BIT is_mandatory: BIT validation_regex: VARCHAR	id	none	<nil><nil>
m_family_members	id: INT64 client_id: INT64 firstname: VARCHAR middlename: VARCHAR lastname: VARCHAR qualification: VARCHAR relationship_cv_id: INT32 marital_status_cv_id: INT32 gender_cv_id: INT32 date_of_birth: DATE age: INT32 profession_cv_id: INT32 mobile_number: VARCHAR is_dependent: BIT	id	none	<nil><nil>
m_entity_to_entity_mapping	id: INT64 rel_id: INT64 from_id: INT64 to_id: INT64 start_date: DATE end_date: DATE	id	none	<nil><nil>
m_entity_to_entity_access	id: INT64 entity_type: VARCHAR entity_id: INT64 access_type_code_value_id: INT32 second_entity_type: VARCHAR second_entity_id: INT64	id	none	<nil><nil>
m_entity_relation	id: INT64 from_entity_type: INT32 to_entity_type: INT32 code_name: VARCHAR	id	none	<nil><nil>
m_entity_datatable_check	id: INT32 application_table_name: VARCHAR x_registered_table_name: VARCHAR status_enum: INT32 system_defined: BIT product_id: INT64	id	none	<nil><nil>
m_document	id: INT32 parent_entity_type: VARCHAR parent_entity_id: INT32 name: VARCHAR file_name: VARCHAR size: INT32 type: VARCHAR description: VARCHAR location: VARCHAR storage_type_enum: INT16	id	none	<nil><nil>
m_deposit_product_term_and_preclosure	id: INT64 savings_product_id: INT64 min_deposit_term: INT32 max_deposit_term: INT32 min_deposit_term_type_enum: INT16 max_deposit_term_type_enum: INT16 in_multiples_of_deposit_term: INT32 in_multiples_of_deposit_term_type_enum: INT16 pre_closure_penal_applicable: BIT pre_closure_penal_interest: DECIMAL pre_closure_penal_interest_on_enum: INT16 min_deposit_amount: DECIMAL max_deposit_amount: DECIMAL deposit_amount: DECIMAL	id	none	<nil><nil>
m_deposit_product_recurring_detail	id: INT64 savings_product_id: INT64 is_mandatory: BIT allow_withdrawal: BIT adjust_advance_towards_future_payments: BIT	id	none	<nil><nil>
m_deposit_product_interest_rate_chart	deposit_product_id: INT64 interest_rate_chart_id: INT64		none	<nil><nil>
m_deposit_account_term_and_preclosure	id: INT64 savings_account_id: INT64 min_deposit_term: INT32 max_deposit_term: INT32 min_deposit_term_type_enum: INT16 max_deposit_term_type_enum: INT16 in_multiples_of_deposit_term: INT32 in_multiples_of_deposit_term_type_enum: INT16 pre_closure_penal_applicable: BIT pre_closure_penal_interest: DECIMAL pre_closure_penal_interest_on_enum: INT16 deposit_period: INT32 deposit_period_frequency_enum: INT16 deposit_amount: DECIMAL maturity_amount: DECIMAL maturity_date: DATE on_account_closure_enum: INT16 expected_firstdepositon_date: DATE transfer_interest_to_linked_account: BIT transfer_to_savings_account_id: INT64	id	none	<nil><nil>
m_deposit_account_recurring_detail	id: INT64 savings_account_id: INT64 mandatory_recommended_deposit_amount: DECIMAL is_mandatory: BIT allow_withdrawal: BIT adjust_advance_towards_future_payments: BIT is_calendar_inherited: BIT total_overdue_amount: DECIMAL no_of_overdue_installments: INT32	id	none	<nil><nil>
m_deposit_account_on_hold_transaction	id: INT64 savings_account_id: INT64 amount: DECIMAL transaction_type_enum: INT16 transaction_date: DATE is_reversed: BIT created_date: DATETIME	id	none	<nil><nil>
m_currency	id: INT64 code: VARCHAR decimal_places: INT16 currency_multiplesof: INT16 display_symbol: VARCHAR name: VARCHAR internationalized_name_code: VARCHAR	id	none	<nil><nil>
m_creditreport	id: INT32 creditBureauId: INT64 nationalId: VARCHAR creditReports: BLOB	id	none	<nil><nil>
m_creditbureau_token	id: INT32 username: VARCHAR token: TEXT tokenType: VARCHAR expiresIn: VARCHAR issued: VARCHAR expiryDate: DATE	id	none	<nil><nil>
m_creditbureau_loanproduct_mapping	id: INT64 organisation_creditbureau_id: INT64 loan_product_id: INT64 is_creditcheck_mandatory: BIT skip_creditcheck_in_failure: BIT stale_period: INT32 isActive: BIT	id	none	<nil><nil>
m_creditbureau_configuration	id: INT64 configkey: VARCHAR value: TEXT organisation_creditbureau_id: INT64 description: VARCHAR	id	none	<nil><nil>
m_creditbureau	id: INT64 name: VARCHAR product: VARCHAR country: VARCHAR implementationKey: VARCHAR	id	none	<nil><nil>
m_collateral_management	id: INT64 name: VARCHAR quality: VARCHAR base_price: DECIMAL unit_type: VARCHAR pct_to_base: DECIMAL currency: INT64	id	none	<nil><nil>
m_code_value	id: INT32 code_id: INT32 code_value: VARCHAR code_description: VARCHAR order_position: INT32 code_score: INT32 is_active: BIT is_mandatory: BIT	id	none	<nil><nil>
m_code	id: INT32 code_name: VARCHAR is_system_defined: BIT	id	none	<nil><nil>
m_client_transfer_details	id: INT64 client_id: INT64 from_office_id: INT64 to_office_id: INT64 proposed_transfer_date: DATE transfer_type: INT8 submitted_on: DATE submitted_by: INT64	id	none	<nil><nil>
m_client_transaction	id: INT64 client_id: INT64 office_id: INT64 currency_code: VARCHAR payment_detail_id: INT64 is_reversed: BIT external_id: VARCHAR transaction_date: DATE transaction_type_enum: INT16 amount: DECIMAL created_date: DATETIME appuser_id: INT64	id	none	<nil><nil>
m_client_non_person	id: INT64 client_id: INT64 constitution_cv_id: INT32 incorp_no: VARCHAR incorp_validity_till: DATETIME main_business_line_cv_id: INT32 remarks: VARCHAR	id	none	<nil><nil>
m_client_identifier	id: INT64 client_id: INT64 document_type_id: INT32 document_key: VARCHAR status: INT32 active: INT32 description: VARCHAR createdby_id: INT64 lastmodifiedby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME	id	none	<nil><nil>
m_client_collateral_management	id: INT64 quantity: DECIMAL client_id: INT64 collateral_id: INT64	id	none	<nil><nil>
m_client_charge_paid_by	id: INT64 client_transaction_id: INT64 client_charge_id: INT64 amount: DECIMAL	id	none	<nil><nil>
m_client_charge	id: INT64 client_id: INT64 charge_id: INT64 is_penalty: BIT charge_time_enum: INT16 charge_due_date: DATE charge_calculation_enum: INT16 amount: DECIMAL amount_paid_derived: DECIMAL amount_waived_derived: DECIMAL amount_writtenoff_derived: DECIMAL amount_outstanding_derived: DECIMAL is_paid_derived: BIT waived: BIT is_active: BIT inactivated_on_date: DATE	id	none	<nil><nil>
m_client_attendance	id: INT64 client_id: INT64 meeting_id: INT64 attendance_type_enum: INT16	id	none	<nil><nil>
m_client_address	id: INT64 client_id: INT64 address_id: INT64 address_type_id: INT32 is_active: BIT	id	none	<nil><nil>
m_client	id: INT64 account_no: VARCHAR external_id: VARCHAR status_enum: INT32 sub_status: INT32 activation_date: DATE office_joining_date: DATE office_id: INT64 transfer_to_office_id: INT64 staff_id: INT64 firstname: VARCHAR middlename: VARCHAR lastname: VARCHAR fullname: VARCHAR display_name: VARCHAR mobile_no: VARCHAR is_staff: BIT gender_cv_id: INT32 date_of_birth: DATE image_id: INT64 closure_reason_cv_id: INT32 closedon_date: DATE updated_by: INT64 updated_on: DATE submittedon_date: DATE submittedon_userid: INT64 activatedon_userid: INT64 closedon_userid: INT64 default_savings_product: INT64 default_savings_account: INT64 client_type_cv_id: INT32 client_classification_cv_id: INT32 reject_reason_cv_id: INT32 rejectedon_date: DATE rejectedon_userid: INT64 withdraw_reason_cv_id: INT32 withdrawn_on_date: DATE withdraw_on_userid: INT64 reactivated_on_date: DATE reactivated_on_userid: INT64 legal_form_enum: INT32 reopened_on_date: DATE reopened_by_userid: INT64 email_address: VARCHAR proposed_transfer_date: DATE	id	none	<nil><nil>
m_charge	id: INT64 name: VARCHAR currency_code: VARCHAR charge_applies_to_enum: INT16 charge_time_enum: INT16 charge_calculation_enum: INT16 charge_payment_mode_enum: INT16 amount: DECIMAL fee_on_day: INT16 fee_interval: INT16 fee_on_month: INT16 is_penalty: BIT is_active: BIT is_deleted: BIT min_cap: DECIMAL max_cap: DECIMAL fee_frequency: INT16 is_free_withdrawal: BIT free_withdrawal_charge_frequency: INT32 restart_frequency: INT32 restart_frequency_enum: INT32 is_payment_type: BIT payment_type_id: INT32 income_or_liability_account_id: INT64 tax_group_id: INT64	id	none	<nil><nil>
m_cashiers	id: INT64 staff_id: INT64 teller_id: INT64 description: VARCHAR start_date: DATE end_date: DATE start_time: VARCHAR end_time: VARCHAR full_day: BIT	id	none	<nil><nil>
m_cashier_transactions	id: INT64 cashier_id: INT64 txn_type: INT16 txn_amount: DECIMAL txn_date: DATE created_date: DATETIME entity_type: VARCHAR entity_id: INT64 txn_note: VARCHAR currency_code: VARCHAR	id	none	<nil><nil>
m_calendar_instance	id: INT64 calendar_id: INT64 entity_id: INT64 entity_type_enum: INT16	id	none	<nil><nil>
m_calendar_history	id: INT64 calendar_id: INT64 title: VARCHAR description: VARCHAR location: VARCHAR start_date: DATE end_date: DATE duration: INT16 calendar_type_enum: INT16 repeating: BIT recurrence: VARCHAR remind_by_enum: INT16 first_reminder: INT16 second_reminder: INT16	id	none	<nil><nil>
m_calendar	id: INT64 title: VARCHAR description: VARCHAR location: VARCHAR start_date: DATE end_date: DATE duration: INT16 calendar_type_enum: INT16 repeating: BIT recurrence: VARCHAR remind_by_enum: INT16 first_reminder: INT16 second_reminder: INT16 createdby_id: INT64 lastmodifiedby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME meeting_time: TIME	id	none	<nil><nil>
m_appuser_role	appuser_id: INT64 role_id: INT64	appuser_id role_id	none	<nil><nil>
m_appuser_previous_password	id: INT64 user_id: INT64 password: VARCHAR removal_date: DATE	id	none	<nil><nil>
m_appuser	id: INT64 is_deleted: BIT office_id: INT64 staff_id: INT64 username: VARCHAR firstname: VARCHAR lastname: VARCHAR password: VARCHAR email: VARCHAR firsttime_login_remaining: BIT nonexpired: BIT nonlocked: BIT nonexpired_credentials: BIT enabled: BIT last_time_password_updated: DATE password_never_expires: BIT is_self_service_user: BIT cannot_change_password: BIT	id	none	<nil><nil>
m_adhoc	id: INT64 name: VARCHAR query: VARCHAR table_name: VARCHAR table_fields: VARCHAR email: VARCHAR IsActive: BIT created_date: DATETIME createdby_id: INT64 lastmodifiedby_id: INT64 lastmodified_date: DATETIME report_run_frequency_code: INT32 report_run_every: INT32 last_run: TIMESTAMP	id	none	<nil><nil>
m_address	id: INT64 street: VARCHAR address_line_1: VARCHAR address_line_2: VARCHAR address_line_3: VARCHAR town_village: VARCHAR city: VARCHAR county_district: VARCHAR state_province_id: INT32 country_id: INT32 postal_code: VARCHAR latitude: DECIMAL longitude: DECIMAL created_by: VARCHAR created_on: DATE updated_by: VARCHAR updated_on: DATE	id	none	<nil><nil>
m_account_transfer_transaction	id: INT64 account_transfer_details_id: INT64 from_savings_transaction_id: INT64 from_loan_transaction_id: INT64 to_savings_transaction_id: INT64 to_loan_transaction_id: INT64 is_reversed: BIT transaction_date: DATE currency_code: VARCHAR currency_digits: INT16 currency_multiplesof: INT16 amount: DECIMAL description: VARCHAR	id	none	<nil><nil>
m_account_transfer_standing_instructions_history	id: INT64 standing_instruction_id: INT64 status: VARCHAR execution_time: DATETIME amount: DECIMAL error_log: VARCHAR	id	none	<nil><nil>
m_account_transfer_standing_instructions	id: INT64 name: VARCHAR account_transfer_details_id: INT64 priority: INT8 status: INT8 instruction_type: INT8 amount: DECIMAL valid_from: DATE valid_till: DATE recurrence_type: INT8 recurrence_frequency: INT16 recurrence_interval: INT16 recurrence_on_day: INT16 recurrence_on_month: INT16 last_run_date: DATE	id	none	<nil><nil>
m_account_transfer_details	id: INT64 from_office_id: INT64 to_office_id: INT64 from_client_id: INT64 to_client_id: INT64 from_savings_account_id: INT64 to_savings_account_id: INT64 from_loan_account_id: INT64 to_loan_account_id: INT64 transfer_type: INT16	id	none	<nil><nil>
job_run_history	id: INT64 job_id: INT64 version: INT64 start_time: DATETIME end_time: DATETIME status: VARCHAR error_message: TEXT trigger_type: VARCHAR error_log: TEXT	id	none	<nil><nil>
job_parameters	id: INT64 job_id: INT64 parameter_name: VARCHAR parameter_value: INT32	id	none	<nil><nil>
job	id: INT64 name: VARCHAR display_name: VARCHAR cron_expression: VARCHAR create_time: DATETIME task_priority: INT16 group_name: VARCHAR previous_run_start_time: DATETIME next_run_time: DATETIME job_key: VARCHAR initializing_errorlog: TEXT is_active: BIT currently_running: BIT updates_allowed: BIT scheduler_group: INT16 is_misfired: BIT node_id: INT32 is_mismatched_job: BIT	id	none	<nil><nil>
interop_identifier	id: INT64 account_id: INT64 type: VARCHAR a_value: VARCHAR sub_value_or_type: VARCHAR created_by: VARCHAR created_on: TIMESTAMP modified_by: VARCHAR modified_on: TIMESTAMP	id	none	<nil><nil>
gsim_accounts	id: INT64 group_id: INT64 account_number: VARCHAR parent_deposit: DECIMAL child_accounts_count: INT32 accepting_child: BIT savings_status_id: INT16 application_id: DECIMAL	id	none	<nil><nil>
glim_accounts	id: INT64 group_id: INT64 account_number: VARCHAR principal_amount: DECIMAL child_accounts_count: INT32 accepting_child: BIT loan_status_id: INT16 application_id: DECIMAL	id	none	<nil><nil>
fused_table_pos	key: VARCHAR pos: INT64	key	none	<nil><nil>
dual			none	<nil><nil>
client_device_registration	id: INT64 client_id: INT64 updatedon_date: DATETIME registration_id: VARCHAR	id	none	<nil><nil>
c_external_service_properties	name: VARCHAR value: VARCHAR external_service_id: INT64		none	<nil><nil>
c_external_service	id: INT64 name: VARCHAR	id	none	<nil><nil>
c_configuration	id: INT64 name: VARCHAR value: INT32 date_value: DATE string_value: VARCHAR enabled: BIT is_trap_door: BIT description: VARCHAR	id	none	<nil><nil>
c_cache	id: INT64 cache_type_enum: INT8	id	none	<nil><nil>
c_account_number_format	id: INT64 account_type_enum: INT16 prefix_type_enum: INT16 prefix_character: VARCHAR	id	none	<nil><nil>
arthavida_schedule_correction	branch: VARCHAR loan_account: VARCHAR loan_id: INT32 correct_1st_due_date: DATE id: INT32	id	none	<nil><nil>
arthavida_grace_period_skip_new	loan_account_no: VARCHAR loan_id: INT32 skip_days: INT32 step: INT32 id: INT32	id	none	<nil><nil>
arthavida_grace_period_skip	external_id: VARCHAR loan_account_no: VARCHAR loan_id: INT32 expectedmatureDate: DATE grace_period-M: INT32 after_grace_period_applied: DATE skip_days: INT32 id: INT32	id	none	<nil><nil>
acc_rule_tags	id: INT64 acc_rule_id: INT64 tag_id: INT32 acc_type_enum: INT16	id	none	<nil><nil>
acc_product_mapping	id: INT64 gl_account_id: INT64 product_id: INT64 product_type: INT16 payment_type: INT32 charge_id: INT64 financial_account_type: INT16	id	none	<nil><nil>
acc_gl_report_2	account_id: INT64 office_id: INT64 amount: DECIMAL name: VARCHAR date: DATE type: INT16 updated_at: TIMESTAMP	account_id date type office_id	none	<nil><nil>
acc_gl_report	account_id: INT64 office_id: INT64 amount: DECIMAL name: VARCHAR date: DATE type: INT16 updated_at: TIMESTAMP	account_id date type office_id	none	<nil><nil>
acc_gl_journal_entry_accrual_correction_2025_07_05	id: INT64 account_id: INT64 office_id: INT64 reversal_id: INT64 currency_code: VARCHAR transaction_id: VARCHAR loan_transaction_id: INT64 savings_transaction_id: INT64 client_transaction_id: INT64 reversed: BIT ref_num: VARCHAR manual_entry: BIT entry_date: DATE type_enum: INT16 amount: DECIMAL description: VARCHAR entity_type_enum: INT16 entity_id: INT64 createdby_id: INT64 lastmodifiedby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME is_running_balance_calculated: BIT office_running_balance: DECIMAL organization_running_balance: DECIMAL payment_details_id: INT64 share_transaction_id: INT64 transaction_date: DATE	id	none	<nil><nil>
acc_gl_journal_entry	id: INT64 account_id: INT64 office_id: INT64 reversal_id: INT64 currency_code: VARCHAR transaction_id: VARCHAR loan_transaction_id: INT64 savings_transaction_id: INT64 client_transaction_id: INT64 reversed: BIT ref_num: VARCHAR manual_entry: BIT entry_date: DATE type_enum: INT16 amount: DECIMAL description: VARCHAR entity_type_enum: INT16 entity_id: INT64 createdby_id: INT64 lastmodifiedby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME is_running_balance_calculated: BIT office_running_balance: DECIMAL organization_running_balance: DECIMAL payment_details_id: INT64 share_transaction_id: INT64 transaction_date: DATE	id	none	<nil><nil>
acc_gl_financial_activity_account	id: INT64 gl_account_id: INT64 financial_activity_type: INT16	id	none	<nil><nil>
acc_gl_closure	id: INT64 office_id: INT64 closing_date: DATE is_deleted: BIT createdby_id: INT64 lastmodifiedby_id: INT64 created_date: DATETIME lastmodified_date: DATETIME comments: VARCHAR	id	none	<nil><nil>
acc_gl_account	id: INT64 name: VARCHAR parent_id: INT64 hierarchy: VARCHAR gl_code: VARCHAR disabled: BIT manual_journal_entries_allowed: BIT account_usage: INT8 classification_enum: INT16 tag_id: INT32 description: VARCHAR	id	none	<nil><nil>
acc_accounting_rule	id: INT64 name: VARCHAR office_id: INT64 debit_account_id: INT64 allow_multiple_debits: BIT credit_account_id: INT64 allow_multiple_credits: BIT description: VARCHAR system_defined: BIT	id	none	<nil><nil>
Loan Purposes	id: INT64 loan_id: INT64 Loan Purpose: INT32 Sub Category: INT32	id	none	<nil><nil>
Loan Overpayment Withdrawal	id: INT64 savings_account_id: INT64 Is allowed to withdraw: BIT	id	none	<nil><nil>
Joint_Borrower	id: INT64 loan_id: INT64 Borrower Type: INT32 Joint Borrower: VARCHAR Note: TEXT	id	none	<nil><nil>
Group_Guarantor	id: INT64 loan_id: INT64 Group Guarantor Name: VARCHAR	id	none	<nil><nil>
Final Check	id: INT64 loan_id: INT64 Is CEO Approved: INT32 Recommended for disburse: INT32 Note: TEXT Recommended by: TEXT Date: DATE	id	none	<nil><nil>
DATABASECHANGELOGLOCK	ID: INT32 LOCKED: BIT LOCKGRANTED: DATETIME LOCKEDBY: VARCHAR	ID	none	<nil><nil>
DATABASECHANGELOG	ID: VARCHAR AUTHOR: VARCHAR FILENAME: VARCHAR DATEEXECUTED: DATETIME ORDEREXECUTED: INT32 EXECTYPE: VARCHAR MD5SUM: VARCHAR DESCRIPTION: VARCHAR COMMENTS: VARCHAR TAG: VARCHAR LIQUIBASE: VARCHAR CONTEXTS: VARCHAR LABELS: VARCHAR DEPLOYMENT_ID: VARCHAR		none	<nil><nil>
Additional_Guarantor	id: INT64 loan_id: INT64 Guarantor Type: INT32 Guarantor Name: VARCHAR Guarantor relationship: INT32	id	none	<nil><nil>
A_Second Approval	id: INT64 loan_id: INT64 Recommend for loan approval: INT32 Note: TEXT Recommended by: TEXT Date: DATE	id	none	<nil><nil>
A_First Approval	id: INT64 loan_id: INT64 Recommend for loan approval: INT32 Note: TEXT Recommended by: TEXT Date: DATE	id	none	<nil><nil>
A_Branch Manager Approval	id: INT64 loan_id: INT64 Recommend for loan approval: INT32 Note: TEXT Recommended by: VARCHAR Date: DATE	id	none	<nil><nil>