| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184 |
- 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);
|