| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| BGD | Prod x Cob x Proc x Co-Part | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| BGD_FILIAL | C | 2 | 0 | Filial | S | ||||||
| BGD_CODIGO | C | 8 | 0 | Cod. Plano | @! | S | |||||
| BGD_VERSAO | C | 3 | 0 | Versao | @! | S | |||||
| BGD_CODMUN | C | 7 | 0 | Municipio | @! | S | |||||
| BGD_TIPO | C | 1 | 0 | Reg Atendto | @! | 1=Internacao;2=Ambulatorial;3=Ambos | S | ||||
| BGD_QTD | N | 6 | 0 | Qtd. Ate | 999999 | S | |||||
| BGD_PERCOP | N | 16 | 2 | % Co-Part. | @E 9,999,999,999,999.99 | S | |||||
| BGD_CODTAB | C | 7 | 0 | Tab.CoPar. | @R !!!!.!!! | ExistCpo("BF8",M->BGD_CODTAB,1) | B68PLS | S | |||
| BGD_TXADM | N | 16 | 2 | Taxa Admin. | @E 9,999,999,999,999.99 | S | |||||
| BGD_PAGATO | C | 1 | 0 | Pagto no Ato | @! | 1=Sim;0=Nao | S | ||||
| BGD_VALUS | N | 16 | 4 | Valor U.S | @E 99,999,999,999.9999 | M->BGD_PERCOP>0 | S | ||||
| BGD_CODPAD | C | 2 | 0 | Cd.Tp.Tabela | @! | ExistCpo("BR4",M->BGD_CODPAD,1) | B41PLS | S | |||
| BGD_CODPRO | C | 16 | 0 | Cod.Proced. | @! | ExistCpo("BR8",M->BGD_CODPAD+M->BGD_CODPRO,1) | BR2PLS | S | |||
| BGD_DESCRI | C | 40 | 0 | Descricao | @! | V | S | ||||
| BGD_TIPUSR | C | 1 | 0 | Tipo Benef. | @! | If(Empty(M->BGD_TIPUSR),.T.,ExistCpo("BIH",M->BGD_TIPUSR,1)) | B47PLS | S | |||
| BGD_DESTIP | C | 30 | 0 | Descricao | @! | V | S | ||||
| BGD_GRAUPA | C | 2 | 0 | Grau Parent. | @! | IF(Empty(M->BGD_GRAUPA),.T.,ExistCpo("BRP",M->BGD_GRAUPA,1)) | B37PLS | S | |||
| BGD_DESGRA | C | 30 | 0 | Descricao | @! | V | S | ||||
| BGD_IDAINI | N | 3 | 0 | Idade Minima | 999 | Positivo() .AND. M->BGD_IDAINI <= M->BGD_IDAFIN | S | ||||
| BGD_IDAFIN | N | 3 | 0 | Idade Maxima | 999 | Positivo() .AND. If(!Empty(M->BGD_IDAINI),M->BGD_IDAFIN >= M->BGD_IDAINI,.T.) | R | N | |||
| BGD_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 | ||
| BGD_RDACRE | C | 1 | 0 | Rede Credenc | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| BGD_RDAPRE | C | 1 | 0 | Rede Prefere | @! | Pertence("12") | R | 1=Sim;2=Nao | M->BGD_RDACRE = "1" | S | |
| BGD_PERCO2 | N | 16 | 2 | % Co-Part2 | @E 9,999,999,999,999.99 | R | M->BGD_VLRCO2 = 0 | S | |||
| BGD_VLRCO2 | N | 16 | 2 | Vlr.Co-Par2 | @E 9,999,999,999,999.99 | R | M->BGD_PERCO2 = 0 | S | |||
| BGD_VALCOP | N | 16 | 2 | Vlr.CoPar. | @E 9,999,999,999,999.99 | R | N | ||||
| BGD_VLRMIN | N | 16 | 2 | Valor Minimo | @E 9,999,999,999,999.99 | R | S | ||||
| BGD_ACUMUL | C | 1 | 0 | Cons. p/Acum | @! | Pertence("12") | R | 1=Inclusao do Contrato;2=Inclusao do Usuario | S | ||
| BGD_VIGINI | D | 8 | 0 | Vig. Inicial | PlsVldBGD() | R | S | ||||
| BGD_VIGFIN | D | 8 | 0 | Vig. Final | PlsVldBGD() | R | S | ||||
| BGD_FINATE | C | 2 | 0 | Finalidade | @! | Vazio() .or. BGY->(ExistCpo("BGY",M->BI3_CODINT+M->BGD_FINATE,1)) | BGYPLS | R | S | ||
| BGD_DESFIN | C | 70 | 0 | Ds Finalidad | @! | V | S | ||||