Tabela |
BGL |
Produtos Municipio Atendimento |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
BGL_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
BGL_CODINT |
C |
4 |
0 |
Cd Operadora |
@! |
|
B41PLS |
|
|
|
S |
BGL_CODIGO |
C |
4 |
0 |
Grp/Empresa |
@! |
|
|
|
|
|
S |
BGL_NUMCON |
C |
12 |
0 |
Num.Contrato |
|
|
|
|
|
|
S |
BGL_VERCON |
C |
3 |
0 |
Versao Cont. |
|
|
|
|
|
|
S |
BGL_SUBCON |
C |
9 |
0 |
Sub-contrato |
|
|
|
|
|
|
S |
BGL_VERSUB |
C |
3 |
0 |
Versao Sub. |
|
|
|
|
|
|
S |
BGL_CODPRO |
C |
4 |
0 |
Produto |
|
|
|
|
|
|
S |
BGL_VERPRO |
C |
3 |
0 |
Versao |
|
|
|
|
|
|
S |
BGL_CODMUN |
C |
7 |
0 |
Municipio |
@! |
|
|
|
|
|
S |
BGL_TIPO |
C |
1 |
0 |
Reg Atendto |
@! |
|
|
|
1=Internacao;2=Ambulatorial;3=Ambos |
|
S |
BGL_QTD |
N |
6 |
0 |
Qtd. Ate |
999999 |
|
|
|
|
|
S |
BGL_VALCOP |
N |
16 |
2 |
Vlr.Co-Part. |
@E 9,999,999,999,999.99 |
|
|
|
|
M->BGL_PERCOP = 0 |
S |
BGL_PERCOP |
N |
16 |
2 |
% Co-Part. |
@E 9,999,999,999,999.99 |
|
|
|
|
M->BGL_VALCOP = 0 |
S |
BGL_CODTAB |
C |
7 |
0 |
Tab.CoPar. |
@R !!!!.!!! |
Vazio() .or. ExistCpo("BF8",M->BGL_CODTAB,1) |
B68PLS |
|
|
|
S |
BGL_TXADM |
N |
16 |
2 |
Taxa Admin. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
BGL_LIMFRA |
N |
16 |
2 |
Vlr.Franq. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
BGL_SOMCOM |
C |
1 |
0 |
Som.p/Compra |
@! |
|
|
|
1=Sim;0=Nao |
|
S |
BGL_PAGATO |
C |
1 |
0 |
Pagto no Ato |
@! |
|
|
|
1=Sim;0=Nao |
|
S |
BGL_VALUS |
N |
16 |
4 |
Valor U.S |
@E 99,999,999,999.9999 |
|
|
|
|
M->BGL_PERCOP>0 |
S |
BGL_CODPAD |
C |
2 |
0 |
Cd.Tp.Tabela |
@! |
ExistCpo("BR4",M->BGL_CODPAD,1) |
B41PLS |
|
|
|
S |
BGL_CDPROC |
C |
16 |
0 |
Cod.Proced. |
@! |
ExistCpo("BR8",M->BGL_CODPAD+M->BGL_CDPROC,1) |
BR3PLS |
|
|
|
S |
BGL_DESCRI |
C |
40 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BGL_ANOMES |
C |
6 |
0 |
Ano/Mes Reaj |
@R !!!!/!! |
|
|
|
|
|
N |
BGL_VLRANT |
N |
16 |
2 |
Valor Ant. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
N |
BGL_TIPUSR |
C |
1 |
0 |
Tipo Benef. |
@! |
If(Empty(M->BGL_TIPUSR),.T.,ExistCpo("BIH",M->BGL_TIPUSR,1)) |
B47PLS |
|
|
|
S |
BGL_DESTIP |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BGL_GRAUPA |
C |
2 |
0 |
Grau Parent. |
@! |
IF(Empty(M->BGL_GRAUPA),.T.,ExistCpo("BRP",M->BGL_GRAUPA,1)) |
B37PLS |
|
|
|
S |
BGL_DESGRA |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BGL_IDAINI |
N |
3 |
0 |
Idade Minima |
999 |
Positivo() .AND. M->BGL_IDAINI <= M->BGL_IDAFIN |
|
|
|
|
S |
BGL_IDAFIN |
N |
3 |
0 |
Idade Maxima |
999 |
Positivo() .AND. If(!Empty(M->BGL_IDAINI),M->BGL_IDAFIN >= M->BGL_IDAINI,.T.) |
|
|
|
|
S |
BGL_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 |
BGL_RDACRE |
C |
1 |
0 |
Rede Credenc |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
BGL_RDAPRE |
C |
1 |
0 |
Rede Prefere |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
M->BGL_RDACRE = "1" |
S |
BGL_PERCO2 |
N |
16 |
2 |
% Co-Part2 |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
BGL_VLRCO2 |
N |
16 |
2 |
Vlr.Co-Par2 |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
BGL_VLRMIN |
N |
16 |
2 |
Valor Minimo |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
BGL_ACUMUL |
C |
1 |
0 |
Cons. p/Acum |
@! |
Pertence("12") |
|
R |
1=Inclusao do Contrato;2=Inclusao do Usuario |
|
S |
BGL_VIGINI |
D |
8 |
0 |
Vig. Inicial |
@D |
PlsVldBGL() |
|
R |
|
|
S |
BGL_VIGFIN |
D |
8 |
0 |
Vig. Final |
@D |
PlsVldBGL() |
|
R |
|
|
S |
BGL_FINATE |
C |
2 |
0 |
Finalidade |
@! |
Vazio() .or. BGY->(ExistCpo("BGY",M->BQC_CODINT+M->BGL_FINATE,1)) |
BGYPLS |
R |
|
|
S |
BGL_DESFIN |
C |
70 |
0 |
Ds Finalidad |
@! |
|
|
V |
|
|
S |