/*order 502296*/      
      /*
      CHANGE REPORT for Table CUSTOMER
          - Adding column MININVAMOUNTTOBEREACHED
          - Adding column SPLITINVOICESPERACTIVITY
          - Adding column CONTRACTPERIOD
          - Adding column PROLONGATIONPERIOD
          - Adding column CANCELADVANCEPERIOD
      ACTION is ALTER or modify Table CUSTOMER
      */

ALTER TABLE CUSTOMER ADD (MININVAMOUNTTOBEREACHED NUMBER(15,6) DEFAULT 0 NULL);


ALTER TABLE CUSTOMER ADD (SPLITINVOICESPERACTIVITY VARCHAR2(1) DEFAULT 'N' NOT 
    NULL
                                   CONSTRAINT YN_ValidationNew138
                                          CHECK (SPLITINVOICESPERACTIVITY IN 
    ('Y', 'N')));


ALTER TABLE CUSTOMER ADD (CONTRACTPERIOD       NUMBER DEFAULT 0 NOT NULL);


ALTER TABLE CUSTOMER ADD (PROLONGATIONPERIOD   NUMBER DEFAULT 0 NOT NULL);


ALTER TABLE CUSTOMER ADD (CANCELADVANCEPERIOD  NUMBER DEFAULT 0 NOT NULL);

