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