---
title: "BalanceLinesPerPeriod (Exact Online)"
description: "Balance Lines per Period"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/exactonline/ExactOnlineXML.XML.BalanceLinesPerPeriod
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineXML.XML.BalanceLinesPerPeriod
updated: 2026-11-16T20:58:39Z
license: https://documentation.invantive.eu/nl/
---

# BalanceLinesPerPeriod: Exact Online Balance Lines per Period

`popular` `insert` `update` `per partition` `XML`

- Catalogus: `ExactOnlineXML`
- Schema: `XML`
- Label: Balance Lines per Period

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom `Division`.

Je kunt gegevens ophalen en wijzigen met `insert` en `update`.

## Samenvatting

The current balance (debit versus credit) per combination of Exact Online company (division), financial year, financial period and for every GL account on balance and Profit and Loss.

Additional where-clause columns supported:
- division
- jaar
- prevyears (2 )
- period_from
- period_to
- afterentry (1 )
- showperiods (1 )

## API-bron

- XML-service: `Balances`
- XML-onderwerp: `Balances`
- XML-pad: `/Years/Year/Periods/Period`

## Tabelkolommen

De kolommen van de tabel `BalanceLinesPerPeriod` 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 |
|---|---|---|:---:|---|---|
| `BALANCE` | `number` | Balance | [x] |  |  |
| `COSTANALYSIS` | `varchar2` | Kostenanalyse | [ ] | `/eExact/Balances/Balance/Years/Year/Periods/Period/CostAnalysis/` |  |
| `CREDIT` | `number` | Credit | [x] | `/eExact/Balances/Balance/Years/Year/Periods/Period/Credit/` |  |
| `DEBIT` | `number` | Debit | [x] | `/eExact/Balances/Balance/Years/Year/Periods/Period/Debit/` |  |
| `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. |
| `INTERFACE_URL` | `varchar2(4000)` | Interface URL | [x] |  | URL gebruikt om deze rij uit te wisselen met Exact Online. |
| `PERIODS_YEAR_CLOSE` | `number` | Jaar Einde | [x] | `/eExact/Balances/Balance/Years/Year/Close/` |  |
| `PERIODS_YEAR_COSTANALYSIS` | `varchar2` | Year Cost Analysis | [ ] | `/eExact/Balances/Balance/Years/Year/CostAnalysis/` |  |
| `PERIODS_YEAR_CREDIT` | `number` | Jaar Credit | [x] | `/eExact/Balances/Balance/Years/Year/Credit/` |  |
| `PERIODS_YEAR_DEBIT` | `number` | Jaar Debit | [x] | `/eExact/Balances/Balance/Years/Year/Debit/` |  |
| `PERIODS_YEAR_OPEN` | `number` | Jaar Opening | [x] | `/eExact/Balances/Balance/Years/Year/Open/` |  |
| `PERIODS_YEAR_REPORTINGYEAR_ATTR` | `number` | Year Reporting Year | [x] | `/eExact/Balances/Balance/Years/Year/ReportingYear` |  |
| `PERIODS_YEAR_YEARS_BALANCE_ADDRESS` | `varchar2` | Balance Address | [ ] | `/eExact/Balances/Balance/Address/` |  |
| `PERIODS_YEAR_YEARS_BALANCE_BALANCETYPE_ATTR` | `varchar2` | Balance Balance Type | [x] | `/eExact/Balances/Balance/balanceType` |  |
| `PERIODS_YEAR_YEARS_BALANCE_CHAMBEROFCOMMERCE` | `varchar2` | Balance Chamber of Commerce | [ ] | `/eExact/Balances/Balance/ChamberOfCommerce/` |  |
| `PERIODS_YEAR_YEARS_BALANCE_CITY` | `varchar2` | Balance City | [ ] | `/eExact/Balances/Balance/City/` |  |
| `PERIODS_YEAR_YEARS_BALANCE_CODE_ATTR` | `varchar2` | Balance Code | [x] | `/eExact/Balances/Balance/code` |  |
| `PERIODS_YEAR_YEARS_BALANCE_COMPANYNAME` | `varchar2` | Balance Company Name | [ ] | `/eExact/Balances/Balance/CompanyName/` |  |
| `PERIODS_YEAR_YEARS_BALANCE_COUNTRY_CODE_ATTR` | `varchar2` | Landcode | [ ] | `/eExact/Balances/Balance/Country/code` |  |
| `PERIODS_YEAR_YEARS_BALANCE_COUNTRY_DESCRIPTION` | `varchar2(255)` | Land Omschrijving | [ ] | `/eExact/Balances/Balance/Country/Description/` |  |
| `PERIODS_YEAR_YEARS_BALANCE_COUNTRY_DESCRIPTION_TERMID_ATTR` | `number` | Balance Country Term ID | [ ] | `/eExact/Balances/Balance/Country/Description/termid` |  |
| `PERIODS_YEAR_YEARS_BALANCE_DESCRIPTION` | `varchar2(255)` | Balansomschrijving | [x] | `/eExact/Balances/Balance/Description/` |  |
| `PERIODS_YEAR_YEARS_BALANCE_DESCRIPTION_TERMID_ATTR` | `number` | itgen_eol_balances_balance_description Term ID | [ ] | `/eExact/Balances/Balance/Description/termid` |  |
| `PERIODS_YEAR_YEARS_BALANCE_LEADCODE` | `varchar2` | Balance Lead Code | [ ] | `/eExact/Balances/Balance/LeadCode/` |  |
| `PERIODS_YEAR_YEARS_BALANCE_POSTALCODE` | `varchar2` | Balance Postal Code | [ ] | `/eExact/Balances/Balance/PostalCode/` |  |
| `PREVYEARS` | `int32` | Vorige Jaren Inbegrepen | [ ] |  |  |
| `REPORTINGPERIOD_ATTR` | `number` | Rapportage Periode | [x] | `/eExact/Balances/Balance/Years/Year/Periods/Period/ReportingPeriod` |  |
| `ROWNUM` | `int64` | Rijnummer | [x] |  | Nummer van de regel binnen de resultaten, te beginnen bij 1. |


## 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)
