Tabela |
BXN |
Metas de Vendas |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
BXN_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
BXN_CODINT |
C |
4 |
0 |
Operadora |
@R !.!!! |
ExistCpo("BA0",M->BXN_CODINT,1) |
B89PLS |
|
|
|
S |
BXN_DESINT |
C |
60 |
0 |
Descr. Oper. |
@! |
|
|
V |
|
|
S |
BXN_ANO |
C |
4 |
0 |
Ano |
@! |
|
|
|
|
|
S |
BXN_TIPO |
C |
1 |
0 |
Tipo |
@! |
pertence("123") |
|
|
1=Vendas;2=Comissao;3=Ambas |
|
S |
BXN_CODEQU |
C |
3 |
0 |
Cod Equipe |
@! |
vazio() .or. ExistCpo("BXL",M->BXN_CODEQU,1) |
BXLPLS |
|
|
|
S |
BXN_DESEQU |
C |
30 |
0 |
Nome Equipe |
@! |
|
|
V |
|
|
S |
BXN_CODVEN |
C |
6 |
0 |
Cod Vendedor |
@! |
vazio() .or. ExistCpo("SA3",M->BXN_CODVEN,1) |
SA3 |
|
|
|
S |
BXN_DESVEN |
C |
40 |
0 |
Nome Vend. |
@! |
|
|
V |
|
|
S |
BXN_TIPPLA |
C |
1 |
0 |
Tipo Plano |
@! |
|
|
|
1=Pessoa Fisica;2=Pessoa Juridica |
|
S |
BXN_TIPINC |
C |
1 |
0 |
Tipo Inclus. |
@! |
|
|
|
1=Plano Novo;2=Adesao;3=Dependente;4=Transferencia;5=Adaptacao |
|
S |
BXN_CODPRO |
C |
4 |
0 |
Produto |
@! |
vazio() .or. ExistCpo("BI3",M->BXN_CODINT+M->BXN_CODPRO,1) |
B51PLS |
|
|
|
S |
BXN_DESPRO |
C |
60 |
0 |
Descr. Prod. |
@! |
|
|
V |
|
|
S |
BXN_Q01 |
N |
6 |
0 |
Meta Jan |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q02 |
N |
6 |
0 |
Meta Fev |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q03 |
N |
6 |
0 |
Meta Mar |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q04 |
N |
6 |
0 |
Meta Abr |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q05 |
N |
6 |
0 |
Meta Mai |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q06 |
N |
6 |
0 |
Meta Jun |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q07 |
N |
6 |
0 |
Meta Jul |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q08 |
N |
6 |
0 |
Meta Ago |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q09 |
N |
6 |
0 |
Meta Set |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q10 |
N |
6 |
0 |
Meta Out |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q11 |
N |
6 |
0 |
Meta Nov |
@E 999999 |
|
|
R |
|
|
S |
BXN_Q12 |
N |
6 |
0 |
Meta Dez |
@E 999999 |
|
|
R |
|
|
S |
BXN_QTOT |
N |
6 |
0 |
Meta Anual |
@E 999999 |
|
|
R |
|
|
S |
BXN_R01 |
N |
6 |
0 |
Real Jan |
@E 999999 |
|
|
R |
|
|
S |
BXN_R02 |
N |
6 |
0 |
Real Fev |
@E 999999 |
|
|
R |
|
|
S |
BXN_R03 |
N |
6 |
0 |
Real Mar |
@E 999999 |
|
|
R |
|
|
S |
BXN_R04 |
N |
6 |
0 |
Real Abr |
@E 999999 |
|
|
R |
|
|
S |
BXN_R05 |
N |
6 |
0 |
Real Mai |
@E 999999 |
|
|
R |
|
|
S |
BXN_R06 |
N |
6 |
0 |
Real Jun |
@E 999999 |
|
|
R |
|
|
S |
BXN_R07 |
N |
6 |
0 |
Real Jul |
@E 999999 |
|
|
R |
|
|
S |
BXN_R08 |
N |
6 |
0 |
Real Ago |
@E 999999 |
|
|
R |
|
|
S |
BXN_R09 |
N |
6 |
0 |
Real Set |
@E 999999 |
|
|
R |
|
|
S |
BXN_R10 |
N |
6 |
0 |
Real Out |
@E 999999 |
|
|
R |
|
|
S |
BXN_R11 |
N |
6 |
0 |
Real Nov |
@E 999999 |
|
|
R |
|
|
S |
BXN_R12 |
N |
6 |
0 |
Real Dez |
@E 999999 |
|
|
R |
|
|
S |
BXN_RTOT |
N |
6 |
0 |
Real Anual |
@E 999999 |
|
|
R |
|
|
S |
BXN_V01 |
N |
12 |
2 |
Vlr Mes 01 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V02 |
N |
12 |
2 |
Vlr Mes 02 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V03 |
N |
12 |
2 |
Vlr Mes 03 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V04 |
N |
12 |
2 |
Vlr Mes 04 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V05 |
N |
12 |
2 |
Vlr Mes 05 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V06 |
N |
12 |
2 |
Vlr Mes 06 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V07 |
N |
12 |
2 |
Vlr Mes 07 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V08 |
N |
12 |
2 |
Vlr Mes 08 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V09 |
N |
12 |
2 |
Vlr Mes 09 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V10 |
N |
12 |
2 |
Vlr Mes 10 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V11 |
N |
12 |
2 |
Vlr Mes 11 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_V12 |
N |
12 |
2 |
Vlr Mes 12 |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_VTOT |
N |
15 |
2 |
Vlr Tot Ano |
@E 999,999,999.99 |
|
|
R |
|
|
S |
BXN_SEQ |
C |
6 |
0 |
Sequencial |
@! |
|
|
|
|
|
S |