PFMOVCCCOMPL

24432 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFPERFFCOMPL.CODCOLIGADA FKPFMOVCCCOMPL_PFPERFFCOMPLR
PCCUSTO.CODCOLIGADA FKPFMOVCCCOMPL_PCCUSTOR
PEVENTO.CODCOLIGADA FKPFMOVCCCOMPL_PEVENTOR
CHAPA DCHAPA 16 null
PFPERFFCOMPL.CHAPA FKPFMOVCCCOMPL_PFPERFFCOMPLR
ANOCOMP smallint 2 null
PFPERFFCOMPL.ANOCOMP FKPFMOVCCCOMPL_PFPERFFCOMPLR
MESCOMP smallint 2 null
PFPERFFCOMPL.MESCOMP FKPFMOVCCCOMPL_PFPERFFCOMPLR
NROPERIODO smallint 2 null
PFPERFFCOMPL.NROPERIODO FKPFMOVCCCOMPL_PFPERFFCOMPLR
CODEVENTO varchar 4 null
PEVENTO.CODIGO FKPFMOVCCCOMPL_PEVENTOR
CODCCUSTO varchar 25 null
PCCUSTO.CODCCUSTO FKPFMOVCCCOMPL_PCCUSTOR
HORA int 4 √ null
REF RMDVALOR2 17,2 √ null
VALOR RMDVALOR2 17,2 √ null
EDITADO smallint 2 (0)
ORIGEMMOV smallint 2 √ (0)
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)
PKPFMOVCCCOMPL Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + NROPERIODO + CODEVENTO + CODCCUSTO + EDITADO

Relationships

Close relationships within degrees of separation