btn-mdw-ace-server-local/mwconfig/migration/MWCONFIG_INITDB_ITM_01.sql

INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, TIMESTAMP)
	VALUES 
		('itm-10363', 'ITM Network Adaptor', 1, CURRENT USER, CURRENT TIMESTAMP),
		('itm-10366', 'ITM OnUs Adaptor', 1, CURRENT USER, CURRENT TIMESTAMP),
		('core-itm', 'Core Adaptor from ITM channel', 0, CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWCONFIG.DTREE(GROUP, PATH, VALUE, MODULE, MODIFIED_BY, TIMESTAMP)
	VALUES 
		('ITM-CODE', '0200', '0200.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0210', '0210.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0220', '0220.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0230', '0230.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0400', '0400.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0401', '0401.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0410', '0410.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0411', '0411.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0420', '0420.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0430', '0430.${msg.processingCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0800', '0800.${msg.networkManagementInformationCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0810', '0810.${msg.networkManagementInformationCode?.padLeft(6, "0")}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),	
		('ITM-CODE', '0200.201000', '0200.201000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0200.202000', '0200.202000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0210.201000', '0210.201000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP),
		('ITM-CODE', '0210.202000', '0210.202000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP), 
		('ITM-CODE', '0200.235000', '0200.230000.${msg.reservedPrivate2.substring(0, 6)}', '[itm]', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWCONFIG.CODEX (ID, XML, MODIFIED_BY, TIMESTAMP)
VALUES ('iso-8583-itm', '<codex id="iso-8583-itm" escape="true">
	<field id="packetLength" type="groupLengthBinary" decimal-format="binary" length="2" />
	<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="12" padding-mode="left" padding-char="0" />
		<field id="amountCardholderBilling" bit="6" type="string" length="12" 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="4" />
		<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="16" />
		<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="999" format="lllvar" />
		<field id="additionalDataPrivate" bit="48" type="string" length="999" 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="reservedNational3" bit="59" type="string" length="999" format="lllvar" />
		<field id="reasonCode" bit="60" type="string" length="999" format="lllvar" />
		<field id="reservedPrivate1" bit="61" type="string" length="999" format="lllvar" />
		<field id="reservedPrivate2" bit="62" type="string" length="999" format="lllvar" />
		<field id="reservedPrivate3" bit="63" type="string" length="999" 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="28" 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="999" 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="lllvar" />
		<field id="issuerTraceId" bit="126" type="string" length="6" format="lllvar" />
		<field id="reservedForPrivateUse" bit="127" type="string" length="11" format="lllvar" />
		<field id="messageAuthenticationCode2" bit="128" type="string" length="16" />
	</field>
	<field id="!type" type="script" encode="true">iso-8583-itm</field>
	<field id="!mid" type="script" encode="true">${msg.transmissionDateTime}.${msg.systemsTraceAuditNumber}</field>
	<field id="!code" type="script" encode="true">${dtree("ITM-CODE", "messageType")}</field>
</codex>', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID)
	VALUES 
		('itm-10363', 'incoming','iso-8583-itm'),
		('itm-10363', 'outgoing','iso-8583-itm'),
		('itm-10366', 'incoming','iso-8583-itm'),
		('itm-10366', 'outgoing','iso-8583-itm'),
		('core-itm', 'incoming', 'dsp-response'),
		('core-itm', 'outgoing', 'dsp');

INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE)
	VALUES 
		('itm-10363', 'maxConnection', '1'),
	   ('itm-10366', 'maxConnection', '1'),
	   ('core-itm', 'timeout', '40000'),
	   ('core-itm', 'closeOnReply', 'true'),
	   ('core-itm', 'maxConnection', '50');

INSERT INTO MWCONFIG.SERVER_PORT (ADAPTOR_ID, PORT, SERVER, GROUP)
	VALUES 
		('itm-10363', 10363, 'server-1', 'itm'),
		('itm-10366', 10366, 'server-1', 'itm');

INSERT INTO MWCONFIG.CLIENT (ADAPTOR_ID, IDLE_WAIT, KEEP_CONN, NODE)
	VALUES ('core-itm', 30000, 0, 'core-client');

INSERT INTO MWCONFIG.CLIENT_TARGET (CLIENT_ID, ID, HOST, SEQ)
	VALUES ('core-itm', 'core-itm', 'BTNCOREKONVEN:13000', 1);

INSERT INTO MWCONFIG.DBCONN(ID, DRIVER, URL, USERNAME, PASSWORD, SCHEMA, MODIFIED_BY, TIMESTAMP)
	VALUES 
		('mwlog', 'com.ibm.db2.jcc.DB2Driver', 'jdbc:db2://btnmwlog:50000/MWLOG', 'db2inst1', 'wajFMo2HsNWsRQcLal8Y47jzNMHI+oAu8ywJwIfL9cA=', 'MWLOG', CURRENT USER, CURRENT TIMESTAMP),
		('CORE_KONVEN_DSP', 'com.ibm.as400.access.AS400JDBCDriver', 'jdbc:as400://BTNCOREKONVEN;prompt=false', 'RPTSPP', 'SmDNFJ5hiv3cLh1UQnV6bw==', 'P', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWCONFIG.PARSER(ID, MODIFIED_BY, TIMESTAMP)
	VALUES 
		('parser-1', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWCONFIG.ROUTING_TABLE (CODE_START, CODE_END, CHANNEL, START_DATE, QUEUE, STATUS, CREATE_BY, CREATE_DATE)
	VALUES 
		('0800.000000', '0800.999999', 'itm', CURRENT TIMESTAMP, 'ITM_NETWORK_IN', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
	   ('*', '*', 'itm', CURRENT TIMESTAMP, 'ITM_IN', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWCONFIG.DEV_TELLER_MAP (GROUP, DEVICE_ID, DEVICE_NAME, TERMINAL_ID, TERMINAL_IP, TELLER_ID, CTRL_UNIT_ID, TIMESTAMP, MODIFIED_BY)
	VALUES 
		('itm', '20004711', '', '20004711', '10.254.47.34', '9904711', 'C47', CURRENT TIMESTAMP, CURRENT USER);

INSERT INTO MWCONFIG.ERROR_MAP (GROUP, ORIGINAL, TARGET, DETAIL, MODIFIED_BY, TIMESTAMP)
	VALUES 
		('core-itm', '996', '81', 'Failed to connect to core', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWCONFIG.PARAM_MAP (GROUP, NAME, VALUE, TIMESTAMP, MODIFIED_BY)
	VALUES 
		('core-response-ok', 'AXISSYSTEMSDNBHD.0000005001', 'F1', CURRENT TIMESTAMP, CURRENT USER),
		('core-response-ok', 'AXISSYSTEMSDNBHD.0000005002', 'F1', CURRENT TIMESTAMP, CURRENT USER),
		('error-f2', 'confail', '996', CURRENT TIMESTAMP, CURRENT USER),
		('itm-konven-code', '0200.201000.001001', '5001', CURRENT TIMESTAMP, CURRENT USER),
		('itm-konven-code', '0200.202000.001001', '5002', CURRENT TIMESTAMP, CURRENT USER),
		('time-check', 'time','15000', CURRENT TIMESTAMP, CURRENT USER);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('itm-network-res', NULL, CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
	VALUES 
		('itm-network-res', 1, '/data', '/data', NULL, NULL),
		('itm-network-res', 2, '/data/body', '/data/body', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
	VALUES 
		('itm-network-res', 1, '@', 'copyMessage();'),
		('itm-network-res', 1, 'connid', '${null}'),
		('itm-network-res', 1, 'mid', '${null}'),
		('itm-network-res', 1, 'nolog', 'true'),
		('itm-network-res', 1, 'sid', '${null}'),
		('itm-network-res', 2, 'messageType', '${msg.messageType.''!value''.substring(0,2).concat("10")}'),
		('itm-network-res', 2, 'responseCode', '00');

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('router-change-group', NULL, CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('router-change-group', 1, '/data', '/data', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
VALUES ('router-change-group', 1, '@', 'copyMessage();', 10),
	   ('router-change-group', 1, 'groupTemp', '${getParamValue("group-change",head.group."!value"+"."+(head.body.reservedPrivate2?."!value"!=null?head.body.reservedPrivate2."!value".padRight(3,"0").substring(0,3):"000"), getParamValue("group-change",head.group?."!value"+"."+(head.body.reservedPrivate2?."!value"!=null?head.body.reservedPrivate2."!value".padRight(9,"0").substring(6,9):"000"), head.group."!value"))}', 10),
	   ('router-change-group', 1, 'groupCheckCode', '${getParamValue("group-check-code", head.group."!value"+"."+head.body.messageType."!value"+"."+(head.body.processingCode?."!value"==null?"":head.body.processingCode."!value".substring(0,2)), "false")}', 20),
	   ('router-change-group', 1, 'groupCore', '${getParamValue("group-core",tar.groupTemp."!value", head.group."!value")}', 25),
	   ('router-change-group', 1, 'group', '${tar.groupCheckCode."!value"=="true"?(head.code."!value".toLowerCase().contains(tar.groupCore."!value".toLowerCase())?tar.groupTemp:head.group):tar.groupTemp."!value"}', 30),
	   ('router-change-group', 1, 'oldgroup', '${head.group."!value"}', NULL);

INSERT INTO MWCONFIG.MAPPING(ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP) VALUES('time-request-check', NULL, NULL, CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP(MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
VALUES ('time-request-check', 1, '/data', '/data', NULL, NULL),
		('time-request-check', 2, '/data', '/data', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
VALUES ('time-request-check', 1, '@', 'copyMessage();', 1),
	   ('time-request-check', 1, 'time_param', '${getParamValue("time-check","time","30000")}', 2),
	   ('time-request-check', 1, 'current_timestamp', '${java.util.Calendar.getInstance().getTimeInMillis()}', 3),
	   ('time-request-check', 2, 'time_total', '${tar.ttl == null ? new Long(tar.time_param."!value")+new Long(tar.reqtimestamp."!value") : new Integer(tar.ttl."!value") > new Integer("0") ? new Long(tar.ttl."!value")+new Long(tar.reqtimestamp."!value") : new Long(tar.reqtimestamp."!value")}', 1);

INSERT INTO MWCONFIG.MAPPING(ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('dsp', NULL, CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP(MAPPING_ID, ID, SOURCE, TARGET) VALUES ('dsp', 1, '/data/body', '/data/body');
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
VALUES ('dsp', 1, '!code', '${head.code}'),
	   ('dsp', 1, '!connid', '${head.connid}'),
	   ('dsp', 1, '!CorrelId', '${head.CorrelId}'),
	   ('dsp', 1, '!destination', '${head.source}'),
	   ('dsp', 1, '!dir', '${head.dir}'),
	   ('dsp', 1, '!group', '${head.group}'),
	   ('dsp', 1, '!mid', '${head.mid}'),
	   ('dsp', 1, '!remaining', 'AAA='),
	   ('dsp', 1, '!remainingPos', '1268'),
	   ('dsp', 1, '!reqtimestamp', '${head.reqtimestamp}'),
	   ('dsp', 1, '!sid', '${head.sid}'),
	   ('dsp', 1, '!source', '${head.source}'),
	   ('dsp', 1, '!timestamp', '${head.timestamp}'),
	   ('dsp', 1, '!type', '${head.type}');

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm', '[izzit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('req-core.itm', 1, '/data/body', '/data/body', 'dsp', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
VALUES 
	('req-core.itm', 1, 'tellerComplete', '${getParamValue("device_teller_map", head.group."!value".trim() + "_" + msg.cardAcceptorTerminalIdentification."!value".trim(), "|||| ")}', 10),
	('req-core.itm', 1, '@', 'copyMessageToChild("original");', NULL), 
	('req-core.itm', 1, '!code', '${"AXISSYSTEMSDNBHD."+tar.dspTransactionCode}', 20),
	('req-core.itm', 1, '!destination', 'core-itm', NULL),
	('req-core.itm', 1, '!mappingCode', '${head.code}', NULL),
	('req-core.itm', 1, '!queueName', 'CORE_IN', NULL),
	('req-core.itm', 1, 'dspHeaderType', '*HOST', NULL),
	('req-core.itm', 1, 'dspDeviceName', '${tar.tellerComplete."!value".split("\\|", -1)[3]}', NULL),
	('req-core.itm', 1, 'dspFiller1', 'F0', NULL),
	('req-core.itm', 1, 'dspVersionNumber', '0000', NULL),
	('req-core.itm', 1, 'dspDataFormatId', 'ABCS', NULL),
	('req-core.itm', 1, 'dspSourceId', '*AXIS', NULL),
	('req-core.itm', 1, 'dspBankIdNumber', '00000000000', NULL),
	('req-core.itm', 1, 'dspNode', '00', NULL),
	('req-core.itm', 1, 'dspExchangeId', '4040404040404040404040404040404040404040', NULL),
	('req-core.itm', 1, 'dspScenarioNumber', 'AXISSYSTEMSDNBHD', NULL),
	('req-core.itm', 1, 'dspTransactionCode', '5001', 10),
	('req-core.itm', 1, 'dspUserId', '${tar.tellerComplete."!value".split("\\|", -1)[0]}', NULL),
	('req-core.itm', 1, 'dspTerminalId', '${tar.tellerComplete."!value".split("\\|", -1)[1]}', NULL),
	('req-core.itm', 1, 'ICLEN', '1020', NULL),
	('req-core.itm', 1, 'ICHEAD', '*MOSA', NULL),
	('req-core.itm', 1, 'ICDEVN', '${tar.tellerComplete."!value".split("\\|", -1)[3]}', NULL),
	('req-core.itm', 1, 'ICID', '00000', NULL),
	('req-core.itm', 1, 'TMTIMIN', '000000', NULL),
	('req-core.itm', 1, 'TMTXTYP', 'T9999', NULL),
	('req-core.itm', 1, 'ICEOM', '*EOM', NULL),
	('req-core.itm', 1, 'TLBCUD', '${tar.tellerComplete."!value".split("\\|", -1)[2]}', NULL),
	('req-core.itm', 1, 'TLBWS', 'ES', NULL),
	('req-core.itm', 1, 'TLBFP3', 'FF', NULL),
	('req-core.itm', 1, 'TLBID', '${tar.tellerComplete."!value".split("\\|", -1)[0]}', NULL),
	('req-core.itm', 1, 'TLBTCD', '${tar.dspTransactionCode}', 20),
	('req-core.itm', 1, 'TLBTDT', '${msg.transmissionDateTime."!value".substring(2,4)+msg.transmissionDateTime."!value".substring(0,2)+new java.text.SimpleDateFormat("yy").format(new Date())}', NULL),
	('req-core.itm', 1, 'TLBWC1', '00', NULL),
	('req-core.itm', 1, 'TLBWC2', '00', NULL),
	('req-core.itm', 1, 'TLBJSN', '${msg.systemsTraceAuditNumber}', NULL),
	('req-core.itm', 1, 'TLBJC1', '00', NULL),
	('req-core.itm', 1, 'TLBJC2', '00', NULL),
	('req-core.itm', 1, 'TLBFP1', 'FF', NULL),
	('req-core.itm', 1, 'TLBFP2', 'FC', NULL),
	('req-core.itm', 1, 'TLBCUR', 'IDR', NULL),
	('req-core.itm', 1, 'TLBCIF', '${msg.timeLocalTransaction}', NULL),
	('req-core.itm', 1, 'TLCUR1', 'IDR', NULL),
	('req-core.itm', 1, 'TLXUFD', 'ATM', NULL),
	('req-core.itm', 1, 'TLBDS1', '${msg.timeLocalTransaction."!value"+msg.dateLocalTransaction."!value"+msg.acquiringInstitutionIdentificationCode."!value".padRight(11," ")+msg.merchantType."!value".padRight(4, " ")+msg.retrievalReferenceNumber."!value".padRight(12," ")}', NULL),
	('req-core.itm', 1, 'RMAPID', '${msg.retrievalReferenceNumber}${new java.text.SimpleDateFormat("yy").format(new Date())+msg.dateLocalTransaction."!value"}${msg.timeLocalTransaction}', NULL),
	('req-core.itm', 1, 'RMADD3', '${(msg.track2Data==null||msg.track2Data."!value"==null?"":msg.track2Data."!value").padRight(37," ")}', NULL),
	('req-core.itm', 1, 'RMPSTC', '${new java.text.SimpleDateFormat("yyyy").format(new Date())+msg.dateLocalTransaction."!value"}', NULL),
	('req-core.itm', 1, 'RMSEHS', '${msg.dateLocalTransaction}', NULL),
	('req-core.itm', 1, 'TLBFIL', '${msg.cardAcceptorTerminalIdentification."!value"+msg.retrievalReferenceNumber."!value".padRight(12," ")+msg.acquiringInstitutionIdentificationCode."!value".padRight(11," ")}', NULL);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('res-core.itm', '[izzit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET) VALUES ('res-core.itm', 1, '/data/body', '/data/body');
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
VALUES ('res-core.itm', 1, '@', 'copyMessage("../body", "request/data/body/original")', 10),
	   ('res-core.itm', 1, '!connid', '${head.connid}', 20),
	   ('res-core.itm', 1, '!CorrelId', '${head.CorrelId}', 20),
	   ('res-core.itm', 1, '!group', '${head.request.data.group}', 20),
	   ('res-core.itm', 1, '!mid', '${head.request.data.mid}', 20),
	   ('res-core.itm', 1, '!reqtimestamp', '${head.reqtimestamp}', 20),
	   ('res-core.itm', 1, '!sid', '${head.sid}', 20),
	   ('res-core.itm', 1, '!source', '${head.request.data.source}', 20),
	   ('res-core.itm', 1, '!timestamp', '${head.timestamp}', 20),
	   ('res-core.itm', 1, 'primaryAccountNumber', '${head.request.data.body.original.primaryAccountNumber}', 20),
	   ('res-core.itm', 1, 'processingCode', '${head.request.data.body.original.processingCode}', 20),
	   ('res-core.itm', 1, 'amountTransaction', '${head.request.data.body.original.amountTransaction}', 20),
	   ('res-core.itm', 1, 'amountCardholderBilling', '${head.request.data.body.original.amountCardholderBilling}', 20),
	   ('res-core.itm', 1, 'transmissionDateTime', '${head.request.data.body.original.transmissionDateTime}', 20),
	   ('res-core.itm', 1, 'conversionRateCardholderBilling', '${head.request.data.body.original.conversionRateCardholderBilling}', 20),
	   ('res-core.itm', 1, 'systemsTraceAuditNumber', '${head.request.data.body.original.systemsTraceAuditNumber}', 20),
	   ('res-core.itm', 1, 'timeLocalTransaction', '${head.request.data.body.original.timeLocalTransaction}', 20),
	   ('res-core.itm', 1, 'dateLocalTransaction', '${head.request.data.body.original.dateLocalTransaction}', 20),
	   ('res-core.itm', 1, 'dateCapture', '${head.request.data.body.original.dateCapture}', 20),
	   ('res-core.itm', 1, 'merchantType', '${head.request.data.body.original.merchantType}', 20),
	   ('res-core.itm', 1, 'amountTransactionFee', '${head.request.data.body.original.amountTransactionFee}', 20),
	   ('res-core.itm', 1, 'acquiringInstitutionIdentificationCode', '${head.request.data.body.original.acquiringInstitutionIdentificationCode}', 20),
	   ('res-core.itm', 1, 'forwardingInstitutionIdentificationCode', '${head.request.data.body.original.forwardingInstitutionIdentificationCode}', 20),
	   ('res-core.itm', 1, 'track2Data', '${head.request.data.body.original.track2Data}', 20),
	   ('res-core.itm', 1, 'retrievalReferenceNumber', '${head.request.data.body.original.retrievalReferenceNumber}', 20),
	   ('res-core.itm', 1, 'responseCode', '00', 20),
	   ('res-core.itm', 1, 'cardAcceptorTerminalIdentification', '${head.request.data.body.original.cardAcceptorTerminalIdentification}', 20),
	   ('res-core.itm', 1, 'cardAcceptorIdentificationCode', '${head.request.data.body.original.cardAcceptorIdentificationCode}', 20),
	   ('res-core.itm', 1, 'cardAcceptorName', '${head.request.data.body.original.cardAcceptorName}', 20),
	   ('res-core.itm', 1, 'additionalDataPrivate', '${head.request.data.body.original.additionalDataPrivate}', 20),
	   ('res-core.itm', 1, 'currencyCodeTransaction', '${head.request.data.body.original.currencyCodeTransaction}', 20),
	   ('res-core.itm', 1, 'reasonCode', '${head.request.data.body.original.reasonCode}', 20),
	   ('res-core.itm', 1, 'reservedPrivate1', '${head.request.data.body.original.reservedPrivate1}', 20),
	   ('res-core.itm', 1, 'reservedPrivate2', '${head.request.data.body.original.reservedPrivate2}', 20),
	   ('res-core.itm', 1, 'receivingInstitutionIdentificationCode', '${head.request.data.body.original.receivingInstitutionIdentificationCode}', 20),
	   ('res-core.itm', 1, 'fromAccount', '${head.request.data.body.original.fromAccount}', 20),
	   ('res-core.itm', 1, 'toAccount', '${head.request.data.body.original.toAccount}', 20),
	   ('res-core.itm', 1, 'reservedForPrivateUse1', '${head.request.data.body.original.reservedForPrivateUse1}', 20),
	   ('res-core.itm', 1, 'networkManagementInformation', '${head.request.data.body.original.networkManagementInformation}', 20),
	   ('res-core.itm', 1, 'reservedForPrivateUse', '${head.request.data.body.original.reservedForPrivateUse}', 20);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('res-core.itm.0200', '[izzit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('res-core.itm.0200', 1, '/data/body', '/data/body', 'res-core.itm', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
VALUES ('res-core.itm.0200', 1, 'messageType', '0210', 10),
	   ('res-core.itm.0200', 1, '!code', '${tar.messageType."!value"+"."+tar.processingCode."!value"}', 20);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('abcs-res-conFail-F2', '[core]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('abcs-res-conFail-F2', 1, '/data/body', '/data/body', 'dsp', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
VALUES ('abcs-res-conFail-F2', 1, 'TLBERR_F2', '${getParamValue("error-f2","confail","999")}', 10),
	   ('abcs-res-conFail-F2', 1, 'ERROR_F2', '${tar.TLBERR_F2."!value" == getParamValue("error-f2","confail","999") ? getParamValue("error-f2","confail-detail","Invalid error") : "Invalid error"}', 20),
	   ('abcs-res-conFail-F2', 1, 'isF2code', '${tar.TLBERR_F2}', 20),
	   ('abcs-res-conFail-F2', 1, 'responseCode', '${tar.TLBERR_F2}', 20),
	   ('abcs-res-conFail-F2', 1, '!CorrelId', '${head.request.data.CorrelId}', NULL),
	   ('abcs-res-conFail-F2', 1, '!adaptor', '${head.adaptor?head.adaptor:head.request.data.source}', NULL),
	   ('abcs-res-conFail-F2', 1, '!code', '${head.request.data.code}', NULL),
	   ('abcs-res-conFail-F2', 1, '!codex_1', 'dsp-abcs-response', NULL),
	   ('abcs-res-conFail-F2', 1, '!dir', 'I', NULL),
	   ('abcs-res-conFail-F2', 1, '!multicodex_1', 'dsp-abcs-subresponse-F2', NULL),
	   ('abcs-res-conFail-F2', 1, '!multicodex_suffix_1', '_F2', NULL),
	   ('abcs-res-conFail-F2', 1, '!reqtimestamp', '${head.request.data.reqtimestamp}', NULL),
	   ('abcs-res-conFail-F2', 1, '!source', '${head.request.data.source?head.request.data.source:head.request.data.destination}', NULL),
	   ('abcs-res-conFail-F2', 1, '!timestamp', '${System.currentTimeMillis()}', NULL),
	   ('abcs-res-conFail-F2', 1, '!type', 'dsp-abcs-response', NULL),
	   ('abcs-res-conFail-F2', 1, '@', 'copyMessage("../request", "request");', NULL),
	   ('abcs-res-conFail-F2', 1, 'AVBAL_F2', '0', NULL),
	   ('abcs-res-conFail-F2', 1, 'FILLER1_F2', '11', NULL),
	   ('abcs-res-conFail-F2', 1, 'FILLER2_F2', '11', NULL),
	   ('abcs-res-conFail-F2', 1, 'ICCOMQ', 'DQAXISIN  ', NULL),
	   ('abcs-res-conFail-F2', 1, 'ICDEVN', '${msg.ICDEVN}', NULL),
	   ('abcs-res-conFail-F2', 1, 'ICEOM', '${msg.ICEOM}', NULL),
	   ('abcs-res-conFail-F2', 1, 'ICHEAD', '*SOKR', NULL),
	   ('abcs-res-conFail-F2', 1, 'ICID', '00000', NULL),
	   ('abcs-res-conFail-F2', 1, 'ICIPSF', '0', NULL),
	   ('abcs-res-conFail-F2', 1, 'ICLEN', '122', NULL),
	   ('abcs-res-conFail-F2', 1, 'ICRSV1', '0', NULL),
	   ('abcs-res-conFail-F2', 1, 'ICRTRQ', '          ', NULL),
	   ('abcs-res-conFail-F2', 1, 'TMTIMIN', '000000', NULL),
	   ('abcs-res-conFail-F2', 1, 'TMTXTYP', '${msg.TMTXTYP}', NULL),
	   ('abcs-res-conFail-F2', 1, 'abcsResponses', '[F2]', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspBankIdNumber', '${msg.dspBankIdNumber}', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspDataFormatId', '${msg.dspDataFormatId}', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspDestinationId', 'DQAXISIN  ', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspExchangeId', '                    ', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspFiller1', '40', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspHeaderFormatId', '*DSP', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspHeaderLength', '0213', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspHeaderType', '*SOKI', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspMessageStatus', '.-------', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspNumberOfErrorsToBeLoaded', '0010', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspNumberOfRecordsToBeLoaded', '0010', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspPacketLength', '', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspPortNumber', '${msg.dspPortNumber}', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspRetrievalReferenceNumber', '                      ', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspRoutingNumber', '00    ', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspScenarioNumber', '${msg.dspScenarioNumber}', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspSourceId', '${msg.dspSourceId}', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspTerminalId', '${msg.dspTerminalId}', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspTransactionCode', '${msg.dspTransactionCode}', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspUserId', '${msg.dspUserId}', NULL),
	   ('abcs-res-conFail-F2', 1, 'dspVersionNumber', '0200', NULL),
	   ('abcs-res-conFail-F2', 1, 'responseCode_F2', 'F2', NULL),
	   ('abcs-res-conFail-F2', 1, 'responseHeader_F2', 'F2', NULL),
	   ('abcs-res-conFail-F2', 1, 'sequenceNumber', '${msg.TLBJSN}', NULL),
	   ('abcs-res-conFail-F2', 1, 'tellerID', '${msg.TLBID}', NULL);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) 
	VALUES ('check.res-core.need-reversal', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
	VALUES ('check.res-core.need-reversal', 1, '/data', '/data', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
VALUES 
	('check.res-core.need-reversal', 1, '@', 'copyMessage()', NULL),
	('check.res-core.need-reversal', 1, 'coreAct', '${getParamValue("check.res-core."+msg.request.data.group."!value"+"."+msg.request.data.body.original.processingCode."!value", msg.body.responseCode==null?"99":msg.body.responseCode."!value","not")}', NULL);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('res-core.itm.error', '[izzit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('res-core.itm.error', 1, '/data/body', '/data/body', 'res-core.itm', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
VALUES ('res-core.itm.error', 1, '!error', '${head.error}'),
	   ('res-core.itm.error', 1, '!errorDetail', '${head.errorDetail}'),
	   ('res-core.itm.error', 1, 'responseCode', '${getParamValue("error_map|".concat(head.adaptor==null?head.destination."!value":head.adaptor."!value"), msg.responseCode."!value", "99")}');

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('res-core.itm.0200.error', '[izzit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('res-core.itm.0200.error', 1, '/data/body', '/data/body', 'res-core.itm.error', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
VALUES ('res-core.itm.0200.error', 1, 'messageType', '0210', 10),
	   ('res-core.itm.0200.error', 1, '!code', '${tar.messageType."!value"+"."+tar.processingCode."!value"}', 20);

INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP) 
	VALUES ('req-core.itm.0200.201000.001001', 'ONUS Inquiry Balance Konven SA Request', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
	VALUES ('req-core.itm.0200.201000.001001', 1, '/data/body', '/data/body', 'req-core.itm', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ)
	VALUES ('req-core.itm.0200.201000.001001', 1, 'TLBF01', '${msg.fromAccount}', null);

INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP) 
	VALUES ('res-core.itm.0200.201000.001001', 'ONUS Inquiry Balance Konven SA Response', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
	VALUES ('res-core.itm.0200.201000.001001', 1, '/data/body', '/data/body', 'res-core.itm.0200', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
	VALUES ('res-core.itm.0200.201000.001001', 1, 'additionalResponseData', '${decimalFormat("0", (msg.AMT2_F1."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.AMT2_F1."!number"*100)).padLeft(12, "0")}${decimalFormat("0", (msg.AMT1_F1."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.AMT1_F1."!number"*100)).padLeft(12, "0")}'),
		   ('res-core.itm.0200.201000.001001', 1, 'additionalDataPrivate', '${msg.SNAME_F1}');

INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm.0200.202000.001001', 'ONUS Inquiry Balance Konven CA Request', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('req-core.itm.0200.202000.001001', 1, '/data/body', '/data/body', 'req-core.itm.0200.201000.001001', 1);

INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('res-core.itm.0200.202000.001001', 'ONUS Inquiry Balance Konven CA Response', '[itmit]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('res-core.itm.0200.202000.001001', 1, '/data/body', '/data/body', 'res-core.itm.0200.201000.001001', 1);

INSERT INTO MWCONFIG.RELOADTS(BROKER, EXECUTIONGROUP, MODIFIED_BY, TIMESTAMP, TYPE) 
	VALUES 
		('ITMBROKER', 'ITMROUTER', CURRENT USER, CURRENT TIMESTAMP, 'mapping'),
	   ('ITMBROKER', 'ITMROUTER', CURRENT USER, CURRENT TIMESTAMP, 'routing'),
	   ('ITMBROKER', 'ITMCORE1', CURRENT USER, CURRENT TIMESTAMP, 'port'),
	   ('ITMBROKER', 'ITMITM1', CURRENT USER, CURRENT TIMESTAMP, 'codex'),
	   ('ITMBROKER', 'ITMITM1', CURRENT USER, CURRENT TIMESTAMP, 'db'),
	   ('ITMBROKER', 'ITMITM1', CURRENT USER, CURRENT TIMESTAMP, 'mapping'),
	   ('ITMBROKER', 'ITMITM1', CURRENT USER, CURRENT TIMESTAMP, 'param'),
	   ('ITMBROKER', 'ITMITM1', CURRENT USER, CURRENT TIMESTAMP, 'parser'),
	   ('ITMBROKER', 'ITMITM1', CURRENT USER, CURRENT TIMESTAMP, 'port'),
	   ('ITMBROKER', 'ITMITM1', CURRENT USER, CURRENT TIMESTAMP, 'routing'),
	   ('ITMBROKER', 'ITMITM1', CURRENT USER, CURRENT TIMESTAMP, 'rpg');

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm-prima', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
	VALUES ('req-core.itm-prima', 1, '/data/body', '/data/body', 'req-core.itm', '1');
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    VALUES 
        ('req-core.itm-prima', 1, 'tellerComplete', '${getParamValue("device_teller_map", head.group."!value".trim() + "_PRIMA1" + msg.timeLocalTransaction."!value".substring(0,2), "|||| ")}', 10),
        ('req-core.itm-prima', 1, 'ICDEVN', '${tar.tellerComplete."!value".split("\\|", -1)[3]}', 20),
        ('req-core.itm-prima', 1, 'TLBCUD', '${tar.tellerComplete."!value".split("\\|", -1)[2]}', 20),
        ('req-core.itm-prima', 1, 'TLBID', '${tar.tellerComplete."!value".split("\\|", -1)[0]}', 20),
        ('req-core.itm-prima', 1, 'dspDeviceName', '${tar.tellerComplete."!value".split("\\|", -1)[3]}', 20),
        ('req-core.itm-prima', 1, 'dspTerminalId', '${tar.tellerComplete."!value".split("\\|", -1)[1]}', 20),
        ('req-core.itm-prima', 1, 'dspUserId', '${tar.tellerComplete."!value".split("\\|", -1)[0]}', 20);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm.0200.411000.001BCABCA', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
	VALUES ('req-core.itm.0200.411000.001BCABCA', 1, '/data/body', '/data/body', 'req-core.itm-prima', '1');
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    VALUES 
        ('req-core.itm.0200.411000.001BCABCA', 1, '@', 'dtree("CHARGES", "!group")', 10),
        ('req-core.itm.0200.411000.001BCABCA', 1, 'TLBF01', '${msg.fromAccount}', 20),
        ('req-core.itm.0200.411000.001BCABCA', 1, 'TLBF02', '${msg.amountTransaction."!number"}', 20),
        ('req-core.itm.0200.411000.001BCABCA', 1, 'TLBF03', '${getParamValueWithError("coa", "prima-liability", "error:92Unknown coa")}', 20),
        ('req-core.itm.0200.411000.001BCABCA', 1, 'TLBF04', '${getCharge(1)?getCharge(1).toBigDecimal()*100:0}', 20),
        ('req-core.itm.0200.411000.001BCABCA', 1, 'TLBF07', '${getParamValueWithError("coa", "prima-liability", "error:92Unknown coa")}', 20),
        ('req-core.itm.0200.411000.001BCABCA', 1, 'TLBF08', '${getCharge(2)?getCharge(2).toBigDecimal()*100:0}', 20),
        ('req-core.itm.0200.411000.001BCABCA', 1, 'TLBF15', '${getParamValueWithError("coa", "prima-liability", "error:92Unknown coa")}', 20),
        ('req-core.itm.0200.411000.001BCABCA', 1, 'TLBF17', '${tar.TLBF04."!value".toBigDecimal() + tar.TLBF08."!value".toBigDecimal()}', 30);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('req-core.itm.0200.412000.001BCABCA', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    VALUES ('req-core.itm.0200.412000.001BCABCA', 1, '/data/body', '/data/body', 'req-core.itm.0200.411000.001BCABCA', '1');

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('res-core.itm.0200.411000.001BCABCA', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    VALUES ('res-core.itm.0200.411000.001BCABCA', 1, '/data/body', '/data/body', 'res-core.itm.0200', '1');
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    VALUES 
    ('res-core.itm.0200.411000.001BCABCA', 1, 'additionalDataPrivate', '${msg.SNAME_F1}', null),
    ('res-core.itm.0200.411000.001BCABCA', 1, 'additionalResponseData', '${decimalFormat("0", (msg.AMT2_F1."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.AMT2_F1."!number"*100)).padLeft(12, "0")}${decimalFormat("0", (msg.AMT1_F1."!number"*100)).length()>12?"999999999999":decimalFormat("0", (msg.AMT1_F1."!number"*100)).padLeft(12, "0")}', null);

INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('res-core.itm.0200.412000.001BCABCA', '[itm]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    VALUES ('res-core.itm.0200.412000.001BCABCA', 1, '/data/body', '/data/body', 'res-core.itm.0200.411000.001BCABCA', '1');