  CREATE TABLE FCT_TMP_TRABSERVCONTRATO (
    NRTRABSERVCONT    NUMBER, 
	NRSEQCONTRATO     NUMBER, 
	NRTIPOORCAMENTO   NUMBER, 
	NRCOMPSERVICO     NUMBER, 
	NRITCOMPSERVICO   NUMBER, 
	IDESCOLHIDO 	  CHAR(1), 
	CDSERVORCA 		  NUMBER, 
	QTSERVORCA        NUMBER, 
	CDTPMEDIDASERV    NUMBER, 
	QTMEDSERVORCA     NUMBER, 
	VRUNITSERVORCA    FLOAT(126), 
	VRTOTSERVORCA     FLOAT(126), 
	IDELEMENTO        VARCHAR2(100), 
	IDELEMENTOPAI     VARCHAR2(100), 
	IDTIPOELEMENTO    CHAR(1), 
	IDSERVOBRIGCOMP   VARCHAR2(1), 
	QTMEDIDAVARIAVEL  NUMBER, 
	QTMEDIDACALC 	  FLOAT(126), 
	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_TMP_TRASERCONT CHECK (IDATIVO IN ('S','N'))
   )
/