| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| BHE | Grupo Empresas Co-Participacao | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| BHE_FILIAL | C | 2 | 0 | Filial | S | ||||||
| BHE_CODINT | C | 4 | 0 | Cd Operadora | @! | B41PLS | S | ||||
| BHE_CODIGO | C | 4 | 0 | Grp/Empresa | @! | S | |||||
| BHE_SEQUEN | C | 3 | 0 | Sequencia | @! | S | |||||
| BHE_TIPO | C | 1 | 0 | Reg. Atdmto | @! | 1=Internacao;2=Ambulatorial;3=Ambos | S | ||||
| BHE_QTD | N | 6 | 0 | Qtd. Ate | 999999 | S | |||||
| BHE_PERCOP | N | 16 | 2 | % Co-Part. | @E 9,999,999,999,999.99 | PLSA660WHE("04") | S | ||||
| BHE_VLRCOP | N | 16 | 2 | Vlr.CoPar. | @E 9,999,999,999,999.99 | PLSA660WHE("05") | S | ||||
| BHE_TXADM | N | 16 | 2 | Taxa Admin. | @E 9,999,999,999,999.99 | S | |||||
| BHE_LIMFRA | N | 16 | 2 | Vlr.Franquia | @E 9,999,999,999,999.99 | S | |||||
| BHE_VALUS | N | 16 | 4 | Valor U.S | @E 99,999,999,999.9999 | PLSA660WHE("06") | S | ||||
| BHE_CODTAB | C | 7 | 0 | Tab.CoPar. | @R !!!!.!!! | Vazio() .or. ExistCpo("BF8",M->BHE_CODTAB,1) | B68PLS | M->BHE_PERCOP > 0 | S | ||
| BHE_SOMCOM | C | 1 | 0 | Som.p/Compra | @! | 1=Sim;0=Nao | M->BHE_PAGATO$"0, " | S | |||
| BHE_PAGATO | C | 1 | 0 | Pagto no Ato | @! | 1=Sim;0=Nao | M->BHE_SOMCOM$"0, " | S | |||
| BHE_PAGRDA | C | 1 | 0 | Pagto na RDA | @! | 1=Sim;0=Nao | S | ||||
| BHE_GRPINT | C | 3 | 0 | Grp Intern. | @! | BQR->(ExistCpo("BQR")) | BAFPLS | M->BHE_TIPO=="1" | S | ||
| BHE_NUMCON | C | 12 | 0 | Num.Contrato | S | ||||||
| BHE_VERCON | C | 3 | 0 | Versao Cont. | S | ||||||
| BHE_SUBCON | C | 9 | 0 | Sub-contrato | S | ||||||
| BHE_VERSUB | C | 3 | 0 | Versao Sub. | S | ||||||
| BHE_CODPRO | C | 4 | 0 | Produto | S | ||||||
| BHE_CODPAD | C | 2 | 0 | Tipo Tab.Pad | S | ||||||
| BHE_CODPSA | C | 16 | 0 | Tab. Padrao | S | ||||||
| BHE_ANOMES | C | 6 | 0 | Ano/Mes Reaj | @R !!!!/!! | N | |||||
| BHE_VERPRO | C | 3 | 0 | Versao | @! | R | N | ||||
| BHE_VLRANT | N | 16 | 2 | Valor Ant. | @E 9,999,999,999,999.99 | N | |||||
| BHE_TIPUSR | C | 1 | 0 | Tipo Benef. | @! | If(Empty(M->BHE_TIPUSR),.T.,ExistCpo("BIH",M->BHE_TIPUSR,1)) | B47PLS | N | |||
| BHE_DESTIP | C | 30 | 0 | Descricao | @! | V | N | ||||
| BHE_GRAUPA | C | 2 | 0 | Grau Parent. | @! | IF(Empty(M->BHE_GRAUPA),.T.,ExistCpo("BRP",M->BHE_GRAUPA,1)) | B37PLS | N | |||
| BHE_DESGRA | C | 30 | 0 | Descricao | @! | V | N | ||||
| BHE_IDAINI | N | 3 | 0 | Idade Minima | 999 | Positivo() .AND. M->BHE_IDAINI <= M->BHE_IDAFIN | N | ||||
| BHE_IDAFIN | N | 3 | 0 | Idade Maxima | 999 | Positivo() .AND. If(!Empty(M->BHE_IDAINI),M->BHE_IDAFIN >= M->BHE_IDAINI,.T.) | N | ||||
| BHE_FAISAL | C | 1 | 0 | Fxa Salarial | @! | Pertence(" 12345") | R | 1=Nivel 1;2=Nivel 2;3=Nivel 3;4=Nivel 4;5=Nivel 5 | N | ||
| BHE_RDACRE | C | 1 | 0 | Rede Credenc | @! | Pertence("12") | R | 1=Sim;2=Nao | N | ||
| BHE_RDAPRE | C | 1 | 0 | Rede Prefere | @! | Pertence("12") | R | 1=Sim;2=Nao | M->BHE_RDACRE = "1" | N | |
| BHE_PERCO2 | N | 16 | 2 | % Co-Part2 | @E 9,999,999,999,999.99 | R | M->BHE_VLRCO2 = 0 | N | |||
| BHE_VLRCO2 | N | 16 | 2 | Vlr.Co-Par2 | @E 9,999,999,999,999.99 | R | M->BHE_PERCO2 = 0 | N | |||
| BHE_VLRMIN | N | 16 | 2 | Valor Minimo | @E 9,999,999,999,999.99 | R | N | ||||
| BHE_ACUMUL | C | 1 | 0 | Cons. p/Acum | @! | Pertence("12") | R | 1=Inclusao do Contrato;2=Inclusao do Usuario | N | ||
| BHE_VIGINI | D | 8 | 0 | Vig. Inicial | PlsVldBHE() | R | S | ||||
| BHE_VIGFIN | D | 8 | 0 | Vig. Final | PlsVldBHE() | R | S | ||||
| BHE_FINATE | C | 2 | 0 | Finalidade | @! | Vazio() .or. BGY->(ExistCpo("BGY",M->BQC_CODINT+M->BHE_FINATE,1)) | BGYPLS | R | S | ||
| BHE_DESFIN | C | 70 | 0 | Ds Finalidad | @! | V | S | ||||