Sākums Izpētīt Palīdzība
Pierakstīties
fiqri
/
btn-mdw-ace-server-local
1
0
Atdalīts 0
Faili Problēmas 0 Izmaiņu pieprasījumi 0 Vikivietne
Atzars: master
Atzari Tagi
btn-mdw-ace-ser...
/
mwconfig
/
migration
/
MWCONFIG_INITDB_REGISTRASI_SHAD.sql

MWCONFIG_INITDB_REGISTRASI_SHAD.sql 9.7 KB
Patstāvīgā saite Vēsture Neapstrādāts

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103 
  1. INSERT INTO MWCONFIG.DTREE(GROUP, PATH, VALUE, MODIFIED_BY, TIMESTAMP, MODULE) 
    2. 

  2.     VALUES 
    3. 

  3.         ('ITM-CODE', '0200.881000', '0200.881000.${msg.reservedPrivate2.substring(0, 9)}', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    4. 

  4.         ('ITM-CODE', '0210.881000', '0210.881000.${msg.reservedPrivate2.substring(0, 9)}', CURRENT USER, CURRENT TIMESTAMP, '[itm]');
    5. 

  5. 

  6. INSERT INTO MWCONFIG.PARAM_MAP(GROUP, NAME, "VALUE", SEQ, MODIFIED_BY, TIMESTAMP, DESCRIPTION) 
    7. 

  7. VALUES 
    8. 

  8.     ('itm-api-core', 'inqRegisMBSyariah', 'http://DUMMY:7080/mid/inqregnmb', null, CURRENT USER, CURRENT TIMESTAMP, null),
    9. 

  9.     ('coa', 'prima-liability', '211976400000', null, CURRENT USER, CURRENT TIMESTAMP, 'gl kewajiban');
    10. 

  10. 

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

  12. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    13. 

  13.     VALUES ('req-core.itm.0200.881000.002001000', 1, '/data/body', '/data/body', 'dsp', '1');
    14. 

  14. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    15. 

  15.     VALUES 
    16. 

  16.         ('req-core.itm.0200.881000.002001000', 1, '@', 'copyMessageToChild("original");', 5),
    17. 

  17.         ('req-core.itm.0200.881000.002001000', 1, '!ReplyToQ', 'ITM_CORE_REPLY', 10),
    18. 

  18.         ('req-core.itm.0200.881000.002001000', 1, '!ReplyToQMgr', 'PAYBROKER.QM', 10),
    19. 

  19.         ('req-core.itm.0200.881000.002001000', 1, '!RequestURL', '${getParamValue("itm-api-core","inqRegisMBSyariah","http://localhost:8094")}', 10),
    20. 

  20.         ('req-core.itm.0200.881000.002001000', 1, '!destination', 'api-bis-conn', 10),
    21. 

  21.         ('req-core.itm.0200.881000.002001000', 1, '!dir', 'O', 10),
    22. 

  22.         ('req-core.itm.0200.881000.002001000', 1, '!key', 'fcd5b3601f3bc0b9e6f80f21ebb76eb8', 10),
    23. 

  23.         ('req-core.itm.0200.881000.002001000', 1, '!mappingCode', '${head.code}', 10),
    24. 

  24.         ('req-core.itm.0200.881000.002001000', 1, '!errorCodePath', 'msg.rsp', 10),
    25. 

  25.         ('req-core.itm.0200.881000.002001000', 1, '!queueName', 'BACKEND_REST_IN', 10),
    26. 

  26.         ('req-core.itm.0200.881000.002001000', 1, 'account', '${msg.fromAccount."!value".replaceFirst(/^0+/, "")}', 20),
    27. 

  27.         ('req-core.itm.0200.881000.002001000', 1, 'card', '${msg.primaryAccountNumber."!value".trim()}', 20),
    28. 

  28.         ('req-core.itm.0200.881000.002001000', 1, 'dob', '${msg.additionalDataPrivate."!value".substring(23,29).trim()}', 20),
    29. 

  29.         ('req-core.itm.0200.881000.002001000', 1, 'hp', '${msg.additionalDataPrivate."!value".substring(0,16).trim()}', 20),
    30. 

  30.         ('req-core.itm.0200.881000.002001000', 1, 'ref', '${msg.retrievalReferenceNumber."!value".padRight(12," ").trim()}', 20),
    31. 

  31.         ('req-core.itm.0200.881000.002001000', 1, 'user', '${msg.cardAcceptorTerminalIdentification."!value".trim()}', 20),
    32. 

  32.         ('req-core.itm.0200.881000.002001000', 1, 'isMultipleRequest', 'true', 30),
    33. 

  33.         ('req-core.itm.0200.881000.002001000', 1, 'mappingCodeMultiple', 'istconn', 30);
    34. 

  34.     
    35. 

  35. INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm.0200.881000.002001000.istconn', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
    36. 

  36. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    37. 

  37.     VALUES ('req-core.itm.0200.881000.002001000.istconn', 1, '/data/body', '/data/body', NULL, NULL);
    38. 

  38. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    39. 

  39.     VALUES 
    40. 

  40.         ('req-core.itm.0200.881000.002001000.istconn', 1, '@', 'copyMessage(".", "request/data/body/original");copyMessage("../respapi", ".");copyMessage("original", "request/data/body/original");', 10),
    41. 

  41.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!CorrelId', '${head.request.data.CorrelId}', null),
    42. 

  42.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!ReplyToQ', 'ITM_CORE_REPLY', null),
    43. 

  43.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!ReplyToQMgr', 'ISOBROKER.QM', null),
    44. 

  44.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!code', '${head.request.data.code}', null),
    45. 

  45.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!connid', '${head.request.data.connid}', null),
    46. 

  46.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!destination', 'ist-conn', null),
    47. 

  47.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!dir', 'O', null),
    48. 

  48.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!group', '${head.request.data.group}', null),
    49. 

  49.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!mappingCode', '${head.request.data.mappingCode}', null),
    50. 

  50.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!mid', '${head.request.data.mid}', null),
    51. 

  51.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!queueName', 'BACKEND_ISO_IN', null),
    52. 

  52.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!reqtimestamp', '${head.request.data.reqtimestamp}', null),
    53. 

  53.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!sid', '${null}', null),
    54. 

  54.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!source', '${head.request.data.source}', null),
    55. 

  55.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!timestamp', '${head.request.data.reqtimestamp}', null),
    56. 

  56.         ('req-core.itm.0200.881000.002001000.istconn', 1, '!type', 'iso-8583-cws', null),
    57. 

  57.         ('req-core.itm.0200.881000.002001000.istconn', 1, 'additionalDataPrivate', '${msg.hp?."!value"!=null?msg.hp."!value".padLeft(16," "):" ".padLeft(16," ")}${msg.cif?."!value"!=null?msg.cif."!value".padRight(7," "):" ".padRight(7," ")}${msg.dob?."!value"!=null?msg.dob."!value".padRight(6," "):" ".padRight(6," ")}${" ".padRight(20," ")}', null),
    58. 

  58.         ('req-core.itm.0200.881000.002001000.istconn', 1, 'fromAccount', 'NULL', null),
    59. 

  59.         ('req-core.itm.0200.881000.002001000.istconn', 1, 'isMultipleRequest', 'NULL', null),
    60. 

  60.         ('req-core.itm.0200.881000.002001000.istconn', 1, 'processingCode', '${head.request.data.body.original.processingCode."!value".trim()=="881000"?"022000":"021000"}', null),
    61. 

  61.         ('req-core.itm.0200.881000.002001000.istconn', 1, 'reservedPrivate3', 'NULL', null);
    62. 

  62. 

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

  64. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    65. 

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

  66. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    67. 

  67.     VALUES ('res-core.itm.0200.881000.002001000', 1, 'additionalDataPrivate', '${msg.additionalDataPrivate."!value"}', 20);
    68. 

  68. 

  69. INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP)
    70. 

  70. VALUES 
    71. 

  71.     ('api-bis-conn', '000', '00', 'Transaction Success', CURRENT USER, CURRENT TIMESTAMP),
    72. 

  72.     ('api-bis-conn', '001', '01', 'Account Not Found', CURRENT USER, CURRENT TIMESTAMP),
    73. 

  73.     ('api-bis-conn', '097', '70', 'Duplicate Reff', CURRENT USER, CURRENT TIMESTAMP),
    74. 

  74.     ('api-bis-conn', '098', 'RA', 'Is Switch A Day Mode Or Night Mode', CURRENT USER, CURRENT TIMESTAMP),
    75. 

  75.     ('api-bis-conn', '099', 'H1', 'Not Authorize', CURRENT USER, CURRENT TIMESTAMP),
    76. 

  76.     ('api-bis-conn', '701', '26', 'Invalid Institution Code', CURRENT USER, CURRENT TIMESTAMP),
    77. 

  77.     ('api-bis-conn', '702', 'RB', 'Invalid Length Bin', CURRENT USER, CURRENT TIMESTAMP),
    78. 

  78.     ('api-bis-conn', '703', 'RC', 'BIN Must Be Fill', CURRENT USER, CURRENT TIMESTAMP),
    79. 

  79.     ('api-bis-conn', '704', 'RD', 'Payment Code Descriptioapi-bis-connn Must Be Filled', CURRENT USER, CURRENT TIMESTAMP),
    80. 

  80.     ('api-bis-conn', '705', 'RE', 'Payment Code Must Be Filled', CURRENT USER, CURRENT TIMESTAMP),
    81. 

  81.     ('api-bis-conn', '706', 'RF', 'Length Virtual Account Invalid', CURRENT USER, CURRENT TIMESTAMP),
    82. 

  82.     ('api-bis-conn', '707', 'RG', 'Length Customer Id Invalid', CURRENT USER, CURRENT TIMESTAMP),
    83. 

  83.     ('api-bis-conn', '721', 'PU', 'Prefix Belum Terdaftar', CURRENT USER, CURRENT TIMESTAMP),
    84. 

  84.     ('api-bis-conn', '722', 'RH', 'Wrong Merchant Id', CURRENT USER, CURRENT TIMESTAMP),
    85. 

  85.     ('api-bis-conn', '723', 'RO', 'Jenis Rekening Salah', CURRENT USER, CURRENT TIMESTAMP),
    86. 

  86.     ('api-bis-conn', '724', 'RJ', 'Branch Invalid', CURRENT USER, CURRENT TIMESTAMP),
    87. 

  87.     ('api-bis-conn', '801', 'RK', 'Invalid Date', CURRENT USER, CURRENT TIMESTAMP),
    88. 

  88.     ('api-bis-conn', '802', 'PG', 'Data Cannot Be Empty / Wrong Format', CURRENT USER, CURRENT TIMESTAMP),
    89. 

  89.     ('api-bis-conn', '901', 'HP', 'Mobile Phone Not Authorize.', CURRENT USER, CURRENT TIMESTAMP),
    90. 

  90.     ('api-bis-conn', '902', 'RL', 'Card Number Not Authorize.', CURRENT USER, CURRENT TIMESTAMP),
    91. 

  91.     ('api-bis-conn', '903', 'RM', 'Phone Number And Card Number Is Not', CURRENT USER, CURRENT TIMESTAMP),
    92. 

  92.     ('api-bis-conn', '904', 'B2', 'Invalid Cif Number.', CURRENT USER, CURRENT TIMESTAMP),
    93. 

  93.     ('api-bis-conn', '905', 'RN', 'Nik Not Found', CURRENT USER, CURRENT TIMESTAMP),
    94. 

  94.     ('api-bis-conn', '906', 'RU', 'Data Already Exist', CURRENT USER, CURRENT TIMESTAMP),
    95. 

  95.     ('api-bis-conn', '907', 'RP', 'Data Not Found', CURRENT USER, CURRENT TIMESTAMP),
    96. 

  96.     ('api-bis-conn', '908', 'RQ', 'Email Not Valid', CURRENT USER, CURRENT TIMESTAMP),
    97. 

  97.     ('api-bis-conn', '941', 'RR', 'Error Because Any Host Message', CURRENT USER, CURRENT TIMESTAMP),
    98. 

  98.     ('api-bis-conn', '942', 'RS', 'Error Because Any Host Message', CURRENT USER, CURRENT TIMESTAMP),
    99. 

  99.     ('api-bis-conn', '994', 'RT', 'Error Because Any Host Message', CURRENT USER, CURRENT TIMESTAMP),
    100. 

  100.     ('api-bis-conn', '971', '14', 'Invalid Transaction', CURRENT USER, CURRENT TIMESTAMP),
    101. 

  101.     ('api-bis-conn', '995', 'RP', 'Data Not Found (API)', CURRENT USER, CURRENT TIMESTAMP),
    102. 

  102.     ('api-bis-conn', '996', '14', 'Invalid Data Request (API)', CURRENT USER, CURRENT TIMESTAMP),
    103. 

  103.     ('api-bis-conn', '999', '99', 'General Error (Timeout)', CURRENT USER, CURRENT TIMESTAMP);
    104.