---
title: "DJ_PAGE (AccountView)"
description: "Journal pages"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/vismaaccountview/AccountView..DJ_PAGE
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..DJ_PAGE
updated: 2026-11-16T21:13:31Z
license: https://documentation.invantive.eu/fr/
---

# DJ_PAGE: AccountView Journal pages

`read only` `per partition`

- Catalogue : `AccountView`
- Label: Journal pages

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `DJ_PAGE` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCT_NR` | `varchar2(10)` | Numéro de compte | [ ] |  |  |
| `ACCT_POST` | `char` | Post directly to general ledger account | [ ] |  |  |
| `ACCT_UPD` | `char` | Accountant change | [ ] |  |  |
| `APPR_SEQ` | `decimal` | Approval sequence number | [ ] |  |  |
| `APPR_STATE` | `int32` | Workflow status | [ ] |  |  |
| `AUTH_DATE` | `datetime` | Last check date | [ ] |  |  |
| `AUTH_NR` | `varchar2(10)` | Authorisation no. | [ ] |  |  |
| `AUTH_USR` | `varchar2(10)` | Last checking user | [ ] |  |  |
| `BLK_AMT` | `int64` | Montant du compte G | [ ] |  |  |
| `BLK_CUR` | `int64` | Montant du compte G FC | [ ] |  |  |
| `BV_AMT` | `int64` | Montant de l'UWV | [ ] |  |  |
| `BV_CUR` | `int64` | Montant de l'UWV FC | [ ] |  |  |
| `CARD_NAME` | `varchar2(40)` | Credit card name | [ ] |  |  |
| `CARD_NR` | `varchar2(20)` | Credit card no. | [ ] |  |  |
| `CHECK_AMT` | `int64` | Cheque amount | [ ] |  |  |
| `CHECK_PRN` | `char` | Cheque printed | [ ] |  |  |
| `CHECK_WD` | `varchar2(60)` | Cheque amount in words | [ ] |  |  |
| `CLT_UPD` | `char` | Client change | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date de modification | [ ] |  |  |
| `CNG_NR` | `int32` | Modifier le numéro | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `COMMENT1` | `varchar2(4)` | Note | [ ] |  |  |
| `COST_CODE` | `varchar2(10)` | Cost centre code | [ ] |  |  |
| `CRED_DAYS` | `decimal` | Délai de paiement en jours | [ ] |  |  |
| `CUR_AMT` | `int64` | Total currency | [ ] |  |  |
| `CUR_CODE` | `varchar2(3)` | Currency code | [ ] |  |  |
| `CUR_VAT` | `int64` | VAT currency total | [ ] |  |  |
| `DD_ACT` | `char` | Prélèvement automatique | [ ] |  |  |
| `DISC_CODE` | `varchar2(2)` | Conditions de paiement | [ ] |  |  |
| `DISC_DAYS` | `decimal` | Durée de la remise en jours | [ ] |  |  |
| `DJ_CODE` | `varchar2(3)` | Code de la revue | [ ] |  |  |
| `DJL_RATE` | `decimal` | Exchange rate foreign currency journal | [ ] |  |  |
| `DOC_ID` | `varchar2(32)` | Document code | [ ] |  |  |
| `DOC_TYPE` | `int32` | Document type | [ ] |  |  |
| `EA_VOUCHER` | `varchar2(36)` | ID of the entry in eAccounting | [ ] |  |  |
| `EBANK_ID` | `varchar2(10)` | Bank link identification | [ ] |  |  |
| `EBANK_STAT` | `int32` | Bank link status | [ ] |  |  |
| `EXCH_RATE` | `decimal` | Taux de change | [ ] |  |  |
| `EXP_CLI` | `char` | Export to client | [ ] |  |  |
| `EXP_DATE` | `datetime` | Valable jusqu'au | [ ] |  |  |
| `EXP_DJP` | `char` | Exported journal pages | [ ] |  |  |
| `EXP_SYS` | `char` | Old value of sys_gen | [ ] |  |  |
| `EXT_DESC` | `varchar2(40)` | Payment reference | [ ] |  |  |
| `GROSS_FLG` | `char` | Show base amount incl. VAT | [ ] |  |  |
| `HDR_DESC` | `varchar2(40)` | Page description | [ ] |  |  |
| `IMP_CODE` | `varchar2(10)` | Journal message | [ ] |  |  |
| `INP_DATE` | `datetime` | Date d'inscription | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `INV_NR` | `varchar2(12)` | Numéro du document/de la facture | [ ] |  |  |
| `LB_AMT` | `int64` | Montant de la cotisation sociale | [ ] |  |  |
| `LB_CUR` | `int64` | Montant de la cotisation sociale FC | [ ] |  |  |
| `MAND_B2B` | `char` | Type de prélèvement automatique : professionnel | [ ] |  |  |
| `MAND_DATE` | `datetime` | Date de signature | [ ] |  |  |
| `MAND_ID` | `varchar2(35)` | Direct debit mandate reference | [ ] |  |  |
| `MAND_SEQ` | `int32` | Autorisation de prélèvement automatique | [ ] |  |  |
| `NETT_AMT` | `int64` | Net page balance | [ ] |  |  |
| `NO_POST` | `char` | Do not post page | [ ] |  |  |
| `OWN_CNG_DT` | `datetime` | Owner change date | [ ] |  |  |
| `PAGE_AMT` | `int64` | Page balance | [ ] |  |  |
| `PAGE_AMTT` | `int64` | Closing balance | [ ] |  |  |
| `PAGE_EAMT` | `int64` | Closing balance | [ ] |  |  |
| `PAGE_NR` | `varchar2(10)` | Page number (sign) | [ ] |  |  |
| `PAGE_NRD` | `varchar2(13)` | Page number (description) | [ ] |  |  |
| `PAGE_NRV` | `decimal` | Numéro de page | [ ] |  |  |
| `PAGE_VAT` | `int64` | VAT amount page | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PAY_ID` | `varchar2(25)` | Payment code | [ ] |  |  |
| `PAY_TYPE` | `varchar2(25)` | Payment method | [ ] |  |  |
| `PAYIN_ID` | `varchar2(25)` | Pay-in ID | [ ] |  |  |
| `PD_AMT` | `int64` | Montant de la remise sur paiement | [ ] |  |  |
| `PD_PCT` | `decimal` | Pourcentage de remise sur le paiement | [ ] |  |  |
| `PERIOD` | `decimal` | Period | [ ] |  |  |
| `PREV_AMT` | `int64` | Opening balance page | [ ] |  |  |
| `PRN_CHECK` | `char` | Print cheque | [ ] |  |  |
| `PRN_RA` | `char` | Print cheque remittance | [ ] |  |  |
| `PROJ_CODE` | `varchar2(10)` | Code du projet | [ ] |  |  |
| `REC_BLK` | `char` | Blocked | [ ] |  |  |
| `STMT_DATE` | `datetime` | Statement date | [ ] |  |  |
| `STMT_LINE` | `char` | Bank statement line | [ ] |  |  |
| `STMT_NR` | `int32` | Bank statement | [ ] |  |  |
| `SUB_NR` | `varchar2(10)` | Customer/Supplier | [ ] |  |  |
| `SYS_GEN` | `char` | Page generated by system | [ ] |  |  |
| `SYS_VAL` | `char` | System validations | [ ] |  |  |
| `TGT_BAL` | `int64` | Control balance | [ ] |  |  |
| `TRN_DATE` | `datetime` | Change date | [ ] |  |  |
| `USR_NAME` | `varchar2(20)` | Dernière modification par | [ ] |  |  |
| `VEXCH_RATE` | `decimal` | Exchange rate (import) | [ ] |  |  |
