Tabela |
EE7 |
Processo de Exportacao |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
EE7_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
EE7_PEDIDO |
C |
20 |
0 |
Pedido |
@! |
NaoVazio() .And. ExistChav("EE7") .And. Ap100Crit("EE7_PEDIDO") |
|
R |
|
lAltera |
N |
EE7_PEDFAT |
C |
6 |
0 |
Ped.de Venda |
@X |
|
|
|
|
|
N |
EE7_DTPROC |
D |
8 |
0 |
Dt.Processo |
|
|
|
|
|
lALTERA |
N |
EE7_DTPEDI |
D |
8 |
0 |
Dt.Pedido |
|
AP100CRIT("EE7_DTPEDI") |
|
|
|
lALTERA |
N |
EE7_VM_AMO |
C |
3 |
0 |
Amostra |
|
|
|
V |
|
|
N |
EE7_AMOSTR |
C |
1 |
0 |
Amostra |
@! |
PERTENCE('124').AND.AP100CRIT('EE7_AMOSTR') |
|
|
1=Sim – Sem Faturamento;2=Nao;4=Sim – Com Faturamento |
lALTERA |
N |
EE7_FIM_PE |
D |
8 |
0 |
Finalizado |
|
|
|
|
|
.F. |
N |
EE7_DTSLCR |
D |
8 |
0 |
Dt.Solic.Cr. |
|
IF(!EMPTY(M->EE7_DTSLCR),M->EE7_DTSLCR>=M->EE7_DTPEDI,.T.) |
|
|
|
AP100W("EE7_DTSLCR") |
N |
EE7_ENVAMO |
C |
1 |
0 |
Env.Amostra? |
|
Pertence("12") |
|
R |
1=Sim; 2=Nao |
|
N |
EE7_DTAPCR |
D |
8 |
0 |
Dt.Apr.Cred. |
|
AP100CRIT("EE7_DTAPCR") |
|
|
|
lAPROVA |
N |
EE7_STATUS |
C |
1 |
0 |
Status |
|
DSCSITEE7() |
|
|
|
lALTERA |
N |
EE7_IMPORT |
C |
6 |
0 |
Cod. Import. |
@! |
AP100CRIT("EE7_IMPORT").And.AP100Crit("EE7_MARCAC") |
AVE001 |
|
|
AP100W("EE7_IMPORT") |
N |
EE7_IMLOJA |
C |
2 |
0 |
Loja Import. |
@! |
ExistCpo("SA1",M->EE7_IMPORT+M->EE7_IMLOJA).And.AP100Crit("EE7_MARCAC").AND.AP100CRIT("EE7_IMLOJA") |
|
|
|
lALTERA |
N |
EE7_IMPODE |
C |
60 |
0 |
Importador |
|
|
|
|
|
lALTERA |
N |
EE7_TABPRE |
C |
4 |
0 |
Tab.Pre-Calc |
@! |
Vazio() .or. ExistCpo("SWF", M->EE7_TABPRE) |
SWF |
R |
|
LALTERA |
N |
EE7_STTDES |
C |
60 |
0 |
Status |
|
|
|
|
|
lALTERA |
N |
EE7_MOTSIT |
C |
15 |
0 |
Situacao |
|
Vazio() .Or. AP100CRIT("EE7_MOTSIT") |
EE4 |
|
|
|
N |
EE7_DSCMTS |
C |
60 |
0 |
Dsc.Situacao |
|
|
|
V |
|
|
N |
EE7_ENDIMP |
C |
100 |
0 |
End. Import. |
@! |
|
|
|
|
lALTERA |
N |
EE7_END2IM |
C |
100 |
0 |
Comp.End. |
@! |
|
|
|
|
lALTERA |
N |
EE7_REFIMP |
C |
40 |
0 |
Ref.Import. |
@! |
AP100Crit("EE7_MARCAC") |
|
|
|
lALTERA |
N |
EE7_EXLIMP |
C |
1 |
0 |
Exige L.I. |
@! |
PERTENCE("12") |
|
|
1=Sim;2=Nao |
lALTERA |
N |
EE7_LICIMP |
C |
60 |
0 |
Licenc.Imp. |
@! |
|
|
|
|
lALTERA |
N |
EE7_DTLIMP |
D |
8 |
0 |
Prazo L.I. |
|
|
|
|
|
lALTERA |
N |
EE7_CLIENT |
C |
6 |
0 |
Cod.Cliente |
@! |
AP100CRIT("EE7_CLIENT") .AND. AP100Crit("EE7_MARCAC") |
AVE002 |
|
|
AP100W("EE7_CLIENT") |
N |
EE7_INTERM |
C |
1 |
0 |
OffShore? |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
LALTERA |
N |
EE7_CLLOJA |
C |
2 |
0 |
Loja Cliente |
@! |
AP100CRIT("EE7_CLLOJA") .AND. AP100Crit("EE7_MARCAC") |
|
|
|
lALTERA |
N |
EE7_DIAS2 |
N |
3 |
0 |
Dias Pagto. |
999 |
ExistCpo("SY6",M->EE7_COND2+Str(M->EE7_DIAS2,AVSX3("EE7_DIAS2",3)),1) |
|
|
|
M->EE7_INTERM="1" |
N |
EE7_COND2 |
C |
5 |
0 |
Cond.Pagto. |
@! |
ExistCpo("SY6",M->EE7_COND2,1) |
SY6 |
|
|
M->EE7_INTERM="1" |
N |
EE7_CLIEDE |
C |
30 |
0 |
Client.Final |
|
|
|
V |
|
lALTERA |
N |
EE7_INCO2 |
C |
3 |
0 |
Incoterm |
@! |
ExistCpo("SYJ",M->EE7_INCO2) |
SYJ |
|
|
M->EE7_INTERM="1" |
N |
EE7_FOLOJA |
C |
2 |
0 |
Loja Fornec. |
@! |
AP100CRIT("EE7_FOLOJA") .AND. AP100Crit("EE7_MARCAC") |
|
|
|
lALTERA |
N |
EE7_FORN |
C |
6 |
0 |
Cod.Fornec. |
@! |
AP100CRIT("EE7_FORN") .And. AP100Crit("EE7_MARCAC") |
AVE005 |
|
|
AP100W("EE7_FORN") |
N |
EE7_FORNDE |
C |
60 |
0 |
Fornecedor |
@! |
|
|
V |
|
lALTERA |
N |
EE7_RESPON |
C |
35 |
0 |
Anal. Resp. |
@! |
|
AVE008 |
|
|
AP100W("EEC_RESPON") |
N |
EE7_EXPORT |
C |
6 |
0 |
Cod.Export. |
@! |
AP100CRIT("EE7_EXPORT") .AND. AP100Crit("EE7_MARCAC") |
AVE006 |
|
|
AP100W("EE7_EXPORT") |
N |
EE7_EXLOJA |
C |
2 |
0 |
Loja Export. |
@! |
AP100CRIT("EE7_EXLOJA") .AND. AP100Crit("EE7_MARCAC") |
|
|
|
lALTERA |
N |
EE7_EXPODE |
C |
30 |
0 |
Exportador |
|
|
|
V |
|
lALTERA |
N |
EE7_CONSIG |
C |
6 |
0 |
Cod.Consign. |
@! |
Vazio() .OR. ExistCpo("SA1",M->EE7_CONSIG+IF(!EMPTY(M->EE7_COLOJA),M->EE7_COLOJA,"")).AND.AP100CRIT("EE7_MARCAC") |
AVE003 |
|
|
AP100W("EE7_CONSIG") |
N |
EE7_COLOJA |
C |
2 |
0 |
Loja Consig. |
@! |
AP100CRIT("EE7_COLOJA") .AND. AP100Crit("EE7_MARCAC") |
|
|
|
lALTERA |
N |
EE7_CONSDE |
C |
30 |
0 |
Consignee |
|
|
|
V |
|
lALTERA |
N |
EE7_BELOJA |
C |
2 |
0 |
Loja Benef. |
@! |
AP100CRIT("EE7_BELOJA") .AND. AP100Crit("EE7_MARCAC") |
|
|
|
lALTERA |
N |
EE7_BENEF |
C |
6 |
0 |
Cod.Benef. |
@! |
AP100CRIT("EE7_BENEF") .AND. AP100Crit("EE7_MARCAC") |
AVE007 |
|
|
AP100W("EE7_BENEF") |
N |
EE7_BENEDE |
C |
60 |
0 |
Beneficiario |
@! |
|
|
|
|
lALTERA |
N |
EE7_ENDBEN |
C |
100 |
0 |
End.Benef. |
@! |
|
|
|
|
lALTERA |
N |
EE7_END2BE |
C |
100 |
0 |
Comp.End. |
@! |
|
|
|
|
lALTERA |
N |
EE7_CONDPA |
C |
5 |
0 |
Cond. Pagto |
@! |
ExistCpo("SY6",M->EE7_CONDPA,1) .And. Ap100Crit("EE7_CONDPA") |
SY6 |
|
|
lALTERA |
N |
EE7_DIASPA |
N |
3 |
0 |
Dias Pagto |
999 |
ExistCpo("SY6",M->EE7_CONDPA+Str(M->EE7_DIASPA,AVSX3("EE7_DIASPA",3)),1) |
|
|
|
lALTERA |
N |
EE7_DESCPA |
C |
60 |
0 |
Descricao |
|
|
|
V |
|
lALTERA |
N |
EE7_MPGEXP |
C |
3 |
0 |
Mod.Pgto.Exp |
@! |
EXISTCPO("EEF",M->EE7_MPGEXP) |
EEF |
|
|
lALTERA |
N |
EE7_DSCMPE |
C |
52 |
0 |
Descricao |
@! |
|
|
V |
|
lALTERA |
N |
EE7_INCOTE |
C |
3 |
0 |
Incoterm |
@! |
ExistCpo("SYJ",M->EE7_INCOTE) |
SYJ |
|
|
lALTERA |
N |
EE7_VIA |
C |
2 |
0 |
Via Transp. |
|
NaoVazio() .And. Ap100Crit("EE7_VIA") |
SYQ |
|
|
lALTERA |
N |
EE7_VIA_DE |
C |
50 |
0 |
Descr.da Via |
@! |
|
|
V |
|
lALTERA |
N |
EE7_ORIGEM |
C |
3 |
0 |
Origem |
@! |
NaoVazio() .And. Ap100Crit("EE7_ORIGEM") |
EV7 |
|
|
AP100W("EE7_ORIGEM") |
N |
EE7_DSCORI |
C |
25 |
0 |
Desc.Origem |
@! |
|
|
V |
|
lALTERA |
N |
EE7_DEST |
C |
3 |
0 |
Destino |
@! |
NaoVazio() .And. Ap100Crit("EE7_DEST") .AND. AP100CRIT("EE7_MARCAC") .AND. AP100CRIT("EE7_DEST") |
EV7 |
|
|
AP100W("EE7_DEST") |
N |
EE7_DSCDES |
C |
25 |
0 |
Desc.Destino |
@! |
|
|
V |
|
lALTERA |
N |
EE7_PAISET |
C |
3 |
0 |
Pais Entrega |
@! |
Existcpo("SYA") .And. AP100Crit("EE7_PAISET",,.F.) |
SYA |
R |
|
lAltera |
N |
EE7_TIPTRA |
C |
1 |
0 |
Tipo Transp. |
9 |
NaoVazio() .And. PERTENCE("123").And. Ap100Crit("EE7_TIPTRA") |
|
|
1=Cheio;2=Picados;3=Carga Solta |
AP100W("EE7_TIPTRA") |
N |
EE7_CODMAR |
C |
6 |
0 |
Cod.Mem.Marc |
|
|
|
|
|
lALTERA |
N |
EE7_MARCAC |
M |
20 |
0 |
Marcacao |
|
|
|
V |
|
lALTERA |
N |
EE7_MOEDA |
C |
3 |
0 |
Moeda Neg. |
@! |
NaoVazio().AND.EXISTCPO("SYF") |
SYF |
|
|
lALTERA |
N |
EE7_PESLIQ |
N |
15 |
3 |
Peso Liquid. |
@E 99,999,999,999.999 |
|
|
|
|
lALTERA |
N |
EE7_PESBRU |
N |
15 |
2 |
Peso Bruto |
@E 999,999,999,999.99 |
|
|
|
|
lALTERA |
N |
EE7_TOTITE |
N |
15 |
2 |
Total Itens |
@E 999,999,999,999.99 |
|
|
|
|
lALTERA |
N |
EE7_TIPSEG |
C |
1 |
0 |
Tipo Vl.Seg. |
|
PERTENCE("12") |
|
R |
1=Percentual;2=Valor Fixo |
|
N |
EE7_FRPPCC |
C |
2 |
0 |
Tipo Frete |
@! |
|
|
|
CC=Collect;PP=Prepaid |
lALTERA |
N |
EE7_FRPREV |
N |
15 |
2 |
Frete Prev. |
@E 999,999,999,999.99 |
(Vazio() .or. AP100Crit("EE7_FRPREV")) .and. AP100PrecoI(.T.) |
|
|
|
lALTERA |
N |
EE7_FRPCOM |
N |
15 |
2 |
Frete Adic. |
@E 999,999,999,999.99 |
AP100PrecoI(.T.) |
|
|
|
lALTERA |
N |
EE7_FREEMB |
N |
15 |
2 |
Fre. Embut. |
@E 999,999,999,999.99 |
Vazio() .Or. Positivo() |
|
R |
|
lAltera |
N |
EE7_SEGPRE |
N |
15 |
2 |
Seguro Prev. |
@E 999,999,999,999.99 |
(Vazio() .or. AP100Crit("EE7_SEGPRE")) .and. AP100PrecoI(.T.) |
|
|
|
lALTERA .And. AP100W("EE7_SEGPRE") |
N |
EE7_SEGURO |
N |
15 |
7 |
Seguro % |
@E 9,999,999.9999999 |
AP100CRIT("EE7_SEGURO") |
|
|
|
lALTERA .And. AP100W("EE7_SEGURO") |
N |
EE7_TEMLC |
C |
1 |
0 |
Tem L/C |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
lALTERA |
N |
EE7_TOTPED |
N |
15 |
2 |
Total Pedido |
@E 999,999,999.99 |
|
|
|
|
lALTERA |
N |
EE7_DESPIN |
N |
15 |
2 |
Desp.Interna |
@E 999,999,999.99 |
(Vazio() .or. Positivo()) .and. AP100PrecoI(.T.) |
|
|
|
lALTERA |
N |
EE7_DESCON |
N |
15 |
2 |
Desconto |
@E 999,999,999.99 |
POSITIVO().AND.AP100PRECOI() |
|
|
|
LALTERA .AND. !LDESCIT |
N |
EE7_PRECOA |
C |
1 |
0 |
Preco Ab. |
@! |
PERTENCE("12") .And. AP100PrecoI() |
|
|
1=Sim;2=Nao |
lALTERA |
N |
EE7_EMBAFI |
C |
20 |
0 |
Volume |
@! |
Vazio().Or.EXISTCPO("EE5") |
EE5 |
|
|
lALTERA |
N |
EE7_CALCEM |
C |
1 |
0 |
Calc.Embalag |
@! |
NaoVazio() .And. Pertence("12") |
|
|
1=Volume;2=Quantidade |
lALTERA |
N |
EE7_DTPGAN |
D |
8 |
0 |
Dt. Pgo.Ant. |
@D |
|
|
|
|
M->EE7_PGTANT=="1" |
N |
EE7_CUBAGE |
N |
15 |
4 |
Cubagem |
@E 9,999,999,999.9999 |
|
|
|
|
lALTERA |
N |
EE7_IDIOMA |
C |
25 |
0 |
Idioma Doc. |
@! |
NaoVazio().AND.EECDSIDIOMA("M->EE7_IDIOMA") |
ID |
|
|
lALTERA |
N |
EE7_SL_LC |
D |
8 |
0 |
Dt.Sol.L/C |
|
|
|
|
|
lALTERA |
N |
EE7_LC_NUM |
C |
20 |
0 |
No. L/C |
@! |
(Vazio() .Or. EXISTCPO("EEL",M->EE7_LC_NUM)) .And. AP100Crit("EE7_LC_NUM") |
EEL |
|
|
lALTERA |
N |
EE7_SL_EME |
D |
8 |
0 |
Dt.Sl.Emenda |
|
|
|
|
|
lALTERA |
N |
EE7_PGTANT |
C |
1 |
0 |
Pagto Antec. |
@! |
PERTENCE("12") |
|
|
1=Sim;2=Nao |
lALTERA |
N |
EE7_TIPCOM |
C |
1 |
0 |
Tipo Comis. |
! |
Pertence("123 ") |
|
|
1=A Remeter;2=Conta Grafica;3=Deduzir da Fatura |
LALTERA |
N |
EE7_TIPCVL |
C |
1 |
0 |
Tipo Vl.Com. |
! |
Pertence("123 ") |
|
|
1=Percentual;2=Valor Fixo;3=Percentual por Item |
lALTERA |
N |
EE7_VALCOM |
N |
15 |
4 |
Comissao |
@E 9,999,999,999.9999 |
Positivo() .and. AP100Crit("EE7_VALCOM") |
|
|
|
AP100W("EE7_VALCOM") |
N |
EE7_REFAGE |
C |
20 |
0 |
Ref.Agente |
@! |
|
|
|
|
lALTERA |
N |
EE7_DSCGEN |
C |
6 |
0 |
Desc.Gen.Pr. |
@! |
|
|
|
|
lALTERA |
N |
EE7_GENERI |
M |
60 |
0 |
Desc.Gen.Pr. |
|
|
|
V |
|
lALTERA |
N |
EE7_CODOBP |
C |
6 |
0 |
Cod.Mem.Ped. |
|
|
|
|
|
lALTERA |
N |
EE7_OBSPED |
M |
60 |
0 |
Obs.Doctos |
|
|
|
V |
|
lALTERA |
N |
EE7_CODMEM |
C |
6 |
0 |
Codigo Memo |
|
|
|
|
|
|
N |
EE7_OBS |
M |
60 |
0 |
Observacao |
|
|
|
V |
|
|
N |
EE7_BRUEMB |
C |
1 |
0 |
Ps.Br.XEmb. |
@! |
PERTENCE("12") |
|
|
1=Sim;2=Nao |
lALTERA |
N |
EE7_FATURA |
D |
8 |
0 |
Dt.Faturam. |
|
|
|
|
|
|
N |
EE7_QTD40H |
N |
10 |
0 |
Qtd.Con.40HC |
@E 9,999,999,999 |
Positivo() |
|
R |
|
LALTERA |
N |
EE7_DSCCOM |
C |
100 |
0 |
Comissao |
|
|
|
V |
|
|
N |
EE7_QTD20 |
N |
10 |
0 |
Qtd.Cont. 20 |
@E 9,999,999,999 |
Positivo() |
|
R |
|
LALTERA |
N |
EE7_INTEGR |
C |
1 |
0 |
Integrado |
@! |
|
|
R |
|
|
N |
EE7_QTD40 |
N |
10 |
0 |
Qtd.Cont. 40 |
@E 9,999,999,999 |
Positivo() |
|
R |
|
LALTERA |
N |
EE7_DECQTD |
N |
1 |
0 |
Dec. Qtde. |
9 |
|
|
|
|
lALTERA |
N |
EE7_DECPRC |
N |
1 |
0 |
Dec. Preco |
9 |
|
|
|
|
lALTERA |
N |
EE7_DECPES |
N |
1 |
0 |
Dec. Peso |
9 |
|
|
|
|
lALTERA |
N |
EE7_TIPO |
C |
1 |
0 |
Tipo de Ped. |
|
|
|
R |
|
|
N |
EE7_FUMIGA |
N |
15 |
4 |
Fumigation |
@E 9,999,999,999.9999 |
|
|
R |
|
|
N |
EE7_PERC |
N |
5 |
2 |
%OffShore |
@E 99.99 |
Positivo() |
|
|
|
M->EE7_INTERM="1" |
N |
EE7_UNIDAD |
C |
2 |
0 |
U.M. Peso |
|
Vazio() .Or. ExistCpo("SAH") |
SAH |
|
|
lALTERA |
N |
EE7_CODBOL |
C |
3 |
0 |
Cod. Bolsa |
@! |
NaoVazio() .And. ExistCpo("SX5","YP"+M->EE7_CODBOL) |
|
R |
|
|
N |
EE7_MODEST |
C |
1 |
0 |
Mod. Estuf. |
@! |
|
|
R |
1=FCL-Responsabilidade do Exportador; 2=LCL-Responsabilidade do Armador |
LALTERA |
N |
EE7_DSCBOL |
C |
60 |
0 |
Desc. Bolsa |
|
|
YP |
V |
|
|
N |
EE7_OPCFIX |
C |
1 |
0 |
Opc. Fixacao |
|
Pertence("SB") |
|
R |
S=Seller; B=Buyer |
|
N |
EE7_CONDFI |
C |
2 |
0 |
Cond.Fixacao |
@! |
ExistCpo("EY0") |
EY0 |
R |
|
|
N |
EE7_DSCFIX |
C |
60 |
0 |
Dsc.Cond.Fix |
|
|
|
V |
|
|
N |
EE7_KEY |
N |
10 |
0 |
Seq.Ord. |
9999999999 |
|
|
|
|
|
S |
EE7_DSCORG |
N |
15 |
2 |
Descon. Orig |
@E 999,999,999,999.99 |
|
|
R |
|
|
N |
EE7_SPOT |
C |
1 |
0 |
Venda Spot? |
|
|
|
R |
1=Sim; 2=Nao |
.F. |
N |
EE7_ID_CR |
C |
10 |
0 |
ID WF CR |
@! |
|
|
R |
|
|
S |
EE7_ID_AP |
C |
10 |
0 |
ID WF AP |
@! |
|
|
R |
|
|
S |
EE7_TPDESC |
C |
1 |
0 |
Tp. Desconto |
@! |
AE100CRIT('EE7_TPDESC') |
|
R |
1=Subtrai; 2=Soma |
M->EE7_PRECOA == "2" |
S |
EE7_VLFOB |
N |
16 |
2 |
Total FOB |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
N |
EE7_PEDERP |
C |
20 |
0 |
Pedido ERP |
@! |
|
|
R |
|
|
S |
EE7_TOTFOB |
N |
15 |
2 |
Total FOB |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
EE7_TOTLIQ |
N |
15 |
2 |
Total Liquid |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
EE7_DESSEG |
C |
1 |
0 |
Desc. Seg. |
@! |
AP100CRIT("EE7_DESSEG") |
|
R |
1=Sim;2=Nao |
M->EE7_PRECOA == "1" |
S |
EE7_DTSLAP |
D |
8 |
0 |
Dt.Sol.Ap.Pr |
|
AP100CRIT("EE7_DTSLAP") |
|
|
|
AP100W("EE7_DTSLAP") |
S |
EE7_DTAPPE |
D |
8 |
0 |
Dt.Aprv.Prof |
|
AP100CRIT("EE7_DTAPPE") |
|
|
|
|
S |