INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, "TIMESTAMP") VALUES('pemko-depok-conn', 'connector/adaptor untuk pemerintah kota depok', 1, 'wpsadmindev', '2022-02-07 12:57:15.725000');

INSERT INTO MWCONFIG.CODEX (ID, ALLOW_PARTIAL, "XML", MODIFIED_BY, "TIMESTAMP") VALUES('iso-8583-pemkot-depok', NULL, '<codex id="iso-8583-pemkot-depok" escape="true">
  	<field id="packetLength" type="groupLength" length="4" />
  	<field id="messageType" type="string" length="4" padding-mode="right" padding-char=" " />
  	<field id="bitmap" type="bitmap">
  		<field id="primaryAccountNumber" bit="2" type="string" length="19" format="llvar" />
  		<field id="processingCode" bit="3" type="string" length="6" />
  		<field id="amountTransaction" bit="4" type="string" length="12" padding-mode="left" padding-char="0" />
  		<field id="amountSettlement" bit="5" type="string" length="18" padding-mode="left" padding-char="0" />
  		<field id="amountCardholderBilling" bit="6" type="string" length="18" padding-mode="left" padding-char="0" />
  		<field id="transmissionDateTime" bit="7" type="string" length="10" />
  		<field id="amountCardholderBillingFee" bit="8" type="string" length="8" padding-mode="left" padding-char="0" />
  		<field id="conversionRateSettlement" bit="9" type="string" length="8" padding-mode="left" padding-char="0" />
  		<field id="conversionRateCardholderBilling" bit="10" type="string" length="8" padding-mode="left" padding-char="0" />
  		<field id="systemsTraceAuditNumber" bit="11" type="string" length="6" />
  		<field id="timeLocalTransaction" bit="12" type="string" length="6" />
  		<field id="dateLocalTransaction" bit="13" type="string" length="4" />
  		<field id="dateExpiration" bit="14" type="string" length="8" />
  		<field id="dateSettlement" bit="15" type="string" length="4" />
  		<field id="dateConversion" bit="16" type="string" length="4" />
  		<field id="dateCapture" bit="17" type="string" length="4" />
  		<field id="merchantType" bit="18" type="string" length="4" padding-mode="left" padding-char="0" />
  		<field id="acquiringInstitutionCountryCode" bit="19" type="string" length="3" padding-mode="left" padding-char="0" />
  		<field id="panExtendedCountryCode" bit="20" type="string" length="3" padding-mode="left" padding-char="0" />
  		<field id="forwardingInstitutionCountryCode" bit="21" type="string" length="3" padding-mode="left" padding-char="0" />
  		<field id="pointOfServiceEntryMode" bit="22" type="string" length="3" padding-mode="left" padding-char="0" />
  		<field id="applicationPanNumber" bit="23" type="string" length="3" padding-mode="left" padding-char="0" />
  		<field id="networkInternationalIdentifier" bit="24" type="string" length="3" padding-mode="left" padding-char="0" />
  		<field id="pointOfServiceConditionCode" bit="25" type="string" length="2" padding-mode="left" padding-char="0" />
  		<field id="pointOfServiceCaptureCode" bit="26" type="string" length="2" padding-mode="left" padding-char="0" />
  		<field id="authorisingIdentificationResponseLength" bit="27" type="string" length="1" padding-mode="left" padding-char="0" />
  		<field id="amountTransactionFee" bit="28" type="string" length="9" padding-mode="left" padding-char="0" />
  		<field id="amountSettlementFee" bit="29" type="string" length="9" padding-mode="left" padding-char="0" />
  		<field id="amountTransactionProcessingFee" bit="30" type="string" length="9" padding-mode="left" padding-char="0" />
  		<field id="amountSettlementProcessingFee" bit="31" type="string" length="9" padding-mode="left" padding-char="0" />
  		<field id="acquiringInstitutionIdentificationCode" bit="32" type="string" length="11" format="llvar" />
  		<field id="forwardingInstitutionIdentificationCode" bit="33" type="string" length="11" format="llvar" />
  		<field id="primaryAccountNumberExtended" bit="34" type="string" length="28" format="llvar" />
  		<field id="track2Data" bit="35" type="string" length="37" format="llvar" />
  		<field id="track3Data" bit="36" type="string" length="104" format="lllvar" />
  		<field id="retrievalReferenceNumber" bit="37" type="string" length="12" />
  		<field id="authorisationIdentificationResponse" bit="38" type="string" length="6" />  
  		<field id="responseCode" bit="39" type="string" length="2" padding-mode="left" />
  		<field id="serviceRestrictionCode" bit="40" type="string" length="3" />
  		<field id="cardAcceptorTerminalIdentification" bit="41" type="string" length="8" />
  		<field id="cardAcceptorIdentificationCode" bit="42" type="string" length="15" />
  		<field id="cardAcceptorName" bit="43" type="string" length="40" />
  		<field id="additionalResponseData" bit="44" type="string" length="25" format="llvar" />
  		<field id="track1Data" bit="45" type="string" length="76" format="llvar" />
  		<field id="additionalDataIso" bit="46" type="string" length="999" format="lllvar" />
  		<field id="additionalDataNational" bit="47" type="string" length="20" format="lllvar" />
  		<field id="additionalDataPrivate" bit="48" type="string" length="20" format="lllvar" />
  		<field id="currencyCodeTransaction" bit="49" type="string" length="3" />
  		<field id="currencyCodeSettlement" bit="50" type="string" length="3" />
  		<field id="currencyCodeCardholderBilling" bit="51" type="string" length="3" />
  		<field id="personalIdentificationNumberData" bit="52" type="string" length="16" />
  		<field id="securityRelatedControlInformation" bit="53" type="string" length="18" padding-mode="left" padding-char="0" />
  		<field id="additionalAmounts" bit="54" type="string" length="999" format="lllvar" />
  		<field id="reservedIso1" bit="55" type="string" length="999" format="lllvar" />
  		<field id="reservedIso2" bit="56" type="string" length="999" format="lllvar" />
  		<field id="reservedNational1" bit="57" type="string" length="999" format="lllvar" />
  		<field id="reservedNational2" bit="58" type="string" length="999" format="lllvar" />
  		<field id="transactionType" bit="59" type="string" length="3" format="lllvar"/>
  		<field id="kodePemda" bit="60" type="string" length="3" format="lllvar"/>
  		<field id="reservedPrivate1" bit="61" type="string" length="22" format="lllvar"/>
  		<field id="reservedPrivate2" bit="62" type="string" length="265" format="lllvar"/>
  		<field id="reservedPrivate3" bit="63" type="string" length="3" format="lllvar"/>
  		<field id="messageAuthenticationCode" bit="64" type="string" length="16" />
  		<field id="bitMapTertiary" bit="65" type="string" length="16" />
  		<field id="settlementCode" bit="66" type="string" length="1" padding-mode="left" padding-char="0" />
  		<field id="extendedPaymentCode" bit="67" type="string" length="2" padding-mode="left" padding-char="0" />
  		<field id="receivingInstitutionCountryCode" bit="68" type="string" length="3" />
  		<field id="settlementInstitutionCountyCode" bit="69" type="string" length="3" />
  		<field id="networkManagementInformationCode" bit="70" type="string" length="3" />
  		<field id="messageNumber" bit="71" type="string" length="4" padding-mode="left" padding-char="0" />
  		<field id="messageNumberLast" bit="72" type="string" length="4" padding-mode="left" padding-char="0" />
  		<field id="dateAction" bit="73" type="string" length="6" />
  		<field id="creditsNumber" bit="74" type="string" length="10" padding-mode="left" padding-char="0" />
  		<field id="creditsReversalNumber" bit="75" type="string" length="10" padding-mode="left" padding-char="0" />
  		<field id="debitsNumber" bit="76" type="string" length="10" padding-mode="left" padding-char="0" />
  		<field id="debitsReversalNumber" bit="77" type="string" length="10" padding-mode="left" padding-char="0" />
  		<field id="transferNumber" bit="78" type="string" length="10" padding-mode="left" padding-char="0" />
  		<field id="transferReversalNumber" bit="79" type="string" length="10" padding-mode="left" padding-char="0" />
  		<field id="inquiriesNumber" bit="80" type="string" length="10" padding-mode="left" padding-char="0" />
  		<field id="authorisationsNumber" bit="81" type="string" length="10" padding-mode="left" padding-char="0" />
  		<field id="creditsProcesssingFeeAmount" bit="82" type="string" length="14" padding-mode="left" padding-char="0" />
  		<field id="creditsTransactionFeeAmount" bit="83" type="string" length="14" padding-mode="left" padding-char="0" />
  		<field id="debitsProcessingFeeAmount" bit="84" type="string" length="14" padding-mode="left" padding-char="0" />
  		<field id="debitsTransactionFeeAmount" bit="85" type="string" length="14" padding-mode="left" padding-char="0" />
  		<field id="creditsAmount" bit="86" type="string" length="15" padding-mode="left" padding-char="0" />
  		<field id="creditsReversalAmount" bit="87" type="string" length="15" padding-mode="left" padding-char="0" />
  		<field id="debitsAmount" bit="88" type="string" length="15" padding-mode="left" padding-char="0" />
  		<field id="debitsReversalAmount" bit="89" type="string" length="15" padding-mode="left" padding-char="0" />
  		<field id="originalDataElements" bit="90" type="string" length="42" padding-mode="left" />
  		<field id="fileUpdateCode" bit="91" type="string" length="1" />
  		<field id="fileSecurityCode" bit="92" type="string" length="2" padding-mode="left" padding-char="0" />
  		<field id="responseIndicator" bit="93" type="string" length="5" padding-mode="left" padding-char="0" />
  		<field id="serviceIndicator" bit="94" type="string" length="7" />
  		<field id="replacementAmounts" bit="95" type="string" length="42" />
  		<field id="messageSecurityCode" bit="96" type="string" length="8" />
  		<field id="amountNetSettlement" bit="97" type="string" length="16" padding-mode="left" padding-char="0" />
  		<field id="payee" bit="98" type="string" length="25" />
  		<field id="settlementInstitutionIdentificationCode" bit="99" type="string" length="11" format="llvar" />
  		<field id="receivingInstitutionIdentificationCode" bit="100" type="string" length="11" format="llvar" />
  		<field id="slipNumber" bit="101" type="string" length="11" format="llvar" />
  		<field id="fromAccount" bit="102" type="string" length="20" format="llvar" />
  		<field id="toAccount" bit="103" type="string" length="28" format="llvar" />
  		<field id="transactionDescription" bit="104" type="string" length="100" format="lllvar" />
  		<field id="reservedForIsoUse1" bit="105" type="string" length="999" format="lllvar" />
  		<field id="reservedForIsoUse2" bit="106" type="string" length="999" format="lllvar" />
  		<field id="reservedForIsoUse3" bit="107" type="string" length="8" format="lllvar"/>
  		<field id="reservedForIsoUse4" bit="108" type="string" length="999" format="lllvar" />
  		<field id="reservedForIsoUse5" bit="109" type="string" length="999" format="lllvar" />
  		<field id="reservedForIsoUse6" bit="110" type="string" length="999" format="lllvar" />
  		<field id="reservedForIsoUse7" bit="111" type="string" length="999" format="lllvar" />
  		<field id="reservedForNationalUse" bit="112" type="string" length="999" format="lllvar" />
  		<field id="authorisingAgentInstitutionIdCode" bit="113" type="string" length="11" format="llvar" />
  		<field id="reservedForNationalUse1" bit="114" type="string" length="999" format="lllvar" />
  		<field id="reservedForNationalUse2" bit="115" type="string" length="999" format="lllvar" />
  		<field id="reservedForNationalUse3" bit="116" type="string" length="999" format="lllvar" />
  		<field id="reservedForNationalUse4" bit="117" type="string" length="999" format="lllvar" />
  		<field id="reservedForNationalUse5" bit="118" type="string" length="999" format="lllvar" />
  		<field id="reservedForNationalUse6" bit="119" type="string" length="999" format="lllvar" />
  		<field id="reservedForPrivateUse1" bit="120" type="string" length="999" format="lllvar" />
  		<field id="reservedForPrivateUse2" bit="121" type="string" length="999" format="lllvar" />
  		<field id="reservedForPrivateUse3" bit="122" type="string" length="999" format="lllvar" />
  		<field id="reservedForPrivateUse4" bit="123" type="string" length="999" format="lllvar" />
  		<field id="infoText" bit="124" type="string" length="255" format="lllvar" />
  		<field id="networkManagementInformation" bit="125" type="string" length="50" format="llvar" />
  		<field id="issuerTraceId" bit="126" type="string" length="6"/>
  		<field id="reservedForPrivateUse" bit="127" type="string" length="11" format="llvar" />
  		<field id="messageAuthenticationCode2" bit="128" type="string" length="16" />
  	</field>
  	<field id="!type" type="script" encode="true">iso-8583-pemkot-depok</field>
  	<field id="!mid" type="script" encode="true">${msg.systemsTraceAuditNumber}</field>
  	<field id="!code" type="script" encode="true">${msg.messageType}.${msg.messageType.startsWith("08") ? msg.networkManagementInformationCode?.padLeft(6, "0") : msg.processingCode?.trim().substring(0,1)}</field>
</codex>', 'wpsadmin', '2014-12-04 14:07:13.031394');

INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('pemko-depok-conn', 'incoming', 'iso-8583-pemkot-depok');
INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES('pemko-depok-conn', 'outgoing', 'iso-8583-pemkot-depok');

INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('pemko-depok-conn', 'echo', '120000');
INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('pemko-depok-conn', 'needSignOn', 'TRUE');
INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES('pemko-depok-conn', 'timeout', '60000');

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

INSERT INTO MWCONFIG.CLIENT_TARGET (CLIENT_ID, ID, HOST, WEIGHT, SEQ) VALUES('pemko-depok-conn', 'pemko-depok-conn', 'localhost:13063', 0, 1);

INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('pemko-depok-conn.ECHO-TEST', '', 'DB2PROD ', '2017-05-24 11:29:20.779458', '[zsym]');
INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODIFIED_BY, "TIMESTAMP", MODULE) VALUES('pemko-depok-conn.SIGN-ON', NULL, 'DB2PROD ', '2017-05-24 07:31:03.323678', '[zsym]');

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

INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.ECHO-TEST', 1, 'networkManagementInformationCode', '301', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 1, 'messageType', '0800', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 1, 'networkManagementInformationCode', '001', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 1, 'systemsTraceAuditNumber', '${counter("pemko-depok-conn", 5, 1, "ddMMyy")}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 1, 'transmissionDateTime', '${getTimeZoneFormat(''MMddHHmmss'',''GMT'')}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 2, '!destination', 'pemko-depok-conn', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 2, '!mid', '${tar.systemsTraceAuditNumber.''!value''}', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 2, '!nosignon', 'true', NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES('pemko-depok-conn.SIGN-ON', 2, '!sid', '${msg.sid==null?getUID(tar.systemsTraceAuditNumber.''!value''):msg.sid.''!value''}', NULL);