{"error":"Error: update `users` set `status` = 0, `created_at` = '2023-04-20 14:07:12', `updated_at` = '2023-11-08 17:15:04' where `id` = 1 - Lock wait timeout exceeded; try restarting transaction at Packet.asError (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\packets\\packet.js:728:17) at Query.execute (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\commands\\command.js:29:26) at Connection.handlePacket (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\connection.js:456:32) at PacketParser.onPacket (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\connection.js:85:12) at PacketParser.executeStart (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\packet_parser.js:75:16) at Socket.<anonymous> (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\connection.js:92:25) at Socket.emit (node:events:527:28) at addChunk (node:internal/streams/readable:315:12) at readableAddChunk (node:internal/streams/readable:289:9) at Socket.Readable.push (node:internal/streams/readable:228:10)","level":"error","request":{"password":"Manila12#","username":"administrator"},"timestamp":"November 8, 2023 - 5:15:55 PM"}
{"error":"Error: update `users` set `status` = 0, `created_at` = '2023-04-20 14:07:12', `updated_at` = '2023-11-08 17:18:02' where `id` = 1 - Lock wait timeout exceeded; try restarting transaction at Packet.asError (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\packets\\packet.js:728:17) at Query.execute (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\commands\\command.js:29:26) at Connection.handlePacket (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\connection.js:456:32) at PacketParser.onPacket (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\connection.js:85:12) at PacketParser.executeStart (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\packet_parser.js:75:16) at Socket.<anonymous> (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\mysql2\\lib\\connection.js:92:25) at Socket.emit (node:events:527:28) at addChunk (node:internal/streams/readable:315:12) at readableAddChunk (node:internal/streams/readable:289:9) at Socket.Readable.push (node:internal/streams/readable:228:10)","level":"error","request":{"password":"Manila12#","username":"administrator"},"timestamp":"November 8, 2023 - 5:18:53 PM"}
{"error":"TypeError: Cannot read properties of null (reading 'username') at InwardController.saveConsolidatedInward (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Controllers\\Http\\InwardController.js:119:17) at Server._routeHandler (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\framework\\src\\Server\\index.js:121:31) at MiddlewareBase._resolveMiddleware (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\middleware-base\\index.js:195:28) at Runnable._invoke (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:76:42) at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:73:34 at f (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\once\\once.js:25:25) at Api.handle (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Middleware\\Api.js:10:11) at MiddlewareBase._resolveMiddleware (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\middleware-base\\index.js:195:28) at Runnable._invoke (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:76:42) at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:73:34","level":"error","request":{"settlementDate":"2023-08-01","transactions":[{"amount":"185328.0","beneficiaryAccountNumber":"001859","beneficiaryAddress":["U401-402 LAFUERZA PLAZA L 2241DONCHINOROCES MAKATI"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"EPSON PRECISION (PHILIPPINES),INC.","endToEndId":136843628,"flowStatus":2,"index":0,"instructions":"Original Transaction was given AC03 status by Original RFI.","isRejected":false,"ofiCustomerReferenceNumber":"RIZAL COMMERCIAL","ofiReferenceNumber":"PCHC000134174039","remarks":"","remitterAccountNumber":"12499800437","remitterAddress":["U401-402 LAFUERZA PLAZA L 2241DONCHINOROCES MAKATI"],"remitterBIC":"RCBCPHMMXXX","remitterName":"MARUKA ENTERPRISES, INC.","rfiCustomerReferenceNumber":"BTMU","rfiReferenceNumber":"BTMU2677","sequenceNumber":46989002,"status":"DS07"},{"amount":"10450350.51","beneficiaryAccountNumber":"5121000104513","beneficiaryAddress":["15/F AYALA TOWER ONEAYALA TRI. AY PHILIPPINES"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"JAPAN AIRLINES INTL. CO. LTD.","endToEndId":136871224,"flowStatus":2,"index":1,"instructions":"TNCD/CASH/20230602F MAKATI CITY ALA AVE., 1226","isRejected":false,"ofiCustomerReferenceNumber":"IATA CASS HINGE","ofiReferenceNumber":"02RE202307310305","remarks":"","remitterAccountNumber":"1006766000","remitterAddress":["15/F AYALA TOWER ONEAYALA TRI. AY PHILIPPINES"],"remitterBIC":"DEUTPHMMXXX","remitterName":"IATA CASS HINGE","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47013669,"status":"DS07"},{"amount":"28436.8","beneficiaryAccountNumber":"5111000004168","beneficiaryAddress":["RM 1508 Cityland 10 Tower 2, H.V. Dela Costa St.,","Salcedo Village, Makati City"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"KDDI PHILIPPINES CORPORATION","endToEndId":136925616,"flowStatus":2,"index":3,"instructions":"HMAP - Firewall Maintenance Support August 2023-August 2024","isRejected":false,"ofiCustomerReferenceNumber":"BOB2307270971889","ofiReferenceNumber":"BOB2307270971889","remarks":"","remitterAccountNumber":"007100090463","remitterAddress":["RM 1508 Cityland 10 Tower 2, H.V. Dela Costa St.,","Salcedo Village, Makati City"],"remitterBIC":"BNORPHMMXXX","remitterName":"ZALAMEA BUSINESS SOLUTIONS, INC.","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47040465,"status":"DS07"},{"amount":"60000000.0","beneficiaryAccountNumber":"5111000000299","beneficiaryAddress":["11F V CORPORATE CENTER 125 LP LEVISTE ST, SALCEDO","VILLAGE, MAKATI CITY"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"AJINOMOTO PHILIPPINES CORPORATION","endToEndId":136927705,"flowStatus":2,"index":4,"instructions":"","isRejected":false,"ofiCustomerReferenceNumber":"BOB2307310977524","ofiReferenceNumber":"BOB2307310977524","remarks":"","remitterAccountNumber":"003000000601","remitterAddress":["11F V CORPORATE CENTER 125 LP LEVISTE ST, SALCEDO","VILLAGE, MAKATI CITY"],"remitterBIC":"BNORPHMMXXX","remitterName":"AJINOMOTO PHILIPPINES CORPORATION","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47041804,"status":"DS07"}],"type":"send"},"timestamp":"November 8, 2023 - 5:21:05 PM"}
{"error":"TypeError: Cannot read properties of null (reading 'username') at InwardController.saveConsolidatedInward (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Controllers\\Http\\InwardController.js:119:17) at Server._routeHandler (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\framework\\src\\Server\\index.js:121:31) at MiddlewareBase._resolveMiddleware (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\middleware-base\\index.js:195:28) at Runnable._invoke (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:76:42) at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:73:34 at f (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\once\\once.js:25:25) at Api.handle (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Middleware\\Api.js:10:11) at MiddlewareBase._resolveMiddleware (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\middleware-base\\index.js:195:28) at Runnable._invoke (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:76:42) at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:73:34","level":"error","request":{"settlementDate":"2023-08-01","transactions":[{"amount":"185328.0","beneficiaryAccountNumber":"001859","beneficiaryAddress":["U401-402 LAFUERZA PLAZA L 2241DONCHINOROCES MAKATI"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"EPSON PRECISION (PHILIPPINES),INC.","endToEndId":136843628,"flowStatus":2,"index":0,"instructions":"Original Transaction was given AC03 status by Original RFI.","isRejected":false,"ofiCustomerReferenceNumber":"RIZAL COMMERCIAL","ofiReferenceNumber":"PCHC000134174039","remarks":"","remitterAccountNumber":"12499800437","remitterAddress":["U401-402 LAFUERZA PLAZA L 2241DONCHINOROCES MAKATI"],"remitterBIC":"RCBCPHMMXXX","remitterName":"MARUKA ENTERPRISES, INC.","rfiCustomerReferenceNumber":"BTMU","rfiReferenceNumber":"BTMU2677","sequenceNumber":46989002,"status":"DS07"},{"amount":"10450350.51","beneficiaryAccountNumber":"5121000104513","beneficiaryAddress":["15/F AYALA TOWER ONEAYALA TRI. AY PHILIPPINES"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"JAPAN AIRLINES INTL. CO. LTD.","endToEndId":136871224,"flowStatus":2,"index":1,"instructions":"TNCD/CASH/20230602F MAKATI CITY ALA AVE., 1226","isRejected":false,"ofiCustomerReferenceNumber":"IATA CASS HINGE","ofiReferenceNumber":"02RE202307310305","remarks":"","remitterAccountNumber":"1006766000","remitterAddress":["15/F AYALA TOWER ONEAYALA TRI. AY PHILIPPINES"],"remitterBIC":"DEUTPHMMXXX","remitterName":"IATA CASS HINGE","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47013669,"status":"DS07"},{"amount":"28436.8","beneficiaryAccountNumber":"5111000004168","beneficiaryAddress":["RM 1508 Cityland 10 Tower 2, H.V. Dela Costa St.,","Salcedo Village, Makati City"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"KDDI PHILIPPINES CORPORATION","endToEndId":136925616,"flowStatus":2,"index":3,"instructions":"HMAP - Firewall Maintenance Support August 2023-August 2024","isRejected":false,"ofiCustomerReferenceNumber":"BOB2307270971889","ofiReferenceNumber":"BOB2307270971889","remarks":"","remitterAccountNumber":"007100090463","remitterAddress":["RM 1508 Cityland 10 Tower 2, H.V. Dela Costa St.,","Salcedo Village, Makati City"],"remitterBIC":"BNORPHMMXXX","remitterName":"ZALAMEA BUSINESS SOLUTIONS, INC.","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47040465,"status":"DS07"},{"amount":"60000000.0","beneficiaryAccountNumber":"5111000000299","beneficiaryAddress":["11F V CORPORATE CENTER 125 LP LEVISTE ST, SALCEDO","VILLAGE, MAKATI CITY"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"AJINOMOTO PHILIPPINES CORPORATION","endToEndId":136927705,"flowStatus":2,"index":4,"instructions":"","isRejected":false,"ofiCustomerReferenceNumber":"BOB2307310977524","ofiReferenceNumber":"BOB2307310977524","remarks":"","remitterAccountNumber":"003000000601","remitterAddress":["11F V CORPORATE CENTER 125 LP LEVISTE ST, SALCEDO","VILLAGE, MAKATI CITY"],"remitterBIC":"BNORPHMMXXX","remitterName":"AJINOMOTO PHILIPPINES CORPORATION","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47041804,"status":"DS07"}],"type":"update"},"timestamp":"November 8, 2023 - 5:21:46 PM"}
{"error":"TypeError: Cannot read properties of null (reading 'username') at InwardController.saveConsolidatedInward (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Controllers\\Http\\InwardController.js:119:17) at Server._routeHandler (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\framework\\src\\Server\\index.js:121:31) at MiddlewareBase._resolveMiddleware (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\middleware-base\\index.js:195:28) at Runnable._invoke (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:76:42) at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:73:34 at f (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\once\\once.js:25:25) at Api.handle (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Middleware\\Api.js:10:11) at MiddlewareBase._resolveMiddleware (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\middleware-base\\index.js:195:28) at Runnable._invoke (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:76:42) at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:73:34","level":"error","request":{"settlementDate":"2023-08-01","transactions":[{"amount":"185328.0","beneficiaryAccountNumber":"001859","beneficiaryAddress":["U401-402 LAFUERZA PLAZA L 2241DONCHINOROCES MAKATI"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"EPSON PRECISION (PHILIPPINES),INC.","endToEndId":136843628,"flowStatus":2,"index":0,"instructions":"Original Transaction was given AC03 status by Original RFI.","isRejected":false,"ofiCustomerReferenceNumber":"RIZAL COMMERCIAL","ofiReferenceNumber":"PCHC000134174039","remarks":"","remitterAccountNumber":"12499800437","remitterAddress":["U401-402 LAFUERZA PLAZA L 2241DONCHINOROCES MAKATI"],"remitterBIC":"RCBCPHMMXXX","remitterName":"MARUKA ENTERPRISES, INC.","rfiCustomerReferenceNumber":"BTMU","rfiReferenceNumber":"BTMU2677","sequenceNumber":46989002,"status":"DS07"},{"amount":"10450350.51","beneficiaryAccountNumber":"5121000104513","beneficiaryAddress":["15/F AYALA TOWER ONEAYALA TRI. AY PHILIPPINES"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"JAPAN AIRLINES INTL. CO. LTD.","endToEndId":136871224,"flowStatus":2,"index":1,"instructions":"TNCD/CASH/20230602F MAKATI CITY ALA AVE., 1226","isRejected":false,"ofiCustomerReferenceNumber":"IATA CASS HINGE","ofiReferenceNumber":"02RE202307310305","remarks":"","remitterAccountNumber":"1006766000","remitterAddress":["15/F AYALA TOWER ONEAYALA TRI. AY PHILIPPINES"],"remitterBIC":"DEUTPHMMXXX","remitterName":"IATA CASS HINGE","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47013669,"status":"DS07"},{"amount":"28436.8","beneficiaryAccountNumber":"5111000004168","beneficiaryAddress":["RM 1508 Cityland 10 Tower 2, H.V. Dela Costa St.,","Salcedo Village, Makati City"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"KDDI PHILIPPINES CORPORATION","endToEndId":136925616,"flowStatus":2,"index":3,"instructions":"HMAP - Firewall Maintenance Support August 2023-August 2024","isRejected":false,"ofiCustomerReferenceNumber":"BOB2307270971889","ofiReferenceNumber":"BOB2307270971889","remarks":"","remitterAccountNumber":"007100090463","remitterAddress":["RM 1508 Cityland 10 Tower 2, H.V. Dela Costa St.,","Salcedo Village, Makati City"],"remitterBIC":"BNORPHMMXXX","remitterName":"ZALAMEA BUSINESS SOLUTIONS, INC.","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47040465,"status":"DS07"},{"amount":"60000000.0","beneficiaryAccountNumber":"5111000000299","beneficiaryAddress":["11F V CORPORATE CENTER 125 LP LEVISTE ST, SALCEDO","VILLAGE, MAKATI CITY"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"AJINOMOTO PHILIPPINES CORPORATION","endToEndId":136927705,"flowStatus":2,"index":4,"instructions":"","isRejected":false,"ofiCustomerReferenceNumber":"BOB2307310977524","ofiReferenceNumber":"BOB2307310977524","remarks":"","remitterAccountNumber":"003000000601","remitterAddress":["11F V CORPORATE CENTER 125 LP LEVISTE ST, SALCEDO","VILLAGE, MAKATI CITY"],"remitterBIC":"BNORPHMMXXX","remitterName":"AJINOMOTO PHILIPPINES CORPORATION","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47041804,"status":"DS07"}],"type":"update"},"timestamp":"November 8, 2023 - 5:25:42 PM"}
{"error":"Error: Undefined binding(s) detected when compiling FIRST. Undefined column(s): [reference_id] query: select * from `transaction_lists` where `reference_id` = ? limit ? at QueryCompiler_MySQL.toSQL (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\knex\\lib\\query\\compiler.js:98:13) at Builder.toSQL (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\knex\\lib\\query\\builder.js:97:44) at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\knex\\lib\\runner.js:31:36 at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\knex\\lib\\runner.js:277:24 at processTicksAndRejections (node:internal/process/task_queues:96:5) at async Proxy.first (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\lucid\\src\\Lucid\\QueryBuilder\\index.js:367:17) at async Function.getTransaction (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Controllers\\Services\\Transactionlist.js:63:23) at async TransactionListController.getTransaction (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Controllers\\Http\\TransactionListController.js:14:30) at async Server._routeHandler (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\framework\\src\\Server\\index.js:121:25) at async Api.handle (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Middleware\\Api.js:10:5)","level":"error","request":{"cycle":2,"settlementDate":"2023-08-01"},"timestamp":"November 8, 2023 - 5:32:21 PM"}
{"error":"TypeError: Cannot read properties of null (reading 'username') at InwardController.saveConsolidatedInward (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Controllers\\Http\\InwardController.js:119:17) at Server._routeHandler (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\framework\\src\\Server\\index.js:121:31) at MiddlewareBase._resolveMiddleware (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\middleware-base\\index.js:195:28) at Runnable._invoke (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:76:42) at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:73:34 at f (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\once\\once.js:25:25) at Api.handle (C:\\Users\\telcom live content\\Documents\\pesonet_api\\app\\Middleware\\Api.js:10:11) at MiddlewareBase._resolveMiddleware (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\@adonisjs\\middleware-base\\index.js:195:28) at Runnable._invoke (C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:76:42) at C:\\Users\\telcom live content\\Documents\\pesonet_api\\node_modules\\co-compose\\src\\Runnable.js:73:34","level":"error","request":{"settlementDate":"2023-08-01","transactions":[{"amount":"185328.0","beneficiaryAccountNumber":"001859","beneficiaryAddress":["U401-402 LAFUERZA PLAZA L 2241DONCHINOROCES MAKATI"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"EPSON PRECISION (PHILIPPINES),INC.","endToEndId":136843628,"flowStatus":2,"index":0,"instructions":"Original Transaction was given AC03 status by Original RFI.","isRejected":false,"ofiCustomerReferenceNumber":"RIZAL COMMERCIAL","ofiReferenceNumber":"PCHC000134174039","remarks":"","remitterAccountNumber":"12499800437","remitterAddress":["U401-402 LAFUERZA PLAZA L 2241DONCHINOROCES MAKATI"],"remitterBIC":"RCBCPHMMXXX","remitterName":"MARUKA ENTERPRISES, INC.","rfiCustomerReferenceNumber":"BTMU","rfiReferenceNumber":"BTMU2677","sequenceNumber":46989002,"status":"DS07"},{"amount":"10450350.51","beneficiaryAccountNumber":"5121000104513","beneficiaryAddress":["15/F AYALA TOWER ONEAYALA TRI. AY PHILIPPINES"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"JAPAN AIRLINES INTL. CO. LTD.","endToEndId":136871224,"flowStatus":2,"index":1,"instructions":"TNCD/CASH/20230602F MAKATI CITY ALA AVE., 1226","isRejected":false,"ofiCustomerReferenceNumber":"IATA CASS HINGE","ofiReferenceNumber":"02RE202307310305","remarks":"","remitterAccountNumber":"1006766000","remitterAddress":["15/F AYALA TOWER ONEAYALA TRI. AY PHILIPPINES"],"remitterBIC":"DEUTPHMMXXX","remitterName":"IATA CASS HINGE","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47013669,"status":"DS07"},{"amount":"28436.8","beneficiaryAccountNumber":"5111000004168","beneficiaryAddress":["RM 1508 Cityland 10 Tower 2, H.V. Dela Costa St.,","Salcedo Village, Makati City"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"KDDI PHILIPPINES CORPORATION","endToEndId":136925616,"flowStatus":2,"index":3,"instructions":"HMAP - Firewall Maintenance Support August 2023-August 2024","isRejected":false,"ofiCustomerReferenceNumber":"BOB2307270971889","ofiReferenceNumber":"BOB2307270971889","remarks":"","remitterAccountNumber":"007100090463","remitterAddress":["RM 1508 Cityland 10 Tower 2, H.V. Dela Costa St.,","Salcedo Village, Makati City"],"remitterBIC":"BNORPHMMXXX","remitterName":"ZALAMEA BUSINESS SOLUTIONS, INC.","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47040465,"status":"DS07"},{"amount":"60000000.0","beneficiaryAccountNumber":"5111000000299","beneficiaryAddress":["11F V CORPORATE CENTER 125 LP LEVISTE ST, SALCEDO","VILLAGE, MAKATI CITY"],"beneficiaryBIC":"BOTKPHMMXXX","beneficiaryName":"AJINOMOTO PHILIPPINES CORPORATION","endToEndId":136927705,"flowStatus":2,"index":4,"instructions":"","isRejected":false,"ofiCustomerReferenceNumber":"BOB2307310977524","ofiReferenceNumber":"BOB2307310977524","remarks":"","remitterAccountNumber":"003000000601","remitterAddress":["11F V CORPORATE CENTER 125 LP LEVISTE ST, SALCEDO","VILLAGE, MAKATI CITY"],"remitterBIC":"BNORPHMMXXX","remitterName":"AJINOMOTO PHILIPPINES CORPORATION","rfiCustomerReferenceNumber":null,"rfiReferenceNumber":null,"sequenceNumber":47041804,"status":"DS07"}],"type":"send"},"timestamp":"November 8, 2023 - 5:48:27 PM"}