CREATE TABLE FCT_ANEXOSMEDICAO_TMP(
	NRSEQCONTRATO     NUMBER,
	CDFILIALFATURA    VARCHAR2(4), 
	NRPARCFATURA      NUMBER, 
	DTINICOMPET       DATE, 
	DTFINCOMPET       DATE, 
	NRESTRUTURAM      NUMBER,
	NMARQUIVO         VARCHAR2(300), 
	DSCAMINHO         VARCHAR2(1000), 
	DSTIPO            VARCHAR2(150), 
	VRTAMANHO         FLOAT(126), 
	NRTIPOANEXO       NUMBER,
	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_FCT_ANEXOMED_TMP CHECK (IDATIVO IN ('S','N'))
)
/