digiposgw

insert into t_security_endpoint_type(active, jhi_label) values(1, 'Aucun');
insert into t_security_endpoint_type(active, jhi_label) values(1, 'Authentification OTP');
insert into t_security_endpoint_type(active, jhi_label) values(1, 'Authentification Empreinte digitale');
insert into t_security_endpoint_type(active, jhi_label) values(1, 'Authentification faciale');
insert into t_security_endpoint_type(active, jhi_label) values(1, 'Authentification vocale');

insert into t_message_endpoint_type(active, jhi_label) values(1, 'ISO8583(JPOS)');
insert into t_message_endpoint_type(active, jhi_label) values(1, 'HTTP');
insert into t_message_endpoint_type(active, jhi_label) values(1, 'HTTPS');
insert into t_message_endpoint_type(active, jhi_label) values(1, 'SOCKET');
insert into t_message_endpoint_type(active, jhi_label) values(1, 'SOCKET SSL');
insert into t_message_endpoint_type(active, jhi_label) values(1, 'FTP');
insert into t_message_endpoint_type(active, jhi_label) values(1, 'SFTP');

insert into t_meansofpayment_type(active, jhi_label) values(1, 'Compte bancaire');
insert into t_meansofpayment_type(active, jhi_label) values(1, 'Carte bancaire');
insert into t_meansofpayment_type(active, jhi_label) values(1, 'Mobile Money');
insert into t_meansofpayment_type(active, jhi_label) values(1, 'Airtime');
insert into t_meansofpayment_type(active, jhi_label) values(1, 'Wallet');

insert into t_beneficiary_type(active, jhi_label) values(1, 'Compte bancaire');
insert into t_beneficiary_type(active, jhi_label) values(1, 'Carte bancaire');
insert into t_beneficiary_type(active, jhi_label) values(1, 'Mobile Money');
insert into t_beneficiary_type(active, jhi_label) values(1, 'Airtime');
insert into t_beneficiary_type(active, jhi_label) values(1, 'Wallet');

insert into t_client_application(code, jhi_label, callbackUsed, callbackUrl) values('APP001', 'APP001', 0, 'Aucun');

insert into t_partner_type(jhi_label) values('Banque');
insert into t_partner_type(jhi_label) values('Micro-finance');
insert into t_partner_type(jhi_label) values('Operateur Mobile');
insert into t_partner_type(jhi_label) values('Services financiers');
insert into t_partner_type(jhi_label) values('Assurance');
insert into t_partner_type(jhi_label) values('E-commerce');
insert into t_partner_type(jhi_label) values('Autres');

insert into t_device_type(jhi_label) values('TYPE1');
insert into t_device_type(jhi_label) values('TYPE2');

insert into t_protocol(code, jhi_label, iso_version, description) values('P001', 'ISO 8583:1987', 1, 'ISO 8583:1987');
insert into t_protocol(code, jhi_label, iso_version, description) values('P002', 'ISO 8583:1993', 2, 'ISO 8583:1993');
insert into t_protocol(code, jhi_label, iso_version, description) values('P003', 'ISO 8583:2003', 3, 'ISO 8583:2003');

insert into t_message_type(active, jhi_label) values(1, 'CASH_IN');
insert into t_message_type(active, jhi_label) values(1, 'CASH_OUT');
insert into t_message_type(active, jhi_label) values(1, 'BILL_PAYMENT');
insert into t_message_type(active, jhi_label) values(1, 'MERCHANT_PAYMENT');
insert into t_message_type(active, jhi_label) values(1, 'ONLINE_PAYMENT');
insert into t_message_type(active, jhi_label) values(1, 'CREDIT');
insert into t_message_type(active, jhi_label) values(1, 'DEBIT');
insert into t_message_type(active, jhi_label) values(1, 'TRANSFER');
insert into t_message_type(active, jhi_label) values(1, 'MoMo2MoMo');
insert into t_message_type(active, jhi_label) values(1, 'MoMo2Airtime');
insert into t_message_type(active, jhi_label) values(1, 'MoMo2Bank');
insert into t_message_type(active, jhi_label) values(1, 'MoMo2Card');
insert into t_message_type(active, jhi_label) values(1, 'MoMo2Wallet');
insert into t_message_type(active, jhi_label) values(1, 'Airtime2MoMo');
insert into t_message_type(active, jhi_label) values(1, 'Airtime2Airtime');
insert into t_message_type(active, jhi_label) values(1, 'Airtime2Bank');
insert into t_message_type(active, jhi_label) values(1, 'Airtime2Card');
insert into t_message_type(active, jhi_label) values(1, 'Airtime2Wallet');
insert into t_message_type(active, jhi_label) values(1, 'Bank2MoMo');
insert into t_message_type(active, jhi_label) values(1, 'Bank2Airtime');
insert into t_message_type(active, jhi_label) values(1, 'Bank2Bank');
insert into t_message_type(active, jhi_label) values(1, 'Bank2Card');
insert into t_message_type(active, jhi_label) values(1, 'Bank2Wallet');
insert into t_message_type(active, jhi_label) values(1, 'Card2MoMo');
insert into t_message_type(active, jhi_label) values(1, 'Card2Airtime');
insert into t_message_type(active, jhi_label) values(1, 'Card2Bank');
insert into t_message_type(active, jhi_label) values(1, 'Card2Card');
insert into t_message_type(active, jhi_label) values(1, 'Card2Wallet');
insert into t_message_type(active, jhi_label) values(1, 'Wallet2MoMo');
insert into t_message_type(active, jhi_label) values(1, 'Wallet2Airtime');
insert into t_message_type(active, jhi_label) values(1, 'Wallet2Bank');
insert into t_message_type(active, jhi_label) values(1, 'Wallet2Card');
insert into t_message_type(active, jhi_label) values(1, 'Wallet2Wallet');
insert into t_message_type(active, jhi_label) values(1, 'Card Request');
insert into t_message_type(active, jhi_label) values(1, 'Gadget Request');
insert into t_message_type(active, jhi_label) values(1, 'Loan Application');
insert into t_message_type(active, jhi_label) values(1, 'Loan Repayment');

insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0100','Authorization Request', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0110','Authorization Response', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0120','Authorization Advice', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0121','Authorization Advice Repeat', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0130','Issuer Response to Authorization Advice', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0200','Acquirer Financial Request', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0210','Issuer Response to Financial Request', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0220','Acquirer Financial Advice', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0221','Acquirer Financial Advice Repeat', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0230','Issuer Response', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0320','Batch Upload', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0330','Batch Upload Response', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0400','Acquirer Reversal Request', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0510','Batch Settlement response', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0800','Network Management Request', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0810','Network Management Response', 1, null);
insert into t_iso_message(message_code, jhi_label, protocol_id, message_type_id) values('0820','Network Management Advice', 1, null);

insert into t_iso_data_field(number, type, usage) values(1, 'b 64', 'Second Bitmap');
insert into t_iso_data_field(number, type, usage) values(2, 'n ..19', 'Primary account number (PAN)');
insert into t_iso_data_field(number, type, usage) values(3, 'n 6', 'Processing code');
insert into t_iso_data_field(number, type, usage) values(4, 'n 12', 'Amount, transaction');
insert into t_iso_data_field(number, type, usage) values(5, 'n 12', 'Amount, settlement');
insert into t_iso_data_field(number, type, usage) values(6, 'n 12', 'Amount, cardholder billing');
insert into t_iso_data_field(number, type, usage) values(7, 'n 10', 'Transmission date & time');
insert into t_iso_data_field(number, type, usage) values(8, 'n 8', 'Amount, cardholder billing fee');
insert into t_iso_data_field(number, type, usage) values(9, 'n 8', 'Conversion rate, settlement');
insert into t_iso_data_field(number, type, usage) values(10, 'n 8', 'Conversion rate, cardholder billing');
insert into t_iso_data_field(number, type, usage) values(11, 'n 6', 'System trace audit number (STAN)');
insert into t_iso_data_field(number, type, usage) values(12, 'n 6', 'Local transaction time (hhmmss)');
insert into t_iso_data_field(number, type, usage) values(13, 'n 4', 'Local transaction date (MMDD)');
insert into t_iso_data_field(number, type, usage) values(14, 'n 4', 'Expiration date');
insert into t_iso_data_field(number, type, usage) values(15, 'n 4', 'Settlement date');
insert into t_iso_data_field(number, type, usage) values(16, 'n 4', 'Currency conversion date');
insert into t_iso_data_field(number, type, usage) values(17, 'n 4', 'Capture date');
insert into t_iso_data_field(number, type, usage) values(18, 'n 4', 'Merchant type, or merchant category code');
insert into t_iso_data_field(number, type, usage) values(19, 'n 3', 'Acquiring institution (country code)');
insert into t_iso_data_field(number, type, usage) values(20, 'n 3', 'PAN extended (country code)');
insert into t_iso_data_field(number, type, usage) values(21, 'n 3', 'Forwarding institution (country code)');
insert into t_iso_data_field(number, type, usage) values(22, 'n 3', 'Point of service entry mode');
insert into t_iso_data_field(number, type, usage) values(23, 'n 3', 'Application PAN sequence number');
insert into t_iso_data_field(number, type, usage) values(24, 'n 3', 'Function code (ISO 8583:1993), or network international identifier (NII)');
insert into t_iso_data_field(number, type, usage) values(25, 'n 2', 'Point of service condition code');
insert into t_iso_data_field(number, type, usage) values(26, 'n 2', 'Point of service capture code');
insert into t_iso_data_field(number, type, usage) values(27, 'n 1', 'Authorizing identification response length');
insert into t_iso_data_field(number, type, usage) values(28, 'x+n 8', 'Amount, transaction fee');
insert into t_iso_data_field(number, type, usage) values(29, 'x+n 8', 'Amount, settlement fee');
insert into t_iso_data_field(number, type, usage) values(30, 'x+n 8', 'Amount, transaction processing fee');
insert into t_iso_data_field(number, type, usage) values(31, 'x+n 8', 'Amount, settlement processing fee');
insert into t_iso_data_field(number, type, usage) values(32, 'n ..11', 'Acquiring institution identification code');
insert into t_iso_data_field(number, type, usage) values(33, 'n ..11', 'Forwarding institution identification code');
insert into t_iso_data_field(number, type, usage) values(34, 'ns ..28', 'Primary account number, extended');
insert into t_iso_data_field(number, type, usage) values(35, 'z ..37', 'Track 2 data');
insert into t_iso_data_field(number, type, usage) values(36, 'n ...104', 'Track 3 data');
insert into t_iso_data_field(number, type, usage) values(37, 'an 12', 'Retrieval reference number');
insert into t_iso_data_field(number, type, usage) values(38, 'an 6', 'Authorization identification response');
insert into t_iso_data_field(number, type, usage) values(39, 'an 2', 'Response code');
insert into t_iso_data_field(number, type, usage) values(40, 'an 3', 'Service restriction code');
insert into t_iso_data_field(number, type, usage) values(41, 'ans 8', 'Card acceptor terminal identification');
insert into t_iso_data_field(number, type, usage) values(42, 'ans 15', 'Card acceptor identification code');
insert into t_iso_data_field(number, type, usage) values(43, 'ans 40', 'Card acceptor name/location (1-23 street address, 24-36 city, 37-38 state, 39-40 country)');
insert into t_iso_data_field(number, type, usage) values(44, 'an ..25', 'Additional response data');
insert into t_iso_data_field(number, type, usage) values(45, 'an ..76', 'Track 1 data');
insert into t_iso_data_field(number, type, usage) values(46, 'an ...999', 'Additional data (ISO)');
insert into t_iso_data_field(number, type, usage) values(47, 'an ...999', 'Additional data (national)');
insert into t_iso_data_field(number, type, usage) values(48, 'an ...999', 'Additional data (private)');
insert into t_iso_data_field(number, type, usage) values(49, 'a or n 3', 'Currency code, transaction');
insert into t_iso_data_field(number, type, usage) values(50, 'a or n 3', 'Currency code, settlement');
insert into t_iso_data_field(number, type, usage) values(51, 'a or n 3', 'Currency code, cardholder billing');
insert into t_iso_data_field(number, type, usage) values(52, 'b 64', 'Personal identification number data');
insert into t_iso_data_field(number, type, usage) values(53, 'n 16', 'Security related control information');
insert into t_iso_data_field(number, type, usage) values(54, 'an ...120', 'Additional amounts');
insert into t_iso_data_field(number, type, usage) values(55, 'ans ...999', 'ICC data – EMV having multiple tags');
insert into t_iso_data_field(number, type, usage) values(56, 'ans ...999', 'Reserved (ISO)');
insert into t_iso_data_field(number, type, usage) values(57, 'ans ...999', 'Reserved (national)');
insert into t_iso_data_field(number, type, usage) values(58, 'ans ...999', ' ');
insert into t_iso_data_field(number, type, usage) values(59, 'ans ...999', '');
insert into t_iso_data_field(number, type, usage) values(60, 'ans ...999', 'Reserved (national) (e.g. settlement request: batch number, advice transactions: original transaction amount, batch upload: original MTI plus original RRN plus original STAN, etc)');
insert into t_iso_data_field(number, type, usage) values(61, 'ans ...999', 'Reserved (private) (e.g. CVV2/service code   transactions)');
insert into t_iso_data_field(number, type, usage) values(62, 'ans ...999', 'Reserved (private) (e.g. transactions: invoice number, key exchange transactions: TPK key, etc.)');
insert into t_iso_data_field(number, type, usage) values(63, 'ans ...999', 'Reserved (private)');
insert into t_iso_data_field(number, type, usage) values(64, 'b 64', 'Message authentication code (MAC)');
insert into t_iso_data_field(number, type, usage) values(65, 'b 1', 'Extended bitmap indicator');
insert into t_iso_data_field(number, type, usage) values(66, 'n 1', 'Settlement code');
insert into t_iso_data_field(number, type, usage) values(67, 'n 2', 'Extended payment code');
insert into t_iso_data_field(number, type, usage) values(68, 'n 3', 'Receiving institution country code');
insert into t_iso_data_field(number, type, usage) values(69, 'n 3', 'Settlement institution country code');
insert into t_iso_data_field(number, type, usage) values(70, 'n 3', 'Network management information code');
insert into t_iso_data_field(number, type, usage) values(71, 'n 4', 'Message number');
insert into t_iso_data_field(number, type, usage) values(72, 'n 4', 'Last message''s number');
insert into t_iso_data_field(number, type, usage) values(73, 'n 6', 'Action date (YYMMDD)');
insert into t_iso_data_field(number, type, usage) values(74, 'n 10', 'Number of credits');
insert into t_iso_data_field(number, type, usage) values(75, 'n 10', 'Credits, reversal number');
insert into t_iso_data_field(number, type, usage) values(76, 'n 10', 'Number of debits');
insert into t_iso_data_field(number, type, usage) values(77, 'n 10', 'Debits, reversal number');
insert into t_iso_data_field(number, type, usage) values(78, 'n 10', 'Transfer number');
insert into t_iso_data_field(number, type, usage) values(79, 'n 10', 'Transfer, reversal number');
insert into t_iso_data_field(number, type, usage) values(80, 'n 10', 'Number of inquiries');
insert into t_iso_data_field(number, type, usage) values(81, 'n 10', 'Number of authorizations');
insert into t_iso_data_field(number, type, usage) values(82, 'n 12', 'Credits, processing fee amount');
insert into t_iso_data_field(number, type, usage) values(83, 'n 12', 'Credits, transaction fee amount');
insert into t_iso_data_field(number, type, usage) values(84, 'n 12', 'Debits, processing fee amount');
insert into t_iso_data_field(number, type, usage) values(85, 'n 12', 'Debits, transaction fee amount');
insert into t_iso_data_field(number, type, usage) values(86, 'n 16', 'Total amount of credits');
insert into t_iso_data_field(number, type, usage) values(87, 'n 16', 'Credits, reversal amount');
insert into t_iso_data_field(number, type, usage) values(88, 'n 16', 'Total amount of debits');
insert into t_iso_data_field(number, type, usage) values(89, 'n 16', 'Debits, reversal amount');
insert into t_iso_data_field(number, type, usage) values(90, 'n 42', 'Original data elements');
insert into t_iso_data_field(number, type, usage) values(91, 'an 1', 'File update code');
insert into t_iso_data_field(number, type, usage) values(92, 'an 2', 'File security code');
insert into t_iso_data_field(number, type, usage) values(93, 'an 5', 'Response indicator');
insert into t_iso_data_field(number, type, usage) values(94, 'an 7', 'Service indicator');
insert into t_iso_data_field(number, type, usage) values(95, 'an 42', 'Replacement amounts');
insert into t_iso_data_field(number, type, usage) values(96, 'b 64', 'Message security code');
insert into t_iso_data_field(number, type, usage) values(97, 'x+n 16', 'Net settlement amount');
insert into t_iso_data_field(number, type, usage) values(98, 'ans 25', 'Payee');
insert into t_iso_data_field(number, type, usage) values(99, 'n ..11', 'Settlement institution identification code');
insert into t_iso_data_field(number, type, usage) values(100, 'n ..11', 'Receiving institution identification code');
insert into t_iso_data_field(number, type, usage) values(101, 'ans ..17', 'File name');
insert into t_iso_data_field(number, type, usage) values(102, 'ans ..28', 'Account identification 1');
insert into t_iso_data_field(number, type, usage) values(103, 'ans ..28', 'Account identification 2');
insert into t_iso_data_field(number, type, usage) values(104, 'ans ...100', 'Transaction description');
insert into t_iso_data_field(number, type, usage) values(105, 'ans ...999', 'Reserved for ISO use');
insert into t_iso_data_field(number, type, usage) values(106, 'ans ...999', 'Reserved for ISO use');
insert into t_iso_data_field(number, type, usage) values(107, 'ans ...999', 'Reserved for ISO use');
insert into t_iso_data_field(number, type, usage) values(108, 'ans ...999', 'Reserved for ISO use');
insert into t_iso_data_field(number, type, usage) values(109, 'ans ...999', 'Reserved for ISO use');
insert into t_iso_data_field(number, type, usage) values(110, 'ans ...999', 'Reserved for ISO use');
insert into t_iso_data_field(number, type, usage) values(111, 'ans ...999', 'Reserved for ISO use');
insert into t_iso_data_field(number, type, usage) values(112, 'ans ...999', 'Reserved for national use');
insert into t_iso_data_field(number, type, usage) values(113, 'ans ...999', 'Reserved for national use');
insert into t_iso_data_field(number, type, usage) values(114, 'ans ...999', 'Reserved for national use');
insert into t_iso_data_field(number, type, usage) values(115, 'ans ...999', 'Reserved for national use');
insert into t_iso_data_field(number, type, usage) values(116, 'ans ...999', 'Reserved for national use');
insert into t_iso_data_field(number, type, usage) values(117, 'ans ...999', 'Reserved for national use');
insert into t_iso_data_field(number, type, usage) values(118, 'ans ...999', 'Reserved for national use');
insert into t_iso_data_field(number, type, usage) values(119, 'ans ...999', 'Reserved for national use');
insert into t_iso_data_field(number, type, usage) values(120, 'ans ...999', 'Reserved for private use');
insert into t_iso_data_field(number, type, usage) values(121, 'ans ...999', 'Reserved for private use');
insert into t_iso_data_field(number, type, usage) values(122, 'ans ...999', 'Reserved for private use');
insert into t_iso_data_field(number, type, usage) values(123, 'ans ...999', 'Reserved for private use');
insert into t_iso_data_field(number, type, usage) values(124, 'ans ...999', 'Reserved for private use');
insert into t_iso_data_field(number, type, usage) values(125, 'ans ...999', 'Reserved for private use');
insert into t_iso_data_field(number, type, usage) values(126, 'ans ...999', 'Reserved for private use');
insert into t_iso_data_field(number, type, usage) values(127, 'ans ...999', 'Reserved for private use');
insert into t_iso_data_field(number, type, usage) values(128, 'b 64', 'Message authentication code');

insert into t_responce_code(code, meaning) values('00', 'Successful approval/completion or that VIP PIN verification is valid');
insert into t_responce_code(code, meaning) values('01', 'Refer to card issuer');
insert into t_responce_code(code, meaning) values('02', 'Refer to card issuer, special condition');
insert into t_responce_code(code, meaning) values('03', 'Invalid merchant or service provider');
insert into t_responce_code(code, meaning) values('04', 'Pickup');
insert into t_responce_code(code, meaning) values('05', 'Do not honor');
insert into t_responce_code(code, meaning) values('06', 'General error');
insert into t_responce_code(code, meaning) values('07', 'Pickup card, special condition (other than lost/stolen card)');
insert into t_responce_code(code, meaning) values('08', 'Honor with identification');
insert into t_responce_code(code, meaning) values('09', 'Request in progress');
insert into t_responce_code(code, meaning) values('10', 'Partial approval');
insert into t_responce_code(code, meaning) values('11', 'VIP approval');
insert into t_responce_code(code, meaning) values('12', 'Invalid transaction');
insert into t_responce_code(code, meaning) values('13', 'Invalid amount (currency conversion field overflow) or amount exceeds maximum for card program');
insert into t_responce_code(code, meaning) values('14', 'Invalid account number (no such number)');
insert into t_responce_code(code, meaning) values('15', 'No such issuer');
insert into t_responce_code(code, meaning) values('16', 'Insufficient funds');
insert into t_responce_code(code, meaning) values('17', 'Customer cancellation');
insert into t_responce_code(code, meaning) values('19', 'Re-enter transaction');
insert into t_responce_code(code, meaning) values('20', 'Invalid response');
insert into t_responce_code(code, meaning) values('21', 'No action taken (unable to back out prior transaction)');
insert into t_responce_code(code, meaning) values('22', 'Suspected Malfunction');
insert into t_responce_code(code, meaning) values('25', 'Unable to locate record in file, or account number is missing from the inquiry');
insert into t_responce_code(code, meaning) values('28', 'File is temporarily unavailable');
insert into t_responce_code(code, meaning) values('30', 'Format error');
insert into t_responce_code(code, meaning) values('41', 'Merchant should retain card (card reported lost)');
insert into t_responce_code(code, meaning) values('43', 'Merchant should retain card (card reported stolen)');
insert into t_responce_code(code, meaning) values('51', 'Insufficient funds');
insert into t_responce_code(code, meaning) values('52', 'No checking account');
insert into t_responce_code(code, meaning) values('53', 'No savings account');
insert into t_responce_code(code, meaning) values('54', 'Expired card');
insert into t_responce_code(code, meaning) values('55', 'Incorrect PIN');
insert into t_responce_code(code, meaning) values('57', 'Transaction not permitted to cardholder');
insert into t_responce_code(code, meaning) values('58', 'Transaction not allowed at terminal');
insert into t_responce_code(code, meaning) values('59', 'Suspected fraud');
insert into t_responce_code(code, meaning) values('61', 'Activity amount limit exceeded');
insert into t_responce_code(code, meaning) values('62', 'Restricted card (for example, in country exclusion table)');
insert into t_responce_code(code, meaning) values('63', 'Security violation');
insert into t_responce_code(code, meaning) values('65', 'Activity count limit exceeded');
insert into t_responce_code(code, meaning) values('68', 'Response received too late');
insert into t_responce_code(code, meaning) values('75', 'Allowable number of PIN-entry tries exceeded');
insert into t_responce_code(code, meaning) values('76', 'Unable to locate previous message (no match on retrieval reference number)');
insert into t_responce_code(code, meaning) values('77', 'Previous message located for a repeat or reversal, but repeat or reversal data are inconsistent with original message');
insert into t_responce_code(code, meaning) values('78', '’Blocked, first used’—The transaction is from a new cardholder, and the card has not been properly unblocked.');
insert into t_responce_code(code, meaning) values('80', 'Visa transactions: credit issuer unavailable. Private label and check acceptance: Invalid date');
insert into t_responce_code(code, meaning) values('81', 'PIN cryptographic error found (error found by VIC security module during PIN decryption)');
insert into t_responce_code(code, meaning) values('82', 'Negative CAM, dCVV, iCVV, or CVV results');
insert into t_responce_code(code, meaning) values('83', 'Unable to verify PIN');
insert into t_responce_code(code, meaning) values('85', 'No reason to decline a request for account number verification, address verification, CVV2 verification; or a credit voucher or merchandise return');
insert into t_responce_code(code, meaning) values('91', 'Issuer unavailable or switch inoperative (STIP not applicable or available for this transaction)');
insert into t_responce_code(code, meaning) values('92', 'Destination cannot be found for routing');
insert into t_responce_code(code, meaning) values('93', 'Transaction cannot be completed, violation of law');
insert into t_responce_code(code, meaning) values('94', 'Duplicate transmission');
insert into t_responce_code(code, meaning) values('95', 'Reconcile error');
insert into t_responce_code(code, meaning) values('96', 'System malfunction, System malfunction or certain field error conditions');
insert into t_responce_code(code, meaning) values('B1', 'Surcharge amount not permitted on Visa cards (U.S. acquirers only)');
insert into t_responce_code(code, meaning) values('N0', 'Force STIP');
insert into t_responce_code(code, meaning) values('N3', 'Cash service not available');
insert into t_responce_code(code, meaning) values('N4', 'Cashback request exceeds issuer limit');
insert into t_responce_code(code, meaning) values('N7', 'Decline for CVV2 failure');
insert into t_responce_code(code, meaning) values('P2', 'Invalid biller information');
insert into t_responce_code(code, meaning) values('P5', 'PIN change/unblock request declined');
insert into t_responce_code(code, meaning) values('P6', 'Unsafe PIN');
insert into t_responce_code(code, meaning) values('Q1', 'Card authentication failed');
insert into t_responce_code(code, meaning) values('R0', 'Stop payment order');
insert into t_responce_code(code, meaning) values('R1', 'Revocation of authorization order');
insert into t_responce_code(code, meaning) values('R3', 'Revocation of all authorizations order');
insert into t_responce_code(code, meaning) values('XA', 'Forward to issuer');
insert into t_responce_code(code, meaning) values('XD', 'Forward to issuer');
insert into t_responce_code(code, meaning) values('Z3', 'Unable to go online');