m_loan_transaction

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
acc_gl_journal_entry.loan_transaction_id FK_acc_gl_journal_entry_m_loan_transaction R
m_account_transfer_transaction.from_loan_transaction_id FK_m_account_transfer_transaction_from_m_loan_transaction R
m_account_transfer_transaction.to_loan_transaction_id FK_m_account_transfer_transaction_to_m_loan_transaction R
m_guarantor_transaction.loan_transaction_id FK_guarantor_transaction_m_loan_transaction R
m_loan_amortization_allocation_mapping.amortization_loan_transaction_id FK_laam_amortization_transaction_id R
m_loan_amortization_allocation_mapping.base_loan_transaction_id FK_laam_base_transaction_id R
m_loan_buy_down_fee_balance.loan_transaction_id FK_loan_buy_down_fees_balance_transaction_id R
m_loan_capitalized_income_balance.loan_transaction_id FK_loan_capitalized_income_balance_transaction_id R
m_loan_charge_paid_by.loan_transaction_id FK__m_loan_transaction R
m_loan_collateral_management.transaction_id fkTransaction C
m_loan_transaction_relation.from_loan_transaction_id FK_m_loan_transaction_from_relation R
m_loan_transaction_relation.to_loan_transaction_id FK_m_loan_transaction_to_relation R
m_loan_transaction_repayment_schedule_mapping.loan_transaction_id FK_mappings_m_loan_transaction R
m_note.loan_transaction_id fk7c9708924d26803 R
loan_id int8 19 null
m_loan.id fkcfcea42640be0710 R
office_id int8 19 null
m_office.id FK_m_loan_transaction_m_office R
payment_detail_id int8 19 √ null
m_payment_detail.id FK_m_loan_transaction_m_payment_detail R
is_reversed bool 1 null
external_id varchar 100 √ null
transaction_type_enum int2 5 null
transaction_date date 13 null
amount numeric 19,6 null
principal_portion_derived numeric 19,6 √ NULL::numeric
interest_portion_derived numeric 19,6 √ NULL::numeric
fee_charges_portion_derived numeric 19,6 √ NULL::numeric
penalty_charges_portion_derived numeric 19,6 √ NULL::numeric
overpayment_portion_derived numeric 19,6 √ NULL::numeric
unrecognized_income_portion numeric 19,6 √ NULL::numeric
outstanding_loan_balance_derived numeric 19,6 √ NULL::numeric
submitted_on_date date 13 null
manually_adjusted_or_reversed bool 1 √ false
created_date timestamp 29,6 √ null
created_by int8 19 null
m_appuser.id FK_loan_transaction_created_by R
last_modified_by int8 19 null
m_appuser.id FK_loan_transaction_last_modified_by R
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null
charge_refund_charge_type varchar 1 √ null
reversal_external_id varchar 100 √ NULL::character varying
reversed_on_date date 13 √ null
version int8 19 1
classification_cv_id int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
m_loan_transaction_pkey Primary key Asc 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
m_loan_transaction_external_id_key Must be unique Asc external_id
unique_reversal_external_id_loan_transaction Must be unique Asc reversal_external_id

Relationships

Close relationships within degrees of separation