-- ABS-21481
----------------   UHFBUNDLE   -------------------
ALTER TABLE UHFBUNDLE ADD (DELIVERYSTATUS NUMBER DEFAULT 0 NOT NULL);

COMMENT ON COLUMN UHFBUNDLE.DELIVERYSTATUS
IS '0 = UNKNOWN, 1 = NOT YET DELIVERED, 2 = DELIVERED';

----------------   SCAN   -------------------
ALTER TABLE SCAN ADD (VIRTUALYN VARCHAR2(1));

----------------   MULTIREADSCANBATCH   -------------------                                      
ALTER TABLE MULTIREADSCANBATCH ADD (VIRTUALQTYNOTUNIQUE NUMBER DEFAULT 0 NOT NULL);

----------------   MULTIREADSCANBATCHCONTENTS   -------------------      
ALTER TABLE MULTIREADSCANBATCHCONTENTS ADD (VIRTUALYN VARCHAR2(1),
                                         BUNDLEADDEDYN VARCHAR2(1),
                                         BUNDLEPROCESSEDYN VARCHAR2(1));


