RBH — Habilidades do Cargo | Tabelas do Protheus

Resposta rápida

Arquivo físico: RBH + empresa, ex.: RBH010
Chave única: RBH_FILIAL+RBH_GRUPO+RBH_CARGO+RBH_CC+RBH_CODCOM+RBH_ITECOM+RBH_HABIL
Compartilhamento: Compartilhado
Estrutura: 18 campos (7 virtuais), 3 índices, 35 gatilhos

Consultar no seu ambiente

Registros da tabelaSQL

SELECT TOP 100 RBH_FILIAL, RBH_GRUPO, RBH_CARGO, RBH_CC, RBH_CODCOM, RBH_ITECOM
  FROM RBH010
 WHERE D_E_L_E_T_ = ' '
 ORDER BY RBH_FILIAL, RBH_GRUPO, RBH_CARGO, RBH_CC, RBH_CODCOM, RBH_ITECOM, RBH_HABIL

Dicionário do seu ambienteSQL

SELECT X3_ORDEM, X3_CAMPO, X3_TITULO, X3_TIPO, X3_TAMANHO, X3_DECIMAL, X3_CONTEXT
  FROM SX3010
 WHERE X3_ARQUIVO = 'RBH'
   AND D_E_L_E_T_ = ' '
 ORDER BY X3_ORDEM

Com quem RBH se liga

Consulta 5

Tabelas usadas como consulta padrão (F3) pelos campos desta.

Gatilhos buscam em 6

Tabelas onde os gatilhos desta posicionam para trazer um valor.

Campos 18

Clique no campo para ver validação, inicializador, combo e gatilhos.

Filtrar campos

Título	Tipo	Tam.	Dec.	Contexto	Picture	F3	Descrição
Filial	Caractere	2	0	Real	—	—	Filial

Grupo	Caractere	2	0	Real	`99`	`SQ0`	Grupo Funcional

Cargo	Caractere	5	0	Real	`@!`	`SQ3`	Cargo do Funcionario

Centro Custo	Caractere	9	0	Real	`@!`	`CTT`	Cod. Centro de Custo

Competencia	Caractere	6	0	Real	`@!`	`RBM`	Cod. Estrut. Competencia

Desc.Compet.	Caractere	30	0	Virtual	`@!`	—	Descricäo da Competencia

Item Compet.	Caractere	6	0	Real	`@!`	`RD2001`	Item de Competencia

Desc.It.Comp	Caractere	30	0	Virtual	`@!`	—	Desc. Item Competencia

Habilidade	Caractere	6	0	Real	`@!`	`RBG001`	Codigo da Habilidade

Desc. Habil.	Caractere	60	0	Virtual	`@S20`	—	Descricäo da Habilidade

Escala	Caractere	2	0	Real	`99`	—	Codigo da Escala

Desc. Escala	Caractere	20	0	Virtual	`@!`	—	Descricao da Escala

Item Escala	Caractere	2	0	Real	`@!`	`RBL`	Item da Escala

D.Item Esc.	Caractere	20	0	Virtual	`@!`	—	Desc. Item de Escala

Grau Import.	Caractere	2	0	Real	`99`	—	Grau de Importancia

Desc.Import.	Caractere	20	0	Virtual	`@!`	—	Desc. Grau de Importancia

Item Import.	Caractere	2	0	Real	`@!`	`RBL`	Item do Grau Importancia

D.Item Imp.	Caractere	20	0	Virtual	`@!`	—	Desc. Item Grau Import.

Índices 3

Ordem	Chave	Descrição	Nickname	Pesquisa
`1`	`RBH_FILIAL+RBH_GRUPO+RBH_CARGO+RBH_CODCOM+RBH_ITECOM`	Grupo + Cargo + Competencia + Item Compet.	—	S
`2`	`RBH_FILIAL+RBH_GRUPO+RBH_CARGO+RBH_CC+RBH_CODCOM+RBH_ITECOM`	Grupo + Cargo + Centro Custo + Competencia + Item Compet.	—	S
`3`	`RBH_FILIAL+RBH_CODCOM+RBH_ITECOM+RBH_HABIL`	Competencia + Item Compet. + Habilidade	—	S

Gatilhos 35

Campo	Seq.	Contradomínio	Tipo	Regra	Alias	Chave de busca	Condição
`RBH_CODCOM`	001	`RBH_ITECOM`	P	`M->RBH_ITECOM := ""`	—	—	—
`RBH_CODCOM`	002	`RBH_HABIL`	P	`M->RBH_HABIL := ""`	—	—	—
`RBH_CODCOM`	003	`RBH_ESCALA`	P	`M->RBH_ESCALA := ""`	—	—	—
`RBH_CODCOM`	004	`RBH_IMPORT`	P	`M->RBH_IMPORT := ""`	—	—	—
`RBH_CODCOM`	005	`RBH_DHABIL`	P	`M->RBH_DHABIL := ""`	—	—	—
`RBH_CODCOM`	006	`RBH_ITESCA`	P	`M->RBH_ITESCA := ""`	—	—	—
`RBH_CODCOM`	007	`RBH_ITIMPO`	P	`M->RBH_ITIMPO := ""`	—	—	—
`RBH_CODCOM`	008	`RBH_DITESC`	P	`M->RBH_DITESC := ""`	—	—	—
`RBH_CODCOM`	009	`RBH_DITIMP`	P	`M->RBH_DITIMP := ""`	—	—	—
`RBH_CODCOM`	010	`RBH_DESCAL`	P	`M->RBH_DESCAL := ""`	—	—	—
`RBH_CODCOM`	011	`RBH_DIMPOR`	P	`M->RBH_DIMPOR := ""`	—	—	—
`RBH_CODCOM`	012	`RBH_DITCOM`	P	`M->RBH_DITCOM := RD2->RD2_DESC`	`RD2`	`xFilial("RD2")+M->RBH_CODCOM+M->RBH_ITECOM`	—
`RBH_CODCOM`	013	`RBH_DCDCOM`	P	`M->RBH_DCDCOM := RDM->RDM_DESC`	`RDM`	`xFilial("RDM")+M->RBH_CODCOM`	—
`RBH_HABIL`	001	`RBH_DHABIL`	P	`M->RBH_DHABIL := RBG->RBG_DESC`	`RBG`	`xFilial("RBG")+M->RBH_HABIL`	—
`RBH_HABIL`	002	`RBH_ESCALA`	P	`M->RBH_ESCALA := RBG->RBG_ESCALA`	`RBG`	`xFilial("RBG")+M->RBH_HABIL`	—
`RBH_HABIL`	003	`RBH_DESCAL`	P	`M->RBH_DESCAL := RBK->RBK_DESCRI`	`RBK`	`xFilial("RBK")+M->RBH_ESCALA`	—
`RBH_HABIL`	004	`RBH_IMPORT`	P	`M->RBH_IMPORT := RBG->RBG_IMPORT`	`RBG`	`xFilial("RBG")+M->RBH_HABIL`	—
`RBH_HABIL`	005	`RBH_DIMPOR`	P	`M->RBH_DIMPOR := RBK->RBK_DESCRI`	`RBK`	`xFilial("RBK")+M->RBH_IMPORT`	—
`RBH_HABIL`	006	`RBH_ITESCA`	P	`M->RBH_ITESCA := ""`	—	—	—
`RBH_HABIL`	007	`RBH_ITIMPO`	P	`M->RBH_ITIMPO := ""`	—	—	—
`RBH_HABIL`	008	`RBH_DITESC`	P	`M->RBH_DITESC := ""`	—	—	—
`RBH_HABIL`	009	`RBH_DITIMP`	P	`M->RBH_DITIMP := ""`	—	—	—
`RBH_ITECOM`	001	`RBH_HABIL`	P	`M->RBH_HABIL := RBJ->RBJ_HABIL`	`RBJ`	`xFilial("RBJ")+M->RBH_CODCOM+M->RBH_ITECOM`	—
`RBH_ITECOM`	002	`RBH_ESCALA`	P	`M->RBH_ESCALA := RBG->RBG_ESCALA`	`RBG`	`xFilial("RBG")+M->RBH_HABIL`	—
`RBH_ITECOM`	003	`RBH_IMPORT`	P	`M->RBH_IMPORT := RBG->RBG_IMPORT`	`RBG`	`xFilial("RBG")+M->RBH_HABIL`	—
`RBH_ITECOM`	004	`RBH_DHABIL`	P	`M->RBH_DHABIL := RBG->RBG_DESC`	`RBG`	`xFilial("RBG")+M->RBH_HABIL`	—
`RBH_ITECOM`	005	`RBH_ITESCA`	P	`M->RBH_ITESCA := ""`	—	—	—
`RBH_ITECOM`	006	`RBH_ITIMPO`	P	`M->RBH_ITIMPO := ""`	—	—	—
`RBH_ITECOM`	007	`RBH_DITESC`	P	`M->RBH_DITESC := ""`	—	—	—
`RBH_ITECOM`	008	`RBH_DITIMP`	P	`M->RBH_DITIMP := ""`	—	—	—
`RBH_ITECOM`	009	`RBH_DESCAL`	P	`M->RBH_DESCAL := RBK->RBK_DESCRI`	`RBK`	`xFilial("RBK")+M->RBH_ESCALA`	—
`RBH_ITECOM`	010	`RBH_DIMPOR`	P	`M->RBH_DIMPOR := RBK->RBK_DESCRI`	`RBK`	`xFilial("RBK")+M->RBH_IMPORT`	—
`RBH_ITECOM`	011	`RBH_DITCOM`	P	`M->RBH_DITCOM := RD2->RD2_DESC`	`RD2`	`xFilial("RD2")+M->RBH_CODCOM+M->RBH_ITECOM`	—
`RBH_ITESCA`	001	`RBH_DITESC`	P	`M->RBH_DITESC := RBL->RBL_DESCRI`	`RBL`	`xFilial("RBL")+M->RBH_ESCALA+M->RBH_ITESCA`	—
`RBH_ITIMPO`	001	`RBH_DITIMP`	P	`M->RBH_DITIMP := RBL->RBL_DESCRI`	`RBL`	`xFilial("RBL")+M->RBH_IMPORT+M->RBH_ITIMPO`	—

Procedência

Dicionário padrão do Protheus 12.1.2510, como a TOTVS distribui, sem customização de ambiente.

RBH Habilidades do Cargo