      
ALTER TABLE PACKINGNOTE ADD (
             FINISHEDPACKING      NUMBER DEFAULT 0 NOT NULL
);

COMMENT ON COLUMN PACKINGNOTE.FINISHEDPACKING IS '0 = Not finished
1 = Finished (manually set to finished)
2 = Finished (no shortages)';

