PFENCCC

10074 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFENCARGO.CODCOLIGADA FKPFENCCC_PFENCARGOR
GCCUSTO.CODCOLIGADA FKPFENCCC_GCCUSTOR
PCCUSTO.CODCOLIGADA FKPFENCCC_PCCUSTOR
PFUNC.CODCOLIGADA FKPFENCCC_PFUNCR
PENCARGO.CODCOLIGADA FKPFENCCC_PENCARGOR
CHAPA DCHAPA 16 null
PFENCARGO.CHAPA FKPFENCCC_PFENCARGOR
PFUNC.CHAPA FKPFENCCC_PFUNCR
ANOCOMP smallint 2 null
PFENCARGO.ANOCOMP FKPFENCCC_PFENCARGOR
MESCOMP smallint 2 null
PFENCARGO.MESCOMP FKPFENCCC_PFENCARGOR
CODENCARGO varchar 4 null
PFENCARGO.CODENCARGO FKPFENCCC_PFENCARGOR
PENCARGO.CODIGO FKPFENCCC_PENCARGOR
CODPCCUSTO varchar 25 null
PCCUSTO.CODCCUSTO FKPFENCCC_PCCUSTOR
VALOR RMDVALOR4 17,4 √ null
EDITADO smallint 2 √ (0)
CODGCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKPFENCCC_GCCUSTOR
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)
PKPFENCCC Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + CODENCARGO + CODPCCUSTO
PXPFENCCC Performance Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + CODENCARGO + CODGCCUSTO

Relationships

Close relationships within degrees of separation