         insert into transactiontype
          (transactiontype_id,
           factorydescription,
           systemuser_id,
           timestamp)
        values
          (401, 'Put Used item in stock', getminsystemuser(), sysdate);
          
          insert into transactiontype
          (transactiontype_id,
           factorydescription,
           systemuser_id,
           timestamp)
        values
          (402, 'Put Defect item in stock', getminsystemuser(), sysdate);
          
          insert into transactiontype
          (transactiontype_id,
           factorydescription,
           systemuser_id,
           timestamp)
        values
          (403, 'Move Defect item to New stock', getminsystemuser(), sysdate);
           insert into transactiontype
          (transactiontype_id,
           factorydescription,
           systemuser_id,
           timestamp)
        values
          (404, 'Move Defect item to Used stock', getminsystemuser(), sysdate);
           insert into transactiontype
          (transactiontype_id,
           factorydescription,
           systemuser_id,
           timestamp)
        values
          (405, 'Move New item to Truck stock', getminsystemuser(), sysdate);
           insert into transactiontype
          (transactiontype_id,
           factorydescription,
           systemuser_id,
           timestamp)
        values
          (406, 'Move Defect item to Truck stock', getminsystemuser(), sysdate);
          insert into transactiontype
          (transactiontype_id,
           factorydescription,
           systemuser_id,
           timestamp)
        values
          (407, 'Move New item to Blocked stock', getminsystemuser(), sysdate);
           insert into transactiontype
          (transactiontype_id,
           factorydescription,
           systemuser_id,
           timestamp)
        values
          (408, 'Move Defect item to Blocked stock', getminsystemuser(), sysdate);
          insert into transactiontype
          (transactiontype_id,
           factorydescription,
           systemuser_id,
           timestamp)
        values
          (490, 'Stock value change', getminsystemuser(), sysdate);
          
      insert into transactiontype_desc
          (transactiontype_id,
           language_id,
           description,
           systemuser_id,
           timestamp)
          select transactiontype_id,
                 getminlanguage(),
                 factorydescription,
                 systemuser_id,
                 timestamp
            from transactiontype where transactiontype.transactiontype_id >=401 and transactiontype.transactiontype_id<=490;

     
      /*
      CHANGE REPORT for Table PRODUCT
          - Adding column USEGRADECATEGORYDEFECT
          - Adding column DEFAULTRETURNGRADE_ID
          - Adding column MOUNTINGPRODUCT
          - Adding column SHOWONMOUNTINGORDER
          - Adding column SHOWONDISMOUNTINGORDER
          - Adding column SHOWONPICKLISTRSC
          - Adding index XIF24PRODUCT
      ACTION is ALTER or modify Table PRODUCT
      */

ALTER TABLE PRODUCT ADD (USEGRADECATEGORYDEFECT VARCHAR2(1) DEFAULT 'N' NOT 
    NULL
                                   CONSTRAINT YN_ValidationNew70
                                          CHECK (USEGRADECATEGORYDEFECT IN ('Y',
     'N')));


ALTER TABLE PRODUCT ADD (DEFAULTRETURNGRADE_ID NUMBER NULL);


ALTER TABLE PRODUCT ADD (MOUNTINGPRODUCT      VARCHAR2(1) DEFAULT 'N' NOT NULL
                                   CONSTRAINT YN_ValidationNew71
                                          CHECK (MOUNTINGPRODUCT IN ('Y', 'N')))
    ;


ALTER TABLE PRODUCT ADD (SHOWONMOUNTINGORDER  VARCHAR2(1) DEFAULT 'N' NOT NULL
                                   CONSTRAINT YN_ValidationNew72
                                          CHECK (SHOWONMOUNTINGORDER IN ('Y', 
    'N')));


ALTER TABLE PRODUCT ADD (SHOWONDISMOUNTINGORDER VARCHAR2(1) DEFAULT 'N' NOT 
    NULL
                                   CONSTRAINT YN_ValidationNew73
                                          CHECK (SHOWONDISMOUNTINGORDER IN ('Y',
     'N')));


ALTER TABLE PRODUCT ADD (SHOWONPICKLISTRSC    VARCHAR2(1) DEFAULT 'N' NOT NULL
                                   CONSTRAINT YN_ValidationNew74
                                          CHECK (SHOWONPICKLISTRSC IN ('Y', 'N')
    ));



CREATE INDEX XIF24PRODUCT ON PRODUCT
(
       DEFAULTRETURNGRADE_ID          ASC
);