      
      /*
      CHANGE REPORT for Table STOCKROOM
          - Adding column REGISTERPICKINGFROMSTOCK
          - Adding column REGISTERPICKINGFORWORKORDER
          - Adding column REGISTERPICKINGFORGENERALPOOL
          - Adding column REGISTERPICKINGFORCUSTOMERPOOL
          - Adding column REGISTERPICKINGFORSALESNOTE
          - Adding column REGISTERPICKINGFORSTOCKDELIVER
          - Adding column REGISTERPICKINGFORMOUNTING
      ACTION is ALTER or modify Table STOCKROOM
      */

ALTER TABLE STOCKROOM ADD (REGISTERPICKINGFROMSTOCK VARCHAR2(1) DEFAULT 'N' NOT 
    NULL
                                   CONSTRAINT YN_ValidationNew102
                                          CHECK (REGISTERPICKINGFROMSTOCK IN 
    ('Y', 'N')));


ALTER TABLE STOCKROOM ADD (REGISTERPICKINGFORWORKORDER VARCHAR2(1) DEFAULT 'N' 
    NOT NULL
                                   CONSTRAINT YN_ValidationNew103
                                          CHECK (REGISTERPICKINGFORWORKORDER IN 
    ('Y', 'N')));


ALTER TABLE STOCKROOM ADD (REGISTERPICKINGFORGENERALPOOL VARCHAR2(1) DEFAULT 
    'N' NOT NULL
                                   CONSTRAINT YN_ValidationNew104
                                          CHECK (REGISTERPICKINGFORGENERALPOOL 
    IN ('Y', 'N')));


ALTER TABLE STOCKROOM ADD (REGISTERPICKINGFORCUSTOMERPOOL VARCHAR2(1) DEFAULT 
    'N' NOT NULL
                                   CONSTRAINT YN_ValidationNew105
                                          CHECK (REGISTERPICKINGFORCUSTOMERPOOL 
    IN ('Y', 'N')));


ALTER TABLE STOCKROOM ADD (REGISTERPICKINGFORSALESNOTE VARCHAR2(1) DEFAULT 'N' 
    NOT NULL
                                   CONSTRAINT YN_ValidationNew106
                                          CHECK (REGISTERPICKINGFORSALESNOTE IN 
    ('Y', 'N')));


ALTER TABLE STOCKROOM ADD (REGISTERPICKINGFORSTOCKDELIVER VARCHAR2(1) DEFAULT 
    'N' NOT NULL
                                   CONSTRAINT YN_ValidationNew107
                                          CHECK (REGISTERPICKINGFORSTOCKDELIVER 
    IN ('Y', 'N')));


ALTER TABLE STOCKROOM ADD (REGISTERPICKINGFORMOUNTING VARCHAR2(1) DEFAULT 'N' 
    NOT NULL
                                   CONSTRAINT YN_ValidationNew108
                                          CHECK (REGISTERPICKINGFORMOUNTING IN 
    ('Y', 'N')));

