--ABS-128259
ALTER TABLE ERP_I_DELIVERYVARIATIONS ADD (FIXEDAMOUNT VARCHAR2(1) DEFAULT 'N' NOT NULL);
ALTER TABLE ERP_I_DELIVERYVARIATIONS
  ADD CONSTRAINT CHK_ERP_I_DELIVERYVARIATIONS_FA
  CHECK (FIXEDAMOUNT IN ('Y', 'N'));
COMMENT ON COLUMN ERP_I_DELIVERYVARIATIONS.FIXEDAMOUNT
  IS 'If is set to Y only this quantity will be delivered (standard deliveries and other delivery variations with no fixed amount for this product/size/finishing method will be overruled)';
