APERFUN

3293 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ACOMPFUN.CODCOLIGADA FKACOMPFUN_APERFUNR
ADEFINICAOCOMPENSACAO.CODCOLIGADA FKADEFINICAOCOMPENSACA_APERFUR
AMOVFUN.CODCOLIGADA FKAMOVFUN_APERFUNR
ASALDOBANCOHOR.CODCOLIGADA FKASALDOBANCOHOR_APERFUNR
APARFUN.CODCOLIGADA FKAPERFUN_APARFUNR
CHAPA DCHAPA 16 null
ACOMPFUN.CHAPA FKACOMPFUN_APERFUNR
ADEFINICAOCOMPENSACAO.CHAPA FKADEFINICAOCOMPENSACA_APERFUR
AMOVFUN.CHAPA FKAMOVFUN_APERFUNR
ASALDOBANCOHOR.CHAPA FKASALDOBANCOHOR_APERFUNR
APARFUN.CHAPA FKAPERFUN_APARFUNR
INICIOPER datetime 16,3 null
ACOMPFUN.INICIOPER FKACOMPFUN_APERFUNR
ADEFINICAOCOMPENSACAO.INICIOPERIODO FKADEFINICAOCOMPENSACA_APERFUR
AMOVFUN.INICIOPER FKAMOVFUN_APERFUNR
ASALDOBANCOHOR.INICIOPER FKASALDOBANCOHOR_APERFUNR
FIMPER datetime 16,3 null
ACOMPFUN.FIMPER FKACOMPFUN_APERFUNR
ADEFINICAOCOMPENSACAO.FIMPERIODO FKADEFINICAOCOMPENSACA_APERFUR
AMOVFUN.FIMPER FKAMOVFUN_APERFUNR
ASALDOBANCOHOR.FIMPER FKASALDOBANCOHOR_APERFUNR
ANOCOMP smallint 2 null
MESCOMP smallint 2 null
DESCRICAO varchar 40 √ null
ALTERADO smallint 2 √ null
OCORRENCIACRITICADA DLOGICO 2 (0)
DATAULTIMOCALCULO datetime 16,3 √ null
MEMORIACALCULO MEMO 2147483647 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
REFERENCIABATIDAALTERADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ARQUIVOMORTO smallint 2 √ ((0))
ATUALIZASALDO smallint 2 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKAPERFUN Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + INICIOPER + FIMPER

Relationships

Close relationships within degrees of separation