m_journal_entry_aggregation_tracking

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
aggregated_on_date_from date 13 null
aggregated_on_date_to date 13 null
submitted_on_date date 13 null
job_execution_id int8 19 null
batch_job_execution.job_execution_id fk_gl_journal_entry_aggregation_tracking_on_job_execution_id R
created_by int8 19 √ null
m_appuser.id fk_gl_journal_entry_aggregation_tracking_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_tracking_on_last_modified_by R
last_modified_on_utc timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_journal_entry_aggregation_tracking Primary key Asc id
idx2_m_journal_entry_aggregation_tracking Must be unique Asc aggregated_on_date_to
idx_m_jour_ent_aggr_trac_job_exec_id Performance Asc job_execution_id
idx_m_journal_entry_aggregation_tracking Performance Asc submitted_on_date

Relationships

Close relationships within degrees of separation