ALTER TABLE OPENING_GREY_PURCHASE ADD RevCharge Varchar(3)
ALTER TABLE OPENING_FINISHED_PURCHASE ADD RevCharge Varchar(3)
ALTER TABLE OPENING_RECEIVED_FROM_JOB ADD RevCharge Varchar(3)
ALTER TABLE OPENING_GENERAL_PURCHASE ADD RevCharge Varchar(3), GSTITC Varchar(15)
ALTER TABLE OPENING_MILL_GP ADD RevCharge Varchar(3)
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
UPDATE OPENING_GREY_PURCHASE SET RevCharge='NO'
UPDATE OPENING_FINISHED_PURCHASE SET RevCharge='NO'
UPDATE OPENING_RECEIVED_FROM_JOB SET RevCharge='NO'
UPDATE OPENING_GENERAL_PURCHASE SET RevCharge='NO', GSTITC = 'INPUTS'
UPDATE OPENING_MILL_GP SET RevCharge='NO'
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''