--ABS-92260 / ABS-96528

--------- PRODUCTLISTPERCUSTOMER ------------
ALTER TABLE PRODUCTLISTPERCUSTOMER ADD (DEFAULTRETURNGRADE_ID NUMBER NULL); 
COMMENT ON COLUMN PRODUCTLISTPERCUSTOMER.DEFAULTRETURNGRADE_ID
IS 'Default value to be displayed when taking item out of circulation.
When set to Null the value defined on Product is taken.';

CREATE INDEX XIF974PRODUCTLISTPERCUSTOMER ON PRODUCTLISTPERCUSTOMER (DEFAULTRETURNGRADE_ID ASC);
ALTER TABLE PRODUCTLISTPERCUSTOMER 
 ADD CONSTRAINT FK_PLPC_QUALITYGRADE FOREIGN KEY (DEFAULTRETURNGRADE_ID)
 REFERENCES QUALITYGRADE(QUALITYGRADE_ID) ON DELETE SET NULL;