PFVERBASDIS

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PDADOSDIS.CODCOLIGADA FKPFVERBASDIS_PDADOSDISR
PEVENTO.CODCOLIGADA FKPFVERBASDIS_PEVENTOR
PFPERFF.CODCOLIGADA FKPFVERBASDIS_PFPERFFR
CHAPA DCHAPA 16 null
PFPERFF.CHAPA FKPFVERBASDIS_PFPERFFR
ANOCOMP smallint 2 null
PFPERFF.ANOCOMP FKPFVERBASDIS_PFPERFFR
MESCOMP smallint 2 null
PFPERFF.MESCOMP FKPFVERBASDIS_PFPERFFR
NROPERIODO smallint 2 null
PFPERFF.NROPERIODO FKPFVERBASDIS_PFPERFFR
CODEVENTO varchar 4 null
PEVENTO.CODIGO FKPFVERBASDIS_PEVENTOR
DTPAGTO datetime2 16,7 null
HORA int 4 √ null
REF RMDVALOR2 17,2 √ null
VALOR RMDVALOR2 17,2 √ null
VALORORIGINAL RMDVALOR2 17,2 √ null
DTVENCIMENTO datetime 16,3 √ null
NROPERIODOFERIAS smallint 2 √ (0)
ANOREF smallint 2 (0)
MESREF smallint 2 (0)
DISSIDIO smallint 2 √ (0)
MOTIVO varchar 2 √ null
PERIODOREF smallint 2 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDDADOS int 4 √ null
PDADOSDIS.ID FKPFVERBASDIS_PDADOSDISR
VERBA13SALARIO smallint 2 √ null
DISSIDIOALTMANUAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0

Indexes

Constraint Name Type Sort Column(s)
PKPFVERBASDIS Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + NROPERIODO + CODEVENTO + DTPAGTO + ANOREF + MESREF + PERIODOREF

Relationships

Close relationships within degrees of separation