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

# AROutstandingItemsPerFinancialPeriodUltimo: Exact Online Open Sales Invoices per Ultimo Financial Period

`read only`

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

The table contains the outstanding sales invoices per ultimo financial period for each of the financial periods 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 `AROutstandingItemsPerFinancialPeriodUltimo` 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` | `int32` | Division | [ ] | `DIVISION` | Division code. |
| `DIVISIONNAME` | `varchar2(50)` | Administratie Naam | [x] | writable, `DIVISIONNAME` | Name of the Exact Online division. |
| `DIVISIONSHORTNAME` | `int64` | Divisie Korte Naam | [x] | writable, `DIVISIONSHORTNAME` | Short name of the Exact Online division. |
| `DUEDATE` | `date` | Vervaldag | [ ] |  | Due date: YYYY-MM-DD |
| `FINPERIOD` | `int16` | Boekperiode | [ ] | filters on the platform, writable, `FINPERIOD` | The financial period.Usually the period is a month or quarter with period 1 starting on the first of January. |
| `FINYEAR` | `int16` | Boekjaar | [ ] | filters on the platform, writable, `FINYEAR` | The financial year.The financial year and calendar year are not always aligned. |
| `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)
