acc_gl_journal_entry

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
acc_gl_journal_entry.reversal_id FK_acc_gl_journal_entry_acc_gl_journal_entry R
m_external_asset_owner_journal_entry_mapping.journal_entry_id FK_ext_asset_owner_je_mapping_journal_entry_id R
m_external_asset_owner_transfer_journal_entry_mapping.journal_entry_id FK_ext_asset_owner_transfer_je_mapping_journal_entry_id R
account_id int8 19 null
acc_gl_account.id FK_acc_gl_journal_entry_acc_gl_account R
office_id int8 19 null
m_office.id FK_acc_gl_journal_entry_m_office R
reversal_id int8 19 √ null
acc_gl_journal_entry.id FK_acc_gl_journal_entry_acc_gl_journal_entry R
currency_code varchar 3 null
transaction_id varchar 50 null
loan_transaction_id int8 19 √ null
m_loan_transaction.id FK_acc_gl_journal_entry_m_loan_transaction R
savings_transaction_id int8 19 √ null
m_savings_account_transaction.id FK_acc_gl_journal_entry_m_savings_account_transaction R
client_transaction_id int8 19 √ null
m_client_transaction.id FK_acc_gl_journal_entry_m_client_transaction R
reversed bool 1 false
ref_num varchar 100 √ null
manual_entry bool 1 false
entry_date date 13 null
type_enum int2 5 null
amount numeric 19,6 null
description varchar 500 √ null
entity_type_enum int2 5 √ null
entity_id int8 19 √ null
created_by int8 19 null
m_appuser.id FK_journal_entry_created_by R
last_modified_by int8 19 null
m_appuser.id FK_journal_entry_last_modified_by R
created_date timestamp 29,6 √ null
lastmodified_date timestamp 29,6 √ null
is_running_balance_calculated bool 1 false
office_running_balance numeric 19,6 0
organization_running_balance numeric 19,6 0
payment_details_id int8 19 √ null
m_payment_detail.id FK_acc_gl_journal_entry_m_payment_detail R
share_transaction_id int8 19 √ null
m_share_account_transactions.id FK_acc_gl_journal_entry_m_share_account_transaction R
transaction_date date 13 √ null

Unfinished. Not maintained.
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null
submitted_on_date date 13 null

Indexes

Constraint Name Type Sort Column(s)
acc_gl_journal_entry_pkey 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 created_by
FK_acc_gl_journal_entry_m_appuser_2 Performance Asc last_modified_by
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
FK_acc_gl_journal_entry_submitted_on_date Performance Asc submitted_on_date
idx_acc_gl_journal_entry_transaction_id Performance Asc transaction_id
transaction_date_index Performance Asc transaction_date

Relationships

Close relationships within degrees of separation