UPDATE `comp_payment` SET `memo` = '', `amountPaid` = '1', `totalDiscount` = '0', `totalPaid` = '1', `totalApplied` = '1.12', `outOfBalance` = '-0.12', `bankCharges` = '0', `totalOtherCharge` = '0' WHERE `ID` =  '107'