 -- order 502813

/*
      CHANGE REPORT for Table BATCH
          - Adding column DIRECTINVOICETIMESTAMP
      ACTION is ALTER or modify Table BATCH
      */

ALTER TABLE BATCH ADD (DIRECTINVOICETIMESTAMP DATE NULL);

      
      /*
      CHANGE REPORT for Table CLIENTINVOICECATEGORY
          - Adding column CLIENTINVOICETYPE
      ACTION is ALTER or modify Table CLIENTINVOICECATEGORY
      */

ALTER TABLE CLIENTINVOICECATEGORY ADD (CLIENTINVOICETYPE    NUMBER(1) DEFAULT 0 
    NOT NULL
                                   CONSTRAINT ClientInvoiceType_Valid
                                          CHECK (CLIENTINVOICETYPE IN (0, 1)));

      
      /*
      CHANGE REPORT for Table INVOICEHEADERCLIENT
          - Adding column CLIENTINVOICETYPE
          - Adding column PAIDDATE
      ACTION is ALTER or modify Table INVOICEHEADERCLIENT
      */

ALTER TABLE INVOICEHEADERCLIENT ADD (CLIENTINVOICETYPE    NUMBER(1) DEFAULT 0 
    NOT NULL
                                   CONSTRAINT ClientInvoiceType_Valid2
                                          CHECK (CLIENTINVOICETYPE IN (0, 1)));


ALTER TABLE INVOICEHEADERCLIENT ADD (PAIDDATE             DATE NULL);

