m_journal_entry_aggregation_summary

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
gl_account_id int8 19 null
acc_gl_account.id fk_gl_journal_entry_aggregation_summary_on_gl_account_id R
product_id int8 19 null
office_id int8 19 null
m_office.id fk_gl_journal_entry_aggregation_summary_on_office_id R
entity_type_enum int2 5 null
aggregated_on_date date 13 null
submitted_on_date date 13 null
external_owner_id int8 19 √ null
m_external_asset_owner.id fk_gl_journal_entry_aggregation_summary_on_external_owner_id R
debit_amount numeric 19,6 √ null
credit_amount numeric 19,6 √ null
manual_entry bool 1 false
job_execution_id int8 19 null
batch_job_execution.job_execution_id fk_gl_journal_entry_aggregation_summary_on_job_execution_id R
created_by int8 19 √ null
m_appuser.id fk_gl_journal_entry_aggregation_summary_on_created_by R
created_on_utc timestamptz 35,6 √ null
last_modified_by int8 19 √ null
m_appuser.id fk_gl_journal_entry_aggregation_summary_on_last_modified_by R
last_modified_on_utc timestamptz 35,6 √ null
originator_external_ids varchar 1000 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_journal_entry_aggregation_summary Primary key Asc id
idx_journal_entry_aggregation_summary Performance Asc/Asc submitted_on_date + gl_account_id
idx_m_jour_ent_aggr_sum_aggr_date Performance Asc aggregated_on_date
idx_m_jour_ent_aggr_sum_job_exec_id Performance Asc job_execution_id
idx_m_jour_ent_aggr_sum_office_id Performance Asc office_id
idx_m_jour_ent_aggr_sum_prod_id_entity_type Performance Asc/Asc product_id + entity_type_enum

Relationships

Close relationships within degrees of separation