| 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 | |||