PFPERFFCOMPL

11453 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFCONVOCACAOPFPERFFCOMPL.CODCOLIGADA FKCONVPERFFCOMPL_PFPERFFCOMPLR
PFFINANCCOMPL.CODCOLIGADA FKPFFINANCCOMPL_PFPERFFCOMPLR
PFMOVCCCOMPL.CODCOLIGADA FKPFMOVCCCOMPL_PFPERFFCOMPLR
PFRETIFICACAOPERIODOCOMPL.CODCOLIGADA FKPFRETIFICACAOPERIODOCOMPL_PFR
PFVERBASCOMPL.CODCOLIGADA FKPFVERBASCOMPL_PFPERFFCOMPLR
PFVERBASDISFERHIST.CODCOLIGADA FKPFVERBASDISFERHIST_PFPERFFCOR
PFVERBASDISHIST.CODCOLIGADA FKPFVERBASDISHIST_PFPERFFCOMPLR
PFUNC.CODCOLIGADA FKPFPERFFCOMPL_PFUNCR
PFBENEFICIO.CODCOLIGADA FKPFPERFFCOMPL_PFBENEFICIOR
CHAPA DCHAPA 16 null
PFCONVOCACAOPFPERFFCOMPL.CHAPA FKCONVPERFFCOMPL_PFPERFFCOMPLR
PFFINANCCOMPL.CHAPA FKPFFINANCCOMPL_PFPERFFCOMPLR
PFMOVCCCOMPL.CHAPA FKPFMOVCCCOMPL_PFPERFFCOMPLR
PFRETIFICACAOPERIODOCOMPL.CHAPA FKPFRETIFICACAOPERIODOCOMPL_PFR
PFVERBASCOMPL.CHAPA FKPFVERBASCOMPL_PFPERFFCOMPLR
PFVERBASDISFERHIST.CHAPA FKPFVERBASDISFERHIST_PFPERFFCOR
PFVERBASDISHIST.CHAPA FKPFVERBASDISHIST_PFPERFFCOMPLR
PFBENEFICIO.CHAPA FKPFPERFFCOMPL_PFBENEFICIOR
PFUNC.CHAPA FKPFPERFFCOMPL_PFUNCR
ANOCOMP smallint 2 null
PFCONVOCACAOPFPERFFCOMPL.ANOCOMP FKCONVPERFFCOMPL_PFPERFFCOMPLR
PFFINANCCOMPL.ANOCOMP FKPFFINANCCOMPL_PFPERFFCOMPLR
PFMOVCCCOMPL.ANOCOMP FKPFMOVCCCOMPL_PFPERFFCOMPLR
PFRETIFICACAOPERIODOCOMPL.ANOCOMPRETIF FKPFRETIFICACAOPERIODOCOMPL_PFR
PFVERBASCOMPL.ANOCOMP FKPFVERBASCOMPL_PFPERFFCOMPLR
PFVERBASDISFERHIST.ANOCOMP FKPFVERBASDISFERHIST_PFPERFFCOR
PFVERBASDISHIST.ANOCOMP FKPFVERBASDISHIST_PFPERFFCOMPLR
MESCOMP smallint 2 null
PFCONVOCACAOPFPERFFCOMPL.MESCOMP FKCONVPERFFCOMPL_PFPERFFCOMPLR
PFFINANCCOMPL.MESCOMP FKPFFINANCCOMPL_PFPERFFCOMPLR
PFMOVCCCOMPL.MESCOMP FKPFMOVCCCOMPL_PFPERFFCOMPLR
PFRETIFICACAOPERIODOCOMPL.MESCOMPRETIF FKPFRETIFICACAOPERIODOCOMPL_PFR
PFVERBASCOMPL.MESCOMP FKPFVERBASCOMPL_PFPERFFCOMPLR
PFVERBASDISFERHIST.MESCOMP FKPFVERBASDISFERHIST_PFPERFFCOR
PFVERBASDISHIST.MESCOMP FKPFVERBASDISHIST_PFPERFFCOMPLR
NROPERIODO smallint 2 null
PFCONVOCACAOPFPERFFCOMPL.NROPERIODO FKCONVPERFFCOMPL_PFPERFFCOMPLR
PFFINANCCOMPL.NROPERIODO FKPFFINANCCOMPL_PFPERFFCOMPLR
PFMOVCCCOMPL.NROPERIODO FKPFMOVCCCOMPL_PFPERFFCOMPLR
PFRETIFICACAOPERIODOCOMPL.PERIODORETIF FKPFRETIFICACAOPERIODOCOMPL_PFR
PFVERBASCOMPL.NROPERIODO FKPFVERBASCOMPL_PFPERFFCOMPLR
PFVERBASDISFERHIST.NROPERIODO FKPFVERBASDISFERHIST_PFPERFFCOR
PFVERBASDISHIST.NROPERIODO FKPFVERBASDISHIST_PFPERFFCOMPLR
MESCAIXACOMUM smallint 2 √ null
VALORESFORCADOS smallint 2 √ null
MOVIMPORTADO smallint 2 √ null
EDITADO smallint 2 √ null
ALTERADO smallint 2 √ null
SALCOMISSAO RMDVALOR2 17,2 √ null
FERIASMES RMDVALOR2 17,2 √ null
BASEINSS RMDVALOR2 17,2 √ null
BASEINSSOUTROEMP RMDVALOR2 17,2 √ null
INSS RMDVALOR2 17,2 √ null
INSSFERIAS RMDVALOR2 17,2 √ null
INSSOUTROEMP RMDVALOR2 17,2 √ null
BASEINSS13 RMDVALOR2 17,2 √ null
BASEINSS13OUTRO RMDVALOR2 17,2 √ null
INSS13 RMDVALOR2 17,2 √ null
BASESALFAMILIA RMDVALOR2 17,2 √ null
SALFAMILIA RMDVALOR2 17,2 √ null
BASEVALETRANSP RMDVALOR2 17,2 √ null
VALETRANSPENTR RMDVALOR2 17,2 √ null
VALETRANSPDESC RMDVALOR2 17,2 √ null
BASEIRRF RMDVALOR2 17,2 √ null
IRRF RMDVALOR2 17,2 √ null
INSSCAIXA RMDVALOR2 17,2 √ null
DEDUTIVELIRRF RMDVALOR2 17,2 √ null
BASEIRRFPART RMDVALOR2 17,2 √ null
IRRFPART RMDVALOR2 17,2 √ null
BASEIRRFFERIAS RMDVALOR2 17,2 √ null
IRRFFERIAS RMDVALOR2 17,2 √ null
INSSCOMCPMF RMDVALOR2 17,2 √ null
DESCRICAO varchar 250 √ null
BASEFGTS RMDVALOR2 17,2 √ null
BASEFGTS13 RMDVALOR2 17,2 √ null
SALARIOPAGO RMDVALOR2 17,2 √ null
STATUSCCUSTO smallint 2 √ (0)
BASEIRRF13 RMDVALOR2 17,2 √ null
SALARIODECALCULO RMDVALOR2 17,2 √ null
IRRF13 RMDVALOR2 17,2 √ null
INSSFERIASCOMCPMF RMDVALOR2 17,2 √ null
INSSCALCUSUARIO RMDVALOR2 17,2 √ null
BASEFGTSDIFSAL RMDVALOR2 17,2 √ null
INSSDIFSAL RMDVALOR2 17,2 √ null
INSSDIFSAL13 RMDVALOR2 17,2 √ null
INSSDIFSALFER RMDVALOR2 17,2 √ null
EXECID varchar 50 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
NRODEPENDIRRF smallint 2 √ null
LIQUIDO RMDVALOR2 17,2 √ null
NRODEPENDSALFAMILIA smallint 2 √ null
IDDADOSRESID smallint 2 √ null
RETIFICACAO smallint 2 √ ((0))
MESPGTORETIF smallint 2 √ null
ANOPGTORETIF smallint 2 √ null
PERIODOPGTORETIF smallint 2 √ null
ANOCAIXACOMUM numeric 7 √ null
ORDEMCALCULOMV smallint 2 √ null
DISSIDIOAPOSDEMISSAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
NUMEROBENEFICIO varchar 20 √ null
PFBENEFICIO.NUMEROBENEFICIO FKPFPERFFCOMPL_PFBENEFICIOR
BASEIRRFPARTANUAL RMDVALOR2 17,2 √ null
IRRFSIMPLIFICADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IRRF13SIMPLIFICADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IRRFFERSIMPLIFICADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0

Indexes

Constraint Name Type Sort Column(s)
PKPFPERFFCOMPL Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + NROPERIODO

Relationships

Close relationships within degrees of separation