PSEFIPPARTOM

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PSEFIPPARTOMCEI.CODCOLIGADA FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
PSECAO.CODCOLIGADA FKPSEFIPPARTOM_PSECAOR
CODSECAO varchar 35 null
PSEFIPPARTOMCEI.CODSECAO FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
PSECAO.CODIGO FKPSEFIPPARTOM_PSECAOR
CODCFO varchar 25 null
PSEFIPPARTOMCEI.CODCFO FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
FCFO.CODCFO FKPSEFIPPARTOM_FCFOR
ANOCOMP int 4 null
PSEFIPPARTOMCEI.ANOCOMP FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
MESCOMP int 4 null
PSEFIPPARTOMCEI.MESCOMP FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
CODRECSEFIP int 4 null
PSEFIPPARTOMCEI.CODRECSEFIP FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
CODCOLIGADATOMADOR DCODCOLIGADA 2 null
PSEFIPPARTOMCEI.CODCOLIGADATOMADOR FKPSEFIPPARTOMCEI_PSEFIPPARTOMR
FCFO.CODCOLIGADA FKPSEFIPPARTOM_FCFOR
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
FATURASTOMADOR RMDVALOR2 17,2 √ null
RETENCAOLEI971198 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)
PKPSEFIPPARTOM Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODSECAO + ANOCOMP + MESCOMP + CODRECSEFIP + CODCFO + CODCOLIGADATOMADOR

Relationships

Close relationships within degrees of separation