PSEFIPPARSEC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PSECAO.CODCOLIGADA FKPSEFIPPARSEC_PSECAOR
CODSECAO varchar 35 null
PSECAO.CODIGO FKPSEFIPPARSEC_PSECAOR
ANOCOMP int 4 null
MESCOMP int 4 null
CODRECSEFIP int 4 null
TOTSALFAMILIA RMDVALOR2 17,2 √ null
DED13LICMATER RMDVALOR2 17,2 √ null
RECEITAEVENTODESP RMDVALOR2 17,2 √ null
SALMATER RMDVALOR2 17,2 √ null
PRODRURALPJ RMDVALOR2 17,2 √ null
PRODRURALPF RMDVALOR2 17,2 √ null
INDICORIGEMRECEITA varchar 1 √ null
COMPENSVALOR RMDVALOR2 17,2 √ null
COMPENSANOINI int 4 √ null
COMPENSMESINI int 4 √ null
COMPENSANOFIM int 4 √ null
COMPENSMESFIM int 4 √ null
VALINSSFPAG RMDVALOR2 17,2 √ null
OUTRENTIDFOPAG RMDVALOR2 17,2 √ null
PRODRURALINSS RMDVALOR2 17,2 √ null
PRODRURALOUTENT RMDVALOR2 17,2 √ null
RECEVENTDESPINSS RMDVALOR2 17,2 √ null
VALCOOPERATIVA RMDVALOR2 17,2 √ null
NUMEROPROCESSO varchar 11 √ null
ANOPROCESSO int 4 √ null
VARAPROCESSO varchar 5 √ null
PROCMESINI int 4 √ null
PROCANOINI int 4 √ null
PROCMESFIM int 4 √ null
PROCANOFIM int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPSEFIPPARSEC Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODSECAO + ANOCOMP + MESCOMP + CODRECSEFIP

Relationships

Close relationships within degrees of separation