-- ABS-118073/ ABS-121792
------ ROUTE TABLE ------
ALTER TABLE ROUTE ADD (DAYSBEFORETOGENERATEGARMDELN NUMBER DEFAULT 0 NOT NULL
                       CONSTRAINT CHK_ROUTE_DAYSBEFGENGARMDN CHECK (DAYSBEFORETOGENERATEGARMDELN BETWEEN 0 AND 7));

COMMENT ON COLUMN ROUTE.DAYSBEFORETOGENERATEGARMDELN
  IS '0 =  Don’t generate.
Max 7.
Used with a scheduled process to automatically generate garment delivery notes.
';
