--ABSN-10115

--CONTACTFOLLOWUPNOTE TABLE
ALTER TABLE CONTACTFOLLOWUPNOTE ADD (CUSTOMERCOMSNAME VARCHAR2(40) NULL);

COMMENT ON COLUMN CONTACTFOLLOWUPNOTE.CUSTOMERCOMSNAME IS 'Name of the customer representative spoken';

--CONTACTCATEGORY TABLE
ALTER TABLE CONTACTCATEGORY ADD (CUSTOMERCOMMUNICATION VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT CHK_CONTACTCATEGORY_CUSTOMERCOMMUNICATION CHECK (CUSTOMERCOMMUNICATION IN ('Y','N')));

