| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| EE8 | Itens Processo de Exportacao | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| EE8_FILIAL | C | 2 | 0 | Filial | N | ||||||
| EE8_PEDIDO | C | 20 | 0 | Pedido | lALTERA | N | |||||
| EE8_SEQUEN | C | 6 | 0 | Sequencia | lALTERA | N | |||||
| EE8_COD_I | C | 15 | 0 | Codigo Item | @! | NaoVazio() .And. EECVLEE8("EE8_COD_I") .And. AP102Grade("EE8_COD_I") | EB1 | lALTERA | N | ||
| EE8_VM_DES | M | 60 | 0 | Descr. Item | V | lALTERA | N | ||||
| EE8_DESC | C | 6 | 0 | Descricao | @! | lALTERA | N | ||||
| EE8_CODQUA | C | 10 | 0 | Qualidade | @! | ExistCpo("EXW") | EXW | R | N | ||
| EE8_DSCQUA | M | 60 | 0 | Desc. Quali. | V | N | |||||
| EE8_QUADES | C | 6 | 0 | Desc. Quali. | R | N | |||||
| EE8_CODPEN | C | 10 | 0 | Peneira | @! | ExistCpo("EXX") | EXX | R | N | ||
| EE8_DSCPEN | C | 60 | 0 | Dsc. Peneira | R | N | |||||
| EE8_CODTIP | C | 10 | 0 | Tipo | @! | ExistCpo("EXY") | EXY | R | N | ||
| EE8_DSCTIP | C | 60 | 0 | Dsc. Tipo | R | N | |||||
| EE8_CODBEB | C | 10 | 0 | Cod Bebida | @! | ExistCpo("EY3") | EYA | R | lAltera | N | |
| EE8_DSCBEB | C | 60 | 0 | Descr Bebida | @! | lAltera | N | ||||
| EE8_FORN | C | 6 | 0 | Fornecedor | @! | AP100CRIT("EE8_FORN") .AND. AP100Crit("EE7_MARCAC") | AVE005 | lALTERA | N | ||
| EE8_FOLOJA | C | 2 | 0 | Loja | @! | AP100CRIT("EE8_FOLOJA") .AND. AP100Crit("EE7_MARCAC") | lALTERA | N | |||
| EE8_FABR | C | 6 | 0 | Fabricante | @! | AP100CRIT("EE8_FABR") .AND. AP100Crit("EE7_MARCAC") | AVE014 | lALTERA | N | ||
| EE8_FALOJA | C | 2 | 0 | Loja | @! | AP100CRIT("EE8_FALOJA") .AND. AP100Crit("EE7_MARCAC") | lALTERA | N | |||
| EE8_SLDINI | N | 15 | 3 | Quantidade | @E 999,999,999.999 | NaoVazio() .And. Positivo() .And. EECVLEE8("EE8_SLDINI") .And. AP102Grade("EE8_SLDINI") | AP100W("EE8_SLDINI") | N | |||
| EE8_EMBAL1 | C | 20 | 0 | Embalagem | NaoVazio().And.ExistCpo("EE5",M->EE8_EMBAL1).And.EECVLEE8("EE8_EMBAL1") | EE5 | Ap100w("EE8_EMBAL1") | N | |||
| EE8_UNIDAD | C | 2 | 0 | U.M.Qtde | ExistCpo("SAH") | SAH | lALTERA | N | |||
| EE8_QTDEM1 | N | 10 | 0 | Qt.de Embal. | @E 9,999,999,999 | naovazio().and.positivo().AND.EECVLEE8("EE8_QTDEM1") | Ap100w("EE8_QTDEM1") | N | |||
| EE8_UNPRC | C | 2 | 0 | U.M. Preco | Vazio() .Or. ExistCpo("SAH") .AND. AP104GATPRECO() | SAH | lALTERA | N | |||
| EE8_PRVPRO | D | 8 | 0 | Prev. Prod. | N | ||||||
| EE8_QE | N | 13 | 3 | Qt.na Embal. | @E 999,999,999.999 | NaoVazio().And.Positivo().AND.EECVLEE8("EE8_QE") | Ap100w("EE8_QE") | N | |||
| EE8_PART_N | C | 20 | 0 | Part-Number | @! | lALTERA | N | ||||
| EE8_DTPROD | D | 8 | 0 | Dt.Producao | N | ||||||
| EE8_PRECO | N | 16 | 7 | Preco Unit. | @E 99,999,999.9999999 | AP100CRIT("EE8_PRECO") .AND. POSITIVO() .AND. EECVLEE8("EE8_PRECO") .AND. AP104GATPRECO(,.F.) | AP100W("EE8_PRECO") | N | |||
| EE8_PRECO2 | N | 16 | 7 | Preco $/60Kg | @E 99,999,999.9999999 | POSITIVO() .AND. AP104GATPRECO() | R | AP100W("EE8_PRECO") | N | ||
| EE8_PRECO3 | N | 16 | 7 | Preco cen/Lb | @E 99,999,999.9999999 | POSITIVO() .AND. AP104GATPRECO() | R | AP100W("EE8_PRECO") | N | ||
| EE8_PRECO4 | N | 16 | 7 | Preco $/Ton | @E 99,999,999.9999999 | POSITIVO() .AND. AP104GATPRECO() | R | AP100W("EE8_PRECO") | N | ||
| EE8_PRECO5 | N | 16 | 7 | Preco $/50Kg | @E 99,999,999.9999999 | POSITIVO() .AND. AP104GATPRECO() | R | AP100W("EE8_PRECO") | S | ||
| EE8_DESCON | N | 15 | 2 | Desconto | @E 999,999,999,999.99 | VAZIO() .OR. POSITIVO() | R | lAltera | N | ||
| EE8_PRENEG | N | 16 | 7 | Preco Negoc. | @E 99,999,999.9999999 | VAZIO() .OR. Positivo() | R | M->EE7_INTERM="1" | N | ||
| EE8_DTPREM | D | 8 | 0 | Dt.Prev.Emb. | @D | Vazio() .Or. EECVLEE8("EE8_DTPREM") | lALTERA | N | |||
| EE8_DTENTR | D | 8 | 0 | Dt.Entrega | @D | Vazio() .Or. EECVLEE8("EE8_DTENTR") | lALTERA | N | |||
| EE8_PRECOI | N | 16 | 8 | Preco FOB | @E 9,999,999.99999999 | POSITIVO() | lALTERA | N | |||
| EE8_PRCTOT | N | 16 | 2 | Preco Total | @E 9,999,999,999,999.99 | naovazio().and.POSITIVO().AND. EECVLEE8("EE8_PRCTOT").and.ap100precoI() | lALTERA | N | |||
| EE8_SLDATU | N | 15 | 3 | Sld.Atual | @E 999,999,999.999 | lALTERA | N | ||||
| EE8_UNPES | C | 2 | 0 | U.M. Peso | Vazio() .Or. ExistCpo("SAH") | SAH | lALTERA | N | |||
| EE8_PSLQUN | N | 16 | 7 | Peso Liq.Un. | @E 99,999,999.9999999 | POSITIVO().AND.EECVLEE8("EE8_PSLQUN") | lALTERA | N | |||
| EE8_PSLQTO | N | 16 | 3 | Peso Liq.Tot | @E 999,999,999,999.999 | lALTERA | N | ||||
| EE8_PSBRUN | N | 16 | 7 | Peso Bru.Un. | @E 99,999,999.9999999 | Positivo().AND.EECVLEE8("EE8_PSBRUN") | lALTERA | N | |||
| EE8_FPCOD | C | 10 | 0 | Cod.Familia | @! | VAZIO() .OR. EXISTCPO("SYC",M->EE8_FPCOD,1) | SYC | lALTERA | N | ||
| EE8_GPCOD | C | 15 | 0 | Cod.Grupo | @! | ExistCpo("EEH",M->EE7_IDIOMA+M->EE8_GPCOD) | AVE010 | lALTERA | N | ||
| EE8_PSBRTO | N | 15 | 3 | Peso Bru.Tot | @E 99,999,999,999.999 | lALTERA | N | ||||
| EE8_DPCOD | C | 15 | 0 | Cod.Divisao | @! | VAZIO() .OR. EXISTCPO("EEG",cIDCAPA+M->EE8_DPCOD,1) | AVE012 | lALTERA | N | ||
| EE8_TPONCM | C | 2 | 0 | Tipo NCM | 99 | EECVLEE8("EE8_TPONCM") | lALTERA | N | |||
| EE8_NLNCCA | C | 7 | 0 | NALADI NCCA | @R 9999.99.9 | VAZIO().OR.ExistCpo("SJ2",M->EE8_NLNCCA) | SJ2 | lALTERA | N | ||
| EE8_REFCLI | C | 20 | 0 | Ref.Cliente | @! | lALTERA | N | ||||
| EE8_NALSH | C | 8 | 0 | NALADI SH | @R 9999.99.99 | VAZIO().OR.ExistCpo("SJ1",M->EE8_NALSH) | SJ1 | lALTERA | N | ||
| EE8_TES | C | 3 | 0 | Tipo Saida | @9 | NaoVazio() .And. ExistCpo("SF4") | SF4 | N | |||
| EE8_PRCINC | N | 16 | 2 | Prc.Tot.FOB | @E 9,999,999,999,999.99 | naovazio().and.POSITIVO() | lALTERA | N | |||
| EE8_CF | C | 5 | 0 | Cod. Fiscal | @9 | NaoVazio() .AND. AP100Valid() | 13 | N | |||
| EE8_FATIT | C | 2 | 0 | Item do PV | N | ||||||
| EE8_STATUS | C | 1 | 0 | Situacao | lALTERA | N | |||||
| EE8_CODAGE | C | 6 | 0 | Agente Com. | @! | EECValidAg() .And. Ap100Crit("EE8_CODAGE") | AGE | AP100W("EE8_CODAGE") | N | ||
| EE8_PERCOM | N | 6 | 2 | Comissao % | @E 99.99 | Positivo() .AND. AP100CRIT("EE8_PERCOM") | AP100W("EE8_PERCOM") | N | |||
| EE8_VLCOM | N | 16 | 2 | Comissao | @E 9,999,999,999,999.99 | Positivo() .AND. AP100CRIT("EE8_VLCOM") | R | AP100W("EE8_VLCOM") | N | ||
| EE8_STA_RV | C | 1 | 0 | Status do RV | ! | EECVLEE8("EE8_STA_RV") | lALTERA | N | |||
| EE8_SEQ_RV | C | 2 | 0 | Sequencia RV | 99 | EECVLEE8("EE8_SEQ_RV") | lALTERA | N | |||
| EE8_VM_FIX | C | 60 | 0 | Sit. Fixacao | V | .F. | N | ||||
| EE8_MESFIX | C | 6 | 0 | Mes Fixacao | @R 99/9999 | lALTERA | N | ||||
| EE8_POSIPI | C | 10 | 0 | NCM | @R 9999.99.99 | Vazio() .OR.ExistCpo("SYD",M->EE8_POSIPI) | SYD2 | lALTERA | N | ||
| EE8_DTCOTA | D | 8 | 0 | Dt.Cotacao | @D | AP100W("EE8_DTCOTA") | N | ||||
| EE8_RV | C | 9 | 0 | Numero do RV | @R 99/9999999 | EECVLEE8("EE8_RV") | lALTERA | N | |||
| EE8_DTQNCM | C | 2 | 0 | Destaque NCM | @R 99 | EECVLEE8("EE8_DTQNCM") | lALTERA | N | |||
| EE8_DTFIX | D | 8 | 0 | Dt.Fixacao | @D | AP100W("EE8_DTFIX") | N | ||||
| EE8_DTRV | D | 8 | 0 | Data do RV | @D | N | |||||
| EE8_PRCFIX | N | 16 | 7 | Preco Fixado | @E 99,999,999.9999999 | V | AP100W("EE8_PRCFIX") | N | |||
| EE8_QTDFIX | N | 15 | 3 | Qtde.Fixada | @E 999,999,999.999 | V | AP100W("EE8_QTDFIX") | N | |||
| EE8_STFIX | C | 1 | 0 | Sit.Fixacao | N | ||||||
| EE8_QTDLOT | N | 15 | 3 | Qtde. Lots | @E 999,999,999.999 | Positivo() | AP100W("EE8_QTDLOT") | N | |||
| EE8_ORIGEM | C | 6 | 0 | Origem | N | ||||||
| EE8_DSCAGE | C | 40 | 0 | Desc.Agente | @! | V | N | ||||
| EE8_LOTECT | C | 10 | 0 | Lote | N | ||||||
| EE8_NUMLOT | C | 6 | 0 | Sub-Lote | @! | N | |||||
| EE8_TIPCOM | C | 1 | 0 | Tipo Comiss. | ! | Vazio() .Or. (Pertence("123 ") .And. EECValidAg(.f.) .And. Ap100Crit("EE8_TIPCOM")) | R | 1=A Remeter;2=Conta Grafica;3=Deduzir da Fatura | !Empty(M->EE8_CODAGE) | N | |
| EE8_DTVALI | D | 8 | 0 | Valid. Lote | N | ||||||
| EE8_DTVCRV | D | 8 | 0 | Dt.Vinc.RV | @D | N | |||||
| EE8_CODNOR | C | 3 | 0 | Cod.Norma | @! | Vazio() .Or. AC120NorVal("EE8_CODNOR") | EXN | N | |||
| EE8_VM_NOR | C | 60 | 0 | Desc.Norma | @! | V | N | ||||
| EE8_ORIGV | C | 6 | 0 | Orig.Vinc.RV | N | ||||||
| EE8_DIFERE | N | 12 | 4 | Diferencial | @E 999,999.9999 | R | lALTERA | N | |||
| EE8_INVPAG | C | 20 | 0 | Invoice Pag. | @! | AP106Valid("EE8_INVPAG") | IVP | R | N | ||
| EE8_LC_NUM | C | 20 | 0 | Nr. L/C | @! | (Vazio() .Or. ExistCpo("EEL")) .And. Ap100Crit("EE8_LC_NUM") | EEL | R | lAltera | N | |
| EE8_VLPAG | N | 16 | 7 | Pre. Un. Pag | @E 99,999,999.9999999 | AP106Valid("EE8_VLPAG") | R | N | |||
| EE8_PRCUN | N | 16 | 8 | Prc.Un.Incot | @E 9,999,999.99999999 | R | N | ||||
| EE8_SEQ_LC | C | 6 | 0 | Seq. L/C | @ 999999 | (Vazio() .Or. ExistCpo("EXS",M->(EE8_LC_NUM+EE8_SEQ_LC))) .And. Ap100Crit("EE8_SEQ_LC") | EXS | R | lAltera .And. Ap100W("EE8_SEQ_LC") | N | |
| EE8_VLFRET | N | 12 | 2 | Vl. do Frete | @E 999,999,999.99 | R | N | ||||
| EE8_VLSEGU | N | 12 | 2 | Vl. Seguro | @E 999,999,999.99 | R | N | ||||
| EE8_VLOUTR | N | 12 | 2 | Outras Desp. | @E 999,999,999.99 | R | N | ||||
| EE8_VLDESC | N | 12 | 2 | Vl. Desconto | @E 999,999,999.99 | R | N | ||||
| EE8_DIFE2 | N | 12 | 4 | Diferenc.Off | @E 999,999.9999 | R | M->EE7_INTERM="1" | N | |||
| EE8_GRADE | C | 1 | 0 | GRADE | R | S=SIM;N=NAO | N | ||||
| EE8_ITEMGR | C | 3 | 0 | Item Grade | R | N | |||||
| EE8_RESERV | C | 6 | 0 | Num.Reserva | @! | Vazio() .or. EECVLEE8("EE8_RESERV") | SC0 | S | |||
| EE8_CODOPE | C | 2 | 0 | Cod. Ope. Es | @! | ValidOpe('EE8_CODOPE') | EJ0 | lALTERA | S | ||
| EE8_DESOPE | C | 60 | 0 | Desc. Op. Es | @! | V | S | ||||
| EE8_PEDERP | C | 20 | 0 | Pedido ERP | @! | R | S | ||||
| EE8_SLDELI | N | 15 | 3 | Sld. Elimin. | @E 99,999,999,999.999 | S | |||||
| EE8_DTELIM | D | 8 | 0 | Dt. Elimin. | S | ||||||
| EE8_OPC | C | 80 | 0 | Opcional PE | @!S40 | .F. | S | ||||
| EE8_MOP | M | 10 | 0 | M. Opcional | @! | .F. | S | ||||
| EE8_ATOCON | C | 13 | 0 | Ato Conces | 9999999999999 | R | AP100W("EE8_ATOCON") | N | |||