-- ABS-70820 / ABS-72025
--- EDI_I_FEDSTRIP ---
ALTER TABLE EDI_I_FEDSTRIP MODIFY (FILENAME VARCHAR2(200));
ALTER TABLE EDI_I_FEDSTRIP ADD (PROCESSED NUMBER DEFAULT 0 NOT NULL CONSTRAINT PROCESSED_VALID1 CHECK (PROCESSED IN (0,1,2)));

COMMENT ON COLUMN EDI_I_FEDSTRIP.PROCESSED IS '0 - Not processed, 1 - Successfully processed, 2 - Error';

--- EDI_I_CONTRACTPO ---
ALTER TABLE EDI_I_CONTRACTPO MODIFY (PROCESSED NUMBER DEFAULT 0);
ALTER TABLE EDI_I_CONTRACTPO ADD CONSTRAINT PROCESSED_VALID2 CHECK (PROCESSED IN (0,1,2));
ALTER TABLE EDI_I_CONTRACTPO ADD (IMPORTEDDATE DATE NULL);

COMMENT ON COLUMN EDI_I_CONTRACTPO.PROCESSED IS '0 - Not processed, 1 - Successfully processed, 2 - Error';
COMMENT ON COLUMN EDI_I_CONTRACTPO.IMPORTEDDATE IS 'Updated when imported into the Contract Purchase Order tables';


