SELECT * FROM sac.dbook WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ATHISAKTHI CAPITALS' and cuscode='4179' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');


DELETE FROM sac.dbook
WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ATHISAKTHI CAPITALS' and cuscode='4179' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

update   sac.tdsdebits set amount = '0.00' where cmpname='SRI ATHISAKTHI CAPITALS' and cuscode='4179' and todaydate= '08-04-2022'

update sac.dbook set amount = 214.00 WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ATHISAKTHI CAPITALS' and date = '21-07-2022' and cuscode='3554' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

update  sac.tdscredits set amount = 214.00 where cmpname='SRI ATHISAKTHI CAPITALS' and cuscode='3554' and todaydate = '21-07-2022'


update sac.dbook  set amount= 9.00 WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ABIRAAMI CREDITS' and  date= '20-08-2022' and cuscode='3899' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');


update  sac.dbook  set amount = 21.00 WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ABIRAAMI CREDITS' and  date= '25-08-2022' and cuscode='3899' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

select * from   sac.tdscredits  where cmpname='SRI ABIRAAMI CREDITS' and cuscode='3899' 
update   sac.tdscredits set amount = 9.00  where cmpname='SRI ABIRAAMI CREDITS' and cuscode='3899' and todaydate='20-08-2022'


SELECT * FROM sac.dbook WHERE date BETWEEN '01-04-2018' and '20-04-2024' and cmpname='SRI ANDAAL CREDITS' and cuscode='2987' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
select * from sac.dbook WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ANDAAL CREDITS' and date = '16-11-2022' and cuscode='2987' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

update sac.dbook set amount = '1820.00' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ANDAAL CREDITS' and date = '16-11-2022' and cuscode='2987' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
update sac.dbook set amount = '427.00' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ANDAAL CREDITS' and date = '21-12-2022' and cuscode='2987' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

SELECT * FROM sac.dbook WHERE date BETWEEN '01-04-2018' and '20-04-2024' and cmpname='SRI ANDAAL CREDITS' and cuscode='0138'  and time = '12:09:35' and date = '10-08-2022' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
update sac.dbook set amount = '53.00' WHERE date BETWEEN '01-04-2018' and '20-04-2024' and cmpname='SRI ANDAAL CREDITS' and cuscode='0138'  and time = '12:09:35' and date = '10-08-2022' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
update sac.dbook set amount = '214.00' WHERE date BETWEEN '01-04-2018' and '20-04-2024' and cmpname='SRI ANDAAL CREDITS' and cuscode='0138'  and time = '12:36:01' and date = '10-08-2022' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

select * from   sac.tdscredits  where cmpname='SRI ANDAAL CREDITS' and cuscode='0138' and id = 696
update  sac.tdscredits set amount = '53.00' where cmpname='SRI ANDAAL CREDITS' and cuscode='0138' and id = 696
update  sac.tdscredits set amount = '214.00' where cmpname='SRI ANDAAL CREDITS' and cuscode='0138' and id = 697

select * from   sac.tdscredits  where cmpname='SRI ANDAAL CREDITS' and cuscode='2987' and todaydate= '16-11-2022'
update  sac.tdscredits set amount = 1820.00  where cmpname='SRI ANDAAL CREDITS' and cuscode='2987' and todaydate= '16-11-2022'
update  sac.tdscredits set amount = 427.00  where cmpname='SRI ANDAAL CREDITS' and cuscode='2987' and todaydate= '21-12-2022'
update sac.dbook set amount = '103840.00' WHERE date BETWEEN '01-04-2018' and '20-04-2024' and cmpname='SRI ANDAAL CREDITS' and cuscode='2987'  and date='21-12-2022' and description = 'PN Dr A/C'
update sac.dbook set amount = '116379.00' WHERE date BETWEEN '01-04-2018' and '20-04-2024' and cmpname='SRI ANDAAL CREDITS' and cuscode='2987'  and date='16-11-2022' and description = 'PN Dr A/C'


update sac.dbook set amount = '53.50' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and date = '10-08-2022'  and time = '14:47:06' and cmpname='SRI AMBIGAI FINANCE' and cuscode='0138' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
update sac.dbook set amount = '213.50' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and date = '10-08-2022'  and time = '14:48:59' and cmpname='SRI AMBIGAI FINANCE' and cuscode='0138' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');





SELECT * FROM sac.dbook WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI PUGAZHIMURUGAN ASSOCIATES' and cuscode='0138' and date= '10-08-2022' and time = '13:34:23' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
update sac.dbook set amount = '54.00' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI PUGAZHIMURUGAN ASSOCIATES' and cuscode='0138' and date= '10-08-2022' and time = '13:34:23' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

update sac.dbook set amount = '214.00' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI PUGAZHIMURUGAN ASSOCIATES' and cuscode='0138' and date= '10-08-2022' and time = '13:37:13' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

select * from   sac.tdscredits  where cmpname='SRI PUGAZHIMURUGAN ASSOCIATES' and cuscode='0138' and id=698
update  sac.tdscredits set amount = '54.00' where cmpname='SRI PUGAZHIMURUGAN ASSOCIATES' and cuscode='0138' and id=698
update  sac.tdscredits set amount = '214.00' where cmpname='SRI PUGAZHIMURUGAN ASSOCIATES' and cuscode='0138' and id=699




15-06-2024:
update sac.dbook set description = 'ROOM RENT Dr A/C' where date >= '2024-02-29' and date <= '2024-03-01' and details = 'MAHESH.C' and cmpname = 'SRI ATHISAKTHI CREDITS';
UPDATE sac.expense set type= 'ROOM RENT' where  date >= '2024-02-29' and date <= '2024-03-01' and detail = 'MAHESH.C' and cmpname = 'SRI ATHISAKTHI CREDITS';



SELECT * FROM sac.dbook WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ANDAAL FINANCE' and cuscode='1604' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
delete from sac.dbook WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ANDAAL FINANCE' and cuscode='1604' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
select * from   sac.tdscredits  where cmpname='SRI ANDAAL FINANCE' and cuscode='1604' 
delete from   sac.tdscredits  where cmpname='SRI ANDAAL FINANCE' and cuscode='1604' 

SELECT * FROM sac.dbook WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ANDAAL FINANCE' and cuscode='4622' and date = '11-08-2022' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
update sac.dbook set amount = '53.70' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ANDAAL FINANCE' and cuscode='4622' and date = '11-08-2022' and time = '18:13:47' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

update sac.dbook set amount = '13.70' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI ANDAAL FINANCE' and cuscode='4622' and date = '11-08-2022' and time = '18:44:10' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');


update  sac.tdscredits set amount = '53.70' where cmpname='SRI ANDAAL FINANCE' and cuscode='4622' and id=713;
update  sac.tdscredits set amount = '13.70' where cmpname='SRI ANDAAL FINANCE' and cuscode='4622' and id=714




update sac.dbook set amount = '53.50' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and date = '10-08-2022'  and time = '14:47:06' and cmpname='SRI AMBIGAI FINANCE' and cuscode='0138' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
update sac.dbook set amount = '213.50' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and date = '10-08-2022'  and time = '14:48:59' and cmpname='SRI AMBIGAI FINANCE' and cuscode='0138' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

update  sac.tdscredits set amount = '53.50' where cmpname='SRI AMBIGAI FINANCE' and cuscode='0138' and id = 705;
update  sac.tdscredits set amount = '213.50' where cmpname='SRI AMBIGAI FINANCE' and cuscode='0138' and id = 706

select * from   sac.tdscredits  where cmpname='SRI AMBIGAI FINANCE' and cuscode='0138'


SELECT * FROM sac.dbook WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI KARPAGAMBAL FINANCE' and cuscode='0138' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C'); 
update sac.dbook set amount = '53.50' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and date = '10-08-2022'  and time = '14:52:40' and cmpname='SRI KARPAGAMBAL FINANCE' and cuscode='0138' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');
update sac.dbook set amount = '213.50' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and date = '10-08-2022'  and time = '14:54:44' and cmpname='SRI KARPAGAMBAL FINANCE' and cuscode='0138' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C');

select * from   sac.tdscredits  where cmpname='SRI KARPAGAMBAL FINANCE' and cuscode='0138'
update  sac.tdscredits set amount = '53.50' where cmpname='SRI KARPAGAMBAL FINANCE' and cuscode='0138' and id = 707;
update  sac.tdscredits set amount = '213.50' where cmpname='SRI KARPAGAMBAL FINANCE' and cuscode='0138' and id = 708


SELECT * FROM sac.dbook WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI AKILANDESWARI CREDITS' and cuscode='0138' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C'); 

update sac.dbook set amount = '693.00' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI AKILANDESWARI CREDITS' and cuscode='0138' and date = '10-08-2022' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C'); 

update  sac.tdscredits set amount = '693.00' where cmpname='SRI AKILANDESWARI CREDITS' and cuscode= '0138' and id = 700;


SELECT * FROM sac.dbook WHERE date BETWEEN '01-04-2018' and '13-04-2024' and cmpname='SRI AMBIGAI CAPITALS' and cuscode='0138' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C'); 


update sac.dbook set amount = '533.00' WHERE date BETWEEN '01-04-2018' and '13-04-2024' and time= '14:09:28' and cmpname='SRI AMBIGAI CAPITALS' and cuscode='0138' and date = '10-08-2022' and description IN ('Int TDS Deduction Cr A/C', 'Int TDS Deduction Dr A/C'); 

select * from   sac.tdscredits  where cmpname='SRI AMBIGAI CAPITALS' and cuscode='0138';

update  sac.tdscredits set amount = '533.00' where cmpname='SRI AMBIGAI CAPITALS' and cuscode='0138' and id = 701;