⬅ Back Dhiraj Silk Mills 22-06-2022.sql
use t23d001


ALTER TABLE ORDER_BILL_DETAIL DROP COLUMN TransChanrge
ALTER TABLE OPENING_ORDER_BILL_DETAIL DROP COLUMN TransChanrge

ALTER TABLE OPENING_ORDER_BILL_DETAIL ADD TransCharge Money
ALTER TABLE ORDER_BILL_DETAIL ADD TransCharge Money

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