| jnl | Journaux comptables |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | achvte | Indicateur Achat ou Vente (A/V) | CHAR | 1 |
| 2 | codjnl | Code journal | CHAR | 3 |
| 3 | typeve | Type d'événement | CHAR | 3 |
| 4 | numeve | Numéro d'événement | LONG | - |
| 5 | cptgen | Numero de compte general | CHAR | 12 |
| 6 | numecr | Numéro d'écriture comptable | LONG | - |
| 7 | typecr | Type d'écriture | CHAR | 3 |
| 8 | debcre | = C si credit, = D si debit | CHAR | 1 |
| 9 | montan | Montant | DBLE | - |
| 10 | datecr | Date d'écriture | DATE | AAAAMMJJ |
| 11 | numfac | Numéro de facture (désengagement) | LONG | - |
| 12 | codtva | Code TVA | CHAR | 6 |
| 13 | codana | Code imputation analytique | CHAR | 6 |
| 14 | codana2 | Code imputation analytique | CHAR | 6 |
| 15 | codana3 | Code imputation analytique | CHAR | 6 |
| 16 | libelle | Libelle long standard | CHAR | 30 |
| 17 | stat | Statistique - Geco | CHAR | 12 |
| 18 | nature | nature de l'ecriture | CHAR | 2 |
| 19 | numfic | Numero de fichier interface comptable | LONG | - |
| 20 | datint | Date interface comptable | DATE | AAAAMMJJ |
| 21 | cumdes | Quantité facturée (ARENA) | DBLE | - |
| 22 | cptecr | Montant transport inclu (ARENA) | DBLE | - |
| 23 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 24 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
| 25 | posfis | Position fiscale | CHAR | 6 |
| 26 | coddev | Code devise | CHAR | 3 |
| 27 | pardev | Parité de la devise | DBLE | - |
| 28 | datpar | Date de la parite | DATE | AAAAMMJJ |
| 29 | mondev | Montant en devises | DBLE | - |
| 30 | datech | Date d'échéance | DATE | AAAAMMJJ |
| 31 | indint | Indicateur interface | CHAR | 1 |
| 32 | codpay | Code pays (03) | CHAR | 3 |
| 33 | codsoc | Code Société | LONG | - |
| 34 | tautva | Taux de la TVA | DBLE | - |
| 35 | cumtva | Cumul T.V.A | DBLE | - |
| 36 | numpos | Numéro de poste | LONG | - |
| 37 | etbcod | Code établissement | CHAR | 3 |
| 38 | tautva2 | Taux de la TVA | DBLE | - |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | jnl_idx1 | Clé N° 1 | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| codjnl (ASC) | ||||
| typeve (ASC) | ||||
| numeve (ASC) | ||||
| numecr (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | jnl_idx2 | Clé N° 2 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typeve (ASC) | ||||
| numeve (ASC) | ||||
| numecr (ASC) | ||||
| codjnl (ASC) | ||||
| cptgen (ASC) | ||||
| typecr (ASC) | ||||
| datecr (ASC) | ||||
| datech (ASC) | ||||
| codana (ASC) | ||||
| codana2 (ASC) | ||||
| codana3 (ASC) | ||||
| libelle (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | jnl_idx3 | Clé N° 3 | P | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| codjnl (ASC) | ||||
| typeve (ASC) | ||||
| numeve (ASC) | ||||
| cptgen (ASC) | ||||
| codana (ASC) | ||||
| typecr (ASC) | ||||
| codana2 (ASC) | ||||
| codana3 (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | jnl_idx4 | Clé N° 4 : Suppression d'un événement | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typeve (ASC) | ||||
| numeve (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 5 | jnl_idx5 | Clé n°5 d'acces par code TVA. | P | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| codjnl (ASC) | ||||
| typeve (ASC) | ||||
| numeve (ASC) | ||||
| cptgen (ASC) | ||||
| codana (ASC) | ||||
| typecr (ASC) | ||||
| codana2 (ASC) | ||||
| codana3 (ASC) | ||||
| codtva (ASC) | ||||