---all firm with common
ALTER TABLE ACCOUNT_MASTER ADD DOB DateTime
UPDATE ACCOUNT_MASTER SET DOB=''

---all firm
ALTER TABLE GP_RECEIVED_FROM_MILL_CHALLAN_DETAIL ADD RD Money, RDAmt Money, LessAmt Money
ALTER TABLE FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL ADD RD Money, RDAmt Money, LessAmt Money
ALTER TABLE OPENING_FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL ADD RD Money, RDAmt Money, LessAmt Money
ALTER TABLE OPENING_YARN_RECEIVED_FROM_MILL_CHALLAN_DETAIL ADD RD Money, RDAmt Money, LessAmt Money
                
UPDATE GP_RECEIVED_FROM_MILL_CHALLAN_DETAIL Set RD=0,RDAmt=0,LessAmt=0
UPDATE FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL Set RD=0,RDAmt=0,LessAmt=0
UPDATE OPENING_FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL Set RD=0,RDAmt=0,LessAmt=0
UPDATE OPENING_YARN_RECEIVED_FROM_MILL_CHALLAN_DETAIL Set RD=0,RDAmt=0,LessAmt=0