--Order 20011656

ALTER TABLE DELIVERYSCAN
	ADD (INTERNALPROCESSINGBU_ID NUMBER NULL);

ALTER TABLE DELIVERYSCAN
ADD CONSTRAINT DELIVERYSCAN_INTERNALPROCESSBU FOREIGN KEY (INTERNALPROCESSINGBU_ID) REFERENCES BUSINESSUNIT (BUSINESSUNIT_ID);

CREATE  INDEX XIF16DELIVERYSCAN ON DELIVERYSCAN
(INTERNALPROCESSINGBU_ID   ASC);

CREATE  INDEX XIE23DELIVERYSCAN ON DELIVERYSCAN
(BUSINESSUNIT_ID   ASC,INTERNALPROCESSINGBU_ID   ASC,CUSTOMER_LINK_ID   ASC);