---
title: "OPENITEM (AccountView)"
description: "Open items"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/vismaaccountview/AccountView..OPENITEM
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..OPENITEM
updated: 2026-11-16T21:14:21Z
license: https://documentation.invantive.eu/fr/
---

# OPENITEM: AccountView Open items

`read only` `per partition`

- Catalogue : `AccountView`
- Label: Open items

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

## Colonnes de table

Les colonnes de la table `OPENITEM` 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 |
|---|---|---|:---:|---|---|
| `AG_DATE` | `datetime` | Scheduling date | [ ] |  |  |
| `AG_PAYREF` | `varchar2(19)` | Acceptgiro payment reference | [ ] |  |  |
| `AMT_INT` | `int64` | Interest/costs | [ ] |  |  |
| `AMT_MARK` | `int64` | Open amount when marking | [ ] |  |  |
| `AMT_PAY` | `int64` | Amount payable | [ ] |  |  |
| `AMT_PAYN` | `int64` | Amount payable (negative) | [ ] |  |  |
| `ASTERIK` | `varchar2(1)` | Asterisk for overdue invoice | [ ] |  |  |
| `AUTH_DATE` | `datetime` | Approval date | [ ] |  |  |
| `AUTH_EMP` | `varchar2(10)` | Approving employee | [ ] |  |  |
| `BANK_ACCT` | `varchar2(10)` | Bank account field name | [ ] |  |  |
| `BANK_ACCTV` | `varchar2(42)` | Bank account | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date de la dernière modification | [ ] |  |  |
| `CNG_NR` | `int32` | Modifier le numéro | [ ] |  |  |
| `COLL_DATE` | `datetime` | Date handed over | [ ] |  |  |
| `COMMENT1` | `varchar2(4)` | Note | [ ] |  |  |
| `COST_CODE` | `varchar2(10)` | Cost centre code | [ ] |  |  |
| `CR_AMT` | `int64` | Montant du crédit | [ ] |  |  |
| `CRED_DAYS` | `decimal` | Délai de paiement en jours | [ ] |  |  |
| `CRED_SHOW` | `char` | Supplier | [ ] |  |  |
| `CUR_CAMT` | `int64` | Currency amount (credit) | [ ] |  |  |
| `CUR_CODE` | `varchar2(3)` | Currency code | [ ] |  |  |
| `CUR_DAMT` | `int64` | Currency amount (debit) | [ ] |  |  |
| `CUR_INT` | `int64` | Currency amount interest/costs | [ ] |  |  |
| `CUR_SIGN` | `varchar2(1)` | Currency symbol | [ ] |  |  |
| `DATE_PAID` | `datetime` | Date paid | [ ] |  |  |
| `DD_ACT` | `char` | Prélèvement automatique | [ ] |  |  |
| `DEB_SHOW` | `char` | Customer | [ ] |  |  |
| `DISC_DAYS` | `decimal` | Durée de la remise en jours | [ ] |  |  |
| `DISP_INV` | `char` | Manually blocked for automatic payment/direct debit | [ ] |  |  |
| `DJ_CODE` | `varchar2(3)` | Code de la revue | [ ] |  |  |
| `DOC_ID` | `varchar2(32)` | Document code | [ ] |  |  |
| `DOC_TYPE` | `int32` | Document type | [ ] |  |  |
| `DR_AMT` | `int64` | Montant du débit | [ ] |  |  |
| `DR_TYPE` | `char` | Debit type | [ ] |  |  |
| `EXT_ID` | `varchar2(32)` | External identification | [ ] |  |  |
| `EXT_TYPE` | `decimal` | External source | [ ] |  |  |
| `FIAT_PRIO` | `decimal` | Approval priority | [ ] |  |  |
| `GREK_TYPE` | `varchar2(1)` | Transaction type G-account | [ ] |  |  |
| `HAS_COMM` | `char` | Note present | [ ] |  |  |
| `INP_DATE` | `datetime` | Date d'inscription | [ ] |  |  |
| `INV_NR` | `varchar2(12)` | Numéro du document/de la facture | [ ] |  |  |
| `IS_EURO` | `char` | Payment in euros | [ ] |  |  |
| `IT_ORIGD_E` | `int64` | Original amount in euros | [ ] |  |  |
| `IT_PAID_EU` | `int64` | Paid in euros | [ ] |  |  |
| `ITEM_AGE` | `decimal` | Number of days open | [ ] |  |  |
| `ITEM_BAL` | `int64` | Open amount | [ ] |  |  |
| `ITEM_BAL_E` | `int64` | Open amount in euros | [ ] |  |  |
| `ITEM_BALC` | `int64` | Open amount (credit) | [ ] |  |  |
| `ITEM_CAMT` | `int64` | Currency amount | [ ] |  |  |
| `ITEM_CAMTC` | `int64` | Currency amount (payment) | [ ] |  |  |
| `ITEM_CAMTD` | `int64` | Currency amount (receipt) | [ ] |  |  |
| `ITEM_CPAYI` | `int64` | Currency amount including interest/costs | [ ] |  |  |
| `ITEM_DSCDT` | `datetime` | Discount due date | [ ] |  |  |
| `ITEM_EXPDS` | `decimal` | Number of days overdue | [ ] |  |  |
| `ITEM_EXPDT` | `datetime` | Date d'échéance | [ ] |  |  |
| `ITEM_EXPPG` | `decimal` | Number of days overdue (negative number of days) | [ ] |  |  |
| `ITEM_ORIGC` | `int64` | Original amount (credit) | [ ] |  |  |
| `ITEM_ORIGD` | `int64` | Original amount | [ ] |  |  |
| `ITEM_PAID` | `int64` | Paid | [ ] |  |  |
| `ITEM_PAYC` | `int64` | Amount after discount (credit) | [ ] |  |  |
| `ITEM_PAYD` | `int64` | Amount after discount | [ ] |  |  |
| `ITEM_PAYI` | `int64` | Amount including interest/costs | [ ] |  |  |
| `ITEM_PDPG` | `int64` | Payment discount amount (direct debit) | [ ] |  |  |
| `ITEM_PROC` | `char` | Processed | [ ] |  |  |
| `ITEM_REC` | `int64` | Amount receivable | [ ] |  |  |
| `ITEM_REST` | `int64` | Montant restant | [ ] |  |  |
| `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 | [ ] |  |  |
| `MARK_DD` | `char` | Marked for direct debit | [ ] |  |  |
| `MARK_PG` | `char` | Marked for payment | [ ] |  |  |
| `OI_STAT` | `decimal` | Approval status | [ ] |  |  |
| `PAGE_NR` | `varchar2(10)` | Numéro de page | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PAY_COLL` | `char` | Item handed over | [ ] |  |  |
| `PAY_DESC` | `varchar2(130)` | Payment reference | [ ] |  |  |
| `PAY_ID` | `varchar2(10)` | Payment file code | [ ] |  |  |
| `PAY_PROM` | `datetime` | Promised payment date | [ ] |  |  |
| `PD_AMT` | `int64` | Montant de la remise sur paiement | [ ] |  |  |
| `PD_PCT` | `decimal` | Pourcentage de remise sur le paiement | [ ] |  |  |
| `PG_BLK` | `char` | Bloqué pour le paiement automatique | [ ] |  |  |
| `PMT_AMT` | `decimal` | Amount payable FC | [ ] |  |  |
| `PMT_AMTN` | `decimal` | Amount payable FC (-) | [ ] |  |  |
| `PMT_ARTS` | `varchar2(2)` | Numéro d'article pour le transport | [ ] |  |  |
| `PMT_CHQ` | `char` | Paiement par chèque | [ ] |  |  |
| `PMT_CRECV` | `char` | Tous les frais bancaires sont à la charge du bénéficiaire | [ ] |  |  |
| `PMT_CSEND` | `char` | Frais prélevés par d'autres banques pour le compte du titulaire du compte | [ ] |  |  |
| `PMT_CURR` | `varchar2(3)` | Payment currency code | [ ] |  |  |
| `PMT_DESC` | `varchar2(80)` | Description du DNB | [ ] |  |  |
| `PMT_FAST` | `char` | Paiement international urgent | [ ] |  |  |
| `PMT_GOODS` | `varchar2(2)` | Code article | [ ] |  |  |
| `PMT_ORD1` | `varchar2(2)` | Code d'instruction de paiement 1 | [ ] |  |  |
| `PMT_ORD2` | `varchar2(2)` | Code d'instruction de paiement 2 | [ ] |  |  |
| `PMT_ORD3` | `varchar2(2)` | Code d'instruction de paiement 3 | [ ] |  |  |
| `PMT_ORD4` | `varchar2(2)` | Code d'instruction de paiement 4 | [ ] |  |  |
| `PMT_TYPE` | `varchar2(2)` | Déclaration des opérations de change | [ ] |  |  |
| `POST_TYPE` | `decimal` | Write-off code | [ ] |  |  |
| `PROJ_CODE` | `varchar2(10)` | Code du projet | [ ] |  |  |
| `REM_BLK` | `char` | Bloqué pour les rappels | [ ] |  |  |
| `REM_CNT` | `decimal` | Number of times reminded | [ ] |  |  |
| `REM_DATE` | `datetime` | Date of last reminder | [ ] |  |  |
| `REM_DAYS` | `decimal` | Number of days since last reminder | [ ] |  |  |
| `SUB_NR` | `varchar2(10)` | Numéro de client/fournisseur | [ ] |  |  |
| `SUM_BAL_EU` | `int64` | Overdue outstanding amount in euros | [ ] |  |  |
| `SUM_IT_BAL` | `int64` | Overdue outstanding amount | [ ] |  |  |
| `TO_PAY` | `int64` | To be paid | [ ] |  |  |
| `TRANSPORT` | `varchar2(16)` | Carried-forward amount | [ ] |  |  |
| `TRN_DATE` | `datetime` | Date de la facture | [ ] |  |  |
| `TRN_DESC` | `varchar2(40)` | Description de la facture | [ ] |  |  |
