Tabela RD4 - Itens de Visoes
Rotina (SysObj): ORGA030
Chave Unica: RD4_FILIAL + RD4_CODIGO + RD4_ITEM + RD4_TREE + DTOS(RD4_DATA)
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 |
Tabelas do Protheus v4.3 (baseado no P12.1.2210) - 16/10/2022 - 10.278 tabelas e 10.531 parametros