Tabela |
GUN |
Prazos e Distancia |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
GUN_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
GUN_CODTAB |
C |
5 |
0 |
Cod Tabela |
99999 |
|
|
R |
|
|
S |
GUN_TPTAB |
C |
1 |
0 |
Tipo Tabela |
|
Pertence("1234") |
|
R |
1=Prazo;2=Distancia;3=Quebra Peso;4=Frete Referencia |
|
S |
GUN_DUPSEN |
C |
1 |
0 |
Ida e Volta |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
GUN_DATDE |
D |
8 |
0 |
Ini Validade |
|
|
|
R |
|
|
S |
GUN_DATATE |
D |
8 |
0 |
Fim Validade |
|
|
|
R |
|
|
S |
GUN_NRCIOR |
C |
7 |
0 |
Cid Origem |
9999999 |
|
GU7GUA |
R |
|
|
S |
GUN_NRREOR |
C |
6 |
0 |
Reg Origem |
999999 |
|
GU9GUA |
R |
|
|
S |
GUN_CDREM |
C |
14 |
0 |
Remetente |
@! |
|
GU3 |
R |
|
|
S |
GUN_NRCIDS |
C |
7 |
0 |
Cid Dest |
9999999 |
|
GU7GUA |
R |
|
|
S |
GUN_NRREDS |
C |
6 |
0 |
Reg Dest |
999999 |
|
GU9GUA |
R |
|
|
S |
GUN_CDDEST |
C |
14 |
0 |
Destinatario |
@! |
|
GU3 |
R |
|
|
S |
GUN_INFRTO |
C |
120 |
0 |
Rota Origem |
@! |
|
|
V |
|
|
S |
GUN_INFRTD |
C |
120 |
0 |
Rota Destino |
@! |
|
|
V |
|
|
S |
GUN_CDTPOP |
C |
10 |
0 |
Tipo Oper |
@! |
GFEExistC("GV4",,,"GV4->GV4_SIT=='1'") .OR. Vazio() |
GV4 |
R |
|
|
S |
GUN_DSTPOP |
C |
50 |
0 |
Desc Tp Op |
|
|
|
V |
|
|
S |
GUN_CDTPVC |
C |
10 |
0 |
Tipo Veiculo |
@! |
|
GV3 |
R |
|
|
S |
GUN_DSTPVC |
C |
50 |
0 |
Desc Tp Veic |
|
|
|
V |
|
|
S |
GUN_CDGRP |
C |
4 |
0 |
Cod Grupo |
|
GFEExistC("GU1",1,M->GUN_CDGRP,"GU1->GU1_SIT=='1' .And. GU1->GU1_TPGRP=='2'") .Or. Vazio() |
GU1GER |
R |
|
|
S |
GUN_DSGRP |
C |
50 |
0 |
Grupo Transp |
|
|
|
V |
|
|
S |
GUN_CDTRP |
C |
14 |
0 |
Transp |
@! |
GFEExistC("GU3",,,"(GU3->GU3_TRANSP=='1'.OR.GU3->GU3_AUTON=='1').AND.GU3->GU3_SIT=='1'") .OR. Vazio() |
GU3TRP |
R |
|
|
S |
GUN_NMTRP |
C |
80 |
0 |
Nome Transp |
|
|
|
V |
|
|
S |
GUN_MODAL |
C |
1 |
0 |
Modal |
|
Pertence("1;2;3;4;5;6;7") |
|
R |
1=Indiferente;2=Rodoviario;3=Ferroviario;4=Aereo;5=Aquaviario;6=Dutoviario;7=Multimodal |
|
S |
GUN_TPPRAZ |
C |
1 |
0 |
Tipo Prazo |
|
Pertence("012") |
|
R |
0=Dias Uteis;1=Dias Corridos;2=Horas |
M->GUN_TPTAB == "1" .Or. M->GUN_TPTAB == "4" |
S |
GUN_PRAZO |
N |
3 |
0 |
Prazo |
999 |
|
|
R |
|
M->GUN_TPTAB == "1" .Or. M->GUN_TPTAB == "4" |
S |
GUN_DMEST |
N |
6 |
1 |
Dist Estimad |
@E 9,999.9 |
|
|
R |
|
M->GUN_TPTAB == "2" |
S |
GUN_PRIOR |
N |
3 |
0 |
Prioridade |
999 |
|
|
R |
|
|
S |
GUN_CDCLFR |
C |
4 |
0 |
Class Frete |
@! |
ALLTRIM(M->GUN_CDCLFR)=="".OR.GFEExistC("GUB",,M->GUN_CDCLFR,"GUB->GUB_SIT=='1'") |
GUB |
R |
|
|
S |
GUN_DSCLFR |
C |
50 |
0 |
Desc Class |
@! |
|
|
V |
|
|
S |
GUN_MAXQBR |
N |
5 |
2 |
% Max Quebra |
@E 99.99 |
|
|
R |
|
|
S |
GUN_FRTPES |
N |
8 |
2 |
Frete Peso |
@E 99,999.99 |
|
|
R |
|
|
S |
GUN_PERIMP |
N |
5 |
2 |
Aliq Imposto |
@E 99.99 |
|
|
R |
|
|
S |
GUN_ENVIAE |
C |
1 |
0 |
Soli Cot |
9 |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
GUN_EMAIL |
C |
50 |
0 |
Email |
@! |
|
|
R |
|
|
S |
GUN_PERIOD |
N |
2 |
0 |
Periodo |
99 |
|
|
R |
|
|
S |
GUN_STATUS |
C |
1 |
0 |
Sit Solicit |
9 |
Pertence("0123") |
|
R |
0=Nao Solicitada;1=Ativo;2=Inativo;3=Aguardando Retorno |
|
S |
GUN_DTATU |
D |
8 |
0 |
Data Atu |
|
|
|
R |
|
|
S |
GUN_HRATU |
C |
5 |
0 |
Hora Atu |
99:99 |
|
|
R |
|
|
S |
GUN_IMPINC |
C |
1 |
0 |
Imposto Inc |
|
Pertence("12") |
|
R |
|
|
S |
GUN_TPREF |
C |
1 |
0 |
Tipo Ref |
9 |
Pertence("1234") |
|
R |
1=Cotacao;2=Previsao;3=Projecao;4=Meta |
M->GUN_TPTAB == "4" |
S |
GUN_PERVIG |
C |
1 |
0 |
Prox Vigenc |
9 |
Pertence("123") |
|
R |
1=Mes;2=Quinzena;3=Semana |
M->GUN_TPTAB == "4" |
S |
GUN_QTDANT |
N |
2 |
0 |
Qtd Dias Ant |
99 |
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_QTDPRZ |
N |
2 |
0 |
Qtd Prz Resp |
99 |
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_QTDLEM |
N |
2 |
0 |
Dias Lembret |
99 |
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_TPFREQ |
C |
1 |
0 |
Tipo Freq |
9 |
Pertence("12") |
|
R |
1=Esporadico;2=Recorrente |
M->GUN_TPTAB == "4" |
S |
GUN_RECOR |
C |
1 |
0 |
Recorrencia |
9 |
Pertence("0123") |
|
R |
0=Nao se Aplica;1=Em Vigor;2=Concluido;3=Desativado |
M->GUN_TPTAB == "4" |
S |
GUN_SOLMOD |
C |
1 |
0 |
Modo Solicit |
9 |
Pertence("12") |
|
R |
1=Manual;2=por Workflow |
M->GUN_TPTAB == "4" |
S |
GUN_SOLSIT |
C |
1 |
0 |
Sit Solicit |
9 |
Pertence("1234") |
|
R |
1=Pendente;2=Aguardando Resposta;3=Atentida;4=Expirada |
M->GUN_TPTAB == "4" .And. M->GUN_SOLMOD == "1" |
S |
GUN_WFSIT |
C |
1 |
0 |
Sit Env WF |
9 |
Pertence("012") |
|
R |
0=Nao se Aplica;1=Enviado com sucesso;2=Tentativa sem sucesso |
M->GUN_TPTAB == "4" |
S |
GUN_UMPESO |
C |
2 |
0 |
Unid Peso |
|
ExistCPO("SAH",M->GUN_UMPESO) |
SAH |
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_SOLDTP |
D |
8 |
0 |
Dat Prox Sol |
|
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_SOLDTS |
D |
8 |
0 |
Dat Soli Sol |
|
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_SOLDTU |
D |
8 |
0 |
Dat Lim Res |
|
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_SOLDTL |
D |
8 |
0 |
Dat Env Lemb |
|
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_SOLDTB |
D |
8 |
0 |
Dat Lembrado |
|
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_SOLDTR |
D |
8 |
0 |
Dat Resposta |
|
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_SOLDTE |
D |
8 |
0 |
Dat Resp Exp |
|
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_SOLEMI |
C |
254 |
0 |
Comunicar |
|
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_SOLMFE |
C |
254 |
0 |
Falha Env WF |
|
|
|
R |
|
M->GUN_TPTAB == "4" |
S |
GUN_CRIUSU |
C |
10 |
0 |
Usuar Cria |
|
|
|
R |
|
|
S |
GUN_CRIDAT |
D |
8 |
0 |
Data Cria |
|
|
|
R |
|
|
S |
GUN_ALTUSU |
C |
10 |
0 |
Usuar Alt |
|
|
|
R |
|
|
S |
GUN_ALTDAT |
D |
8 |
0 |
Data Alt |
|
|
|
R |
|
|
S |