⬅ Back Agency Payment Detail COlumn Name Error().sql
use T202425


ALTER TABLE RECEIVED_DETAIL ADD CommOn Varchar(15)
UPDATE RECEIVED_DETAIL SET CommOn = 'CHEQUE AMOUNT' WHERE GSTPerc=0
UPDATE RECEIVED_DETAIL SET CommOn = 'TAXABLE AMOUNT' WHERE GSTPerc<>0