Tabela RD4 - Itens de Visoes
Rotina (SysObj): ORGA030
Chave Unica: RD4_FILIAL + RD4_CODIGO + RD4_ITEM + RD4_TREE + DTOS(RD4_DATA)
Modo: C
Modo Unid.: C
Modo Empr.: C
Sumario:
Campos
| Campo | Titulo | Descricao | Tipo | Contexto | Tamanho |
|---|---|---|---|---|---|
| RD4_FILIAL | Filial | Filial do Sistema | C | Real | 2 |
| RD4_CODIGO | Codigo | Codigo da Estrutura | C | Real | 6 |
| RD4_ITEM | Item | Codigo do Item | C | Real | 6 |
| RD4_EMPIDE | Emp. Ident. | Empresa do Identificador | C | Real | 2 |
| RD4_FILIDE | Filial Ident | Filial do Identificador | C | Real | 2 |
| RD4_CODIDE | Cod. Ident. | Codigo do Identificador | C | Real | 9 |
| RD4_DESC | Desc.Item | Descricao do Item | C | Real | 60 |
| RD4_TREE | Grp.Superior | Grupo superior | C | Real | 6 |
| RD4_CHAVE | Chave | Chave de Busca | C | Real | 96 |
| RD4_DATA | Data Alterac | Data da Alteracao | D | Real | 8 |
| RD4_STATUS | Status | Status | C | Real | 1 |
Indices
| Ordem | Chave | Descricao | Nickname |
|---|---|---|---|
| 1 | RD4_FILIAL + RD4_CODIGO + RD4_ITEM + RD4_TREE + DTOS(RD4_DATA) | Codigo + Item + Grp.Superior + Data Alterac | |
| 2 | RD4_FILIAL + RD4_CODIGO + RD4_TREE + RD4_ITEM + DTOS(RD4_DATA) | Codigo + Grp.Superior + Item + Data Alterac | |
| 3 | RD4_FILIAL + RD4_DESC + RD4_CODIGO + RD4_ITEM + RD4_TREE + DTOS(RD4_DATA) | Desc.Item + Codigo + Item + Grp.Superior + Data Alterac | |
| 4 | RD4_FILIAL + RD4_CODIGO + RD4_CHAVE | Codigo + Chave | |
| 5 | RD4_FILIAL + RD4_CODIGO + RD4_CODIDE | Codigo + Cod. Ident. | |
| 6 | RD4_FILIAL + RD4_EMPIDE + RD4_FILIDE + RD4_CODIDE | Emp. Ident. + Filial Ident + Cod. Ident. | |
| 7 | RD4_FILIAL + RD4_CODIGO + RD4_EMPIDE + RD4_FILIDE + RD4_CODIDE | Codigo + Emp. Ident. + Filial Ident + Cod. Ident. |
Relacionamentos
| Tabela Origem | Tabela Destino | Expressao Origem | Expressao Destino | Relacionamento |
|---|---|---|---|---|
| RD2 (Itens de Competencia) | RD4 (Itens de Visoes) | RD2_ITEM | RD4_TREE | 1 para N |
| RD4 (Itens de Visoes) | RCD (Historico de Itens de Visao) | RD4_CODIGO + RD4_ITEM | RCD_CODIGO + RCD_ITEM | 1 para N |
| RD4 (Itens de Visoes) | RD4 (Itens de Visoes) | RD4_CODIGO + RD4_ITEM | RD4_CODIGO + RD4_TREE | 1 para N |
| RD4 (Itens de Visoes) | RDE (Itens Participantes x Visoes) | RD4_ITEM | RDE_ITEVIS | 1 para N |
| RD4 (Itens de Visoes) | RDE (Itens Participantes x Visoes) | RD4_CODIGO + RD4_ITEM | RDE_CODVIS + RDE_ITEVIS | 1 para N |
| RDK (Cabecalho de Visoes) | RD4 (Itens de Visoes) | RDK_CODIGO | RD4_CODIGO | 1 para N |