| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VCF | Dados Adicionais Clientes Cev | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VCF_FILIAL | C | 2 | 0 | Filial | N | ||||||
| VCF_CODCLI | C | 6 | 0 | Cod.Cliente | @! | FG_SEEK("SA1","M->VCF_CODCLI",1,.f.,"VCF_NOMCLI","A1_NOME").and.VEICM560VAL(1) | SA1 | If(INCLUI,.t.,.f.) | S | ||
| VCF_LOJCLI | C | 2 | 0 | Loja Cliente | @! | FG_SEEK("SA1","M->VCF_CODCLI+M->VCF_LOJCLI",1,.f.,"VCF_NOMCLI","A1_NOME").and.VEICM560VAL(1) | If(INCLUI,.t.,.f.) | S | |||
| VCF_NOMCLI | C | 20 | 0 | Nome Cliente | @! | V | S | ||||
| VCF_CODSEG | C | 6 | 0 | Cod.Segmento | @! | FG_Seek("VX5","'033'+M->VCF_CODSEG",1,.f.,"VCF_DESSEG","VX5_DESCRI") | VX5 | R | S | ||
| VCF_DESSEG | C | 20 | 0 | Desc.Segment | @! | V | S | ||||
| VCF_NIVIMP | C | 2 | 0 | Nivel Import | @! | S | |||||
| VCF_AREVEN | C | 3 | 0 | Area de Vda | @! | S | |||||
| VCF_OFIPRO | C | 1 | 0 | Ofic Propria | @! | Pertence("01") | 0=Nao;1=Sim | S | |||
| VCF_QTDMEC | N | 3 | 0 | Qtd Mecanico | @E 999 | S | |||||
| VCF_USASTE | C | 1 | 0 | Util.Srv.Ter | @! | Pertence("01") | 0=Nao;1=Sim | S | |||
| VCF_VALSTE | N | 12 | 2 | Vlr.Srv.Terc | @E 999,999,999.99 | S | |||||
| VCF_QTDFR3 | N | 3 | 0 | Qtd.Frot.Ter | @E 999 | S | |||||
| VCF_PERFT3 | N | 3 | 0 | % Fatur Terc | @E 999 | S | |||||
| VCF_PERVC3 | N | 3 | 0 | %VolCargTerc | @E 999 | S | |||||
| VCF_RECBRU | N | 7 | 0 | RBrutMes/Mil | @E 9,999,999 | VEICM560VAL(2) | S | ||||
| VCF_RECVIS | C | 75 | 0 | ReceitaBruta | @! | M->VCF_RECVIS >= 0 | S | ||||
| VCF_SOCIO1 | C | 70 | 0 | Socio 1 | @! | N | |||||
| VCF_SOCIO2 | C | 70 | 0 | Socio 2 | @! | S | |||||
| VCF_SOCIO3 | C | 70 | 0 | Socio 3 | @! | S | |||||
| VCF_EMPCO1 | C | 70 | 0 | Empr Colig 1 | @! | S | |||||
| VCF_EMPCO2 | C | 70 | 0 | Empr Colig 2 | @! | S | |||||
| VCF_EMPCO3 | C | 70 | 0 | Empr Colig 3 | @! | S | |||||
| VCF_FIL_01 | C | 30 | 0 | Filial 1 | @! | S | |||||
| VCF_FIL_02 | C | 30 | 0 | Filial 2 | @! | S | |||||
| VCF_FIL_03 | C | 30 | 0 | Filial 3 | @! | S | |||||
| VCF_PRICL1 | C | 70 | 0 | PrincClient1 | @! | S | |||||
| VCF_PRICL2 | C | 70 | 0 | PrincClient2 | @! | S | |||||
| VCF_PRICL3 | C | 70 | 0 | PrincClient3 | @! | S | |||||
| VCF_PRIFO1 | C | 70 | 0 | PrincFornec1 | @! | S | |||||
| VCF_PRIFO2 | C | 70 | 0 | PrincFornec2 | @! | S | |||||
| VCF_PRIFO3 | C | 70 | 0 | PrincFornec3 | @! | S | |||||
| VCF_BCOAG1 | C | 7 | 0 | BcoAgencia1 | @R 999/9999 | S | |||||
| VCF_BCOAG2 | C | 7 | 0 | BcoAgencia2 | @R 999/9999 | S | |||||
| VCF_BCOAG3 | C | 7 | 0 | BcoAgencia3 | @R 999/9999 | S | |||||
| VCF_FOR1MO | C | 30 | 0 | Fornec 1 MO | @! | S | |||||
| VCF_FOR2MO | C | 30 | 0 | Fornec 2 MO | @! | S | |||||
| VCF_FOR1PC | C | 30 | 0 | Fornec 1 PC | @! | S | |||||
| VCF_FOR2PC | C | 30 | 0 | Fornec 2 PC | @! | S | |||||
| VCF_VENPEC | C | 6 | 0 | Vended Pecas | @! | SA3 | S | ||||
| VCF_DIAPEP | N | 3 | 0 | DiasVisitPec | @E 999 | R | S | ||||
| VCF_CLAPEC | C | 1 | 0 | Clas.Cli.Pec | @! | Pertence("ABCDEFGHIJKLMNOPQRSTUVWXYZ") | R | A=A;B=B;C=C;D=D;E=E;F=F;G=G;H=H;I=I;J=J;K=K;L=L;M=M;N=N;O=O;P=P;Q=Q;R=R;S=S;T=T;U=U;V=V;W=W;X=X;Y=Y;Z=Z | S | ||
| VCF_VENVEI | C | 6 | 0 | Vended Veic | @! | SA3 | S | ||||
| VCF_DIAPER | N | 3 | 0 | DiasVisitVei | @E 999 | R | S | ||||
| VCF_CLAVEI | C | 1 | 0 | Clas.Cli.Vei | @! | Pertence("ABCDEFGHIJKLMNOPQRSTUVWXYZ") | R | A=A;B=B;C=C;D=D;E=E;F=F;G=G;H=H;I=I;J=J;K=K;L=L;M=M;N=N;O=O;P=P;Q=Q;R=R;S=S;T=T;U=U;V=V;W=W;X=X;Y=Y;Z=Z | S | ||
| VCF_VENSRV | C | 6 | 0 | Vended Srvcs | @! | SA3 | S | ||||
| VCF_DIAPES | N | 3 | 0 | DiasVisitSrv | @E 999 | R | S | ||||
| VCF_CLASRV | C | 1 | 0 | Clas.Cli.Srv | @! | Pertence("ABCDEFGHIJKLMNOPQRSTUVWXYZ") | R | A=A;B=B;C=C;D=D;E=E;F=F;G=G;H=H;I=I;J=J;K=K;L=L;M=M;N=N;O=O;P=P;Q=Q;R=R;S=S;T=T;U=U;V=V;W=W;X=X;Y=Y;Z=Z | S | ||
| VCF_BLOQAG | C | 10 | 0 | Bloq Agendas | @! | R | N | ||||
| VCF_MOTBLO | C | 50 | 0 | Motivo Bloq | @! | R | N | ||||
| VCF_DATCAD | D | 8 | 0 | Dt.Cadastro | R | S | |||||
| VCF_VENVEU | C | 6 | 0 | Vend.Vei.Usa | @! | SA3 | S | ||||
| VCF_DIAVEU | N | 3 | 0 | DiasVisVeiUs | @E 999 | S | |||||
| VCF_CLAVEU | C | 1 | 0 | Clas.Vei.Usa | @! | Pertence("ABCDEFGHIJKLMNOPQRSTUVWXYZ") | A=A;B=B;C=C;D=D;E=E;F=F;G=G;H=H;I=I;J=J;K=K;L=L;M=M;N=N;O=O;P=P;Q=Q;R=R;S=S;T=T;U=U;V=V;W=W;X=X;Y=Y;Z=Z | S | |||
| VCF_GRUECN | C | 6 | 0 | Grp.Economic | @! | vazio().or.FG_Seek("VQK","M->VCF_GRUECN",1,.f.) | VQK | R | S | ||
| VCF_VENPNE | C | 6 | 0 | Vended Pneus | @! | SA3 | S | ||||
| VCF_DIAPNE | N | 3 | 0 | DiasVisPneus | @E 999 | S | |||||
| VCF_DIAOUT | N | 3 | 0 | DiasVisOutro | @E 999 | S | |||||
| VCF_CONDIC | C | 1 | 0 | Condicao | @! | Pertence("012") | R | 0=Nao tratada;1=Em andamento;2=Desqualificada | S | ||
| VCF_CLAPNE | C | 1 | 0 | Class.Pneus | @! | Pertence("ABCDEFGHIJKLMNOPQRSTUVWXYZ") | A=A;B=B;C=C;D=D;E=E;F=F;G=G;H=H;I=I;J=J;K=K;L=L;M=M;N=N;O=O;P=P;Q=Q;R=R;S=S;T=T;U=U;V=V;W=W;X=X;Y=Y;Z=Z | S | |||
| VCF_JUSTIF | C | 100 | 0 | Justificativ | @! | R | S | ||||
| VCF_MSGSAT | C | 100 | 0 | Msg.Pesq.Sat | @! | R | S | ||||
| VCF_VENOUT | C | 6 | 0 | Vended Outro | @! | SA3 | S | ||||
| VCF_CLAOUT | C | 1 | 0 | Class.Outros | @! | Pertence("ABCDEFGHIJKLMNOPQRSTUVWXYZ") | A=A;B=B;C=C;D=D;E=E;F=F;G=G;H=H;I=I;J=J;K=K;L=L;M=M;N=N;O=O;P=P;Q=Q;R=R;S=S;T=T;U=U;V=V;W=W;X=X;Y=Y;Z=Z | S | |||
| VCF_LATITU | N | 16 | 8 | Latitude | @E 9,999,999.99999999 | R | S | ||||
| VCF_LONGIT | N | 16 | 8 | Longitude | @E 9,999,999.99999999 | R | S | ||||