ALTER TABLE PARAMGERALECOMMERCE ADD DSMANUALFILESERV VARCHAR2(4000)
/

CREATE TABLE INTGORCAGOP (
	NRINTGORCAGOP 	NUMBER 			NOT NULL,
	CDFILIAL      	VARCHAR2(4) 	NOT NULL,
	NRANO         	DATE 			NOT NULL, 
	CDITMORCA     	NUMBER,       
	CDDESPDIV     	NUMBER,
	CDARVPROD     	VARCHAR2(20),
	VRORCAJAN     	FLOAT,
	VRORCAFEV     	FLOAT,
	VRORCAMAR     	FLOAT,
	VRORCAABR     	FLOAT,
	VRORCAMAI     	FLOAT,
	VRORCAJUN     	FLOAT,
	VRORCAJUL     	FLOAT,
	VRORCAAGO     	FLOAT, 
	VRORCASET     	FLOAT,
	VRORCAOUT     	FLOAT,
	VRORCANOV     	FLOAT,
	VRORCADEZ     	FLOAT,
	IDORCAIMP     	VARCHAR2(1) 	NOT NULL,
	NRORG         	NUMBER 	     	DEFAULT         SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
    IDATIVO       	VARCHAR2(1)     DEFAULT 'S' NOT NULL
      CONSTRAINT CKC_IDATIVO_INTGORCAGOP CHECK (IDATIVO IN ('S','N')),
    DTINCLUSAO      DATE                  			NULL,
    DTULTATU        DATE                  			NULL,
    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'
)
/