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','1194.16','2194.16', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2194.16' 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','1932.91','2932.91', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2932.91' 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','2026-01-01 04:44:05')
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','894.187','1894.187', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1894.187' 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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','847.547','1847.547', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1847.547' 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','1289.51','2289.51', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2289.51' 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','2026-01-01 04:44:05')
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','5086.97','6086.97', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='6086.97' 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','3430.04','4430.04', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='4430.04' 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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','133.296','1133.296', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1133.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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','596.789','1596.789', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1596.789' 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','289.214','1289.214', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1289.214' 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','1045.66','2045.66', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2045.66' 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','2026-01-01 04:44:05')
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','181.749','1181.749', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1181.749' 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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','119.587','1119.587', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1119.587' 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','231.339','1231.339', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1231.339' 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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','1230.92','2230.92', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2230.92' 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','2026-01-01 04:44:05')
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','197.456','1197.456', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1197.456' 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','3237.59','4237.59', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='4237.59' 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','352.616','1352.616', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1352.616' 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','391.578','1391.578', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1391.578' 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','1841.8','2841.8', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2841.8' 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','1016.21','2016.21', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2016.21' 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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','1370.71','2370.71', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2370.71' 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','635.871','1635.871', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1635.871' 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','2026-01-01 04:44:05')
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','301.516','1301.516', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1301.516' 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','723.754','1723.754', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1723.754' 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','542.811','1542.811', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1542.811' 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','841.888','1841.888', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1841.888' 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','2026-01-01 04:44:05')
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','397.338','1397.338', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1397.338' 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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','441.058','1441.058', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1441.058' 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','2026-01-01 04:44:05')
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','238.018','1238.018', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1238.018' 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','2026-01-01 04:44:05')
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','369.766','1369.766', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1369.766' 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','2026-01-01 04:44:05')
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','1755.46','2755.46', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='2755.46' 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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','2026-01-01 04:44:05')
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','291.716','1291.716', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1291.716' 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','3256.11','4256.11', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='4256.11' 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','2026-01-01 04:44:05')
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','670.29','1670.29', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1670.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','973.71','1973.71', 'Bonus ','bonus amount','Pongal bonus 2025','2026-01-01 04:44:05')
UPDATE `ft_accounts_vehicle` SET `accounts_credit_balance`='1973.71' WHERE `accounts_vehicle_id`='33325'