---
title: "BalanceLinesPerPeriodAll (Exact Online)"
description: "Balance Lines per Period (All Years)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.Balances.BalanceLinesPerPeriodAll
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.Balances.BalanceLinesPerPeriodAll
updated: 2026-11-01T17:55:09Z
license: https://documentation.invantive.eu/en/
---

# BalanceLinesPerPeriodAll: Exact Online Balance Lines per Period (All Years)

`read only`

- Catalog: `ExactOnlineREST`
- Schema: `Balances`
- Label: Balance Lines per Period (All Years)

Complete historical balance sheet for per period. Compared to BalanceLinesPerPeriodEx, this view retrieves all years instead of only at most 5 years.

Can only retrieve data.

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 432 |
| Full scan rows per minute | 50,300 |
| Point query rows per minute | 138 |

The result can be cached on the client.

## Table Columns

The columns of the table `BalanceLinesPerPeriodAll` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `BALANCE` | `decimal` | Balance | [ ] | `balance` |  |
| `CREDIT` | `number` | Credit | [ ] |  |  |
| `DEBIT` | `number` | Debit | [ ] |  |  |
| `DIVISION_CODE` | `int32` | Division | [ ] | `DIVISION_CODE` | Division code. |
| `DIVISION_HID` | `int64` | Division Short Name | [x] | writable, `DIVISION_HID` | Short name of the Exact Online division. |
| `DIVISION_NAME` | `varchar2(50)` | Administration Name | [x] | writable, `DIVISION_NAME` | Name of the Exact Online division. |
| `PERIODS_YEAR_CLOSE` | `number` | Year Close | [ ] |  |  |
| `PERIODS_YEAR_CREDIT` | `number` | Year Credit | [ ] |  |  |
| `PERIODS_YEAR_DEBIT` | `number` | Year Debit | [ ] |  |  |
| `PERIODS_YEAR_OPEN` | `number` | Year Open | [ ] |  |  |
| `PERIODS_YEAR_REPORTINGYEAR_ATTR` | `number` | Year Reporting Year | [ ] |  |  |
| `PERIODS_YEAR_YEARS_BALANCE_BALANCETYPE_ATTR` | `varchar2` | Balance Balance Type | [ ] |  |  |
| `PERIODS_YEAR_YEARS_BALANCE_CODE_ATTR` | `varchar2` | Balance Code | [ ] |  |  |
| `PERIODS_YEAR_YEARS_BALANCE_DESCRIPTION` | `varchar2(255)` | Balance Description | [ ] |  |  |
| `PERIODS_YEAR_YEARS_BALANCE_LEADCODE` | `varchar2` | Balance Lead Code | [ ] |  |  |
| `REPORTINGPERIOD_ATTR` | `number` | Reporting Period | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

