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

Tabela 2410 EWH

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

Salve salve, blz?

 

 

Tabela EWH. #EWH

 

 

 

 

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
EWH DATA EWH990 Manutenção Armazenagem Detalhe Manten. Almacenam. Detalle Detail Storage Maintenance E E E 0 EWH_FILIAL+EWH_HAWB+EWH_CODPAR+EWH_LINHA N 17 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
EWH 01 EWH_FILIAL C 2 0 Filial Filial do Sistema 1 S A R 033
EWH 02 EWH_HAWB C 20 0 Processo Processo de Implantacao @! 1 S V R 148
EWH 03 EWH_CODPAR C 10 0 Cod Armazem Cod. Processo Armazenagem 1 S V R
EWH 04 EWH_LINHA C 3 0 Linha Linha Servico Prestado 1 S V R
EWH 05 EWH_CODSRV C 3 0 Servico Cod Servico EXISTCPO('EWD') EWD 1 S S A R
EWH 06 EWH_DESSRV C 50 0 Descricao Descricao Servico 1 S V V
EWH 07 EWH_CDTINI C 200 0 Cp.Dt.Ini. Cp.Dt.Ini. 1 S V R
EWH 08 EWH_CDTFIM C 200 0 Cp.Dt.Fim Cp.Dt.Fim 1 S V R
EWH 09 EWH_PERIOD N 3 0 Periodicidad Qnt dias ref. preco serv. @E 999 POSITIVO() .AND. M->EWH_PERIOD>0 1 S S A R
EWH 10 EWH_DT_INI D 8 0 Data Inicio Data Inicio Prest. Serv. 1 S S A R
EWH 11 EWH_PRVFIM D 8 0 Prev. Fim Prev. Fim 1 S S A R
EWH 12 EWH_DT_FIM D 8 0 Data Fim Data Term. prest. serv. 1 S S A R
EWH 13 EWH_DIAS N 3 0 Qtd. Dias Quantidade Dias @E 999 1 S S A R
EWH 14 EWH_QTDPER N 3 0 Qtd Periodos Qtd Periodos @E 999 1 S V R
EWH 15 EWH_CODPRC C 3 0 Un. Preco Un. Preco 1 S S A R
EWH 16 EWH_DESPRC C 50 0 Des.Un.Pr Desc. Unidade Preco 1 S V V
EWH 17 EWH_QTD N 14 5 Quantidade Quantidade Serv. Prestado @E 99,999,999.99999 Positivo() 1 S S A R
EWH 18 EWH_PRCUNI N 15 7 Preco s/ ISS Preco Unitario s/ ISS @E 9,999,999.9999999 Positivo() 1 S S A R
EWH 19 EWH_ALISS N 5 2 Aliq. ISS Aliq. ISS @E 99.99 Positivo() SUPERGETMV('MV_ALIQISS') 1 S S A R
EWH 20 EWH_PRCTOT N 15 5 Preco Serv. Preco Serv. @E 999,999,999.99999 POSITIVO() 1 S S A R
EWH 21 EWH_VL_PRV N 15 2 Vlr. Previst Vlr. Previsto @E 999,999,999,999.99 1 S S A R
EWH 22 EWH_VL_TOT N 15 2 Vlr. Total Vlr. Total @E 999,999,999,999.99 POSITIVO() 1 S S A R
EWH 23 EWH_OBS M 60 0 Observacao Observacao Gerais 1 S A R
EWH 24 EWH_CDTPRV C 200 0 Cp.Dt.Prev Cp.Dt.Prevista 1 S A R

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
EWH 1 EWH_FILIAL+EWH_HAWB+EWH_CODPAR+EWH_LINHA Processo + Cod Armazem + Linha Proceso + Cod Almacen + Linea Process + Warehouse Cd + Line 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
EWH_ALISS 001 AM103CalcGat('ALISS') EWH_PRCTOT P N 0 RETORNO('ALISS') S
EWH_ALISS 002 AM103CalcGat('PRC') EWH_VL_TOT P N 0 RETORNO('VLTOT') S
EWH_ALISS 003 IIF(AM103CALCGAT('VLPRV')<0,0,AM103CALCGAT('VLPRV')) EWH_VL_PRV P N 0 S
EWH_ALISS 004 GatVlGetDados('EWH_VL_PRV') EWG_VL_PRV P N 0 S
EWH_ALISS 005 GatVlGetDados('EWH_VL_TOT') EWG_VL_TOT P N 0 S
EWH_CODPRC 001 EW8->EW8_DESPRC EWH_DESPRC P S EW8 1 xFilial("EW8")+M->EWH_CODPRC S
EWH_CODSRV 001 EWD->EWD_DESSRV EWH_DESSRV P S EWD 1 XFILIAL("EWD")+M->EWH_CODSRV S
EWH_CODSRV 002 EWD->EWD_CDTINI EWH_CDTINI P S EWD 1 XFILIAL("EWD")+M->EWH_CODSRV S
EWH_CODSRV 003 EWD->EWD_CDTFIM EWH_CDTFIM P S EWD 1 XFILIAL("EWD")+M->EWH_CODSRV S
EWH_CODSRV 004 EWD->EWD_CODPRC EWH_CODPRC P S EWD 1 XFILIAL("EWD")+M->EWH_CODSRV S
EWH_CODSRV 005 U_AM103PRU() EWH_PRCUNI P n 0 S
EWH_CODSRV 006 iif(!Empty(EWD->EWD_CDTPRV),&(EWD->EWD_CDTPRV),ctod('//')) EWH_PRVFIM P n 0 S
EWH_CODSRV 007 IIF(AM103VADATE('DIAS')<1,1,AM103VADATE('DIAS')) EWH_DIAS P s 0 S
EWH_CODSRV 008 EWH->EWH_PRCUNI/(1-(EWH->EWH_ALISS)/100) EWH_PRCTOT P s 0 S
EWH_CODSRV 009 IIF(AM103CALCGAT('PER')<1,1,AM103CALCGAT('PER')) EWH_QTDPER P s 0 RETORNO('QTD') S
EWH_CODSRV 010 AM103VLRTOT() EWH_VL_TOT P s 0 RETORNO('VLTOT') S
EWH_CODSRV 011 IIF(AM103CALCGAT(VLPRV)<0,0,AM103CALCGAT(VLPRV)) EWH_VL_PRV P n 0 RETORNO('VLPRV') S
EWH_CODSRV 012 iif(!Empty(EWD->EWD_CDTINI),&(EWD->EWD_CDTINI),ctod('//')) EWH_DT_INI P n 0 S
EWH_CODSRV 013 iif(!Empty(EWD->EWD_CDTPRV),&(EWD->EWD_CDTPRV),ctod('//')) EWH_CDTPRV P n 0 S
EWH_CODSRV 014 iif(!Empty(EWD->EWD_CDTFIM),&(EWD->EWD_CDTFIM),ctod('//')) EWH_DT_FIM P n 0 S
EWH_CODSRV 015 iif(!Empty(EW8->EW8_FORMUL),&(EW8->EW8_FORMUL),0) EWH_QTD P n 0 S
EWH_DIAS 001 IIF(AM103CALCGAT('DIAS')<1,1,AM103CALCGAT('DIAS')) EWH_QTDPER P N 0 RETORNO('PER') S
EWH_DIAS 002 u_ValCols('EWH_PRCTOT')*u_ValCols('EWH_QTD')*u_ValCols('EWH_QTDPER') EWH_VL_TOT P N 0 RETORNO('VLTOT') S
EWH_DIAS 003 GatVlGetDados('EWH_VL_TOT') EWG_VL_TOT P N 0 RETORNO('VLTOT') S
EWH_DT_FIM 001 AM103CalcGat('PRC') EWH_VL_TOT P N 0 S
EWH_DT_FIM 002 GatVlGetDados('EWH_VL_TOT') EWG_VL_TOT P N 0 S
EWH_DT_INI 001 CalcDias('EWH_DT_INI') EWH_DIAS P N 0 S
EWH_DT_INI 002 AM103CalcGat('VLPRV') EWH_VL_PRV P N 0 S
EWH_DT_INI 003 GatVlGetDados('EWH_VL_PRV') EWG_VL_PRV P N 0 S
EWH_DT_INI 004 AM103CalcGat('PRC') EWH_VL_TOT P N 0 S
EWH_DT_INI 005 GatVlGetDados('EWH_VL_TOT') EWG_VL_TOT P N 0 S
EWH_PERIOD 001 IIF(AM103CALCGAT('PER')<1,1,AM103CALCGAT('PER')) EWH_QTDPER P N 0 RETORNO('QTDP') S
EWH_PERIOD 002 AM103Ret('PRC') EWH_VL_TOT P N 0 RETORNO('VLTOT') S
EWH_PERIOD 003 GatVlGetDados('EWH_VL_TOT') EWG_VL_TOT P N 0 S
EWH_PERIOD 004 AM103CalcGat('VLPRV') EWH_VL_PRV P N 0 S
EWH_PERIOD 005 GatVlGetDados('EWH_VL_PRV') EWG_VL_PRV P N 0 S
EWH_PRCTOT 001 AM103CalcGat('PRCT') EWH_PRCUNI P N 0 S
EWH_PRCTOT 002 AM103CalcGat('PRC') EWH_VL_TOT P N 0 RETORNO('VLTOT') S
EWH_PRCTOT 003 IIF(AM103CALCGAT('VLPRV')<0,0,AM103CALCGAT('VLPRV')) EWH_VL_PRV P N 0 AM103RET('VLPR') S
EWH_PRCTOT 004 GatVlGetDados('EWH_VL_TOT') EWG_VL_TOT P N 0 AM103Ret('VLPR') S
EWH_PRCTOT 005 GatVlGetDados('EWH_VL_PRV') EWG_VL_PRV P N 0 AM103Ret('VLPR') S
EWH_PRCUNI 001 AM103CalcGat('ALISS') EWH_PRCTOT P N 0 S
EWH_PRCUNI 002 AM103CalcGat('PRC') EWH_VL_TOT P N 0 RETORNO('VLTOT') S
EWH_PRCUNI 003 IIF(AM103CALCGAT('VLPRV')<0,0,AM103CALCGAT('VLPRV')) EWH_VL_PRV P N 0 AM103RET('VLPR') S
EWH_PRCUNI 004 GatVlGetDados('EWH_VL_PRV') EWG_VL_PRV P N 0 AM103Ret('VLPR') S
EWH_PRCUNI 005 GatVlGetDados('EWH_VL_TOT') EWG_VL_TOT P N 0 AM103Ret('VLPR') S
EWH_PRVFIM 001 AM103CalcGat('VLPRV') EWH_VL_PRV P N 0 S
EWH_PRVFIM 002 GatVlGetDados('EWH_VL_PRV') EWG_VL_PRV P N 0 S
EWH_QTD 001 IIF(AM103CALCGAT('QTD')<1,1,AM103CALCGAT('QTD')) EWH_VL_PRV P N 0 AM103RET('VLPR') S
EWH_QTD 002 IIF(AM103CALCGAT('QTD1')<1,1,AM103CALCGAT('QTD1')) EWH_VL_TOT P N 0 RETORNO('VLTOT') S
EWH_QTD 003 GatVlGetDados('EWH_VL_TOT') EWG_VL_TOT P N 0 RETORNO('VLTOT') S
EWH_QTD 004 GatVlGetDados('EWH_VL_PRV') EWG_VL_PRV P N 0 RETORNO('VLTOT') S
EWH_VL_PRV 001 GatVlGetDados('EWH_VL_PRV') EWG_VL_PRV P N 0 S
EWH_VL_TOT 001 GatVlGetDados('EWH_VL_TOT') EWG_VL_TOT P N 0 S

 

 

 

 

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
148 Imp.Purchase/Hawb/Invoice/Prof Imp.Purchase/Hawb/Invoice/Prof Imp.Purchase/Hawb/Invoice/Prof 30 15 20 @!

 

 

 

 

 

 

 

 

 

 

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