Tabela |
AD1 |
Oportunidades de Venda |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
AD1_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
AD1_NROPOR |
C |
6 |
0 |
Oportunidade |
@! |
ExistChav("AD1") |
|
R |
|
|
S |
AD1_REVISA |
C |
2 |
0 |
Revisao |
@! |
|
|
R |
|
|
S |
AD1_DESCRI |
C |
30 |
0 |
Descricao |
@! |
NaoVazio() |
|
R |
|
|
S |
AD1_DATA |
D |
8 |
0 |
Dt Inclusao |
|
|
|
R |
|
|
S |
AD1_HORA |
C |
5 |
0 |
Hora |
@! |
|
|
R |
|
|
S |
AD1_USER |
C |
6 |
0 |
Cod.Usuario |
@! |
|
|
R |
|
|
S |
AD1_VEND |
C |
6 |
0 |
Vendedor |
@! |
ExistCpo("SA3") .AND. Ft300AltTV() |
SA3 |
R |
|
|
S |
AD1_NOMVEN |
C |
40 |
0 |
Nome |
@! |
|
|
V |
|
|
S |
AD1_DTINI |
D |
8 |
0 |
Dt.Inicio |
|
Ft300DtVld() |
|
R |
|
|
S |
AD1_DTFIM |
D |
8 |
0 |
Dt.Fechament |
|
Ft300DtVld() |
|
R |
|
|
S |
AD1_PROSPE |
C |
6 |
0 |
Prospect |
@! |
Ft300Prosp() .And. CRMXLibReg("SUS") |
SUS |
R |
|
|
S |
AD1_LOJPRO |
C |
2 |
0 |
Loja Prosp. |
@! |
Ft300Prosp() |
|
R |
|
|
S |
AD1_NOMPRO |
C |
40 |
0 |
Nome Prosp. |
@! |
|
|
V |
|
|
S |
AD1_CODCLI |
C |
6 |
0 |
Cliente |
@! |
Ft300Cli(.F.) .And. CRMXLibReg("SA1") |
SA1 |
R |
|
|
S |
AD1_LOJCLI |
C |
2 |
0 |
Loja |
@! |
Ft300Cli(.F.) |
|
R |
|
|
S |
AD1_NOMCLI |
C |
40 |
0 |
Nome Cliente |
@! |
|
|
V |
|
|
S |
AD1_PROVEN |
C |
6 |
0 |
Processo |
@! |
ExistCpo("AC1") .AND. Ft300AtAIJ() |
AC2 |
R |
|
|
S |
AD1_STAGE |
C |
6 |
0 |
Estagio |
@! |
ExistCpo("AC2",FwFldGet("AD1_PROVEN")+FwFldGet("AD1_STAGE")) .AND. Ft300AtAIJ() |
|
R |
|
|
S |
AD1_PERCEN |
N |
3 |
0 |
Estagio % |
999 |
|
|
V |
|
|
S |
AD1_CODMEM |
C |
6 |
0 |
Link - SYP |
@! |
|
|
R |
|
|
S |
AD1_MEMO |
M |
80 |
0 |
Notas |
@! |
|
|
V |
|
|
S |
AD1_DTPFIM |
D |
8 |
0 |
Dt.Prev. Fim |
|
FwFldGet("AD1_DTPFIM") >= dDataBase |
|
R |
|
|
S |
AD1_DTPENC |
D |
8 |
0 |
Dt.Prev.Enc |
|
|
|
R |
|
|
S |
AD1_HRPENC |
C |
5 |
0 |
Hr.Prev.Enc |
99:99 |
|
|
R |
|
|
S |
AD1_MOEDA |
N |
2 |
0 |
Moeda |
99 |
|
|
|
|
|
S |
AD1_RCINIC |
N |
12 |
2 |
Prev. Inic. |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
AD1_VERBA |
N |
12 |
2 |
Receita Est. |
@E 999,999,999.99 |
Positivo() |
|
R |
|
IIF(!INCLUI,Ft300VrPro(),.T.) |
S |
AD1_RCFECH |
N |
12 |
2 |
Mensalidade |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
AD1_RCREAL |
N |
12 |
2 |
Receita Real |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
N |
AD1_CUSTO |
N |
12 |
2 |
Custo |
@E 999,999,999.99 |
|
|
R |
|
|
S |
AD1_FEELIN |
C |
1 |
0 |
Temperatura |
@! |
Pertence("123") |
|
R |
1=Baixa;2=Media;3=Alta |
|
S |
AD1_FCS |
C |
6 |
0 |
F.C.S. |
@! |
Vazio() .Or. ExistCpo("SX5","A6"+FwFldGet("AD1_FCS")) |
A6 |
R |
|
FwFldGet("AD1_STATUS")$"19".AND.Empty(FwFldGet("AD1_FCI")) |
S |
AD1_DESFCS |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
AD1_FCI |
C |
6 |
0 |
F.C.I. |
@! |
Vazio() .Or. ExistCpo("SX5","A6"+FwFldGet("AD1_FCI")) |
A6 |
R |
|
FwFldGet("AD1_STATUS")$"123".AND.Empty(FwFldGet("AD1_FCS")) |
S |
AD1_DESFCI |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
AD1_PRIOR |
C |
1 |
0 |
Prioridade |
9 |
Pertence("123") |
|
R |
1=Baixa;2=Media;3=Alta |
|
S |
AD1_STATUS |
C |
1 |
0 |
Status |
@! |
Ft300VdVis() .AND. Ft300VProp() .AND. Ft300VldFC() .AND. Ft300OpEnc() |
|
R |
1=Aberto;2=Perdido;3=Suspenso;9=Ganha |
!Empty(FwFldGet("AD1_FCI")) .OR. !Empty(FwFldGet("AD1_FCS")) |
S |
AD1_ENCERR |
C |
6 |
0 |
Encerramento |
@! |
Vazio() .OR. ExistCpo("SUN") |
SUN |
R |
|
IIF(FwFldGet("AD1_STATUS") $ "2|3",.T.,.F.) |
S |
AD1_MTVENC |
M |
10 |
0 |
Motivo |
|
|
|
R |
|
!Empty(FwFldGet("AD1_ENCERR")) |
S |
AD1_MODO |
C |
1 |
0 |
Modo |
@! |
Pertence("12") |
|
R |
1=Manual;2=Automatico |
|
S |
AD1_MEMENC |
C |
6 |
0 |
Descr.Encerr |
@! |
|
|
R |
|
|
S |
AD1_COMUNI |
C |
6 |
0 |
Comunicacao |
@! |
Vazio() .OR. ExistCpo("SUL",FwFldGet("AD1_COMUNI")) |
SUL |
R |
|
|
S |
AD1_CANAL |
C |
6 |
0 |
Un. Negocio |
@! |
Vazio() .OR. ExistCpo("ADK") |
ADK |
R |
|
|
S |
AD1_TABELA |
C |
3 |
0 |
Tabela |
|
Vazio() .OR. ( ExistCpo("DA0") .AND. MaVldTabPrc(FwFldGet("AD1_TABELA")) ) |
DA0 |
R |
|
|
S |
AD1_CODPRO |
C |
15 |
0 |
Produto |
@! |
Vazio() .Or. ExistCpo("SB1") |
SB1 |
|
|
|
S |
AD1_DESPRO |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
AD1_SETOR |
C |
1 |
0 |
Setor |
@! |
Pertence("12") |
|
R |
1=Publico;2=Privado |
|
S |
AD1_CODCAT |
C |
3 |
0 |
Cod.Categ |
@! |
|
ADO |
R |
|
|
S |
AD1_VISTEC |
C |
1 |
0 |
Vist.Tecnica |
@! |
|
|
R |
1=Sim;2=Nao |
|
N |
AD1_CODVIS |
C |
6 |
0 |
Vistoria Tec |
@! |
|
|
R |
|
|
N |
AD1_SITVIS |
C |
1 |
0 |
Sit.Vist.Tec |
@! |
|
|
R |
1=Em Aberto;2=Agendado;3=Concluida;4=Nenhuma |
|
N |
AD1_NUMORC |
C |
6 |
0 |
Orcamento |
@! |
|
|
|
|
|
S |
AD1_PROPOS |
C |
6 |
0 |
Proposta |
|
|
|
R |
|
|
S |
AD1_TPCAMP |
C |
1 |
0 |
Tipo Camp |
|
|
|
R |
|
|
S |
AD1_CHVCAM |
C |
14 |
0 |
Codigo |
|
|
|
R |
|
|
S |
AD1_CODTMK |
C |
6 |
0 |
Cod Atend |
@! |
|
|
R |
|
|
S |
AD1_REGSLA |
C |
6 |
0 |
Registro SLA |
|
|
|
R |
|
|
S |
AD1_IDESTN |
C |
30 |
0 |
Id.Estr.Neg |
@! |
|
|
R |
|
|
S |
AD1_NVESTN |
N |
2 |
0 |
Nvl. Est.Neg |
99 |
|
|
R |
|
|
S |
AD1_MSBLQL |
C |
1 |
0 |
Registro |
@! |
Pertence("12") |
|
R |
1=Inativo;2=Ativo |
|
S |
AD1_DTASSI |
D |
8 |
0 |
Dt.Ass.Prop. |
|
|
|
R |
|
M->AD1_STATUS == '9' |
S |
AD1_OBSPRO |
M |
10 |
0 |
Obs.Proposta |
|
|
|
R |
|
|
S |
AD1_CNTPRO |
C |
6 |
0 |
Contato Ass. |
@! |
Ft300VlSU5() |
SU5001 |
R |
|
!Empty(M->AD1_DTASSI) |
S |
AD1_NOMCNT |
C |
30 |
0 |
Nome contato |
|
|
|
V |
|
|
S |
AD1_USRASS |
C |
6 |
0 |
Usuario Resp |
|
|
|
R |
|
|
S |
AD1_DSCUSR |
C |
30 |
0 |
Nome Usuario |
|
|
|
V |
|
|
S |
AD1_DESCAM |
C |
40 |
0 |
Desc. Camp. |
|
|
|
V |
|
|
S |