DTW_TR_ENTRY


Description

Holds an entry bound to an account

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_TR_BLOCKING_RELATED_ENTRY.ENTRY_ID DTW_TR_BLOCKING_REL_ENT_ENT_FK C
DTW_TR_BLOCKING_RELATED_ENTRY.TARGET_ID DTW_TR_BLOCKING_REL_ENT_TRG_FK R
DTW_TR_COMPENSATING_ENTRY.ENTRY_ID DTW_TR_COMPENSATING_ENTRY_E_FK C
DTW_TR_ENTRY_BALANCE_CHANGE.ENTRY_ID DTW_TR_BLC_CHANGE_ENTRY_FK C
DTW_TR_ENTRY_FULFILLMENT.FULFILLED_ENTRY_ID DTW_TR_ENTRY_FLMNT_FLM_FK C
DTW_TR_ENTRY_FULFILLMENT.PENDING_ENTRY_ID DTW_TR_ENTRY_FLMNT_PRM_FK R
DTW_TR_INTENT_ENTRY_REL.ENTRY_ID DTW_TR_INTENT_ENTRY_REL_ENT_FK C
DTW_TR_MONITORING_PROCESS_REL_ENTRIES.ENTRY_ID DTW_TR_ENTRY_ID_REL_FK R
DTW_TR_MONITORING_RELEASE_ENTRIES.ENTRY_ID DTW_TR_ENTRY_ID_FK R

Identifies the entry
ENTRY_BATCH_ID CHAR 36 null
DTW_TR_ENTRY_BATCH.ID DTW_TR_ENTRY_ENTRY_BATCH_FK C

Holds the underlying entry batch
TYPE VARCHAR 32 null

Holds the underlying entry type (possible values LEDGER, EXCLUSION)
DESCRIPTION VARCHAR 40 √ null

Holds an optional description of the underlying entry
UPDATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the entry was lastly updated
HISTORY_CODE_ID VARCHAR 64 null
DTW_TR_HISTORY_CODE.ID DTW_TR_HISTORY_CODE_FK R

The history code of the underlying entry
AS_OF DATE 10 null

The accounting date of the given entry
CURRENCY CHAR 3 null

The currency on which the amount of the underlying entry is expressed
AMOUNT DECIMAL 19 null

The value of the underlying entry
VERSION TINYINT 3 √ 0

Holds the version of the given intent

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_ENTRY_ENTRY_BATCH_IDX Performance Asc ENTRY_BATCH_ID
DTW_TR_ENTRY_HISTORY_CODE_IDX Performance Asc HISTORY_CODE_ID
DTW_TR_ENTRY_TYPE_IDX Performance Asc TYPE

Relationships

Close relationships within degrees of separation