DTW_TR_BALANCE_TYPE


Description

Holds a balance types

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID VARCHAR 64 null
DTW_TR_ACC_GROUP_BALANCE_TYPE.BALANCE_TYPE_ID DTW_TR_ACC_GRP_BLNC_TP_BLNC_FK C
DTW_TR_BALANCE_LAYER.LAYER DTW_TR_BALANCE_CHILD_FK C
DTW_TR_BALANCE_LAYER.PARENT DTW_TR_BALANCE_PARENT_FK C
DTW_TR_BALANCE_PATTERN_BLC_BKP.BALANCE_TYPE_ID DTW_TR_BALANCE_PATTERN_TYP_FK C
DTW_TR_BALANCE_TYPE_FEATURE.BALANCE_TYPE_ID DTW_TR_BALANCE_TYPE_FEATURE_FK C
DTW_TR_ENTRY_BALANCE_CHANGE.BALANCE_TYPE_ID DTW_TR_BLC_CHANGE_TYPE_FK R
DTW_TR_MONITORING_BALANCE_REL.BALANCE_TYPE_ID DTW_TR_MON_BALANCES_REL_BAL_FK C
DTW_TR_PATTERN_RULE_BALANCE.BALANCE_TYPE_ID DTW_TR_PTTRN_RULE_BLC_BLC_FK C
DTW_TR_PHYSICAL_BALANCE.BALANCE_TYPE DTW_TR_PHYSICAL_BLC_TYPE_FK R
DTW_TR_SNAPSHOT_BALANCE.BALANCE_TYPE_ID DTW_TR_BALANCE_SNAPSHOT_T_FK R
DTW_TRS_SCHEDULE_LIMIT.BALANCE_TYPE DTW_TR_BALANCE_TYPE_FK R

Identifies a balance type
KIND VARCHAR 32 √ null

Holds the type of balance holder (possible values: ACCOUNT, ACCOUNT_GROUP, MONITORING, and VIRTUAL)
CURRENCY CHAR 3 null

Identifies the currency associated with the balance type
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

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

When the balance type was lastly updated
DEFAULT_MINIMUM_AMOUNT DECIMAL 19 √ null

Holds the default minimum value of underlying physical balance
DEFAULT_MAXIMUM_AMOUNT DECIMAL 19 √ null

Holds the default maximum value of underlying physical balance
NORMALIZER VARCHAR 32 null

The account group type associated with the underlying physical balance. Only used when the balance type is ‘ACCOUNT_GROUP’
REFRESH VARCHAR 16 NEVER

A spring-based cron expression denoting the time on which the underlying balance will be refresh. NEVER should be used if the particular balance do not refresh
DELEGATE VARCHAR 256 √ null

Holds the FQN of this particular balance delegate. Only available for virtual balances

Indexes

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

Relationships

Close relationships within degrees of separation