CREATE TABLE MOVBANC_TEMP(
  NRSEQMOVBANC 		NUMBER 			NOT NULL,
  NRSEQITMOV   		NUMBER 			NOT NULL,
  TIPO 				VARCHAR2(100) 	NULL, 
  TPLANCAMENTO 		VARCHAR2(100) 	NULL, 
  DESCRICAO 		VARCHAR2(500) 	NULL, 
  DEBITO     		FLOAT, 
  CREDITO    		FLOAT, 
  SALDOTELA  		FLOAT, 
  DEBCRED    		VARCHAR2(02) 	NULL,
  CDREDUCONT 		VARCHAR2(03) 	NOT NULL, 
  NRMOVBANC  		VARCHAR2(20) 	NULL,
  NRCHEQUE   		VARCHAR2(20) 	NULL, 
  DTMOVBANC  		DATE, 
  IDMOVBANC  		VARCHAR2(20) 	NULL , 
  NRDOCMBANC 		VARCHAR2(20) 	NULL,
  DSTIPOMOV  		VARCHAR2(500) 	NULL, 
  DSHISMBANC 		VARCHAR2(500) 	NULL, 
  VRMOVBANC  		FLOAT, 
  NUMEROBAIXA 		VARCHAR2(20) 	NULL, 
  IDORIGMBANC 		VARCHAR2(02) 	NULL, 
  VRSDOCCORR 		FLOAT, 
  VRSDOIMPLA 		FLOAT, 
  SALDO      		FLOAT, 
  CDBANCO    		VARCHAR2(03) 	NOT NULL, 
  CDEMPRESA  		VARCHAR2(02) 	NOT NULL,  
  NMEMPRESA  		VARCHAR2(500) 	NOT NULL,   
  CDAGENCIA  		VARCHAR2(10) 	NOT NULL, 
  CDCONTCORR 		VARCHAR2(20) 	NOT NULL, 
  DSCONTCORR 		VARCHAR2(500)  	NULL, 
  CDPICTCONT 		VARCHAR2(20) 	NOT NULL, 
  NMBANCO    		VARCHAR2(200) 	NULL, 
  DSMOVIMENTO 		VARCHAR2(500), 
  DSDEBICRED 		VARCHAR2(500), 
  VRLIMITCREDCCOR 	FLOAT, 
  SDOANT 			VARCHAR2(20),
  DTPERIODOINI 		DATE, 
  DTPERIODOFIN 		DATE, 
  SALDOINICIAL 		VARCHAR2(02), 
  NMRAZAO 			VARCHAR2(500),
  NRORG 			NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
  IDATIVO 			VARCHAR2(1) 	DEFAULT 'S' NOT NULL
		CONSTRAINT CKC_IDATIVO_MOVBANC_TEMP 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',
		CONSTRAINT PK_MOVBANC_TEMP PRIMARY KEY (NRSEQMOVBANC, NRSEQITMOV)
)
/