m_savings_account_transaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_gl_journal_entry.savings_transaction_id FK_acc_gl_journal_entry_m_savings_account_transactionR
m_account_transfer_transaction.from_savings_transaction_id FK_m_account_transfer_transaction_from_m_savings_transactionR
m_account_transfer_transaction.to_savings_transaction_id FK_m_account_transfer_transaction_to_m_savings_transactionR
m_savings_account_charge_paid_by.savings_account_transaction_id FK__m_savings_account_transactionR
m_savings_account_transaction_tax_details.savings_transaction_id FK_savings_account_transaction_tax_details_savings_transactionR
savings_account_id BIGINT 19 null
m_savings_account.id FKSAT0000000001R
office_id BIGINT 19 null
m_office.id FK_m_savings_account_transaction_m_officeR
payment_detail_id BIGINT 19 √ NULL
m_payment_detail.id FK_m_savings_account_transaction_m_payment_detailR
transaction_type_enum SMALLINT 5 null
is_reversed BIT 1 null
transaction_date DATE 10 null
amount DECIMAL 19,6 null
overdraft_amount_derived DECIMAL 19,6 √ NULL
balance_end_date_derived DATE 10 √ NULL
balance_number_of_days_derived INT 10 √ NULL
running_balance_derived DECIMAL 19,6 √ NULL
cumulative_balance_derived DECIMAL 19,6 √ NULL
created_date DATETIME 19 null
appuser_id BIGINT 19 √ NULL
is_manual BIT 1 √ b'0'
release_id_of_hold_amount BIGINT 19 √ NULL
is_loan_disbursement BIT 1 √ NULL
ref_no VARCHAR 128 √ NULL
original_transaction_id BIGINT 19 √ NULL
is_reversal BIT 1 b'0'
reason_for_block VARCHAR 256 √ NULL
is_lien_transaction BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY 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
ref_no Must be unique Asc ref_no

Relationships

Close relationships within degrees of separation