Tabela JHS - Cabecalho Log de Requerimentos
Chave Unica: JHS_FILIAL + JHS_NUM + JHS_TIPO + JHS_NREQUE
Modo: C
Modo Unid.: E
Modo Empr.: E
Sumario:
Campos
| Campo | Titulo | Descricao | Tipo | Contexto | Tamanho |
|---|---|---|---|---|---|
| JHS_FILIAL | Filial | Filial | C | Real | 2 |
| JHS_NUM | Num. Control | Num. Control | C | Real | 15 |
| JHS_TIPO | Tp. Requerim | Tp. Requerim | C | Real | 6 |
| JHS_DESC | Descricao | Descricao | C | Real | 30 |
| JHS_VERSAO | Versao | Versao | C | Real | 2 |
| JHS_TIPSOL | Tp. Solictac | Tp. Solictac | C | Real | 1 |
| JHS_CODIDE | Identif. | Identificacao | C | Real | 20 |
| JHS_DATA | Data Log | Data Log | D | Real | 8 |
| JHS_USERLO | Usuario | Usuario | C | Real | 25 |
| JHS_HORA | Hora Log | Hora Log | C | Real | 5 |
| JHS_QUANT | Quantidade | Quantidade | N | Real | 3 |
| JHS_STATUS | Status | Status | C | Real | 1 |
| JHS_NREQUE | Num. Requer | Num. Requer | C | Real | 6 |
| JHS_TPOPER | Tp. Operacao | Tp. Operacao | C | Real | 10 |
Indices
| Ordem | Chave | Descricao | Nickname |
|---|---|---|---|
| 1 | JHS_FILIAL + JHS_NUM + JHS_TIPO + JHS_VERSAO | Num. Control + Tp. Requerim + Versao | |
| 2 | JHS_FILIAL + JHS_CODIDE + JHS_TIPO + JHS_NUM | Identif. + Tp. Requerim + Num. Control | |
| 3 | JHS_FILIAL + JHS_NUM + JHS_TIPO + JHS_STATUS | Num. Control + Tp. Requerim + Status |
Relacionamentos
| Tabela Origem | Tabela Destino | Expressao Origem | Expressao Destino | Relacionamento |
|---|---|---|---|---|
| Sem dados encontrados na SX9 | ||||