VPROCTRABINFOCONTRATO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDINFOCONTRATO int 4 null
VPROCTRABABONO.IDINFOCONTRATO FKVPROCTRABABONO_VPROCTRABINFR
VPROCTRABINFOCONTRATOCOMPL.IDINFOCONTRATO FKINFOCONTRATOCOMPL_INFOCONTRAR
VPROCTRABMUDCATEGATIV.IDINFOCONTRATO FKMUDCATEGATIV_VPROCTRABINFOCOR
VPROCTRABPERIODO.IDINFOCONTRATO FKPERIODO_VPROCTRABINFOCONTRATR
VPROCTRABUNICIDADECONTRATUAL.IDINFOCONTRATO FKUNICIDADECONTRATUAL_INFOCONTR
TPCONTR int 4 √ null
INDCONTR char 1 √ null
DTADMORIG datetime 16,3 √ null
INDREINT char 1 √ null
INDCATEG char 1 √ null
INDNATATIV char 1 √ null
INDMOTDESLIG char 1 √ null
INDUNIC char 1 √ null
MATRICULA varchar 30 √ null
CODCATEG int 4 √ null
DTINICIO datetime 16,3 √ null
TPINSCFILIAL int 4 √ null
NRINSCFILIAL varchar 14 √ null
COMPINI varchar 7 √ null
COMPFIM varchar 7 √ null
REPERCPROC int 4 √ null
VRREMUN numeric 16,2 √ null
VRAPI numeric 16,2 √ null
VR13API numeric 16,2 √ null
VRINDEN numeric 16,2 √ null
VRBASEINDENFGTS numeric 16,2 √ null
PAGDIRETORESC char 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDTRABALHADOR int 4 √ null
VPROCTRABTRABALHADOR.IDTRABALHADOR FKINFOCONTRATO_VPROCTRABTRABALR
INDREPERC int 4 √ null
INDENSD char 1 √ null
INDENABONO char 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVPROCTRABINFOCONTRATO Primary key Asc IDINFOCONTRATO

Relationships

Close relationships within degrees of separation