PFDEPMOV

248 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTDEPEVENTOS.CODCOLIGADA FKPFHSTDEPEVENTOS_PFDEPMOVR
PFDEPEND.CODCOLIGADA FKPFDEPMOV_PFDEPENDR
CHAPA DCHAPA 16 null
PFHSTDEPEVENTOS.CHAPA FKPFHSTDEPEVENTOS_PFDEPMOVR
PFDEPEND.CHAPA FKPFDEPMOV_PFDEPENDR
NRODEPEND smallint 2 null
PFHSTDEPEVENTOS.NRODEPEND FKPFHSTDEPEVENTOS_PFDEPMOVR
PFDEPEND.NRODEPEND FKPFDEPMOV_PFDEPENDR
ANOCOMP smallint 2 null
PFHSTDEPEVENTOS.ANOCOMP FKPFHSTDEPEVENTOS_PFDEPMOVR
MESCOMP smallint 2 null
PFHSTDEPEVENTOS.MESCOMP FKPFHSTDEPEVENTOS_PFDEPMOVR
MESCAIXA smallint 2 null
TIPOMOV smallint 2 (0)
PFHSTDEPEVENTOS.TIPOMOV FKPFHSTDEPEVENTOS_PFDEPMOVR
VALOR RMDVALOR2 17,2 √ null
VALORORIGINAL RMDVALOR2 17,2 √ null
FOIALTERADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
NROPERIODO smallint 2 null
PFHSTDEPEVENTOS.NROPERIODO FKPFHSTDEPEVENTOS_PFDEPMOVR
DTVENCFERIAS datetime 16,3 √ null
MESREF smallint 2 null
PFHSTDEPEVENTOS.MESREF FKPFHSTDEPEVENTOS_PFDEPMOVR
ANOREF smallint 2 null
PFHSTDEPEVENTOS.ANOREF FKPFHSTDEPEVENTOS_PFDEPMOVR
PERIODOREF smallint 2 null
PFHSTDEPEVENTOS.PERIODOREF FKPFHSTDEPEVENTOS_PFDEPMOVR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATAPAGTOFER DDATETIME 16,3 √ null
PERCENTUALPENSAO RMDVALOR2 17,2 √ null
FORCALCULO varchar 8 √ null
FORMPENSAO varchar 8 √ null
BRUTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
APLICACAO varchar 1 √ null
ANOCAIXA numeric 7 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFDEPMOV Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + NRODEPEND + ANOCOMP + MESCOMP + NROPERIODO + TIPOMOV + MESREF + ANOREF + PERIODOREF

Relationships

Close relationships within degrees of separation