USE E19M001

ALTER TABLE MULTI_JOURNAL_ADDLESS_DETAIL ADD ROffAmt Money
UPDATE MULTI_JOURNAL_ADDLESS_DETAIL SET ROffAmt =0

ALTER TABLE MULTI_JOURNAL_ADDLESS_DETAIL ADD TDSPerc Money,TDSAmt Money,TDSAcc Varchar(7),IncomeTaxPerc Money,IncomeTaxAmt Money,SurchargePerc Money,SurchargeAmt Money,EduCessPerc Money,EduCessAmt Money,TDSType Varchar(35),TDSDate DateTime,TDSRecPay Varchar(35)
UPDATE MULTI_JOURNAL_ADDLESS_DETAIL Set TDSPerc=0,TDSAmt=0,TDSAcc='',IncomeTaxPerc=0,IncomeTaxAmt=0,SurchargePerc=0,SurchargeAmt=0,EduCessPerc=0,EduCessAmt=0,TDSType='',TDSDate=JVDate, TDSRecPay='NO'