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

ALTER TABLE ROUTECONTROLEXTRAINFO ADD (ERP_EXPORTED VARCHAR2(1) DEFAULT 'N' NOT NULL
  CONSTRAINT CHK_ROUTECONTROLEI_ERP CHECK (ERP_EXPORTED IN ('N','Y','X')));
CREATE INDEX INDX_ROUTECONTROLEI_ERP ON ROUTECONTROLEXTRAINFO (ERP_EXPORTED);
  
ALTER TABLE INVOICEHEADEREXTRAINFO ADD (ERP_EXPORTED VARCHAR2(1) DEFAULT 'N' NOT NULL
  CONSTRAINT CHK_INVOICEHEADEREI_ERP CHECK (ERP_EXPORTED IN ('N','Y','X')));
CREATE INDEX INDX_INVOICEHEADEREI_ERP ON INVOICEHEADEREXTRAINFO (ERP_EXPORTED);