m_loan_capitalized_income_balance

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
version int8 19 null
loan_id int8 19 null
m_loan.id FK_loan_capitalized_income_balance_loan_id R
loan_transaction_id int8 19 null
m_loan_transaction.id FK_loan_capitalized_income_balance_transaction_id R
amount numeric 19,6 null
date date 13 null
unrecognized_amount numeric 19,6 null
charged_off_amount numeric 19,6 √ null
amount_adjustment numeric 19,6 √ null
created_by int8 19 √ null
m_appuser.id FK_loan_capitalized_income_balance_created_by R
created_on_utc timestamptz 35,6 √ null
last_modified_by int8 19 √ null
m_appuser.id FK_loan_capitalized_income_balance_last_modified_by R
last_modified_on_utc timestamptz 35,6 √ null
is_deleted bool 1 false
is_closed bool 1 false

Indexes

Constraint Name Type Sort Column(s)
pk_m_loan_capitalized_income_balance Primary key Asc id
m_loan_capitalized_income_balance_idx_1 Must be unique Asc/Asc loan_id + loan_transaction_id
m_loan_capitalized_income_balance_idx_2 Performance Asc loan_id

Relationships

Close relationships within degrees of separation