---
title: "AROutstandingItemsPerFinancialYearUltimo (Exact Online)"
description: "Open Sales Invoices per Ultimo Financial Year"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/exactonline/ExactOnlineREST.Views.AROutstandingItemsPerFinancialYearUltimo
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.Views.AROutstandingItemsPerFinancialYearUltimo
updated: 2026-11-16T20:58:22Z
license: https://documentation.invantive.eu/nl/
---

# AROutstandingItemsPerFinancialYearUltimo: Exact Online Open Sales Invoices per Ultimo Financial Year

`read only`

- Catalogus: `ExactOnlineREST`
- Schema: `Views`
- Label: Open Sales Invoices per Ultimo Financial Year

The table contains the outstanding sales invoices per ultimo financial year for each of the financial years defined.

Kan alleen gegevens ophalen.

## Prestatiekenmerken

| Characteristic | Value |
|---|---:|
| Gemiddelde toegangsvertraging (ms) | 432 |
| Aantal rijen per minuut bij volledige scan | 50,300 |
| Aantal rijen per minuut in een Query | 138 |

Het resultaat kan op de client in de Cache worden opgeslagen.

## Tabelkolommen

De kolommen van de tabel `AROutstandingItemsPerFinancialYearUltimo` 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 |
|---|---|---|:---:|---|---|
| `CURRENCY_CODE_ATTR` | `varchar2` | Valuta Code | [ ] |  |  |
| `DESCRIPTION` | `varchar2(255)` | Description | [ ] |  |  |
| `DIVISION_CODE` | `varchar2` | Administratie ID | [x] |  | Intern uniek nummer van de Exact Online administratie. |
| `DIVISION_HID` | `int64` | Administration | [x] |  | Number of the Exact Online administration.Not guaranteed to be unique. |
| `DIVISION_NAME` | `varchar2(240)` | Administratie Naam | [x] |  | Name of the Exact Online administration.Not guaranteed to be unique. |
| `DUEDATE` | `date` | Vervaldag | [ ] |  | Due date: YYYY-MM-DD |
| `FINANCIALYEAR` | `number` | Financial Year Number | [ ] |  |  |
| `INVOICEAMTDC` | `number` | Factuurbedrag Administratie Valuta | [ ] |  |  |
| `INVOICEAMTFC` | `number` | Factuurbedrag Vreemde Valuta | [ ] |  |  |
| `INVOICEDATE` | `date` | Factuurdatum | [ ] |  | Invoice date: YYYY-MM-DD |
| `NUMBER_ATTR` | `number` | Number | [ ] |  |  |
| `OUTSTANDINGAMTDC` | `number` | Uitstaand Bedrag Administratie Valuta | [ ] |  |  |
| `OUTSTANDINGAMTFC` | `number` | Uitstaand Bedrag Vreemde Valuta | [ ] |  |  |
| `OUTSTANDINGITEMS_AR_ACCOUNT_CODE_ATTR` | `varchar2` | Account Code | [ ] |  |  |
| `OUTSTANDINGITEMS_AR_ACCOUNT_NAME` | `varchar2` | Accountnaam | [ ] |  |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

- [Exact Online](/nl/release-notes/drivers?driver=exact-online)
