CREATE TABLE SIMUORCAGOP (
   NRSIMUORCAGOP 		NUMBER 				NOT NULL,
   CDFILIAL 			VARCHAR2(04),
   IDTIPOORCAOP 		VARCHAR2(30) 		NOT NULL,
   CODIGO 				VARCHAR2(30),
   CDINVEST 			VARCHAR2(10),
   CDIMPOSTO 			VARCHAR2(02),
   CDSERVFILI 			VARCHAR2(05),
   CDDESPPREV 			VARCHAR2(03),
   CDORCAMENTOMO 		VARCHAR2(10),
   CDDESPADMFAT 		VARCHAR2(02),
   CDPRODUTO 			VARCHAR2(20),
   QTORCAMENTO 			FLOAT,
   VRORCAMENTO 			FLOAT,
   NRMES 				NUMBER,
   VRPRECOBASE 			FLOAT, 
   NRLISTA 				VARCHAR2(20),
   VRAJUSTPERCENTUAL 	FLOAT, 
   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_SIMUORCAGOP CHECK (IDATIVO IN ('S','N')),
		CONSTRAINT PK_SIMUORCAGOP PRIMARY KEY(NRSIMUORCAGOP)
)
/