Salve salve, blz?
Tabela EG0. #EG0
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 |
| EG0 | DATA | EG0990 | Demurrage | Demurrage | Demurrage | | E | E | E | 0 | | | N | 17 | EG0_DEMURR+EG0_NAVIO+EG0_VIAGEM+EG0_DEST | AVGDM400 | | 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 |
| EG0 | 01 | EG0_FILIAL | C | 2 | 0 | Filial | Filial | | | | | 1 | | N | | | | | | | | 033 | |
| EG0 | 02 | EG0_MODULO | C | 1 | 0 | Modulo | Modulo | | | | | 1 | | N | | | | | | | | | |
| EG0 | 03 | EG0_DEMURR | C | 15 | 0 | Demurrage | Codigo do demurrage | @! | ExistChav("EG0",IF(nModulo==17,"I",IF(nModulo==29,"E"," "))+M->EG0_DEMURR) | | | 1 | | S | | | | | | Inclui | | | 1 |
| EG0 | 04 | EG0_REVER | C | 1 | 0 | Reversivel | Reversivel | | RM400VAL("EG0_REVER") | "2" | | 1 | | S | | | | 1=Sim;2=Näo | | Inclui | | | 1 |
| EG0 | 05 | EG0_NAVIO | C | 25 | 0 | Vessel Code | Vessel Code | @! | RM400VAL("EG0_NAVIO") | | E6_ | 1 | | S | | | | | | Inclui | | | 1 |
| EG0 | 06 | EG0_VIAGEM | C | 20 | 0 | Trip | Trip | @! | RM400VAL("EG0_VIAGEM") | | | 1 | | S | | | | | | Inclui | | | 1 |
| EG0 | 07 | EG0_DEST | C | 3 | 0 | Disch. Port | Disch. Port | @! | RM400VAL("EG0_DEST") | | YR1 | 1 | | S | | | | | | Inclui .and. M->EG0_REVER = '2' | | | 1 |
| EG0 | 08 | EG0_VM_DES | C | 25 | 0 | Disch. Port. | Disch. Port. | @! | | E_FIELD("EG0_DEST","Y9_DESCR",,,2) | | 1 | | N | V | V | | | | | | | 1 |
| EG0 | 09 | EG0_TIPO | C | 1 | 0 | Type | Type | @! | | "2" | | 1 | | S | | | | 1=Solid;2=Liquid | | Inclui | | | 1 |
| EG0 | 10 | EG0_DT_BOK | D | 8 | 0 | C/P Dated Of | C/P Dated Of | @D | RM400Val("EG0_DT_BOK") | dDataBase | | 1 | | S | | | | | | Inclui | | | 1 |
| EG0 | 11 | EG0_FORNEC | C | 6 | 0 | Owners/Selle | Owners/Sellers | @! | RM400VAL("EG0_FORNEC") | | SA2 | 1 | | S | | | | | | Inclui | | 001 | 1 |
| EG0 | 12 | EG0_FORLOJ | C | 2 | 0 | Unit | Unit | @! | | | | 1 | | S | | | | | | | | 002 | 1 |
| EG0 | 56 | EG0_FRETE | C | 1 | 0 | Charterer | Charterer | | RM400VAL("EG0_FRETE") | "1" | | 1 | | S | A | R | | 1=Sim ; 2=Näo | | Inclui | | | 1 |
| EG0 | 57 | EG0_CHART | C | 20 | 0 | Charter Part | Charter Part | @! | | | | 1 | | N | A | R | | | | | | | 1 |
| EG0 | 58 | EG0_CLIENT | C | 6 | 0 | Buyers | Buyers | @! | RM400VAL("EG0_CLIENT") | | SA1 | 1 | | N | A | R | | | | Inclui | | 001 | 1 |
| EG0 | 59 | EG0_CLILOJ | C | 2 | 0 | Unit | Unit | @! | | | | 1 | | S | A | R | | | | Inclui | | 002 | 1 |
| EG0 | 60 | EG0_VM_CLI | C | 20 | 0 | Buyers | Buyers | @! | E_FIELD("EG0_CLIENT","A1_NREDUZ") | | | 1 | | N | V | V | | | | Inclui | | | 1 |
| EG0 | 61 | EG0_CODAGE | C | 6 | 0 | Inspector | Inspector | @! | | | SY5A | 1 | | N | A | R | | | | | | 001 | 1 |
| EG0 | 62 | EG0_CODTER | C | 6 | 0 | Terminal | Terminal | @! | | | Y5A | 1 | | N | A | R | | | | | | 001 | 1 |
| EG0 | 13 | EG0_ROADS | D | 8 | 0 | Vsl Arvd Rds | Vsl Arvd Rds | @D | RM400VAL("EG0_ROADS") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 38 | EG0_RAT_HD | C | 1 | 0 | Rate L/D D/H | Rate L/D D/H | | RM400VAL("EG0_RAT_HD") | "1" | | 1 | | S | | | | 1=Day;2=Hour | | | | | 3 |
| EG0 | 39 | EG0_MOEDA | C | 3 | 0 | Money | Money | | RM400VAL("EG0_MOEDA") | "US$" | SYF | 1 | | S | | | | | | Inclui | | | 3 |
| EG0 | 40 | EG0_DEM_V | N | 16 | 2 | Dem Rate Val | Dem Rate Value | @E 9,999,999,999,999.99 | RM400VAL("EG0_DEM_V") | | | 1 | | S | | | | | | | | | 3 |
| EG0 | 41 | EG0_DEM_TP | C | 1 | 0 | Dem Rate At | Demurrage Rate At | | RM400VAL("EG0_DEM_TP") | "1" | | 1 | | S | | | | 1=Day;2=Hour | | | | | 3 |
| EG0 | 42 | EG0_DES_V | N | 16 | 2 | Des Rate Val | Despatch Rate At | @E 9,999,999,999,999.99 | RM400VAL("EG0_DES_V") | | | 1 | | S | | | | | | | | | 3 |
| EG0 | 43 | EG0_DES_TP | C | 1 | 0 | Des Rate At | Despatch Rate At | | RM400VAL("EG0_DES_TP") | | | 1 | | S | | | | 1=Day;2=Hour | | | | | 3 |
| EG0 | 44 | EG0_COND | C | 50 | 0 | Condition | Condition | | | | | 1 | | S | | | | | | | | | 3 |
| EG0 | 45 | EG0_USED | C | 8 | 0 | Time Used | Time Used | | | | | 1 | | S | | | | | | .F. | | | 3 |
| EG0 | 46 | EG0_CLASSI | C | 1 | 0 | Classificati | Classification | | | "2" | | 1 | | N | A | R | | 1=Demurrage;2=Despatch;3=No Demurrage No Despatch | | .F. | | | 3 |
| EG0 | 47 | EG0_TEMPO | N | 16 | 8 | Time Calc | Tempo Calculated | @E 9,999,999.99999999 | | | | 1 | | S | | | | | | .F. | | | 3 |
| EG0 | 48 | EG0_OBS | C | 6 | 0 | Remarks | Remarks | | | | | 1 | | N | | | | | | | | | 4 |
| EG0 | 49 | EG0_VM_OBS | M | 60 | 0 | Observation | Observation | | | MSMM(M->EG0_OBS,60) | | 1 | | N | | V | | | | | | | 4 |
| EG0 | 66 | EG0_TCFDT | D | 8 | 0 | Dt Cnt Finsh | Date Count Finished | @d | RM400VAL("EG0_TCFDT") | | | 1 | | S | A | R | | | | | | | 2 |
| EG0 | 67 | EG0_TCFTM | C | 5 | 0 | Tm Cnt Finsh | Time Count Finished | 99:99 | RM400VAL("EG0_TCFTM") | | | 1 | | S | A | R | | | | | | | 2 |
| EG0 | 68 | EG0_TCFWK | C | 15 | 0 | Wk Cnt Finsh | Wk Cnt Finsh | @! | CdoW(M->EG0_COMM) | CDOW(M->EG0_TCFDT) | | 1 | | N | V | V | | | | | | | 2 |
| EG0 | 70 | EG0_DT_CP | D | 8 | 0 | Dt. Ch. Par. | Dt. Ch. Par. | @d | | | | 1 | | S | A | R | | | | | | | 2 |
| EG0 | 73 | EG0_VM_BCO | M | 60 | 0 | Banking data | Banking data | | | MSMM(M->EG0_BANCO,60) | | 1 | | N | A | V | | | | | | | 4 |
| EG0 | 37 | EG0_RAT_LD | N | 16 | 5 | Rate L/D | Rate L/D | @E 9,999,999,999.99999 | RM400VAL("EG0_RAT_LD") | | | 1 | | S | | | | | | | | | 3 |
| EG0 | 36 | EG0_PARC_C | N | 14 | 5 | Parcel Cargo | Parcel Cargo Quantity | @E 99,999,999.99999 | | | | 1 | | S | | | | | | .F. | | | 3 |
| EG0 | 35 | EG0_CARGO | N | 14 | 5 | Cgo. Qtty | Cgo. Qtty | @E 99,999,999.99999 | RM400VAL("EG0_CARGO") | | | 1 | | S | | | | | | | | | 3 |
| EG0 | 34 | EG0_COMPT | C | 5 | 0 | Time Complet | Time Completed | 99:99 | RM400VAL("EG0_COMPT") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 33 | EG0_COMPW | C | 15 | 0 | Week Complet | Week Completed | @! | | CdoW(M->EG0_COMP) | | 1 | | N | V | V | | | | | | | 2 |
| EG0 | 32 | EG0_COMP | D | 8 | 0 | Disch. Compl | Disch. Completed | @D | RM400VAL("EG0_COMP") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 31 | EG0_COMMT | C | 5 | 0 | Time Commenc | Time Commenced | 99:99 | RM400VAL("EG0_COMMT") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 30 | EG0_COMMW | C | 15 | 0 | Week Commenc | Week Commenced | @! | | CDOW(M->EG0_COMM) | | 1 | | N | V | V | | | | | | | 2 |
| EG0 | 29 | EG0_COMM | D | 8 | 0 | Ld.Dis.Comme | Ld.Dis.Commenced | @D | RM400VAL("EG0_COMM") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 28 | EG0_FROMT | C | 5 | 0 | Time From | Time From | 99:99 | RM400VAL("EG0_FROMT") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 27 | EG0_FROMW | C | 15 | 0 | Week Time | Week Time | @! | | CDOW(M->EG0_FROM) | | 1 | | N | V | V | | | | | | | 2 |
| EG0 | 26 | EG0_FROM | D | 8 | 0 | Time Cnt Fro | Time Cnt Fro | @D | RM400VAL("EG0_FROM") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 25 | EG0_ACCEPT | C | 5 | 0 | Time Accepte | Time Accepted | 99:99 | RM400VAL("EG0_ACCEPT") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 24 | EG0_ACCEPW | C | 15 | 0 | Week Accepte | Week Accepted | @! | | CDOW(M->EG0_ACCEP) | | 1 | | N | V | V | | | | | | | 2 |
| EG0 | 23 | EG0_ACCEP | D | 8 | 0 | NOR Accepted | NOR Accepted | @D | RM400VAL("EG0_ACCEP") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 22 | EG0_TENDT | C | 5 | 0 | Time Tendere | Time Tendered | 99:99 | RM400VAL("EG0_TENDT") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 21 | EG0_TENDW | C | 15 | 0 | Week Tendere | Week Tendere | @! | | CdoW(M->EG0_TEND) | | 1 | | N | V | V | | | | | | | 2 |
| EG0 | 20 | EG0_TEND | D | 8 | 0 | NOR Tendered | NOR Tendered | @D | RM400VAL("EG0_TEND") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 19 | EG0_BERTT | C | 5 | 0 | Time Berthed | Time Berthed | 99:99 | RM400VAL("EG0_BERTT") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 18 | EG0_BERTW | C | 15 | 0 | Week Berthed | Week Berthed | @! | | CDOW(M->EG0_BERT) | | 1 | | N | V | V | | | | | | | 2 |
| EG0 | 17 | EG0_BERT | D | 8 | 0 | Vsl Berthed | Vsl Berthed | @D | RM400VAL("EG0_BERT") | | | 1 | | N | | | | | | | | | 2 |
| EG0 | 16 | EG0_ROADST | C | 5 | 0 | Time Roads | Time Roads | 99:99 | RM400VAL("EG0_ROADST") | | | 1 | | S | | | | | | | | | 2 |
| EG0 | 15 | EG0_ROADSW | C | 15 | 0 | Week Roads | Week Roads | @! | | CDOW(M->EG0_ROADS) | | 1 | | N | V | V | | | | | | | 2 |
| EG0 | 14 | EG0_VM_FOR | C | 20 | 0 | Owners/Selle | Owners/Sellers | @! | | E_FIELD("EG0_FORNEC","A2_NREDUZ") | | 1 | | N | V | V | | | | | | | 1 |
| EG0 | 72 | EG0_VCT | D | 8 | 0 | Closing Date | Closing Date | @d | | | | 1 | | S | A | R | | | | | | | |
| EG0 | 71 | EG0_TLOAD | N | 16 | 8 | Time Load | Time Loaded | @E 9,999,999.99999999 | | | | 1 | | S | A | R | | | | .F. | | | |
| EG0 | 69 | EG0_TDISCH | N | 16 | 8 | Time Disch | Time Discharged | @E 9,999,999.99999999 | | | | 1 | | S | A | R | | | | .F. | | | |
| EG0 | 65 | EG0_NOR | C | 8 | 0 | Time NOR | Time NOR | 99:99:99 | RM400VAL("EG0_NOR") | | | 1 | | N | A | R | | | | | | | |
| EG0 | 64 | EG0_NEG_VL | N | 16 | 2 | Rev. Figures | Rev. Figures | @E 9,999,999,999,999.99 | | | | 1 | | S | A | R | | | | | | | |
| EG0 | 63 | EG0_NEG_TP | C | 1 | 0 | Neg. Type | Neg. Type | | | | | 1 | | N | A | R | | | | | | | |
| EG0 | 55 | EG0_BANCO | C | 6 | 0 | Dados Banc. | Dados Banc. | | | | | 1 | | S | A | R | | | | | | | |
| EG0 | 54 | EG0_PGT | D | 8 | 0 | Dt.Payment | Dt.Payment | @D | | | | 1 | | S | | | | | | | | | |
| EG0 | 53 | EG0_SITUA | C | 50 | 0 | Situation | Situation | @! | | | | 1 | | S | | | | | | | | | |
| EG0 | 52 | EG0_VALPRO | N | 16 | 2 | Vlr do Proc. | Valor do Processo | @E 9,999,999,999,999.99 | | | | 1 | | S | | | | | | | | | |
| EG0 | 51 | EG0_OW_VL | N | 16 | 2 | Owners Value | Owners Value | @E 9,999,999,999,999.99 | | | | 1 | | S | | | | | | | | | |
| EG0 | 50 | EG0_OW_TP | C | 1 | 0 | Owners Type | Owners Type | | | | | 1 | | S | | | | | | | | | |
SIX - INDICES
| INDICE | ORDEM | CHAVE | DESCRICAO | DESCSPA | DESCENG | PROPRI | F3 | NICKNAME | SHOWPESQ | IX_VIRTUAL | IX_VIRCUST |
| 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 |
| 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 |
SXG - Grupo de Campos
| XG_GRUPO | XG_DESCRI | XG_DESSPA | XG_DESENG | XG_SIZEMAX | XG_SIZEMIN | XG_SIZE | XG_PICTURE |
| 001 | Codigo Cliente/Fornecedor | Codigo Cliente/Proveedor | Customer/Supplier Code | 20 | 6 | 6 | @! |
| 002 | Loja Cliente/Fornecedor | Tienda Cliente/Proveedor | Customer/Supplier Unit | 4 | 2 | 2 | @! |
| 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
