Tabela |
BGH |
Vigencias do Grupo Operadora |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
BGH_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
BGH_GRUOPE |
C |
2 |
0 |
Codigo |
@! |
|
|
|
|
|
S |
BGH_CODSEQ |
C |
3 |
0 |
Codigo Seq. |
@! |
|
|
R |
|
|
S |
BGH_DATINI |
D |
8 |
0 |
Data Inicial |
|
|
|
|
|
|
S |
BGH_DATFIN |
D |
8 |
0 |
Data Final |
|
|
|
|
|
|
S |
BGH_VLRFIL |
N |
16 |
4 |
Vlr.Filme |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
BGH_VLRTAX |
N |
16 |
2 |
Vlr.Tx.Pagar |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
BGH_VLRTRC |
N |
16 |
2 |
Vlr.Tx.Receb |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
BGH_NIVVAL |
C |
1 |
0 |
Nivel Valido |
@! |
|
|
|
1=Sim;0=Nao |
M->BGH_VLRTAX==0 .And. M->BGH_VLRTRC == 0 |
S |
BGH_TABPAG |
C |
3 |
0 |
Tab.Pagto |
@! |
VAZIO() .OR. BF8->(ExistCpo("BF8",PLSINTPAD()+M->BGH_TABPAG,1)) |
BH2PLS |
|
|
|
S |
BGH_TABREC |
C |
3 |
0 |
Tab.Recto |
@! |
VAZIO() .OR. BF8->(ExistCpo("BF8",plsintpad()+M->BGH_TABREC,1)) |
BH2PLS |
|
|
|
S |
BGH_LIMCH |
N |
7 |
2 |
Limite Aut. |
@E 999.99 |
|
|
|
|
|
S |
BGH_TIPLIM |
C |
1 |
0 |
Tipo Limite |
@C |
|
|
|
1=Limite em CH;2=Limite em Reais |
|
S |
BGH_PERCON |
N |
4 |
0 |
Period.Cons. |
9999 |
|
|
|
|
|
S |
BGH_UNPERI |
C |
1 |
0 |
Unidade |
@! |
|
|
|
1=Horas;2=Dias;3=Meses;4=Anos;5=Vida |
|
S |
BGH_BANDAP |
N |
16 |
2 |
Banda Pag. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
BGH_BANDAR |
N |
16 |
2 |
Banda Rec. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
BGH_TIPUSR |
C |
1 |
0 |
Tipo Benef. |
@! |
If(Empty(M->BGH_TIPUSR),.T.,ExistCpo("BIH",M->BGH_TIPUSR,1)) |
B47PLS |
|
|
|
S |
BGH_DESTIP |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BGH_GRAUPA |
C |
2 |
0 |
Grau Parent. |
@! |
IF(Empty(M->BGH_GRAUPA),.T.,ExistCpo("BRP",M->BGH_GRAUPA,1)) |
B37PLS |
|
|
|
S |
BGH_DESGRA |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BGH_IDAINI |
N |
3 |
0 |
Idade Minima |
999 |
Positivo() .AND. If(!Empty(M->BGH_IDAINI),M->BGH_IDAFIN >= M->BGH_IDAINI,.T.) |
|
R |
|
|
N |
BGH_IDAFIN |
N |
3 |
0 |
Idade Maxima |
999 |
Positivo() .AND. If(!Empty(M->BGH_IDAINI),M->BGH_IDAFIN >= M->BGH_IDAINI,.T.) |
|
R |
|
|
N |
BGH_FAISAL |
C |
1 |
0 |
Fxa Salarial |
@! |
Pertence(" 12345") |
|
R |
1=Nivel 1;2=Nivel 2;3=Nivel 3;4=Nivel 4;5=Nivel 5 |
|
S |
BGH_RDACRE |
C |
1 |
0 |
Rede Credenc |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
BGH_RDAPRE |
C |
1 |
0 |
Rede Prefere |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
M->BGH_RDACRE = "1" |
S |
BGH_PERCO2 |
N |
16 |
2 |
% Co-Part2 |
@E 9,999,999,999,999.99 |
|
|
R |
|
M->BGH_VLRCO2 = 0 |
S |
BGH_VLRCO2 |
N |
16 |
2 |
Vlr.Co-Par2 |
@E 9,999,999,999,999.99 |
|
|
R |
|
M->BGH_PERCO2 = 0 |
S |
BGH_VLRMIN |
N |
16 |
2 |
Valor Minimo |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
BGH_ACUMUL |
C |
1 |
0 |
Cons. p/Acum |
@! |
Pertence("12") |
|
R |
1=Inclusao do Contrato;2=Inclusao do Usuario |
|
S |
BGH_SEQREL |
C |
3 |
0 |
Seq Rel |
@! |
ExistCpo("BP8",PlsIntPad()+M->BGH_SEQREL,1) |
BP8PLS |
R |
|
|
S |
BGH_FINATE |
C |
2 |
0 |
Finalidade |
@! |
Vazio() .or. BGY->(ExistCpo("BGY",PlsIntPad()+M->BGH_FINATE,1)) |
BGYPLS |
R |
|
|
S |
BGH_DESFIN |
C |
70 |
0 |
Ds Finalidad |
@! |
|
|
V |
|
|
S |
BGH_DIFIDA |
C |
1 |
0 |
Per Dif Idad |
@! |
|
|
R |
1=Sim;2=Nao |
|
S |