INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, TIMESTAMP)
	VALUES ('dck-13000', 'Dummy Core Konven', 0, CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID)
	VALUES ('dck-13000', 'incoming', 'dsp');
INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID)
	VALUES ('dck-13000', 'outgoing', 'dsp-response');

INSERT INTO MWCONFIG.SERVER_PORT (ADAPTOR_ID, PORT, SERVER, GROUP)
	VALUES ('dck-13000', 13000, 'dummy-server', 'dck');

INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
	VALUES ('dummy-res.dck.master', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
	VALUES ('dummy-res.dck.master', 1, '/data/body', '/data/body', NULL, NULL);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
	VALUES ('dummy-res.dck.master', 1, '!CorrelId', '${head.CorrelId}'),
		   ('dummy-res.dck.master', 1, '!sid', '${head.sid}'),
		   ('dummy-res.dck.master', 1, '!connid', '${head.connid}'),
		   ('dummy-res.dck.master', 1, '!group', '${head.group}'),
		   ('dummy-res.dck.master', 1, '!source', '${head.source}'),
		   ('dummy-res.dck.master', 1, '!dir', 'O'),
		   ('dummy-res.dck.master', 1, '!reqtimestamp', '${head.reqtimestamp}'),
		   ('dummy-res.dck.master', 1, 'dspHeaderType', '*SOKI'),
		   ('dummy-res.dck.master', 1, 'dspSocketNumber', '1'),
		   ('dummy-res.dck.master', 1, 'dspPortNumber', '13000'),
		   ('dummy-res.dck.master', 1, 'dspFiller1', '40'),
		   ('dummy-res.dck.master', 1, 'dspHeaderLength', '213'),
		   ('dummy-res.dck.master', 1, 'dspVersionNumber', '0200'),
		   ('dummy-res.dck.master', 1, 'dspHeaderFormatId', '*DSP'),
		   ('dummy-res.dck.master', 1, 'dspDataFormatId', '${msg.dspDataFormatId}'),
		   ('dummy-res.dck.master', 1, 'dspSourceId', '${msg.dspSourceId}'),
		   ('dummy-res.dck.master', 1, 'dspDestinationId', 'DQAXISIN'),
		   ('dummy-res.dck.master', 1, 'dspRoutingNumber', '00'),
		   ('dummy-res.dck.master', 1, 'dspMessageStatus', '/-------'),
		   ('dummy-res.dck.master', 1, 'dspBankIdNumber', '${msg.dspBankIdNumber}'),
		   ('dummy-res.dck.master', 1, 'dspNode', '${msg.dspNode}'),
		   ('dummy-res.dck.master', 1, 'dspExchangeId', '000000002F07001F4040C3D4D5E2C2D9F0F0F0F1'),
		   ('dummy-res.dck.master', 1, 'dspScenarioNumber', '${msg.dspScenarioNumber}'),
		   ('dummy-res.dck.master', 1, 'dspTransactionCode', '${msg.dspTransactionCode}'),
		   ('dummy-res.dck.master', 1, 'dspRetrievalReferenceNumber', '1234567890123456789012'),
		   ('dummy-res.dck.master', 1, 'dspNumberOfRecordsToBeLoaded', '10'),
		   ('dummy-res.dck.master', 1, 'dspNumberOfErrorsToBeLoaded', '10'),
		   ('dummy-res.dck.master', 1, 'dspUserId', '${msg.dspUserId}'),
		   ('dummy-res.dck.master', 1, 'dspTerminalId', '${msg.dspTerminalId}');

INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
	VALUES ('dummy-res.dck.master-abcs', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
	VALUES ('dummy-res.dck.master-abcs', 1, '/data/body', '/data/body', 'dummy-res.dck.master', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
	VALUES ('dummy-res.dck.master-abcs', 1, 'ICHEAD', '*SOKR'),
		   ('dummy-res.dck.master-abcs', 1, 'ICRTRQ', 'DQICRTTEL'),
		   ('dummy-res.dck.master-abcs', 1, 'ICDEVN', '${msg.ICDEVN}'),
		   ('dummy-res.dck.master-abcs', 1, 'ICID', '12345'),
		   ('dummy-res.dck.master-abcs', 1, 'ICCOMQ', 'DQAXISIN'),
		   ('dummy-res.dck.master-abcs', 1, 'TMTIMIN', '${new java.text.SimpleDateFormat("HHmmss").format(new Date())}'),
		   ('dummy-res.dck.master-abcs', 1, 'TMTXTYP', '${msg.TMTXTYP}'),
		   ('dummy-res.dck.master-abcs', 1, 'ICEOM', '${msg.ICEOM}'),
		   ('dummy-res.dck.master-abcs', 1, 'tellerID', '${msg.TLBID}'),
		   ('dummy-res.dck.master-abcs', 1, 'sequenceNumber', '${msg.TLBJSN}');

INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
	VALUES ('dummy-res.dck.master-abcs-89', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
	VALUES ('dummy-res.dck.master-abcs-89', 1, '/data/body', '/data/body', 'dummy-res.dck.master', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
	VALUES ('dummy-res.dck.master-abcs-89', 1, 'responseCode_89', '89'),
		   ('dummy-res.dck.master-abcs-89', 1, 'responseHeader_89', '89'),
		   ('dummy-res.dck.master-abcs-89', 1, 'responseSubHeader_89', 'F1');

INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
	VALUES ('dummy-res.dck.master-abcs-F1', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
	VALUES ('dummy-res.dck.master-abcs-F1', 1, '/data/body', '/data/body', 'dummy-res.dck.master', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
	VALUES ('dummy-res.dck.master-abcs-F1', 1, 'responseCode_F1', 'F1'),
		   ('dummy-res.dck.master-abcs-F1', 1, 'responseHeader_F1', 'F1'),
		   ('dummy-res.dck.master-abcs-F1', 1, 'TLXMNE_F1', 'INQ');

INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1, '/data/body', '/data/body', 'dummy-res.dck.master-abcs', 1),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-89', 1),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-F1', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT)
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1, 'dspMessageLength', '741'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1, 'ICLEN', '75'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1, 'abcsResponses', '89 F1'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, '!multicodex_suffix_1', '_89'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'ACCTNO_89', '1601500028153'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'ACTYPE_89', 'S'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'SNAME_89', 'SUCIPTO'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'CFSSNO_89', '1055101502651003'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'STATUS_89', '1'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'CBAL_89', '27260729942.98'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'COLECT_89', '27260729942.98'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'WHYTD_89', '138731996.73'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'WHTDY_89', '8962430'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'ACCRU2_89', '44812159'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'NETAMT_89', '27296579671.98'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'PBBAL_89', '3348239020.92'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'TLNBSR_89', '3405'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'UNPAMT_89', '23912490922.06'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'UNPITM_89', '66'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'DDSIC1_89', 'D5'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'DDSIC2_89', 'D5'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'DDSIC3_89', 'D5'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'DDSIC4_89', 'D5'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'AVLBAL_89', '27260729942.98'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2, 'MINBLM_89', '50000'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, '!multicodex_suffix_2', '_F1'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, 'SNAME_F1', 'SUCIPTO'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, 'AMT1_F1', '27260729942.98'),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3, 'AMT2_F1', '27260729942.98');


INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP) 
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', NULL, '[dck]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 1, '/data/body', '/data/body', 'dummy-res.dck.master-abcs', 1),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-F1', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 1, 'ICLEN', '98', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 1, 'dspMessageLength', '349', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, '!multicodex_suffix_1', '_F1', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'ACC_F1', '29816151200', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'AMT1_F1', '298161512', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'AMT2_F1', '298161512', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'SNAME_F1', 'NASABAH A000008', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005012', 2, 'TLXMNE_F1', 'PBK', NULL);


INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP) 
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', NULL, '[dck]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 1, '/data/body', '/data/body', 'dummy-res.dck.master-abcs', 1),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-F1', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 1, 'ICLEN', '98', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 1, 'dspMessageLength', '349', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, '!multicodex_suffix_1', '_F1', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'ACC_F1', '29816151200', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'AMT1_F1', '298161512', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'AMT2_F1', '298161512', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'SNAME_F1', 'NASABAH A000008', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005013', 2, 'TLXMNE_F1', 'PBK', NULL);

INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY, TIMESTAMP) 
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', NULL, '[dck]', CURRENT USER, CURRENT TIMESTAMP);
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 1, '/data/body', '/data/body', 'dummy-res.dck.master-abcs', 1),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, '/data/body', '/data/body', 'dummy-res.dck.master-abcs-F1', 1);
INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 1, 'ICLEN', '98', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 1, 'dspMessageLength', '349', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, '!multicodex_suffix_1', '_F1', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'ACC_F1', '29816151200', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'AMT1_F1', '298161512', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'AMT2_F1', '298161512', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'SNAME_F1', 'NASABAH A000008', NULL),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005014', 2, 'TLXMNE_F1', 'PBK', NULL);

INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005002', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005002', 1, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005002', 2, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005002', 3, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3);

INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000007140', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000007140', 1, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000007140', 2, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000007140', 3, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3);

INSERT INTO MWCONFIG.MAPPING (ID, MODIFIED_BY, TIMESTAMP, MODULE)
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005195', CURRENT USER, CURRENT TIMESTAMP, '[dck]');
INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID)
	VALUES ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005195', 1, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 1),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005195', 2, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 2),
		   ('dummy-res.dck.AXISSYSTEMSDNBHD.0000005195', 3, '/data/body', '/data/body', 'dummy-res.dck.AXISSYSTEMSDNBHD.0000005001', 3);
