Pragiva — Tecnologia na prática

Tabelas Referência

RF3 Jornada

RF3 tem 45 campos, 1 índice e 76 gatilhos no dicionário padrão, e cada registro é identificado pela chave única.

Protheus 12.1.2510 exclusivo derivado do dicionário padrão

Resposta rápida

Arquivo físico
RF3 + empresa, ex.: RF3010
Chave única
RF3_FILIAL+RF3_JORN
Compartilhamento
Exclusivo
Estrutura
45 campos (0 virtuais), 1 índice, 76 gatilhos

Consultar no seu ambiente

Registros da tabelaSQL
SELECT TOP 100 RF3_FILIAL, RF3_JORN
  FROM RF3010
 WHERE D_E_L_E_T_ = ' '
 ORDER BY RF3_FILIAL, RF3_JORN
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 = 'RF3'
   AND D_E_L_E_T_ = ' '
 ORDER BY X3_ORDEM

Com quem RF3 se liga

É consultada por 2

Tabelas cujos campos usam esta como consulta padrão.

Campos 45

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

CampoTítuloTipoTam. Dec.ContextoPictureF3Descrição
Filial Caractere 2 0 Real — — Filial
Jornada Caractere 3 0 Real — — Código da Jornada
Descrição Caractere 50 0 Real — — Descrição da Jornada
Flag Caractere 1 0 Real ! — Flag de Geracao
1E Numérico 5 2 Real @E 99.99 — Primeira Entrada
1S Numérico 5 2 Real @E 99.99 — Primeira Saída
2E Numérico 5 2 Real @E 99.99 — Segunda Entrada
2S Numérico 5 2 Real @E 99.99 — Segunda Saída
3E Numérico 5 2 Real @E 99.99 — Terceira Entrada
3S Numérico 5 2 Real @E 99.99 — Terceira Saída
4E Numérico 5 2 Real @E 99.99 — Quarta Entrada
4S Numérico 5 2 Real @E 99.99 — Quarta Saída
Limite Infer Numérico 5 2 Real @E 99.99 — Limite mínimo da tabela
Limite Sup. Numérico 5 2 Real @E 99.99 — Limite Máximo da Tabela
1a.S.Interv Caractere 1 0 Real @! — 1a Saida e Intervalo
2a.S.Interv. Caractere 1 0 Real @! — 2a Saida e Intervalo
3a.S.Interv. Caractere 1 0 Real @! — 3a Saida e Intervalo
Inferior 1E Numérico 5 2 Real @E 99.99 — Limite Inferior 1E
Superior 1E Numérico 5 2 Real @E 99.99 — Limite Superior 1E
Inferior 1S Numérico 5 2 Real @E 99.99 — Limite Inferior 1S
CampoTítuloTipoTam. Dec.ContextoPictureF3Descrição
Superior 1S Numérico 5 2 Real @E 99.99 — Limite Superior 1S
Inferior 2E Numérico 5 2 Real @E 99.99 — Limite Inferior 2E
Superior 2E Numérico 5 2 Real @E 99.99 — Limite Superior 2E
Inferior 2S Numérico 5 2 Real @E 99.99 — Limite Inferior 2S
Superior 2S Numérico 5 2 Real @E 99.99 — Limite Superior 2S
Inferior 3E Numérico 5 2 Real @E 99.99 — Limite Superior 3E
Superior 3E Numérico 5 2 Real @E 99.99 — Limite Superior 3E
Inferior 3S Numérico 5 2 Real @E 99.99 — Limite Inferior 3S
Superior 3S Numérico 5 2 Real @E 99.99 — Limite Superior 3S
Inferior 4E Numérico 5 2 Real @E 99.99 — Limite Inferior 4E
Superior 4E Numérico 5 2 Real @E 99.99 — Limite Superior 4E
Inferior 4S Numérico 5 2 Real @E 99.99 — Limite Inferior 4S
Superior 4S Numérico 5 2 Real @E 99.99 — Limite Superior 4S
1a.Jor.Cont. Caractere 1 0 Real @! — 1a Jornada Continua?
2a.Jor.Cont. Caractere 1 0 Real @! — 2a Jornada Continua?
3a.Jor.Cont. Caractere 1 0 Real @! — 3a Jornada Continua?
4a.Jor.Cont. Caractere 1 0 Real @! — 4a Jornada Continua?
Hrs 1o.Int. Numérico 5 2 Real 99.99 — Horas 1o. Intervalo
Hrs 2o.Int. Numérico 5 2 Real 99.99 — Horas 2o. Intervalo
Hrs 3o.Int. Numérico 5 2 Real 99.99 — Horas 3o. Intervalo
CampoTítuloTipoTam. Dec.ContextoPictureF3Descrição
Hrs.Trb.1a.J Numérico 5 2 Real 99.99 — Hrs. Trb. 1a. Jornada
Hrs.Trb.2a.J Numérico 5 2 Real 99.99 — Hrs. Trb. 2a. Jornada
Hrs.Trb.3a.J Numérico 5 2 Real 99.99 — Hrs. Trb. 3a. Jornada
Hrs.Trb.4a.J Numérico 5 2 Real 99.99 — Hrs. Trb. 4a. Jornada
Horas Total Numérico 6 2 Real 999.99 — Total de Horas

Índices 1

OrdemChaveDescriçãoNicknamePesquisa
1 RF3_FILIAL+RF3_JORN Jornada — S

Gatilhos 76

CampoSeq.ContradomínioTipoRegraAliasChave de buscaCondição
RF3_ENTRA1 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_ENTRA1 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_ENTRA1 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_ENTRA1 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_ENTRA1 005 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_ENTRA2 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_ENTRA2 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_ENTRA2 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_ENTRA2 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_ENTRA2 005 RF3_HRINT1 P M->RF3_HRINT1:= fHrsTrabGat("I","RF3","MB","1") — — —
RF3_ENTRA2 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_ENTRA3 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_ENTRA3 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_ENTRA3 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_ENTRA3 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_ENTRA3 005 RF3_HRINT2 P M->RF3_HRINT2:= fHrsTrabGat("I","RF3","MB","2") — — —
RF3_ENTRA3 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_ENTRA4 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_ENTRA4 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_ENTRA4 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_ENTRA4 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_ENTRA4 005 RF3_HRINT3 P M->RF3_HRINT3:= fHrsTrabGat("I","RF3","MB","3") — — —
RF3_ENTRA4 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_INTER1 001 RF3_HRINT1 P M->RF3_HRINT1:= fHrsTrabGat("I","RF3","MB","1") — — —
RF3_INTER1 002 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_INTER2 001 RF3_HRINT2 P M->RF3_HRINT2:= fHrsTrabGat("I","RF3","MB","2") — — —
RF3_INTER2 002 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_INTER3 001 RF3_HRINT3 P M->RF3_HRINT3:= fHrsTrabGat("I","RF3","MB","3") — — —
RF3_INTER3 002 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_JND1CO 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_JND1CO 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_JND1CO 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_JND1CO 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_JND1CO 005 RF3_HRINT1 P M->RF3_HRINT1:= fHrsTrabGat("I","RF3","MB","1") — — —
RF3_JND1CO 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_JND2CO 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_JND2CO 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_JND2CO 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_JND2CO 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_JND2CO 005 RF3_HRINT1 P M->RF3_HRINT1:= fHrsTrabGat("I","RF3","MB","1") — — —
RF3_JND2CO 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_JND3CO 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_JND3CO 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_JND3CO 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_JND3CO 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_JND3CO 005 RF3_HRINT1 P M->RF3_HRINT1:= fHrsTrabGat("I","RF3","MB","1") — — —
RF3_JND3CO 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_JND4CO 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_JND4CO 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_JND4CO 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_JND4CO 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_JND4CO 005 RF3_HRINT1 P M->RF3_HRINT1:= fHrsTrabGat("I","RF3","MB","1") — — —
RF3_JND4CO 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_SAIDA1 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_SAIDA1 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_SAIDA1 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_SAIDA1 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_SAIDA1 005 RF3_HRINT1 P M->RF3_HRINT1:= fHrsTrabGat("I","RF3","MB","1") — — —
RF3_SAIDA1 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_SAIDA2 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_SAIDA2 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_SAIDA2 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_SAIDA2 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_SAIDA2 005 RF3_HRINT2 P M->RF3_HRINT2:= fHrsTrabGat("I","RF3","MB","2") — — —
RF3_SAIDA2 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_SAIDA3 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_SAIDA3 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_SAIDA3 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_SAIDA3 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_SAIDA3 005 RF3_HRINT3 P M->RF3_HRINT3:= fHrsTrabGat("I","RF3","MB","3") — — —
RF3_SAIDA3 006 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —
RF3_SAIDA4 001 RF3_HRTRAB P M->RF3_HRTRAB:= fHrsTrabGat("H","RF3","MB","1") — — —
RF3_SAIDA4 002 RF3_HRTRA2 P M->RF3_HRTRA2:= fHrsTrabGat("H","RF3","MB","2") — — —
RF3_SAIDA4 003 RF3_HRTRA3 P M->RF3_HRTRA3:= fHrsTrabGat("H","RF3","MB","3") — — —
RF3_SAIDA4 004 RF3_HRTRA4 P M->RF3_HRTRA4:= fHrsTrabGat("H","RF3","MB","4") — — —
RF3_SAIDA4 005 RF3_HRSTOT P M->RF3_HRSTOT:= fHrsTrabGat("T","RF3","MB") — — —

Procedência

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