--- ABS-16751
-------------------------   WEBMENUDIALOG   -----------------------------------
ALTER TABLE WEBMENUDIALOG ADD (BIFILTER NUMBER DEFAULT 0 NOT NULL
				CONSTRAINT BIFILTER_VALID1_1 CHECK (BIFILTER BETWEEN 0 AND 3),
			       BISHOWWEBPORTALCONTENT NUMBER DEFAULT 0 NOT NULL
				CONSTRAINT BISHOWWEBPORTAL_VALID1_1 CHECK (BISHOWWEBPORTALCONTENT BETWEEN 0 AND 6),
			       SHOWFORRESIDENTIALCUSTONLY VARCHAR2(1) DEFAULT 'N' NOT NULL
				CONSTRAINT YN_VALIDATIONFIELD270 CHECK (SHOWFORRESIDENTIALCUSTONLY IN ('Y','N')),
			       SHOWFORGARMENTCUSTONLY VARCHAR2(1) DEFAULT 'N' NOT NULL
				CONSTRAINT YN_VALIDATIONFIELD271 CHECK (SHOWFORGARMENTCUSTONLY IN ('Y','N')));

COMMENT ON COLUMN WEBMENUDIALOG.BIFILTER IS '0 = customer
1 = debtor
2 = master account
3 = common customer';

COMMENT ON COLUMN WEBMENUDIALOG.BISHOWWEBPORTALCONTENT IS '0 = always
1 = only if customer is a bill-to customer
2 = only if customer is not a bill-to customer
3 = only if customer is a master account
4 = only if customer is not a master account
5 = only if customer is a common customer
6 = only if customer is not a common customer';