use T20G001

select * from scan_balance_sheet where (CREDITACC='20LM007' OR DEBITACC ='20LM007') AND STATUS='UN ADJ'
select SUM(AMOUNT) from scan_balance_sheet where (CREDITACC='20LM007') AND STATUS='UN ADJ'
select SUM(AMOUNT) from scan_balance_sheet where (DEBITACC='20LM007') AND STATUS='UN ADJ'