| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| BHD | Produtos e Co-Participacao | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| BHD_FILIAL | C | 2 | 0 | Filial | S | ||||||
| BHD_CODIGO | C | 8 | 0 | Codigo | @! | B41PLS | S | ||||
| BHD_VERSAO | C | 3 | 0 | Versao | @! | S | |||||
| BHD_TIPO | C | 1 | 0 | Reg Atendto | @! | 1=Internacao;2=Ambulatorial;3=Ambos | S | ||||
| BHD_QTD | N | 6 | 0 | Qtd. Ate | 999999 | S | |||||
| BHD_PERCOP | N | 16 | 2 | % Co-Part. | @E 9,999,999,999,999.99 | PLSA800WHE("01") | S | ||||
| BHD_VLRCOP | N | 16 | 2 | Vlr.CoPar. | @E 9,999,999,999,999.99 | PLSA800WHE("02") | S | ||||
| BHD_VALUS | N | 16 | 4 | Valor U.S | @E 99,999,999,999.9999 | PLSA800WHE("03") | S | ||||
| BHD_TXADM | N | 16 | 2 | Taxa Admin. | @E 9,999,999,999,999.99 | S | |||||
| BHD_CODTAB | C | 7 | 0 | Tab.CoPar. | @R !!!!.!!! | Vazio() .or. ExistCpo("BF8",M->BHD_CODTAB,1) | B68PLS | M->BHD_PERCOP > 0 | S | ||
| BHD_LIMFRA | N | 16 | 2 | Vlr.Franq. | @E 9,999,999,999,999.99 | S | |||||
| BHD_SOMCOM | C | 1 | 0 | Som.p/Compra | @! | 1=Sim;0=Nao | M->BHD_PAGATO$"0, " | S | |||
| BHD_PAGATO | C | 1 | 0 | Pagto no Ato | @! | 1=Sim;0=Nao | M->BHD_SOMCOM$"0, " | S | |||
| BHD_PAGRDA | C | 1 | 0 | Pagto na RDA | @! | 1=Sim;0=Nao | S | ||||
| BHD_GRPINT | C | 3 | 0 | Grp Intern. | @! | BQR->(ExistCpo("BQR")) | BAFPLS | M->BHD_TIPO=="1" | S | ||
| BHD_CODPAD | C | 2 | 0 | Cod.Tipo Pad | @! | S | |||||
| BHD_SOMPRO | C | 1 | 0 | Somen.Proc.? | @! | 1=Sim;0=Nao | S | ||||
| BHD_CODPSA | C | 16 | 0 | Cod Tb Pad | @! | S | |||||
| BHD_PAGDIF | C | 1 | 0 | Pg.Df.Vl.Max | @! | 1=Sim;0=Nao | S | ||||
| BHD_VLRATE | N | 16 | 2 | Vlr.Mx.Bs.Co | @E 9,999,999,999,999.99 | M->BHD_PAGDIF = "1" .AND. M->BHD_LIMFRA <> 0 | S | ||||
| BHD_VIGDE | D | 8 | 0 | Vigencia De | PlsVldBHD() | R | N | ||||
| BHD_VIGATE | D | 8 | 0 | Vigencia Ate | Vazio() .or. PlsVldBHD() | R | N | ||||
| BHD_ANOMES | C | 6 | 0 | Ano/Mes Reaj | @R !!!!/!! | N | |||||
| BHD_VLRANT | N | 16 | 2 | Valor Ant. | @E 9,999,999,999,999.99 | N | |||||
| BHD_TIPUSR | C | 1 | 0 | Tipo Benef. | @! | If(Empty(M->BHD_TIPUSR),.T.,ExistCpo("BIH",M->BHD_TIPUSR,1)) | B47PLS | N | |||
| BHD_DESTIP | C | 30 | 0 | Descricao | @! | B37PLS | V | N | |||
| BHD_GRAUPA | C | 2 | 0 | Grau Parent. | @! | IF(Empty(M->BHD_GRAUPA),.T.,ExistCpo("BRP",M->BHD_GRAUPA,1)) | N | ||||
| BHD_DESGRA | C | 30 | 0 | Descricao | @! | V | N | ||||
| BHD_IDAINI | N | 3 | 0 | Idade Minima | 999 | Positivo() .AND. M->BHD_IDAINI <= M->BHD_IDAFIN | N | ||||
| BHD_IDAFIN | N | 3 | 0 | Idade Maxima | 999 | Positivo() .AND. If(!Empty(M->BHD_IDAINI),M->BHD_IDAFIN >= M->BHD_IDAINI,.T.) | N | ||||
| BHD_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 | ||
| BHD_RDACRE | C | 1 | 0 | Rede Credenc | @! | Pertence("12") | R | 1=Sim;2=Nao | N | ||
| BHD_RDAPRE | C | 1 | 0 | Rede Prefere | @! | Pertence("12") | R | 1=Sim;2=Nao | M->BHD_RDACRE = "1" | N | |
| BHD_PERCO2 | N | 16 | 2 | % Co-Part2 | @E 9,999,999,999,999.99 | R | N | ||||
| BHD_VLRCO2 | N | 16 | 2 | Vlr.Co-Par2 | @E 9,999,999,999,999.99 | R | N | ||||
| BHD_VLRMIN | N | 16 | 2 | Valor Minimo | @E 9,999,999,999,999.99 | R | N | ||||
| BHD_ACUMUL | C | 1 | 0 | Cons. p/Acum | @! | Pertence("12") | R | 1=Inclusao do Contrato;2=Inclusao do Usuario | N | ||
| BHD_FINATE | C | 2 | 0 | Finalidade | @! | Vazio() .or. BGY->(ExistCpo("BGY",M->BI3_CODINT+M->BHD_FINATE,1)) | BGYPLS | R | S | ||
| BHD_DESFIN | C | 70 | 0 | Ds Finalidad | @! | V | S | ||||