| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| BHZ | Cobranca Retroativa Reajuste | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| BHZ_FILIAL | C | 2 | 0 | Filial | S | ||||||
| BHZ_CODINT | C | 4 | 0 | Operadora | @R !.!!! | PLSVLDINT(M->BHZ_CODINT) .AND. ExistCpo( "BA0", M->BHZ_CODINT) | B89PLS | R | S | ||
| BHZ_DESINT | C | 40 | 0 | Desc.Operad. | @! | ExistCpo( "AAD", M->BHZ_CODREA) | V | S | |||
| BHZ_CODIGO | C | 6 | 0 | Cod. Lote | @! | R | S | ||||
| BHZ_CODREA | C | 6 | 0 | Cod.Reajuste | @! | ExistCpo("BHW",M->BHZ_CODINT+M->BHZ_CODREA,1) | BHZPL7 | R | S | ||
| BHZ_ANO | C | 4 | 0 | Ano | 9999 | R | S | ||||
| BHZ_MES | C | 2 | 0 | Mes | 99 | ENTRE("01","12") | R | S | |||
| BHZ_EMPDE | C | 4 | 0 | Empresa De | @! | VAZIO() .OR. ExistCpo("BG9",M->BHZ_CODINT+M->BHZ_EMPDE,1) | BHZPL1 | R | S | ||
| BHZ_EMPATE | C | 4 | 0 | Empresa Ate | @! | M->BHZ_EMPATE $ "ZZZZ" .OR. (M->BHZ_EMPATE >= M->BHZ_EMPDE .AND. ExistCpo("BG9",M->BHZ_CODINT+M->BHZ_EMPATE,1)) | BHZPL1 | R | S | ||
| BHZ_TIPGRU | C | 1 | 0 | Tipo Contr. | @! | R | 1=Pessoa Fisica;2=Pessoa Juridica;3=Ambos | S | |||
| BHZ_CONDE | C | 12 | 0 | Contrato De | @! | VAZIO() .OR. ExistCpo("BT5",M->BHZ_CODINT+M->BHZ_EMPDE+M->BHZ_CONDE,1) | BHZPL2 | R | S | ||
| BHZ_CONATE | C | 12 | 0 | Contrato Ate | @! | M->BHZ_CONATE $ "ZZZZZZZZZZZZ" .OR. ( ExistCpo("BT5",M->BHZ_CODINT+M->BHZ_EMPATE+M->BHZ_CONATE,1)) | BHZPL2 | R | S | ||
| BHZ_SUBDE | C | 9 | 0 | Sub-Cont.De | @! | VAZIO() .OR. ExistCpo("BQC",BT5->BT5_CODINT+BT5->BT5_CODIGO+BT5->BT5_NUMCON+BT5->BT5_VERSAO+M->BHZ_SUBDE ,1) | BHZPL4 | R | S | ||
| BHZ_SUBATE | C | 9 | 0 | Sub-Cont.Ate | @! | M->BHZ_SUBATE$ "ZZZZZZZZZ" .OR. ExistCpo("BQC",BT5->BT5_CODINT+BT5->BT5_CODIGO+BT5->BT5_NUMCON+BT5->BT5_VERSAO+M->BHZ_SUBATE,1) | BHZPL5 | R | S | ||
| BHZ_MATDE | C | 6 | 0 | Matric. De | @! | VAZIO() .OR. ExistCpo("BA1",BT5->BT5_CODINT+BT5->BT5_CODIGO+M->BHZ_MATDE,1) | BHZPL6 | R | S | ||
| BHZ_MATATE | C | 6 | 0 | Matric. Ate | @! | M->BHZ_MATATE $ "ZZZZZZ" .OR. ExistCpo("BA1",BT5->BT5_CODINT+BT5->BT5_CODIGO+M->BHZ_MATATE,1) | BHZPL6 | R | S | ||
| BHZ_PROD | C | 1 | 0 | Cob.Produto | @! | R | 1=Sim;0=Nao | S | |||
| BHZ_OPC | C | 1 | 0 | Cob.Opcional | @! | R | 1=Sim;0=Nao | S | |||
| BHZ_TAX | C | 1 | 0 | Cob.Tx.Adesa | @! | R | 1=Sim;0=Nao | S | |||
| BHZ_OBS1 | C | 250 | 0 | Observacao | @! | R | N | ||||
| BHZ_USRBLQ | C | 1 | 0 | Usr. Bloq. ? | @! | R | 1=Sim;0=Nao | S | |||
| BHZ_TIPPAR | C | 1 | 0 | Tipo Parcela | @! | IIF(M->BHZ_TIPPAR=="1",M->BHZ_QTDPAR:=1,"") | R | 1=Parcela Unica;2=Qtde Parcelas Atrasadas;3=Qtde Parc. Ate Prox.. Reajuste;4=Qtde Parcelas Informada | S | ||
| BHZ_QTDPAR | N | 2 | 0 | Qtd. Parcel. | 99 | R | M->BHZ_TIPPAR <>"1" | S | |||