use T25R002 

ALTER TABLE OPENING_MILL_GP Add BillType Varchar(7)
ALTER TABLE GP_RECEIVED_FROM_MILL Add BillType Varchar(7)
ALTER TABLE FINISHED_RECEIVED_FROM_MILL Add BillType Varchar(7)
ALTER TABLE OPENING_FINISHED_RECEIVED_FROM_MILL Add BillType Varchar(7)
Create Table MILL_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))

UPDATE OPENING_MILL_GP SET BillType ='PROCA/C'
UPDATE GP_RECEIVED_FROM_MILL SET BillType ='PROCA/C'
UPDATE FINISHED_RECEIVED_FROM_MILL SET BillType ='PROCA/C'
UPDATE OPENING_FINISHED_RECEIVED_FROM_MILL SET BillType ='PROCA/C'
INSERT INTO MILL_ACCOUNT_TYPES VALUES ('PROCA/C')