Tabela
JBH Cabecalho Solicitacao de Req
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
JBH_FILIAL C 2 0 FILIAL S
JBH_NUM C 6 0 Num. Protoc. @! ExistChav( "JBH", M->JBH_NUM ).And.FreeForUse( "JBH", M->JBH_NUM ) S
JBH_TIPO C 6 0 Codigo Tipo @! GEExistCpo("JBF") .and. A410ValTipo() .and. A410DtPart( dDataBase ) JBF M->JBH_STATUS # "1" S
JBH_DESC C 30 0 Desc. Tipo @! V S
JBH_VERSAO C 2 0 Versao @! S
JBH_TIPSOL C 1 0 Tipo Solicit Pertence("1234") 1=Funcionario;2=Aluno;3=Candidato;4=Externo M->JBH_STATUS # "1" S
JBH_CODIDE C 20 0 Identif. @! ACA410Solic(2,.T.) J08 M->JBH_STATUS # "1" S
JBH_NOME C 60 0 Nome @! M->JBH_TIPSOL=="4" S
JBH_EMAIL C 40 0 E-mail V S
JBH_DATA D 8 0 Data Solicit M->JBH_STATUS # "1" S
JBH_QUANT N 3 0 Quantidade 999 M->JBH_QUANT > 0 M->JBH_STATUS # "1" S
JBH_STATUS C 1 0 Status Pertence("123") 1=Deferido;2=Indeferido;3=Pendente;4=Atrasado;5=Aguardando Vaga;6=Cancelado;7=Pagamento Pendente S
JBH_DTPART D 8 0 A Partir de M->JBH_DTPART > dDataBase M->JBH_STATUS # "1" S
JBH_GERABL C 1 0 Gera Boleto Pertence("12") .and. A410ValGBol() 1=Sim;2=Nao A410GeraBl() S
JBH_STDOCU C 1 0 Situacao Doc Pertence("123") .and. Iif( M->JBH_STDOCU $ "23", (M->JBH_DTSTDO := dDataBase, M->JBH_HRSTDO := Time(), .T.), .T. ) 1=Nao-Retirado;2=Retirado;3=Arquivado M->JBH_STATUS=="1" S
JBH_DTSTDO D 8 0 Data Situac. A410SitDoc() S
JBH_HRSTDO C 5 0 Hora Situac. 99:99 A410SitDoc() S
JBH_DTINIC D 8 0 Data Inicio S
JBH_HRINIC C 5 0 Hora Inicio 99:99 S
JBH_MEMO1 C 6 0 Observacao @! S
JBH_OBSERV M 80 0 Observacao V S
JBH_MEMO2 C 6 0 Resp.Script @! S
JBH_RESPOS M 80 0 Resp.Script V S
JBH_NUMDES C 8 0 Num Fil Des R S
JBH_NUMANT C 8 0 Num Fil Ant R S