| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VDM | Interesses Oport. de Negocios | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VDM_FILIAL | C | 2 | 0 | Filial | S | ||||||
| VDM_CODOPO | C | 6 | 0 | Cod. Oport. | @! | R | S | ||||
| VDM_CODINT | C | 6 | 0 | Interesse | @! | R | S | ||||
| VDM_CAMPOP | C | 6 | 0 | Campanha | @! | ExistCpo("VX5","026"+M->VDM_CAMPOP) | VX5 | R | Empty(M->VDM_NUMATE) | S | |
| VDM_CODMAR | C | 3 | 0 | Marca | @! | VE1 | R | Empty(M->VDM_CODINT) | S | ||
| VDM_MODVEI | C | 30 | 0 | Modelo | @! | FG_Seek("VV2","M->VDM_CODMAR+M->VDM_MODVEI",1,.f.,"VDM_DESMOD","VV2_DESMOD") | VV2SQL | R | Empty(M->VDM_CODINT) | S | |
| VDM_DESMOD | C | 30 | 0 | Descr. Mod. | @!S30 | V | S | ||||
| VDM_CORVEI | C | 6 | 0 | Cor | @! | FG_Seek("VVC","M->VDM_CODMAR+M->VDM_CORVEI",1,.f.,"VDM_DESCOR","VVC_DESCRI") | VVC | R | Empty(M->VDM_NUMATE) | S | |
| VDM_DESCOR | C | 30 | 0 | Descr Cor | @S20 | V | S | ||||
| VDM_OPCFAB | C | 100 | 0 | Opcionais | @S!50 | R | S | ||||
| VDM_QTDINT | N | 3 | 0 | Qtd Interess | @E 999 | positivo() | R | Empty(M->VDM_NUMATE) | S | ||
| VDM_DATINT | D | 8 | 0 | Dta Interess | R | Empty(M->VDM_NUMATE) | S | ||||
| VDM_DATLIM | D | 8 | 0 | Data Limite | M->VDM_DATLIM >= M->VDM_DATINT | R | Empty(M->VDM_NUMATE) | S | |||
| VDM_OBSERV | M | 70 | 0 | Observacao | @! | V | Empty(M->VDM_NUMATE) | S | |||
| VDM_NOMVEN | C | 40 | 0 | Nome | @! | V | S | ||||
| VDM_CODVEN | C | 6 | 0 | Vendedor | @! | VM680VEND() | SA3 | R | Empty(M->VDM_NUMATE) | S | |
| VDM_CODFAS | C | 6 | 0 | Cod. Fase | @! | VCM680VLD() | VDKFAS | R | Empty(M->VDM_NUMATE) | S | |
| VDM_DESFAS | C | 30 | 0 | Descr.Fase | @! | V | S | ||||
| VDM_DTFASO | D | 8 | 0 | Dt Fase Opor | M->VDM_DTFASO <= ddatabase | R | S | ||||
| VDM_HRFASO | N | 4 | 0 | Hr Fase Opor | @R 99:99 | R | S | ||||
| VDM_ABRATE | C | 1 | 0 | Abrir Atend. | @! | Pertence("012").and.VCM680TPA(M->VDM_ABRATE) | V | 0=Nao;1=Atendimento;2=Faturamento Direto | VCM680WHEN(1) | S | |
| VDM_FILATE | C | 2 | 0 | Filial Atend | R | S | |||||
| VDM_NUMATE | C | 10 | 0 | Nro Atendto | @! | R | S | ||||
| VDM_STAATE | C | 20 | 0 | Status Atend | @! | V | S | ||||
| VDM_TIPMID | C | 6 | 0 | Tp de Midia | @! | FG_Seek("VX5","'027'+M->VDM_TIPMID",1,.f.,"VDM_DESMID","VX5_DESCRI") | VX5 | R | Empty(M->VDM_NUMATE) | S | |
| VDM_DESMID | C | 30 | 0 | Descr.Midia | @! | V | S | ||||
| VDM_TIPCON | C | 1 | 0 | Tp Contato | @! | PERTENCE("12") | R | 1=Ativo;2=Passivo | Empty(M->VDM_NUMATE) | S | |
| VDM_FASFIN | C | 10 | 0 | Fase Financ. | @! | FG_Seek("VX5","'031'+M->VDM_FASFIN",1,.f.,"VDM_NOMFIN","VX5_DESCRI").or.Empty() | VX5 | R | VCM680WHEN(2) | S | |
| VDM_NOMFIN | C | 40 | 0 | Nome Financ. | @! | V | S | ||||
| VDM_DTFASF | D | 8 | 0 | Dt Fase Fin | M->VDM_DTFASF <= ddatabase | R | VCM680WHEN(2) | S | |||
| VDM_HRFASF | N | 4 | 0 | Hr Fase Fin | @R 99:99 | V | VCM680WHEN(2) | S | |||
| VDM_CODBCO | C | 3 | 0 | Banco | @! | A63 | R | VCM680WHEN(2) | S | ||
| VDM_NOMBCO | C | 3 | 0 | Banco | @! | R | VCM680WHEN(2) | S | |||
| VDM_CODAGE | C | 5 | 0 | Cod.Agencia | @! | R | VCM680WHEN(2) | S | |||
| VDM_CONCOR | C | 5 | 0 | Cod.Agencia | @! | R | VCM680WHEN(2) | S | |||
| VDM_NOMGER | C | 15 | 0 | Nome Gerente | @! | R | VCM680WHEN(2) | S | |||
| VDM_NROTEL | C | 15 | 0 | Telefone | @! | R | VCM680WHEN(2) | S | |||
| VDM_NOMCID | C | 60 | 0 | Cidade | @! | R | VCM680WHEN(2) | S | |||
| VDM_LINCRE | C | 10 | 0 | Linha Credit | @! | ExistCPO("VX5","032"+M->VDM_LINCRE) | VX5 | R | VCM680WHEN(2) | S | |
| VDM_MOTCAN | C | 6 | 0 | Mot. Cancel. | @! | Vazio() .or. FG_SEEK("VS0","'000011'+M->VDM_MOTCAN",1,.f.) | VS0 | R | Empty(M->VDM_NUMATE) | S | |
| VDM_ITETRA | C | 2 | 0 | Item | @! | S | |||||
| VDM_CCLIBC | C | 6 | 0 | Cod.Cli.Bco | @! | vazio().or.FG_Seek("SA1","M->VDM_CCLIBC+Alltrim(M->VDM_LCLIBC)",1,.f.,"VDM_NCLIBC","A1_NOME") | SA1 | R | VCM680WHEN(2) | S | |
| VDM_LCLIBC | C | 2 | 0 | Loj.Cli.Bco | @! | vazio().or.FG_Seek("SA1","M->VDM_CCLIBC+M->VDM_LCLIBC",1,.f.,"VDM_NCLIBC","A1_NOME") | R | VCM680WHEN(2) | S | ||
| VDM_NCLIBC | C | 30 | 0 | Nom.Cli.Bco | @! | V | S | ||||
| VDM_VLRMON | N | 14 | 2 | Vlr.Montador | @E 99,999,999,999.99 | Positivo() | R | VCM680WHEN(2) | S | ||
| VDM_VLROFE | N | 14 | 2 | Vlr.Ofertado | @E 99,999,999,999.99 | Positivo() | R | VCM680WHEN(2) | S | ||
| VDM_VLRCLI | N | 14 | 2 | Vlr.Prop.Cli | @E 99,999,999,999.99 | Positivo() | R | VCM680WHEN(2) | S | ||
| VDM_VLRVDA | N | 14 | 2 | Vlr.Venda | @E 99,999,999,999.99 | Positivo() | R | VCM680WHEN(2) | S | ||
| VDM_DATVDA | D | 8 | 0 | Data Venda | R | VCM680WHEN(2) | S | ||||
| VDM_VLRCOM | N | 14 | 2 | Vlr.Comissao | @E 99,999,999,999.99 | Positivo() | R | VCM680WHEN(2) | S | ||
| VDM_QTDUSA | N | 2 | 0 | Qtd.Usados | @E 99 | Positivo() | R | VCM680WHEN(2) | S | ||
| VDM_VLRUSA | N | 14 | 2 | Vlr.Usados | @E 99,999,999,999.99 | Positivo() | R | VCM680WHEN(2) | S | ||
| VDM_DECVDA | C | 10 | 0 | Decisao Vda | @! | FG_Seek("VX5","'044'+M->VDM_DECVDA",1,.F.,"VDM_DECDES","VX5_DESCRI") | VX5 | S | |||
| VDM_DECDES | C | 30 | 0 | Desc.Decisao | @! | V | S | ||||
| VDM_VLRNEG | N | 12 | 2 | Val. Negoc. | @E 999,999,999.99 | Positivo() | R | S | |||