USE T27C001 

UPDATE UPDATE_DETAIL SET UpdNo=431

SELECT * FROM GP_RECEIVED_FROM_MILL_CHALLAN_DETAIL


ALTER TABLE ACCOUNT_MASTER ADD DOB DateTime
UPDATE ACCOUNT_MASTER SET DOB=''
    
ALTER TABLE GP_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

ALTER TABLE FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL ADD RD Money, RDAmt Money, LessAmt Money
UPDATE FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL Set RD=0,RDAmt=0,LessAmt=0

ALTER TABLE OPENING_FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL ADD RD Money, RDAmt Money, LessAmt Money
UPDATE OPENING_FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL Set RD=0,RDAmt=0,LessAmt=0

ALTER TABLE OPENING_YARN_RECEIVED_FROM_MILL_CHALLAN_DETAIL ADD RD Money, RDAmt Money, LessAmt Money
UPDATE OPENING_YARN_RECEIVED_FROM_MILL_CHALLAN_DETAIL Set RD=0,RDAmt=0,LessAmt=0