| Tabela |
| B9W |
VISITA DE RELACIONAMENTO |
| Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
| B9W_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
| B9W_AGENTE |
C |
6 |
0 |
Agente |
@! |
B9H->(ExistCpo("B9H",PLSINTPAD()+PLS806Zero(M->B9W_AGENTE),2)) .OR. EmpTy(M->B9W_AGENTE) |
B9PB9H |
R |
|
|
S |
| B9W_NOMAGT |
C |
50 |
0 |
Nome |
@! |
|
|
V |
|
|
S |
| B9W_CODPRE |
C |
6 |
0 |
Prestador |
@! |
BAU->(ExistCpo("BAU",PLS806Zero(M->B9W_CODPRE))) .OR. Empty(M->B9W_CODPRE) |
B9WBAU |
R |
|
IF(INCLUI, .T., .F.) |
S |
| B9W_PRESTA |
C |
50 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
| B9W_CPFCGC |
C |
14 |
0 |
CPF/CNPJ |
@! |
|
|
V |
|
|
S |
| B9W_DATAAG |
D |
8 |
0 |
Agendamento |
|
M->B9W_DATAAG>=Date() |
|
R |
|
|
S |
| B9W_HORAAG |
C |
4 |
0 |
Hora Agenda |
@R 99:99 |
PLSVLDHOR(M->B9W_HORAAG) |
|
R |
|
|
S |
| B9W_DATAVI |
D |
8 |
0 |
Data Visita |
|
M->B9W_DATAVI >= M->B9W_DATAAG .AND. !Empty(M->B9W_DATAAG) .AND. M->B9W_DATAVI<=Date() |
|
R |
|
IF(INCLUI, .F., .T.) |
S |
| B9W_HORAVI |
C |
4 |
0 |
Hora Visita |
@R 99:99 |
PLSVLDHOR(M->B9W_HORAVI) |
|
R |
|
! (INCLUI) |
S |
| B9W_DESCON |
C |
50 |
0 |
Contato |
@! |
|
|
R |
|
|
S |
| B9W_TELCON |
C |
11 |
0 |
Telefone |
@R (99) 99999-9999 |
ValFone() |
|
R |
|
|
S |
| B9W_EMAIL |
C |
50 |
0 |
E-mail |
@! |
IsEmail(AllTrim(M->B9W_EMAIL)) |
|
R |
|
|
S |
| B9W_MOTVIS |
C |
2 |
0 |
Mot Visita |
@! |
((B9L->(ExistCpo("B9L",PLSINTPAD()+PLS806Zero(M->B9W_MOTVIS), 7)) .AND. PLS807VTPV(M->B9W_MOTVIS)) .OR. Empty(M->B9W_MOTVIS)) |
B9WB9L |
R |
|
|
S |
| B9W_DESVIS |
C |
30 |
0 |
Motivo |
@! |
|
|
V |
|
|
S |
| B9W_CODOBS |
C |
3 |
0 |
Observacao |
@! |
B9N->(ExistCpo("B9N",PLSINTPAD()+PLS806Zero(M->B9W_CODOBS), 1)).OR. EmpTy(M->B9W_CODOBS) |
B9PB9N |
R |
|
|
S |
| B9W_DESOBS |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
| B9W_CODSOL |
C |
6 |
0 |
Solicitante |
@! |
UsrExist(PLS806Zero(M->B9W_CODSOL)) .OR. Empty(M->B9W_CODSOL) |
B9PUSR |
R |
|
|
S |
| B9W_DESSOL |
C |
30 |
0 |
Solicitante |
@! |
|
|
R |
|
|
S |
| B9W_CODCAN |
C |
2 |
0 |
Canais Com. |
@! |
B9M->(ExistCpo("B9M",PLSINTPAD()+PLS806Zero(M->B9W_CODCAN), 2)).OR. EmpTy(M->B9W_CODCAN) |
B9WB9M |
R |
|
|
S |
| B9W_DESCAN |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
| B9W_CODINF |
C |
6 |
0 |
Recebe Info? |
@! |
B9F->(ExistCpo("B9F",PLSINTPAD()+PLS806Zero(M->B9W_CODINF), 2)).OR. EmpTy(M->B9W_CODINF) |
B9WB9F |
R |
|
|
S |
| B9W_DESINF |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
| B9W_END2 |
C |
1 |
0 |
Outro end? |
@! |
|
|
R |
0=Nao;1=Sim |
|
S |
| B9W_SCON |
C |
1 |
0 |
Usa Portal? |
@! |
|
|
R |
0=Nao;1=Sim |
|
S |
| B9W_SEQVIS |
C |
5 |
0 |
Seq Visita |
@! |
|
|
R |
|
|
S |
| B9W_OBSERV |
M |
10 |
0 |
Observacao |
@! |
|
|
R |
|
|
S |
| B9W_CODINT |
C |
4 |
0 |
Operadora |
@R !.!!! |
|
|
R |
|
|
S |
| B9W_DESINT |
C |
15 |
0 |
Desc Ope |
@! |
|
|
V |
|
|
S |
