PFRESILICAO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFRESILICAOENCARGOS.CODCOLIGADA FKPFRESILICAOENCARGOS_PFRESILIR
PFRESILICAOMOV.CODCOLIGADA FKPFRESILICAOMOV_PFRESILICAOR
PFRESILICAOMOVBASE.CODCOLIGADA FKPFRESILICAOMOVBASE_PFRESILICR
PFRESILICAOSALCOMP.CODCOLIGADA FKPFRESILICAOSALCOMP_PFRESILICR
PMOTMUDSAL.CODCOLIGADA FKPFRESILICAO_PMOTMUDSALR
PFUNC.CODCOLIGADA FKPFRESILICAO_PFUNCR
PTIPOSRESILICAO.CODCOLIGADA FKPFRESILICAO_PTIPOSRESILICAOR
CHAPA DCHAPA 16 null
PFRESILICAOENCARGOS.CHAPA FKPFRESILICAOENCARGOS_PFRESILIR
PFRESILICAOMOV.CHAPA FKPFRESILICAOMOV_PFRESILICAOR
PFRESILICAOMOVBASE.CHAPA FKPFRESILICAOMOVBASE_PFRESILICR
PFRESILICAOSALCOMP.CHAPA FKPFRESILICAOSALCOMP_PFRESILICR
PFUNC.CHAPA FKPFRESILICAO_PFUNCR
IDRESILICAO smallint 2 null
PFRESILICAOENCARGOS.IDRESILICAO FKPFRESILICAOENCARGOS_PFRESILIR
PFRESILICAOMOV.IDRESILICAO FKPFRESILICAOMOV_PFRESILICAOR
PFRESILICAOMOVBASE.IDRESILICAO FKPFRESILICAOMOVBASE_PFRESILICR
PFRESILICAOSALCOMP.IDRESILICAO FKPFRESILICAOSALCOMP_PFRESILICR
CODTIPO varchar 2 null
PTIPOSRESILICAO.CODTIPO FKPFRESILICAO_PTIPOSRESILICAOR
DATARESILICAO DDATETIME 16,3 √ null
DTINICIOCONTRATO DDATETIME 16,3 √ null
DTFIMCONTRATO DDATETIME 16,3 √ null
JORNADAANTERIOR smallint 2 √ null
SALARIOANTERIOR RMDVALOR2 17,2 √ null
JORNADAATUAL smallint 2 √ null
SALARIOATUAL RMDVALOR2 17,2 √ null
JORNADACALC smallint 2 √ null
SALARIOCALC RMDVALOR2 17,2 √ null
USASALCOMPOSTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ORIGEMCLASSIS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
MOTMUDANCASALARIO varchar 2 √ null
PMOTMUDSAL.CODCLIENTE FKPFRESILICAO_PMOTMUDSALR
RESILICAOCALCULADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
RESILICAOPRECISARECALC DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ANOCOMPLANC smallint 2 √ null
MESCOMPLANC smallint 2 √ null
PERIODOLANC smallint 2 √ null
EXECID varchar 40 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_PFRESILICAO Primary key Asc/Asc/Asc CODCOLIGADA + CHAPA + IDRESILICAO

Relationships

Close relationships within degrees of separation