| ut_jnl | Journal de bord |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | numero | Numero d'entree | LONG | - |
| 2 | datdeb | Date de debut | DATE | AAAAMMJJ |
| 3 | heudeb | Heure de debut | CHAR | 4 |
| 4 | auti | Utilisateur aval | CHAR | 8 |
| 5 | afct | Fonction aval | CHAR | 40 |
| 6 | soc | Code societe | LONG | - |
| 7 | codut_ter | Code terminal | CHAR | 10 |
| 8 | datfin | Date de fin | DATE | AAAAMMJJ |
| 9 | heufin | Heure de Fin | CHAR | 4 |
| 10 | datmod | Date de modification | DATE | AAAAMMJJ |
| 11 | utimod | Agent responsable de la dernière accès | CHAR | 8 |
| 12 | codsoc | Code societe | LONG | - |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | ut_jnl_idx1 | Clé N° 1 | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| soc (ASC) | ||||
| numero (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | ut_jnl_idx2 | Clé N° 2 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| soc (ASC) | ||||
| auti (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | ut_jnl_idx3 | Clé N° 3 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| soc (ASC) | ||||
| auti (ASC) | ||||
| afct (ASC) | ||||
| numero (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | ut_jnl_idx4 | Clé N° 4 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| soc (ASC) | ||||
| auti (ASC) | ||||
| afct (ASC) | ||||
| numero (ASC) | ||||