add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
INSTRUMENT_ID VALUE_TYPE_CODE ORIGINAL_TRANSACTION_VALUE VALUE_IN_HOME_CURRENCY
ABC TOT_AMT 3 5.7702
ABC AMT_AVAL 1 1.9234
ABC DRWN_AMT 2 3.8468
ABC MTD_DRWN 2 3.8468
INSTRUMENT_ID VALUE_TYPE_CODE ValueType Value
ABC TOT_AMT ORIGINAL_TRANSACTION_VALUE 3.0000
ABC TOT_AMT VALUE_IN_HOME_CURRENCY 5.7702
ABC AMT_AVAL ORIGINAL_TRANSACTION_VALUE 1.0000
ABC AMT_AVAL VALUE_IN_HOME_CURRENCY 1.9234
ABC DRWN_AMT ORIGINAL_TRANSACTION_VALUE 2.0000
ABC DRWN_AMT VALUE_IN_HOME_CURRENCY 3.8468
ABC MTD_DRWN ORIGINAL_TRANSACTION_VALUE 2.0000
ABC MTD_DRWN VALUE_IN_HOME_CURRENCY 3.8468
INSTRUMENT_ID NEW_CODE Value
ABC TOT_AMT_ORIG 3.0000
ABC TOT_AMT_VALU 5.7702
ABC AMT_AVAL_ORIG 1.0000
ABC AMT_AVAL_VALU 1.9234
ABC DRWN_AMT_ORIG 2.0000
ABC DRWN_AMT_VALU 3.8468
ABC MTD_DRWN_ORIG 2.0000
ABC MTD_DRWN_VALU 3.8468
INSTRUMENT_ID TOT_AMT TOT_AMT1 AMT_AVAL AMT_AVAL1 DRWN_AMT DRWN_AMT1 MTD_DRWN MTD_DRWN1 MTD_DRWN MTD_DRWN1
ABC 3 5.7702 1 1.9234 2 2.0000 2 3.8468 2 3.8468