  
      
      /*
      CHANGE REPORT for Table PLANTINVOICELINETYPE
          - Adding column SUPPRESSPRINTING
      ACTION is ALTER or modify Table PLANTINVOICELINETYPE
      */

ALTER TABLE PLANTINVOICELINETYPE ADD (SUPPRESSPRINTING     NUMBER DEFAULT 0 NOT 
    NULL
                                   CONSTRAINT SuppressPrint
                                          CHECK (SUPPRESSPRINTING IN (0, 1, 2)))
    ;

COMMENT ON COLUMN PLANTINVOICELINETYPE.SUPPRESSPRINTING IS'0 = Always when Amount is zero 1 = Only when Quantity is zero 2 = Never';


update plantinvoicelinetype p
set p.suppressprinting = (select i.supressprinting from invoicelinetype i where i.invoicelinetype_id = p.invoicelinetype_id);