INSERT INTO tbl_mpesapayments
( 
transactiontype,
transid,
transtime,
shortdate,
dateint ,
transamount,
businessshortcode,
billrefnumber,
billrefno,
invoicenumber,
MSISDN,
firstname,
middlename,
lastname,
shortcodeadmn,
lipakaromsg,
transyear,
orgaccountbalance
) 
VALUES 
( 
'Pay Bill', 
'ZXC0MKODG0', 
'20200812141827',
'20200812141827',
'20200812',
'5000.00', 
'4090345', 
'1202', 
'1202', 
'', 
'2547 ***** 325',
'SABINA', 
'WANJIRU', 
'MUGUCIA',
'409034501202',
'ZXC0MKODG0 confirmed 5000.00 received from SABINA WANJIRU MUGUCIA 2547 ***** 325 for account 1202 on 2020-08-12. Visatell Ref No: 5A5843304D4B4F444730 visat',
'2020',
'50000.00' 
)