08-07-23, 12:17 PM
Website - bilisremitonline.com
Format - .SQL
Size sql file - 5GB
Date - 2023
All Rows - 8kk
INSERT INTO `remittanceupload` (`id`, `dateadded`, `refferencenumber`, `amount`, `currency`, `sfname`, `slname`, `smaname`, `bfname`, `blname`, `bmname`, `address`, `contactno`, `status`, `filename`, `reasonofcancellation`, `lastupdatedate`, `lastupdateby`) VALUES
INSERT INTO `transactions` (`id`, `partnercode`, `partnerid`, `referencenumber`, `amount`, `responseid`, `responsecode`, `responsemessage`, `requeststr`, `reponsestr`, `txndate`, `currency`) VALUES
Format - .SQL
Size sql file - 5GB
Date - 2023
All Rows - 8kk
INSERT INTO `remittanceupload` (`id`, `dateadded`, `refferencenumber`, `amount`, `currency`, `sfname`, `slname`, `smaname`, `bfname`, `blname`, `bmname`, `address`, `contactno`, `status`, `filename`, `reasonofcancellation`, `lastupdatedate`, `lastupdateby`) VALUES
INSERT INTO `transactions` (`id`, `partnercode`, `partnerid`, `referencenumber`, `amount`, `responseid`, `responsecode`, `responsemessage`, `requeststr`, `reponsestr`, `txndate`, `currency`) VALUES
Code:
INSERT INTO `remittanceupload` (`id`, `dateadded`, `refferencenumber`, `amount`, `currency`, `sfname`, `slname`, `smaname`, `bfname`, `blname`, `bmname`, `address`, `contactno`, `status`, `filename`, `reasonofcancellation`, `lastupdatedate`, `lastupdateby`) VALUES
(1310666, '2022-07-01 08:35:51', 'OB-01030062200051', '13,090.00', 'PHP', 'CHERRY JOY PORLAS', 'TANGCAY', ' ', 'JOEMAR N', 'TAPIA', ' ', 'THRU OPTIMUM REMIT PALAWAN EXPRESSMLHUILLIERLBC PADALA', '639914409914', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310667, '2022-07-01 08:35:51', 'OB-01030062200094', '13,000.00', 'PHP', 'SIONELA LOWELA', 'LEGASPI', ' ', 'FEBE', 'PENADO', ' ', 'PALAWANMLHUILLIER PAY ANY BRANCH PROCESS BY OPTIM', '639387769901', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310668, '2022-07-01 08:35:51', 'OB-01030062200607', '12,508.00', 'PHP', 'ODESSALYN P', 'BARREDO', ' ', 'LEANDRO M', 'OLIVAR JR', ' ', 'OR LBC PALAWAN M LHUILLIER PROCESS BY OPTIMUM', '', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310669, '2022-07-01 08:35:51', 'OB-01030062200541', '12,419.00', 'PHP', 'RUTH A', 'BARCOMA', ' ', 'ANASTACIA O', 'BARCUMA', ' ', 'THRU OPTIMUM REMIT PALAWAN EXPRESSMLHUILLIERLBC PADALA', '639265292525', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310670, '2022-07-01 08:35:51', 'OB-01030062200158', '12,391.00', 'PHP', 'KRYSTELLEFRANZ BORRES', 'BODEGAS', ' ', 'PRECY', 'OLIVER', ' ', 'OR PALAWAN M LHUILLIER LBC SABIHIN SA PINAS PROCE', '', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310671, '2022-07-01 08:35:51', 'OB-01030062200534', '12,239.00', 'PHP', 'FEDELYN B', 'BASILIO', ' ', 'JAY ANN', 'VALLES', ' ', 'UNIVERSAL CEBUANAMLHUILLIERPALAWAN PAWNSHOP PROCESS BY OPTIMUM REMIT', '639484659272', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310672, '2022-07-01 08:35:52', 'OB-01030062200587', '10,622.00', 'PHP', 'SHIRLEY J', 'BERNAL', ' ', 'JULIUS J', 'BERNAL', ' ', 'OR CEBUANA LBC M LHUILLIER PPROCESS BY OPTIMUM REMIT VIA MTS PAY ANYBRANCH', '', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310673, '2022-07-01 08:35:52', 'OB-01030062200045', '13,806.00', 'PHP', 'CLARISSA B', 'FEDILO', ' ', 'REYMOND F', 'FEDILO', ' ', 'THRU OPTIMUM REMIT PALAWAN EXPRESSMLHUILLIERLBC PADALA', '', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310674, '2022-07-01 08:35:52', 'OB-01030062200343', '2,535.00', 'PHP', 'WILMA G', 'ALBUFERA', ' ', 'MA JASMINE', 'TORRES', ' ', 'THRU OPTIMUM REMIT PALAWAN EXPRESSMLHUILLIERLBC PADALA', '639657239356', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310675, '2022-07-01 08:35:52', 'OB-01030062200056', '7,002.00', 'PHP', 'DOLORES', 'CABOCTOLAN', ' ', 'JOY ANN C', 'ONDON', ' ', 'THRU OPTIMUM REMIT MLHUILLIERPALAWAN PAWNSHOPLBC ANY BRANCH', '639123177956', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310676, '2022-07-01 08:35:52', 'OB-01030062200385', '3,023.00', 'PHP', 'NURSIMAR H', 'JALAIDE', ' ', 'ABDURAJID HASID', 'ABDURAHIM', ' ', 'OR PALAWAN LBC M LHUILLIER SABIHIN SA PINAS NAG P', '639561696500', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310677, '2022-07-01 08:35:52', 'OB-01030062200359', '3,023.00', 'PHP', 'JOCELYN BERROYA', 'ADARNE', ' ', 'MICHAEL C', 'MELAYO', ' ', 'OR PALAWAN LBC M LHUILLIER PROCESS BY OPTIMUM EX', '', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
(1310678, '2022-07-01 08:35:52', 'OB-01030062200337', '3,023.00', 'PHP', 'CHERRY MAE T', 'CELEDONIO', ' ', 'JOEBERT', 'CELEDONIO', ' ', 'OR PALAWAN LBC M LHUILLIERPROCESS BY OPTIMUM REMI', '', 4, 'OTC07012022#1.txt', '', '0000-00-00 00:00:00', ''),
INSERT INTO `transactions` (`id`, `partnercode`, `partnerid`, `referencenumber`, `amount`, `responseid`, `responsecode`, `responsemessage`, `requeststr`, `reponsestr`, `txndate`, `currency`) VALUES
(28831061, 'SRUZRBHC', '5914877338', '05434393038', 0.00, '649B849FE8E9C', '1007', 'Invalid Remittance Number', 'pcode=SRUZRBHC, ptxnid=5914877338, referencenumber=05434393038, sign=667d06449b43ac56e3862c9897306b50dc3ed20ac54a4c5452461b19007ef7c603aa7ca28bf9a30ddbf7a7f54e3b2820f1a87f42701b28d4ebae93dc8c111417', '<QueryResponse><PartnerCode>SRUZRBHC</PartnerCode><PartnerTxnID>5914877338</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B849FE8E9C</ResponseID><Timestamp>2023-06-28 08:53:56</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:53:56', ''),
(28831062, 'RMNPSYXP', 'zhhz5a2prpiqxel1', 'FEC837254', 0.00, '649B84A07743B', '1007', 'Invalid Remittance Number', 'pcode=RMNPSYXP, ptxnid=zhhz5a2prpiqxel1, referencenumber=FEC837254, sign=872e1e583a1ac8797833abdf6ce7c7c02bc8174aaef0a8b9928f7ea3e9db7efd3a7623399020d6e16f55bbeba2d436b1e84d92d180503203dcab753325cc234e', '<QueryResponse><PartnerCode>RMNPSYXP</PartnerCode><PartnerTxnID>zhhz5a2prpiqxel1</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84A07743B</ResponseID><Timestamp>2023-06-28 08:53:56</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:53:56', ''),
(28831063, 'RZF4V74K', '230628085350', 'OPTRAE0000184866', 4379.38, '649B849E42275', '0', 'Success', 'pcode=RZF4V74K, ptxnid=230628085551, referencenumber=OPTRAE0000184866, sign=f69ee7c26287cb402c0421c64841041cb26fd79498da539a9d77240767c58f23b0c323a6de7ff81acf50bd3e19d3d08a3517cf93a0753375d546934f25687b90, responseid=649B849E42275', '<DisburseResponse><PartnerCode>RZF4V74K</PartnerCode><PartnerTxnID>230628085551</PartnerTxnID><ResponseCode>0</ResponseCode><ResponseMessage>Success</ResponseMessage><ResponseID>649B8517908D0</ResponseID><Timestamp>2023-06-28 08:55:57</Timestamp><ResponseData><RemittaceInfo><ReferenceID>OPTRAE0000184866</ReferenceID><Amount>4,379.38</Amount><Status>PAID</Status><RemitDate>2023-06-27 18:27:37</RemitDate></RemittaceInfo><Sender><SenderName>YOLITA MANABAT SAJULGA</SenderName></Sender><BeneFiciary><BeneFiciaryName>KING IVHAN B SALAZAR</BeneFiciaryName><BeneFiciaryAddress>ISABELA ISABELA</BeneFiciaryAddress><BeneFiciaryContact>639000000000</BeneFiciaryContact></BeneFiciary></ResponseData></DisburseResponse>', '2023-06-28 08:53:57', 'PHP'),
(28831064, 'SRUZRBHC', '5914881731', '166862689', 0.00, '649B84B11DBE9', '1007', 'Invalid Remittance Number', 'pcode=SRUZRBHC, ptxnid=5914881731, referencenumber=166862689, sign=b6c9fbb102e6a405882759004aeefdea36543db96f60279f64e40d88ac5b4418be947499b30784fb77dcbdde521c1ab400301ff0dca18ba6a1756c22ec35aacc', '<QueryResponse><PartnerCode>SRUZRBHC</PartnerCode><PartnerTxnID>5914881731</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84B11DBE9</ResponseID><Timestamp>2023-06-28 08:54:12</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:54:12', ''),
(28831065, 'RMNPSYXP', 'dqciphivyzb1u21o', '232014684441', 0.00, '649B84B552D9C', '1007', 'Invalid Remittance Number', 'pcode=RMNPSYXP, ptxnid=dqciphivyzb1u21o, referencenumber=232014684441, sign=f6bbe1712a7e5bab3cc3166a50b849b6d1f44065611aa17a1d92009fe4ed160c999cb6c1dc72ccc9db0ef051fc8a48da240f62cd817955a65ae4992d1ced22c4', '<QueryResponse><PartnerCode>RMNPSYXP</PartnerCode><PartnerTxnID>dqciphivyzb1u21o</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84B552D9C</ResponseID><Timestamp>2023-06-28 08:54:16</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:54:16', ''),
(28831066, 'RMNPSYXP', 'iccbb4ogc5ybvqf3', '166835147', 0.00, '649B84BD71F7E', '1007', 'Invalid Remittance Number', 'pcode=RMNPSYXP, ptxnid=iccbb4ogc5ybvqf3, referencenumber=166835147, sign=c2ae0495d1d622ef98a470557afbbde0f22b98fdfa71e80dbac2a17e3a46d3e1263a72d6b18578ca7cca527d70e930750bbe9999b7bdd5b26dc6a9df246feb17', '<QueryResponse><PartnerCode>RMNPSYXP</PartnerCode><PartnerTxnID>iccbb4ogc5ybvqf3</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84BD71F7E</ResponseID><Timestamp>2023-06-28 08:54:24</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:54:24', ''),
(28831067, 'RZF4V74K', '230628085425', 'OPTRAE0000184932', 0.00, '649B84C1E77D3', '1007', 'Invalid Remittance Number', 'pcode=RZF4V74K, ptxnid=230628085425, referencenumber=OPTRAE0000184932, sign=56c0983dc3352f66fcc0115fa93e8be338fb0fcbbebcc61e6793081104fc27504d7dc23cb73eccaf901e751e76990e390febc2580557dc9ad71f24f09e6e4068', '<QueryResponse><PartnerCode>RZF4V74K</PartnerCode><PartnerTxnID>230628085425</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84C1E77D3</ResponseID><Timestamp>2023-06-28 08:54:28</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:54:28', ''),
(28831068, 'SRUZRBHC', '5914884211', '2506200670', 0.00, '649B84C8BDC7F', '1007', 'Invalid Remittance Number', 'pcode=SRUZRBHC, ptxnid=5914884211, referencenumber=2506200670, sign=2296f38f730c9417730b9da2970719838e9026957927a652d21280a59b75c3d1f9ed8e48859853cdabdcc6f6befc565ab1b2b57f7db7ebbbf9add12a53d52da8', '<QueryResponse><PartnerCode>SRUZRBHC</PartnerCode><PartnerTxnID>5914884211</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84C8BDC7F</ResponseID><Timestamp>2023-06-28 08:54:36</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:54:36', ''),
(28831069, 'RMNPSYXP', '04kdlny045fasotr', 'PHUK30825760', 0.00, '649B84C972AF0', '1007', 'Invalid Remittance Number', 'pcode=RMNPSYXP, ptxnid=04kdlny045fasotr, referencenumber=PHUK30825760, sign=f30e09b4f673001d248623c33c3cb791a25f918f5cb72c14f213d65a485f367a4312eec1bf6c5de4a6adc0ae9641e8526579d8b08c90342804095b00c3502b1e', '<QueryResponse><PartnerCode>RMNPSYXP</PartnerCode><PartnerTxnID>04kdlny045fasotr</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84C972AF0</ResponseID><Timestamp>2023-06-28 08:54:37</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:54:37', ''),
(28831070, 'SRUZRBHC', '5914885143', 'OPTRAE0060184504', 0.00, '649B84D213656', '1007', 'Invalid Remittance Number', 'pcode=SRUZRBHC, ptxnid=5914885143, referencenumber=OPTRAE0060184504, sign=70191f18869e33f11128550a53111363d5319f17570e24b292b909df9daf35eeef975454844f4c861d5e05f3c35ef0367faca4eadccd185884798dfc1285e0e6', '<QueryResponse><PartnerCode>SRUZRBHC</PartnerCode><PartnerTxnID>5914885143</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84D213656</ResponseID><Timestamp>2023-06-28 08:54:44</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:54:44', ''),
(28831071, 'RMNPSYXP', 'um2y3k2qmo2z25it', '10225062300019', 0.00, '649B84DE23041', '1007', 'Invalid Remittance Number', 'pcode=RMNPSYXP, ptxnid=um2y3k2qmo2z25it, referencenumber=10225062300019, sign=6db6b9615a181f9d3ea74e3fcde0c42e496c347bcfbfa935fa31d845ca42218a0daa960d7e5e03f3a226b03d2b53c49f78224ddf806adfa236f7cb6ec97744e6', '<QueryResponse><PartnerCode>RMNPSYXP</PartnerCode><PartnerTxnID>um2y3k2qmo2z25it</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84DE23041</ResponseID><Timestamp>2023-06-28 08:54:57</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:54:57', ''),
(28831072, 'RMNPSYXP', 'bfmzfeklu0pv3l0h', 'EEC00427062300378', 0.00, '649B84DE5A5F0', '1007', 'Invalid Remittance Number', 'pcode=RMNPSYXP, ptxnid=bfmzfeklu0pv3l0h, referencenumber=EEC00427062300378, sign=0dadd11a358bffad60f24bed9e2e9d9d59558034be699083a602c64086ba6190a10c0d06051aeeb088a4e86a96f7bff0e8ec8ffe2332807f82a91ab0722ad963', '<QueryResponse><PartnerCode>RMNPSYXP</PartnerCode><PartnerTxnID>bfmzfeklu0pv3l0h</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84DE5A5F0</ResponseID><Timestamp>2023-06-28 08:54:58</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:54:58', ''),
(28831073, 'SRUZRBHC', '5914880383', '0543739038', 0.00, '649B84E5B2A7E', '1007', 'Invalid Remittance Number', 'pcode=SRUZRBHC, ptxnid=5914880383, referencenumber=0543739038, sign=578d1642fb15d5c53edd23069843bd776501dc7b5726de8127ec401db2998727f51046688c2bbd893ab12fff9a946f56091c0e5c8985adb8e6723d8f5dfd54a3', '<QueryResponse><PartnerCode>SRUZRBHC</PartnerCode><PartnerTxnID>5914880383</PartnerTxnID><ResponseCode>1007</ResponseCode><ResponseMessage>Invalid Remittance Number</ResponseMessage><ResponseID>649B84E5B2A7E</ResponseID><Timestamp>2023-06-28 08:55:05</Timestamp><ResponseData><RemittaceInfo><ReferenceID></ReferenceID><Amount></Amount><Status></Status><RemitDate></RemitDate></RemittaceInfo><Sender><SenderName> </SenderName></Sender><BeneFiciary><BeneFiciaryName> </BeneFiciaryName><BeneFiciaryAddress></BeneFiciaryAddress><BeneFiciaryContact></BeneFiciaryContact></BeneFiciary></ResponseData></QueryResponse>', '2023-06-28 08:55:05', ''),
