| p_5ba | Balance analytique |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | codsoc | Code Société | LONG | - |
| 2 | p_5bacg | Type calendrier Comptable - gestion | CHAR | 1 |
| 3 | p_5axcod | Code axe analytique | CHAR | 1 |
| 4 | p_6sbcod | Code suivi budgétaire | CHAR | 3 |
| 5 | p_6buniv | Niveau du budget | LONG | - |
| 6 | p_plncodpr | Code plan principale | CHAR | 3 |
| 7 | p_plecodpr | Element base plan principal | CHAR | 12 |
| 8 | p_plncodpb | Code plan budgétaire | CHAR | 3 |
| 9 | p_plecodpb | Element base plan budgétaire | CHAR | 12 |
| 10 | p_plncods1 | Plan secondaire 1 | CHAR | 3 |
| 11 | p_plecods1 | Element base plan secondaire 1 | CHAR | 12 |
| 12 | p_plncods2 | Plan secondaire 2 | CHAR | 3 |
| 13 | p_plecods2 | Element base plan secondaire 2 | CHAR | 12 |
| 14 | p_plncodpj | Plan des projets | CHAR | 3 |
| 15 | p_plecodpj | Element base plan projet | CHAR | 12 |
| 16 | p_5badeb | Date de début de balance | DATE | AAAAMMJJ |
| 17 | p_5bafin | Date de fin de balance | DATE | AAAAMMJJ |
| 18 | tp_njlnat | Nature du journal | CHAR | 1 |
| 19 | etbcod | Code établissement | CHAR | 3 |
| 20 | p_5bamde | cumul débit devise établissement | DBLE | - |
| 21 | p_5bamce | Cumul crédit devise établissement | DBLE | - |
| 22 | p_5bamds | Cumul débit devise société | DBLE | - |
| 23 | p_5bamcs | Cumul crédit devise société | DBLE | - |
| 24 | p_5bamdg | Cumul debit devise groupe | DBLE | - |
| 25 | p_5bamcg | Cumul crédit devise groupe | DBLE | - |
| 26 | p_5bamdc | Cumul débit devise contexte | DBLE | - |
| 27 | p_5bamcc | Cumul crédit devise contexte | DBLE | - |
| 28 | p_5baqte | Quantite de la période | DBLE | - |
| 29 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 30 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
| 31 | p_5bastr | Sous-traitance | CHAR | 1 |
| 32 | p_5balig | N° de ligne | LONG | - |
| 33 | p_5baarch | Indicateur archivage | CHAR | 1 |
| 34 | p_5batxt | N° de texte libre | LONG | - |
| 35 | p_1ppcpt | Numéro du compte plan principal | CHAR | 12 |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | p_5ba_idx1 | Clé primaire relation p_5ba | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| tp_njlnat (ASC) | ||||
| etbcod (ASC) | ||||
| p_1ppcpt (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | p_5ba_idx2 | Clé physique rubrique/section | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpb (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | p_5ba_idx3 | Clé logique section1/rubrique | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods1 (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | p_5ba_idx4 | Clé logique section2/rubrique | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods2 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 5 | p_5ba_idx5 | Clé logique projet/rubrique | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpj (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 6 | p_5ba_idx6 | Clé logique analyt section/rubrique | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| tp_njlnat (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 7 | p_5ba_idx7 | Clé logique analyt rubrique/section | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpb (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| tp_njlnat (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 8 | p_5ba_idx8 | Clé logique analyt sect sec 1/rubrique | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods1 (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| tp_njlnat (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 9 | p_5ba_idx9 | Clé logique analyt section 2/rubrique | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods2 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| tp_njlnat (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 10 | p_5ba_idx10 | Clé logique analyt projet/rubrique | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpj (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| tp_njlnat (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 11 | p_5ba_idx11 | Clé logique budget section/rubrique | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 12 | p_5ba_idx12 | Clé logique budget rubrique/section | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpb (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 13 | p_5ba_idx13 | Clé logique budget sec 1/rubrique | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods1 (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 14 | p_5ba_idx14 | Clé logique budget sec 2/rubrique | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods2 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 15 | p_5ba_idx15 | Clé logique budget/env section/rubrique | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| tp_njlnat (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 16 | p_5ba_idx16 | Clé logique section/sec1 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 17 | p_5ba_idx17 | Recherche affaires par egalité PR | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 18 | p_5ba_idx18 | Recherche affaires par egalité S1 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods1 (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 19 | p_5ba_idx19 | Recherche affaires par egalité S2 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods2 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plncodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 20 | p_5ba_idx20 | Recherche affaires par egalité S3 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpj (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_6sbcod (ASC) | ||||
| p_6buniv (ASC) | ||||
| p_5bacg (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 21 | p_5ba_idx21 | Clé physique budget section/s1 | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_5axcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 22 | p_5ba_idx22 | Clé logique budget section/s1 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 23 | p_5ba_idx23 | Clé logique budget section/s2 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 24 | p_5ba_idx24 | Clé logique budget section/pj | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpr (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 25 | p_5ba_idx25 | Clé logique budget s1/s2 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods1 (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 26 | p_5ba_idx26 | Clé logique budget s1/pj | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods1 (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 27 | p_5ba_idx27 | Clé logique budget s2/pj | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncods2 (ASC) | ||||
| p_plecods2 (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 28 | p_5ba_idx28 | plan projet-rubrique | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| p_plncodpj (ASC) | ||||
| p_plecodpj (ASC) | ||||
| p_plecodpb (ASC) | ||||
| p_5badeb (ASC) | ||||
| p_plecodpr (ASC) | ||||
| p_plecods1 (ASC) | ||||
| p_5axcod (ASC) | ||||
| p_5bacg (ASC) | ||||
| etbcod (ASC) | ||||