/*order 502382*/  
      /*
      CHANGE REPORT for Table INVOICEFREQUENCY
          - Changing column definition of INVOICEFREQUENCYNUMBER
      ACTION is ALTER or modify Table INVOICEFREQUENCY
      */

INSERT INTO INVOICEFREQUENCY
  (INVOICEFREQUENCY_ID,
   INVOICEFREQUENCYNUMBER,
   FACTORYDESCRIPTION,
   SYSTEMUSER_ID,
   TIMESTAMP,
   DEFAULTFREQUENCY)
  SELECT 140, 140, 'Every 4 months', GETMINSYSTEMUSER(), SYSDATE, 'N' FROM DUAL;
  
INSERT INTO INVOICEFREQUENCY_DESC
  (INVOICEFREQUENCY_ID, LANGUAGE_ID, DESCRIPTION, SYSTEMUSER_ID, TIMESTAMP)
  SELECT X.INVOICEFREQUENCY_ID,
         L.LANGUAGE_ID,
         X.FACTORYDESCRIPTION,
         X.SYSTEMUSER_ID,
         X.TIMESTAMP
    FROM INVOICEFREQUENCY X, LANGUAGES L
   WHERE X.INVOICEFREQUENCY_ID = 140
     AND L.TRANSLATEDESCRIPTION = 'Y';

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
140=Every 4 Months
160=Every 6 Months
200=Manual
';

