-- ABS-11726

ALTER TABLE STOCKCOUNTSCHEDULE_LINK MODIFY (STOCKCOUNTSCHEDULE_ID NULL);

ALTER TABLE ALLOCATIONTRANSACTION DROP CONSTRAINT ALLOCATIONTRANSACTION_VALID2;

ALTER TABLE ALLOCATIONTRANSACTION
  ADD CONSTRAINT ALLOCATIONTRANSACTION_VALID2
  CHECK ((ONHAND IS NOT NULL AND TRANSACTIONTYPE = 1) OR (ONHAND IS NULL));
