CREATE TABLE CADCOMISSAO
(
   NRFAIXA      	NUMBER 						NOT NULL,        
   NRORG            NUMBER DEFAULT 	 SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO      	VARCHAR2(1)   DEFAULT 'S' 	NOT NULL,
      CONSTRAINT CKC_IDATIVO_CADCOMISSAO CHECK (IDATIVO IN ('S','N')),
   DTINCLUSAO   	DATE                   		NULL,
   DTULTATU     	DATE                  		NULL,
   NRORGINCLUSAO    NUMBER        DEFAULT 1 	NULL,
   CDOPERINCLUSAO   VARCHAR2(12)  DEFAULT '1' 	NULL,
   NRORGULTATU      NUMBER        DEFAULT 1 	NULL,
   CDOPERULTATU     VARCHAR2(12)  DEFAULT '1',
   DSVRINICIAL  	VARCHAR2(50) 				NOT NULL,  
   DSVRFINAL    	VARCHAR2(50) 				NOT NULL,  
   DSVRCOMISSAO 	VARCHAR2(50) 				NOT NULL,  
   IDTROCAPRECO 	VARCHAR2(1)  DEFAULT 'S' 	NOT NULL 
      CONSTRAINT CKC_IDTROCAPRECO_CADCOMISSAO CHECK (IDTROCAPRECO IN ('S','N'))
)
/
ALTER TABLE CADCOMISSAO ADD CONSTRAINT PK_CADCOMISSAO PRIMARY KEY(NRFAIXA)