--Order 20015714.60


-- REASONCODE table
ALTER TABLE REASONCODE ADD (REASONFORAPO VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT YN_VALIDATIONFIELD235 CHECK (REASONFORAPO  IN ('Y' , 'N')));


-- WORKORDERLINE table
ALTER TABLE WORKORDERLINE ADD (DEFAULTSUPPLIER_ID NUMBER NULL);

CREATE INDEX XIF15WORKORDERLINE ON WORKORDERLINE
(DEFAULTSUPPLIER_ID   ASC);

ALTER TABLE WORKORDERLINE
ADD CONSTRAINT WORKORDERLINE_SUPPL FOREIGN KEY (DEFAULTSUPPLIER_ID) REFERENCES SUPPLIER (SUPPLIER_ID) ON DELETE SET NULL;


-- PRODUCTLISTPERCUSTOMER table
ALTER TABLE PRODUCTLISTPERCUSTOMER ADD (DEFAULTSUPPLIER_ID NUMBER NULL);

CREATE INDEX XIF23PRODUCTLISTPERCUSTOMER ON PRODUCTLISTPERCUSTOMER
(DEFAULTSUPPLIER_ID   ASC);

ALTER TABLE PRODUCTLISTPERCUSTOMER
ADD CONSTRAINT PRODUCTLISTPERCUSTOMER_SUPPL FOREIGN KEY (DEFAULTSUPPLIER_ID) REFERENCES SUPPLIER (SUPPLIER_ID) ON DELETE SET NULL;