Tabela
VCFDados Adicionais Clientes Cev
CampoTipoTamanhoDecimalTítuloFormatoValidaçãoF3ContextoListaCondiçãoPYME
VCF_FILIALC20Filial N
VCF_CODCLIC60Cod.Cliente @! FG_SEEK("SA1","M->VCF_CODCLI",1,.f.,"VCF_NOMCLI","A1_NOME").and.VEICM560VAL(1) SA1 If(INCLUI,.t.,.f.) S
VCF_LOJCLIC20Loja 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_NOMCLIC200Nome Cliente@! V S
VCF_CODSEGC60Cod.Segmento@! FG_Seek("VX5","'033'+M->VCF_CODSEG",1,.f.,"VCF_DESSEG","VX5_DESCRI") VX5 R S
VCF_DESSEGC200Desc.Segment@! V S
VCF_NIVIMPC20Nivel Import@! S
VCF_AREVENC30Area de Vda @! S
VCF_OFIPROC10Ofic Propria@! Pertence("01") 0=Nao;1=Sim S
VCF_QTDMECN30Qtd Mecanico@E 999 S
VCF_USASTEC10Util.Srv.Ter@! Pertence("01") 0=Nao;1=Sim S
VCF_VALSTEN122Vlr.Srv.Terc@E 999,999,999.99 S
VCF_QTDFR3N30Qtd.Frot.Ter@E 999 S
VCF_PERFT3N30% Fatur Terc@E 999 S
VCF_PERVC3N30%VolCargTerc@E 999 S
VCF_RECBRUN70RBrutMes/Mil@E 9,999,999 VEICM560VAL(2) S
VCF_RECVISC750ReceitaBruta@! M->VCF_RECVIS >= 0 S
VCF_SOCIO1C700Socio 1 @! N
VCF_SOCIO2C700Socio 2 @! S
VCF_SOCIO3C700Socio 3 @! S
VCF_EMPCO1C700Empr Colig 1@! S
VCF_EMPCO2C700Empr Colig 2@! S
VCF_EMPCO3C700Empr Colig 3@! S
VCF_FIL_01C300Filial 1 @! S
VCF_FIL_02C300Filial 2 @! S
VCF_FIL_03C300Filial 3 @! S
VCF_PRICL1C700PrincClient1@! S
VCF_PRICL2C700PrincClient2@! S
VCF_PRICL3C700PrincClient3@! S
VCF_PRIFO1C700PrincFornec1@! S
VCF_PRIFO2C700PrincFornec2@! S
VCF_PRIFO3C700PrincFornec3@! S
VCF_BCOAG1C70BcoAgencia1 @R 999/9999 S
VCF_BCOAG2C70BcoAgencia2 @R 999/9999 S
VCF_BCOAG3C70BcoAgencia3 @R 999/9999 S
VCF_FOR1MOC300Fornec 1 MO @! S
VCF_FOR2MOC300Fornec 2 MO @! S
VCF_FOR1PCC300Fornec 1 PC @! S
VCF_FOR2PCC300Fornec 2 PC @! S
VCF_VENPECC60Vended Pecas@! SA3 S
VCF_DIAPEPN30DiasVisitPec@E 999 R S
VCF_CLAPECC10Clas.Cli.Pec@! Pertence("ABCDEFGHIJKLMNOPQRSTUVWXYZ") RA=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_VENVEIC60Vended Veic @! SA3 S
VCF_DIAPERN30DiasVisitVei@E 999 R S
VCF_CLAVEIC10Clas.Cli.Vei@! Pertence("ABCDEFGHIJKLMNOPQRSTUVWXYZ") RA=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_VENSRVC60Vended Srvcs@! SA3 S
VCF_DIAPESN30DiasVisitSrv@E 999 R S
VCF_CLASRVC10Clas.Cli.Srv@! Pertence("ABCDEFGHIJKLMNOPQRSTUVWXYZ") RA=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_BLOQAGC100Bloq Agendas@! R N
VCF_MOTBLOC500Motivo Bloq @! R N
VCF_DATCADD80Dt.Cadastro R S
VCF_VENVEUC60Vend.Vei.Usa@! SA3 S
VCF_DIAVEUN30DiasVisVeiUs@E 999 S
VCF_CLAVEUC10Clas.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_GRUECNC60Grp.Economic@! vazio().or.FG_Seek("VQK","M->VCF_GRUECN",1,.f.) VQK R S
VCF_VENPNEC60Vended Pneus@! SA3 S
VCF_DIAPNEN30DiasVisPneus@E 999 S
VCF_DIAOUTN30DiasVisOutro@E 999 S
VCF_CONDICC10Condicao @! Pertence("012") R0=Nao tratada;1=Em andamento;2=Desqualificada S
VCF_CLAPNEC10Class.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_JUSTIFC1000Justificativ@! R S
VCF_MSGSATC1000Msg.Pesq.Sat@! R S
VCF_VENOUTC60Vended Outro@! SA3 S
VCF_CLAOUTC10Class.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