--ABS-95414 Enhancement to ERP stockroom tables
ALTER TABLE PURCHASEORDERHEADER ADD (ERP_EXPORTED VARCHAR2(1) DEFAULT 'N' NOT NULL
  CONSTRAINT CHK_PURCHASEORDERHEAD_ERP CHECK (ERP_EXPORTED IN ('N','Y','X')));
CREATE INDEX INDX_PURCHASEORDERHEAD_ERP ON PURCHASEORDERHEADER(ERP_EXPORTED ASC);
COMMENT ON COLUMN PURCHASEORDERHEADER.ERP_EXPORTED
  IS 'N=Not exported, Y=Exported, X=Inbetweem exports';