/*ORDER 502299*/  
      
      /*
      CHANGE REPORT for Table CUSTOMERRENTPRICE
          - Changing column definition of TYPEOFRENT
          - Adding column INVOICEFREQUENCYNUMBER
      ACTION is ALTER or modify Table CUSTOMERRENTPRICE
      */

COMMENT ON COLUMN CUSTOMERRENTPRICE.TYPEOFRENT IS '1=Piece price 
2=Changes/Wk 
3=Overuse price 
4=Per Frequency
5=Underuse Price
6=Lease
7=Split price
8=Per Invoice Frequency';


ALTER TABLE CUSTOMERRENTPRICE ADD (INVOICEFREQUENCYNUMBER NUMBER DEFAULT 10 NOT 
    NULL);

COMMENT ON COLUMN CUSTOMERRENTPRICE.INVOICEFREQUENCYNUMBER IS '10=Weekly
40=Every 4 weeks
110=Monthly';
      
      /*
      CHANGE REPORT for Table GENERALRENTPRICE
          - Changing column definition of TYPEOFRENT
          - Adding column INVOICEFREQUENCYNUMBER
      ACTION is ALTER or modify Table GENERALRENTPRICE
      */

COMMENT ON COLUMN GENERALRENTPRICE.TYPEOFRENT IS '1=Piece price 
2=Changes/Wk 
3=Overuse price 
4=Per Frequency
5=Underuse Price
6=Lease
7=Split price
8=Per Invoice Frequency';


ALTER TABLE GENERALRENTPRICE ADD (INVOICEFREQUENCYNUMBER NUMBER DEFAULT 10 NOT 
    NULL);

COMMENT ON COLUMN GENERALRENTPRICE.INVOICEFREQUENCYNUMBER IS '10=Weekly
40=Every 4 weeks
110=Monthly';

      /*
      CHANGE REPORT for Table INVOICEFREQUENCY
          - Adding column PRICEFREQUENCYNUMBER
      ACTION is ALTER or modify Table INVOICEFREQUENCY
      */

ALTER TABLE INVOICEFREQUENCY ADD (PRICEFREQUENCYNUMBER NUMBER DEFAULT 0 NOT 
    NULL);

COMMENT ON COLUMN INVOICEFREQUENCY.INVOICEFREQUENCYNUMBER IS '0=Direct
10=Weekly
20=Every 2 weeks
30=Every 3 weeks
40=Every 4 weeks
45=4-4-5 week schedule
50=Every 8 weeks
60=Every 13 weeks
65=Every 16 weeks
70=Every 26 weeks
80=Every 52 weeks
105=Twice a Month 
110=Monthly
120=Every 2 Months
130=Every 3 Months
160=Every 6 Months
200=Manual
';
COMMENT ON COLUMN INVOICEFREQUENCY.PRICEFREQUENCYNUMBER IS '0=Default value
40=The price frequency is 4Weekly';

     
      /*
      CHANGE REPORT for Table PRODUCTLISTPERCUSTOMER
          - Adding column INVOICEFREQRELATEDRENTPRICE
      ACTION is ALTER or modify Table PRODUCTLISTPERCUSTOMER
      */

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






