| cai | Caisse |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | typtie | Type de tiers | CHAR | 3 |
| 2 | sigtie | Sigle du tiers | CHAR | 12 |
| 3 | datrgl | Date de réglement | DATE | AAAAMMJJ |
| 4 | typtie1 | Type de tiers | CHAR | 3 |
| 5 | sigtie1 | Sigle du tiers | CHAR | 12 |
| 6 | modrgl | Mode de reglement | CHAR | 2 |
| 7 | codeta | Code état d'un évènement | CHAR | 1 |
| 8 | sigres | Sigle responsable | CHAR | 12 |
| 9 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 10 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
| 11 | monenc | Montant encaissé | DBLE | - |
| 12 | mondec | Montant décompte | DBLE | - |
| 13 | monrgl | Montant régul. | DBLE | - |
| 14 | indint | Indicateur interface | CHAR | 1 |
| 15 | datint | Date interface comptable | DATE | AAAAMMJJ |
| 16 | codsoc | Code Société | LONG | - |
| 17 | caissini | Fond de caisse initial | DBLE | - |
| 18 | caissfin | Fond de caisse final | DBLE | - |
| 19 | coddev | Code devise | CHAR | 3 |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | cai_idx1 | Clé N° 1 | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typtie (ASC) | ||||
| sigtie (ASC) | ||||
| datrgl (ASC) | ||||
| typtie1 (ASC) | ||||
| sigtie1 (ASC) | ||||
| modrgl (ASC) | ||||
| coddev (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | cai_idx2 | Clé N° 2 | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typtie (ASC) | ||||
| sigtie (ASC) | ||||
| datrgl (ASC) | ||||
| modrgl (ASC) | ||||
| coddev (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | cai_idx4 | Clé N° 4 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typtie (ASC) | ||||
| sigtie (ASC) | ||||
| datrgl (ASC) | ||||
| modrgl (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 5 | cai_idx5 | Clé N° 5 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typtie (ASC) | ||||
| sigtie (ASC) | ||||
| datrgl (DESC) | ||||
| modrgl (ASC) | ||||
| coddev (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 6 | cai_idx6 | Clé n° 6 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typtie (ASC) | ||||
| sigtie (ASC) | ||||
| datrgl (ASC) | ||||
| coddev (ASC) | ||||