-- Add/modify column SUPPLIERDELIVERYNOTE into a VARCHAR2(20), if it contains data, check if that data can be deleted first!
alter table ERP_O_STOCKTRANSACTION modify SUPPLIERDELIVERYNOTE VARCHAR2(20);
alter table ERP_O_WORKORDERLINE add MARKETSEGMENTCODE VARCHAR2(6);
alter table ERP_O_WORKORDERLINE add QUANTITYTOBECREDITED number;
alter table ERP_I_PURCHASEORDERLINE add UNIQUEITEM VARCHAR2(1) default 'N' not null;