PFVERBAS

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PEVENTO.CODCOLIGADA FKPFVERBAS_PEVENTOR
PFPERFF.CODCOLIGADA FKPFVERBAS_PFPERFFR
CHAPA DCHAPA 16 null
PFPERFF.CHAPA FKPFVERBAS_PFPERFFR
ANOCOMP smallint 2 null
PFPERFF.ANOCOMP FKPFVERBAS_PFPERFFR
MESCOMP smallint 2 null
PFPERFF.MESCOMP FKPFVERBAS_PFPERFFR
NROPERIODO smallint 2 null
PFPERFF.NROPERIODO FKPFVERBAS_PFPERFFR
CODEVENTO varchar 4 null
PEVENTO.CODIGO FKPFVERBAS_PEVENTOR
DTPAGTO datetime 16,3 √ null
HORA int 4 √ null
REF RMDVALOR2 17,2 √ null
VALOR RMDVALOR2 17,2 √ null
VALORORIGINAL RMDVALOR2 17,2 √ null
DESCONTADO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
ANOLANC smallint 2 √ null
MESLANC smallint 2 √ null
PERIODOLANC smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFVERBAS Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + NROPERIODO + CODEVENTO

Relationships

Close relationships within degrees of separation