Tabela |
EE9 |
Itens Embarque |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
EE9_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
EE9_PEDIDO |
C |
20 |
0 |
Pedido |
|
|
|
|
|
lALTERA |
N |
EE9_SEQUEN |
C |
6 |
0 |
Sequencia |
|
|
|
|
|
lALTERA |
N |
EE9_SEQEMB |
C |
6 |
0 |
Seq.Embarq. |
@R !!!!!!!!!! |
|
|
|
|
lALTERA |
N |
EE9_PREEMB |
C |
20 |
0 |
Prep.Embarq. |
|
|
|
|
|
lALTERA |
N |
EE9_COD_I |
C |
15 |
0 |
Codigo Item |
@! |
NaoVazio() .And. ExistCpo("SB1",M->EE9_COD_I) |
EB1 |
|
|
.F. |
N |
EE9_VM_DES |
M |
60 |
0 |
Descr. Item |
|
|
|
V |
|
|
N |
EE9_DESC |
C |
6 |
0 |
Descricao |
@! |
|
|
|
|
|
N |
EE9_CODQUA |
C |
10 |
0 |
Cod. Qual. |
@! |
ExistCpo("EXW") |
EXW |
R |
|
.F. |
N |
EE9_QUADES |
C |
6 |
0 |
Desc. Quali. |
|
|
|
R |
|
|
N |
EE9_DSCQUA |
M |
60 |
0 |
Desc. Qual. |
|
|
|
V |
|
.F. |
N |
EE9_CODPEN |
C |
10 |
0 |
Peneira |
@! |
ExistCpo("EXX") |
EXX |
R |
|
.F. |
N |
EE9_DSCPEN |
C |
60 |
0 |
Dsc. peneira |
|
|
|
R |
|
.F. |
N |
EE9_CODTIP |
C |
10 |
0 |
Tipo |
@! |
ExistCpo("EXY") |
EXY |
R |
|
.F. |
N |
EE9_DSCTIP |
C |
60 |
0 |
Dsc. Tipo |
|
|
|
R |
|
.F. |
N |
EE9_CODBEB |
C |
10 |
0 |
Cod Bebida |
@! |
ExistCpo("EY3") |
EYA |
|
|
.F. |
N |
EE9_DSCBEB |
C |
60 |
0 |
Descr Bebida |
@! |
|
|
|
|
.F. |
N |
EE9_FORN |
C |
6 |
0 |
Fornecedor |
@! |
AE100CRIT("EE9_FORN") |
AVE005 |
|
|
|
N |
EE9_FOLOJA |
C |
2 |
0 |
Loja |
@! |
AE100CRIT("EE9_FOLOJA") |
|
|
|
|
N |
EE9_FABR |
C |
6 |
0 |
Fabricante |
@! |
VAZIO().OR.AE100CRIT("EE9_FABR") |
AVE014 |
|
|
|
N |
EE9_FALOJA |
C |
2 |
0 |
Loja |
@! |
AE100CRIT("EE9_FALOJA") |
|
|
|
|
N |
EE9_DTPROD |
D |
8 |
0 |
Dt.Producao |
|
|
|
|
|
|
N |
EE9_PRVPRO |
D |
8 |
0 |
Prev.Prod. |
|
|
|
|
|
|
N |
EE9_PART_N |
C |
20 |
0 |
Part-Number |
@! |
|
|
|
|
|
N |
EE9_UNIDAD |
C |
2 |
0 |
U.M.Qtde |
|
ExistCpo("SAH") .and. AE100ValAto("EE9_UNIDAD") |
SAH |
|
|
!lProcReplicado |
N |
EE9_DESCON |
N |
15 |
2 |
Desconto |
@E 999,999,999,999.99 |
VAZIO() .OR. POSITIVO() |
|
R |
|
lALTERA |
N |
EE9_PRECO |
N |
16 |
7 |
Preco Unit. |
@E 99,999,999.9999999 |
POSITIVO().AND.EECVLEE9("EE9_PRECO") .And. AE100PrecoI() .AND. AP104GATPRECO() |
|
|
|
lALTERA |
N |
EE9_SLDINI |
N |
15 |
3 |
Quant.Embar. |
@E 99,999,999,999.999 |
Positivo() .AND. EECVLEE9("EE9_SLDINI") .And. AE100PrecoI() |
|
|
|
AE100W("EE9_SLDINI") .And. !lProcReplicado |
N |
EE9_PRECO2 |
N |
16 |
7 |
Preco $/60Kg |
@E 99,999,999.9999999 |
POSITIVO() .AND. AP104GATPRECO() |
|
R |
|
lALTERA |
N |
EE9_EMBAL1 |
C |
20 |
0 |
Embalagem |
|
NaoVazio().And.ExistCpo("EE5",M->EE9_EMBAL1).And.EECVLEE9("EE9_EMBAL1") |
EE5 |
|
|
AE100W("EE9_EMBAL1") .And. !lProcReplicado |
N |
EE9_PRECO3 |
N |
16 |
7 |
Preco cen/Lb |
@E 99,999,999.9999999 |
POSITIVO() .AND. AP104GATPRECO() |
|
R |
|
lALTERA |
N |
EE9_PRECO4 |
N |
16 |
7 |
Preco $/Ton |
@E 99,999,999.9999999 |
POSITIVO() .AND. AP104GATPRECO() |
|
R |
|
lALTERA |
N |
EE9_QE |
N |
13 |
3 |
Qt.na Embal. |
@E 999,999,999.999 |
Positivo().AND.EECVLEE9("EE9_QE") |
|
|
|
AE100W("EE9_QE") .And. !lProcReplicado |
N |
EE9_FPCOD |
C |
10 |
0 |
Cod.Familia |
@! |
VAZIO() .OR. EXISTCPO("SYC",M->EE9_FPCOD,1) |
SYC |
|
|
|
N |
EE9_PACKAG |
C |
60 |
0 |
Package |
@! |
|
|
|
|
|
N |
EE9_QTDEM1 |
N |
10 |
0 |
Qt.de Embal. |
@E 9,999,999,999 |
Positivo().AND.EECVLEE9("EE9_QTDEM1") |
|
|
|
lALTERA .And. !lProcReplicado |
N |
EE9_UNPRC |
C |
2 |
0 |
U.M. Preco |
|
Vazio() .Or. ExistCpo("SAH") .AND. AP104GATPRECO(, .F.) |
SAH |
|
|
lALTERA .And. !lProcReplicado |
N |
EE9_UNPES |
C |
2 |
0 |
U.M. Peso |
|
Vazio() .Or. ExistCpo("SAH") |
SAH |
|
|
lALTERA .And. !lProcReplicado |
N |
EE9_PRECOI |
N |
16 |
8 |
Preco FOB |
@E 9,999,999.99999999 |
POSITIVO() |
|
|
|
lALTERA |
N |
EE9_PSLQUN |
N |
16 |
7 |
Peso Liq.Un. |
@E 99,999,999.9999999 |
POSITIVO().AND.EECVLEE9("EE9_PSLQUN") |
|
|
|
!lProcReplicado |
N |
EE9_PSBRUN |
N |
16 |
7 |
Peso Bru.Un. |
@E 99,999,999.9999999 |
Positivo().AND.EECVLEE9("EE9_PSBRUN") |
|
|
|
!lProcReplicado |
N |
EE9_PRECO5 |
N |
16 |
7 |
Preco $/50Kg |
@E 99,999,999.9999999 |
POSITIVO() .AND. AP104GATPRECO() |
|
R |
|
lALTERA |
S |
EE9_GPCOD |
C |
15 |
0 |
Cod.Grupo |
@! |
AE100Crit("EE9_GPCOD") |
AVE011 |
|
|
|
N |
EE9_DPCOD |
C |
15 |
0 |
Cod.Divisao |
@! |
VAZIO() .OR. EXISTCPO("EEG",cSXBID+M->EE9_DPCOD,1) |
AVE013 |
|
|
|
N |
EE9_POSIPI |
C |
10 |
0 |
NCM |
@R 9999.99.99 |
Vazio() .OR.ExistCpo("SYD",M->EE9_POSIPI) |
SYD2 |
|
|
|
N |
EE9_DTQNCM |
C |
2 |
0 |
No.Destaque |
@R 99 |
EECVLEE9('EE9_DTQNCM') |
|
R |
|
|
S |
EE9_NLNCCA |
C |
7 |
0 |
NALADI NCCA |
@R 9999.99.9 |
ExistCpo("SJ2",M->EE9_NLNCCA) |
SJ2 |
|
|
|
N |
EE9_NALSH |
C |
8 |
0 |
NALADI SH |
@R 9999.99.99 |
ExistCpo("SJ1",M->EE9_NALSH) |
SJ1 |
|
|
|
N |
EE9_PSBRTO |
N |
15 |
3 |
Peso Bru.Tt. |
@E 99,999,999,999.999 |
|
|
|
|
|
N |
EE9_STATUS |
C |
1 |
0 |
Situacao |
|
|
|
|
|
|
N |
EE9_RV |
C |
9 |
0 |
Numero do RV |
@R 99/9999999 |
|
|
|
|
|
N |
EE9_DTRV |
D |
8 |
0 |
Data do RV |
|
|
|
|
|
|
N |
EE9_RE |
C |
12 |
0 |
R.E. |
@R 99/9999999-999 |
AE100CRIT("EE9_RE") |
Y6B |
|
|
|
N |
EE9_DTRE |
D |
8 |
0 |
Data R.E. |
|
AE100CRIT('EE9_DTRE') |
|
|
|
|
N |
EE9_ATOCON |
C |
13 |
0 |
Ato Conces. |
99999999999 |
AE100ValAto("EE9_ATOCON") |
ATOCON |
|
|
AE100ValAto("WHEN") |
N |
EE9_SEQED3 |
C |
3 |
0 |
Seq. A.C. |
999 |
AE100ValAto("EE9_SEQED3") |
|
|
|
AE100ValAto("WSEQ") |
N |
EE9_FINALI |
C |
3 |
0 |
Finalidade |
@! |
PERTENCE("100\310\329") |
|
|
100=Entorpecentes;329=Para Uso Nao Militar;310=Para Uso Militar |
|
N |
EE9_NRSD |
C |
20 |
0 |
Nr. S.D. |
@! |
|
|
|
|
Ae100W('EE9_NRSD') |
N |
EE9_RC |
C |
12 |
0 |
Numero do RC |
@R 99/9999999-999 |
|
|
|
|
|
N |
EE9_DTAVRB |
D |
8 |
0 |
Averb. S.D. |
|
|
|
|
|
|
N |
EE9_PRCTOT |
N |
16 |
2 |
Preco Total |
@E 9,999,999,999,999.99 |
POSITIVO() |
|
|
|
|
N |
EE9_PSLQTO |
N |
16 |
3 |
Peso Liq.Tot |
@E 999,999,999,999.999 |
|
|
|
|
|
N |
EE9_HOUSE |
C |
20 |
0 |
Conhecimento |
|
|
|
|
|
|
N |
EE9_REFCLI |
C |
20 |
0 |
Ref.Cliente |
@! |
|
|
|
|
|
N |
EE9_SEQSIS |
C |
6 |
0 |
Seq.Siscomex |
@! |
|
|
|
|
|
N |
EE9_PRCINC |
N |
16 |
2 |
Prc.Tot.FOB |
@E 9,999,999,999,999.99 |
naovazio().and.POSITIVO() |
|
|
|
|
N |
EE9_NF |
C |
9 |
0 |
Nota Fiscal |
@! |
|
|
|
|
|
N |
EE9_SERIE |
C |
3 |
0 |
Serie |
@! |
|
|
|
|
|
N |
EE9_CODAGE |
C |
6 |
0 |
Agente Com. |
@! |
EECValidAg() .And. AE100CRIT("EE9_CODAGE") |
AGE |
|
|
AE100W("EE9_CODAGE") .And. !lDtEmba |
N |
EE9_PERCOM |
N |
6 |
2 |
Comissao % |
@E 999.99 |
Positivo() .AND. EECVLEE9("EE9_PERCOM") |
|
|
|
AE100W("EE9_PERCOM") |
N |
EE9_VLCOM |
N |
16 |
2 |
Comissao |
@E 9,999,999,999,999.99 |
Positivo() .AND. EECVLEE9("EE9_VLCOM") |
|
R |
|
AP100W("EE9_VLCOM") |
N |
EE9_MAXCOM |
N |
5 |
2 |
% Comis.RE. |
@E 99.99 |
Positivo() |
|
|
|
|
N |
EE9_CODNOR |
C |
3 |
0 |
Cod.Norma |
@! |
Vazio() .Or. AC120NorVal("EE9_CODNOR") |
EXN |
|
|
|
N |
EE9_VM_NOR |
C |
60 |
0 |
Desc.Norma |
@! |
|
|
V |
|
|
N |
EE9_FASEDR |
C |
1 |
0 |
Fase Drawbac |
@! |
|
|
|
1=Pedido de Drawback;2=Ato Concessorio |
|
N |
EE9_QT_AC |
N |
15 |
5 |
Qtd. no A.C. |
@E 999,999,999.99999 |
Positivo() |
|
|
|
|
N |
EE9_VL_AC |
N |
15 |
2 |
Valor no AC |
@E 999,999,999,999.99 |
Positivo() |
|
|
|
|
N |
EE9_ISENTO |
C |
1 |
0 |
Isenc. Total |
@! |
|
|
|
1=Sim;2=Nao |
|
N |
EE9_SALISE |
N |
15 |
5 |
Saldo Isenc. |
@E 999,999,999.99999 |
|
|
|
|
|
N |
EE9_CC |
C |
5 |
0 |
Cod.Unid.Req |
@! |
If(!Empty(M->EE9_CC), ExistCpo("SY3",M->EE9_CC), .T.) |
SY3 |
|
|
|
N |
EE9_DESCCC |
C |
50 |
0 |
Unid. Req. |
@! |
|
|
V |
|
|
N |
EE9_DESCRE |
C |
6 |
0 |
Desc. RE |
@! |
|
|
|
|
|
N |
EE9_DSCAGE |
C |
40 |
0 |
Desc.Agente |
@! |
|
|
V |
|
|
N |
EE9_VM_DRE |
M |
75 |
0 |
Descr. RE |
|
|
|
V |
|
|
N |
EE9_INVPAG |
C |
20 |
0 |
Invoice Pag. |
@! |
NaoVazio().AND.AP106Valid("EE9_INVPAG") |
IVP |
|
|
|
N |
EE9_TIPCOM |
C |
1 |
0 |
Tipo Comiss. |
! |
Vazio() .Or. (Pertence("123 ") .And. EECValidAg(.f.) .And. Ae100Crit("EE9_TIPCOM")) |
|
R |
1=A Remeter;2=Conta Grafica;3=Deduzir da Fatura |
!Empty(M->EE9_CODAGE) |
N |
EE9_VLPAG |
N |
16 |
7 |
Pre. Un. Pag |
@E 99,999,999.9999999 |
NaoVazio().AND.AP106Valid("EE9_VLPAG") |
|
|
|
|
N |
EE9_CODUE |
C |
6 |
0 |
Cod.Unid.Exp |
@! |
AE100CRIT("EE9_CODUE") |
SA2 |
R |
|
|
N |
EE9_LC_NUM |
C |
20 |
0 |
Nr. L/C |
@! |
(Vazio() .Or. ExistCpo("EEL")) .And. Ae100Crit("EE9_LC_NUM") |
EEL |
R |
|
lAltera |
N |
EE9_SEQ_LC |
C |
6 |
0 |
Seq. L/C |
@ 999999 |
(Vazio() .Or. ExistCpo("EXS",M->(EE9_LC_NUM+EE9_SEQ_LC))) .And. Ae100Crit("EE9_SEQ_LC") |
EXS |
R |
|
lAltera .And. Ae100W("EE9_SEQ_LC") |
N |
EE9_LOJUE |
C |
2 |
0 |
Loj.Unid.Exp |
@! |
AE100CRIT("EE9_LOJUE") |
|
R |
|
!Empty(M->EE9_CODUE) |
N |
EE9_NOMUE |
C |
60 |
0 |
Nom.Unid.Exp |
@! |
|
|
V |
|
|
N |
EE9_AGRE |
C |
6 |
0 |
Agrup.R.E. |
@! |
|
|
R |
|
|
N |
EE9_AGSUFI |
C |
6 |
0 |
Agrup.Sufixo |
@! |
|
|
R |
|
|
N |
EE9_DTDDE |
D |
8 |
0 |
Data da DDE |
|
|
|
R |
|
|
N |
EE9_PRCUN |
N |
16 |
8 |
Prc.Un.Incot |
@E 9,999,999.99999999 |
|
|
R |
|
|
N |
EE9_VLFRET |
N |
12 |
2 |
Vl. do Frete |
@E 999,999,999.99 |
|
|
R |
|
|
N |
EE9_VLSEGU |
N |
12 |
2 |
Vl. Seguro |
@E 999,999,999.99 |
|
|
R |
|
|
N |
EE9_VLOUTR |
N |
12 |
2 |
Outras Desp. |
@E 999,999,999.99 |
|
|
R |
|
|
N |
EE9_VLDESC |
N |
12 |
2 |
Vl. Desconto |
@E 999,999,999.99 |
|
|
R |
|
|
N |
EE9_DIFERE |
N |
12 |
4 |
Diferencial |
@E 9,999,999.9999 |
|
|
V |
|
|
S |
EE9_MESFIX |
C |
6 |
0 |
Mes Fixacao |
@R 99/9999 |
|
|
R |
|
lAltera |
N |
EE9_FATIT |
C |
2 |
0 |
Item do PV |
|
|
|
R |
|
|
S |
EE9_TES |
C |
3 |
0 |
Tipo Saida |
@9 |
NaoVazio() .And. ExistCpo('SF4') |
SF4 |
R |
|
|
N |
EE9_CF |
C |
5 |
0 |
Cod. Fiscal |
@9 |
NaoVazio() |
|
R |
|
|
N |
EE9_VLSCOB |
N |
16 |
8 |
Vl.Tot.S Cob |
@E 9,999,999.99999999 |
Positivo() |
|
|
|
.F. |
N |
EE9_ID |
C |
10 |
0 |
ID |
|
|
|
R |
|
|
N |
EE9_SEQRE |
C |
5 |
0 |
Seq. |
|
|
|
R |
|
|
N |
EE9_CODOPE |
C |
2 |
0 |
Cod. Ope. Es |
@! |
ValidOpe('EE9_CODOPE') |
EJ0 |
|
|
lALTERA |
S |
EE9_DESOPE |
C |
60 |
0 |
Desc. Op. Es |
@! |
|
|
V |
|
|
S |
EE9_CATCOT |
C |
6 |
0 |
Cat.Cota |
|
ExistCpo('SX5','YY'+M->EE9_CATCOT) |
YY |
|
|
|
S |
EE9_DINTCD |
C |
6 |
0 |
Desc. Inttra |
@! |
|
|
R |
|
|
N |
EE9_DINT |
M |
60 |
0 |
Desc. Inttra |
@! |
E_MSMM(EE9->EE9_DINTCD,60) |
|
V |
|
|
N |
EE9_PERIE |
N |
6 |
2 |
% IE |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->EE9_PERIE) |
|
R |
|
|
S |
EE9_BASIE |
N |
15 |
2 |
Base Calc.IE |
@E 999,999,999,999.99 |
POSITIVO() |
|
R |
|
|
S |
EE9_VLRIE |
N |
15 |
2 |
Vlr Rec IE |
@E 999,999,999,999.99 |
POSITIVO() |
|
R |
|
|
S |
EE9_SDOC |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |
EE9_PCARGA |
C |
4 |
0 |
Pr. Carga |
@! |
|
EVN05 |
R |
|
|
S |
EE9_DESPCA |
C |
30 |
0 |
Desc Pri Car |
@! |
|
|
V |
|
|
S |
EE9_OBSPCA |
M |
80 |
0 |
Obs.Pr.Car |
@! |
|
|
R |
|
|
S |
EE9_JUSDUE |
C |
100 |
0 |
Just. DUE |
@! |
|
|
R |
|
|
S |
EE9_LPCO |
C |
11 |
0 |
LPCO |
@! |
|
|
R |
|
|
S |
EE9_TPAC |
C |
1 |
0 |
Tipo Ato |
|
|
|
|
A=Comum;B=Generico;C=Intermediario;D=Interm. Gen. |
|
S |