--ABS-47345/ ABS-51703

---STANDARDDELIVERY table---
ALTER TABLE STANDARDDELIVERY ADD (MAXDAYSBEFORETOGENPACKN NUMBER(1) DEFAULT 0 NOT NULL
                                                          CONSTRAINT MAXDAYSBEFGENPACK_VALID1_1 CHECK (MAXDAYSBEFORETOGENPACKN BETWEEN 0 AND 7));

COMMENT ON COLUMN STANDARDDELIVERY.MAXDAYSBEFORETOGENPACKN
  IS 'The maximum number of days before a delivery date that the packing note can be generated.';