| bap | Paramétrage des barèmes |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | achvte | Indicateur Achat ou Vente (A/V) | CHAR | 1 |
| 2 | typqui | Type de QUI | CHAR | 1 |
| 3 | clequi | Cle du QUI | CHAR | 16 |
| 4 | typqoi | Type de QUOI | CHAR | 1 |
| 5 | cleqoi | Cle du QUOI | CHAR | 16 |
| 6 | codbar | Code barème | CHAR | 3 |
| 7 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 8 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
| 9 | codsoc | Code Société | LONG | - |
| 10 | typlie | Type de lien | CHAR | 3 |
| 11 | typtie | Type de tiers | CHAR | 3 |
| 12 | sigtie | Sigle du tiers | CHAR | 12 |
| 13 | tqui | Type de QUI | CHAR | 3 |
| 14 | tqoi | Type de QUOI | CHAR | 3 |
| 15 | taucom | Taux de la commission | DBLE | - |
| 16 | numord | Numéro d'ordre | LONG | - |
| 17 | datdeb | Date de début de période | DATE | AAAAMMJJ |
| 18 | datfin | Date de fin de période | DATE | AAAAMMJJ |
| 19 | coduni | Unité de mesure | CHAR | 3 |
| 20 | num1 | Numérique 1 | LONG | - |
| 21 | num2 | Numérique 2 | LONG | - |
| 22 | lib1 | Libellé 1 | CHAR | 30 |
| 23 | typtie1 | Type de tiers | CHAR | 3 |
| 24 | sigtie1 | Sigle du tiers | CHAR | 12 |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | bap_idx1 | Clé N° 1 | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typlie (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numord (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | bap_idx2 | POUR MAJ QUI-QUOI | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tqoi (ASC) | ||||
| typlie (ASC) | ||||
| achvte (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | bap_idx3 | POUR MAJ QUI-QUOI | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tqui (ASC) | ||||
| typlie (ASC) | ||||
| achvte (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | bap_idx4 | Clef 4 | P | N |
Clause Order By |
||||
| numord (DESC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 5 | bap_idx5 | Clé recherche multicritères barèmes | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typlie (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numord (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 6 | bap_idx6 | clé 6 plafond poste | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typlie (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numord (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 7 | bap_idx7 | clé 7 reprise | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typlie (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numord (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 8 | bap_idx8 | Clé de suppression des Qui | D | N |
| Clé de suppresion des Qui | ||||
Clause Order By |
||||
| codsoc (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 9 | bap_idx9 | Clé de suppression des Qoi | D | N |
| Clé de suppression des Qoi | ||||
Clause Order By |
||||
| codsoc (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||