Tabela
GU3 EMITENTES DE TRANSPORTE
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
GU3_FILIAL C 2 0 Filial S
GU3_CDEMIT C 14 0 Cod Emitente @! ExistChav("GU3") R INCLUI S
GU3_NMEMIT C 80 0 Nome NaoVazio() R S
GU3_NMFAN C 80 0 Nome Fant R S
GU3_NMABRV C 20 0 Nome Abrev @! R S
GU3_NATUR C 1 0 Natureza @! GFE015AU() R J=Juridica;F=Fisica;X=Outros S
GU3_CDGREM C 4 0 Cod Grupo @! GFEExistC("GU1",1,M->GU3_CDGREM,"GU1->GU1_SIT=='1' .And. (GU1->GU1_TPGRP=='1' .Or. Empty(GU1->GU1_TPGRP))") .Or. Vazio() GU1 R !ALTERA .OR. (ALTERA .And. GFE015CDGR()) S
GU3_DTNASC D 8 0 Nasc/Criacao R S
GU3_DTIMPL D 8 0 Dt Cadastro R INCLUI S
GU3_ORIGEM C 1 0 Origem @! PERTENCE("123") R 1=Usuario;2=ERP;3=Outros .F. S
GU3_SIT C 1 0 Situacao @! Pertence("12") R 1=Ativo;2=Inativo ALTERA .And. GFEX000VAC() S
GU3_EMFIL C 1 0 Filial? @! Pertence("12").and.GFE15VERF() R 1=Sim;2=Nao S
GU3_TRANSP C 1 0 Transp? @! GFE015TR() R 1=Sim;2=Nao GFE015AUT() S
GU3_CLIEN C 1 0 Cliente? @! PERTENCE("12") R 1=Sim;2=Nao S
GU3_FORN C 1 0 Fornecedor? @! Pertence("12") R 1=Sim;2=Nao S
GU3_AUTON C 1 0 Autonomo? @! GFE015ATN() R 1=Sim;2=Nao GFE015AUT() S
GU3_ENDER C 80 0 Endereco @! R S
GU3_COMPL C 50 0 Complemento R S
GU3_BAIRRO C 40 0 Bairro @! R S
GU3_CEP C 8 0 CEP @R 99.999-999 R S
GU3_NRCID C 7 0 Nr Cidade 9999999 IF(!ISBLIND(), ExistCpo("GU7") .AND. GFE015AU(), .T.) GU7 R S
GU3_NMCID C 60 0 Nome Cidade @! V S
GU3_UF C 2 0 UF @! EXISTCPO("SX5","12"+M->GU3_UF) V S
GU3_IDFED C 21 0 CNPJ/CPF @R 99.999.999/9999-99 IIF(M->GU3_NATUR != 'X' , VAZIO() .OR. CGC(M->GU3_IDFED), .T.) R S
GU3_TPTRIB C 1 0 Reg Tribut @! Pertence("1;2;3;4") R 1=Normal;2=Simplificado;3=Especial;4=Imune S
GU3_CONICM C 1 0 Contrib ICMS @! R 1=Sim;2=Nao;3=Sim, Exceto outras UFs S
GU3_IE C 19 0 Insc Est/RG @! R S
GU3_ORGEXP C 8 0 Orgao Exp @! R S
GU3_IM C 19 0 Inscr Munic @! R S
GU3_CXPOS C 10 0 Caixa Postal R S
GU3_EMAIL C 50 0 E-mail R S
GU3_CONISS C 1 0 Contrib ISS @! R 1=Sim;2=Nao S
GU3_FONE1 C 15 0 Fone 1 R S
GU3_RAMAL1 N 5 0 Ramal 1 99999 R S
GU3_FONE2 C 15 0 Fone 2 R S
GU3_RAMAL2 N 5 0 Ramal 2 99999 R S
GU3_FAX C 15 0 Fax R S
GU3_RAMALF N 5 0 Ramal Fax 99999 R S
GU3_WSITE C 50 0 WEB Site R S
GU3_MVTERC C 1 0 Mov Autonomo @! Pertence("12") R 1=Sim;2=Nao M->GU3_AUTON $ "1" S
GU3_CATTRP C 1 0 Categoria Pertence("1;2;3;4;5;6;7;8") R 1=Empresa Comercial;2=Autonomo;3=Cooperativa;4=Operador Logistico;5=Distribuidor;6=Correios;7=Proprio Embarcador;8=Outros M->GU3_TRANSP == "1" .And. M->GU3_AUTON == "2" S
GU3_MODAL C 1 0 Modal Pertence("1;2;3;4;5;6;7") R 1=Nao-informado;2=Rodoviario;3=Ferroviario;4=Aereo;5=Aquaviario;6=Dutoviario;7=Multimodal M->GU3_TRANSP == "1" .And. M->GU3_AUTON == "2" S
GU3_FRCOMB C 1 0 Negoc Frete @! Pertence("12") R 1=Permite Combinar;2=Somente com Tabela M->GU3_TRANSP $ "1" .OR. M->GU3_AUTON $ "1" S
GU3_DEDIC C 1 0 Frota Dedic @! Pertence("12") R 1=Sim;2=Nao M->GU3_TRANSP $ "1" .OR. M->GU3_AUTON $ "1" S
GU3_ANTT C 14 0 RNTRC @! R GFEA015ANT() S
GU3_INSS C 12 0 Insc INSS @! R M->GU3_AUTON $ "1" S
GU3_NRDEP N 2 0 Dependentes 99 R M->GU3_AUTON $ "1" S
GU3_CDEMFT C 14 0 Transp Fatur @! GU3TRP R M->GU3_TRANSP $ "1" S
GU3_MAXDOC N 3 0 Max Doc Carg 999 R M->GU3_TRANSP $ "1" S
GU3_NMEMFT C 80 0 Transp Fatur V M->GU3_TRANSP $ "1" S
GU3_AGRDOC C 1 0 Agrup Doctos @! Pertence("12") R 1=Sim;2=Nao M->GU3_TRANSP $ "1" S
GU3_ACOCO C 1 0 Acao Ocor @! Pertence("123") R 1=Mantem;2=Nenhuma;3=Alerta M->GU3_TRANSP $ "1" S
GU3_PFCALC C 1 0 Por Calculo R 1=Sim;2=Nao M->GU3_TRANSP $ "1" S
GU3_PFFIL C 1 0 Por Filial @! Pertence("12") R 1=Sim;2=Nao M->GU3_TRANSP == "1" .AND. M->GU3_PFCALC == "2" S
GU3_PFUF C 1 0 Por UF @! Pertence("12") R 1=Sim;2=Nao M->GU3_TRANSP == "1" .AND. M->GU3_PFCALC == "2" S
GU3_PFCLAS C 1 0 Por Classif @! Pertence("12") R 1=Sim;2=Nao M->GU3_TRANSP == "1" .AND. M->GU3_PFCALC == "2" S
GU3_PFTPFR C 1 0 Por Tp Frete @! Pertence("12") R 1=Sim;2=Nao M->GU3_TRANSP == "1" .AND. M->GU3_PFCALC == "2" S
GU3_PFNORM N 1 0 Grp Normal 9 R GFE015WPFG() S
GU3_PFCPVL N 1 0 Grp Comp Val 9 R GFE015WPFG() S
GU3_PFCPIC N 1 0 Grp Comp Imp 9 R GFE015WPFG() S
GU3_PFDEV N 1 0 Grp Devol 9 R GFE015WPFG() S
GU3_PFREDE N 1 0 Grp Redesp 9 R GFE015WPFG() S
GU3_PFREEN N 1 0 Grp Reentreg 9 R GFE015WPFG() S
GU3_PFSERV N 1 0 Grp Servico 9 R GFE015WPFG() S
GU3_ENTOBR C 1 0 Entreg Obrig @! Pertence("12") R 1=Sim;2=Nao S
GU3_CALCVC C 1 0 Calc Vencto @! R 1=Sim;2=Nao M->GU3_TRANSP $ "1" S
GU3_PRAZO N 3 0 Prazo 999 R M->GU3_TRANSP $ "1" S
GU3_ACAOVC C 1 0 Dia Nao-util @! R 1=Manter;2=Adiar;3=Antecipar M->GU3_TRANSP $ "1" S
GU3_TPFREQ C 1 0 Tipo Frequen @! R 0=Qualquer dia;1=Dia Base;2=Dia da Semana M->GU3_TRANSP $ "1" S
GU3_DBAS1 N 2 0 Dia Base 1 99 R M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "1" S
GU3_DBAS2 N 2 0 Dia Base 2 99 R M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "1" S
GU3_DBAS3 N 2 0 Dia Base 3 99 R M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "1" S
GU3_DBAS4 N 2 0 Dia Base 4 99 R M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "1" S
GU3_DBAS5 N 2 0 Dia Base 5 99 R M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "1" S
GU3_SEGUN C 1 0 Segunda @! R 1=Sim;2=Nao M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "2" S
GU3_TERCA C 1 0 Terca @! R 1=Sim;2=Nao M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "2" S
GU3_QUARTA C 1 0 Quarta @! R 1=Sim;2=Nao M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "2" S
GU3_QUINTA C 1 0 Quinta @! R 1=Sim;2=Nao M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "2" S
GU3_SEXTA C 1 0 Sexta @! R 1=Sim;2=Nao M->GU3_TRANSP $ "1" .AND. M->GU3_TPFREQ $ "2" S
GU3_ICMPRE C 1 0 ICMS Presum @! R 1=Sim;2=Nao M->GU3_TRANSP $ "1" S
GU3_APUICM C 1 0 Apurac ICMS @! R 1=Normal;2=Subs Tribut;3=Diferido;4=Presumido M->GU3_TRANSP $ "1" .AND. M->GU3_CONICM $ "1" S
GU3_APUISS C 1 0 Apuracao ISS @! R 1=Normal;2=Subs Tribut M->GU3_TRANSP $ "1" .AND. M->GU3_CONISS $ "1" S
GU3_CAUTPF C 1 0 Confirm Auto Pertence("12") R 1=Sim;2=Nao M->GU3_TRANSP == "1" .AND. M->GU3_AUTON == "2" S
GU3_SBTRIB C 1 0 Subs Trib @! R 1=Sim;2=Nao M->GU3_TRANSP $ "1" S
GU3_CTE C 1 0 Emite CT-e @! R 1=Sim;2=Nao M->GU3_TRANSP $ "1" S
GU3_OBS M 10 0 Observacoes R S
GU3_CXEDI C 40 0 Cx Post EDI R S
GU3_FATAUT C 1 0 Gera Fat Aut @! Pertence("12") R 1=Sim;2=Nao M->GU3_TRANSP $ "1" S
GU3_CDGRED C 4 0 Grupo EDI GFEExistC("GU1",1,M->GU3_CDGRED,"GU1->GU1_SIT=='1' .And. GU1->GU1_TPGRP=='3'") .Or. Vazio() GU1EDI R S
GU3_CDGRGL C 4 0 Grp Gerenc GFEExistC("GU1",1,M->GU3_CDGRGL,"GU1->GU1_SIT=='1' .And. GU1->GU1_TPGRP=='2'") .Or. Vazio() GU1GER R S
GU3_EDICTE N 4 0 Posicao CT-e 9999 R M->GU3_TRANSP $ "1" S
GU3_CDERP C 6 0 Codigo ERP @! R S
GU3_CDCERP C 2 0 Cod Comp ERP @! R S
GU3_CDTERP C 6 0 Cod Tran ERP @! R S
GU3_VALEP C 1 0 Vale Pedagio @! R 1=Recebe;2=Nao recebe S
GU3_OCORET C 1 0 Ocor Retroat @! Pertence("1234") R 1=Conforme o parametro;2=Nao permite data retroativa;3=Somente ocorrencias EDI;4=Todas ocorrencias M->GU3_TRANSP == "1" .Or. M->GU3_AUTON = "1" S
GU3_PCISS N 9 5 %ISS Simples @E 999.99999 R GFE015ISS() S
GU3_REDESP C 1 0 Redesp? @! 1=Sim;2=Nao M->GU3_TRANSP $ "1" S
GU3_ESEXIC C 80 0 Est Exc ICMS @! UFF3 R M->GU3_CONICM == "1" .And. M->GU3_TRANSP == "1" S
GU3_PFTPSE C 1 0 Por Servico @! Pertence("12") R 1=Sim; 2=Nao S