Domovská stránka Prehľadávať Pomoc
Prihlásiť sa
yusuf
/
btnmw-server-local
forknuté z wisnu/btnmw-server-local
1
0
Fork 0
Súbory
Strom: c0cc59dac6
Branche Tagy
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
História Raw

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.