-- ABS-119395/ ABS-120921
ALTER TABLE CUSTOMERGENERAL ADD (DEFAULTRESIDUALVALUESCHEME_ID NUMBER NULL);

CREATE INDEX XIF1CUSTOMERGENERAL ON CUSTOMERGENERAL (DEFAULTRESIDUALVALUESCHEME_ID);

ALTER TABLE CUSTOMERGENERAL
  ADD CONSTRAINT FK_CUSTOMERGENERAL_DEFRESVAL_ID FOREIGN KEY (DEFAULTRESIDUALVALUESCHEME_ID)
  REFERENCES RESIDUALVALUESCHEME (RESIDUALVALUESCHEME_ID) ON DELETE SET NULL;