PFFINANCCOMPL

68541 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFPERFFCOMPL.CODCOLIGADA FKPFFINANCCOMPL_PFPERFFCOMPLR
PEVENTO.CODCOLIGADA FKPFFINANCCOMPL_PEVENTOR
CHAPA DCHAPA 16 null
PFPERFFCOMPL.CHAPA FKPFFINANCCOMPL_PFPERFFCOMPLR
ANOCOMP smallint 2 null
PFPERFFCOMPL.ANOCOMP FKPFFINANCCOMPL_PFPERFFCOMPLR
MESCOMP smallint 2 null
PFPERFFCOMPL.MESCOMP FKPFFINANCCOMPL_PFPERFFCOMPLR
NROPERIODO smallint 2 null
PFPERFFCOMPL.NROPERIODO FKPFFINANCCOMPL_PFPERFFCOMPLR
CODEVENTO varchar 4 null
PEVENTO.CODIGO FKPFFINANCCOMPL_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
ALTERADOMANUAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
VERBAFERIAS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ORIGEMMOV smallint 2 √ (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
VERBARESILICAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
VERBADIFERENCA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DISSIDIO smallint 2 √ ((0))
DISSIDIOALTMANUAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0

Indexes

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

Relationships

Close relationships within degrees of separation