ALTER TABLE INSCRESTAD ADD  IDTPAMBIENTESNCM  VARCHAR2(1) NULL 
	CONSTRAINT CKC_IDSTATUSPRIN CHECK ( IDTPAMBIENTESNCM  IN('0','1'))
/

  CREATE TABLE WEBSERVICESNCM(
	IDTPAMBIENTESNCM 	VARCHAR2(1) DEFAULT '1' NOT NULL, 
	WSMBRAGTMGMT 		VARCHAR2(250), 
	WSPARAM 			VARCHAR2(250), 
	WSMDATAMAH 			VARCHAR2(250), 
	WSEVETIN 			VARCHAR2(250), 
	WSEVETINTEST 		VARCHAR2(250), 
	DESCENDSERVER 		VARCHAR2(200),
	NRORG             	NUMBER 	      	DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 		NOT NULL,
    IDATIVO           	VARCHAR2(1)     DEFAULT 'S' 					NOT NULL
		CONSTRAINT CKC_IDATIVO_WEBSERVICESNCM CHECK (IDATIVO IN ('S','N')),
    DTINCLUSAO        	DATE            DEFAULT SYSDATE,
    DTULTATU          	DATE            DEFAULT SYSDATE,
    NRORGINCLUSAO     	NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERINCLUSAO    	VARCHAR2(12)    DEFAULT '1' 					NULL,
    NRORGULTATU       	NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERULTATU      	VARCHAR2(12)    DEFAULT '1',
		CONSTRAINT CKC_IDTPAMB_WEBSERVICESNCM CHECK ( IDTPAMBIENTESNCM IN ('0','1')),
		CONSTRAINT PK_WEBSERVICESNCM PRIMARY KEY (IDTPAMBIENTESNCM))
/

ALTER TABLE SERIALPRODSCNM ADD DTFABRLOTE DATE
/

ALTER TABLE SERIALPRODSCNM ADD  IDSTATUSPRINT  VARCHAR2(1) NULL 
   CONSTRAINT CKC_IDSTATUSPRINT CHECK ( IDSTATUSPRINT  IN('0','1','2','3'))
/

ALTER TABLE PARAMAN ADD IDSNCMLIBLOTE VARCHAR2(3) DEFAULT 'NAO'
    CONSTRAINT CKC_IDSNCMLIBLOTE CHECK (IDSNCMLIBLOTE  IN ('SIM','NAO'))
/