-- ==============================================
-- TABLE: FPA_LOGRETROCESSO
-- ==============================================
CREATE TABLE FPA_LOGRETROCESSO
(
    NRLOGRETROCESSO 	NUMBER NOT NULL, 
	DSORDEM 			VARCHAR2(100), 
	DSINICIO 			VARCHAR2(2000), 
	DSFIM 				VARCHAR2(2000), 
	DTPAGAMENTO 		DATE, 
	IDULTPGTOMES 		VARCHAR2(1), 
	IDMEMORIACALC 		VARCHAR2(1), 
	IDTPFORMCALCULO 	VARCHAR2(20), 
	IDDIFSAL 			VARCHAR2(1), 
	IDDIFFERIAS 		VARCHAR2(1), 
	DSTIPOVINCULO 		VARCHAR2(50), 
	DSINICIO2 			VARCHAR2(2000), 
	DSFIM2 				VARCHAR2(2000), 
	DSINICIO3 			VARCHAR2(2000), 
	DSFIM3 				VARCHAR2(2000), 	
	NRFERIAS 			NUMBER, 
	DTINIGOZOFERIAS 	DATE, 
	DTFIMGOZOFERIAS 	DATE, 
	QTDIAGOZOFERIAS 	NUMBER, 
	QTDIASABONOFERI 	NUMBER, 
	NRVINCULOM 			NUMBER, 
	DTAVISOFERIAS 		DATE, 
	IDADIANT13SALAR 	VARCHAR2(1), 
	DSVINCNAOCONTEMPL 	VARCHAR2(2000), 
	DTRESCISAOINI 		DATE,
	DTRESCISAOFIM 		DATE,
	VRSALDOFGTSBANCO 	NUMBER,	
	IDFAZDIFCOMP 		VARCHAR2(1),
	VRSALDISSIDIO 		FLOAT,
	DTINICIOVALE 		DATE,
	DTFINALVALE 		DATE,
	DTINICIOFILTROVALE 	DATE,
	DTFINALFILTROVALE 	DATE,	
	NRTIPOLINHAVINC 	NUMBER,
	NRTPBENEFICIO 		NUMBER,
	TPPERIODOBENEF 		VARCHAR2(100),
    DSOBSERVACAO 		VARCHAR2(4000),
    NRORG             	NUMBER 	     	DEFAULT         SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
    IDATIVO           	VARCHAR2(1)     DEFAULT 'S' NOT NULL
      CONSTRAINT CKC_IDATIVO_FPA_LOGRETROCESSO 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',
		CONSTRAINT PK_FPA_LOGRETROCESSO PRIMARY KEY (NRLOGRETROCESSO)
)