-- ABS-98599
ALTER TABLE ERP_I_PRODUCT ADD (PRODUCTRANKING     VARCHAR2(10) DEFAULT NULL,
                               MODIFICATIONGROUP1 VARCHAR2(6) DEFAULT NULL,
                               MODIFICATIONGROUP2 VARCHAR2(6) DEFAULT NULL,
                               MODIFICATIONGROUP3 VARCHAR2(6) DEFAULT NULL);
 
 
ALTER TABLE ERP_I_PRODUCTSIZE ADD (ACTIVE_YN      VARCHAR2(1) DEFAULT NULL
 CONSTRAINT CHK_ERP_I_PRODSIZE_ACTIV CHECK (ACTIVE_YN IN ('Y','N')));
COMMENT ON COLUMN ERP_I_PRODUCTSIZE.ACTIVE_YN IS 
'This is a limited implementation of Active Y/N and only applies to the adding of new productsize records in PLPC. 
It is not honored anywhere else in ABSSolute';