m_loan_transaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_gl_journal_entry.loan_transaction_id FK_acc_gl_journal_entry_m_loan_transactionR
m_account_transfer_transaction.from_loan_transaction_id FK_m_account_transfer_transaction_from_m_loan_transactionR
m_account_transfer_transaction.to_loan_transaction_id FK_m_account_transfer_transaction_to_m_loan_transactionR
m_guarantor_transaction.loan_transaction_id FK_guarantor_transaction_m_loan_transactionR
m_loan_charge_paid_by.loan_transaction_id FK__m_loan_transactionR
m_loan_collateral_management.transaction_id fkTransactionC
m_loan_transaction_repayment_schedule_mapping.loan_transaction_id FK_mappings_m_loan_transactionR
m_note.loan_transaction_id FK7C9708924D26803R
loan_id BIGINT 19 null
m_loan.id FKCFCEA42640BE0710R
office_id BIGINT 19 null
m_office.id FK_m_loan_transaction_m_officeR
payment_detail_id BIGINT 19 √ NULL
m_payment_detail.id FK_m_loan_transaction_m_payment_detailR
is_reversed BIT 1 null
external_id VARCHAR 100 √ NULL
transaction_type_enum SMALLINT 5 null
transaction_date DATE 10 null
amount DECIMAL 19,6 null
principal_portion_derived DECIMAL 19,6 √ NULL
interest_portion_derived DECIMAL 19,6 √ NULL
fee_charges_portion_derived DECIMAL 19,6 √ NULL
penalty_charges_portion_derived DECIMAL 19,6 √ NULL
overpayment_portion_derived DECIMAL 19,6 √ NULL
unrecognized_income_portion DECIMAL 19,6 √ NULL
outstanding_loan_balance_derived DECIMAL 19,6 √ NULL
submitted_on_date DATE 10 null
manually_adjusted_or_reversed BIT 1 √ b'0'
created_date DATETIME 19 √ NULL
appuser_id BIGINT 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
external_id Must be unique Asc external_id
FK_m_loan_transaction_m_office Performance Asc office_id
FK_m_loan_transaction_m_payment_detail Performance Asc payment_detail_id
FKCFCEA42640BE0710 Performance Asc loan_id

Relationships

Close relationships within degrees of separation