-- ABS-40146
------------- MULTIREADSCANBATCH -------------
ALTER TABLE MULTIREADSCANBATCH ADD (STACKCHECKPRODUCT_ID NUMBER NULL,
                                    STACKCHECKSIZE_ID NUMBER NULL,
                                    STACKCHECKSTACKSIZE NUMBER DEFAULT 0 NOT NULL,
                                    STACKCHECKPACK VARCHAR2(1) DEFAULT 'N' NOT NULL,
                                    STACKCHECKPRODUCTIDENTIFIED VARCHAR2(1) DEFAULT 'N' NOT NULL );

COMMENT ON COLUMN MULTIREADSCANBATCH.STACKCHECKPRODUCT_ID
  IS 'Only populated by stack check';
COMMENT ON COLUMN MULTIREADSCANBATCH.STACKCHECKSIZE_ID
  IS 'Only populated by stack check';
COMMENT ON COLUMN MULTIREADSCANBATCH.STACKCHECKSTACKSIZE
  IS 'Only populated by stack check';
COMMENT ON COLUMN MULTIREADSCANBATCH.STACKCHECKPACK
  IS 'Y/N  defines if the stackcheck product is a pack (Y) or a stack (N)';
COMMENT ON COLUMN MULTIREADSCANBATCH.STACKCHECKPRODUCTIDENTIFIED
  IS 'Y/N defines if stackcheckproduct_id is uniquely identied. When not it might be another similar pack with same unique contents';

------------- UHFBUNDLE -------------
ALTER TABLE UHFBUNDLE MODIFY (PRODUCT_LINK_ID NULL);
ALTER TABLE UHFBUNDLE MODIFY (SIZEDEFINITION_LINK_ID NULL);

ALTER TABLE UHFBUNDLE ADD (PACK VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT YN_VALIDATIONFIELD358 CHECK (PACK IN ('Y', 'N')));

COMMENT ON COLUMN UHFBUNDLE.PACK
IS 'Y/N Defines if it is pack product (Y) or a just a stack (N)';
COMMENT ON COLUMN UHFBUNDLE.PRODUCT_LINK_ID
  IS 'Null in case it is not sure which pack product it concerns';
COMMENT ON COLUMN UHFBUNDLE.SIZEDEFINITION_LINK_ID
  IS 'Null for pack products';
