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 |