-- ABS-133297
ALTER TABLE ERP_I_CUSTOMER
  DROP CONSTRAINT CHK_ERPI_CUS_NOPREPCHARGE;
ALTER TABLE ERP_I_CUSTOMER
  ADD CONSTRAINT CHK_ERPI_CUS_NOPREPCHARGE
  CHECK ((DAYSNOPREPCHARGE >0 AND NOPREPCHARGE1STINVOICE = 'N') OR (DAYSNOPREPCHARGE =0 AND NOPREPCHARGE1STINVOICE = 'Y'));


ALTER TABLE ERP_U_CUSTOMER ADD (SEARCHNAME VARCHAR2(10),
                                DAYSNOPREPCHARGE NUMBER,
                                NOPREPCHARGE1STINVOICE VARCHAR2(1),
                                NOEMBLEMCHARGE1STINVOICE VARCHAR2(1),
                                SPECIALSIZECHARGE VARCHAR2(1));
ALTER TABLE ERP_U_CUSTOMER
  ADD CONSTRAINT CHK_ERPU_CUS_NOPREPCHARGE1STINVOICE
  CHECK (NOPREPCHARGE1STINVOICE IN ('Y','N'));
ALTER TABLE ERP_U_CUSTOMER
  ADD CONSTRAINT CHK_ERPU_CUS_NOPREPCHARGE
  CHECK ((DAYSNOPREPCHARGE >0 AND NOPREPCHARGE1STINVOICE = 'N') OR (DAYSNOPREPCHARGE =0 AND NOPREPCHARGE1STINVOICE = 'Y'));
ALTER TABLE ERP_U_CUSTOMER
  ADD CONSTRAINT CHK_ERPU_CUS_NOEMBLEMCHARGE1STINVOICE
  CHECK (NOEMBLEMCHARGE1STINVOICE  IN ('Y','N'));
