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 |