-- ABS-73318 EDI Export Mulliez
-- Add TYPEOFMERCHANDISE EDI_O_PURCHASEORDERLINE
ALTER TABLE EDI_O_PURCHASEORDERLINE ADD (TYPEOFMERCHANDISE NUMBER NULL);
-- Add comments to the column 
COMMENT ON COLUMN EDI_O_PURCHASEORDERLINE.TYPEOFMERCHANDISE 
  IS '1 = Linen
2 = Garments
3 = Sales only items
4 = Emblems
5 = Residential/domestic';

--Make sure all options are there
ALTER TABLE EDI_O_PURCHASEORDERHEADER
  DROP CONSTRAINT CHK_EDI_O_PURCHASEORDERHEAD_PO;
ALTER TABLE EDI_O_PURCHASEORDERHEADER
  ADD CONSTRAINT CHK_EDI_O_PURCHASEORDERHEAD_PO
  CHECK (POEXPORTFORMAT IN (0, 1, 2));