DTW_TR_ENTRY_BALANCE_CHANGE


Description

Holds which balances were change by an entry

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ENTRY_ID CHAR 36 null
DTW_TR_ENTRY.ID DTW_TR_BLC_CHANGE_ENTRY_FK C

Identifies the underlying entry
BALANCE_TYPE_ID VARCHAR 64 null
DTW_TR_BALANCE_TYPE.ID DTW_TR_BLC_CHANGE_TYPE_FK R

Identifies which balance was changed
CURRENCY CHAR 3 null

Identifies the currency on which the balance was changed
AMOUNT DECIMAL 19 null

Identifies the amount of which the balance was changed

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc ENTRY_ID + BALANCE_TYPE_ID
DTW_TR_BLC_CHANGE_ENTRY_IDX Performance Asc ENTRY_ID
DTW_TR_BLC_CHANGE_TYPE_FK Performance Asc BALANCE_TYPE_ID

Relationships

Close relationships within degrees of separation