---
title: "OPENITEM (AccountView)"
description: "Open items"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/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/nl/
---

# OPENITEM: AccountView Open items

`read only` `per partition`

- Catalogus: `AccountView`
- Label: Open items

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `OPENITEM` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | 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` | Datum van laatste wijziging | [ ] |  |  |
| `CNG_NR` | `int32` | Nummer wijzigen | [ ] |  |  |
| `COLL_DATE` | `datetime` | Date handed over | [ ] |  |  |
| `COMMENT1` | `varchar2(4)` | Note | [ ] |  |  |
| `COST_CODE` | `varchar2(10)` | Cost centre code | [ ] |  |  |
| `CR_AMT` | `int64` | Kredietbedrag | [ ] |  |  |
| `CRED_DAYS` | `decimal` | Betalingstermijn in dagen | [ ] |  |  |
| `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` | Automatische incasso | [ ] |  |  |
| `DEB_SHOW` | `char` | Customer | [ ] |  |  |
| `DISC_DAYS` | `decimal` | Kortingsperiode in dagen | [ ] |  |  |
| `DISP_INV` | `char` | Manually blocked for automatic payment/direct debit | [ ] |  |  |
| `DJ_CODE` | `varchar2(3)` | Tijdschriftcode | [ ] |  |  |
| `DOC_ID` | `varchar2(32)` | Document code | [ ] |  |  |
| `DOC_TYPE` | `int32` | Document type | [ ] |  |  |
| `DR_AMT` | `int64` | Afschrijvingsbedrag | [ ] |  |  |
| `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` | Datum van inschrijving | [ ] |  |  |
| `INV_NR` | `varchar2(12)` | Document-/factuurnummer | [ ] |  |  |
| `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` | Vervaldatum | [ ] |  |  |
| `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` | Resterend bedrag | [ ] |  |  |
| `MAND_B2B` | `char` | Type automatische incasso: zakelijk | [ ] |  |  |
| `MAND_DATE` | `datetime` | Datum van ondertekening | [ ] |  |  |
| `MAND_ID` | `varchar2(35)` | Direct debit mandate reference | [ ] |  |  |
| `MAND_SEQ` | `int32` | Machtiging voor automatische incasso | [ ] |  |  |
| `MARK_DD` | `char` | Marked for direct debit | [ ] |  |  |
| `MARK_PG` | `char` | Marked for payment | [ ] |  |  |
| `OI_STAT` | `decimal` | Approval status | [ ] |  |  |
| `PAGE_NR` | `varchar2(10)` | Paginanummer | [ ] |  |  |
| `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` | Bedrag van de betalingskorting | [ ] |  |  |
| `PD_PCT` | `decimal` | Kortingspercentage bij betaling | [ ] |  |  |
| `PG_BLK` | `char` | Geblokkeerd voor automatische betaling | [ ] |  |  |
| `PMT_AMT` | `decimal` | Amount payable FC | [ ] |  |  |
| `PMT_AMTN` | `decimal` | Amount payable FC (-) | [ ] |  |  |
| `PMT_ARTS` | `varchar2(2)` | Artikelnummer voor doorvoer | [ ] |  |  |
| `PMT_CHQ` | `char` | Betaling per cheque | [ ] |  |  |
| `PMT_CRECV` | `char` | Alle bankkosten komen ten laste van de begunstigde | [ ] |  |  |
| `PMT_CSEND` | `char` | Kosten van andere banken ten laste van de hoofdsom | [ ] |  |  |
| `PMT_CURR` | `varchar2(3)` | Payment currency code | [ ] |  |  |
| `PMT_DESC` | `varchar2(80)` | Beschrijving voor DNB | [ ] |  |  |
| `PMT_FAST` | `char` | Dringende buitenlandse betaling | [ ] |  |  |
| `PMT_GOODS` | `varchar2(2)` | Goederencode | [ ] |  |  |
| `PMT_ORD1` | `varchar2(2)` | Betalingsinstructiecode 1 | [ ] |  |  |
| `PMT_ORD2` | `varchar2(2)` | Betalingsinstructiecode 2 | [ ] |  |  |
| `PMT_ORD3` | `varchar2(2)` | Betalingsinstructiecode 3 | [ ] |  |  |
| `PMT_ORD4` | `varchar2(2)` | Betalingsinstructiecode 4 | [ ] |  |  |
| `PMT_TYPE` | `varchar2(2)` | Verslaglegging inzake deviezen | [ ] |  |  |
| `POST_TYPE` | `decimal` | Write-off code | [ ] |  |  |
| `PROJ_CODE` | `varchar2(10)` | Projectcode | [ ] |  |  |
| `REM_BLK` | `char` | Geblokkeerd vanwege herinneringen | [ ] |  |  |
| `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)` | Klant-/leveranciersnummer | [ ] |  |  |
| `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` | Factuurdatum | [ ] |  |  |
| `TRN_DESC` | `varchar2(40)` | Omschrijving van de factuur | [ ] |  |  |
