# APOutstandingItemsPerFinancialPeriodUltimo: Exact Online Open Purchase Invoices per Ultimo Financial Period - Catalog: `ExactOnlineREST` - Schema: `Views` - Label: Open Purchase Invoices per Ultimo Financial Period This is a read-only view. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## View Columns The columns of the view `APOutstandingItemsPerFinancialPeriodUltimo` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CURRENCY_CODE_ATTR` | `varchar2` | Currency Code | | | | `DESCRIPTION` | `varchar2`(255) | Description | | | | `DIVISION` | `int32` | Division | ☐ | Division code. | | `DIVISIONNAME` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DIVISIONSHORTNAME` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `DUEDATE` | `date` | Due Date | | Due date: YYYY-MM-DD | | `FINPERIOD` | `int16` | Financial Period | ☐ | The financial period. Usually the period is a month or quarter with period 1 starting on the first of January. | | `FINYEAR` | `int16` | Financial Year | ☐ | The financial year. The financial year and calendar year are not always aligned. | | `INVOICEAMTDC` | `number` | Invoice Amount Administration Currency | | | | `INVOICEAMTFC` | `number` | Invoice Amount Foreign Currency | | | | `INVOICEDATE` | `date` | Invoice Date | | Invoice date: YYYY-MM-DD | | `NUMBER_ATTR` | `number` | Number | | | | `OUTSTANDINGAMTDC` | `number` | Outstanding Amount Administration Currency | | | | `OUTSTANDINGAMTFC` | `number` | Outstanding Amount Foreign Currency | | | | `OUTSTANDINGITEMS_AP_ACCOUNT_CODE_ATTR` | `varchar2` | Account Code | | | | `OUTSTANDINGITEMS_AP_ACCOUNT_NAME` | `varchar2` | Account Name | | |