Tabela |
BB3 |
Faixas Etarias dos Produtos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
BB3_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
BB3_CODIGO |
C |
8 |
0 |
Cod. Plano |
@! |
|
|
|
|
|
S |
BB3_VERSAO |
C |
3 |
0 |
Versao |
@! |
|
|
|
|
|
S |
BB3_CODFOR |
C |
3 |
0 |
Forma Cobr. |
@! |
|
B26PLS |
|
|
|
S |
BB3_CODFAI |
C |
3 |
0 |
Codigo Faixa |
@! |
|
|
|
|
|
S |
BB3_TABVLD |
D |
8 |
0 |
Valida Ate |
|
|
|
|
|
|
S |
BB3_TIPUSR |
C |
1 |
0 |
Tipo Benef. |
@! |
If(Empty(M->BB3_TIPUSR),.T.,ExistCpo("BIH",M->BB3_TIPUSR,1)) |
B47PLS |
|
|
M->BB3_FAIFAM=="0" |
S |
BB3_DESTIP |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BB3_GRAUPA |
C |
2 |
0 |
Grau Parent. |
@! |
If(Empty(M->BB3_GRAUPA),.T.,ExistCpo("BRP",M->BB3_GRAUPA,1)) |
B37PLS |
|
|
M->BB3_FAIFAM=="0" |
S |
BB3_DESGRA |
C |
30 |
0 |
Desc.Grau P. |
@! |
|
|
V |
|
|
S |
BB3_SEXO |
C |
1 |
0 |
Sexo |
@! |
|
|
|
1=Masculino;2=Feminino;3=Ambos |
M->BB3_FAIFAM=="0" |
S |
BB3_IDAINI |
N |
3 |
0 |
Idade Minima |
999 |
PlVerFai("BB3_IDAINI","BB3_IDAFIN",1,OBrwBB3:aHeader,OBrwBB3:aCols,{"BB3_TIPUSR","BB3_GRAUPA","BB3_SEXO","BB3_TABVLD"}) |
|
|
|
M->BB3_FAIFAM=="0" |
S |
BB3_IDAFIN |
N |
3 |
0 |
Idade Maxima |
999 |
PlVerFai("BB3_IDAINI","BB3_IDAFIN",2,OBrwBB3:aHeader,OBrwBB3:aCols,{"BB3_TIPUSR","BB3_GRAUPA","BB3_SEXO","BB3_TABVLD"}) |
|
|
|
M->BB3_FAIFAM=="0" |
S |
BB3_VALFAI |
N |
16 |
2 |
Valor Faixa |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
BB3_FAIFAM |
C |
1 |
0 |
Fx. Familiar |
@! |
|
|
|
1=Sim;0=Nao |
BJ1->BJ1_FAIFAM="0" |
S |
BB3_QTDMIN |
N |
4 |
0 |
Qtd. Min Usr |
@! 9999 |
PlVerFai("BB3_QTDMIN","BB3_QTDMAX",1,OBrwBB3:aHeader,OBrwBB3:aCols,{"BB3_TIPUSR","BB3_GRAUPA","BB3_SEXO","BB3_TABVLD"}) |
|
|
|
M->BB3_FAIFAM=="1" |
S |
BB3_QTDMAX |
N |
4 |
0 |
Qtd. Max Usr |
@! 9999 |
PlVerFai("BB3_QTDMIN","BB3_QTDMAX",2,OBrwBB3:aHeader,OBrwBB3:aCols,{"BB3_TIPUSR","BB3_GRAUPA","BB3_SEXO","BB3_TABVLD"}) |
|
|
|
M->BB3_FAIFAM=="1" |
S |
BB3_REJAPL |
N |
5 |
2 |
Reajuste Apl |
@E 99.99 |
|
|
|
|
|
S |
BB3_PERREJ |
D |
8 |
0 |
DataBase Rej |
@D |
|
|
|
|
|
S |
BB3_ANOMES |
C |
6 |
0 |
Ano/Mes |
@R !!!!/!! |
|
|
|
|
|
S |
BB3_VLRANT |
N |
16 |
2 |
Valor Antigo |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |