acc_gl_journal_entry

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_gl_journal_entry.reversal_id FK_acc_gl_journal_entry_acc_gl_journal_entryR
account_id BIGINT 19 null
acc_gl_account.id FK_acc_gl_journal_entry_acc_gl_accountR
office_id BIGINT 19 null
m_office.id FK_acc_gl_journal_entry_m_officeR
reversal_id BIGINT 19 √ NULL
acc_gl_journal_entry.id FK_acc_gl_journal_entry_acc_gl_journal_entryR
currency_code VARCHAR 3 null
transaction_id VARCHAR 50 null
loan_transaction_id BIGINT 19 √ NULL
m_loan_transaction.id FK_acc_gl_journal_entry_m_loan_transactionR
savings_transaction_id BIGINT 19 √ NULL
m_savings_account_transaction.id FK_acc_gl_journal_entry_m_savings_account_transactionR
client_transaction_id BIGINT 19 √ NULL
m_client_transaction.id FK_acc_gl_journal_entry_m_client_transactionR
reversed BIT 1 b'0'
ref_num VARCHAR 100 √ NULL
manual_entry BIT 1 b'0'
entry_date DATE 10 null
type_enum SMALLINT 5 null
amount DECIMAL 19,6 null
description VARCHAR 500 √ NULL
entity_type_enum SMALLINT 5 √ NULL
entity_id BIGINT 19 √ NULL
createdby_id BIGINT 19 null
m_appuser.id FK_acc_gl_journal_entry_m_appuserR
lastmodifiedby_id BIGINT 19 null
m_appuser.id FK_acc_gl_journal_entry_m_appuser_2R
created_date DATETIME 19 null
lastmodified_date DATETIME 19 null
is_running_balance_calculated BIT 1 b'0'
office_running_balance DECIMAL 19,6 0.000000
organization_running_balance DECIMAL 19,6 0.000000
payment_details_id BIGINT 19 √ NULL
m_payment_detail.id FK_acc_gl_journal_entry_m_payment_detailR
share_transaction_id BIGINT 19 √ NULL
m_share_account_transactions.id FK_acc_gl_journal_entry_m_share_account_transactionR
transaction_date DATE 10 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_acc_gl_journal_entry_acc_gl_account Performance Asc account_id
FK_acc_gl_journal_entry_acc_gl_journal_entry Performance Asc reversal_id
FK_acc_gl_journal_entry_m_appuser Performance Asc createdby_id
FK_acc_gl_journal_entry_m_appuser_2 Performance Asc lastmodifiedby_id
FK_acc_gl_journal_entry_m_client_transaction Performance Asc client_transaction_id
FK_acc_gl_journal_entry_m_loan_transaction Performance Asc loan_transaction_id
FK_acc_gl_journal_entry_m_office Performance Asc office_id
FK_acc_gl_journal_entry_m_payment_detail Performance Asc payment_details_id
FK_acc_gl_journal_entry_m_savings_account_transaction Performance Asc savings_transaction_id
FK_acc_gl_journal_entry_m_share_account_transaction Performance Asc share_transaction_id
transaction_date_index Performance Asc transaction_date

Relationships

Close relationships within degrees of separation