Tabela EG0 - Demurrage
Rotina (SysObj): AVGDM400
Modo: E
Modo Unid.: E
Modo Empr.: E
Sumario:
Campos
| Campo | Titulo | Descricao | Tipo | Contexto | Tamanho |
|---|---|---|---|---|---|
| EG0_FILIAL | Filial | Filial | C | Real | 2 |
| EG0_MODULO | Modulo | Modulo | C | Real | 1 |
| EG0_DEMURR | Demurrage | Codigo do demurrage | C | Real | 15 |
| EG0_REVER | Reversivel | Reversivel | C | Real | 1 |
| EG0_NAVIO | Vessel Code | Vessel Code | C | Real | 25 |
| EG0_VIAGEM | Trip | Trip | C | Real | 20 |
| EG0_DEST | Disch. Port | Disch. Port | C | Real | 3 |
| EG0_VM_DES | Disch. Port. | Disch. Port. | C | Virtual | 25 |
| EG0_TIPO | Type | Type | C | Real | 1 |
| EG0_DT_BOK | C/P Dated Of | C/P Dated Of | D | Real | 8 |
| EG0_FORNEC | Owners/Selle | Owners/Sellers | C | Real | 6 |
| EG0_FORLOJ | Unit | Unit | C | Real | 2 |
| EG0_VM_FOR | Owners/Selle | Owners/Sellers | C | Virtual | 20 |
| EG0_ROADS | Vsl Arvd Rds | Vsl Arvd Rds | D | Real | 8 |
| EG0_ROADSW | Week Roads | Week Roads | C | Virtual | 15 |
| EG0_ROADST | Time Roads | Time Roads | C | Real | 5 |
| EG0_BERT | Vsl Berthed | Vsl Berthed | D | Real | 8 |
| EG0_BERTW | Week Berthed | Week Berthed | C | Virtual | 15 |
| EG0_BERTT | Time Berthed | Time Berthed | C | Real | 5 |
| EG0_TEND | NOR Tendered | NOR Tendered | D | Real | 8 |
| EG0_TENDW | Week Tendere | Week Tendere | C | Virtual | 15 |
| EG0_TENDT | Time Tendere | Time Tendered | C | Real | 5 |
| EG0_ACCEP | NOR Accepted | NOR Accepted | D | Real | 8 |
| EG0_ACCEPW | Week Accepte | Week Accepted | C | Virtual | 15 |
| EG0_ACCEPT | Time Accepte | Time Accepted | C | Real | 5 |
| EG0_FROM | Time Cnt Fro | Time Cnt Fro | D | Real | 8 |
| EG0_FROMW | Week Time | Week Time | C | Virtual | 15 |
| EG0_FROMT | Time From | Time From | C | Real | 5 |
| EG0_COMM | Ld.Dis.Comme | Ld.Dis.Commenced | D | Real | 8 |
| EG0_COMMW | Week Commenc | Week Commenced | C | Virtual | 15 |
| EG0_COMMT | Time Commenc | Time Commenced | C | Real | 5 |
| EG0_COMP | Disch. Compl | Disch. Completed | D | Real | 8 |
| EG0_COMPW | Week Complet | Week Completed | C | Virtual | 15 |
| EG0_COMPT | Time Complet | Time Completed | C | Real | 5 |
| EG0_CARGO | Cgo. Qtty | Cgo. Qtty | N | Real | 14, 5 |
| EG0_PARC_C | Parcel Cargo | Parcel Cargo Quantity | N | Real | 14, 5 |
| EG0_RAT_LD | Rate L/D | Rate L/D | N | Real | 16, 5 |
| EG0_RAT_HD | Rate L/D D/H | Rate L/D D/H | C | Real | 1 |
| EG0_MOEDA | Money | Money | C | Real | 3 |
| EG0_DEM_V | Dem Rate Val | Dem Rate Value | N | Real | 16, 2 |
| EG0_DEM_TP | Dem Rate At | Demurrage Rate At | C | Real | 1 |
| EG0_DES_V | Des Rate Val | Despatch Rate At | N | Real | 16, 2 |
| EG0_DES_TP | Des Rate At | Despatch Rate At | C | Real | 1 |
| EG0_COND | Condition | Condition | C | Real | 50 |
| EG0_USED | Time Used | Time Used | C | Real | 8 |
| EG0_CLASSI | Classificati | Classification | C | Real | 1 |
| EG0_TEMPO | Time Calc | Tempo Calculated | N | Real | 16, 8 |
| EG0_OBS | Remarks | Remarks | C | Real | 6 |
| EG0_VM_OBS | Observation | Observation | M | Virtual | 60 |
| EG0_OW_TP | Owners Type | Owners Type | C | Real | 1 |
| EG0_OW_VL | Owners Value | Owners Value | N | Real | 16, 2 |
| EG0_VALPRO | Vlr do Proc. | Valor do Processo | N | Real | 16, 2 |
| EG0_SITUA | Situation | Situation | C | Real | 50 |
| EG0_PGT | Dt.Payment | Dt.Payment | D | Real | 8 |
| EG0_BANCO | Dados Banc. | Dados Banc. | C | Real | 6 |
| EG0_FRETE | Charterer | Charterer | C | Real | 1 |
| EG0_CHART | Charter Part | Charter Part | C | Real | 20 |
| EG0_CLIENT | Buyers | Buyers | C | Real | 6 |
| EG0_CLILOJ | Unit | Unit | C | Real | 2 |
| EG0_VM_CLI | Buyers | Buyers | C | Virtual | 20 |
| EG0_CODAGE | Inspector | Inspector | C | Real | 6 |
| EG0_CODTER | Terminal | Terminal | C | Real | 6 |
| EG0_NEG_TP | Neg. Type | Neg. Type | C | Real | 1 |
| EG0_NEG_VL | Rev. Figures | Rev. Figures | N | Real | 16, 2 |
| EG0_NOR | Time NOR | Time NOR | C | Real | 8 |
| EG0_TCFDT | Dt Cnt Finsh | Date Count Finished | D | Real | 8 |
| EG0_TCFTM | Tm Cnt Finsh | Time Count Finished | C | Real | 5 |
| EG0_TDISCH | Time Disch | Time Discharged | N | Real | 16, 8 |
| EG0_TCFWK | Wk Cnt Finsh | Wk Cnt Finsh | C | Virtual | 15 |
| EG0_TLOAD | Time Load | Time Loaded | N | Real | 16, 8 |
| EG0_DT_CP | Dt. Ch. Par. | Dt. Ch. Par. | D | Real | 8 |
| EG0_VCT | Closing Date | Closing Date | D | Real | 8 |
| EG0_VM_BCO | Banking data | Banking data | M | Virtual | 60 |
Indices
| Ordem | Chave | Descricao | Nickname |
|---|---|---|---|
| 1 | EG0_FILIAL + EG0_MODULO + EG0_DEMURR + EG0_NAVIO + EG0_VIAGEM + EG0_DEST | Modulo + Demurrage + Vessel Code + Trip + Disch. Port | |
| 2 | EG0_FILIAL + EG0_MODULO + EG0_DEMURR + EG0_FORNEC + EG0_NAVIO + EG0_VIAGEM + EG0_DEST | Modulo + Demurrage + Owners/Selle + Vessel Code + Trip + Disch. Port |
Relacionamentos
| Tabela Origem | Tabela Destino | Expressao Origem | Expressao Destino | Relacionamento |
|---|---|---|---|---|
| EE6 (Disponibilidade de Navios) | EG0 (Demurrage) | EE6_COD + EE6_VIAGEM | EG0_NAVIO + EG0_VIAGEM | 1 para N |
| SA1 (Clientes) | EG0 (Demurrage) | A1_COD + A1_LOJA | EG0_CLIENT + EG0_CLILOJ | 1 para N |
| SA2 (Fornecedores) | EG0 (Demurrage) | A2_COD + A2_LOJA | EG0_FORNEC + EG0_FORLOJ | 1 para N |
| SY5 (Despachantes/Empresas) | EG0 (Demurrage) | Y5_COD | EG0_CODAGE | 1 para N |
| SY5 (Despachantes/Empresas) | EG0 (Demurrage) | Y5_COD | EG0_CODTER | 1 para N |
| SYF (Moedas) | EG0 (Demurrage) | YF_MOEDA | EG0_MOEDA | 1 para N |
| SYR (Taxas de Frete) | EG0 (Demurrage) | YR_DESTINO | EG0_DEST | 1 para N |