PSEFIPPARTOMCEI

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PSECAO.CODCOLIGADA FKPSEFIPPARTOMCEI_PSECAOR
GCOLIGADA.CODCOLIGADA FKPSEFIPPARTOMCEI_GCOLIGADAR
PSEFIPPARTOM.CODCOLIGADA FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
CODSECAO varchar 35 null
PSECAO.CODIGO FKPSEFIPPARTOMCEI_PSECAOR
PSEFIPPARTOM.CODSECAO FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
ANOCOMP int 4 null
PSEFIPPARTOM.ANOCOMP FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
MESCOMP int 4 null
PSEFIPPARTOM.MESCOMP FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
CODRECSEFIP int 4 null
PSEFIPPARTOM.CODRECSEFIP FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
CODCFO varchar 25 null
PSEFIPPARTOM.CODCFO FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
FCFO.CODCFO FKPSEFIPPARTOMCEI_FCFOR
CODCOLIGADATOMADOR DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKPSEFIPPARTOMCEI_GCOLIGADATR
FCFO.CODCOLIGADA FKPSEFIPPARTOMCEI_FCFOR
PSEFIPPARTOM.CODCOLIGADATOMADOR FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
CEI varchar 20 null
TOTSALFAMILIA RMDVALOR2 17,2 √ 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
RETENCAOLEI971198 RMDVALOR2 17,2 √ null
FATURASTOMADOR RMDVALOR2 17,2 √ 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)
PKPSEFIPPARTOMCEI Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODSECAO + CODCFO + ANOCOMP + MESCOMP + CODRECSEFIP + CODCOLIGADATOMADOR + CEI

Relationships

Close relationships within degrees of separation