Domů Procházet Nápověda
Přihlásit se
wisnu
/
btnmw-server-local
1
0
Rozštěpit 1
Soubory Úkoly 0 Pull Requesty 1 Wiki
Strom: 8062162f93
Větve Značky
btnmw-server-lo...
/
mwconfig
/
migration
/
MWCONFIG_INITDB_ITM_04_core.itm.0200.230000.002NMB.sql

MWCONFIG_INITDB_ITM_04_core.itm.0200.230000.002NMB.sql 10 KB
Historie Surový

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798 
  1. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm.0200.230000.002NMB', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
    2. 

  2. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    3. 

  3.   VALUES 
    4. 

  4.     ('req-core.itm.0200.230000.002NMB', 1, '/data/body', '/data/body', NULL, NULL), 
    5. 

  5.     ('req-core.itm.0200.230000.002NMB', 2, '/data/body', '/data/body', NULL, NULL);
    6. 

  6. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    7. 

  7.   VALUES 
    8. 

  8.     ('req-core.itm.0200.230000.002NMB', 1, '!connid', '${head.connid}', NULL), 
    9. 

  9.     ('req-core.itm.0200.230000.002NMB', 1, '!destination', 'ist-conn', NULL), 
    10. 

  10.     ('req-core.itm.0200.230000.002NMB', 1, '!group', '${head.group}', NULL), 
    11. 

  11.     ('req-core.itm.0200.230000.002NMB', 1, '!mappingCode', '${head.code}', NULL), 
    12. 

  12.     ('req-core.itm.0200.230000.002NMB', 1, '!mid', '${head.mid}', NULL), 
    13. 

  13.     ('req-core.itm.0200.230000.002NMB', 1, '!queueName', 'BACKEND_ISO_IN', NULL), 
    14. 

  14.     ('req-core.itm.0200.230000.002NMB', 1, '!reqtimestamp', '${head.reqtimestamp}', NULL), 
    15. 

  15.     ('req-core.itm.0200.230000.002NMB', 1, '!ReplyToQ', 'ITM_CORE_REPLY', NULL), 
    16. 

  16.     ('req-core.itm.0200.230000.002NMB', 1, '!ReplyToQMgr', 'ISOBROKER.QM', NULL), 
    17. 

  17.     ('req-core.itm.0200.230000.002NMB', 1, '!sid', '${null}', NULL), 
    18. 

  18.     ('req-core.itm.0200.230000.002NMB', 1, '!source', '${head.source}', NULL), 
    19. 

  19.     ('req-core.itm.0200.230000.002NMB', 1, '!timestamp', '${head.reqtimestamp}', NULL), 
    20. 

  20.     ('req-core.itm.0200.230000.002NMB', 1, '@', 'copyMessageToChild("original");copyMessage();', NULL), 
    21. 

  21.     ('req-core.itm.0200.230000.002NMB', 2, 'additionalDataPrivate', '${msg.additionalDataPrivate."!value".substring(0,16)}', NULL), 
    22. 

  22.     ('req-core.itm.0200.230000.002NMB', 2, 'isMultipleRequest', 'true', NULL), 
    23. 

  23.     ('req-core.itm.0200.230000.002NMB', 2, 'mappingCodeMultiple', 'konven', NULL), 
    24. 

  24.     ('req-core.itm.0200.230000.002NMB', 2, 'processingCode', '940000', NULL), 
    25. 

  25.     ('req-core.itm.0200.230000.002NMB', 2, 'reservedPrivate3', '${msg.additionalDataPrivate."!value".substring(16,80)}', NULL);
    26. 

  26. 

  27. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm.0200.230000.002NMB.konven', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
    28. 

  28. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('req-core.itm.0200.230000.002NMB.konven', 1, '/data/body', '/data/body', 'req-core.itm.multiple-master.konven', 1);
    29. 

  29. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    30. 

  30.   VALUES 
    31. 

  31.     ('req-core.itm.0200.230000.002NMB.konven', 1, '@', 'dtree("CHARGES","!group");', 10), 
    32. 

  32.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'ACCTYPE', '${getParamValueWithError("account-type", msg.fromAccount."!value".padLeft(20, "0").substring(11, 13), "error:01Unknown account type " +msg.fromAccount."!value".padLeft(20, "0").substring(11, 13))}', 10), 
    33. 

  33.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'dspTransactionCode', '${tar.ACCTYPE?(tar.ACCTYPE."!value".equals("S")?"5195":(tar.ACCTYPE."!value".equals("D")?"5196":null)):null}', 20), 
    34. 

  34.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBF02', '${decimalFormat("0",(msg.amountTransaction."!value".toBigDecimal()+(getCharge(1).toBigDecimal()+getCharge(2).toBigDecimal())*100))}', 20), 
    35. 

  35.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBF03', '${getAccount(2)}', 20), 
    36. 

  36.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBF04', '${decimalFormat("0",(getCharge(2).toBigDecimal())*100)}', 20), 
    37. 

  37.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBF09', '${getAccount(1)}', 20), 
    38. 

  38.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBF10', '${decimalFormat("0",(getCharge(1).toBigDecimal())*100)}', 20), 
    39. 

  39.     ('req-core.itm.0200.230000.002NMB.konven', 1, '!code', 'AXISSYSTEMSDNBHD.000000${tar.dspTransactionCode}', NULL), 
    40. 

  40.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'amountTransaction', '${null}', NULL), 
    41. 

  41.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'fromAccount', '${null}', NULL), 
    42. 

  42.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'networkManagementInformation', '${null}', NULL), 
    43. 

  43.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'primaryAccountNumber', '${null}', NULL), 
    44. 

  44.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'reservedForPrivateUse', '${null}', NULL), 
    45. 

  45.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'RMCNT', '${head.request.data.body.original.additionalDataPrivate."!value".substring(43,63)}', NULL), 
    46. 

  46.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'RMSEHS', '${msg.dateLocalTransaction}', NULL), 
    47. 

  47.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBDS1', '${msg.merchantType}:      :${msg.additionalDataPrivate."!value".substring(0,16)}:${msg.retrievalReferenceNumber}', NULL), 
    48. 

  48.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBDS2', '${"      "}:${msg.additionalDataPrivate."!value".substring(0,16)}', NULL), 
    49. 

  49.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBF01', '${msg.fromAccount."!value".substring(0,16)}', NULL), 
    50. 

  50.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBF15', '${getParamValueWithError("coa", "gl-withdrawal-acquire-"+msg.serviceIndicator."!value".substring(0, 3), "error:92Unknown coa")}', NULL), 
    51. 

  51.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBF16', '${msg.amountTransaction}', NULL), 
    52. 

  52.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBTCD', '${tar.dspTransactionCode}', NULL), 
    53. 

  53.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLBTPN', '${msg.cardAcceptorTerminalIdentification."!value".padRight(16," ")}:${msg.additionalDataPrivate."!value".substring(0,16)}:${msg.retrievalReferenceNumber."!value".padRight(12," ")}', NULL), 
    54. 

  54.     ('req-core.itm.0200.230000.002NMB.konven', 1, 'TLXUFD', 'ATMCWDW', NULL);
    55. 

  55. 

  56. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm.0200.230000.002NMB.res-reverse', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
    57. 

  57. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('req-core.itm.0200.230000.002NMB.res-reverse', 1, '/data/body', '/data/body', 'req-core.itm.res-reverse-master', 1);
    58. 

  58. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    59. 

  59.   VALUES 
    60. 

  60.     ('req-core.itm.0200.230000.002NMB.res-reverse', 1, 'additionalDataPrivate', '${head.request.data.original1.body.additionalDataPrivate}', NULL), 
    61. 

  61.     ('req-core.itm.0200.230000.002NMB.res-reverse', 1, 'cardAcceptorIdentificationCode', '${null}', NULL), 
    62. 

  62.     ('req-core.itm.0200.230000.002NMB.res-reverse', 1, 'messageType', '400', NULL), 
    63. 

  63.     ('req-core.itm.0200.230000.002NMB.res-reverse', 1, 'originalDataElements', '${head.request.data.original1.request.data.body.messageType."!value".trim()}${head.request.data.original1.request.data.body.retrievalReferenceNumber."!value".trim().padRight(12," ")}${head.request.data.original1.request.data.body.dateLocalTransaction."!value".trim()}${head.request.data.original1.request.data.body.timeLocalTransaction."!value".trim()}${head.request.data.original1.request.data.body.systemsTraceAuditNumber."!value".trim()}${"          "}', NULL), 
    64. 

  64.     ('req-core.itm.0200.230000.002NMB.res-reverse', 1, 'processingCode', '940000', NULL), 
    65. 

  65.     ('req-core.itm.0200.230000.002NMB.res-reverse', 1, 'reasonCode', '${null}', NULL), 
    66. 

  66.     ('req-core.itm.0200.230000.002NMB.res-reverse', 1, 'serviceIndicator', '${null}', NULL);
    67. 

  67. 

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

  69. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('res-core.itm.0200.230000.002NMB', 1, '/data/body', '/data/body', 'res-core.itm.0200', 1);
    70. 

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

  71.   VALUES 
    72. 

  72.     ('res-core.itm.0200.230000.002NMB', 1, 'additionalDataPrivate', '${msg.SNAME_F1."!value".substring(0,20)}${head.request.data.original1.body.additionalDataPrivate}${head.request.data.original1.body.reservedPrivate3}', NULL), 
    73. 

  73.     ('res-core.itm.0200.230000.002NMB', 1, 'amountTransaction', '${head.request.data.original1.body.amountTransaction."!value".padLeft(12,"0")}', NULL), 
    74. 

  74.     ('res-core.itm.0200.230000.002NMB', 1, 'amountTransactionFee', '${decimalFormat("0",(head.request.data.body.TLBF04."!value".toBigDecimal()+head.request.data.body.TLBF10."!value".toBigDecimal()))}', NULL), 
    75. 

  75.     ('res-core.itm.0200.230000.002NMB', 1, 'fromAccount', '${head.request.data.original1.body.fromAccount."!value".padLeft(16,"0")}', NULL);
    76. 

  76. 

  77. INSERT INTO MWCONFIG.DTREE (GROUP, PATH, VALUE, MODIFIED_BY, TIMESTAMP, MODULE) 
    78. 

  78.    VALUES 
    79. 

  79.       ('CHARGES', 'itm|940000', 'cardless-btn', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    80. 

  80.       ('CHARGES', 'itm|941000', 'cardless-btn', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    81. 

  81.       ('CHARGES', 'itm|942000', 'cardless-btn', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    82. 

  82.       ('CHARGES', 'itm|950000', 'cardless-cash-deposit', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    83. 

  83.       ('CHARGES', 'itm|951000', 'cardless-cash-deposit', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    84. 

  84.       ('CHARGES', 'itm|952000', 'cardless-cash-deposit', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    85. 

  85.       ('CHARGES', 'cardless-btn', '---', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    86. 

  86.       ('CHARGES', 'cardless-cash-deposit', '---', CURRENT USER, CURRENT TIMESTAMP, '[itm]');
    87. 

  87. 

  88. 

  89. 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, C6_VALUE, C6_NAME, C6_SCRIPT, C6_ACCOUNT) 
    90. 

  90.     VALUES 
    91. 

  91.       ('cardless-btn', 0.00, 'Pendapatan BTN', null, '467811491418', 0.00, 'Biaya Admin', null, '467811491418', 0.00, null, null, null, 0.00, null, null, null, 0.00, null, null, null, CURRENT USER, CURRENT TIMESTAMP, null, null, null, null),
    92. 

  92.       ('cardless-cash-deposit', 0.00, 'Pendapatan BTN', null, '467811491418', 0.00, 'Biaya Admin', null, '467811491418', 0.00, null, null, null, 0.00, null, null, null, 0.00, null, null, null, CURRENT USER, CURRENT TIMESTAMP, null, null, null, null);
    93. 

  93. 

  94. INSERT INTO MWCONFIG.PARAM_MAP (GROUP, NAME, VALUE, SEQ, MODIFIED_BY, TIMESTAMP, DESCRIPTION) 
    95. 

  95.   VALUES 
    96. 

  96.     ('coa', 'gl-withdrawal-acquire-BTN', '111330000000', null, CURRENT USER, CURRENT TIMESTAMP, 'GL Cash ATM BTN'), 
    97. 

  97.     ('coa', 'gl-withdrawal-acquire-VND', '111340000061', null, CURRENT USER, CURRENT TIMESTAMP, 'GL Cash ATM Vendor'), 
    98. 

  98.     ('coa', 'gl-withdrawal-acquire-BCR', '111360000000', null, CURRENT USER, CURRENT TIMESTAMP, null);
    99.