| p_ilf | Lien entre p_ifi et p_mvc |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | codsoc | Code Société | LONG | - |
| 2 | p_ifinum | Numero fiche immobilisation | CHAR | 10 |
| 3 | p_ecrnum | N° technique écriture | LONG | - |
| 4 | p_mvcnum | no techniq mvc comptable ds l'écriture | LONG | - |
| 5 | p_ilfint | Intégration immo | CHAR | 1 |
| 6 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 7 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | p_ilf_idx1 | Clé 1 | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_ifinum (ASC) | ||||
| p_ecrnum (ASC) | ||||
| p_mvcnum (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | p_ilf_idx2 | Clé 2 | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_ifinum (ASC) | ||||
| p_ecrnum (ASC) | ||||
| p_mvcnum (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | p_ilf_idx3 | Clé logique rech mvc | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_ifinum (ASC) | ||||
| p_ecrnum (ASC) | ||||
| p_mvcnum (ASC) | ||||