/*ORDER 502217*/      
      /*
      CHANGE REPORT for Table MISCELLANEOUSCHARGE
          - Adding a new relationship MISCELLANEOUSCHARGE_COSTCENTER
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK MISCELLANEOUSCHARGE_COSTCENTER of table MISCELLANEOUSCHARGE, which references table COSTCENTER_LINK).
          - Adding column COSTCENTER_LINK_ID
          - Adding index XIF5MISCELLANEOUSCHARGE
      ACTION is ALTER or modify Table MISCELLANEOUSCHARGE
      */

ALTER TABLE MISCELLANEOUSCHARGE ADD (COSTCENTER_LINK_ID   NUMBER NULL);

CREATE INDEX XIF5MISCELLANEOUSCHARGE ON MISCELLANEOUSCHARGE
(
       COSTCENTER_LINK_ID             ASC
);


ALTER TABLE MISCELLANEOUSCHARGE
       ADD  ( CONSTRAINT MISCELLANEOUSCHARGE_COSTCENTER
              FOREIGN KEY (COSTCENTER_LINK_ID)
                             REFERENCES COSTCENTER_LINK ) ;

