btnmw-server-local/mwconfig/migration/MWCONFIG_INITDB_POC.sql

-- ERROR_MAP --

INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G03', '89', '', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G404', '89', '', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G503', '89', '', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G504', '68', '', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G99', '99', '', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', '000', '00', 'Success', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', '996', '96', 'Kesalahan permintaan umum gagal, termasuk penguraian pesan gagal.', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', '997', '97', 'Format yang tidak valid', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', '999', '99', 'Format tidak ada atau tidak valid pada Field yang mandatory', CURRENT USER, CURRENT TIMESTAMP);
-- PARAM MAP--

INSERT INTO MWCONFIG.PARAM_MAP (GROUP, NAME, VALUE, DESCRIPTION, SEQ, MODIFIED_BY, TIMESTAMP) VALUES ('itm-api-core', 'InquirySaldo', 'http://172.16.3.198:6600/ib/cms/inquirydd?id=MIDDLE&key=K7tfZuRT1MLmNsftNWK9FUlGZHL4oPIa', NULL, NULL, CURRENT USER, CURRENT TIMESTAMP);
-- DTREE --

-- DEV_TELLER_MAP
INSERT INTO MWCONFIG.DEV_TELLER_MAP
("GROUP", DEVICE_ID, DEVICE_NAME, TERMINAL_ID, TELLER_ID, CTRL_UNIT_ID, MODIFIED_BY, "TIMESTAMP", TERMINAL_IP)
VALUES('itm', '10001401', 'DBL MOCK UP 5', '10001401', '9901401', 'C14', CURRENT USER, CURRENT TIMESTAMP, '172.16.109.20');

INSERT INTO MWCONFIG.DTREE
("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('ITM-CODE', '0200.204000', '0200.204000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.DTREE
("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('ITM-CODE', '0210.204000', '0210.204000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.DTREE
("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('ITM-CODE', '0200.205000', '0200.205000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.DTREE
("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('ITM-CODE', '0210.205000', '0210.205000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.DTREE
("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('ITM-CODE', '0200.206000', '0200.206000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.DTREE
("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('ITM-CODE', '0210.206000', '0210.206000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);

-- MAPPING --

INSERT INTO MWCONFIG.MAPPING
(ID, DESCRIPTION, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('req-core.itm.0200.204000.001001', 'POC inquiry saldo ISO-ABCS', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING
(ID, DESCRIPTION, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('res-core.itm.0200.204000.001001', 'POC inquiry saldo ISO-ABCS', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING
(ID, DESCRIPTION, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('req-core.itm.0200.205000.001001', 'POC inquiry saldo ISO-REST', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING
(ID, DESCRIPTION, MODULE, MODIFIED_BY, "TIMESTAMP")
VALUES('res-core.itm.0200.205000.001001', 'POC inquiry saldo ISO-REST', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm.0200.206000.001001', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('res-core.itm.0200.206000.001001', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);

--MAPPING_GROUP--

INSERT INTO MWCONFIG.MAPPING_GROUP
(MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
VALUES('req-core.itm.0200.204000.001001', 1, '/data/body', '/data/body', 'req-core.itm', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP
(MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
VALUES('res-core.itm.0200.204000.001001', 1, '/data/body', '/data/body', 'res-core.itm.0200', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('req-core.itm.0200.205000.001001', 1, '/data/body', '/data/body', 'dsp', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('res-core.itm.0200.205000.001001', 1, '/data/body', '/data/body', 'res-core.itm', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('res-core.itm.0200.205000.001001', 2, '/data/body', '/data/body/resCore', null, null);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('req-core.itm.0200.206000.001001', 1, '/data/body', '/data/body', 'dsp', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('res-core.itm.0200.206000.001001', 1, '/data/body', '/data/body', 'res-core.itm.0200', 1);


--MAPPING_GROUP_LINE--

INSERT INTO MWCONFIG.MAPPING_GROUP_LINE
(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
VALUES('req-core.itm.0200.204000.001001', 1, 'TLBF01', '${msg.fromAccount}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE
(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
VALUES('res-core.itm.0200.204000.001001', 1, 'additionalDataPrivate', '${msg.SNAME_F1}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE
(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
VALUES('res-core.itm.0200.204000.001001', 1, '!oldGroup', '${head.request.data.body.original?.frontOriginal?.code==null?"":head.request.data.body.original?.frontOriginal?.code."!value"==null?"":head.request.data.body.original?.frontOriginal?.code}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE
(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
VALUES('res-core.itm.0200.204000.001001', 1, 'additionalResponseData', '${decimalFormat("0", (msg.AMT2_F1."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.AMT2_F1."!number"*100)).padLeft(12, "0")}${decimalFormat("0", (msg.AMT1_F1."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.AMT1_F1."!number"*100)).padLeft(12, "0")}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, '!ReplyToQ', 'ITM_CORE_REPLY', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, '!destination', 'InquirySaldo', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, '!dir', 'O', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, '!errorCodePath', 'body.response.data.Item.errCode', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, '!mappingCode', '${head.code}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, '!queueName', 'BACKEND_REST_IN', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, '!RequestURL', '${getParamValue("itm-api-core","InquirySaldo","http://localhost:8094")}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, '@', 'copyMessageToChild("original")', 10);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, 'account', '${msg.fromAccount}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, 'ref', '${msg.retrievalReferenceNumber."!value".padRight(12," ")}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.205000.001001', 1, 'wsid', 'BTNPOC', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm.0200.205000.001001', 1, 'messageType', '0210', 10);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm.0200.205000.001001', 1, 'responseCode', '${getParamValue("error_map|InquirySaldo", msg.rsp."!value","99")}', 20);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm.0200.205000.001001', 1, 'additionalDataPrivate', '${msg.nama}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm.0200.205000.001001', 1, 'additionalResponseData', '${decimalFormat("0", (msg.available."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.available."!number"*100)).padLeft(12, "0")}${decimalFormat("0", (msg.saldo."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.saldo."!number"*100)).padLeft(12, "0")}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm.0200.205000.001001', 2, '@', 'copyMessage();', NULL);

INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, '!ReplyToQ', 'ITM_CORE_REPLY', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, '!destination', 'InquirySaldo', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, '!dir', 'O', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, '!mappingCode', '${head.code}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, '!queueName', 'BACKEND_RPG_IN', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, '@', 'copyMessageToChild("original")', 10);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, 'iwsid', 'BTNPOC', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, 'iwsref', '${msg.retrievalReferenceNumber."!value".padRight(12," ")}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, 'iacc', '${msg.fromAccount."!value".padRight(19," ").substring(0,19)}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('req-core.itm.0200.206000.001001', 1, '!rpgid', 'INQUIRY', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm.0200.206000.001001', 1, 'additionalResponseData', '${msg.ocbal."!value".padRight(15," ").substring(0,15)}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm.0200.206000.001001', 1, 'additionalDataPrivate', '${msg.orsp."!value".padRight(3," ").substring(0,3)}${msg.orspdc."!value".padRight(50," ").substring(0,50)}${msg.oacc."!value".padRight(19," ").substring(0,19)}${msg.oname."!value".padRight(20," ").substring(0,20)}${msg.oacsts."!value".padRight(1," ").substring(0,1)}${msg.oactip."!value".padRight(1," ").substring(0,1)}${msg.ocurr."!value".padRight(4," ").substring(0,4)}${msg.ocif."!value".padRight(7," ").substring(0,7)}${msg.osccod."!value".padRight(2," ").substring(0,2)}${msg.ocbal."!value".padRight(15," ").substring(0,15)}${msg.ohold."!value".padRight(15," ").substring(0,15)}', NULL);

-- CONFIG RPG
INSERT INTO MWCONFIG.HOST(ID, HOST, USERNAME, PASSWORD, CONTEXT, MODIFIED_BY, TIMESTAMP) VALUES ('CORE_KONVEN_DSP', '172.18.30.104', 'DTIAB00004', 'Batara123', null, CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.RPG_CALL(ID, CMD, HOST, TIMEOUT, MODIFIED_BY, TIMESTAMP) VALUES ('INQUIRY', '/QSYS.LIB/RUNQBTN.LIB/WSINQA6.PGM', 'CORE_KONVEN_DSP', 60000, CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 1, 'iwsid', 'string', 25);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 2, 'iwsref', 'string', 12);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 3, 'iacc', 'string', 19);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 4, 'orsp', 'string', 3);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 5, 'orspdc', 'string', 50);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 6, 'oacc', 'string', 19);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 7, 'oname', 'string', 20);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 8, 'oacsts', 'string', 1);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 9, 'oactip', 'string', 1);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 10, 'ocurr', 'string', 4);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 11, 'ocif', 'string', 7);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 12, 'osccod', 'string', 2);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 13, 'ocbal', 'string', 15);
INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 14, 'ohold', 'string', 15);


-- REST MAPPING ABCS

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.abcs-inquiry.request', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('rest-api.abcs-inquiry.request', 1, '/Data', '/data/body', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!ReplyToQ', 'ROUTER_REST_OUT', 10);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!ReplyToQMgr', 'ITMBROKERQM', 10);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!codex', 'iso-8583-itm', 10);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!group', 'itm', 10);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!code', '0200.204000.001001', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!destination', 'core-itm', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!queueName', 'ITM_IN', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!source', 'itm-10363', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!ttl', '15000', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!type', 'dsp', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'messageType', '0200', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'processingCode', '204000', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'amountTransaction', '', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'merchantType', '6011', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'acquiringInstitutionIdentificationCode', '200', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'track2Data', '4215708903547074=2009126083', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'retrievalReferenceNumber', '${msg.reff."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'cardAcceptorTerminalIdentification', '10001401', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'cardAcceptorIdentificationCode', '200', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'cardAcceptorName', 'JL RAYA BOJONEGARA CILECLG          ID  ', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'additionalDataPrivate', '', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'currencyCodeTransaction', '360', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'reservedPrivate2', '001001000000', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'serviceIndicator', '', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'fromAccount', '${msg.account."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'transmissionDateTime', '${new java.text.SimpleDateFormat("MMddHHmmss").format(new Date())}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'dateLocalTransaction', '${new java.text.SimpleDateFormat("MMdd").format(new Date())}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'dateSettlement', '${(new java.text.SimpleDateFormat("MMdd")).format(new Date()+1 )}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'timeLocalTransaction', '${(new java.text.SimpleDateFormat("HHmmss")).format(new Date() )}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'systemsTraceAuditNumber', '${(new java.text.SimpleDateFormat("HHmmss")).format(new Date() )}', null);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.abcs-inquiry.response', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('rest-api.abcs-inquiry.response', 1, '/data/body', '/data/body/response', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('rest-api.abcs-inquiry.response', 2, '/data/body/frontOriginal/data/JSON/Data', '/data/body/response', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.response', 1, 'rsp', '${msg.responseCode."!value"=="00"?"0":"6"}${msg.responseCode."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.response', 1, 'rspdesc', '${"Transaksi Sukses"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.response', 1, 'available', '${msg.additionalResponseData."!value"[0..11]}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.response', 1, 'nama', '${msg.additionalDataPrivate."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.response', 1, 'saldo', '${msg.additionalResponseData."!value"[12..23]}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.response', 2, 'reff', '${msg.reff."!value"}', null);

-- REST MAPPING JSON

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.json-inquiry.request', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('rest-api.json-inquiry.request', 1, '/Data', '/data/body', 'rest-api.abcs-inquiry.request', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.request', 1, '!code', '0200.205000.001001', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.request', 1, 'processingCode', '205000', null);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.json-inquiry.response', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('rest-api.json-inquiry.response', 1, '/data/body/resCore', '/data/body/response', null, null);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('rest-api.json-inquiry.response', 2, '/data/body/frontOriginal/data/JSON/Data', '/data/body/response', null, null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'ref', '${msg.ref."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'rsp', '${msg.rsp."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'rspdesc', '${msg.rspdesc."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'account', '${msg.account."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'cif', '${msg.cif."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'accounttype', '${msg.accounttype."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'producttype', '${msg.producttype."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'nama', '${msg.nama."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'currency', '${msg.currency."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'status', '${msg.status."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'saldo', '${msg.saldo."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'available', '${msg.available."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'hold', '${msg.hold."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'dateopen', '${msg.dateopen."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'rate', '${msg.rate."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'branch', '${msg.branch."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.response', 1, 'controllingbranch', '${msg.controllingbranch."!value"}', null);

-- REST MAPPING RPG
INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.rpg-inquiry.request', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('rest-api.rpg-inquiry.request', 1, '/Data', '/data/body', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, '!queueName', 'BACKEND_RPG_IN', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, '!ReplyToQ', 'ROUTER_REST_OUT', 10);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, '!ReplyToQMgr', 'ITMBROKERQM', 10);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, '!rpgid', 'INQUIRY', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, 'iwsid', 'BTNPOC', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, 'iwsref', '${msg.reff."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, 'iacc', '${msg.account."!value"}', null);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.rpg-inquiry.response', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('rest-api.rpg-inquiry.response', 1, '/data/body', '/data/body/response', null, null);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('rest-api.rpg-inquiry.response', 2, '/data/body/frontOriginal/data/JSON/Data', '/data/body/response', null, null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'iwsid', '${""}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'oacc', '${""}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'account', '${msg.iacc."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'rsp', '${msg.orsp."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'rspdesc', '${msg.orspdc."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'nama', '${msg.oname."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'status', '${msg.oacsts."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'accounttype', '${msg.oactip."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'currency', '${msg.ocurr."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'cif', '${msg.ocif."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'producttype', '${msg.osccod."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'available', '${msg.ocbal."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'hold', '${msg.ohold."!value"}', null);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 2, 'reff', '${msg.reff."!value"}', null);
-- COPY MESSAGE RESPONSE CORE TO ROUTER REST
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET) VALUES ('res-core.itm', 2, '/data/body', '/data/body/rescore');
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm', 2, '@', 'copyMessage()', 10);