-- ABS-10918

---------------- CUSTOMERGARMENTDISPENSER -----------------
ALTER TABLE CUSTOMERGARMENTDISPENSER ADD (ENHANCED VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT YN_VALIDATIONFIELD257 CHECK (ENHANCED IN ('Y','N')),
										 EXPORTTOGD VARCHAR2(1) DEFAULT 'Y' NOT NULL CONSTRAINT YN_VALIDATIONFIELD258 CHECK (EXPORTTOGD IN ('Y','N')),
										 USEWEARERIDFIELD NUMBER DEFAULT 0 NOT NULL CONSTRAINT YN_VALIDATIONFIELD259 CHECK (USEWEARERIDFIELD IN (0,1)));
										 

COMMENT ON COLUMN CUSTOMERGARMENTDISPENSER.ENHANCED
  IS 'Only used for Kannegieser (Interface = 2)';
COMMENT ON COLUMN CUSTOMERGARMENTDISPENSER.EXPORTTOGD
  IS 'Only used for Kannegieser (Interface = 2)';
COMMENT ON COLUMN CUSTOMERGARMENTDISPENSER.USEWEARERIDFIELD
  IS 'Option 1 is only used for Kannegieser (Interface = 2)';
  

---------------- PRODUCTLISTPERCUSTOMER -------------------
ALTER TABLE PRODUCTLISTPERCUSTOMER ADD (GDIMPORTRELEVANT VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT YN_VALIDATIONFIELD260  CHECK (GDIMPORTRELEVANT IN ('Y','N')));


