use T24K001
CREATE TABLE MILL_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
INSERT INTO MILL_ACCOUNT_TYPES Values('PROCA/C')


ALTER TABLE GP_RECEIVED_FROM_MILL ADD BillType Varchar(7)

UPDATE GP_RECEIVED_FROM_MILL SET BillType = 'PROCA/C'