Ajude o site desativando o bloqueador de anúncio
Cabeçalho

Tabela 2410 SPJ

Autor: Eurai Criado: 01/03/2025 Atualizado: 01/03/2025 Protheus
Postagem

Salve salve, blz?

 

 

Tabela SPJ. #SPJ

 

 

 

 

SX2 - TABELA

X2_CHAVE X2_PATH X2_ARQUIVO X2_NOME X2_NOMESPA X2_NOMEENG X2_ROTINA X2_MODO X2_MODOUN X2_MODOEMP X2_DELET X2_TTS X2_UNICO X2_PYME X2_MODULO X2_DISPLAY X2_SYSOBJ X2_USROBJ X2_POSLGT X2_CLOB X2_AUTREC X2_TAMFIL X2_TAMUN X2_TAMEMP X2_STAMP X2_INSDT
SPJ DATA SPJ990 Horário Padrão Horario Estandar Standard Time E E E 0 PJ_FILIAL+PJ_TURNO+PJ_SEMANA+PJ_DIA S 16 PONA080 1 2 2 2 0 0

 

 

 

 

SX3 - CAMPOS

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_DESCRIC X3_PICTURE X3_VALID X3_RELACAO X3_F3 X3_NIVEL X3_TRIGGER X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_CBOX X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER
SPJ 01 PJ_FILIAL C 2 0 Filial Filial 1 033
SPJ 02 PJ_TURNO C 3 0 Turno Codigo do Turno @! 1
SPJ 16 PJ_CODREF C 2 0 Cod.Refeicao Codigo da Refeicao 99 Vazio() .or. ExistCpo("SP1") SP1 1 S
SPJ 17 PJ_TPEXT C 1 0 Tp.He Normal Tipo de Hora Extra Normal @! '1' 1 S #PonRetOpcBox(03)
SPJ 18 PJ_TPEXTN C 1 0 Tp.He Not. Tipo de Hora Ext Noturna @! '5' 1 S #PonRetOpcBox(03)
SPJ 19 PJ_NONAHOR C 1 0 Nona Hora Apura Nona Hora @! Pertence("SN") 'N' 1 S #PonRetOpcBox(05)
SPJ 36 PJ_RHEXP C 6 0 Contr.Exp.Rh Controle de Exportação RH 1
SPJ 03 PJ_SEMANA C 2 0 Sequencia Sequencia de Turno 99 1 0
SPJ 04 PJ_DIA C 1 0 Dia Semana Dia da Semana @! 1 0
SPJ 05 PJ_TPDIA C 1 0 Tipo Dia Tipo do Dia @! NaoVazio() 1 S S #PonRetOpcBox(01) 0
SPJ 07 PJ_ENTRA1 N 5 2 1a Entrada Horario da 1a Entrada @E 99.99 VldHora(M->PJ_ENTRA1) 1 S S 1
SPJ 08 PJ_SAIDA1 N 5 2 1a Saida Horario da 1a Saida @E 99.99 VldHora(M->PJ_SAIDA1) 1 S S 1
SPJ 09 PJ_ENTRA2 N 5 2 2a Entrada Horario da 2a Entrada @E 99.99 VldHora(M->PJ_ENTRA2) 1 S S 1
SPJ 10 PJ_SAIDA2 N 5 2 2a Saida Horario da 2a Saida @E 99.99 VldHora(M->PJ_SAIDA2) 1 S S 1
SPJ 11 PJ_ENTRA3 N 5 2 3a Entrada Horario da 3a Entrada @E 99.99 VldHora(M->PJ_ENTRA3) 1 S S 1
SPJ 12 PJ_SAIDA3 N 5 2 3a Saida Horario da 3a Saida @E 99.99 VldHora(M->PJ_SAIDA3) 1 S S 1
SPJ 13 PJ_ENTRA4 N 5 2 4a Entrada Horario da 4a Entrada @E 99.99 VldHora(M->PJ_ENTRA4) 1 S S 1
SPJ 14 PJ_SAIDA4 N 5 2 4a Saida Horario da 4a Saida @E 99.99 VldHora(M->PJ_SAIDA4) 1 S S 1
SPJ 35 PJ_INTSREP C 2 0 Interv.SREP Intervalo para ACJEF Vazio() .Or. Pertence(PonRetOpcBox(07)) 1 S A R #PonRetOpcBox(07) 1
SPJ 06 PJ_HORMENO N 5 2 Limite Infer Limite Minimo da Tabela @E 99.99 VldHora(M->PJ_HORMENO) .and. NaoVazio() IF(Empty(SR6->R6_HORMENO),Val(GetMv("MV_HORMENO",,"0")),SR6->R6_HORMENO) 1 S 2
SPJ 15 PJ_HORMAIS N 5 2 Limite Super Limite Maximo da Tabela @E 99.99 VldHora(M->PJ_HORMAIS) .and. NaoVazio() IF(Empty(SR6->R6_HORMAIS),Val(GetMv("MV_HORMAIS",,"0")),SR6->R6_HORMAIS) 1 S 2
SPJ 20 PJ_INTERV1 C 1 0 1a.S.Interv 1a Saida e Intervalo @! Pertence("SN") 'N' 1 S S #PonRetOpcBox(05) 3
SPJ 21 PJ_INTERV2 C 1 0 2a.S.Interv. 2a Saida e Intervalo @! Pertence("SN") 'N' 1 S S #PonRetOpcBox(05) 3
SPJ 22 PJ_INTERV3 C 1 0 3a.S.Interv. 3a Saida e Intervalo @! Pertence("SN") 'N' 1 S S #PonRetOpcBox(05) 3
SPJ 23 PJ_JND1CON C 1 0 1a.Jor.Cont. 1a Jornada Continua? @! Pertence("SN") 'N' 1 S S #PonRetOpcBox(05) 4
SPJ 24 PJ_JND2CON C 1 0 2a.Jor.Cont. 2a Jornada Continua? @! Pertence("SN") 'N' 1 S S #PonRetOpcBox(05) 4
SPJ 25 PJ_JND3CON C 1 0 3a.Jor.Cont. 3a Jornada Continua? @! Pertence("SN") 'N' 1 S S #PonRetOpcBox(05) 4
SPJ 26 PJ_JND4CON C 1 0 4a.Jor.Cont. 4a Jornada Continua? @! Pertence("SN") 'N' 1 S S #PonRetOpcBox(05) 4
SPJ 27 PJ_HRSINT1 N 5 2 Hrs 1o.Int. Horas 1o. Intervalo @E 99.99 POSITIVO() 1 S V 5
SPJ 28 PJ_HRSINT2 N 5 2 Hrs 2o.Int. Horas 2o. Intervalo @E 99.99 POSITIVO() 1 S V 5
SPJ 29 PJ_HRSINT3 N 5 2 Hrs 3o.Int. Horas 3o. Intervalo @E 99.99 POSITIVO() 1 S V 5
SPJ 30 PJ_HRSTRAB N 5 2 Hrs.Trb.1a.J Hrs. Trb. 1a. Jornada @E 99.99 POSITIVO() 1 S V 5
SPJ 31 PJ_HRSTRA2 N 5 2 Hrs.Trb.2a.J Hrs. Trb. 2a. Jornada @E 99.99 POSITIVO() 1 S V 5
SPJ 32 PJ_HRSTRA3 N 5 2 Hrs.Trb.3a.J Hrs. Trb. 3a. Jornada @E 99.99 POSITIVO() 1 S V 5
SPJ 33 PJ_HRSTRA4 N 5 2 Hrs.Trb.4a.J Hrs. Trb. 4a. Jornada @E 99.99 POSITIVO() 1 S V 5
SPJ 34 PJ_HRTOTAL N 6 2 Horas Total Total de Horas @E 999.99 POSITIVO() 1 S V 5

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
SPJ 1 PJ_FILIAL+PJ_TURNO+PJ_SEMANA+PJ_DIA Turno + Sequencia + Dia Semana Turno + Secuencia + Dia Semana Shift + Sequence + Week Days S S 2 3

 

 

 

 

SX7 - GATILHOS

X7_CAMPO X7_SEQUENC X7_REGRA X7_CDOMIN X7_TIPO X7_SEEK X7_ALIAS X7_ORDEM X7_CHAVE X7_CONDIC X7_PROPRI
PJ_ENTRA1 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_ENTRA1 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_ENTRA1 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_ENTRA1 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_ENTRA1 005 M->PJ_HRTOTAL := fHrsTrabGat("T") PJ_HRTOTAL P N 0 S
PJ_ENTRA2 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_ENTRA2 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_ENTRA2 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_ENTRA2 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_ENTRA2 005 M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1") PJ_HRSINT1 P N 0 S
PJ_ENTRA2 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_ENTRA3 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_ENTRA3 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_ENTRA3 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_ENTRA3 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_ENTRA3 005 M->PJ_HRSINT2 := fHrsTrabGaT("I",,,"2") PJ_HRSINT2 P N 0 S
PJ_ENTRA3 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_ENTRA4 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_ENTRA4 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_ENTRA4 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_ENTRA4 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_ENTRA4 005 M->PJ_HRSINT3 := fHrsTrabGaT("I",,,"3") PJ_HRSINT3 P N 0 S
PJ_ENTRA4 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_INTERV1 001 M->PJ_HRSINT1 := fHrsTrabGat('I',,,"1") PJ_HRSINT1 P N 0 S
PJ_INTERV1 002 M->PJ_HRTOTAL := fHrsTrabGat("T") PJ_HRTOTAL P N 0 S
PJ_INTERV2 001 M->PJ_HRSINT2 := fHrsTrabGat('I',,,"2") PJ_HRSINT2 P N 0 S
PJ_INTERV2 002 M->PJ_HRTOTAL := fHrsTrabGat("T") PJ_HRTOTAL P N 0 S
PJ_INTERV3 001 M->PJ_HRSINT3 := fHrsTrabGat('I',,,"3") PJ_HRSINT3 P N 0 S
PJ_INTERV3 002 M->PJ_HRTOTAL := fHrsTrabGat("T") PJ_HRTOTAL P N 0 S
PJ_JND1CON 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_JND1CON 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_JND1CON 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_JND1CON 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_JND1CON 005 M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1") PJ_HRSINT1 P N 0 S
PJ_JND1CON 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_JND2CON 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_JND2CON 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_JND2CON 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_JND2CON 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_JND2CON 005 M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1") PJ_HRSINT1 P N 0 S
PJ_JND2CON 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_JND3CON 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_JND3CON 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_JND3CON 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_JND3CON 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_JND3CON 005 M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1") PJ_HRSINT1 P N 0 S
PJ_JND3CON 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_JND4CON 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_JND4CON 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_JND4CON 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_JND4CON 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_JND4CON 005 M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1") PJ_HRSINT1 P N 0 S
PJ_JND4CON 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_SAIDA1 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_SAIDA1 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_SAIDA1 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_SAIDA1 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_SAIDA1 005 M->PJ_HRSINT1 := fHrsTrabGaT("I",,,"1") PJ_HRSINT1 P N 0 S
PJ_SAIDA1 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_SAIDA2 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_SAIDA2 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_SAIDA2 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_SAIDA2 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_SAIDA2 005 M->PJ_HRSINT2 := fHrsTrabGaT("I",,,"2") PJ_HRSINT2 P N 0 S
PJ_SAIDA2 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_SAIDA3 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_SAIDA3 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_SAIDA3 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_SAIDA3 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_SAIDA3 005 M->PJ_HRSINT3 := fHrsTrabGaT("I",,,"3") PJ_HRSINT3 P N 0 S
PJ_SAIDA3 006 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_SAIDA4 001 M->PJ_HRSTRAB := fHrsTrabGat("H",,,"1") PJ_HRSTRAB P N 0 S
PJ_SAIDA4 002 M->PJ_HRSTRA2 := fHrsTrabGat("H",,,"2") PJ_HRSTRA2 P N 0 S
PJ_SAIDA4 003 M->PJ_HRSTRA3 := fHrsTrabGat("H",,,"3") PJ_HRSTRA3 P N 0 S
PJ_SAIDA4 004 M->PJ_HRSTRA4 := fHrsTrabGat("H",,,"4") PJ_HRSTRA4 P N 0 S
PJ_SAIDA4 005 M->PJ_HRTOTAL := fHrsTrabGaT("T") PJ_HRTOTAL P N 0 S
PJ_TPDIA 001 IF(M->PJ_TPDIA=='D',M->PJ_TPEXT:="2",IF(M->PJ_TPDIA=="C",M->PJ_TPDIA:="3",M->PJ_TPDIA:="1")) PJ_TPEXT P N 0 S
PJ_TPDIA 002 IF(M->PJ_TPDIA=='D',M->PJ_TPEXTN:="6",IF(M->PJ_TPDIA=="C",M->PJ_TPEXTN:="7",M->PJ_TPEXTN:="5")) PJ_TPEXTN P N 0 S

 

 

 

 

SX9 - Relacionamento entre Tabelas

X9_DOM X9_IDENT X9_CDOM X9_EXPDOM X9_EXPCDOM X9_PROPRI X9_LIGDOM X9_LIGCDOM X9_CONDSQL X9_USEFIL X9_ENABLE X9_VINFIL X9_CHVFOR
SPJ 001 AA1 PJ_SEMANA AA1_SEQTUR S 1 N S S 2 2
SPJ 002 TFF PJ_SEMANA TFF_SEQTRN S 1 N S S 2 2
SPJ 003 SRA PJ_SEMANA RA_SEQTURN S 1 N S S 2 2
SPJ 004 SPF PJ_TURNO+PJ_SEMANA PF_TURNODE+PF_SEQUEDE S 1 N S S 2 2
SPJ 005 SPF PJ_TURNO+PJ_SEMANA PF_TURNOPA+PF_REGRAPA S 1 N S S 2 2
SPJ 006 TX8 PJ_SEMANA TX8_SEQTRN S 1 N S S 2 2

 

 

 

 

SXG - Grupo de Campos

XG_GRUPO XG_DESCRI XG_DESSPA XG_DESENG XG_SIZEMAX XG_SIZEMIN XG_SIZE XG_PICTURE
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2

 

 

 

 

 

 

 

 

 

 

Gostou? Compartilhe com seus amigos e deixe um comentário! ??

Um abraço, e até a próxima  

 

 

 

 

 

📰 Posts Relacionados

ASSINE A NEWSLETTER

Cadastrando...

PIX uDesenv

PIX QR Code para depósito

Clique para doar

Siga-nos

YouTube GitHub LinkedIn

Parceiros

Tudo em ADVPL - Blog parceiro

Blog ADVPL