USE T23M001

alter table  ORDER_BILL_DETAIL drop column TransChanrge
alter table  opening_ORDER_BILL_DETAIL drop column TransChanrge
ALTER TABLE ORDER_BILL_DETAIL ADD TransCharge Money
ALTER TABLE OPENING_ORDER_BILL_DETAIL ADD TransCharge Money

UPDATE ORDER_BILL_DETAIL SET TransCharge = 0        
UPDATE OPENING_ORDER_BILL_DETAIL SET TransCharge = 0