PDIRF

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PDIRFCOMPLEMENTO.CODCOLIGADA FKPDIRFCOMPLEMENTO_PDIRFR
PFUNC.CODCOLIGADA FKPDIRF_PFUNCR
CHAPA DCHAPA 16 null
PDIRFCOMPLEMENTO.CHAPA FKPDIRFCOMPLEMENTO_PDIRFR
PFUNC.CHAPA FKPDIRF_PFUNCR
ANO smallint 2 null
PDIRFCOMPLEMENTO.ANO FKPDIRFCOMPLEMENTO_PDIRFR
BASEIRRF RMDVALOR2 17,2 √ null
INSS RMDVALOR2 17,2 √ null
PREVPRIVADA RMDVALOR2 17,2 √ null
PENSAO RMDVALOR2 17,2 √ null
IRRF RMDVALOR2 17,2 √ null
APOSRESERVA RMDVALOR2 17,2 √ null
DIARIAS RMDVALOR2 17,2 √ null
APOSMOLESTIA RMDVALOR2 17,2 √ null
LUCROS RMDVALOR2 17,2 √ null
SOCIO RMDVALOR2 17,2 √ null
INDENIZRCTPDV RMDVALOR2 17,2 √ null
ACCPMF RMDVALOR2 17,2 √ null
OUTROSNAOTRIB1 RMDVALOR2 17,2 √ null
OUTROSNAOTRIB2 RMDVALOR2 17,2 √ null
OUTROSNAOTRIB3 RMDVALOR2 17,2 √ null
LIQ13SAL RMDVALOR2 17,2 √ null
OUTROSTRIBEXCL1 RMDVALOR2 17,2 √ null
AUXILIAR1 RMDVALOR2 17,2 √ null
AUXILIAR2 RMDVALOR2 17,2 √ null
AUXILIAR3 RMDVALOR2 17,2 √ null
AUXILIAR4 RMDVALOR2 17,2 √ null
AUXILIAR5 RMDVALOR2 17,2 √ null
INFOCOMPL MEMO 2147483647 √ null
CGC varchar 20 √ null
CODRETENCAO varchar 5 √ null
IDXDESPMEDICO RMDVALOR2 17,2 √ null
IDXINFCOMPL RMDVALOR2 17,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
COMPROVANTEXML DIMAGEM 2147483647 √ null
IRRF13 RMDVALOR2 17,2 √ null
BASE_IRRF_RRA RMDVALOR2 17,2 √ null
INSS_RRA RMDVALOR2 17,2 √ null
IRRF_RRA RMDVALOR2 17,2 √ null
PENSAO_RRA RMDVALOR2 17,2 √ null
VALORDAJUD RMDVALOR2 17,2 √ null
QTDMESES smallint 2 √ null
NUMPROCESSO varchar 20 √ null
APOSRESERVA13 RMDVALOR2 17,2 √ null
JUROSMORA RMDVALOR2 17,2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPDIRF Primary key Asc/Asc/Asc CODCOLIGADA + CHAPA + ANO

Relationships

Close relationships within degrees of separation