SELECT owner_id, vehicle_id from fms_vehicle where vehicle_id in (6062,31319,12081,28911,26221,12782,27094,3854,18781,32857,7332,30424,28963,341710490,28092,26774,20306,28206,3135,12249,32865,3594,22993,32029,29357,29249,20452,17096,18420,14752,14434,1177,18760,5426,12972,12699,5428,2294,5445,19989,33298,16765,33297,33296,2663,6535,4040,5179,27970,28230,24902,25884,27781,33325,32043,33217,31853,17203,13869,20096,28596,20425,27143,3254,24602,28280,28547,24603,5640,18760,11800,32907,20092,27719,32599,18934,32658,23713,28963,30006,32857)
75
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '1177'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('1177',0, '11370','1000','499.441','1499.441', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1499.441' WHERE `accounts_vehicle_id`='1177'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '2294'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('2294',0, '430','1000','877.372','1877.372', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1877.372' WHERE `accounts_vehicle_id`='2294'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '3135'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('3135',0, '0','1000','0','1000', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1000' WHERE `accounts_vehicle_id`='3135'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '3254'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('3254',0, '495','1000','1128.72','2128.72', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2128.72' WHERE `accounts_vehicle_id`='3254'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '3594'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('3594',0, '10063','1000','331.738','1331.738', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1331.738' WHERE `accounts_vehicle_id`='3594'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '3854'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('3854',0, '10831','1000','475.368','1475.368', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1475.368' WHERE `accounts_vehicle_id`='3854'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '4040'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('4040',0, '438','1000','450.036','1450.036', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1450.036' WHERE `accounts_vehicle_id`='4040'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '5179'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('5179',0, '438','1000','2969.7','3969.7', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='3969.7' WHERE `accounts_vehicle_id`='5179'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '5426'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('5426',0, '9408','1000','92.015','1092.015', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1092.015' WHERE `accounts_vehicle_id`='5426'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '5428'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('5428',0, '430','1000','3867.67','4867.67', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='4867.67' WHERE `accounts_vehicle_id`='5428'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '5445'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('5445',0, '430','1000','4217.26','5217.26', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='5217.26' WHERE `accounts_vehicle_id`='5445'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '5640'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('5640',0, '154113','1000','245.08','1245.08', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1245.08' WHERE `accounts_vehicle_id`='5640'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '6062'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('6062',0, '89','1000','156.505','1156.505', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1156.505' WHERE `accounts_vehicle_id`='6062'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '7332'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('7332',0, '5326','1000','233.296','1233.296', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1233.296' WHERE `accounts_vehicle_id`='7332'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '11800'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('11800',0, '144310','1000','234.511','1234.511', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1234.511' WHERE `accounts_vehicle_id`='11800'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '12081'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('12081',0, '156135','1000','150.512','1150.512', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1150.512' WHERE `accounts_vehicle_id`='12081'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '12249'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('12249',0, '5918','1000','418.52','1418.52', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1418.52' WHERE `accounts_vehicle_id`='12249'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '12699'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('12699',0, '268','1000','967.69','1967.69', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1967.69' WHERE `accounts_vehicle_id`='12699'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '12782'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('12782',0, '7306','1000','366.555','1366.555', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1366.555' WHERE `accounts_vehicle_id`='12782'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '12972'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('12972',0, '7489','1000','593.306','1593.306', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1593.306' WHERE `accounts_vehicle_id`='12972'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '13869'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('13869',0, '469','1000','747.311','1747.311', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1747.311' WHERE `accounts_vehicle_id`='13869'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '14434'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('14434',0, '13668','1000','1027.67','2027.67', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2027.67' WHERE `accounts_vehicle_id`='14434'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '14752'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('14752',0, '144161','1000','385.908','1385.908', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1385.908' WHERE `accounts_vehicle_id`='14752'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '16765'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('16765',0, '435','1000','150.5','1150.5', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1150.5' WHERE `accounts_vehicle_id`='16765'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '17096'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('17096',0, '146582','1000','-205.486','794.514', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='794.514' WHERE `accounts_vehicle_id`='17096'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '17203'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('17203',0, '461','1000','206.15','1206.15', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1206.15' WHERE `accounts_vehicle_id`='17203'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '18420'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('18420',0, '145804','1000','351.044','1351.044', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1351.044' WHERE `accounts_vehicle_id`='18420'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '18760'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('18760',0, '10345','1000','501.92','1501.92', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1501.92' WHERE `accounts_vehicle_id`='18760'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '18781'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('18781',0, '147261','1000','405','1405', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1405' WHERE `accounts_vehicle_id`='18781'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '18934'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('18934',0, '146811','1000','250.789','1250.789', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1250.789' WHERE `accounts_vehicle_id`='18934'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '19989'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('19989',0, '435','1000','118.77','1118.77', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1118.77' WHERE `accounts_vehicle_id`='19989'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '20092'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('20092',0, '0','1000','0','1000', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1000' WHERE `accounts_vehicle_id`='20092'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '20096'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('20096',0, '469','1000','-27.194','972.806', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='972.806' WHERE `accounts_vehicle_id`='20096'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '20306'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('20306',0, '147343','1000','-106.01','893.99', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='893.99' WHERE `accounts_vehicle_id`='20306'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '20425'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('20425',0, '469','1000','919.186','1919.186', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1919.186' WHERE `accounts_vehicle_id`='20425'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '20452'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('20452',0, '147466','1000','-655.66','344.34', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='344.34' WHERE `accounts_vehicle_id`='20452'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '22993'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('22993',0, '9738','1000','682.85','1682.85', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1682.85' WHERE `accounts_vehicle_id`='22993'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '23713'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('23713',0, '150738','1000','1323.93','2323.93', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2323.93' WHERE `accounts_vehicle_id`='23713'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '24602'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('24602',0, '1555','1000','318.923','1318.923', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1318.923' WHERE `accounts_vehicle_id`='24602'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '24603'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('24603',0, '1555','1000','351.57','1351.57', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1351.57' WHERE `accounts_vehicle_id`='24603'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '24902'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('24902',0, '454','1000','3002.9','4002.9', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='4002.9' WHERE `accounts_vehicle_id`='24902'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '25884'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('25884',0, '454','1000','527.06','1527.06', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1527.06' WHERE `accounts_vehicle_id`='25884'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '26221'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('26221',0, '147638','1000','391.716','1391.716', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1391.716' WHERE `accounts_vehicle_id`='26221'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '26774'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('26774',0, '153980','1000','2061.82','3061.82', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='3061.82' WHERE `accounts_vehicle_id`='26774'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '27094'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('27094',0, '154283','1000','100.908','1100.908', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1100.908' WHERE `accounts_vehicle_id`='27094'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '27143'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('27143',0, '480','1000','127.636','1127.636', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1127.636' WHERE `accounts_vehicle_id`='27143'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '27719'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('27719',0, '146811','1000','251.458','1251.458', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1251.458' WHERE `accounts_vehicle_id`='27719'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '27781'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('27781',0, '454','1000','3481.7','4481.7', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='4481.7' WHERE `accounts_vehicle_id`='27781'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '27970'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('27970',0, '454','1000','825.482','1825.482', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1825.482' WHERE `accounts_vehicle_id`='27970'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '28092'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('28092',0, '161332','1000','1193.93','2193.93', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2193.93' WHERE `accounts_vehicle_id`='28092'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '28206'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('28206',0, '144347','1000','156.145','1156.145', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1156.145' WHERE `accounts_vehicle_id`='28206'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '28230'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('28230',0, '454','1000','468.22','1468.22', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1468.22' WHERE `accounts_vehicle_id`='28230'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '28280'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('28280',0, '1555','1000','184.571','1184.571', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1184.571' WHERE `accounts_vehicle_id`='28280'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '28547'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('28547',0, '1555','1000','1153.15','2153.15', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2153.15' WHERE `accounts_vehicle_id`='28547'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '28596'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('28596',0, '469','1000','256.96','1256.96', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1256.96' WHERE `accounts_vehicle_id`='28596'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '28911'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('28911',0, '155849','1000','287.357','1287.357', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1287.357' WHERE `accounts_vehicle_id`='28911'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '28963'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('28963',0, '155901','1000','252.603','1252.603', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1252.603' WHERE `accounts_vehicle_id`='28963'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '29249'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('29249',0, '155358','1000','627.608','1627.608', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1627.608' WHERE `accounts_vehicle_id`='29249'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '29357'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('29357',0, '156274','1000','899.23','1899.23', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1899.23' WHERE `accounts_vehicle_id`='29357'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '30006'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('30006',0, '155901','1000','176.29','1176.29', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1176.29' WHERE `accounts_vehicle_id`='30006'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '30424'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('30424',0, '4942','1000','215.301','1215.301', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1215.301' WHERE `accounts_vehicle_id`='30424'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '31319'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('31319',0, '158138','1000','-898.15','101.85', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='101.85' WHERE `accounts_vehicle_id`='31319'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '31853'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('31853',0, '455','1000','167.842','1167.842', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1167.842' WHERE `accounts_vehicle_id`='31853'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '32029'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('32029',0, '158808','1000','196.094','1196.094', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1196.094' WHERE `accounts_vehicle_id`='32029'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '32043'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('32043',0, '454','1000','2043.63','3043.63', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='3043.63' WHERE `accounts_vehicle_id`='32043'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '32599'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('32599',0, '146811','1000','251.062','1251.062', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1251.062' WHERE `accounts_vehicle_id`='32599'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '32658'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('32658',0, '148180','1000','1699.11','2699.11', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2699.11' WHERE `accounts_vehicle_id`='32658'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '32857'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('32857',0, '159597','1000','534.475','1534.475', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1534.475' WHERE `accounts_vehicle_id`='32857'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '32865'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('32865',0, '159605','1000','247.663','1247.663', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1247.663' WHERE `accounts_vehicle_id`='32865'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '32907'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('32907',0, '146811','1000','1086.62','2086.62', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2086.62' WHERE `accounts_vehicle_id`='32907'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '33217'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('33217',0, '455','1000','248.347','1248.347', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1248.347' WHERE `accounts_vehicle_id`='33217'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '33296'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('33296',0, '435','1000','271.709','1271.709', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1271.709' WHERE `accounts_vehicle_id`='33296'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '33297'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('33297',0, '435','1000','1000.32','2000.32', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2000.32' WHERE `accounts_vehicle_id`='33297'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '33298'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('33298',0, '435','1000','770.29','1770.29', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1770.29' WHERE `accounts_vehicle_id`='33298'
select accounts_credit_balance from ft_accounts_vehicle where accounts_vehicle_id = '33325'
INSERT INTO `ft_accounts_log`(`account_vid`, `accounts_reciept_no`, `account_oid`,`accounts_amount`,
`ft_old_amount`, `ft_new_amount`, `accounts_payment_type`, `accounts_type`, `accounts_remarks`,accounts_created_dt )
VALUES ('33325',0, '454','1000','989.58','1989.58', 'Bonus ','bonus amount','Pongal bonus 2025','2025-12-31 06:46:03')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1989.58' WHERE `accounts_vehicle_id`='33325'