| p_7cpl | Couples sections/affaires |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | codsoc | Code Société | LONG | - |
| 2 | p_5axcod | Code axe analytique | CHAR | 1 |
| 3 | p_7cplplma | Plan majeur | CHAR | 3 |
| 4 | p_7cplelma | Element plan majeur | CHAR | 12 |
| 5 | p_7cplplmi | Plan mineur | CHAR | 3 |
| 6 | p_7cplelmi | Element plan mineur | CHAR | 12 |
| 7 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 8 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | p_7cpl_idx1 | Clé primaire p_7cpl | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_7cplelmi (ASC) | ||||
| p_7cplplmi (ASC) | ||||
| p_7cplelma (ASC) | ||||
| p_7cplplma (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | p_7cpl_idx2 | Recherche sur plan majeur | L | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_7cplelmi (ASC) | ||||
| p_7cplplmi (ASC) | ||||
| p_7cplelma (ASC) | ||||
| p_7cplplma (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | p_7cpl_idx3 | Recherche sur plan majeur | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_7cplelma (ASC) | ||||
| p_7cplplma (ASC) | ||||
| p_7cplelmi (ASC) | ||||
| p_7cplplmi (ASC) | ||||
| p_5axcod (ASC) | ||||