btnmw-server-local/mwconfig/migration/MWCONFIG_INITDB_ITM_02_core.itm.res-reverse-master.sql

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) 
  VALUES ('req-core.itm.res-reverse-master', '[iwswc][itm][itsii]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
  VALUES ('req-core.itm.res-reverse-master', 1, '/data/body', '/data/body', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
  VALUES 
    ('req-core.itm.res-reverse-master', 1, '@', 'copyMessage(".", "request/data/original1/request/data/body");', 10), 
    ('req-core.itm.res-reverse-master', 1, '!connid', '${head.request.data.original1.request.data.connid}', 20), 
    ('req-core.itm.res-reverse-master', 1, '!destination', '${head.request.data.original1.request.data.destination}', 20), 
    ('req-core.itm.res-reverse-master', 1, '!group', '${head.request.data.original1.request.data.group}', 20), 
    ('req-core.itm.res-reverse-master', 1, '!mappingCode', '${head.request.data.original1.request.data.mappingCode}', 20), 
    ('req-core.itm.res-reverse-master', 1, '!mid', '${head.request.data.original1.request.data.mid}.2', 20), 
    ('req-core.itm.res-reverse-master', 1, '!queueName', '${head.request.data.original1.request.data.queueName}', 20), 
    ('req-core.itm.res-reverse-master', 1, '!reqtimestamp', '${head.request.data.original1.request.data.reqtimestamp}', 20), 
    ('req-core.itm.res-reverse-master', 1, '!sid', '${head.sid}', 20), 
    ('req-core.itm.res-reverse-master', 1, '!source', '${head.request.data.original1.request.data.source}', 20), 
    ('req-core.itm.res-reverse-master', 1, '!timestamp', '${head.request.data.original1.request.data.timestamp}', 20);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) 
  VALUES ('req-core.itm.res-reverse-master.konven', '[itm][itsii]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
  VALUES ('req-core.itm.res-reverse-master.konven', 1, '/data/body', '/data/body', 'req-core.itm.res-reverse-master', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
  VALUES 
    ('req-core.itm.res-reverse-master.konven', 1, '!code', '${head.request.data.original1.request.data.code}', 20), 
    ('req-core.itm.res-reverse-master.konven', 1, '!CorrelId', '${head.request.data.original1.request.data.CorrelId}', 20), 
    ('req-core.itm.res-reverse-master.konven', 1, '!remaining', '${head.request.data.original1.request.data.remaining}', 20), 
    ('req-core.itm.res-reverse-master.konven', 1, '!remainingPos', '${head.request.data.original1.request.data.remainingPos}', 20), 
    ('req-core.itm.res-reverse-master.konven', 1, '!type', '${head.request.data.original1.request.data.type}', 20), 
    ('req-core.itm.res-reverse-master.konven', 1, 'TLBF20', '${head.request.data.original1.request.data.body.TLBJSN}', 20), 
    ('req-core.itm.res-reverse-master.konven', 1, 'TLBWC2', '10', 20);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) 
  VALUES ('req-core.itm.res-reverse-master.syariah', '[itm][itsii]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
  VALUES ('req-core.itm.res-reverse-master.syariah', 1, '/data/body', '/data/body', 'req-core.itm.res-reverse-master', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
  VALUES 
    ('req-core.itm.res-reverse-master.syariah', 1, 'messageType', '400', 20), 
    ('req-core.itm.res-reverse-master.syariah', 1, 'originalDataElements', '${head.request.data.original1.request.data.body.messageType."!value"+head.request.data.original1.request.data.body.retrievalReferenceNumber."!value"+head.request.data.original1.request.data.body.dateLocalTransaction."!value"+head.request.data.original1.request.data.body.timeLocalTransaction."!value"+head.request.data.original1.request.data.body.dateCapture."!value"+"          "}', 20);