Salve salve, blz?
Tabela EC5. #EC5
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 |
| EC5 | DATA | EC5990 | Invoice (Contabilidade) | Invoice (Contabilidad) | Invoice (Accounting) | | E | E | E | 0 | | EC5_FILIAL+EC5_FORN+EC5_INVOIC+EC5_IDENTC+EC5_MOE_FO | N | 31 | | ECOIV100 | | 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 |
| EC5 | 01 | EC5_FILIAL | C | 2 | 0 | Filial | Filial do Sistema | | | | | 1 | | N | | | | | | | | 033 | |
| EC5 | 02 | EC5_INVOIC | C | 20 | 0 | No. Invoice | Numero da Invoice | @! | IV100Val('INVOICE') | | | 1 | | S | | | | | | | | 148 | |
| EC5 | 03 | EC5_IDENTC | C | 10 | 0 | Unid. Req. | Unidade Requisitante | @! | IV100Val('IDENTCT') | | ECC | 1 | | S | | | | | | | | | |
| EC5 | 04 | EC5_DESC_I | C | 40 | 0 | Desc.Un.Req. | Desc. Unidade Requisitan. | @! | | E_Field("EC5_IDENTC","ECC_DESCR") | | 1 | | N | V | V | | | | | E_Field("EC5_IDENTCT","ECC_DESCR",,.F.) | | |
| EC5 | 05 | EC5_T_D | C | 1 | 0 | Tipo | Tipo Estoq./Divisas/Trans | @! | | IF(Inclui,'T',EIC->EC5_T_D) | | 1 | | N | | | | | | | | | |
| EC5 | 06 | EC5_DES_TD | C | 8 | 0 | Tipo | Tipo Estoq./Divisas/Trans | @! | | BuscaOrigem(M->EC5_SIS_OR) | | 1 | | S | V | V | | | | | IF(EC5->EC5_T_D='E','Estoque ',IF(EC5->EC5_T_D='D','Divisas ','Transito')) | | |
| EC5 | 07 | EC5_DT_EMI | D | 8 | 0 | Data Emissao | Data de Emissao | @D | IV100Val('DATA') | | | 1 | | S | | | | | | IV100When("GERAL") | | | |
| EC5 | 08 | EC5_DT_VEN | D | 8 | 0 | Data Venc. | Data de Vencimento | @D | | | | 1 | | S | | | | | | | | | |
| EC5 | 09 | EC5_HAWB | C | 20 | 0 | Processo | Processo | @! | | | | 1 | | S | | | | | | | | 148 | |
| EC5 | 10 | EC5_FORN | C | 6 | 0 | Cod. Fornec. | Codigo do Fornecedor | @! | IV100Val('FORN') | | FOR100 | 1 | | N | | | | | | IV100When("GERAL") | | 001 | |
| EC5 | 11 | EC5_FORNDE | C | 50 | 0 | Fornecedor | Nome do Fornecedor | @! | | E_Field("EC5_FORN","A2_NREDUZ") | | 1 | | S | V | V | | | | | E_Field("EC5_FORN","A2_NREDUZ",,.T.) | 177 | |
| EC5 | 12 | EC5_MOE_FO | C | 3 | 0 | Moeda | Moeda | @! | IV100Val('MOEDA') | | SYF | 1 | | S | | | | | | IV100When("GERAL") | | | |
| EC5 | 13 | EC5_AMOS | C | 1 | 0 | Amostra | Amostra | @! | | "2" | | 1 | | S | | | | 1=Sim;2=Nao | | IV100When("GERAL") | | | |
| EC5 | 14 | EC5_FOB_TO | N | 15 | 2 | Valor Invoic | Valor da Invoice | @E 999,999,999,999.99 | positivo() .AND. IV100Val('VALOR') | | | 1 | | S | | | | | | IV100When("GERAL") | | | |
| EC5 | 15 | EC5_CD_PGT | C | 1 | 0 | Condic. Pgto | Condicao de Pagamento | @! | | IF(Inclui,'2',EIC->EC5_CD_PGT) | | 1 | | N | | | | | | | | | |
| EC5 | 16 | EC5_DES_PG | C | 15 | 0 | Condic. Pgto | Condicao de Pagamento | @! | | BuscaCondPagto(EC5->EC5_CD_PGT) | | 1 | | S | V | V | | | | | EC5->EC5_CD_PGT+'-'+BuscaCondPagto(EC5->EC5_CD_PGT) | | |
| EC5 | 17 | EC5_VCFMES | C | 2 | 0 | Mes Encerram | Mes Enceramento | @R 99 | | | | 1 | | S | | | | | | ! Inclui | | | |
| EC5 | 18 | EC5_VCFANO | C | 4 | 0 | Ano Encerram | Ano Enceramento | @R 9999 | | | | 1 | | S | | | | | | ! Inclui | | | |
| EC5 | 19 | EC5_NR_CON | C | 4 | 0 | Nr. Contabil | Nr. da Contabilidade | @R 9999 | | '0000' | | 1 | | S | | | | | | .F. | | | |
| EC5 | 20 | EC5_DT_CAM | D | 8 | 0 | Data Ult.Ctb | Data da Ultima Contabil. | @D | | | | 1 | | S | | | | | | .F. | | | |
| EC5 | 21 | EC5_SIS_OR | C | 1 | 0 | Origem | Origem | @! | | IF(Inclui,'2',EC5->EC5_SIS_OR) | | 1 | | N | | | | | | .F. | | | |
| EC5 | 22 | EC5_DES_OR | C | 15 | 0 | Desc.Origem | Descricao da Origem | @! | | IF(Inclui,'CONTABILIDADE',BuscaOrigem(EC5->EC5_SIS_OR)) | | 1 | | S | V | V | | | | | BuscaOrigem(EC5->EC5_SIS_OR,.T.) | | |
| EC5 | 23 | EC5_T_D_NR | C | 4 | 0 | No. da Conta | No. da Conta | @R 9999 | | | | 1 | | N | | | | | | | | | |
SIX - INDICES
| INDICE | ORDEM | CHAVE | DESCRICAO | DESCSPA | DESCENG | PROPRI | F3 | NICKNAME | SHOWPESQ | IX_VIRTUAL | IX_VIRCUST |
| EC5 | 1 | EC5_FILIAL+EC5_FORN+EC5_INVOIC+EC5_IDENTC+EC5_MOE_FO | Cod. Fornec. + No. Invoice + Unid. Req. + Moeda | Cod. Proveed + Num. Invoice + Unid.Solic. + Moneda | Supp. Code + Invoice Nr. + Petition Un. + Currency | S | | | S | 2 | 3 |
| EC5 | 2 | EC5_FILIAL+EC5_FORN+DTOS(EC5_DT_EMI)+EC5_INVOIC+EC5_IDENTC | Cod. Fornec. + Data Emissao + No. Invoice + Unid. Req. | Cod. Proveed + Fch.Emision + Num. Invoice + Unid.Solic. | Supp. Code + Issue Date + Invoice Nr. + Petition Un. | S | | | S | 2 | 3 |
| EC5 | 3 | EC5_FILIAL+EC5_NR_CON+EC5_FORN+EC5_INVOIC+EC5_IDENTC | Nr. Contabil + Cod. Fornec. + No. Invoice + Unid. Req. | Num Contabil + Cod. Proveed + Num. Invoice + Unid.Solic. | Account. No. + Supp. Code + Invoice Nr. + Petition Un. | S | | | S | 2 | 3 |
| EC5 | 4 | EC5_FILIAL+EC5_VCFANO+EC5_VCFMES+EC5_FORN+EC5_INVOIC+EC5_IDENTC | Ano Encerram + Mes Encerram + Cod. Fornec. + No. Invoice + Unid. Req. | Ano Cierre + Mes Cierre + Cod. Proveed + Num. Invoice + Unid.Solic. | Clos. Year + Clos. Month + Supp. Code + Invoice Nr. + Petition Un. | S | | | S | 2 | 3 |
| EC5 | 5 | EC5_FILIAL+EC5_INVOIC+EC5_FORN+EC5_IDENTC | No. Invoice + Cod. Fornec. + Unid. Req. | Num. Invoice + Cod. Proveed + Unid.Solic. | Invoice Nr. + Supp. Code + Petition Un. | S | | | S | 2 | 3 |
| EC5 | 6 | EC5_FILIAL+EC5_HAWB+EC5_IDENTC | Processo + Unid. Req. | Proceso + Unid.Solic. | Process + Petition Un. | S | | | S | 2 | 3 |
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 |
| EC5 | 001 | ECA | EC5_FORN+EC5_INVOIC+EC5_IDENTC+EC5_MOE_FO | ECA_IDENTC+ECA_INVOIC+ECA_FORN+ECA_MOEDA | S | 1 | N | #ECA_PAGANT='0' AND #ECA_TPMODU='IMPORT' | S | S | 2 | 2 |
| EC5 | 002 | EC7 | EC5_IDENTC+EC5_INVOIC+EC5_FORN+EC5_MOE_FO | EC7_IDENTC+EC7_INVOIC+EC7_FORN+EC7_MOEDA | S | 1 | N | | S | S | 2 | 2 |
| EC5 | 003 | EC8 | EC5_INVOIC | EC8_INVOIC | S | 1 | N | | S | N | 2 | 2 |
| EC5 | 004 | EC8 | EC5_IDENTC+EC5_INVOIC+EC5_FORN+EC5_MOE_FO | EC8_IDENTC+EC8_INVOIC+EC8_FORN+EC8_MOEDA | S | 1 | N | | S | S | 2 | 2 |
| EC5 | 005 | EC9 | EC5_IDENTC+EC5_INVOIC+EC5_FORN | EC9_IDENTC+EC9_INVOIC+EC9_FORN | 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 |
| 001 | Codigo Cliente/Fornecedor | Codigo Cliente/Proveedor | Customer/Supplier Code | 20 | 6 | 6 | @! |
| 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 | @! |
| 177 | Nome do Fornecedor | Nombre del proveedor | Supplier Name | 254 | 50 | 50 | @! |
Gostou? Compartilhe com seus amigos e deixe um comentário! ??
Um abraço, e até a próxima
