CREATE TABLE FCT_TMP_CONTRPENDENCIAREAJ 
(
	NRSEQCONTRATO		NUMBER,
	NRCONTRATOFCT 		VARCHAR2(30),
	NRPARCNEGOCIO 		NUMBER, 
	NMPRINCIPALPARC 	VARCHAR2(250),
	DTINICIOCONTRATO 	DATE,
	DTFIMCONTRATO 		DATE,
	DSREFERENCIACONT 	VARCHAR2(250),
    NRORG 				NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
	IDATIVO 			VARCHAR2(1) 	DEFAULT 'S' NOT NULL,
		CONSTRAINT CKC_IDATIVO_FCTTMPCONPENREAJ 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'

) 