Tabela CYT - Apontamento Item Controle
Chave Unica: CYT_FILIAL + CYT_CDMQ + DTOS(CYT_DTSQVF) + CYT_HRSQVF + CYT_CDVF
Modo: C
Modo Unid.: C
Modo Empr.: C
Sumario:
Campos
| Campo | Titulo | Descricao | Tipo | Contexto | Tamanho |
|---|---|---|---|---|---|
| CYT_FILIAL | Filial | Filial | C | Real | 2 |
| CYT_CDMQ | Maquina | Maquina | C | Real | 20 |
| CYT_DSMQ | Desc Maquina | Descricao Maquina | C | Virtual | 40 |
| CYT_CDVF | Item Control | Item Controle | C | Real | 5 |
| CYT_DSVF | Desc Item | Descricao Item Controle | C | Virtual | 40 |
| CYT_DTRP | Data Reporte | Data Reporte | D | Real | 8 |
| CYT_HRRP | Hora Reporte | Hora Reporte | C | Real | 8 |
| CYT_HCRP | Hora Ce Rep | Hora Centesimal Reporte | N | Virtual | 7, 4 |
| CYT_DTRS | Data | Resultado Data | D | Real | 8 |
| CYT_VLRS | Numerico | Resultado Numerico | N | Real | 14, 4 |
| CYT_DSRS | Observacao | Resultado Character | C | Real | 254 |
| CYT_DTSQVF | Data Refer | Data Referencia | D | Real | 8 |
| CYT_HRSQVF | Hora Refer | Hora Referencia | C | Real | 8 |
| CYT_HCSQVF | Hora Ce Ref | Hr Centesimal Referencia | N | Virtual | 7, 4 |
Indices
| Ordem | Chave | Descricao | Nickname |
|---|---|---|---|
| 1 | CYT_FILIAL + CYT_CDMQ + DTOS(CYT_DTSQVF) + CYT_HRSQVF + CYT_CDVF | Maquina + Data Refer + Hora Refer + Item Control | |
| 2 | CYT_FILIAL + CYT_CDVF | Item Control |
Relacionamentos
| Tabela Origem | Tabela Destino | Expressao Origem | Expressao Destino | Relacionamento |
|---|---|---|---|---|
| CYB (Maquina) | CYT (Apontamento Item Controle) | CYB_CDMQ | CYT_CDMQ | 1 para N |
| CYE (Maquina x Item Controle) | CYT (Apontamento Item Controle) | CYE_CDMQ + CYE_CDVF | CYT_CDMQ + CYT_CDVF | 1 para N |
| CYK (Item Controle) | CYT (Apontamento Item Controle) | CYK_CDVF | CYT_CDVF | 1 para N |