-- ABS-20977

ALTER TABLE INVOICEJOBSCHEDULE ADD (ERP_EXPORT VARCHAR2(1) DEFAULT 'X' NULL 
                                             CONSTRAINT ERP_EXPORT_VALID1_1 CHECK (ERP_EXPORT IN ('Y','N','X')));
 
COMMENT ON COLUMN INVOICEJOBSCHEDULE.ERP_EXPORT
  IS 'Indicates if invoices have been exported for this run ( initial default will be X for possible existing records, new records get N )';
  
ALTER TABLE INVOICEJOBSCHEDULE MODIFY (ERP_EXPORT DEFAULT 'N');

CREATE INDEX XIE3INVOICEJOBSCHEDULE ON INVOICEJOBSCHEDULE (ERP_EXPORT ASC);