CREATE TABLE PRAZOFORNEXPEDFILPROD (
    NRPRAZOFORNEXPEDPROD NUMBER       	 NOT NULL,
    CDFORNECED           VARCHAR2(21) 	 NOT NULL, 
    CDFILIAL             VARCHAR2(4)  	 NOT NULL,
    CDPRODUTO            VARCHAR2(10) 	 NOT NULL,
    QTDIASPRAZOEXPED     FLOAT(126),
    NRORG            	 NUMBER 	     DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 		NOT NULL,
    IDATIVO          	 VARCHAR2(1)     DEFAULT 'S'					NOT NULL,
    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_IDATIVO_PRZFORNEXPFILPR CHECK (IDATIVO IN ('S','N')),
	   CONSTRAINT PK_PRAZOFORNEXPEDFILPROD PRIMARY KEY (NRPRAZOFORNEXPEDPROD)
)
/
CREATE SEQUENCE SEQ_PRAZOFORNEXPEDFILPROD START WITH 1 INCREMENT BY 1
/

ALTER TABLE PARASUPRI ADD DSEMAILCONCLAUTRUPOL VARCHAR2(400)
/