VTAREFA

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PHSTPRODUCAOAGRARIA.CODCOLIGADA FKPHSTPRODUCAOAGRARIA_VTAREFAR
PPARAMFILIAL.CODCOLIGADA FKPPARAMFILIAL_VTAREFA2R
PPRECOPRODUCAO.CODCOLIGADA FKPPRECOPRODUCAO_VTAREFAR
PPRODUCAOAGRARIA.CODCOLIGADA FKPPRODUCAOAGRARIA_VTAREFAR
PRGRCALCTAREFAAGRARIA.CODCOLIGADA FKPRGRCALCTAREFAAGRARIA_VTAREFR
PTAREFAAFAST.CODCOLIGADA FKPTAREFAAFAST_VTAREFAR
VATIVTAREFA.CODCOLIGADA FKVATIVTAREFA_VTAREFAR
VHABILTAREFA.CODCOLIGADA FKVHABILTAREFA_VTAREFAR
VHISTTAREFA.CODCOLIGADA FKVHISTTAREFA_VTAREFAR
VLOTACAOTAREFA.CODCOLIGADA FKVLOTACAOTAREFA_VTAREFAR
VMAPACONHECIMENTOCOMPETENCIA.CODCOLIGADA FKVMAPACONHECCOMPET_VTAREFAR
VMAPACONHECIMENTOREQACESSO.CODCOLIGADA FKVMAPACONHECREQACESSO_VTAREFAR
VPOSTOFUNCAOTAREFA.CODCOLIGADA FKVPOSTOFUNCAOTAREFA_VTAREFAR
VPPRAHISTAREFAFUNCAOPOSTO.CODCOLIGADA FKVPPRAHISTAREFUNCPST_VTAREFAR
VPPRAHISTRISCOSTAREFA.CODCOLIGADA FKVPPRAHISTRISCTAR_VTAREFAR
VPPRAHISTTAREFALOTACAO.CODCOLIGADA FKVPPRAHISTTAREFALOT_VTAREFAR
VPPRAHISTTAREFASFUNCAO.CODCOLIGADA FKVPPRAHISTTARFUNC_VTAREFAR
VPPRAMEDICOES.CODCOLIGADA FKVPPRAMEDICOES_VTAREFAR
VPPRARISCOSTAREFA.CODCOLIGADA FKVPPRARISCOSTAREFA_VTAREFAR
VPPRATAREFASFUNCAO.CODCOLIGADA FKVPPRATAREFASFUNCAO_VTAREFAR
VPPRATAREFASFUNCAOPOSTO.CODCOLIGADA FKVPPRATAREFAFUNCPOSTO_VTAREFAR
VTAREFAPESSOAL.CODCOLIGADA FKVTAREFAPESSOAL_VTAREFAR
CODTAREFA varchar 10 null
PHSTPRODUCAOAGRARIA.CODTAREFA FKPHSTPRODUCAOAGRARIA_VTAREFAR
PPARAMFILIAL.RGRCALCCOMPMINDIARIA FKPPARAMFILIAL_VTAREFA3R
PPARAMFILIAL.RGRCALCDISPENSAPAGA FKPPARAMFILIAL_VTAREFA2R
PPARAMFILIAL.RGRCALCDSR FKPPARAMFILIAL_VTAREFA4R
PPARAMFILIAL.RGRCALCFERIADONORMAL FKPPARAMFILIAL_VTAREFA1R
PPARAMFILIAL.RGRCALFERIADODOBRO FKPPARAMFILIAL_VTAREFAR
PPRECOPRODUCAO.CODTAREFA FKPPRECOPRODUCAO_VTAREFAR
PPRODUCAOAGRARIA.CODTAREFA FKPPRODUCAOAGRARIA_VTAREFAR
PRGRCALCTAREFAAGRARIA.CODTAREFA FKPRGRCALCTAREFAAGRARIA_VTAREFR
PTAREFAAFAST.CODTAREFA FKPTAREFAAFAST_VTAREFAR
VATIVTAREFA.CODTAREFA FKVATIVTAREFA_VTAREFAR
VHABILTAREFA.CODTAREFA FKVHABILTAREFA_VTAREFAR
VHISTTAREFA.CODTAREFA FKVHISTTAREFA_VTAREFAR
VLOTACAOTAREFA.CODTAREFA FKVLOTACAOTAREFA_VTAREFAR
VMAPACONHECIMENTOCOMPETENCIA.CODTAREFA FKVMAPACONHECCOMPET_VTAREFAR
VMAPACONHECIMENTOREQACESSO.CODTAREFA FKVMAPACONHECREQACESSO_VTAREFAR
VPOSTOFUNCAOTAREFA.CODTAREFA FKVPOSTOFUNCAOTAREFA_VTAREFAR
VPPRAHISTAREFAFUNCAOPOSTO.CODTAREFA FKVPPRAHISTAREFUNCPST_VTAREFAR
VPPRAHISTRISCOSTAREFA.CODTAREFA FKVPPRAHISTRISCTAR_VTAREFAR
VPPRAHISTTAREFALOTACAO.CODTAREFA FKVPPRAHISTTAREFALOT_VTAREFAR
VPPRAHISTTAREFASFUNCAO.CODTAREFA FKVPPRAHISTTARFUNC_VTAREFAR
VPPRAMEDICOES.CODTAREFA FKVPPRAMEDICOES_VTAREFAR
VPPRARISCOSTAREFA.CODTAREFA FKVPPRARISCOSTAREFA_VTAREFAR
VPPRATAREFASFUNCAO.CODTAREFA FKVPPRATAREFASFUNCAO_VTAREFAR
VPPRATAREFASFUNCAOPOSTO.CODTAREFA FKVPPRATAREFAFUNCPOSTO_VTAREFAR
VTAREFAPESSOAL.CODTAREFA FKVTAREFAPESSOAL_VTAREFAR
NOMETAREFA varchar 100 √ null
DESCRICAO MEMO 2147483647 √ null
CODTPATIVEXEC varchar 3 √ null
VTPATIVEXEC.CODTPATIVEXEC FKVTAREFA_VTPATIVEXECR
INATIVA DLOGICO 2 (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
NOMEABREVIADO varchar 20 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVTAREFA Primary key Asc/Asc CODCOLIGADA + CODTAREFA

Relationships

Close relationships within degrees of separation