⬅ Back OrderNot recrd FindQur.txt
use T22R001


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