--Order 20015398.70

----------------------PRODUCTLISTPERCUSTOMER-----------------

ALTER TABLE PRODUCTLISTPERCUSTOMER
ADD (FREECLEANCHANGE VARCHAR2(1) DEFAULT 'N' NOT NULL  CONSTRAINT YN_VALIDATIONFIELD237 CHECK (FREECLEANCHANGE IN ('Y','N')));

--------------------INVOICELINESUBTYPE--------------------

insert into invoicelinesubtype i
      (i.invoicelinesubtype_id,
       subtype,
       invoicelinetype_id,
       factorydescription,
       systemuser_id,
       timestamp)
      select seq_invoicelinesubtype.nextval,
             44,
             2,
             'Free Clean Change Per Week',
             1,
             sysdate
        from dual;
commit;

----------------PACKINGNOTELINE-------------------------

ALTER TABLE PACKINGNOTELINE
ADD (QTYFREECLEANCHANGE NUMBER DEFAULT 0 NOT NULL );


