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