-- order 502499

   
      /*
      CHANGE REPORT for Table UNRELATEDLOAN
          - change null constraint from NOT NULL to NULL of column PACKINGNOTELINE_ID
          - Changing column definition of PACKINGNOTELINE_ID
      ACTION is ALTER or modify Table UNRELATEDLOAN
      IMPACT ANALYSIS REPORT for ALTER or modify Table UNRELATEDLOAN
          - index XIF4UNRELATEDLOAN needs to be removed in order to proceed. 
      */

ALTER TABLE UNRELATEDLOAN MODIFY (PACKINGNOTELINE_ID NULL);


COMMENT ON COLUMN UNRELATEDLOAN.PACKINGNOTELINE_ID IS 'May be left empty, since an unrelated loan can be created without being linked to a packing note line yet.';
