DTW_TR_HISTORY_CODE


Description

Holds the available history codes (formerly known as entry types)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID VARCHAR 64 null
DTW_TR_ENTRY.HISTORY_CODE_ID DTW_TR_HISTORY_CODE_FK R
DTW_TR_HISTORY_CODE.REVERSAL_HISTORY_CODE_ID DTW_TR_HIST_CODE_REVERSAL_FK N
DTW_TR_HISTORY_CODE_FEAT.HISTORY_CODE_ID DTW_TR_HST_FEATURE_HST_ID_FK C

Identifies the entry type
DESCRIPTION VARCHAR 256 null

Holds the entry type description
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the entry type was created within the digital twin
UPDATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the entry type was lastly updated
KIND VARCHAR 16 null

Holds the kind of the entry type (possible values: CREDIT, DEBIT)
REVERSAL_HISTORY_CODE_ID VARCHAR 64 √ null
DTW_TR_HISTORY_CODE.ID DTW_TR_HIST_CODE_REVERSAL_FK N

Holds the reversal history code for this entry type

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_HIST_CODE_REVERSAL_IDX Performance Asc REVERSAL_HISTORY_CODE_ID

Relationships

Close relationships within degrees of separation