m_savings_account_transaction

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
acc_gl_journal_entry.savings_transaction_id FK_acc_gl_journal_entry_m_savings_account_transaction R
m_account_transfer_transaction.from_savings_transaction_id FK_m_account_transfer_transaction_from_m_savings_transaction R
m_account_transfer_transaction.to_savings_transaction_id FK_m_account_transfer_transaction_to_m_savings_transaction R
m_savings_account_charge_paid_by.savings_account_transaction_id FK__m_savings_account_transaction R
m_savings_account_transaction_tax_details.savings_transaction_id FK_savings_account_transaction_tax_details_savings_transaction R
savings_account_id int8 19 null
m_savings_account.id fksat0000000001 R
office_id int8 19 null
m_office.id FK_m_savings_account_transaction_m_office R
payment_detail_id int8 19 √ null
m_payment_detail.id FK_m_savings_account_transaction_m_payment_detail R
transaction_type_enum int2 5 null
is_reversed bool 1 null
transaction_date date 13 null
amount numeric 19,6 null
overdraft_amount_derived numeric 19,6 √ NULL::numeric
balance_end_date_derived date 13 √ null
balance_number_of_days_derived int4 10 √ null
running_balance_derived numeric 19,6 √ NULL::numeric
cumulative_balance_derived numeric 19,6 √ NULL::numeric
created_date timestamp 29,6 √ null
created_by int8 19 null
m_appuser.id FK_savings_account_transaction_created_by R
is_manual bool 1 √ false
release_id_of_hold_amount int8 19 √ null
is_loan_disbursement bool 1 √ null
ref_no varchar 128 √ null
original_transaction_id int8 19 √ null
is_reversal bool 1 false
reason_for_block varchar 256 √ null
is_lien_transaction bool 1 false
submitted_on_date date 13 null
last_modified_by int8 19 null
m_appuser.id FK_savings_account_transaction_last_modified_by R
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null
external_id varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
m_savings_account_transaction_pkey Primary key Asc id
FK_m_savings_account_transaction_m_office Performance Asc office_id
FK_m_savings_account_transaction_m_payment_detail Performance Asc payment_detail_id
fksat0000000001 Performance Asc savings_account_id
uk_m_sat_external_id Must be unique Asc external_id

Relationships

Close relationships within degrees of separation