SPJ — Horário Padrão | Tabelas do Protheus

Resposta rápida

Arquivo físico: SPJ + empresa, ex.: SPJ010
Chave única: PJ_FILIAL+PJ_TURNO+PJ_SEMANA+PJ_DIA
Compartilhamento: Exclusivo
Estrutura: 36 campos (0 virtuais), 1 índice, 78 gatilhos
Rotina do sistema: PONA080

Consultar no seu ambiente

Registros da tabelaSQL

SELECT TOP 100 PJ_FILIAL, PJ_TURNO, PJ_SEMANA, PJ_DIA
  FROM SPJ010
 WHERE D_E_L_E_T_ = ' '
 ORDER BY PJ_FILIAL, PJ_TURNO, PJ_SEMANA, PJ_DIA

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 = 'SPJ'
   AND D_E_L_E_T_ = ' '
 ORDER BY X3_ORDEM

Com quem SPJ se liga

Consulta 1

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

SP1

Campos 36

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

Turno	Caractere	3	0	Real	`@!`	—	Codigo do Turno

Sequencia	Caractere	2	0	Real	`99`	—	Sequencia de Turno

Dia Semana	Caractere	1	0	Real	`@!`	—	Dia da Semana

Tipo Dia	Caractere	1	0	Real	`@!`	—	Tipo do Dia

Limite Infer	Numérico	5	2	Real	`@E 99.99`	—	Limite Minimo da Tabela

1a Entrada	Numérico	5	2	Real	`@E 99.99`	—	Horario da 1a Entrada

1a Saida	Numérico	5	2	Real	`@E 99.99`	—	Horario da 1a Saida

2a Entrada	Numérico	5	2	Real	`@E 99.99`	—	Horario da 2a Entrada

2a Saida	Numérico	5	2	Real	`@E 99.99`	—	Horario da 2a Saida

3a Entrada	Numérico	5	2	Real	`@E 99.99`	—	Horario da 3a Entrada

3a Saida	Numérico	5	2	Real	`@E 99.99`	—	Horario da 3a Saida

4a Entrada	Numérico	5	2	Real	`@E 99.99`	—	Horario da 4a Entrada

4a Saida	Numérico	5	2	Real	`@E 99.99`	—	Horario da 4a Saida

Limite Super	Numérico	5	2	Real	`@E 99.99`	—	Limite Maximo da Tabela

Cod.Refeicao	Caractere	2	0	Real	`99`	`SP1`	Codigo da Refeicao

Tp.He Normal	Caractere	1	0	Real	`@!`	—	Tipo de Hora Extra Normal

Tp.He Not.	Caractere	1	0	Real	`@!`	—	Tipo de Hora Ext Noturna

Nona Hora	Caractere	1	0	Real	`@!`	—	Apura Nona Hora

1a.S.Interv	Caractere	1	0	Real	`@!`	—	1a Saida e Intervalo

Título	Tipo	Tam.	Dec.	Contexto	Picture	F3	Descrição
2a.S.Interv.	Caractere	1	0	Real	`@!`	—	2a Saida e Intervalo

3a.S.Interv.	Caractere	1	0	Real	`@!`	—	3a Saida e Intervalo

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	`@E 99.99`	—	Horas 1o. Intervalo

Hrs 2o.Int.	Numérico	5	2	Real	`@E 99.99`	—	Horas 2o. Intervalo

Hrs 3o.Int.	Numérico	5	2	Real	`@E 99.99`	—	Horas 3o. Intervalo

Hrs.Trb.1a.J	Numérico	5	2	Real	`@E 99.99`	—	Hrs. Trb. 1a. Jornada

Hrs.Trb.2a.J	Numérico	5	2	Real	`@E 99.99`	—	Hrs. Trb. 2a. Jornada

Hrs.Trb.3a.J	Numérico	5	2	Real	`@E 99.99`	—	Hrs. Trb. 3a. Jornada

Hrs.Trb.4a.J	Numérico	5	2	Real	`@E 99.99`	—	Hrs. Trb. 4a. Jornada

Horas Total	Numérico	6	2	Real	`@E 999.99`	—	Total de Horas

Interv.SREP	Caractere	2	0	Real	—	—	Intervalo para ACJEF

Contr.Exp.Rh	Caractere	6	0	Real	—	—	Controle de Exportação RH

Índices 1

Ordem	Chave	Descrição	Nickname	Pesquisa
`1`	`PJ_FILIAL+PJ_TURNO+PJ_SEMANA+PJ_DIA`	Turno + Sequencia + Dia Semana	—	S

Gatilhos 78

Campo	Seq.	Contradomínio	Tipo	Regra	Alias	Chave de busca	Condição
`PJ_ENTRA1`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_ENTRA1`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_ENTRA1`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_ENTRA1`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_ENTRA1`	005	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGat("T")`	—	—	—
`PJ_ENTRA2`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_ENTRA2`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_ENTRA2`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_ENTRA2`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_ENTRA2`	005	`PJ_HRSINT1`	P	`M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1")`	—	—	—
`PJ_ENTRA2`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_ENTRA3`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_ENTRA3`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_ENTRA3`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_ENTRA3`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_ENTRA3`	005	`PJ_HRSINT2`	P	`M->PJ_HRSINT2 := fHrsTrabGaT("I",,,"2")`	—	—	—
`PJ_ENTRA3`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_ENTRA4`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_ENTRA4`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_ENTRA4`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_ENTRA4`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_ENTRA4`	005	`PJ_HRSINT3`	P	`M->PJ_HRSINT3 := fHrsTrabGaT("I",,,"3")`	—	—	—
`PJ_ENTRA4`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_INTERV1`	001	`PJ_HRSINT1`	P	`M->PJ_HRSINT1 := fHrsTrabGat('I',,,"1")`	—	—	—
`PJ_INTERV1`	002	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGat("T")`	—	—	—
`PJ_INTERV2`	001	`PJ_HRSINT2`	P	`M->PJ_HRSINT2 := fHrsTrabGat('I',,,"2")`	—	—	—
`PJ_INTERV2`	002	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGat("T")`	—	—	—
`PJ_INTERV3`	001	`PJ_HRSINT3`	P	`M->PJ_HRSINT3 := fHrsTrabGat('I',,,"3")`	—	—	—
`PJ_INTERV3`	002	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGat("T")`	—	—	—
`PJ_JND1CON`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_JND1CON`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_JND1CON`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_JND1CON`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_JND1CON`	005	`PJ_HRSINT1`	P	`M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1")`	—	—	—
`PJ_JND1CON`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_JND2CON`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_JND2CON`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_JND2CON`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_JND2CON`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_JND2CON`	005	`PJ_HRSINT1`	P	`M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1")`	—	—	—
`PJ_JND2CON`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_JND3CON`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_JND3CON`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_JND3CON`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_JND3CON`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_JND3CON`	005	`PJ_HRSINT1`	P	`M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1")`	—	—	—
`PJ_JND3CON`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_JND4CON`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_JND4CON`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_JND4CON`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_JND4CON`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_JND4CON`	005	`PJ_HRSINT1`	P	`M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1")`	—	—	—
`PJ_JND4CON`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_SAIDA1`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_SAIDA1`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_SAIDA1`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_SAIDA1`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_SAIDA1`	005	`PJ_HRSINT1`	P	`M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1")`	—	—	—
`PJ_SAIDA1`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_SAIDA2`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_SAIDA2`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_SAIDA2`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_SAIDA2`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_SAIDA2`	005	`PJ_HRSINT2`	P	`M->PJ_HRSINT2 := fHrsTrabGaT("I",,,"2")`	—	—	—
`PJ_SAIDA2`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_SAIDA3`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_SAIDA3`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_SAIDA3`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_SAIDA3`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_SAIDA3`	005	`PJ_HRSINT3`	P	`M->PJ_HRSINT3 := fHrsTrabGaT("I",,,"3")`	—	—	—
`PJ_SAIDA3`	006	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_SAIDA4`	001	`PJ_HRSTRAB`	P	`M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1")`	—	—	—
`PJ_SAIDA4`	002	`PJ_HRSTRA2`	P	`M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2")`	—	—	—
`PJ_SAIDA4`	003	`PJ_HRSTRA3`	P	`M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3")`	—	—	—
`PJ_SAIDA4`	004	`PJ_HRSTRA4`	P	`M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4")`	—	—	—
`PJ_SAIDA4`	005	`PJ_HRTOTAL`	P	`M->PJ_HRTOTAL := fHrsTrabGaT("T")`	—	—	—
`PJ_TPDIA`	001	`PJ_TPEXT`	P	`IF(M->PJ_TPDIA=='D',M->PJ_TPEXT:="2",IF(M->PJ_TPDIA=="C",M->PJ_TPDIA:="3",M->PJ_TPDIA:="1"))`	—	—	—
`PJ_TPDIA`	002	`PJ_TPEXTN`	P	`IF(M->PJ_TPDIA=='D',M->PJ_TPEXTN:="6",IF(M->PJ_TPDIA=="C",M->PJ_TPEXTN:="7",M->PJ_TPEXTN:="5"))`	—	—	—

Procedência

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

SPJ Horário Padrão