-- ABS-16847
-----  SUPPLIER  -------
ALTER TABLE SUPPLIER ADD (SHIPMENTTYPE_ID NUMBER NULL);

CREATE INDEX XIF6SUPPLIER ON SUPPLIER (SHIPMENTTYPE_ID ASC);

ALTER TABLE SUPPLIER
  ADD CONSTRAINT SUPPLIER_SHIPMENTTYPE_ID FOREIGN KEY (SHIPMENTTYPE_ID)
  REFERENCES SHIPMENTTYPE (SHIPMENTTYPE_ID);
  
----  PURCHASEORDERHEADER  ----
ALTER TABLE PURCHASEORDERHEADER ADD (SHIPMENTTYPE_ID NUMBER NULL);

CREATE INDEX XIF9PURCHASEORDERHEADER ON PURCHASEORDERHEADER (SHIPMENTTYPE_ID ASC);

ALTER TABLE PURCHASEORDERHEADER
  ADD CONSTRAINT PORDERHEADER_SHIPMENTTYPE_ID FOREIGN KEY (SHIPMENTTYPE_ID)
  REFERENCES SHIPMENTTYPE (SHIPMENTTYPE_ID);
