Acasă Explorează Ajutor
Autentificare
yusuf
/
btnmw-server-local
a fost obținut din wisnu/btnmw-server-local
1
0
Bifurcare 0
Fisiere
Arbore: cde996e17b
Ramuri Etichete
btnmw-server-lo...
/
mwconfig
/
migration
/
MWCONFIG_INIT_PEMKO_4013.sql

MWCONFIG_INIT_PEMKO_4013.sql 16 KB
Istoric Crud

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166 
  1. INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, "TIMESTAMP") VALUES('mitracom-conn', 'connector/adaptor untuk SYB BILLER', 1, 'wpsadmindev', '2022-02-07 12:57:15.725000');
    2. 

  2. 

  3. INSERT INTO MWCONFIG.CODEX (ID, ALLOW_PARTIAL, "XML", MODIFIED_BY, "TIMESTAMP") VALUES('iso-8583-mitracom', NULL, '<codex id="iso-8583-mitracom" escape="true">
    4. 

  4. 	<field id="packetLength" type="groupLengthBinary" decimal-format="binary" length="2" />
    5. 

  5. 	<field id="messageType" type="string" length="4" padding-mode="right" padding-char=" " />
    6. 

  6. 	<field id="bitmap" type="bitmap">
    7. 

  7. 		<field id="primaryAccountNumber" bit="2" type="string" length="16" format="llvar" />
    8. 

  8. 		<field id="processingCode" bit="3" type="string" length="6" />
    9. 

  9. 		<field id="amountTransaction" bit="4" type="string" length="12" padding-mode="left" padding-char="0" />
    10. 

  10. 		<field id="amountSettlement" bit="5" type="string" length="18" padding-mode="left" padding-char="0" />
    11. 

  11. 		<field id="amountCardholderBilling" bit="6" type="string" length="18" padding-mode="left" padding-char="0" />
    12. 

  12. 		<field id="transmissionDateTime" bit="7" type="string" length="10" />
    13. 

  13. 		<field id="amountCardholderBillingFee" bit="8" type="string" length="8" padding-mode="left" padding-char="0" />
    14. 

  14. 		<field id="conversionRateSettlement" bit="9" type="string" length="8" padding-mode="left" padding-char="0" />
    15. 

  15. 		<field id="conversionRateCardholderBilling" bit="10" type="string" length="8" padding-mode="left" padding-char="0" />
    16. 

  16. 		<field id="systemsTraceAuditNumber" bit="11" type="string" length="6" />
    17. 

  17. 		<field id="timeLocalTransaction" bit="12" type="string" length="6" />
    18. 

  18. 		<field id="dateLocalTransaction" bit="13" type="string" length="4" />
    19. 

  19. 		<field id="dateExpiration" bit="14" type="string" length="8" />
    20. 

  20. 		<field id="dateSettlement" bit="15" type="string" length="4" />
    21. 

  21. 		<field id="dateConversion" bit="16" type="string" length="4" />
    22. 

  22. 		<field id="dateCapture" bit="17" type="string" length="4" />
    23. 

  23. 		<field id="merchantType" bit="18" type="string" length="4" padding-mode="left" padding-char="0" />
    24. 

  24. 		<field id="acquiringInstitutionCountryCode" bit="19" type="string" length="3" padding-mode="left" padding-char="0" />
    25. 

  25. 		<field id="panExtendedCountryCode" bit="20" type="string" length="3" padding-mode="left" padding-char="0" />
    26. 

  26. 		<field id="forwardingInstitutionCountryCode" bit="21" type="string" length="3" padding-mode="left" padding-char="0" />
    27. 

  27. 		<field id="pointOfServiceEntryMode" bit="22" type="string" length="3" padding-mode="left" padding-char="0" />
    28. 

  28. 		<field id="applicationPanNumber" bit="23" type="string" length="3" padding-mode="left" padding-char="0" />
    29. 

  29. 		<field id="networkInternationalIdentifier" bit="24" type="string" length="3" padding-mode="left" padding-char="0" />
    30. 

  30. 		<field id="pointOfServiceConditionCode" bit="25" type="string" length="2" padding-mode="left" padding-char="0" />
    31. 

  31. 		<field id="pointOfServiceCaptureCode" bit="26" type="string" length="2" padding-mode="left" padding-char="0" />
    32. 

  32. 		<field id="authorisingIdentificationResponseLength" bit="27" type="string" length="1" padding-mode="left" padding-char="0" />
    33. 

  33. 		<field id="amountTransactionFee" bit="28" type="string" length="9" padding-mode="left" padding-char="0" />
    34. 

  34. 		<field id="amountSettlementFee" bit="29" type="string" length="9" padding-mode="left" padding-char="0" />
    35. 

  35. 		<field id="amountTransactionProcessingFee" bit="30" type="string" length="9" padding-mode="left" padding-char="0" />
    36. 

  36. 		<field id="amountSettlementProcessingFee" bit="31" type="string" length="9" padding-mode="left" padding-char="0" />
    37. 

  37. 		<field id="acquiringInstitutionIdentificationCode" bit="32" type="string" length="99" format="llvar" />
    38. 

  38. 		<field id="forwardingInstitutionIdentificationCode" bit="33" type="string" length="11" format="llvar" />
    39. 

  39. 		<field id="primaryAccountNumberExtended" bit="34" type="string" length="28" format="llvar" />
    40. 

  40. 		<field id="track2Data" bit="35" type="string" length="37" format="llvar" />
    41. 

  41. 		<field id="track3Data" bit="36" type="string" length="104" format="lllvar" />
    42. 

  42. 		<field id="retrievalReferenceNumber" bit="37" type="string" length="12" />
    43. 

  43. 		<field id="authorisationIdentificationResponse" bit="38" type="string" length="6" />  
    44. 

  44. 		<field id="responseCode" bit="39" type="string" length="2" padding-mode="left" />
    45. 

  45. 		<field id="serviceRestrictionCode" bit="40" type="string" length="3" />
    46. 

  46. 		<field id="cardAcceptorTerminalIdentification" bit="41" type="string" length="16" />
    47. 

  47. 		<field id="cardAcceptorIdentificationCode" bit="42" type="string" length="15" />
    48. 

  48. 		<field id="cardAcceptorName" bit="43" type="string" length="40" />
    49. 

  49. 		<field id="additionalResponseData" bit="44" type="string" length="25" format="llvar" />
    50. 

  50. 		<field id="track1Data" bit="45" type="string" length="76" format="llvar" />
    51. 

  51. 		<field id="additionalDataIso" bit="46" type="string" length="999" format="lllvar" />
    52. 

  52. 		<field id="additionalDataNational" bit="47" type="string" length="20" format="lllvar" />
    53. 

  53. 		<field id="additionalDataPrivate" bit="48" type="string" length="999" format="lllvar" />
    54. 

  54. 		<field id="currencyCodeTransaction" bit="49" type="string" length="3" />
    55. 

  55. 		<field id="currencyCodeSettlement" bit="50" type="string" length="3" />
    56. 

  56. 		<field id="currencyCodeCardholderBilling" bit="51" type="string" length="3" />
    57. 

  57. 		<field id="personalIdentificationNumberData" bit="52" type="string" length="16" />
    58. 

  58. 		<field id="securityRelatedControlInformation" bit="53" type="string" length="18" padding-mode="left" padding-char="0" />
    59. 

  59. 		<field id="additionalAmounts" bit="54" type="string" length="999" format="lllvar" />
    60. 

  60. 		<field id="reservedIso1" bit="55" type="string" length="999" format="lllvar" />
    61. 

  61. 		<field id="reservedIso2" bit="56" type="string" length="999" format="lllvar" />
    62. 

  62. 		<field id="reservedNational1" bit="57" type="string" length="999" format="lllvar" />
    63. 

  63. 		<field id="reservedNational2" bit="58" type="string" length="999" format="lllvar" />
    64. 

  64. 		<field id="transactionType" bit="59" type="string" length="3" />
    65. 

  65. 		<field id="kodePemda" bit="60" type="string" length="3" padding-mode="left" padding-char="0" />
    66. 

  66. 		<field id="reservedPrivate1" bit="61" type="string" length="22" padding-mode="left" padding-char="0" />
    67. 

  67. 		<field id="reservedPrivate2" bit="62" type="string" length="278" padding-mode="left" padding-char="0" />
    68. 

  68. 		<field id="reservedPrivate3" bit="63" type="string" length="999" format="lllvar" />
    69. 

  69. 		<field id="messageAuthenticationCode" bit="64" type="string" length="16" />
    70. 

  70. 		<field id="bitMapTertiary" bit="65" type="string" length="16" />
    71. 

  71. 		<field id="settlementCode" bit="66" type="string" length="1" padding-mode="left" padding-char="0" />
    72. 

  72. 		<field id="extendedPaymentCode" bit="67" type="string" length="2" padding-mode="left" padding-char="0" />
    73. 

  73. 		<field id="receivingInstitutionCountryCode" bit="68" type="string" length="3" />
    74. 

  74. 		<field id="settlementInstitutionCountyCode" bit="69" type="string" length="3" />
    75. 

  75. 		<field id="networkManagementInformationCode" bit="70" type="string" length="3" />
    76. 

  76. 		<field id="messageNumber" bit="71" type="string" length="4" padding-mode="left" padding-char="0" />
    77. 

  77. 		<field id="messageNumberLast" bit="72" type="string" length="4" padding-mode="left" padding-char="0" />
    78. 

  78. 		<field id="dateAction" bit="73" type="string" length="6" />
    79. 

  79. 		<field id="creditsNumber" bit="74" type="string" length="10" padding-mode="left" padding-char="0" />
    80. 

  80. 		<field id="creditsReversalNumber" bit="75" type="string" length="10" padding-mode="left" padding-char="0" />
    81. 

  81. 		<field id="debitsNumber" bit="76" type="string" length="10" padding-mode="left" padding-char="0" />
    82. 

  82. 		<field id="debitsReversalNumber" bit="77" type="string" length="10" padding-mode="left" padding-char="0" />
    83. 

  83. 		<field id="transferNumber" bit="78" type="string" length="10" padding-mode="left" padding-char="0" />
    84. 

  84. 		<field id="transferReversalNumber" bit="79" type="string" length="10" padding-mode="left" padding-char="0" />
    85. 

  85. 		<field id="inquiriesNumber" bit="80" type="string" length="10" padding-mode="left" padding-char="0" />
    86. 

  86. 		<field id="authorisationsNumber" bit="81" type="string" length="10" padding-mode="left" padding-char="0" />
    87. 

  87. 		<field id="creditsProcesssingFeeAmount" bit="82" type="string" length="14" padding-mode="left" padding-char="0" />
    88. 

  88. 		<field id="creditsTransactionFeeAmount" bit="83" type="string" length="14" padding-mode="left" padding-char="0" />
    89. 

  89. 		<field id="debitsProcessingFeeAmount" bit="84" type="string" length="14" padding-mode="left" padding-char="0" />
    90. 

  90. 		<field id="debitsTransactionFeeAmount" bit="85" type="string" length="14" padding-mode="left" padding-char="0" />
    91. 

  91. 		<field id="creditsAmount" bit="86" type="string" length="15" padding-mode="left" padding-char="0" />
    92. 

  92. 		<field id="creditsReversalAmount" bit="87" type="string" length="15" padding-mode="left" padding-char="0" />
    93. 

  93. 		<field id="debitsAmount" bit="88" type="string" length="15" padding-mode="left" padding-char="0" />
    94. 

  94. 		<field id="debitsReversalAmount" bit="89" type="string" length="15" padding-mode="left" padding-char="0" />
    95. 

  95. 		<field id="originalDataElements" bit="90" type="string" length="42" padding-mode="left" />
    96. 

  96. 		<field id="fileUpdateCode" bit="91" type="string" length="1" />
    97. 

  97. 		<field id="fileSecurityCode" bit="92" type="string" length="2" padding-mode="left" padding-char="0" />
    98. 

  98. 		<field id="responseIndicator" bit="93" type="string" length="5" padding-mode="left" padding-char="0" />
    99. 

  99. 		<field id="serviceIndicator" bit="94" type="string" length="7" />
    100. 

  100. 		<field id="replacementAmounts" bit="95" type="string" length="42" />
    101. 

  101. 		<field id="messageSecurityCode" bit="96" type="string" length="8" />
    102. 

  102. 		<field id="amountNetSettlement" bit="97" type="string" length="16" padding-mode="left" padding-char="0" />
    103. 

  103. 		<field id="payee" bit="98" type="string" length="25" />
    104. 

  104. 		<field id="settlementInstitutionIdentificationCode" bit="99" type="string" length="11" format="llvar" />
    105. 

  105. 		<field id="receivingInstitutionIdentificationCode" bit="100" type="string" length="11" format="llvar" />
    106. 

  106. 		<field id="slipNumber" bit="101" type="string" length="11" format="llvar" />
    107. 

  107. 		<field id="fromAccount" bit="102" type="string" length="20" format="llvar" />
    108. 

  108. 		<field id="toAccount" bit="103" type="string" length="28" format="llvar" />
    109. 

  109. 		<field id="transactionDescription" bit="104" type="string" length="100" format="lllvar" />
    110. 

  110. 		<field id="reservedForIsoUse1" bit="105" type="string" length="999" format="lllvar" />
    111. 

  111. 		<field id="reservedForIsoUse2" bit="106" type="string" length="999" format="lllvar" />
    112. 

  112. 		<field id="reservedForIsoUse3" bit="107" type="string" length="8" format="lllvar" />
    113. 

  113. 		<field id="reservedForIsoUse4" bit="108" type="string" length="999" format="lllvar" />
    114. 

  114. 		<field id="reservedForIsoUse5" bit="109" type="string" length="999" format="lllvar" />
    115. 

  115. 		<field id="reservedForIsoUse6" bit="110" type="string" length="999" format="lllvar" />
    116. 

  116. 		<field id="reservedForIsoUse7" bit="111" type="string" length="999" format="lllvar" />
    117. 

  117. 		<field id="reservedForNationalUse" bit="112" type="string" length="999" format="lllvar" />
    118. 

  118. 		<field id="authorisingAgentInstitutionIdCode" bit="113" type="string" length="11" format="llvar" />
    119. 

  119. 		<field id="reservedForNationalUse1" bit="114" type="string" length="999" format="lllvar" />
    120. 

  120. 		<field id="reservedForNationalUse2" bit="115" type="string" length="999" format="lllvar" />
    121. 

  121. 		<field id="reservedForNationalUse3" bit="116" type="string" length="999" format="lllvar" />
    122. 

  122. 		<field id="reservedForNationalUse4" bit="117" type="string" length="999" format="lllvar" />
    123. 

  123. 		<field id="reservedForNationalUse5" bit="118" type="string" length="999" format="lllvar" />
    124. 

  124. 		<field id="reservedForNationalUse6" bit="119" type="string" length="999" format="lllvar" />
    125. 

  125. 		<field id="reservedForPrivateUse1" bit="120" type="string" length="999" format="lllvar" />
    126. 

  126. 		<field id="reservedForPrivateUse2" bit="121" type="string" length="999" format="lllvar" />
    127. 

  127. 		<field id="reservedForPrivateUse3" bit="122" type="string" length="999" format="lllvar" />
    128. 

  128. 		<field id="reservedForPrivateUse4" bit="123" type="string" length="999" format="lllvar" />
    129. 

  129. 		<field id="infoText" bit="124" type="string" length="255" format="lllvar" />
    130. 

  130. 		<field id="networkManagementInformation" bit="125" type="string" length="50" format="lllvar" />
    131. 

  131. 		<field id="issuerTraceId" bit="126" type="string" length="6" format="lllvar" />
    132. 

  132. 		<field id="reservedForPrivateUse" bit="127" type="string" length="11" format="lllvar" />
    133. 

  133. 		<field id="messageAuthenticationCode2" bit="128" type="string" length="16" />
    134. 

  134. 	</field>
    135. 

  135. 	<field id="!type" type="script" encode="true">iso-8583-mitracom</field>
    136. 

  136. 	<field id="!mid" type="script" encode="true">${msg.systemsTraceAuditNumber}</field>
    137. 

  137. 	<field id="!code" type="script" encode="true">${msg.messageType}.${msg.messageType.startsWith("08") ? msg.networkManagementInformationCode?.padLeft(6, "0") : msg.processingCode?.trim().substring(0,2) +"."+ msg.reservedPrivate3?.trim().substring(0,4)}</field>
    138. 

  138. </codex>', 'wpsadmin', '2014-12-04 14:07:13.031394');
    139. 

  139. 

  140. INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('mitracom-conn', 'incoming', 'iso-8583-mitracom');
    141. 

  141. INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('mitracom-conn', 'outgoing', 'iso-8583-mitracom');
    142. 

  142. 

  143. INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('mitracom-conn', 'echo', '120000');
    144. 

  144. INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('mitracom-conn', 'needSignOn', 'TRUE');
    145. 

  145. INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('mitracom-conn', 'timeout', '60000');
    146. 

  146. 

  147. INSERT INTO MWCONFIG.CLIENT (ADAPTOR_ID, IDLE_WAIT, TIMEOUT, CLOSE_QUEUE, CONTROL_QUEUE, KEEP_CONN, REUSE_DELAY, NODE) VALUES('mitracom-conn', 0, 0, NULL, NULL, 1, 0, 'billpayClientNode');
    148. 

  148. 

  149. INSERT INTO MWCONFIG.CLIENT_TARGET (CLIENT_ID, ID, HOST, WEIGHT, SEQ) VALUES('mitracom-conn', 'mitracom-conn', 'localhost:13069', 0, 1);
    150. 

  150. 

  151. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('mitracom-conn.ECHO-TEST', '', 'DB2PROD ', '2017-05-24 11:29:20.779458', '[zsym]');
    152. 

  152. INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('mitracom-conn.SIGN-ON', NULL, 'DB2PROD ', '2017-05-24 07:31:03.323678', '[zsym]');
    153. 

  153. 

  154. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('mitracom-conn.SIGN-ON', 1, '/data', '/data/body', NULL, NULL);
    155. 

  155. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('mitracom-conn.SIGN-ON', 2, '/data', '/data/body', 'mitracom-conn.SIGN-ON', 1);
    156. 

  156. INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES('mitracom-conn.ECHO-TEST', 1, '/data', '/data/body', 'mitracom-conn.SIGN-ON', 2);
    157. 

  157. 

  158. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('mitracom-conn.ECHO-TEST', 1, 'networkManagementInformationCode', '301', NULL);
    159. 

  159. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('mitracom-conn.SIGN-ON', 1, 'messageType', '0800', NULL);
    160. 

  160. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('mitracom-conn.SIGN-ON', 1, 'networkManagementInformationCode', '001', NULL);
    161. 

  161. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('mitracom-conn.SIGN-ON', 1, 'systemsTraceAuditNumber', '${counter("mitracom-conn", 5, 1, "ddMMyy")}', NULL);
    162. 

  162. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('mitracom-conn.SIGN-ON', 1, 'transmissionDateTime', '${getTimeZoneFormat(''MMddHHmmss'',''GMT'')}', NULL);
    163. 

  163. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('mitracom-conn.SIGN-ON', 2, '!destination', 'mitracom-conn', NULL);
    164. 

  164. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('mitracom-conn.SIGN-ON', 2, '!mid', '${tar.systemsTraceAuditNumber.''!value''}', NULL);
    165. 

  165. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('mitracom-conn.SIGN-ON', 2, '!nosignon', 'true', NULL);
    166. 

  166. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('mitracom-conn.SIGN-ON', 2, '!sid', '${msg.sid==null?getUID(tar.systemsTraceAuditNumber.''!value''):msg.sid.''!value''}', NULL);
    167.