Эхлэл Бүгдийг харах Тусламж
Нэвтрэх
yusuf
/
btnmw-server-local
-с салаалсан wisnu/btnmw-server-local
1
0
Салаа 0
Файлууд
Мод: d5c255e567
Салаанууд Тагууд
btnmw-server-lo...
/
mwconfig
/
migration
/
MWCONFIG_INITDB_POC.sql

MWCONFIG_INITDB_POC.sql 31 KB
Түүх Анхны өгөгдөл

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240 
  1. -- ERROR_MAP --
    2. 

  2. 

  3. INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G03', '89', '', CURRENT USER, CURRENT TIMESTAMP);
    4. 

  4. INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G404', '89', '', CURRENT USER, CURRENT TIMESTAMP);
    5. 

  5. INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G503', '89', '', CURRENT USER, CURRENT TIMESTAMP);
    6. 

  6. INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G504', '68', '', CURRENT USER, CURRENT TIMESTAMP);
    7. 

  7. INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', 'G99', '99', '', CURRENT USER, CURRENT TIMESTAMP);
    8. 

  8. INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', '000', '00', 'Success', CURRENT USER, CURRENT TIMESTAMP);
    9. 

  9. 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);
    10. 

  10. INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP) VALUES ('InquirySaldo', '997', '97', 'Format yang tidak valid', CURRENT USER, CURRENT TIMESTAMP);
    11. 

  11. 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);
    12. 

  12. -- PARAM MAP--
    13. 

  13. 

  14. 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);
    15. 

  15. -- DTREE --
    16. 

  16. 

  17. -- DEV_TELLER_MAP
    18. 

  18. INSERT INTO MWCONFIG.DEV_TELLER_MAP
    19. 

  19. ("GROUP", DEVICE_ID, DEVICE_NAME, TERMINAL_ID, TELLER_ID, CTRL_UNIT_ID, MODIFIED_BY, "TIMESTAMP", TERMINAL_IP)
    20. 

  20. VALUES('itm', '10001401', 'DBL MOCK UP 5', '10001401', '9901401', 'C14', CURRENT USER, CURRENT TIMESTAMP, '172.16.109.20');
    21. 

  21. 

  22. INSERT INTO MWCONFIG.DTREE
    23. 

  23. ("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
    24. 

  24. VALUES('ITM-CODE', '0200.204000', '0200.204000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
    25. 

  25. INSERT INTO MWCONFIG.DTREE
    26. 

  26. ("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
    27. 

  27. VALUES('ITM-CODE', '0210.204000', '0210.204000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
    28. 

  28. INSERT INTO MWCONFIG.DTREE
    29. 

  29. ("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
    30. 

  30. VALUES('ITM-CODE', '0200.205000', '0200.205000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
    31. 

  31. INSERT INTO MWCONFIG.DTREE
    32. 

  32. ("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
    33. 

  33. VALUES('ITM-CODE', '0210.205000', '0210.205000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
    34. 

  34. INSERT INTO MWCONFIG.DTREE
    35. 

  35. ("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
    36. 

  36. VALUES('ITM-CODE', '0200.206000', '0200.206000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
    37. 

  37. INSERT INTO MWCONFIG.DTREE
    38. 

  38. ("GROUP", "PATH", VALUE, MODULE, MODIFIED_BY, "TIMESTAMP")
    39. 

  39. VALUES('ITM-CODE', '0210.206000', '0210.206000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
    40. 

  40. 

  41. -- MAPPING --
    42. 

  42. 

  43. INSERT INTO MWCONFIG.MAPPING
    44. 

  44. (ID, DESCRIPTION, MODULE, MODIFIED_BY, "TIMESTAMP")
    45. 

  45. VALUES('req-core.itm.0200.204000.001001', 'POC inquiry saldo ISO-ABCS', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
    46. 

  46. INSERT INTO MWCONFIG.MAPPING
    47. 

  47. (ID, DESCRIPTION, MODULE, MODIFIED_BY, "TIMESTAMP")
    48. 

  48. VALUES('res-core.itm.0200.204000.001001', 'POC inquiry saldo ISO-ABCS', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
    49. 

  49. INSERT INTO MWCONFIG.MAPPING
    50. 

  50. (ID, DESCRIPTION, MODULE, MODIFIED_BY, "TIMESTAMP")
    51. 

  51. VALUES('req-core.itm.0200.205000.001001', 'POC inquiry saldo ISO-REST', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
    52. 

  52. INSERT INTO MWCONFIG.MAPPING
    53. 

  53. (ID, DESCRIPTION, MODULE, MODIFIED_BY, "TIMESTAMP")
    54. 

  54. VALUES('res-core.itm.0200.205000.001001', 'POC inquiry saldo ISO-REST', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
    55. 

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

  56. 

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

  58. 

  59. --MAPPING_GROUP--
    60. 

  60. 

  61. INSERT INTO MWCONFIG.MAPPING_GROUP
    62. 

  62. (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    63. 

  63. VALUES('req-core.itm.0200.204000.001001', 1, '/data/body', '/data/body', 'req-core.itm', 1);
    64. 

  64. INSERT INTO MWCONFIG.MAPPING_GROUP
    65. 

  65. (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    66. 

  66. VALUES('res-core.itm.0200.204000.001001', 1, '/data/body', '/data/body', 'res-core.itm.0200', 1);
    67. 

  67. 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);
    68. 

  68. 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);
    69. 

  69. 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);
    70. 

  70. 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);
    71. 

  71. 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);
    72. 

  72. 

  73. 

  74. --MAPPING_GROUP_LINE--
    75. 

  75. 

  76. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE
    77. 

  77. (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
    78. 

  78. VALUES('req-core.itm.0200.204000.001001', 1, 'TLBF01', '${msg.fromAccount}', NULL);
    79. 

  79. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE
    80. 

  80. (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
    81. 

  81. VALUES('res-core.itm.0200.204000.001001', 1, 'additionalDataPrivate', '${msg.SNAME_F1}', NULL);
    82. 

  82. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE
    83. 

  83. (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
    84. 

  84. 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);
    85. 

  85. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE
    86. 

  86. (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
    87. 

  87. 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);
    88. 

  88. 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);
    89. 

  89. 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);
    90. 

  90. 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);
    91. 

  91. 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);
    92. 

  92. 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);
    93. 

  93. 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);
    94. 

  94. 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);
    95. 

  95. 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);
    96. 

  96. 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);
    97. 

  97. 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);
    98. 

  98. 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);
    99. 

  99. 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);
    100. 

  100. 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);
    101. 

  101. 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);
    102. 

  102. 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);
    103. 

  103. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm.0200.205000.001001', 2, '@', 'copyMessage();', NULL);
    104. 

  104. 

  105. 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);
    106. 

  106. 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);
    107. 

  107. 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);
    108. 

  108. 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);
    109. 

  109. 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);
    110. 

  110. 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);
    111. 

  111. 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);
    112. 

  112. 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);
    113. 

  113. 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);
    114. 

  114. 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);
    115. 

  115. 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);
    116. 

  116. 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);
    117. 

  117. 

  118. -- CONFIG RPG
    119. 

  119. 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);
    120. 

  120. 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);
    121. 

  121. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 1, 'iwsid', 'string', 25);
    122. 

  122. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 2, 'iwsref', 'string', 12);
    123. 

  123. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 3, 'iacc', 'string', 19);
    124. 

  124. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 4, 'orsp', 'string', 3);
    125. 

  125. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 5, 'orspdc', 'string', 50);
    126. 

  126. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 6, 'oacc', 'string', 19);
    127. 

  127. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 7, 'oname', 'string', 20);
    128. 

  128. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 8, 'oacsts', 'string', 1);
    129. 

  129. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 9, 'oactip', 'string', 1);
    130. 

  130. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 10, 'ocurr', 'string', 4);
    131. 

  131. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 11, 'ocif', 'string', 7);
    132. 

  132. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 12, 'osccod', 'string', 2);
    133. 

  133. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 13, 'ocbal', 'string', 15);
    134. 

  134. INSERT INTO MWCONFIG.RPG_CALL_ARG(RPG_CALL_ID, ID, NAME, "TYPE", LENGTH) VALUES ('INQUIRY', 14, 'ohold', 'string', 15);
    135. 

  135. 

  136. 

  137. -- REST MAPPING ABCS
    138. 

  138. 

  139. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.abcs-inquiry.request', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
    140. 

  140. 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);
    141. 

  141. 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);
    142. 

  142. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!ReplyToQMgr', 'ITMBROKERQM', 10);
    143. 

  143. 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);
    144. 

  144. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!group', 'itm', 10);
    145. 

  145. 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);
    146. 

  146. 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);
    147. 

  147. 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);
    148. 

  148. 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);
    149. 

  149. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!ttl', '15000', null);
    150. 

  150. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, '!type', 'dsp', null);
    151. 

  151. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'messageType', '0200', null);
    152. 

  152. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'processingCode', '204000', null);
    153. 

  153. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'amountTransaction', '', null);
    154. 

  154. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'merchantType', '6011', null);
    155. 

  155. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'acquiringInstitutionIdentificationCode', '200', null);
    156. 

  156. 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);
    157. 

  157. 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);
    158. 

  158. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'cardAcceptorTerminalIdentification', '10001401', null);
    159. 

  159. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'cardAcceptorIdentificationCode', '200', null);
    160. 

  160. 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);
    161. 

  161. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'additionalDataPrivate', '', null);
    162. 

  162. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'currencyCodeTransaction', '360', null);
    163. 

  163. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'reservedPrivate2', '001001000000', null);
    164. 

  164. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.abcs-inquiry.request', 1, 'serviceIndicator', '', null);
    165. 

  165. 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);
    166. 

  166. 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);
    167. 

  167. 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);
    168. 

  168. 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);
    169. 

  169. 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);
    170. 

  170. 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);
    171. 

  171. 

  172. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.abcs-inquiry.response', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
    173. 

  173. 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);
    174. 

  174. 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);
    175. 

  175. 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);
    176. 

  176. 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);
    177. 

  177. 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);
    178. 

  178. 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);
    179. 

  179. 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);
    180. 

  180. 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);
    181. 

  181. 

  182. -- REST MAPPING JSON
    183. 

  183. 

  184. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.json-inquiry.request', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
    185. 

  185. 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);
    186. 

  186. 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);
    187. 

  187. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.json-inquiry.request', 1, 'processingCode', '205000', null);
    188. 

  188. 

  189. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.json-inquiry.response', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
    190. 

  190. 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);
    191. 

  191. 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);
    192. 

  192. 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);
    193. 

  193. 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);
    194. 

  194. 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);
    195. 

  195. 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);
    196. 

  196. 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);
    197. 

  197. 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);
    198. 

  198. 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);
    199. 

  199. 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);
    200. 

  200. 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);
    201. 

  201. 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);
    202. 

  202. 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);
    203. 

  203. 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);
    204. 

  204. 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);
    205. 

  205. 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);
    206. 

  206. 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);
    207. 

  207. 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);
    208. 

  208. 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);
    209. 

  209. 

  210. -- REST MAPPING RPG
    211. 

  211. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.rpg-inquiry.request', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
    212. 

  212. 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);
    213. 

  213. 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);
    214. 

  214. 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);
    215. 

  215. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, '!ReplyToQMgr', 'ITMBROKERQM', 10);
    216. 

  216. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, '!rpgid', 'INQUIRY', null);
    217. 

  217. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.request', 1, 'iwsid', 'BTNPOC', null);
    218. 

  218. 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);
    219. 

  219. 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);
    220. 

  220. 

  221. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('rest-api.rpg-inquiry.response', '[rest]', CURRENT USER, CURRENT TIMESTAMP);
    222. 

  222. 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);
    223. 

  223. 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);
    224. 

  224. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'iwsid', '${""}', null);
    225. 

  225. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('rest-api.rpg-inquiry.response', 1, 'oacc', '${""}', null);
    226. 

  226. 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);
    227. 

  227. 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);
    228. 

  228. 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);
    229. 

  229. 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);
    230. 

  230. 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);
    231. 

  231. 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);
    232. 

  232. 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);
    233. 

  233. 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);
    234. 

  234. 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);
    235. 

  235. 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);
    236. 

  236. 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);
    237. 

  237. 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);
    238. 

  238. -- COPY MESSAGE RESPONSE CORE TO ROUTER REST
    239. 

  239. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET) VALUES ('res-core.itm', 2, '/data/body', '/data/body/rescore');
    240. 

  240. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('res-core.itm', 2, '@', 'copyMessage()', 10);
    241.