--ABS-90975/ ABS-113066
ALTER TABLE CONTAINERSCAN ADD (SHIPMENTLISTMAT_ID NUMBER NULL);

COMMENT ON COLUMN CONTAINERSCAN.SHIPMENTLISTMAT_ID
  IS 'Only filled for at shipment list scans (module MATTRANSPORT)
';

CREATE INDEX XIF8CONTAINERSCAN  ON CONTAINERSCAN (SHIPMENTLISTMAT_ID ASC);

ALTER TABLE CONTAINERSCAN 
  ADD CONSTRAINT FK_CONTSC_SHIPLISTM FOREIGN KEY (SHIPMENTLISTMAT_ID)
  REFERENCES SHIPMENTLISTMAT(SHIPMENTLISTMAT_ID) ON DELETE SET NULL;


