Tabela |
B9P |
Agendamento de Captacao |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
B9P_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
B9P_SEQVIS |
C |
5 |
0 |
Seq Visita |
@! |
|
|
R |
|
|
S |
B9P_AGENTE |
C |
6 |
0 |
Cod Agente |
@! |
B9H->(ExistCpo("B9H",PLSINTPAD()+PLS806Zero(M->B9P_AGENTE),2)) .OR. EmpTy(M->B9P_AGENTE) |
B9PB9H |
R |
|
|
S |
B9P_NOMAGT |
C |
50 |
0 |
Nome Agente |
@! |
|
|
V |
|
|
S |
B9P_PRICON |
C |
1 |
0 |
1º Contato |
@! |
|
|
R |
0=Nao;1=Sim |
|
S |
B9P_CODPRO |
C |
6 |
0 |
Cod Prospect |
@! |
|
|
R |
|
|
S |
B9P_PRESTA |
C |
50 |
0 |
Prestador |
@! |
|
|
R |
|
|
S |
B9P_CPFCGC |
C |
14 |
0 |
CPF/CNPJ |
@! |
CGC(M->B9P_CPFCGC) .OR. Vazio(M->B9P_CPFCGC) |
|
R |
|
|
S |
B9P_CRMNUM |
C |
15 |
0 |
CRM Nº |
999999999999999 |
|
|
R |
|
|
S |
B9P_CRMEST |
C |
2 |
0 |
CRM Estado |
@! |
ExistCpo("SX5","12"+M->B9P_CRMEST) |
12 |
R |
|
|
S |
B9P_DATAAG |
D |
8 |
0 |
Agendamento |
|
M->B9P_DATAAG>=Date() |
|
R |
|
|
S |
B9P_HORAAG |
C |
4 |
0 |
Hora Agenda |
@R 99:99 |
PLSVLDHOR(M->B9P_HORAAG) |
|
R |
|
|
S |
B9P_DATAVI |
D |
8 |
0 |
Visita |
|
M->B9P_DATAVI >= M->B9P_DATAAG .AND. !Empty(M->B9P_DATAAG) .AND. M->B9P_DATAVI<=Date() .OR. Vazio(M->B9P_DATAVI) |
|
R |
|
If(INCLUI, .F., .T.) |
S |
B9P_HORAVI |
C |
4 |
0 |
Hora Visita |
@R 99:99 |
PLSVLDHOR(M->B9P_HORAVI) .AND. If(M->B9P_DATAAG == M->B9P_DATAVI, M->B9P_HORAVI >= M->B9P_HORAAG, .T.) |
|
R |
|
If(INCLUI, .F., .T.) |
S |
B9P_NOMCON |
C |
50 |
0 |
Nome Contato |
@! |
|
|
R |
|
|
S |
B9P_DESCON |
C |
11 |
0 |
Tel Contato |
@R (99) 9.9999-9999 |
ValFone() |
|
R |
|
|
S |
B9P_EMAIL |
C |
50 |
0 |
E-mail |
@! |
IsEmail(AllTrim(M->B9P_EMAIL)) |
|
R |
|
|
S |
B9P_MOTVIS |
C |
2 |
0 |
Mot. Visita |
@! |
((B9L->(ExistCpo("B9L",PLSINTPAD()+PLS806Zero(M->B9P_MOTVIS), 7)) .AND. PLS806VTPV(M->B9P_MOTVIS)) .OR. Empty(M->B9P_MOTVIS)) |
B9PB9L |
R |
|
|
S |
B9P_DESVIS |
C |
30 |
0 |
De. Visita |
@! |
|
|
V |
|
|
S |
B9P_CODOBS |
C |
3 |
0 |
Cod Observ. |
@! |
B9N->(ExistCpo("B9N",PLSINTPAD()+PLS806Zero(M->B9P_CODOBS), 1)).OR. EmpTy(M->B9P_CODOBS) |
B9PB9N |
R |
|
|
S |
B9P_DESOBS |
C |
30 |
0 |
Desc Observ. |
@! |
|
|
V |
|
|
S |
B9P_CODSOL |
C |
6 |
0 |
Cod Solic. |
@! |
UsrExist(PLS806Zero(M->B9P_CODSOL)) .OR. Empty(M->B9P_CODSOL) |
B9PUSR |
R |
|
|
S |
B9P_DESSOL |
C |
50 |
0 |
Solicitante |
@! |
|
|
R |
|
|
S |
B9P_REVNEG |
C |
1 |
0 |
Revisita Neg |
@! |
|
|
R |
0=Nao; 1=Sim |
IIf(M->B9P_PRICON == "1", .F., .T.) |
S |
B9P_INTCON |
C |
1 |
0 |
Int convenio |
@! |
|
|
R |
0=Nao; 1=Sim |
If(INCLUI, .F., .T.) .AND. !(Vazio(M->B9P_DATAVI)) |
S |
B9P_PROVCT |
C |
1 |
0 |
Prov. Contr. |
@! |
|
|
R |
0=Nao; 1=Sim |
IIF(M->B9P_INTCON == "1", .T., .F.) |
S |
B9P_CEMIGS |
C |
1 |
0 |
Conhece Ope? |
@! |
|
|
R |
0=Nao; 1=Sim |
|
S |
B9P_FCAPTA |
C |
1 |
0 |
Captacao |
@! |
|
|
R |
1=Prestador Portal;2=Indicacao CallCenter;3=Indicacao Portal; 4=Operadora |
|
S |
B9P_GEROUS |
C |
1 |
0 |
Gerou Solic? |
@! |
|
|
R |
0=Nao;1=Sim |
|
S |
B9P_CODINT |
C |
4 |
0 |
Operadora |
@R !.!!! |
|
|
R |
|
|
S |
B9P_DESINT |
C |
15 |
0 |
Desc Ope |
@! |
|
|
V |
|
|
S |
B9P_OBSERV |
M |
10 |
0 |
Observacoes |
|
|
|
R |
|
|
S |
B9P_CODB9P |
C |
6 |
0 |
Antigo B9P |
@! |
|
|
R |
|
|
S |
B9P_DATCAN |
D |
8 |
0 |
Data Cancel. |
|
|
|
R |
|
|
S |