| LOAN_OFFERING_INTEREST_CALC_RULE |
loan_offering.INTEREST_CALC_RULE_ID |
interest_calc_rule.INTEREST_CALC_RULE_ID |
| LOAN_OFFERING_PENALTY |
loan_offering.PENALTY_ID |
penalty.PENALTY_ID |
| LOAN_OFFERING_PENALTY_GLCODE |
loan_offering.PENALTIES_GLCODE_ID |
gl_code.GLCODE_ID |
| PRD_OFFERING_MIX_PRD_OFFERING_ID_1 |
prd_offering_mix.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| PRD_OFFERING_MIX_PRD_OFFERING_ID_2 |
prd_offering_mix.PRD_OFFERING_NOT_ALLOWED_ID |
prd_offering.PRD_OFFERING_ID |
| accepted_payment_type_ibfk_1 |
accepted_payment_type.TRANSACTION_ID |
transaction_type.TRANSACTION_ID |
| accepted_payment_type_ibfk_2 |
accepted_payment_type.PAYMENT_TYPE_ID |
payment_type.PAYMENT_TYPE_ID |
| account_action_ibfk_1 |
account_action.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| account_activity_ibfk_1 |
account_activity.ACCOUNT_ID |
account.ACCOUNT_ID |
| account_activity_ibfk_2 |
account_activity.PRINCIPAL_CURRENCY_ID |
currency.CURRENCY_ID |
| account_activity_ibfk_3 |
account_activity.PRINCIPAL_OUTSTANDING_CURRENCY_ID |
currency.CURRENCY_ID |
| account_activity_ibfk_4 |
account_activity.INTEREST_CURRENCY_ID |
currency.CURRENCY_ID |
| account_activity_ibfk_5 |
account_activity.INTEREST_OUTSTANDING_CURRENCY_ID |
currency.CURRENCY_ID |
| account_activity_ibfk_6 |
account_activity.FEE_CURRENCY_ID |
currency.CURRENCY_ID |
| account_activity_ibfk_7 |
account_activity.FEE_OUTSTANDING_CURRENCY_ID |
currency.CURRENCY_ID |
| account_activity_ibfk_8 |
account_activity.PENALTY_CURRENCY_ID |
currency.CURRENCY_ID |
| account_activity_ibfk_9 |
account_activity.PENALTY_OUTSTANDING_CURRENCY_ID |
currency.CURRENCY_ID |
| account_custom_field_ibfk_1 |
account_custom_field.FIELD_ID |
custom_field_definition.FIELD_ID |
| account_custom_field_ibfk_2 |
account_custom_field.ACCOUNT_ID |
account.ACCOUNT_ID |
| account_fees_ibfk_1 |
account_fees.ACCOUNT_ID |
account.ACCOUNT_ID |
| account_fees_ibfk_2 |
account_fees.FEE_ID |
fees.FEE_ID |
| account_fees_ibfk_3 |
account_fees.ACCOUNT_FEE_AMNT_CURRENCY_ID |
currency.CURRENCY_ID |
| account_fees_ibfk_4 |
account_fees.FEE_FREQUENCY |
recurrence_detail.DETAILS_ID |
| account_flag_detail_ibfk_1 |
account_flag_detail.ACCOUNT_ID |
account.ACCOUNT_ID |
| account_flag_detail_ibfk_2 |
account_flag_detail.FLAG_ID |
account_state_flag.FLAG_ID |
| account_flag_detail_ibfk_3 |
account_flag_detail.CREATED_BY |
personnel.PERSONNEL_ID |
| account_ibfk_1 |
account.ACCOUNT_STATE_ID |
account_state.ACCOUNT_STATE_ID |
| account_ibfk_2 |
account.ACCOUNT_TYPE_ID |
account_type.ACCOUNT_TYPE_ID |
| account_ibfk_3 |
account.CUSTOMER_ID |
customer.CUSTOMER_ID |
| account_ibfk_4 |
account.PERSONNEL_ID |
personnel.PERSONNEL_ID |
| account_ibfk_5 |
account.OFFICE_ID |
office.OFFICE_ID |
| account_notes_ibfk_1 |
account_notes.ACCOUNT_ID |
account.ACCOUNT_ID |
| account_notes_ibfk_2 |
account_notes.OFFICER_ID |
personnel.PERSONNEL_ID |
| account_payment_ibfk_1 |
account_payment.ACCOUNT_ID |
account.ACCOUNT_ID |
| account_payment_ibfk_2 |
account_payment.CURRENCY_ID |
currency.CURRENCY_ID |
| account_payment_ibfk_3 |
account_payment.PAYMENT_TYPE_ID |
payment_type.PAYMENT_TYPE_ID |
| account_state_flag_ibfk_1 |
account_state_flag.STATUS_ID |
account_state.ACCOUNT_STATE_ID |
| account_state_flag_ibfk_2 |
account_state_flag.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| account_state_ibfk_1 |
account_state.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| account_status_change_history_ibfk_1 |
account_status_change_history.ACCOUNT_ID |
account.ACCOUNT_ID |
| account_status_change_history_ibfk_2 |
account_status_change_history.OLD_STATUS |
account_state.ACCOUNT_STATE_ID |
| account_status_change_history_ibfk_3 |
account_status_change_history.NEW_STATUS |
account_state.ACCOUNT_STATE_ID |
| account_status_change_history_ibfk_4 |
account_status_change_history.CHANGED_BY |
personnel.PERSONNEL_ID |
| account_trxn_ibfk_1 |
account_trxn.ACCOUNT_ID |
account.ACCOUNT_ID |
| account_trxn_ibfk_2 |
account_trxn.ACCOUNT_ACTION_ID |
account_action.ACCOUNT_ACTION_ID |
| account_trxn_ibfk_3 |
account_trxn.PAYMENT_ID |
account_payment.PAYMENT_ID |
| account_trxn_ibfk_4 |
account_trxn.CURRENCY_ID |
currency.CURRENCY_ID |
| account_trxn_ibfk_5 |
account_trxn.AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| account_trxn_ibfk_6 |
account_trxn.CUSTOMER_ID |
customer.CUSTOMER_ID |
| account_type_ibfk_1 |
account_type.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| activity_ibfk_1 |
activity.PARENT_ID |
activity.ACTIVITY_ID |
| activity_ibfk_2 |
activity.ACTIVITY_NAME_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| activity_ibfk_3 |
activity.DESCRIPTION_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| attendance_ibfk_1 |
attendance.MEETING_ID |
customer_meeting.CUSTOMER_MEETING_ID |
| branch_ho_update_ibfk_1 |
branch_ho_update.OFFICE_ID |
office.OFFICE_ID |
| category_type_ibfk_1 |
category_type.CATEGORY_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| change_log_detail_ibfk_1 |
change_log_detail.CHANGE_LOG_ID |
change_log.CHANGE_LOG_ID |
| change_log_ibfk_1 |
change_log.CHANGED_BY |
personnel.PERSONNEL_ID |
| checklist_detail_ibfk_1 |
checklist_detail.CHECKLIST_ID |
checklist.CHECKLIST_ID |
| checklist_detail_ibfk_2 |
checklist_detail.LOCALE_ID |
supported_locale.LOCALE_ID |
| checklist_ibfk_1 |
checklist.LOCALE_ID |
supported_locale.LOCALE_ID |
| checklist_ibfk_2 |
checklist.CREATED_BY |
personnel.PERSONNEL_ID |
| checklist_ibfk_3 |
checklist.UPDATED_BY |
personnel.PERSONNEL_ID |
| client_initial_savings_offering_ibfk_1 |
client_initial_savings_offering.CUSTOMER_ID |
customer.CUSTOMER_ID |
| client_initial_savings_offering_ibfk_2 |
client_initial_savings_offering.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| client_perf_history_ibfk_1 |
client_perf_history.CUSTOMER_ID |
customer.CUSTOMER_ID |
| coa_ibfk_1 |
coa.GLCODE_ID |
gl_code.GLCODE_ID |
| coa_idmapper_ibfk_1 |
coa_idmapper.COA_ID |
coa.COA_ID |
| coahierarchy_ibfk_1 |
coahierarchy.COA_ID |
coa.COA_ID |
| coahierarchy_ibfk_2 |
coahierarchy.PARENT_COAID |
coa.COA_ID |
| coll_sheet_customer_ibfk_1 |
coll_sheet_customer.TOTAL_DUE_SAVINGS_LOAN_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_customer_ibfk_2 |
coll_sheet_customer.CUST_ACCNT_FEE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_customer_ibfk_3 |
coll_sheet_customer.CUST__ACCNT_PENALTY_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_customer_ibfk_4 |
coll_sheet_customer.COLLECTIVE_LN_AMNT_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_customer_ibfk_5 |
coll_sheet_customer.COLLECTIVE_LN_DISBURSAL_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_customer_ibfk_6 |
coll_sheet_customer.COLLECTIVE_SAVINGS_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_customer_ibfk_7 |
coll_sheet_customer.COLLECTIVE_ACCNT_CHARGES_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_customer_ibfk_8 |
coll_sheet_customer.COLLECTIVE_TOTAL_CHARGES_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_customer_ibfk_9 |
coll_sheet_customer.COLLECTIVE_NET_CASH_IN_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_1 |
coll_sheet_loan_details.ORIG_LOAN_AMNT_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_10 |
coll_sheet_loan_details.FEES_OVERDUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_11 |
coll_sheet_loan_details.PENALTY_OVERDUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_12 |
coll_sheet_loan_details.TOTAL_AMNT_OVERDUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_13 |
coll_sheet_loan_details.TOTAL_AMNT_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_14 |
coll_sheet_loan_details.AMNT_TOBE_DISBURSED_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_15 |
coll_sheet_loan_details.TOTAL_PRIN_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_2 |
coll_sheet_loan_details.AMNT_TO_CLOSE_LOAN_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_3 |
coll_sheet_loan_details.PRINCIPAL_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_4 |
coll_sheet_loan_details.INTEREST_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_5 |
coll_sheet_loan_details.FEES_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_6 |
coll_sheet_loan_details.PENALTY_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_7 |
coll_sheet_loan_details.TOTAL_SCHEDULED_AMNT_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_8 |
coll_sheet_loan_details.PRINCIPAL_OVERDUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_loan_details_ibfk_9 |
coll_sheet_loan_details.INTEREST_OVERDUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_savings_details_ibfk_1 |
coll_sheet_savings_details.ACCNT_BALANCE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_savings_details_ibfk_2 |
coll_sheet_savings_details.RECOMMENDED_AMNT_DUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_savings_details_ibfk_3 |
coll_sheet_savings_details.AMNT_OVERDUE_CURRENCY |
currency.CURRENCY_ID |
| coll_sheet_savings_details_ibfk_4 |
coll_sheet_savings_details.TOTAL_SAVINGS_AMNT_DUE_CURRENCY |
currency.CURRENCY_ID |
| collateral_type_ibfk_1 |
collateral_type.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| cust_perf_history_ibfk_1 |
cust_perf_history.CUSTOMER_ID |
customer.CUSTOMER_ID |
| custom_field_definition_ibfk_1 |
custom_field_definition.LEVEL_ID |
customer_level.LEVEL_ID |
| custom_field_definition_ibfk_2 |
custom_field_definition.ENTITY_ID |
lookup_entity.ENTITY_ID |
| custom_field_definition_ibfk_3 |
custom_field_definition.ENTITY_TYPE |
entity_master.ENTITY_TYPE_ID |
| customer_account_activity_ibfk_1 |
customer_account_activity.ACCOUNT_ID |
account.ACCOUNT_ID |
| customer_account_activity_ibfk_2 |
customer_account_activity.FEE_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| customer_account_activity_ibfk_3 |
customer_account_activity.CREATED_BY |
personnel.PERSONNEL_ID |
| customer_account_ibfk_1 |
customer_account.ACCOUNT_ID |
account.ACCOUNT_ID |
| customer_address_detail_ibfk_1 |
customer_address_detail.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_address_detail_ibfk_2 |
customer_address_detail.LOCALE_ID |
supported_locale.LOCALE_ID |
| customer_attendance_ibfk_1 |
customer_attendance.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_attendance_types_ibfk_1 |
customer_attendance_types.ATTENDANCE_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| customer_checklist_ibfk_1 |
customer_checklist.CHECKLIST_ID |
checklist.CHECKLIST_ID |
| customer_checklist_ibfk_2 |
customer_checklist.LEVEL_ID |
customer_level.LEVEL_ID |
| customer_checklist_ibfk_3 |
customer_checklist.CUSTOMER_STATUS_ID |
customer_state.STATUS_ID |
| customer_custom_field_ibfk_1 |
customer_custom_field.FIELD_ID |
custom_field_definition.FIELD_ID |
| customer_custom_field_ibfk_2 |
customer_custom_field.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_detail_ibfk_1 |
customer_detail.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_detail_ibfk_2 |
customer_detail.CITIZENSHIP |
lookup_value.LOOKUP_ID |
| customer_detail_ibfk_3 |
customer_detail.EDUCATION_LEVEL |
lookup_value.LOOKUP_ID |
| customer_detail_ibfk_4 |
customer_detail.ETHINICITY |
lookup_value.LOOKUP_ID |
| customer_detail_ibfk_5 |
customer_detail.HANDICAPPED |
lookup_value.LOOKUP_ID |
| customer_detail_ibfk_6 |
customer_detail.MARITAL_STATUS |
lookup_value.LOOKUP_ID |
| customer_detail_ibfk_7 |
customer_detail.POVERTY_STATUS |
lookup_value.LOOKUP_ID |
| customer_fee_schedule_ibfk_1 |
customer_fee_schedule.ID |
customer_schedule.ID |
| customer_fee_schedule_ibfk_2 |
customer_fee_schedule.AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| customer_fee_schedule_ibfk_3 |
customer_fee_schedule.AMOUNT_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| customer_fee_schedule_ibfk_4 |
customer_fee_schedule.FEE_ID |
fees.FEE_ID |
| customer_fee_schedule_ibfk_5 |
customer_fee_schedule.ACCOUNT_FEE_ID |
account_fees.ACCOUNT_FEE_ID |
| customer_flag_detail_ibfk_1 |
customer_flag_detail.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_flag_detail_ibfk_2 |
customer_flag_detail.FLAG_ID |
customer_state_flag.FLAG_ID |
| customer_flag_detail_ibfk_3 |
customer_flag_detail.CREATED_BY |
personnel.PERSONNEL_ID |
| customer_hierarchy_ibfk_1 |
customer_hierarchy.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_hierarchy_ibfk_2 |
customer_hierarchy.PARENT_ID |
customer.CUSTOMER_ID |
| customer_hierarchy_ibfk_3 |
customer_hierarchy.UPDATED_BY |
personnel.PERSONNEL_ID |
| customer_historical_data_ibfk_1 |
customer_historical_data.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_ibfk_1 |
customer.CUSTOMER_LEVEL_ID |
customer_level.LEVEL_ID |
| customer_ibfk_2 |
customer.STATUS_ID |
customer_state.STATUS_ID |
| customer_ibfk_3 |
customer.BRANCH_ID |
office.OFFICE_ID |
| customer_ibfk_4 |
customer.LOAN_OFFICER_ID |
personnel.PERSONNEL_ID |
| customer_ibfk_5 |
customer.CUSTOMER_FORMEDBY_ID |
personnel.PERSONNEL_ID |
| customer_level_ibfk_1 |
customer_level.PARENT_LEVEL_ID |
customer_level.LEVEL_ID |
| customer_level_ibfk_2 |
customer_level.LEVEL_NAME_ID |
lookup_entity.ENTITY_ID |
| customer_loan_account_detail_ibfk_1 |
customer_loan_account_detail.ACCOUNT_TRXN_ID |
account_trxn.ACCOUNT_TRXN_ID |
| customer_loan_account_detail_ibfk_2 |
customer_loan_account_detail.CURRENCY_ID |
currency.CURRENCY_ID |
| customer_loan_account_detail_ibfk_3 |
customer_loan_account_detail.PRINCIPAL_CURRENCY_ID |
currency.CURRENCY_ID |
| customer_loan_account_detail_ibfk_4 |
customer_loan_account_detail.INTEREST_CURRENCY_ID |
currency.CURRENCY_ID |
| customer_loan_account_detail_ibfk_5 |
customer_loan_account_detail.PENALTY_CURRENCY_ID |
currency.CURRENCY_ID |
| customer_loan_account_detail_ibfk_6 |
customer_loan_account_detail.ACCOUNT_ID |
loan_account.ACCOUNT_ID |
| customer_meeting_detail_ibfk_1 |
customer_meeting_detail.MEETING_ID |
customer_meeting.CUSTOMER_MEETING_ID |
| customer_meeting_detail_ibfk_2 |
customer_meeting_detail.DETAILS_ID |
recurrence_detail.DETAILS_ID |
| customer_meeting_ibfk_1 |
customer_meeting.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_meeting_ibfk_2 |
customer_meeting.MEETING_ID |
meeting.MEETING_ID |
| customer_meeting_ibfk_3 |
customer_meeting.UPDATED_MEETING_ID |
meeting.MEETING_ID |
| customer_movement_ibfk_1 |
customer_movement.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_movement_ibfk_2 |
customer_movement.OFFICE_ID |
office.OFFICE_ID |
| customer_movement_ibfk_3 |
customer_movement.PERSONNEL_ID |
personnel.PERSONNEL_ID |
| customer_movement_ibfk_4 |
customer_movement.UPDATED_BY |
personnel.PERSONNEL_ID |
| customer_name_detail_ibfk_1 |
customer_name_detail.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_name_detail_ibfk_2 |
customer_name_detail.SALUTATION |
lookup_value.LOOKUP_ID |
| customer_name_detail_ibfk_3 |
customer_name_detail.LOCALE_ID |
supported_locale.LOCALE_ID |
| customer_note_ibfk_1 |
customer_note.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_note_ibfk_2 |
customer_note.FIELD_OFFICER_ID |
personnel.PERSONNEL_ID |
| customer_picture_ibfk_1 |
customer_picture.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_position_ibfk_1 |
customer_position.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_program_ibfk_1 |
customer_program.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_program_ibfk_2 |
customer_program.PROGRAM_ID |
program.PROGRAM_ID |
| customer_schedule_ibfk_1 |
customer_schedule.ACCOUNT_ID |
account.ACCOUNT_ID |
| customer_schedule_ibfk_2 |
customer_schedule.CURRENCY_ID |
currency.CURRENCY_ID |
| customer_schedule_ibfk_3 |
customer_schedule.CUSTOMER_ID |
customer.CUSTOMER_ID |
| customer_state_flag_ibfk_1 |
customer_state_flag.STATUS_ID |
customer_state.STATUS_ID |
| customer_state_flag_ibfk_2 |
customer_state_flag.FLAG_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| customer_state_ibfk_1 |
customer_state.LEVEL_ID |
customer_level.LEVEL_ID |
| customer_state_ibfk_2 |
customer_state.STATUS_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| customer_trxn_detail_ibfk_1 |
customer_trxn_detail.TOTAL_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| customer_trxn_detail_ibfk_2 |
customer_trxn_detail.MISC_PENALTY_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| customer_trxn_detail_ibfk_3 |
customer_trxn_detail.MISC_FEE_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| customer_trxn_detail_ibfk_4 |
customer_trxn_detail.ACCOUNT_TRXN_ID |
account_trxn.ACCOUNT_TRXN_ID |
| fee_formula_master_ibfk_1 |
fee_formula_master.FORUMLA_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| fee_frequency_ibfk_1 |
fee_frequency.FEE_ID |
fees.FEE_ID |
| fee_frequency_ibfk_2 |
fee_frequency.FEE_FREQUENCYTYPE_ID |
fee_frequency_type.FEE_FREQUENCY_ID |
| fee_frequency_ibfk_3 |
fee_frequency.FREQUENCY_PAYMENT_ID |
fee_payment.FEE_PAYMENT_ID |
| fee_frequency_ibfk_4 |
fee_frequency.FREQUENCY_MEETING_ID |
meeting.MEETING_ID |
| fee_frequency_type_ibfk_1 |
fee_frequency_type.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| fee_payment_ibfk_1 |
fee_payment.FEE_PAYMENT_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| fee_payments_categories_type_ibfk_1 |
fee_payments_categories_type.CATEGORY_ID |
category_type.CATEGORY_ID |
| fee_payments_categories_type_ibfk_2 |
fee_payments_categories_type.FEE_PAYMENT_ID |
fee_payment.FEE_PAYMENT_ID |
| fee_payments_categories_type_ibfk_3 |
fee_payments_categories_type.FEE_TYPE_ID |
fee_type.FEE_TYPE_ID |
| fee_status_ibfk_1 |
fee_status.STATUS_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| fee_trxn_detail_ibfk_1 |
fee_trxn_detail.ACCOUNT_FEE_ID |
account_fees.ACCOUNT_FEE_ID |
| fee_trxn_detail_ibfk_2 |
fee_trxn_detail.FEE_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| fee_trxn_detail_ibfk_3 |
fee_trxn_detail.ACCOUNT_TRXN_ID |
account_trxn.ACCOUNT_TRXN_ID |
| fee_type_ibfk_1 |
fee_type.FEE_LOOKUP_ID |
lookup_entity.ENTITY_ID |
| fee_update_type_ibfk_1 |
fee_update_type.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| feelevel_ibfk_1 |
feelevel.FEE_ID |
fees.FEE_ID |
| fees_ibfk_1 |
fees.GLCODE_ID |
gl_code.GLCODE_ID |
| fees_ibfk_2 |
fees.CATEGORY_ID |
category_type.CATEGORY_ID |
| fees_ibfk_3 |
fees.STATUS |
fee_status.STATUS_ID |
| fees_ibfk_4 |
fees.OFFICE_ID |
office.OFFICE_ID |
| fees_ibfk_5 |
fees.CREATED_BY |
personnel.PERSONNEL_ID |
| fees_ibfk_6 |
fees.UPDATED_BY |
personnel.PERSONNEL_ID |
| fees_ibfk_7 |
fees.FORMULA_ID |
fee_formula_master.FORMULAID |
| fees_ibfk_8 |
fees.RATE_OR_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| fees_ibfk_9 |
fees.FEE_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| field_configuration_ibfk_1 |
field_configuration.ENTITY_ID |
entity_master.ENTITY_TYPE_ID |
| field_configuration_ibfk_2 |
field_configuration.PARENT_FIELD_CONFIG_ID |
field_configuration.FIELD_CONFIG_ID |
| financial_action_ibfk_1 |
financial_action.LOOKUP_ID |
lookup_value_locale.LOOKUP_ID |
| financial_trxn_ibfk_1 |
financial_trxn.ACCOUNT_TRXN_ID |
account_trxn.ACCOUNT_TRXN_ID |
| financial_trxn_ibfk_2 |
financial_trxn.CURRENCY_ID |
currency.CURRENCY_ID |
| financial_trxn_ibfk_3 |
financial_trxn.POSTED_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| financial_trxn_ibfk_4 |
financial_trxn.BALANCE_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| financial_trxn_ibfk_5 |
financial_trxn.CURRENCY_ID |
currency.CURRENCY_ID |
| financial_trxn_ibfk_6 |
financial_trxn.RELATED_FIN_TRXN |
financial_trxn.TRXN_ID |
| financial_trxn_ibfk_7 |
financial_trxn.FIN_ACTION_ID |
financial_action.FIN_ACTION_ID |
| financial_trxn_ibfk_8 |
financial_trxn.POSTED_BY |
personnel.PERSONNEL_ID |
| financial_trxn_ibfk_9 |
financial_trxn.GLCODE_ID |
gl_code.GLCODE_ID |
| fk_loan_account |
loan_account.PARENT_ACCOUNT_ID |
loan_account.ACCOUNT_ID |
| fk_loan_monthweek |
loan_account.MONTH_WEEK |
week_days_master.WEEK_DAYS_MASTER_ID |
| fk_loan_rankday |
loan_account.MONTH_RANK |
rank_days_master.RANK_DAYS_MASTER_ID |
| freq_of_deposits_ibfk_1 |
freq_of_deposits.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| fund_ibfk_1 |
fund.FUNDCODE_ID |
fund_code.FUNDCODE_ID |
| grace_period_type_ibfk_1 |
grace_period_type.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| group_perf_history_ibfk_1 |
group_perf_history.CUSTOMER_ID |
customer.CUSTOMER_ID |
| holiday_ibfk_1 |
holiday.OFFICE_ID |
office.OFFICE_ID |
| holiday_ibfk_2 |
holiday.REPAYMENT_RULE_ID |
repayment_rule.REPAYMENT_RULE_ID |
| inherited_meeting_ibfk_1 |
inherited_meeting.CUSTOMER_ID |
customer.CUSTOMER_ID |
| inherited_meeting_ibfk_2 |
inherited_meeting.MEETING_ID |
customer_meeting.CUSTOMER_MEETING_ID |
| insurance_offering_ibfk_1 |
insurance_offering.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| interest_calc_rule_ibfk_1 |
interest_calc_rule.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| interest_calculation_types_ibfk_1 |
interest_calculation_types.INTEREST_CALCULATION_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| interest_types_ibfk_1 |
interest_types.CATEGORY_ID |
prd_type.PRD_TYPE_ID |
| interest_types_ibfk_2 |
interest_types.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| language_ibfk_1 |
language.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| loan_account_ibfk_1 |
loan_account.ACCOUNT_ID |
account.ACCOUNT_ID |
| loan_account_ibfk_10 |
loan_account.BUSINESS_ACTIVITIES_ID |
lookup_value.LOOKUP_ID |
| loan_account_ibfk_11 |
loan_account.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| loan_account_ibfk_12 |
loan_account.PARENT_ACCOUNT_ID |
account.ACCOUNT_ID |
| loan_account_ibfk_2 |
loan_account.CURRENCY_ID |
currency.CURRENCY_ID |
| loan_account_ibfk_3 |
loan_account.LOAN_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_account_ibfk_4 |
loan_account.LOAN_BALANCE_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_account_ibfk_5 |
loan_account.FUND_ID |
fund.FUND_ID |
| loan_account_ibfk_6 |
loan_account.GRACE_PERIOD_TYPE_ID |
grace_period_type.GRACE_PERIOD_TYPE_ID |
| loan_account_ibfk_7 |
loan_account.INTEREST_TYPE_ID |
interest_types.INTEREST_TYPE_ID |
| loan_account_ibfk_8 |
loan_account.MEETING_ID |
meeting.MEETING_ID |
| loan_account_ibfk_9 |
loan_account.COLLATERAL_TYPE_ID |
collateral_type.COLLATERAL_TYPE_ID |
| loan_activity_details_ibfk_1 |
loan_activity_details.CREATED_BY |
personnel.PERSONNEL_ID |
| loan_activity_details_ibfk_10 |
loan_activity_details.BALANCE_FEE_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_activity_details_ibfk_2 |
loan_activity_details.ACCOUNT_ID |
account.ACCOUNT_ID |
| loan_activity_details_ibfk_3 |
loan_activity_details.PRINCIPAL_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_activity_details_ibfk_4 |
loan_activity_details.INTEREST_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_activity_details_ibfk_5 |
loan_activity_details.FEE_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_activity_details_ibfk_6 |
loan_activity_details.PENALTY_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_activity_details_ibfk_7 |
loan_activity_details.BALANCE_PRINCIPAL_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_activity_details_ibfk_8 |
loan_activity_details.BALANCE_INTEREST_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_activity_details_ibfk_9 |
loan_activity_details.BALANCE_PENALTY_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_amount_from_last_loan_ibfk_1 |
loan_amount_from_last_loan.PRD_OFFERING_ID |
loan_offering.PRD_OFFERING_ID |
| loan_amount_from_loan_cycle_ibfk_1 |
loan_amount_from_loan_cycle.PRD_OFFERING_ID |
loan_offering.PRD_OFFERING_ID |
| loan_amount_same_for_all_loan_ibfk_1 |
loan_amount_same_for_all_loan.PRD_OFFERING_ID |
loan_offering.PRD_OFFERING_ID |
| loan_arrears_aging_ibfk_1 |
loan_arrears_aging.ACCOUNT_ID |
account.ACCOUNT_ID |
| loan_arrears_aging_ibfk_10 |
loan_arrears_aging.UNPAID_BALANCE_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_arrears_aging_ibfk_2 |
loan_arrears_aging.CUSTOMER_ID |
customer.CUSTOMER_ID |
| loan_arrears_aging_ibfk_3 |
loan_arrears_aging.PARENT_CUSTOMER_ID |
customer.CUSTOMER_ID |
| loan_arrears_aging_ibfk_4 |
loan_arrears_aging.OFFICE_ID |
office.OFFICE_ID |
| loan_arrears_aging_ibfk_5 |
loan_arrears_aging.OVERDUE_PRINCIPAL_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_arrears_aging_ibfk_6 |
loan_arrears_aging.OVERDUE_INTEREST_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_arrears_aging_ibfk_7 |
loan_arrears_aging.OVERDUE_BALANCE_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_arrears_aging_ibfk_8 |
loan_arrears_aging.UNPAID_PRINCIPAL_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_arrears_aging_ibfk_9 |
loan_arrears_aging.UNPAID_INTEREST_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_fee_schedule_ibfk_1 |
loan_fee_schedule.ID |
loan_schedule.ID |
| loan_fee_schedule_ibfk_2 |
loan_fee_schedule.AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_fee_schedule_ibfk_3 |
loan_fee_schedule.AMOUNT_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_fee_schedule_ibfk_4 |
loan_fee_schedule.FEE_ID |
fees.FEE_ID |
| loan_fee_schedule_ibfk_5 |
loan_fee_schedule.ACCOUNT_FEE_ID |
account_fees.ACCOUNT_FEE_ID |
| loan_offering_fund_ibfk_1 |
loan_offering_fund.PRD_OFFERING_ID |
loan_offering.PRD_OFFERING_ID |
| loan_offering_fund_ibfk_2 |
loan_offering_fund.FUND_ID |
fund.FUND_ID |
| loan_offering_ibfk_1 |
loan_offering.PRINCIPAL_GLCODE_ID |
gl_code.GLCODE_ID |
| loan_offering_ibfk_2 |
loan_offering.INTEREST_GLCODE_ID |
gl_code.GLCODE_ID |
| loan_offering_ibfk_3 |
loan_offering.GRACEPERIOD_TYPE_ID |
grace_period_type.GRACE_PERIOD_TYPE_ID |
| loan_offering_ibfk_4 |
loan_offering.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| loan_offering_ibfk_5 |
loan_offering.INTEREST_TYPE_ID |
interest_types.INTEREST_TYPE_ID |
| loan_offering_ibfk_6 |
loan_offering.MIN_LOAN_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_offering_ibfk_7 |
loan_offering.MAX_LOAN_AMNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_offering_ibfk_8 |
loan_offering.DEFAULT_LOAN_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_penalty_ibfk_1 |
loan_penalty.ACCOUNT_ID |
loan_account.ACCOUNT_ID |
| loan_penalty_ibfk_2 |
loan_penalty.PENALTY_ID |
penalty.PENALTY_ID |
| loan_perf_history_ibfk_1 |
loan_perf_history.ACCOUNT_ID |
account.ACCOUNT_ID |
| loan_schedule_ibfk_1 |
loan_schedule.ACCOUNT_ID |
account.ACCOUNT_ID |
| loan_schedule_ibfk_10 |
loan_schedule.INTEREST_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_11 |
loan_schedule.PENALTY_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_12 |
loan_schedule.MISC_PENALTY_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_13 |
loan_schedule.CUSTOMER_ID |
customer.CUSTOMER_ID |
| loan_schedule_ibfk_2 |
loan_schedule.CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_3 |
loan_schedule.PRINCIPAL_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_4 |
loan_schedule.INTEREST_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_5 |
loan_schedule.PENALTY_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_6 |
loan_schedule.MISC_FEES_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_7 |
loan_schedule.MISC_FEES_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_8 |
loan_schedule.MISC_PENALTY_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_schedule_ibfk_9 |
loan_schedule.PRINCIPAL_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_summary_ibfk_1 |
loan_summary.ORIG_PRINCIPAL_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_summary_ibfk_2 |
loan_summary.ORIG_INTEREST_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_summary_ibfk_3 |
loan_summary.ORIG_FEES_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_summary_ibfk_4 |
loan_summary.ORIG_PENALTY_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_summary_ibfk_5 |
loan_summary.PRINCIPAL_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_summary_ibfk_6 |
loan_summary.INTEREST_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_summary_ibfk_7 |
loan_summary.FEES_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_summary_ibfk_8 |
loan_summary.PENALTY_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_summary_ibfk_9 |
loan_summary.ACCOUNT_ID |
loan_account.ACCOUNT_ID |
| loan_trxn_detail_ibfk_1 |
loan_trxn_detail.PRINCIPAL_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_trxn_detail_ibfk_2 |
loan_trxn_detail.INTEREST_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_trxn_detail_ibfk_3 |
loan_trxn_detail.PENALTY_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_trxn_detail_ibfk_4 |
loan_trxn_detail.MISC_PENALTY_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_trxn_detail_ibfk_5 |
loan_trxn_detail.MISC_FEE_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| loan_trxn_detail_ibfk_6 |
loan_trxn_detail.ACCOUNT_TRXN_ID |
account_trxn.ACCOUNT_TRXN_ID |
| lookup_label_ibfk_1 |
lookup_label.ENTITY_ID |
lookup_entity.ENTITY_ID |
| lookup_label_ibfk_2 |
lookup_label.LOCALE_ID |
supported_locale.LOCALE_ID |
| lookup_value_ibfk_1 |
lookup_value.ENTITY_ID |
lookup_entity.ENTITY_ID |
| lookup_value_locale_ibfk_1 |
lookup_value_locale.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| lookup_value_locale_ibfk_2 |
lookup_value_locale.LOCALE_ID |
supported_locale.LOCALE_ID |
| max_min_loan_amount_ibfk_1 |
max_min_loan_amount.ACCOUNT_ID |
loan_account.ACCOUNT_ID |
| max_min_no_of_install_ibfk_1 |
max_min_no_of_install.ACCOUNT_ID |
loan_account.ACCOUNT_ID |
| meeting_ibfk_1 |
meeting.MEETING_TYPE_ID |
meeting_type.MEETING_TYPE_ID |
| mfi_attribute_ibfk_1 |
mfi_attribute.OFFICE_ID |
office.OFFICE_ID |
| no_of_install_from_last_loan_ibfk_1 |
no_of_install_from_last_loan.PRD_OFFERING_ID |
loan_offering.PRD_OFFERING_ID |
| no_of_install_from_loan_cycle_ibfk_1 |
no_of_install_from_loan_cycle.PRD_OFFERING_ID |
loan_offering.PRD_OFFERING_ID |
| no_of_install_same_for_all_loan_ibfk_1 |
no_of_install_same_for_all_loan.PRD_OFFERING_ID |
loan_offering.PRD_OFFERING_ID |
| offering_fund_ibfk_1 |
offering_fund.FUND_ID |
fund.FUND_ID |
| offering_fund_ibfk_2 |
offering_fund.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| office_action_payment_type_ibfk_1 |
office_action_payment_type.ACCOUNT_ACTION_ID |
account_action.ACCOUNT_ACTION_ID |
| office_action_payment_type_ibfk_2 |
office_action_payment_type.OFFICE_ID |
office.OFFICE_ID |
| office_action_payment_type_ibfk_3 |
office_action_payment_type.PAYMENT_TYPE_ID |
payment_type.PAYMENT_TYPE_ID |
| office_action_payment_type_ibfk_4 |
office_action_payment_type.PRD_TYPE_ID |
prd_type.PRD_TYPE_ID |
| office_address_ibfk_1 |
office_address.OFFICE_ID |
office.OFFICE_ID |
| office_code_ibfk_1 |
office_code.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| office_custom_field_ibfk_1 |
office_custom_field.OFFICE_ID |
office.OFFICE_ID |
| office_hierarchy_ibfk_1 |
office_hierarchy.OFFICE_ID |
office.OFFICE_ID |
| office_hierarchy_ibfk_2 |
office_hierarchy.PARENT_ID |
office.OFFICE_ID |
| office_hierarchy_ibfk_3 |
office_hierarchy.UPDATED_BY |
personnel.PERSONNEL_ID |
| office_ibfk_1 |
office.OFFICE_LEVEL_ID |
office_level.LEVEL_ID |
| office_ibfk_2 |
office.PARENT_OFFICE_ID |
office.OFFICE_ID |
| office_ibfk_3 |
office.STATUS_ID |
office_status.STATUS_ID |
| office_ibfk_4 |
office.OFFICE_CODE_ID |
office_code.CODE_ID |
| office_level_ibfk_1 |
office_level.PARENT_LEVEL_ID |
office_level.LEVEL_ID |
| office_status_ibfk_1 |
office_status.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| payment_type_ibfk_1 |
payment_type.PAYMENT_TYPE_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| penalty_ibfk_1 |
penalty.CATEGORY_ID |
category_type.CATEGORY_ID |
| penalty_ibfk_2 |
penalty.GLCODE_ID |
gl_code.GLCODE_ID |
| penalty_ibfk_3 |
penalty.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| penalty_ibfk_4 |
penalty.OFFICE_ID |
office.OFFICE_ID |
| personnel_custom_field_ibfk_1 |
personnel_custom_field.PERSONNEL_ID |
personnel.PERSONNEL_ID |
| personnel_custom_field_ibfk_2 |
personnel_custom_field.FIELD_ID |
custom_field_definition.FIELD_ID |
| personnel_details_ibfk_1 |
personnel_details.PERSONNEL_ID |
personnel.PERSONNEL_ID |
| personnel_details_ibfk_2 |
personnel_details.GENDER |
lookup_value.LOOKUP_ID |
| personnel_details_ibfk_3 |
personnel_details.MARITAL_STATUS |
lookup_value.LOOKUP_ID |
| personnel_hierarchy_ibfk_1 |
personnel_hierarchy.PARENT_ID |
personnel.PERSONNEL_ID |
| personnel_hierarchy_ibfk_2 |
personnel_hierarchy.PERSONNEL_ID |
personnel.PERSONNEL_ID |
| personnel_hierarchy_ibfk_3 |
personnel_hierarchy.UPDATED_BY |
personnel.PERSONNEL_ID |
| personnel_ibfk_1 |
personnel.OFFICE_ID |
office.OFFICE_ID |
| personnel_ibfk_2 |
personnel.CREATED_BY |
personnel.PERSONNEL_ID |
| personnel_ibfk_3 |
personnel.LEVEL_ID |
personnel_level.LEVEL_ID |
| personnel_ibfk_4 |
personnel.PREFERRED_LOCALE |
supported_locale.LOCALE_ID |
| personnel_ibfk_5 |
personnel.TITLE |
lookup_value.LOOKUP_ID |
| personnel_ibfk_6 |
personnel.UPDATED_BY |
personnel.PERSONNEL_ID |
| personnel_level_ibfk_1 |
personnel_level.PARENT_LEVEL_ID |
personnel_level.LEVEL_ID |
| personnel_level_ibfk_2 |
personnel_level.LEVEL_NAME_ID |
lookup_value.LOOKUP_ID |
| personnel_movement_ibfk_1 |
personnel_movement.PERSONNEL_ID |
personnel.PERSONNEL_ID |
| personnel_movement_ibfk_2 |
personnel_movement.UPDATED_BY |
personnel.PERSONNEL_ID |
| personnel_movement_ibfk_3 |
personnel_movement.OFFICE_ID |
office.OFFICE_ID |
| personnel_notes_ibfk_1 |
personnel_notes.PERSONNEL_ID |
personnel.PERSONNEL_ID |
| personnel_notes_ibfk_2 |
personnel_notes.OFFICER_ID |
personnel.PERSONNEL_ID |
| personnel_role_ibfk_1 |
personnel_role.PERSONNEL_ID |
personnel.PERSONNEL_ID |
| personnel_role_ibfk_2 |
personnel_role.ROLE_ID |
role.ROLE_ID |
| personnel_status_ibfk_1 |
personnel_status.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| position_ibfk_1 |
position.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| ppi_survey_ibfk_1 |
ppi_survey.SURVEY_ID |
survey.SURVEY_ID |
| prd_applicable_master_ibfk_1 |
prd_applicable_master.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| prd_category_ibfk_1 |
prd_category.PRD_TYPE_ID |
prd_type.PRD_TYPE_ID |
| prd_category_status_ibfk_1 |
prd_category_status.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| prd_checklist_ibfk_1 |
prd_checklist.ACCOUNT_STATUS |
account_state.ACCOUNT_STATE_ID |
| prd_checklist_ibfk_2 |
prd_checklist.CHECKLIST_ID |
checklist.CHECKLIST_ID |
| prd_checklist_ibfk_3 |
prd_checklist.PRD_TYPE_ID |
prd_type.PRD_TYPE_ID |
| prd_fee_frequency_ibfk_1 |
prd_fee_frequency.FEE_ID |
fees.FEE_ID |
| prd_fee_frequency_ibfk_2 |
prd_fee_frequency.PRDOFFERING_FEE_ID |
prd_offering_fees.PRD_OFFERING_FEE_ID |
| prd_fee_frequency_ibfk_3 |
prd_fee_frequency.FREQUENCY_ID |
recurrence_type.RECURRENCE_ID |
| prd_offering_fees_ibfk_1 |
prd_offering_fees.FEE_ID |
fees.FEE_ID |
| prd_offering_fees_ibfk_2 |
prd_offering_fees.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| prd_offering_ibfk_1 |
prd_offering.GLCODE_ID |
gl_code.GLCODE_ID |
| prd_offering_ibfk_2 |
prd_offering.OFFICE_ID |
office.OFFICE_ID |
| prd_offering_ibfk_3 |
prd_offering.PRD_CATEGORY_ID |
prd_category.PRD_CATEGORY_ID |
| prd_offering_ibfk_4 |
prd_offering.OFFERING_STATUS_ID |
prd_status.OFFERING_STATUS_ID |
| prd_offering_ibfk_5 |
prd_offering.PRD_TYPE_ID |
prd_type.PRD_TYPE_ID |
| prd_offering_ibfk_6 |
prd_offering.PRD_APPLICABLE_MASTER_ID |
prd_applicable_master.PRD_APPLICABLE_MASTER_ID |
| prd_offering_meeting_ibfk_1 |
prd_offering_meeting.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| prd_offering_meeting_ibfk_2 |
prd_offering_meeting.PRD_MEETING_ID |
meeting.MEETING_ID |
| prd_offering_meeting_ibfk_3 |
prd_offering_meeting.PRD_OFFERING_MEETING_TYPE_ID |
meeting_type.MEETING_TYPE_ID |
| prd_state_ibfk_1 |
prd_state.PRD_STATE_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| prd_status_ibfk_1 |
prd_status.PRD_TYPE_ID |
prd_type.PRD_TYPE_ID |
| prd_status_ibfk_2 |
prd_status.PRD_STATE_ID |
prd_state.PRD_STATE_ID |
| prd_type_ibfk_1 |
prd_type.PRD_TYPE_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| product_offering_mandatory_savings_ibfk_1 |
product_offering_mandatory_savings.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| program_fund_ibfk_1 |
program_fund.FUND_ID |
fund.FUND_ID |
| program_fund_ibfk_2 |
program_fund.PROGRAM_ID |
program.PROGRAM_ID |
| program_ibfk_1 |
program.GLCODE_ID |
gl_code.GLCODE_ID |
| program_ibfk_2 |
program.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| program_ibfk_3 |
program.OFFICE_ID |
office.OFFICE_ID |
| question_choices_ibfk_1 |
question_choices.QUESTION_ID |
questions.QUESTION_ID |
| rank_days_master_ibfk_1 |
rank_days_master.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| recommended_amnt_unit_ibfk_1 |
recommended_amnt_unit.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| recur_on_day_ibfk_1 |
recur_on_day.DETAILS_ID |
recurrence_detail.DETAILS_ID |
| recur_on_day_ibfk_2 |
recur_on_day.DAYS |
week_days_master.WEEK_DAYS_MASTER_ID |
| recur_on_day_ibfk_3 |
recur_on_day.RANK_OF_DAYS |
rank_days_master.RANK_DAYS_MASTER_ID |
| recurrence_detail_ibfk_1 |
recurrence_detail.RECURRENCE_ID |
recurrence_type.RECURRENCE_ID |
| recurrence_detail_ibfk_2 |
recurrence_detail.MEETING_ID |
meeting.MEETING_ID |
| repayment_rule_ibfk_1 |
repayment_rule.REPAYMENT_RULE_LOOKUP_ID |
lookup_value.LOOKUP_ID |
| report_ibfk_1 |
report.REPORT_CATEGORY_ID |
report_category.REPORT_CATEGORY_ID |
| report_jasper_map_ibfk_1 |
report_jasper_map.REPORT_CATEGORY_ID |
report_category.REPORT_CATEGORY_ID |
| role_ibfk_1 |
role.CREATED_BY |
personnel.PERSONNEL_ID |
| role_ibfk_2 |
role.UPDATED_BY |
personnel.PERSONNEL_ID |
| roles_activity_ibfk_1 |
roles_activity.ACTIVITY_ID |
activity.ACTIVITY_ID |
| roles_activity_ibfk_2 |
roles_activity.ROLE_ID |
role.ROLE_ID |
| saving_schedule_ibfk_1 |
saving_schedule.ACCOUNT_ID |
account.ACCOUNT_ID |
| saving_schedule_ibfk_2 |
saving_schedule.CURRENCY_ID |
currency.CURRENCY_ID |
| saving_schedule_ibfk_3 |
saving_schedule.DEPOSIT_CURRENCY_ID |
currency.CURRENCY_ID |
| saving_schedule_ibfk_4 |
saving_schedule.DEPOSIT_PAID_CURRENCY_ID |
currency.CURRENCY_ID |
| saving_schedule_ibfk_5 |
saving_schedule.CUSTOMER_ID |
customer.CUSTOMER_ID |
| savings_account_ibfk_1 |
savings_account.ACCOUNT_ID |
account.ACCOUNT_ID |
| savings_account_ibfk_10 |
savings_account.MIN_AMNT_FOR_INT_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_account_ibfk_2 |
savings_account.SAVINGS_BALANCE_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_account_ibfk_3 |
savings_account.RECOMMENDED_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_account_ibfk_4 |
savings_account.INT_TO_BE_POSTED_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_account_ibfk_5 |
savings_account.RECOMMENDED_AMNT_UNIT_ID |
recommended_amnt_unit.RECOMMENDED_AMNT_UNIT_ID |
| savings_account_ibfk_6 |
savings_account.SAVINGS_TYPE_ID |
savings_type.SAVINGS_TYPE_ID |
| savings_account_ibfk_7 |
savings_account.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| savings_account_ibfk_8 |
savings_account.INTEREST_CALCULATION_TYPE_ID |
interest_calculation_types.INTEREST_CALCULATION_TYPE_ID |
| savings_account_ibfk_9 |
savings_account.TIME_PER_FOR_INT_CALC |
meeting.MEETING_ID |
| savings_activity_details_ibfk_1 |
savings_activity_details.CREATED_BY |
personnel.PERSONNEL_ID |
| savings_activity_details_ibfk_2 |
savings_activity_details.ACCOUNT_ID |
account.ACCOUNT_ID |
| savings_activity_details_ibfk_3 |
savings_activity_details.ACCOUNT_ACTION_ID |
account_action.ACCOUNT_ACTION_ID |
| savings_activity_details_ibfk_4 |
savings_activity_details.AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_activity_details_ibfk_5 |
savings_activity_details.BALANCE_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_offering_ibfk_1 |
savings_offering.PRD_OFFERING_ID |
prd_offering.PRD_OFFERING_ID |
| savings_offering_ibfk_2 |
savings_offering.RECOMMENDED_AMNT_UNIT_ID |
recommended_amnt_unit.RECOMMENDED_AMNT_UNIT_ID |
| savings_offering_ibfk_3 |
savings_offering.SAVINGS_TYPE_ID |
savings_type.SAVINGS_TYPE_ID |
| savings_offering_ibfk_4 |
savings_offering.INTEREST_CALCULATION_TYPE_ID |
interest_calculation_types.INTEREST_CALCULATION_TYPE_ID |
| savings_offering_ibfk_5 |
savings_offering.RECOMMENDED_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_offering_ibfk_6 |
savings_offering.MAX_AMNT_WITHDRAWL_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_offering_ibfk_7 |
savings_offering.MIN_AMNT_FOR_INT_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_offering_ibfk_8 |
savings_offering.DEPOSIT_GLCODE_ID |
gl_code.GLCODE_ID |
| savings_offering_ibfk_9 |
savings_offering.INTEREST_GLCODE_ID |
gl_code.GLCODE_ID |
| savings_performance_ibfk_1 |
savings_performance.ACCOUNT_ID |
account.ACCOUNT_ID |
| savings_performance_ibfk_2 |
savings_performance.TOTAL_DEPOSITS_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_performance_ibfk_3 |
savings_performance.TOTAL_WITHDRAWALS_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_performance_ibfk_4 |
savings_performance.TOTAL_INTEREST_EARNED_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_trxn_detail_ibfk_1 |
savings_trxn_detail.ACCOUNT_TRXN_ID |
account_trxn.ACCOUNT_TRXN_ID |
| savings_trxn_detail_ibfk_2 |
savings_trxn_detail.DEPOSIT_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_trxn_detail_ibfk_3 |
savings_trxn_detail.WITHDRAWAL_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_trxn_detail_ibfk_4 |
savings_trxn_detail.INTEREST_AMOUNT_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_trxn_detail_ibfk_5 |
savings_trxn_detail.BALANCE_CURRENCY_ID |
currency.CURRENCY_ID |
| savings_type_ibfk_1 |
savings_type.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| spouse_father_lookup_ibfk_1 |
spouse_father_lookup.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| supported_locale_ibfk_1 |
supported_locale.COUNTRY_ID |
country.COUNTRY_ID |
| supported_locale_ibfk_2 |
supported_locale.LANG_ID |
language.LANG_ID |
| survey_instance_ibfk_1 |
survey_instance.SURVEY_ID |
survey.SURVEY_ID |
| survey_instance_ibfk_2 |
survey_instance.CUSTOMER_ID |
customer.CUSTOMER_ID |
| survey_instance_ibfk_3 |
survey_instance.OFFICER_ID |
personnel.PERSONNEL_ID |
| survey_instance_ibfk_4 |
survey_instance.ACCOUNT_ID |
account.ACCOUNT_ID |
| survey_instance_ibfk_5 |
survey_instance.CREATING_OFFICER_ID |
personnel.PERSONNEL_ID |
| survey_questions_ibfk_1 |
survey_questions.QUESTION_ID |
questions.QUESTION_ID |
| survey_questions_ibfk_2 |
survey_questions.SURVEY_ID |
survey.SURVEY_ID |
| survey_response_ibfk_1 |
survey_response.SURVEY_QUESTION_ID |
survey_questions.SURVEYQUESTION_ID |
| survey_response_ibfk_2 |
survey_response.INSTANCE_ID |
survey_instance.INSTANCE_ID |
| survey_response_ibfk_3 |
survey_response.CHOICE_VALUE |
question_choices.CHOICE_ID |
| system_configuration_ibfk_1 |
system_configuration.OFFICE_ID |
office.OFFICE_ID |
| waive_off_history_ibfk_1 |
waive_off_history.ACCOUNT_ID |
loan_account.ACCOUNT_ID |
| week_days_master_ibfk_1 |
week_days_master.LOOKUP_ID |
lookup_value.LOOKUP_ID |
| yes_no_master_ibfk_1 |
yes_no_master.LOOKUP_ID |
lookup_value.LOOKUP_ID |