ALTER TABLE LOGNECECOMP ADD NRNECECMPLOGORIG VARCHAR2(10)
/
ALTER TABLE LOGNECECOMP ADD IDLOGNECECOMPCALC VARCHAR2(1) 
	CONSTRAINT CKC_IDLOGNECECOMPCALC CHECK (IDLOGNECECOMPCALC IS NULL OR (IDLOGNECECOMPCALC IN ('S', 'N'))) 
/
ALTER TABLE LOGNECECOMP ADD IDLOGNECECOMPEXT VARCHAR2(1) 
	CONSTRAINT CKC_IDLOGNECECOMPEXT CHECK (IDLOGNECECOMPEXT IS NULL OR (IDLOGNECECOMPEXT IN ('S', 'N'))) 
/