Dicionário Protheus
Início
O Poder da Hiperautomação

Tabela EG0 no Protheus

Demurrage

O que é a tabela EG0 no Protheus?

A tabela EG0 faz parte do sistema ERP Protheus da TOTVS e é utilizada para demurrage.

Ela pertence ao dicionário de dados do Protheus (SX2) e armazena informações essenciais utilizadas em processos como cadastros, movimentações e integrações do sistema.

A tabela EG0 possui diversos campos (SX3), cada um com regras específicas como tipo, tamanho e validações, além de índices (SIX) que otimizam a performance das consultas.

Nesta página você pode consultar a estrutura completa da tabela EG0, incluindo todos os campos e índices relacionados.

Propriedades da Tabela

Propriedade Valor
X2_CHAVE EG0
X2_PATH \DATA\
X2_ARQUIVO EG0990
X2_NOME Demurrage
X2_NOMESPA Demurrage
X2_NOMEENG Demurrage
X2_ROTINA -
X2_MODO E
X2_MODOUN E
X2_MODOEMP E
X2_DELET 0
X2_TTS -
X2_UNICO -
X2_PYME N
X2_MODULO 17
X2_DISPLAY EG0_DEMURR+EG0_NAVIO+EG0_VIAGEM+EG0_DEST
X2_SYSOBJ AVGDM400
X2_USROBJ -
X2_POSLGT 1
X2_CLOB 2
X2_AUTREC 2
X2_TAMFIL 2
X2_TAMUN 0
X2_TAMEMP 0
X2_STAMP 2
X2_INSDT 2
D_E_L_E_T_ -
R_E_C_N_O_ 3781
R_E_C_D_E_L_ 0

Campos da Tabela EG0 (73 campos)

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_TITSPA X3_TITENG X3_DESCRIC X3_DESCSPA X3_DESCENG X3_PICTURE X3_VALID X3_USADO X3_RELACAO X3_F3 X3_NIVEL X3_RESERV X3_CHECK X3_TRIGGER X3_PROPRI X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_VLDUSER X3_CBOX X3_CBOXSPA X3_CBOXENG X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER X3_PYME X3_CONDSQL X3_CHKSQL X3_IDXSRV X3_ORTOGRA X3_IDXFLD X3_TELA X3_PICBRV X3_AGRUP X3_POSLGT X3_MODAL X3_CHKSUM X3_ADDSUM D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
EG0 01 EG0_FILIAL C 2 0 Filial Sucursal Branch Filial Sucursal Branch - - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - 033 - N - - N N N - - - 1 2 - - - 60375 0
EG0 02 EG0_MODULO C 1 0 Modulo Modulo Module Modulo Modulo Module - - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 60376 0
EG0 03 EG0_DEMURR C 15 0 Demurrage Demurrage Demurrage Codigo do demurrage Codigo de demurrage Demurrage Code @! ExistChav("EG0",IF(nModulo==17,"I",IF(nModulo==29,"E"," "))+M->EG0_DEMURR) x x x x x x x x x x x x x x x xx - - 1 x x - - - S - - - - - - - - Inclui - - 1 N - - S N N - - - 1 1 - - - 60377 0
EG0 04 EG0_REVER C 1 0 Reversivel Reversible Reversible Reversivel Reversible Reversible - RM400VAL("EG0_REVER") x x x x x x x x x x x x x x x xx "2" - 1 x xxxxxx - - - S - - - - 1=Sim;2=Näo 1=Si;2=No 1=Yes;2=No - Inclui - - 1 N - - N N N - - - 1 1 - - - 60378 0
EG0 05 EG0_NAVIO C 25 0 Vessel Code Vessel Code Vessel Code Vessel Code Vessel Code Vessel Code @! RM400VAL("EG0_NAVIO") x x x x x x x x x x x x x x x xx - E6_ 1 x x - - - S - - - - - - - - Inclui - - 1 N - - S N N - - - 1 1 - - - 60379 0
EG0 06 EG0_VIAGEM C 20 0 Trip Trip Trip Trip Trip Trip @! RM400VAL("EG0_VIAGEM") x x x x x x x x x x x x x x x xx - - 1 x x - - - S - - - - - - - - Inclui - - 1 N - - S N N - - - 1 1 - - - 60380 0
EG0 07 EG0_DEST C 3 0 Disch. Port Disch.Port. Disch.Port. Disch. Port Disch.Port. Disch.Port. @! RM400VAL("EG0_DEST") x x x x x x xxxx x x xx x x x x x x x x - YR1 1 x - - - S - - - - - - - - Inclui .and. M->EG0_REVER = '2' - - 1 N - - S N N - - - 1 2 - - - 60381 0
EG0 08 EG0_VM_DES C 25 0 Disch. Port. Disch.Port. Disch.Port. Disch. Port. Disch.Port. Disch.Port. @! - x x x x x x xxxx x x xx x x x x x x x E_FIELD("EG0_DEST","Y9_DESCR",,,2) - 1 x xxxx x - - - N V V - - - - - - - - - 1 N - - N N N - - - 1 2 - - - 60382 0
EG0 09 EG0_TIPO C 1 0 Type Type Type Type Type Type @! - x x x x x x x x x x x x x x x x "2" - 1 x xxxxxx - - - S - - - - 1=Solid;2=Liquid 1=Solid;2=Liquid 1=Solid;2=Liquid - Inclui - - 1 N - - N N N - - - 1 1 - - - 60383 0
EG0 10 EG0_DT_BOK D 8 0 C/P Dated Of C/P Dated Of B/N Dated Of C/P Dated Of C/P Dated Of B/N Dated Of @D RM400Val("EG0_DT_BOK") x x x x x x x x x x x x x x x x dDataBase - 1 x xxxxxx - - - S - - - - - - - - Inclui - - 1 N - - N N N - - - 1 1 - - - 60384 0
EG0 11 EG0_FORNEC C 6 0 Owners/Selle Owners/Selle Owners/Selle Owners/Sellers Owners/Sellers Owners/Sellers @! RM400VAL("EG0_FORNEC") x x x x x x x x x x x x x x x xx - SA2 1 x x - - - S - - - - - - - - Inclui - 001 1 N - - S N N - - - 1 1 - - - 60385 0
EG0 12 EG0_FORLOJ C 2 0 Unit Unit Unit Unit Unit Unit @! - x x x x x xxxx x x xx x x x x x x x - - 1 x x - - - S - - - - - - - - - - 002 1 N - - S N N - - - 1 2 - - - 60386 0
EG0 13 EG0_VM_FOR C 20 0 Owners/Selle Owners/Selle Owners/Selle Owners/Sellers Owners/Sellers Owners/Sellers @! - x x x x x x xxxx x x xx x x x x x x x E_FIELD("EG0_FORNEC","A2_NREDUZ") - 1 x xxxx x - - - N V V - - - - - - - - - 1 N - - N N N - - - 1 2 - - - 60387 0
EG0 14 EG0_ROADS D 8 0 Vsl Arvd Rds Vsl Arvd Rds Vsl Arvd Rds Vsl Arvd Rds Vsl Arvd Rds Vsl Arvd Rds @D RM400VAL("EG0_ROADS") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60388 0
EG0 15 EG0_ROADSW C 15 0 Week Roads Week Roads Day Arvd Rds Week Roads Week Roads Day Arvd Rds @! - x x x x x x xxxx x x xx x x x x x x x CDOW(M->EG0_ROADS) - 1 x xxxx x - - - N V V - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60389 0
EG0 16 EG0_ROADST C 5 0 Time Roads Time Roads Time Arvd Rd Time Roads Time Roads Time Arvd Rds 99:99 RM400VAL("EG0_ROADST") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60390 0
EG0 17 EG0_BERT D 8 0 Vsl Berthed Vsl Berthed Vsl Berthed Vsl Berthed Vsl Berthed Vsl Berthed @D RM400VAL("EG0_BERT") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - N - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60391 0
EG0 18 EG0_BERTW C 15 0 Week Berthed Week Berthed Day Berthed Week Berthed Week Berthed Day Berthed @! - x x x x x x xxxx x x xx x x x x x x x CDOW(M->EG0_BERT) - 1 x xxxx x - - - N V V - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60392 0
EG0 19 EG0_BERTT C 5 0 Time Berthed Time Berthed Time Berthed Time Berthed Time Berthed Time Berthed 99:99 RM400VAL("EG0_BERTT") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60393 0
EG0 20 EG0_TEND D 8 0 NOR Tendered NOR Tendered NOR Tendred NOR Tendered NOR Tendere NOR Tendred @D RM400VAL("EG0_TEND") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60394 0
EG0 21 EG0_TENDW C 15 0 Week Tendere Week Tendere Day Tendere Week Tendere Week Tendere Day Tendere @! - x x x x x x xxxx x x xx x x x x x x x CdoW(M->EG0_TEND) - 1 x xxxx x - - - N V V - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60395 0
EG0 22 EG0_TENDT C 5 0 Time Tendere Time Tendere Time Tendere Time Tendered Time Tendered Time Tendered 99:99 RM400VAL("EG0_TENDT") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60396 0
EG0 23 EG0_ACCEP D 8 0 NOR Accepted NOR Accepted NOR Accepted NOR Accepted NOR Accepted NOR Accepted @D RM400VAL("EG0_ACCEP") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60397 0
EG0 24 EG0_ACCEPW C 15 0 Week Accepte Week Accepte Day Accepted Week Accepted Week Accepted Day Accepted @! - x x x x x x xxxx x x xx x x x x x x x CDOW(M->EG0_ACCEP) - 1 x xxxx x - - - N V V - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60398 0
EG0 25 EG0_ACCEPT C 5 0 Time Accepte Time Accepte Time Accepte Time Accepted Time Accepted Time Accepted 99:99 RM400VAL("EG0_ACCEPT") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60399 0
EG0 26 EG0_FROM D 8 0 Time Cnt Fro Time Cnt Fro Date Cnt Frm Time Cnt Fro Time Cnt Fro Date Cnt Frm @D RM400VAL("EG0_FROM") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60400 0
EG0 27 EG0_FROMW C 15 0 Week Time Week Time Day Cnt From Week Time Week Time Day Cnt From @! - x x x x x x xxxx x x xx x x x x x x x CDOW(M->EG0_FROM) - 1 x xxxx x - - - N V V - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60401 0
EG0 28 EG0_FROMT C 5 0 Time From Time From Time From Time From Time From Time From 99:99 RM400VAL("EG0_FROMT") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60402 0
EG0 29 EG0_COMM D 8 0 Ld.Dis.Comme Ld.Dis.Comme Disch. Comme Ld.Dis.Commenced Ld.Dis.Commenced Disch. Comme @D RM400VAL("EG0_COMM") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60403 0
EG0 30 EG0_COMMW C 15 0 Week Commenc Day Commenc Day Commenc Week Commenced Week Commenced Day Commenc @! - x x x x x x xxxx x x xx x x x x x x x CDOW(M->EG0_COMM) - 1 x xxxx x - - - N V V - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60404 0
EG0 31 EG0_COMMT C 5 0 Time Commenc Time Commenc Time Commenc Time Commenced Time Commenced Time Commenced 99:99 RM400VAL("EG0_COMMT") x x x x x x xxxx x x x x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60405 0
EG0 32 EG0_COMP D 8 0 Disch. Compl Disch. Compl Disch.Compl Disch. Completed Disch. Completed Disch. Completed @D RM400VAL("EG0_COMP") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60406 0
EG0 33 EG0_COMPW C 15 0 Week Complet Week Complet Week Complet Week Completed Week Completed Week Completed @! - x x x x x x xxxx x x xx x x x x x x x CdoW(M->EG0_COMP) - 1 x xxxx x - - - N V V - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60407 0
EG0 34 EG0_COMPT C 5 0 Time Complet Time Complet Time Complet Time Completed Time Completed Time Completed 99:99 RM400VAL("EG0_COMPT") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60408 0
EG0 35 EG0_CARGO N 14 5 Cgo. Qtty Cgo. Qtty Cargo Qtty Cgo. Qtty Cgo. Qtty Cargo Quantity @E 99,999,999.99999 RM400VAL("EG0_CARGO") x x x x x x x x x x x x x x x x - - 1 x xxxxxx - - - S - - - - - - - - - - - 3 N - - N N N - - - 1 1 - - - 60409 0
EG0 36 EG0_PARC_C N 14 5 Parcel Cargo Parcel Cargo Parcel Cargo Parcel Cargo Quantity Parcel Cargo Quantity Parcel Cargo Quantity @E 99,999,999.99999 - x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - .F. - - 3 N - - N N N - - - 1 2 - - - 60410 0
EG0 37 EG0_RAT_LD N 16 5 Rate L/D Rate L/D Rate L/D Rate L/D Rate L/D Rate L/D @E 9,999,999,999.99999 RM400VAL("EG0_RAT_LD") x x x x x x x x x x x x x x x x - - 1 x xxxxxx - - - S - - - - - - - - - - - 3 N - - N N N - - - 1 1 - - - 60411 0
EG0 38 EG0_RAT_HD C 1 0 Rate L/D D/H Rate L/D D/H Rate L/D D/H Rate L/D D/H Rate L/D D/H Rate L/D D/H - RM400VAL("EG0_RAT_HD") x x x x x x x x x x x x x x x x "1" - 1 x xxxxxx - - - S - - - - 1=Day;2=Hour 1=Day;2=Hour 1=Day;2=Hour - - - - 3 N - - N N N - - - 1 1 - - - 60412 0
EG0 39 EG0_MOEDA C 3 0 Money Money Money Money Money Money - RM400VAL("EG0_MOEDA") x x x x x x x x x x x x x x x xx "US$" SYF 1 x x - - - S - - - - - - - - Inclui - - 3 N - - N N N - - - 1 1 - - - 60413 0
EG0 40 EG0_DEM_V N 16 2 Dem Rate Val Dem Rate Val Dem Rate Val Dem Rate Value Dem Rate Value Dem Rate Value @E 9,999,999,999,999.99 RM400VAL("EG0_DEM_V") x x x x x x x x x x x x x x x x - - 1 x xxxxxx - - - S - - - - - - - - - - - 3 N - - N N N - - - 1 1 - - - 60414 0
EG0 41 EG0_DEM_TP C 1 0 Dem Rate At Dem Rate At Dem Rate At Demurrage Rate At Demurrage Rate At Demurrage Rate At - RM400VAL("EG0_DEM_TP") x x x x x x x x x x x x x x x x "1" - 1 x xxxxxx - - - S - - - - 1=Day;2=Hour 1=Day;2=Hour 1=Day;2=Hour - - - - 3 N - - N N N - - - 1 1 - - - 60415 0
EG0 42 EG0_DES_V N 16 2 Des Rate Val Des Rate Val Des Rate Val Despatch Rate At Despatch Rate At Despatch Rate At @E 9,999,999,999,999.99 RM400VAL("EG0_DES_V") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 3 N - - N N N - - - 1 2 - - - 60416 0
EG0 43 EG0_DES_TP C 1 0 Des Rate At Des Rate At Des Rate At Despatch Rate At Despatch Rate At Despatch Rate At - RM400VAL("EG0_DES_TP") x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - 1=Day;2=Hour 1=Day;2=Hour 1=Day;2=Hour - - - - 3 N - - N N N - - - 1 2 - - - 60417 0
EG0 44 EG0_COND C 50 0 Condition Condition Condition Condition Condition Condition - - x x x x x x xxxx x x xx x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - 3 N - - N N N - - - 1 2 - - - 60418 0
EG0 45 EG0_USED C 8 0 Time Used Time Used Time Used Time Used Time Used Time Used - - x x x x x x x x x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - .F. - - 3 N - - N N N - - - 1 2 - - - 60419 0
EG0 46 EG0_CLASSI C 1 0 Classificati Classificati Classific. Classification Classification Classification - - x x x x x x x x x x x x x x x "2" - 1 x xxxx x - - - N A R - - 1=Demurrage;2=Despatch;3=No Demurrage No Despatch 1=Demurrage;2=Despatch;3=No Demurrage No Despatch 1=Demurrage;2=Despatch;3=No Demurrage No Despatch - .F. - - 3 N - - N N N - - - 1 2 - - - 60420 0
EG0 47 EG0_TEMPO N 16 8 Time Calc Time Calc Time calc Tempo Calculated Time calculated Time calculated @E 9,999,999.99999999 - x x x x x x x x x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - .F. - - 3 N - - N N N - - - 1 2 - - - 60421 0
EG0 48 EG0_OBS C 6 0 Remarks Remarks Remarks Remarks Remarks Remarks - - x x x x x x x x x x x x x x x - - 1 x xxxx x - - - N - - - - - - - - - - - 4 N - - N N N - - - 1 2 - - - 60422 0
EG0 49 EG0_VM_OBS M 60 0 Observation Observation Observation Observation Observation Observation - - x x x x x x xxxx x x xx x x x x x x x MSMM(M->EG0_OBS,60) - 1 x xxxx x - - - N - V - - - - - - - - - 4 N - - N N N - - - 1 2 - - - 60423 0
EG0 50 EG0_OW_TP C 1 0 Owners Type Owners Type Owners Type Owners Type Owners Type Owners Type - - x x x x x x x x x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 60424 0
EG0 51 EG0_OW_VL N 16 2 Owners Value Owners Value Owners Valor Owners Value Owners Value Owners Valor @E 9,999,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 60425 0
EG0 52 EG0_VALPRO N 16 2 Vlr do Proc. Vlr de Proc. Val of case Valor do Processo Valor de Proceso Value of Case @E 9,999,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 60426 0
EG0 53 EG0_SITUA C 50 0 Situation Situation Situation Situation Situation Situation @! - x x x x x x x x x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 60427 0
EG0 54 EG0_PGT D 8 0 Dt.Payment Dt.Payment Dt.Payment Dt.Payment Dt.Payment Payment date @D - x x x x x x x x x x x x x x x - - 1 x xxxx x - - - S - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 60428 0
EG0 55 EG0_BANCO C 6 0 Dados Banc. Datos Banc. Bank info Dados Banc. Datos Banc. Bank information - - x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 60429 0
EG0 56 EG0_FRETE C 1 0 Charterer Charterer Charterer Charterer Charterer Charterer - RM400VAL("EG0_FRETE") x x x x x x x x x x x x x x x x "1" - 1 x xx - - - S A R - - 1=Sim ; 2=Näo 1=Si ; 2=No 1=Yes;2=No - Inclui - - 1 N - - N N N - - - 1 1 - - - 60430 0
EG0 57 EG0_CHART C 20 0 Charter Part Charter Part Charter Part Charter Part Charter Part Charter Part @! - x x x x x xxxx x x xx x x x x x x x - - 1 x x - - - N A R - - - - - - - - - 1 N - - N N N - - - 1 2 - - - 60431 0
EG0 58 EG0_CLIENT C 6 0 Buyers Buyers Buyers Buyers Buyers Buyers @! RM400VAL("EG0_CLIENT") x x x x x xxxx x x xx x x x x x x x - SA1 1 x x - - - N A R - - - - - - Inclui - 001 1 N - - N N N - - - 1 2 - - - 60432 0
EG0 59 EG0_CLILOJ C 2 0 Unit Unit Unit Unit Unit Unit @! - x x x x x xxxx x x xx x x x x x x x - - 1 x x - - - S A R - - - - - - Inclui - 002 1 N - - N N N - - - 1 2 - - - 60433 0
EG0 60 EG0_VM_CLI C 20 0 Buyers Buyers Buyers Buyers Buyers Buyers @! E_FIELD("EG0_CLIENT","A1_NREDUZ") x x x x x xxxx x x xx x x x x x x x - - 1 x x - - - N V V - - - - - - Inclui - - 1 S - - N N N - - - 1 2 - - - 60434 0
EG0 61 EG0_CODAGE C 6 0 Inspector Inspector Inspector Inspector Inspector Inspector @! - x x x x x xxxx x x xx x x x x x x x - SY5A 1 x - - - N A R - - - - - - - - 001 1 N - - N N N - - - 1 2 - - - 60435 0
EG0 62 EG0_CODTER C 6 0 Terminal Terminal Terminal Terminal Terminal Terminal @! - x x x x x xxxx x x xx x x x x x x x - Y5A 1 x - - - N A R - - - - - - - - 001 1 N - - N N N - - - 1 2 - - - 60436 0
EG0 63 EG0_NEG_TP C 1 0 Neg. Type Neg. Type Neg. Type Neg. Type Neg. Type Neg. Type - - x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 60437 0
EG0 64 EG0_NEG_VL N 16 2 Rev. Figures Rev. Figures Rev. Figures Rev. Figures Rev. Figures Rev. Figures @E 9,999,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 60438 0
EG0 65 EG0_NOR C 8 0 Time NOR Time NOR Time NOR Time NOR Time NOR Time NOR 99:99:99 RM400VAL("EG0_NOR") x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 60439 0
EG0 66 EG0_TCFDT D 8 0 Dt Cnt Finsh Dt Cnt Finsh Dt Cnt Finsh Date Count Finished Date Count Finished Date Count Finished @d RM400VAL("EG0_TCFDT") x x x x x xxxx x x xx x x x x x x x - - 1 x - - - S A R - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60440 0
EG0 67 EG0_TCFTM C 5 0 Tm Cnt Finsh Tm Cnt Finsh Tm Cnt Finsh Time Count Finished Time Count Finished Time Count Finished 99:99 RM400VAL("EG0_TCFTM") x x x x x xxxx x x xx x x x x x x x - - 1 x - - - S A R - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60441 0
EG0 68 EG0_TDISCH N 16 8 Time Disch Time Disch Time Disch Time Discharged Time Discharged Time Discharged @E 9,999,999.99999999 - x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - .F. - - - N - - N N N - - - 1 2 - - - 60442 0
EG0 69 EG0_TCFWK C 15 0 Wk Cnt Finsh Wk Cnt Finsh Wk Cnt Finsh Wk Cnt Finsh Wk Cnt Finsh Wk Cnt Finsh @! CdoW(M->EG0_COMM) x x x x x xxxx x x xx x x x x x x x CDOW(M->EG0_TCFDT) - 1 x - - - N V V - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60443 0
EG0 70 EG0_TLOAD N 16 8 Time Load Time Load Time Load Time Loaded Time Loaded Time Loaded @E 9,999,999.99999999 - x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - .F. - - - N - - N N N - - - 1 2 - - - 60444 0
EG0 71 EG0_DT_CP D 8 0 Dt. Ch. Par. Fc. Ch. Par. Dt. Ch. Par. Dt. Ch. Par. Fc. Ch. Par. Dt. Ch. Par. @d - x x x x x xxxx x x xx x x x x x x x - - 1 x - - - S A R - - - - - - - - - 2 N - - N N N - - - 1 2 - - - 60445 0
EG0 72 EG0_VCT D 8 0 Closing Date Closing Date Closing Date Closing Date Closing Date Closing Date @d - x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 60446 0
EG0 73 EG0_VM_BCO M 60 0 Banking data Banking data Banking data Banking data Banking data Bank info - - x x x x x xxxx x x xx x x x x x x x MSMM(M->EG0_BANCO,60) - 1 x - - - N A V - - - - - - - - - 4 N - - N N N - - - 1 2 - - - 60447 0

Índices da Tabela EG0 (2 índices)

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
EG0 1 EG0_FILIAL+EG0_MODULO+EG0_DEMURR+EG0_NAVIO+EG0_VIAGEM+EG0_DEST Modulo + Demurrage + Vessel Code + Trip + Disch. Port Modulo + Demurrage + Vessel Code + Trip + Disch.Port. Module + Demurrage + Vessel Code + Trip + Disch.Port. S - - S 2 3 - 9116 0
EG0 2 EG0_FILIAL+EG0_MODULO+EG0_DEMURR+EG0_FORNEC+EG0_NAVIO+EG0_VIAGEM+EG0_DEST Modulo + Demurrage + Owners/Selle + Vessel Code + Trip + Disch. Port Modulo + Demurrage + Owners/Selle + Vessel Code + Trip + Disch.Port. Module + Demurrage + Owners/Selle + Vessel Code + Trip + Disch.Port. S - - S 2 3 - 9117 0

Perguntas frequentes

Para que serve a tabela EG0 no Protheus?

Ela é utilizada para demurrage dentro do sistema ERP Protheus.

Como consultar os campos da tabela EG0?

Nesta página você pode visualizar todos os campos, incluindo tipo, tamanho e validações.

O que são os índices da tabela EG0?

Os índices são estruturas que melhoram a performance de busca e acesso aos dados dentro do Protheus.

Exemplo de consulta SQL da tabela EG0

Modelo de query gerado automaticamente com base na estrutura da tabela. 

SELECT
    EG0_FILIAL,
    EG0_MODULO,
    EG0_DEMURR,
    EG0_REVER,
    EG0_NAVIO,
    EG0_VIAGEM,
    EG0_DEST,
    EG0_VM_DES,
    EG0_TIPO,
    EG0_DT_BOK,
    EG0_FORNEC,
    EG0_FORLOJ,
    EG0_VM_FOR,
    EG0_ROADS,
    EG0_ROADSW,
    EG0_ROADST,
    EG0_BERT,
    EG0_BERTW,
    EG0_BERTT,
    EG0_TEND,
    EG0_TENDW,
    EG0_TENDT,
    EG0_ACCEP,
    EG0_ACCEPW,
    EG0_ACCEPT,
    EG0_FROM,
    EG0_FROMW,
    EG0_FROMT,
    EG0_COMM,
    EG0_COMMW,
    EG0_COMMT,
    EG0_COMP,
    EG0_COMPW,
    EG0_COMPT,
    EG0_CARGO,
    EG0_PARC_C,
    EG0_RAT_LD,
    EG0_RAT_HD,
    EG0_MOEDA,
    EG0_DEM_V,
    EG0_DEM_TP,
    EG0_DES_V,
    EG0_DES_TP,
    EG0_COND,
    EG0_USED,
    EG0_CLASSI,
    EG0_TEMPO,
    EG0_OBS,
    EG0_VM_OBS,
    EG0_OW_TP,
    EG0_OW_VL,
    EG0_VALPRO,
    EG0_SITUA,
    EG0_PGT,
    EG0_BANCO,
    EG0_FRETE,
    EG0_CHART,
    EG0_CLIENT,
    EG0_CLILOJ,
    EG0_VM_CLI,
    EG0_CODAGE,
    EG0_CODTER,
    EG0_NEG_TP,
    EG0_NEG_VL,
    EG0_NOR,
    EG0_TCFDT,
    EG0_TCFTM,
    EG0_TDISCH,
    EG0_TCFWK,
    EG0_TLOAD,
    EG0_DT_CP,
    EG0_VCT,
    EG0_VM_BCO
FROM EG0
WHERE
    D_E_L_E_T_ = ' '
    AND EG0_FILIAL = 'VALOR'
    AND EG0_MODULO = 'VALOR'
    AND EG0_DEMURR = 'VALOR'
    AND EG0_REVER = 'VALOR'
    AND EG0_NAVIO = 'VALOR'
    AND EG0_VIAGEM = 'VALOR'
    AND EG0_DEST = 'VALOR'
    AND EG0_VM_DES = 'VALOR'
    AND EG0_TIPO = 'VALOR'
    AND EG0_DT_BOK BETWEEN '20261001' AND '20261031'
    AND EG0_FORNEC = 'VALOR'
    AND EG0_FORLOJ = 'VALOR'
    AND EG0_VM_FOR = 'VALOR'
    AND EG0_ROADS BETWEEN '20261001' AND '20261031'
    AND EG0_ROADSW = 'VALOR'
    AND EG0_ROADST = 'VALOR'
    AND EG0_BERT BETWEEN '20261001' AND '20261031'
    AND EG0_BERTW = 'VALOR'
    AND EG0_BERTT = 'VALOR'
    AND EG0_TEND BETWEEN '20261001' AND '20261031'
    AND EG0_TENDW = 'VALOR'
    AND EG0_TENDT = 'VALOR'
    AND EG0_ACCEP BETWEEN '20261001' AND '20261031'
    AND EG0_ACCEPW = 'VALOR'
    AND EG0_ACCEPT = 'VALOR'
    AND EG0_FROM BETWEEN '20261001' AND '20261031'
    AND EG0_FROMW = 'VALOR'
    AND EG0_FROMT = 'VALOR'
    AND EG0_COMM BETWEEN '20261001' AND '20261031'
    AND EG0_COMMW = 'VALOR'
    AND EG0_COMMT = 'VALOR'
    AND EG0_COMP BETWEEN '20261001' AND '20261031'
    AND EG0_COMPW = 'VALOR'
    AND EG0_COMPT = 'VALOR'
    AND EG0_CARGO = 0
    AND EG0_PARC_C = 0
    AND EG0_RAT_LD = 0
    AND EG0_RAT_HD = 'VALOR'
    AND EG0_MOEDA = 'VALOR'
    AND EG0_DEM_V = 0
    AND EG0_DEM_TP = 'VALOR'
    AND EG0_DES_V = 0
    AND EG0_DES_TP = 'VALOR'
    AND EG0_COND = 'VALOR'
    AND EG0_USED = 'VALOR'
    AND EG0_CLASSI = 'VALOR'
    AND EG0_TEMPO = 0
    AND EG0_OBS = 'VALOR'
    AND EG0_OW_TP = 'VALOR'
    AND EG0_OW_VL = 0
    AND EG0_VALPRO = 0
    AND EG0_SITUA = 'VALOR'
    AND EG0_PGT BETWEEN '20261001' AND '20261031'
    AND EG0_BANCO = 'VALOR'
    AND EG0_FRETE = 'VALOR'
    AND EG0_CHART = 'VALOR'
    AND EG0_CLIENT = 'VALOR'
    AND EG0_CLILOJ = 'VALOR'
    AND EG0_VM_CLI = 'VALOR'
    AND EG0_CODAGE = 'VALOR'
    AND EG0_CODTER = 'VALOR'
    AND EG0_NEG_TP = 'VALOR'
    AND EG0_NEG_VL = 0
    AND EG0_NOR = 'VALOR'
    AND EG0_TCFDT BETWEEN '20261001' AND '20261031'
    AND EG0_TCFTM = 'VALOR'
    AND EG0_TDISCH = 0
    AND EG0_TCFWK = 'VALOR'
    AND EG0_TLOAD = 0
    AND EG0_DT_CP BETWEEN '20261001' AND '20261031'
    AND EG0_VCT BETWEEN '20261001' AND '20261031'