--20015616.80

----------PLPC table-----------

ALTER TABLE PRODUCTLISTPERCUSTOMER
	ADD (DEPRECIATIONLOSSSCHEME_ID NUMBER NULL);

CREATE INDEX XIF24PRODUCTLISTPERCUSTOMER ON PRODUCTLISTPERCUSTOMER (DEPRECIATIONLOSSSCHEME_ID);

ALTER TABLE PRODUCTLISTPERCUSTOMER 
  ADD CONSTRAINT PLPC_RESIDUALVALSCHEME FOREIGN KEY (DEPRECIATIONLOSSSCHEME_ID)
  REFERENCES RESIDUALVALUESCHEME (RESIDUALVALUESCHEME_ID) ON DELETE SET NULL;


----------CUSTOMERtable-----------

ALTER TABLE CUSTOMER
	ADD (DEPRECIATIONLOSSCHARGE VARCHAR2(1) DEFAULT 'N' NOT NULL  CONSTRAINT YN_VALIDATIONFIELD126 CHECK (DEPRECIATIONLOSSCHARGE IN ('Y','N')));

