Tabela |
GV8 |
ROTA DA TABELA DE FRETE |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
GV8_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
GV8_CDEMIT |
C |
14 |
0 |
Emitente |
@! |
|
GU3GVA |
R |
|
.F. |
S |
GV8_NMEMIT |
C |
80 |
0 |
Nome |
|
|
|
V |
|
|
S |
GV8_NRTAB |
C |
6 |
0 |
Tabela |
999999 |
|
GVA2 |
R |
|
.F. |
S |
GV8_DSTAB |
C |
50 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
GV8_NRNEG |
C |
6 |
0 |
Negociacao |
999999 |
|
GV9 |
R |
|
.F. |
S |
GV8_NRROTA |
C |
4 |
0 |
Rota |
9999 |
|
|
R |
|
|
S |
GV8_PRIROT |
N |
2 |
0 |
Prioridade |
99 |
|
|
R |
|
|
S |
GV8_TPORIG |
C |
1 |
0 |
Tipo Origem |
@! |
Pertence("012345") .AND. GFE61ROTO() |
|
R |
0=Todos;1=Cidade;2=Distancia;3=Regiao;4=Pais/UF;5=Remetente |
GFE61ROTO() |
S |
GV8_NRCIOR |
C |
7 |
0 |
Cid. Origem |
9999999 |
Vazio() .OR. GFEExistC("GU7",1,M->GV8_NRCIOR,"GU7->GU7_SIT=='1'") |
GU7GUA |
R |
|
GFE61ROW() |
S |
GV8_DSCIOR |
C |
50 |
0 |
Ds Cid Orig |
@! |
|
|
V |
|
|
S |
GV8_DSTORI |
N |
15 |
5 |
Dst.Ori.Ini. |
@E 999,999,999.99999 |
|
|
R |
|
GFE61ROW() |
S |
GV8_DSTORF |
N |
15 |
5 |
Dst.Ori.Fin. |
@E 999,999,999.99999 |
|
|
R |
|
GFE61ROW() |
S |
GV8_NRREOR |
C |
6 |
0 |
Reg. Origem |
999999 |
Vazio() .OR. GFEExistC("GU9",1,M->GV8_NRREOR,"GU9->GU9_SIT=='1'") |
GU9GUA |
R |
|
GFE61ROW() |
S |
GV8_DSREOR |
C |
50 |
0 |
Ds Reg Orig |
@! |
|
|
V |
|
|
S |
GV8_CDPAOR |
C |
3 |
0 |
Pais Origem |
@! |
Vazio() .OR. ExistCpo("SYA",M->GV8_CDPAOR) |
SYA |
R |
|
GFE61ROW() |
S |
GV8_DSPAOR |
C |
50 |
0 |
Ds Pais Orig |
@! |
|
|
V |
|
|
S |
GV8_CDUFOR |
C |
2 |
0 |
UF Origem |
@! |
Vazio() .OR. ExistCpo("SX5","12"+M->GV8_CDUFOR) |
12 |
R |
|
GFE61ROW() |
S |
GV8_CDFIOR |
C |
2 |
0 |
Fil. Origem |
@! |
EXISTCPO("SM0",SM0->M0_CODIGO+M->GV8_CDFIOR) |
DLB |
R |
|
GFE61ROW() |
S |
GV8_TPDEST |
C |
1 |
0 |
Tipo Destino |
@! |
Pertence("012345") .AND. GFE61ROTO() |
|
R |
0=Todos;1=Cidade;2=Distancia;3=Regiao;4=Pais/UF;5=Destinatario |
GFE61ROTO() |
S |
GV8_NRCIDS |
C |
7 |
0 |
Cid. Destino |
9999999 |
Vazio() .OR. GFEExistC("GU7",1,M->GV8_NRCIDS,"GU7->GU7_SIT=='1'") |
GU7GUA |
R |
|
GFE61ROW() |
S |
GV8_DSCIDS |
C |
50 |
0 |
Ds Cid Dest |
@! |
|
|
V |
|
|
S |
GV8_DSTDEI |
N |
15 |
5 |
Dst.Des.Ini. |
@E 999,999,999.99999 |
|
|
R |
|
GFE61ROW() |
S |
GV8_DSTDEF |
N |
15 |
5 |
Dst.Des.Fin. |
@E 999,999,999.99999 |
|
|
R |
|
GFE61ROW() |
S |
GV8_NRREDS |
C |
6 |
0 |
Reg. Destino |
999999 |
Vazio() .OR. GFEExistC("GU9",1,M->GV8_NRREDS,"GU9->GU9_SIT=='1'") |
GU9GUA |
R |
|
GFE61ROW() |
S |
GV8_DSREDS |
C |
50 |
0 |
Ds Reg Dest |
@! |
|
|
V |
|
|
S |
GV8_CDPADS |
C |
3 |
0 |
Pais Destino |
@! |
Vazio() .OR. ExistCpo("SYA",M->GV8_CDPADS) |
SYA |
R |
|
GFE61ROW() |
S |
GV8_DSPADS |
C |
50 |
0 |
Ds Pais Dest |
@! |
|
|
V |
|
|
S |
GV8_CDUFDS |
C |
2 |
0 |
UF Destino |
@! |
Vazio() .OR. ExistCpo("SX5","12"+M->GV8_CDUFDS) |
12 |
R |
|
GFE61ROW() |
S |
GV8_CDFIDS |
C |
2 |
0 |
Fil. Destino |
@! |
EXISTCPO("SM0",SM0->M0_CODIGO+M->GV8_CDFIDS) |
DLB |
R |
|
GFE61ROW() |
S |
GV8_DUPSEN |
C |
1 |
0 |
Ida e Volta |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
GV8_PCDEV |
N |
9 |
5 |
% Devolucao |
@E 999.99999 |
Positivo() |
|
R |
|
|
S |
GV8_PCREEN |
N |
9 |
5 |
% Reentrega |
@E 999.99999 |
Positivo() |
|
R |
|
|
S |
GV8_VLMXRE |
N |
12 |
2 |
Max. Reentr. |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
GV8_CDREM |
C |
14 |
0 |
Cod Remet |
@! |
EXISTCPO("GU3",M->GV8_CDREM) |
GU3 |
R |
|
GFE61ROW() |
S |
GV8_NMREM |
C |
80 |
0 |
Nome Remet |
|
|
|
V |
|
|
S |
GV8_CDDEST |
C |
14 |
0 |
Cod Destin |
@! |
EXISTCPO("GU3",M->GV8_CDDEST) |
GU3 |
R |
|
GFE61ROW() |
S |
GV8_NMDEST |
C |
80 |
0 |
Nome Destin |
|
|
|
V |
|
|
S |
GV8_VLMINR |
N |
6 |
2 |
Min.Reentr |
@E 999.99 |
|
|
R |
|
|
S |
GV8_TRPREE |
C |
14 |
0 |
Transp.Reent |
@! |
|
GU3FRN |
R |
|
|
S |