btn-mdw-ace-server-local/mwconfig/cicd/migrate.sql

CONNECT TO MWCONFIG; 

CALL MWCONFIG.MERGE_CHARGES('edc-amp-link-inquiry-LMP', 3400,'fee nasabah', NULL, NULL, 0,'fee switcher', NULL, NULL, 0,'fee acquirer', NULL, NULL, 0,'fee promosi', NULL, NULL, 0,'fee issuer', NULL, NULL);
-- --  CALL MWCONFIG.MERGE_DTREE('GROUP', 'PATH', 'VALUE', 'MODULE');

-- -- inq balance
CALL MWCONFIG.MERGE_DTREE('CHARGES', 'itm|402000', 'itm|40|${msg.reservedPrivate2."!value".substring(9,12)}', '[iprit]');
CALL MWCONFIG.MERGE_DTREE('CHARGES', 'itm|401000', 'itm|40|${msg.reservedPrivate2."!value".substring(9,12)}', '[iprit]');
CALL MWCONFIG.MERGE_DTREE('CHARGES', 'itm|40|BCA', 'itm prima inquiry balance', '[iprit]');
CALL MWCONFIG.MERGE_DTREE('CHARGES', 'itm prima inquiry balance', '----', '[iprit][syariah][iprii]');

-- -- tarik tunai, transfer ke bank btn, transfer ke bank lain (acq), transfer ke bank lain (iss-acq)
CALL MWCONFIG.MERGE_DTREE('CHARGES', 'itm|432000', 'itm prima transfer', '[itm][izzp]');
CALL MWCONFIG.MERGE_DTREE('CHARGES', 'itm|431000', 'itm prima transfer', '[itm][izzp][iwswc][ipri]');
CALL MWCONFIG.MERGE_DTREE('CHARGES', 'itm prima transfer', '----', '[itm][syariah][pay][iprii]');
-- -- CALL MWCONFIG.MERGE_CHARGES('ID', 'C1_NAME', 'C1_VALUE', 'C1_SCRIPT', 'C1_ACCOUNT', 'C2_NAME', 'C2_VALUE', 'C2_SCRIPT', 'C2_ACCOUNT', 'C3_NAME', 'C3_VALUE', 'C3_SCRIPT', 'C3_ACCOUNT', 'C4_NAME', 'C4_VALUE', 'C4_SCRIPT', 'C4_ACCOUNT', 'C5_NAME', 'C5_VALUE', 'C5_SCRIPT', 'C5_ACCOUNT');

-- -- inq balance
CALL MWCONFIG.MERGE_CHARGES('itm prima inquiry balance', 3250.00,'acquirer', '', '', 750.00, 'switcher','', '', 0.00, '','', '', 375.00, 'acquirer btn','', '', 0.00, '','', '');

-- -- tarik tunai, transfer ke bank btn, transfer ke bank lain (acq), transfer ke bank lain (iss-acq)
CALL MWCONFIG.MERGE_CHARGES('itm prima transfer', 3850.00,'acquirer', '', '', 1150.00, 'switcher','', '', 1500.00, 'destination', '', '', 600.00, 'acquirer btn','', '', 0.00, '','', '');


TERMINATE;