--ABS-76585 revenue and invoices; contract and routes interface
ALTER TABLE ROUTE ADD (ERP_EXPORTED VARCHAR2(1) DEFAULT 'N' NOT NULL
  CONSTRAINT CHK_ROUTE_ERP CHECK (ERP_EXPORTED IN ('N','Y','X')));
CREATE INDEX INDX_ROUTE_ERP ON ROUTE(ERP_EXPORTED);