Página inicial Explorar Ajuda
Entrar
fiqri
/
btn-mdw-ace-server-local
1
0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Tree: 29a7959698
Branches Tags
btn-mdw-ace-ser...
/
mwconfig
/
migration
/
MWCONFIG_INITDB_TRF_ON_US.sql

MWCONFIG_INITDB_TRF_ON_US.sql 30 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265 
  1. INSERT INTO MWCONFIG.ROUTING_TABLE (CODE_START, CODE_END, CHANNEL, START_DATE, QUEUE, STATUS, REPLY_TO, REPLY_TO_QMGR, CREATE_BY, CREATE_DATE)
    2. 

  2. 	VALUES 
    3. 

  3. 		('0200.470000', '0200.470000', 'sms', CURRENT TIMESTAMP, 'SMS_IBFT_INQIN', 'ACTIVE', 'ROUTER_OUT', 'SMSBROKER.QM', CURRENT USER, CURRENT TIMESTAMP),
    4. 

  4. 		('0200.570000', '0200.570000', 'sms', CURRENT TIMESTAMP, 'SMS_IBFT_PAYIN', 'ACTIVE', 'ROUTER_OUT', 'SMSBROKER.QM', CURRENT USER, CURRENT TIMESTAMP);
    5. 

  5. 

  6. 

  7. INSERT INTO MWCONFIG.DTREE (GROUP, PATH, VALUE, MODIFIED_BY, TIMESTAMP, MODULE)
    8. 

  8.     VALUES
    9. 

  9.         ('CHARGES', 'sms', 'sms|${msg.processingCode."!value".substring(0,2)}', CURRENT USER, CURRENT TIMESTAMP, '[smsro]'),
    10. 

  10.         ('CHARGES', 'sms|57', 'sms-ibft-${msg.reservedPrivate2."!value".substring(3,6).toLowerCase()}', CURRENT USER, CURRENT TIMESTAMP, '[smsro]'),
    11. 

  11.         ('CHARGES', 'sms-ibft-alt', '---', CURRENT USER, CURRENT TIMESTAMP, '[smsro]'),
    12. 

  12.         ('CHARGES', 'sms-ibft-amp', '----', CURRENT USER, CURRENT TIMESTAMP, '[smsro]'),
    13. 

  13.         ('CHARGES', 'sms-ibft-bca', '---', CURRENT USER, CURRENT TIMESTAMP, '[smsro]'),
    14. 

  14.         ('CHARGES', 'sms-ibft-hbr', '---', CURRENT USER, CURRENT TIMESTAMP, '[smsro]'),
    15. 

  15.         ('CHARGES', 'sms-ibft-sat', '---', CURRENT USER, CURRENT TIMESTAMP, '[smsro]');
    16. 

  16. 

  17. INSERT INTO MWCONFIG.CHARGES (ID, C1_VALUE, C1_NAME, C1_SCRIPT, C1_ACCOUNT, C2_VALUE, C2_NAME, C2_SCRIPT, C2_ACCOUNT, C3_VALUE, C3_NAME, C3_SCRIPT, C3_ACCOUNT, C4_VALUE, C4_NAME, C4_SCRIPT, C4_ACCOUNT, C5_VALUE, C5_NAME, C5_SCRIPT, C5_ACCOUNT, MODIFIED_BY, TIMESTAMP)
    18. 

  18.     VALUES 
    19. 

  19.         ('sms-ibft-alt', 3800.00, 'acquirer', NULL, '467917400000 ', 1500.00, 'switcher', NULL, '211974400000', 0.00, 'COA', NULL, NULL, 1200.00, 'Issuer', NULL, '211974400000', 6500.00, 'total', NULL, '211974400000', CURRENT USER, CURRENT TIMESTAMP),
    20. 

  20.         ('sms-ibft-amp', 4625.00, 'fee acquirer', NULL, '999467965491413', 0.00, 'fee issuer', NULL, '0', 0.00, 'fee promosi', NULL, '0', 375.00, 'fee switcher', NULL, '999211962491413', 1500.00, 'Fee Destination', NULL, '999211978491413', CURRENT USER, CURRENT TIMESTAMP),
    21. 

  21.         ('sms-ibft-amp-LMP', 3625.00, 'fee acquirer', NULL, '999467965491413', 0.00, 'fee issuer', NULL, '0', 0.00, 'fee promosi', NULL, '0', 375.00, 'fee switcher', NULL, '999211962491413', 0.00, 'Fee Destination', NULL, '999211987491413', CURRENT USER, CURRENT TIMESTAMP),
    22. 

  22.         ('sms-ibft-amp-XMP', 3800.00, 'fee acquirer', NULL, '999467965491413', 825.00, 'fee issuer', NULL, '0', 0.00, 'fee promosi', NULL, '0', 375.00, 'fee switcher', NULL, '999211962491413', 1500.00, 'Fee Destination', NULL, '999211987491413', CURRENT USER, CURRENT TIMESTAMP),
    23. 

  23.         ('sms-ibft-bca', 3850.00, 'acquirer', NULL, '467915400000', 1500.00, 'beneficiary', NULL, '211976400000', 1150.00, 'switcher', NULL, '211976400000', 5000.00, 'COA-4', NULL, '', 6500.00, 'total', NULL, '211976400000', CURRENT USER, CURRENT TIMESTAMP),
    24. 

  24.         ('sms-ibft-hbr', 4625.00, 'acquirer', NULL, '467915200000', 1500.00, 'beneficiary', NULL, '211978400000', 0.00, 'COA-3', NULL, '', 375.00, 'switcher', NULL, '211962400000', 0.00, 'COA-5', NULL, '211978400000', CURRENT USER, CURRENT TIMESTAMP),
    25. 

  25.         ('sms-ibft-sat', 3800.00, 'acquirer', NULL, '467916200000', 1500.00, 'beneficiary', NULL, '211987400000', 1200.00, 'switcher', NULL, '211968400000', 0.00, 'COA-4', NULL, '211968400000', 6500.00, 'total', NULL, '211987400000', CURRENT USER, CURRENT TIMESTAMP);
    26. 

  26. 

  27. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('sms.abcs-err-to-iso', '[sms]', CURRENT USER, CURRENT TIMESTAMP);
    28. 

  28. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    29. 

  29.     VALUES 
    30. 

  30.         ('sms.abcs-err-to-iso', 1, '/data', '/data', NULL, NULL),
    31. 

  31.         ('sms.abcs-err-to-iso', 2, '/data/body', '/data/body', NULL, NULL),
    32. 

  32.         ('sms.abcs-err-to-iso', 3, '/data/coreResponse/body', '/data/body', NULL, NULL);
    33. 

  33. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    34. 

  34.     VALUES 
    35. 

  35.         ('sms.abcs-err-to-iso', 1, '@', 'copyMessage()', 1),
    36. 

  36.         ('sms.abcs-err-to-iso', 2, 'messageType', '0210', 1),
    37. 

  37.         ('sms.abcs-err-to-iso', 2, 'responseCode', '${getParamValue("error_map|core-itm", head.coreResponse.body.responseCode."!value","99")}', 2),
    38. 

  38.         ('sms.abcs-err-to-iso', 3, 'reservedForPrivateUse2', '${msg.ERROR_F2==null?"":msg.ERROR_F2."!value"}', 2);
    39. 

  39. 

  40. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('sms.0200.470000', '[sms]', CURRENT USER, CURRENT TIMESTAMP);
    41. 

  41. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    42. 

  42.     VALUES 
    43. 

  43.         ('sms.0200.470000', 1, '/data', '/data', NULL, NULL),
    44. 

  44.         ('sms.0200.470000', 2, '/data/body', '/data/body', NULL, NULL);
    45. 

  45. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    46. 

  46.     VALUES 
    47. 

  47.         ('sms.0200.470000', 1, '@', 'copyMessage();', 1),
    48. 

  48.         ('sms.0200.470000', 1, 'type', '${null}', 1),
    49. 

  49.         ('sms.0200.470000', 2, '!destination', 'itm-conn', 1),
    50. 

  50.         ('sms.0200.470000', 2, '!group', '${head.group}', 1),
    51. 

  51.         ('sms.0200.470000', 2, 'messageType', '0200', 2),
    52. 

  52.         ('sms.0200.470000', 2, 'systemsTraceAuditNumber', '${msg.systemsTraceAuditNumber} ', 3),
    53. 

  53.         ('sms.0200.470000', 2, 'transmissionDateTime', '${getTimeZoneFormat("MMddHHmmss","GMT")}', 5),
    54. 

  54.         ('sms.0200.470000', 2, 'amountTransactionFee', '${null}', 6),
    55. 

  55.         ('sms.0200.470000', 2, 'amountTransactionProcessingFee', '${null}', 6),
    56. 

  56.         ('sms.0200.470000', 2, 'merchantType', '6017', 6),
    57. 

  57.         ('sms.0200.470000', 2, 'receivingInstitutionIdentificationCode', '${head.source."!value".substring(4,8) == "5080"?msg.cardAcceptorIdentificationCode."!value".padRight(11," ").substring(0,11):msg.receivingInstitutionIdentificationCode."!value".padRight(11," ").substring(0,11)}', 7),
    58. 

  58.         ('sms.0200.470000', 2, 'reservedForPrivateUse', '${msg.receivingInstitutionIdentificationCode}', 7),
    59. 

  59.         ('sms.0200.470000', 2, 'reservedPrivate2', '001${msg.reservedPrivate2."!value".substring(0,6).equals("001AMP")?"001MRP":msg.reservedPrivate2."!value".substring(0,6)}000', 8),
    60. 

  60.         ('sms.0200.470000', 2, 'timeLocalTransaction', '${new java.text.SimpleDateFormat("HHmmss").format(new Date())}', 10),
    61. 

  61.         ('sms.0200.470000', 2, 'dateLocalTransaction', '${new java.text.SimpleDateFormat("MMdd").format(new Date())}', 11),
    62. 

  62.         ('sms.0200.470000', 2, '!mid', '${tar.transmissionDateTime."!value"+"."+tar.systemsTraceAuditNumber."!value"}', 99),
    63. 

  63.         ('sms.0200.470000', 2, 'processingCode', '${msg.reservedPrivate2."!value".substring(3,6).equals("AMP")?"45":msg.reservedPrivate2."!value".substring(3,6).equals("BCA")?"46":msg.reservedPrivate2."!value".substring(3,6).equals("HBR")?"47":msg.reservedPrivate2."!value".substring(3,6).equals("SAT")?"48":msg.reservedPrivate2."!value".substring(3,6).equals("ALT")?"49":"99"}${msg.processingCode."!value".substring(2,6)}', null);
    64. 

  64. 

  65. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('resp-ln.sms', NULL, CURRENT USER, CURRENT TIMESTAMP);
    66. 

  66. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    67. 

  67.     VALUES 
    68. 

  68.         ('resp-ln.sms', 1, '/data', '/data', NULL, NULL),
    69. 

  69.         ('resp-ln.sms', 2, '/data/body', '/data/body', NULL, NULL);
    70. 

  70. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    71. 

  71. VALUES 
    72. 

  72.     ('resp-ln.sms', 1, '@', 'copyMessage()', 1),
    73. 

  73.     ('resp-ln.sms', 2, 'messageType', '0210', 1),
    74. 

  74.     ('resp-ln.sms', 2, 'responseCode', '${head.source."!value".substring(0,6).equals("sms-10") && head.code."!value".substring(0,7) == "0200.1." && head.source."!value".substring(0,9) != "sms-10802"?"B1":"89"}', 2);
    75. 

  75. 

  76. INSERT INTO MWCONFIG.MAPPING(ID, DESCRIPTION, MODIFIED_BY, TIMESTAMP, MODULE) VALUES ('sms.0200.470000.itm-conn.0210.490000', '', CURRENT USER, CURRENT TIMESTAMP, '[sms]');
    77. 

  77. INSERT INTO MWCONFIG.MAPPING_GROUP(MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    78. 

  78.     VALUES 
    79. 

  79.         ('sms.0200.470000.itm-conn.0210.490000', 1, '/data/request/data/body/frontOriginal', '/data', null, null),
    80. 

  80.         ('sms.0200.470000.itm-conn.0210.490000', 2, '/data/body', '/data/body', null, null);
    81. 

  81. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    82. 

  82.     VALUES 
    83. 

  83.         ('sms.0200.470000.itm-conn.0210.490000', 2, 'additionalDataPrivate', '${msg.responseCode."!value".equals("00")?msg.additionalDataPrivate:tar.additionalDataPrivate}${head.request.data.source."!value".substring(4,8) != "1080" ? "000000650000" : ""}', 4),
    84. 

  84.         ('sms.0200.470000.itm-conn.0210.490000', 2, 'messageType', '0210', 5),
    85. 

  85.         ('sms.0200.470000.itm-conn.0210.490000', 2, 'responseCode', '${head.request.data.source."!value".substring(0,6).equals("sms-10")?"99":(getParamValue("error_map|ibft-"+head.request.data.body.frontOriginal.body.reservedPrivate2."!value".substring(3,6).toUpperCase(), msg.responseCode."!value",msg.responseCode."!value"))}', 6),
    86. 

  86.         ('sms.0200.470000.itm-conn.0210.490000', 1, '@', 'copyMessage();', 2);
    87. 

  87. 

  88. INSERT INTO MWCONFIG.MAPPING(ID, DESCRIPTION, MODIFIED_BY, TIMESTAMP, MODULE) VALUES ('sms.0200.470000.itm-conn.0210.450000', null, CURRENT USER, CURRENT TIMESTAMP, '[sms]');
    89. 

  89. INSERT INTO MWCONFIG.MAPPING_GROUP(MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
    90. 

  90.     VALUES
    91. 

  91.         ('sms.0200.470000.itm-conn.0210.450000', 1, '/data/request/data/body/frontOriginal', '/data', 'sms.0200.470000.itm-conn.0210.490000', 1),
    92. 

  92.         ('sms.0200.470000.itm-conn.0210.450000', 2, '/data/body', '/data/body', 'sms.0200.470000.itm-conn.0210.490000', 2);
    93. 

  93. 

  94. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    95. 

  95.     VALUES 
    96. 

  96.         ('sms.0200.470000.itm-conn.0210.450000', 2, 'issuerTraceId', '${msg.issuerTraceId}', null),
    97. 

  97.         ('sms.0200.470000.itm-conn.0210.450000', 2, 'additionalDataPrivate', '${msg.responseCode."!value".equals("00")?msg.additionalDataPrivate:tar.additionalDataPrivate}${head.request.data.source."!value".substring(4,8) != "1080" ? (msg.issuerTraceId."!value"==null?"":msg.issuerTraceId."!value"=="LMP"?"000000650000":msg.issuerTraceId."!value"=="XMP"?"000000650000":"000000000000") : ""}', null);
    98. 

  98. 

  99. 

  100. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.sms', '[sms]', CURRENT USER, CURRENT TIMESTAMP);
    101. 

  101. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('req-core.sms', 1, '/data/body', '/data/body', 'dsp', '1');
    102. 

  102. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    103. 

  103.     VALUES 
    104. 

  104.         ('req-core.sms', 1, 'dspTransactionCode', '${getParamValue("sms-konven-code", "0200."+head.body.processingCode ."!value"+"."+head.body.reservedPrivate2."!value", "0000")}', 10),
    105. 

  105.         ('req-core.sms', 1, 'tellerComplete', '${getParamValue("device_teller_map", head.group."!value".trim() + "_" + msg.cardAcceptorTerminalIdentification."!value".trim(), "|||| ")}', 10),
    106. 

  106.         ('req-core.sms', 1, '!code', '${"AXISSYSTEMSDNBHD."+tar.dspTransactionCode}', 20),
    107. 

  107.         ('req-core.sms', 1, 'TLBTCD', '${tar.dspTransactionCode}', 20),
    108. 

  108.         ('req-core.sms', 1, '!destination', 'core-sms', null),
    109. 

  109.         ('req-core.sms', 1, '!mappingCode', '${head.code}', null),
    110. 

  110.         ('req-core.sms', 1, '!queueName', 'CORE_IN', null),
    111. 

  111.         ('req-core.sms', 1, '!type', 'dsp', null),
    112. 

  112.         ('req-core.sms', 1, '@', 'copyMessageToChild("original");', null),
    113. 

  113.         ('req-core.sms', 1, 'ICDEVN', '${tar.tellerComplete."!value".split("\\|", -1)[3]}', null),
    114. 

  114.         ('req-core.sms', 1, 'ICEOM', '*EOM', null),
    115. 

  115.         ('req-core.sms', 1, 'ICHEAD', '*MOSA', null),
    116. 

  116.         ('req-core.sms', 1, 'ICID', '00000', null),
    117. 

  117.         ('req-core.sms', 1, 'ICLEN', '1020', null),
    118. 

  118.         ('req-core.sms', 1, 'RMADD3', '${(msg.track2Data==null||msg.track2Data."!value"==null?"":msg.track2Data."!value").padRight(37," ")}', null),
    119. 

  119.         ('req-core.sms', 1, 'RMAPID', '${msg.retrievalReferenceNumber}${new java.text.SimpleDateFormat("yy").format(new Date())+msg.dateLocalTransaction."!value"}${msg.timeLocalTransaction}', null),
    120. 

  120.         ('req-core.sms', 1, 'RMPSTC', '${new java.text.SimpleDateFormat("yyyy").format(new Date())+msg.dateLocalTransaction."!value"}', null),
    121. 

  121.         ('req-core.sms', 1, 'RMSEHS', '${msg.dateLocalTransaction}', null),
    122. 

  122.         ('req-core.sms', 1, 'TLBCIF', '${msg.timeLocalTransaction}', null),
    123. 

  123.         ('req-core.sms', 1, 'TLBCUD', '${tar.tellerComplete."!value".split("\\|", -1)[2]}', null),
    124. 

  124.         ('req-core.sms', 1, 'TLBCUR', 'IDR', null),
    125. 

  125.         ('req-core.sms', 1, 'TLBDS1', '${msg.timeLocalTransaction."!value"+msg.dateLocalTransaction."!value"+msg.acquiringInstitutionIdentificationCode."!value".padRight(11," ")+msg.merchantType."!value".padRight(4, " ")+msg.retrievalReferenceNumber."!value".padRight(12," ")}', null),
    126. 

  126.         ('req-core.sms', 1, 'TLBFIL', '${msg.cardAcceptorTerminalIdentification."!value"+msg.retrievalReferenceNumber."!value".padRight(12," ")+msg.acquiringInstitutionIdentificationCode."!value".padRight(11," ")}', null),
    127. 

  127.         ('req-core.sms', 1, 'TLBFP1', 'FF', null),
    128. 

  128.         ('req-core.sms', 1, 'TLBFP2', 'FC', null),
    129. 

  129.         ('req-core.sms', 1, 'TLBFP3', 'FF', null),
    130. 

  130.         ('req-core.sms', 1, 'TLBID', '${tar.tellerComplete."!value".split("\\|", -1)[0]}', null),
    131. 

  131.         ('req-core.sms', 1, 'TLBJC1', '00', null),
    132. 

  132.         ('req-core.sms', 1, 'TLBJC2', '00', null),
    133. 

  133.         ('req-core.sms', 1, 'TLBJSN', '${msg.systemsTraceAuditNumber}', null),
    134. 

  134.         ('req-core.sms', 1, 'TLBTDT', '${msg.transmissionDateTime."!value".substring(2,4)+msg.transmissionDateTime."!value".substring(0,2)+new java.text.SimpleDateFormat("yy").format(new Date())}', null),
    135. 

  135.         ('req-core.sms', 1, 'TLBWC1', '00', null),
    136. 

  136.         ('req-core.sms', 1, 'TLBWC2', '00', null),
    137. 

  137.         ('req-core.sms', 1, 'TLBWS', 'ES', null),
    138. 

  138.         ('req-core.sms', 1, 'TLCUR1', 'IDR', null),
    139. 

  139.         ('req-core.sms', 1, 'TLXUFD', 'SMS', null),
    140. 

  140.         ('req-core.sms', 1, 'TMTIMIN', '000000', null),
    141. 

  141.         ('req-core.sms', 1, 'TMTXTYP', 'T9999', null),
    142. 

  142.         ('req-core.sms', 1, 'dspBankIdNumber', '00000000000', null),
    143. 

  143.         ('req-core.sms', 1, 'dspDataFormatId', 'ABCS', null),
    144. 

  144.         ('req-core.sms', 1, 'dspDeviceName', '${tar.tellerComplete."!value".split("\\|", -1)[3]}', null),
    145. 

  145.         ('req-core.sms', 1, 'dspExchangeId', '4040404040404040404040404040404040404040', null),
    146. 

  146.         ('req-core.sms', 1, 'dspFiller1', 'F0', null),
    147. 

  147.         ('req-core.sms', 1, 'dspHeaderType', '*HOST', null),
    148. 

  148.         ('req-core.sms', 1, 'dspNode', '00', null),
    149. 

  149.         ('req-core.sms', 1, 'dspScenarioNumber', 'AXISSYSTEMSDNBHD', null),
    150. 

  150.         ('req-core.sms', 1, 'dspSourceId', '*AXIS', null),
    151. 

  151.         ('req-core.sms', 1, 'dspTerminalId', '${tar.tellerComplete."!value".split("\\|", -1)[1]}', null),
    152. 

  152.         ('req-core.sms', 1, 'dspUserId', '${tar.tellerComplete."!value".split("\\|", -1)[0]}', null),
    153. 

  153.         ('req-core.sms', 1, 'dspVersionNumber', '0000', null);
    154. 

  154. 

  155. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.sms.0200.570000.001', '[sms]', CURRENT USER, CURRENT TIMESTAMP);
    156. 

  156. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('req-core.sms.0200.570000.001', 1, '/data/body', '/data/body', 'req-core.sms', '1');
    157. 

  157. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    158. 

  158. VALUES 
    159. 

  159.         ('req-core.sms.0200.570000.001', 1, '@', 'copyMessage("frontOriginal", ".");dtree("CHARGES","!group");', 1),
    160. 

  160.         ('req-core.sms.0200.570000.001', 1, '!reqtimestamp', '${head.reqtimestamp}', 2),
    161. 

  161.         ('req-core.sms.0200.570000.001', 1, '!CorrelId', '${head.CorrelId}', 3),
    162. 

  162.         ('req-core.sms.0200.570000.001', 1, '!type', 'dsp', 4),
    163. 

  163.         ('req-core.sms.0200.570000.001', 1, '!destination', 'core-sms', 5),
    164. 

  164.         ('req-core.sms.0200.570000.001', 1, '!mid', '${head.mid}', 6),
    165. 

  165.         ('req-core.sms.0200.570000.001', 1, '!ttl', '15000', 10),
    166. 

  166.         ('req-core.sms.0200.570000.001', 1, 'dspTransactionCode', '${getParamValueWithError("sms-ibft-konven-code", msg.reservedPrivate2."!value".substring(3,6)+"-"+msg.processingCode."!value".substring(2,4), "error:92Unknown Transaction Code")}', 10),
    167. 

  167.         ('req-core.sms.0200.570000.001', 1, 'fee_ibb', '${head.source."!value".substring(4,7) == "318"? msg.amountTransactionProcessingFee==null?"0":msg.amountTransactionProcessingFee."!value"==null?"0":msg.amountTransactionProcessingFee."!value"=="0"?"0":msg.amountTransactionProcessingFee."!value"==""?"0":msg.amountTransactionProcessingFee:0}', 10),
    168. 

  168.         ('req-core.sms.0200.570000.001', 1, 'total_fee', '${(getCharge(1)?getCharge(1).toBigDecimal()*100:0)+(getCharge(2)?getCharge(2).toBigDecimal()*100:0)+(getCharge(3)?getCharge(3).toBigDecimal()*100:0)+(getCharge(4)?getCharge(4).toBigDecimal()*100:0)+(getCharge(5)?getCharge(5).toBigDecimal()*100:0)}', 10),
    169. 

  169.         ('req-core.sms.0200.570000.001', 1, 'RMPAD1', '${head.source."!value".substring(4,8).equals("5080")?msg.reservedForIsoUse1?."!value":""}', 15),
    170. 

  170.         ('req-core.sms.0200.570000.001', 1, 'TLBFP3', 'FF', 15),
    171. 

  171.         ('req-core.sms.0200.570000.001', 1, 'RMPAD2', '${head.source."!value".substring(4,8).equals("5080")?msg.reservedForIsoUse2?."!value":""}', 16),
    172. 

  172.         ('req-core.sms.0200.570000.001', 1, 'TLBJSN', '${msg.systemsTraceAuditNumber}', 16),
    173. 

  173.         ('req-core.sms.0200.570000.001', 1, 'RMPAD3', '${head.source."!value".substring(4,8).equals("5080")?msg.transmissionDateTime?."!value":""}', 17),
    174. 

  174.         ('req-core.sms.0200.570000.001', 1, 'TLBFP1', 'FF', 17),
    175. 

  175.         ('req-core.sms.0200.570000.001', 1, 'TLBFP2', 'FC', 18),
    176. 

  176.         ('req-core.sms.0200.570000.001', 1, 'TLBF01', '${msg.fromAccount}', 19),
    177. 

  177.         ('req-core.sms.0200.570000.001', 1, '!code', 'AXISSYSTEMSDNBHD.000000${tar.dspTransactionCode}', 20),
    178. 

  178.         ('req-core.sms.0200.570000.001', 1, 'RMPYID', '${head.source."!value".substring(4,8).equals("5080")?decimalFormat("0",msg.amountTransaction."!value".toBigDecimal()/100):""}', 20),
    179. 

  179.         ('req-core.sms.0200.570000.001', 1, 'TLBF02', '${msg.amountTransaction}', 20),
    180. 

  180.         ('req-core.sms.0200.570000.001', 1, 'TLBTCD', '${tar.dspTransactionCode}', 20),
    181. 

  181.         ('req-core.sms.0200.570000.001', 1, 'TLBTPN', '${head.source."!value".substring(4,8).equals("5080")?msg.reservedForIsoUse3?."!value":"TRF "+msg.additionalDataPrivate?."!value".padRight(76," ").substring(0,12).trim()+" "+getParamValue("bank-name", msg.receivingInstitutionIdentificationCode."!value".trim(), "").padRight(10," ").substring(0,10).trim()+" "+(msg.toAccount?."!value"!=null?msg.toAccount."!value".padLeft(19,"0").substring(7,19):"")}', 20),
    182. 

  182.         ('req-core.sms.0200.570000.001', 1, 'TLBF03', '${getAccount(1)}', 21),
    183. 

  183.         ('req-core.sms.0200.570000.001', 1, 'TLBF04', '${getCharge(1)?getCharge(1).toBigDecimal()*100:0}', 22),
    184. 

  184.         ('req-core.sms.0200.570000.001', 1, 'TLBF05', '${msg.reservedPrivate2."!value".substring(3,6).equals("ALT")?getAccount(2):msg.reservedPrivate2."!value".substring(3,6).equals("AMP")?"":getAccount(2)}', 23),
    185. 

  185.         ('req-core.sms.0200.570000.001', 1, 'TLBF09', '${msg.reservedPrivate2."!value".substring(3,6).equals("ALT")?"0":msg.reservedPrivate2."!value".substring(3,6).equals("AMP")?"":getAccount(4)}', 23),
    186. 

  186.         ('req-core.sms.0200.570000.001', 1, 'TLBF11', '${head.source."!value".substring(4,7) == "318" ? getParamValueWithError("coa", "gl-pendapatan-layanan", "error:92Unknown coa") : msg.reservedPrivate2."!value".substring(3,6).equals("ALT")? "0":msg.reservedPrivate2."!value".substring(3,6).equals("AMP")? (msg.issuerTraceId."!value"=="LMP" ? "0" : getAccount(1)): "0"}', 23),
    187. 

  187.         ('req-core.sms.0200.570000.001', 1, 'TLBF06', '${msg.reservedPrivate2."!value".substring(3,6).equals("ALT")?(getCharge(2)?getCharge(2).toBigDecimal()*100:0):msg.reservedPrivate2."!value".substring(3,6).equals("AMP")?"":getCharge(2)?getCharge(2).toBigDecimal()*100:0}', 24),
    188. 

  188.         ('req-core.sms.0200.570000.001', 1, 'TLBF10', '${msg.reservedPrivate2."!value".substring(3,6).equals("ALT")?"0":msg.reservedPrivate2."!value".substring(3,6).equals("AMP")?"":getCharge(4)?getCharge(4).toBigDecimal()*100:0}', 24),
    189. 

  189.         ('req-core.sms.0200.570000.001', 1, 'TLBF12', '${head.source."!value".substring(4,7) == "318" ? tar.fee_ibb : msg.reservedPrivate2."!value".substring(3,6).equals("ALT")? "0":msg.reservedPrivate2."!value".substring(3,6).equals("AMP")? (msg.issuerTraceId."!value"=="LMP" ? "0" : getCharge(2).toBigDecimal()*100): "0"}', 24),
    190. 

  190.         ('req-core.sms.0200.570000.001', 1, 'TLBF16', '${msg.reservedPrivate2."!value".substring(3,6).equals("ALT") || msg.reservedPrivate2."!value".substring(3,6).equals("BCA")?(msg.amountTransaction."!number"):msg.reservedPrivate2."!value".substring(3,6).equals("AMP")? head.source."!value".substring(4,7) == "318" ? msg.amountTransaction."!value".toBigDecimal()+tar.TLBF12."!value".toBigDecimal():(msg.amountTransaction."!number")+(getCharge(5)?getCharge(5).toBigDecimal()*100:0):getCharge(5)?getCharge(5).toBigDecimal()*100:0}', 24),
    191. 

  191.         ('req-core.sms.0200.570000.001', 1, 'TLBF07', '${msg.reservedPrivate2."!value".substring(3,6).equals("ALT")?getAccount(4):msg.reservedPrivate2."!value".substring(3,6).equals("AMP")?"":getAccount(3)}', 25),
    192. 

  192.         ('req-core.sms.0200.570000.001', 1, 'TLBF08', '${msg.reservedPrivate2."!value".substring(3,6).equals("ALT")?(getCharge(4)?getCharge(4).toBigDecimal()*100:0):msg.reservedPrivate2."!value".substring(3,6).equals("AMP")?"":getCharge(3)?getCharge(3).toBigDecimal()*100:0}', 26),
    193. 

  193.         ('req-core.sms.0200.570000.001', 1, 'TLBF13', '${getAccount(4)}', 28),
    194. 

  194.         ('req-core.sms.0200.570000.001', 1, 'TLBF14', '${getCharge(4)?getCharge(4).toBigDecimal()*100:0}', 28),
    195. 

  195.         ('req-core.sms.0200.570000.001', 1, 'TLBF15', '${getAccount(5)}', 28),
    196. 

  196.         ('req-core.sms.0200.570000.001', 1, 'TLBCUR', 'IDR', 30),
    197. 

  197.         ('req-core.sms.0200.570000.001', 1, 'TLBF17', '${msg.reservedPrivate2."!value".substring(3,6).equals("AMP")?tar.total_fee:getCharge(5)?getCharge(5).toBigDecimal()*100:0}', 30),
    198. 

  198.         ('req-core.sms.0200.570000.001', 1, 'TLBCIF', '${msg.timeLocalTransaction}', 31),
    199. 

  199.         ('req-core.sms.0200.570000.001', 1, 'RMCKC', '${msg.transmissionDateTime}', 34),
    200. 

  200.         ('req-core.sms.0200.570000.001', 1, 'RMAPID', '${msg.retrievalReferenceNumber}${(new java.text.SimpleDateFormat("yyMMddHHmmss")).format(new Date())}', 35),
    201. 

  201.         ('req-core.sms.0200.570000.001', 1, 'RMADD3', '${head.source."!value".substring(4,7) == "208"||head.source."!value".substring(4,7) == "318"?(msg.reservedIso2==null?"00000000000":msg.reservedIso2."!value").padRight(16," "):head.source."!value".substring(4,8).equals("5080")?msg.fromAccount."!value"+" ".padRight(1," ")+msg.toAccount."!value":msg.track2Data}', 36),
    202. 

  202.         ('req-core.sms.0200.570000.001', 1, 'RMSEHS', '${msg.dateLocalTransaction}', 37),
    203. 

  203.         ('req-core.sms.0200.570000.001', 1, 'RMPSTC', '${(new java.text.SimpleDateFormat("yyyyMMdd")).format(new Date())}', 41),
    204. 

  204.         ('req-core.sms.0200.570000.001', 1, 'TLBFIL', '${tar.dspUserId}:${msg.receivingInstitutionIdentificationCode."!value".trim()}${msg.toAccount}:${msg.retrievalReferenceNumber}', 52),
    205. 

  205.         ('req-core.sms.0200.570000.001', 1, 'RMADD2', 'KE ${msg.additionalDataPrivate?."!value".padRight(76," ").substring(0,15).trim()} ${msg.toAccount?."!value"!=null?msg.toAccount."!value".padLeft(19,"0").substring(3,19):""}', null),
    206. 

  206.         ('req-core.sms.0200.570000.001', 1, 'RMNAME', 'DR ${msg.additionalDataPrivate?."!value".padRight(76," ").substring(46,61).trim()} ${msg.fromAccount?."!value"!=null?msg.fromAccount."!value".padLeft(19,"0").substring(3,19):""}', null),
    207. 

  207.         ('req-core.sms.0200.570000.001', 1, 'RMPYNM', '${msg.cardAcceptorTerminalIdentification?."!value"!=null?msg.cardAcceptorTerminalIdentification."!value".padRight(8," ").substring(0,8):"".padRight(8," ")} ${msg.track2Data?."!value"!=null?msg.track2Data."!value".padRight(16," ").substring(0,16):"".padRight(16," ")} ${msg.retrievalReferenceNumber."!value".padRight(12,"0").substring(0,12)}', null),
    208. 

  208.         ('req-core.sms.0200.570000.001', 1, 'TLBDS1', '${head.source."!value".substring(4,8) == "5080" ? "API" : "MOB" } ${msg.cardAcceptorTerminalIdentification}', null),
    209. 

  209.         ('req-core.sms.0200.570000.001', 1, 'TLBDS2', 'REF ${msg.retrievalReferenceNumber."!value".padRight(12," ").substring(0,12)}', null),
    210. 

  210.         ('req-core.sms.0200.570000.001', 1, 'TLXUFD', '${head.source."!value".substring(4,8) == "2080" ? "NEWMB" : head.source."!value".substring(4,8) == "3180" ? "IBB" : head.source."!value".substring(4,8) == "5080" ? "OPENAPI" : "TRFATM" }', null);
    211. 

  211. 

  212. INSERT INTO MWCONFIG.PARAM_MAP (GROUP, NAME, VALUE, TIMESTAMP, MODIFIED_BY)
    213. 

  213. 	VALUES 
    214. 

  214.         ('sms-ibft-konven-code', 'ALT-10', '6394', CURRENT TIMESTAMP, CURRENT USER),
    215. 

  215.         ('sms-ibft-konven-code', 'ALT-20', '6395', CURRENT TIMESTAMP, CURRENT USER),
    216. 

  216.         ('sms-ibft-konven-code', 'AMP-10', '7140', CURRENT TIMESTAMP, CURRENT USER),
    217. 

  217.         ('sms-ibft-konven-code', 'AMP-20', '7141', CURRENT TIMESTAMP, CURRENT USER),
    218. 

  218.         ('sms-ibft-konven-code', 'BCA-10', '6390', CURRENT TIMESTAMP, CURRENT USER),
    219. 

  219.         ('sms-ibft-konven-code', 'BCA-20', '6391', CURRENT TIMESTAMP, CURRENT USER),
    220. 

  220.         ('sms-ibft-konven-code', 'HBR-10', '6392', CURRENT TIMESTAMP, CURRENT USER),
    221. 

  221.         ('sms-ibft-konven-code', 'HBR-20', '6393', CURRENT TIMESTAMP, CURRENT USER),
    222. 

  222.         ('sms-ibft-konven-code', 'SAT-10', '6388', CURRENT TIMESTAMP, CURRENT USER),
    223. 

  223.         ('sms-ibft-konven-code', 'SAT-20', '6389', CURRENT TIMESTAMP, CURRENT USER);
    224. 

  224. 

  225. INSERT INTO MWCONFIG.PARAM_MAP (GROUP, NAME, VALUE, DESCRIPTION, SEQ, MODIFIED_BY, TIMESTAMP)
    226. 

  226.     VALUES
    227. 

  227.         ('core-response-ok', 'AXISSYSTEMSDNBHD.0000007140', '89 F1', NULL, NULL, CURRENT USER, CURRENT TIMESTAMP);
    228. 

  228. 

  229. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('sms.0200.570000', '[sms]', CURRENT USER, CURRENT TIMESTAMP);
    230. 

  230. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    231. 

  231.     VALUES 
    232. 

  232.             ('sms.0200.570000', 1, '/data', '/data', NULL, NULL),
    233. 

  233.             ('sms.0200.570000', 2, '/data/body', '/data/body', NULL, NULL);
    234. 

  234. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    235. 

  235.     VALUES 
    236. 

  236.         ('sms.0200.570000', 1, '@', 'copyMessage()', 1),
    237. 

  237.         ('sms.0200.570000', 2, '@', 'copyMessage("frontOriginal", ".");', 1),
    238. 

  238.         ('sms.0200.570000', 1, 'type', 'iso-8583-itmibft', 2),
    239. 

  239.         ('sms.0200.570000', 2, 'messageType', '0200', 2),
    240. 

  240.         ('sms.0200.570000', 2, 'systemsTraceAuditNumber', '${msg.systemsTraceAuditNumber} ', 3),
    241. 

  241.         ('sms.0200.570000', 2, 'processingCode', '${msg.reservedPrivate2."!value".substring(3,6).equals("AMP")?"65":msg.reservedPrivate2."!value".substring(3,6).equals("BCA")?"66":msg.reservedPrivate2."!value".substring(3,6).equals("HBR")?"67":msg.reservedPrivate2."!value".substring(3,6).equals("SAT")?"68":msg.reservedPrivate2."!value".substring(3,6).equals("ALT")?"69":"99"}${msg.processingCode."!value".substring(2,6)}', 4),
    242. 

  242.         ('sms.0200.570000', 2, 'transmissionDateTime', '${getTimeZoneFormat("MMddHHmmss","GMT")}', 5),
    243. 

  243.         ('sms.0200.570000', 2, 'merchantType', '6017', 6),
    244. 

  244.         ('sms.0200.570000', 2, 'reservedForPrivateUse', '${msg.receivingInstitutionIdentificationCode}', 7),
    245. 

  245.         ('sms.0200.570000', 2, 'amountTransactionFee', '${null}', 8),
    246. 

  246.         ('sms.0200.570000', 2, 'amountTransactionProcessingFee', '${null}', 8),
    247. 

  247.         ('sms.0200.570000', 2, 'reservedPrivate2', '001${msg.reservedPrivate2."!value".substring(0,6).equals("001AMP")?"001MRP":msg.reservedPrivate2."!value".substring(0,6)}000', 8),
    248. 

  248.         ('sms.0200.570000', 2, '!sid', '${head.sid}', 9),
    249. 

  249.         ('sms.0200.570000', 2, '!flowType', 'P', 10),
    250. 

  250.         ('sms.0200.570000', 2, '!destination', 'itm-conn', 11),
    251. 

  251.         ('sms.0200.570000', 2, 'dateLocalTransaction', '${new java.text.SimpleDateFormat("MMdd").format(new Date())}', 11),
    252. 

  252.         ('sms.0200.570000', 2, 'timeLocalTransaction', '${new java.text.SimpleDateFormat("HHmmss").format(new Date())}', 12),
    253. 

  253.         ('sms.0200.570000', 2, 'reservedForIsoUse1', '${null}', 14),
    254. 

  254.         ('sms.0200.570000', 2, 'reservedForIsoUse2', '${null}', 14),
    255. 

  255.         ('sms.0200.570000', 2, 'reservedForIsoUse3', '${null}', 14),
    256. 

  256.         ('sms.0200.570000', 2, '!mid', '${tar.transmissionDateTime."!value"+"."+tar.systemsTraceAuditNumber."!value"}', 99);
    257. 

  257. 

  258. 

  259. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('sms.0200.570000.itm-conn.0210.650000', '[sms]', CURRENT USER, CURRENT TIMESTAMP);
    260. 

  260. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('sms.0200.570000.itm-conn.0210.650000', 1, '/data/request/data/body/frontOriginal', '/data', NULL, NULL);
    261. 

  261. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('sms.0200.570000.itm-conn.0210.650000', 2, '/data/body', '/data/body', NULL, NULL);
    262. 

  262. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('sms.0200.570000.itm-conn.0210.650000', 1, '@', 'copyMessage()', 1);
    263. 

  263. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('sms.0200.570000.itm-conn.0210.650000', 2, 'messageType', '0210', 2);
    264. 

  264. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('sms.0200.570000.itm-conn.0210.650000', 2, 'additionalDataPrivate', '${msg.responseCode."!value".equals("00")?msg.additionalDataPrivate :tar.additionalDataPrivate}${head.request.data.source."!value".substring(4,8) != "1080" ? msg.responseCode."!value"!="00"?"000000000000":(msg.issuerTraceId."!value".equals("XMP")?"000000650000":msg.issuerTraceId."!value".equals("LMP")?"000000650000":"000000650000") : ""}', 3);
    265. 

  265. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('sms.0200.570000.itm-conn.0210.650000', 2, 'responseCode', '${getParamValue("error_map|ibft-"+head.request.data.body.frontOriginal.body.reservedPrivate2."!value".substring(3,6).toUpperCase(), msg.responseCode."!value",msg.responseCode."!value")}', 4);
    266.