---
title: "LEDGER (AccountView)"
description: "General ledger"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/vismaaccountview/AccountView..LEDGER
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..LEDGER
updated: 2026-11-16T21:14:07Z
license: https://documentation.invantive.eu/nl/
---

# LEDGER: AccountView General ledger

`read only` `per partition`

- Catalogus: `AccountView`
- Label: General ledger

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `LEDGER` 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 |
|---|---|---|:---:|---|---|
| `ACCT_ALLOC` | `varchar2(10)` | Clear balance to | [ ] |  |  |
| `ACCT_BAL` | `int64` | Account balance | [ ] |  |  |
| `ACCT_COST` | `varchar2(10)` | Cost price account | [ ] |  |  |
| `ACCT_LINK` | `decimal` | Type controleaccount | [ ] |  |  |
| `ACCT_NAME` | `varchar2(40)` | Account description | [ ] |  |  |
| `ACCT_NR` | `varchar2(10)` | Rekeningnummer | [ ] |  |  |
| `ACCT_PROJ` | `char` | Project account | [ ] |  |  |
| `ACCT_TYPE` | `decimal` | Account type | [ ] |  |  |
| `ACT_PY` | `int64` | Balance prior year | [ ] |  |  |
| `BAL_BAL` | `int64` | Balance sheet | [ ] |  |  |
| `BAL_PL` | `int64` | P&L | [ ] |  |  |
| `CLT_BLK` | `char` | Blocked for client | [ ] |  |  |
| `CNG_DATE` | `datetime` | Datum van wijziging | [ ] |  |  |
| `CNG_NR` | `int32` | Nummer wijzigen | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `CO_ACCT` | `char` | Clearing account | [ ] |  |  |
| `CON_ACCT` | `varchar2(10)` | Statutory consolidation account | [ ] |  |  |
| `CON_ACCT2` | `varchar2(10)` | Internal consolidation account | [ ] |  |  |
| `COR_BAL` | `int64` | Balance of prior-year items | [ ] |  |  |
| `COR_CAMT` | `int64` | Adjustments credit amount | [ ] |  |  |
| `COR_DAMT` | `int64` | Adjustments debit amount | [ ] |  |  |
| `COST_CODE` | `varchar2(10)` | Cost centre code | [ ] |  |  |
| `COST_MAND` | `char` | Cost centre code required | [ ] |  |  |
| `CR_AMT` | `int64` | Kredietbedrag | [ ] |  |  |
| `CR_AMTMIN` | `int64` | Negative credit amount | [ ] |  |  |
| `CUR_CAMT` | `int64` | Currency amount credit | [ ] |  |  |
| `CUR_CODE` | `varchar2(3)` | Currency code | [ ] |  |  |
| `CUR_DAMT` | `int64` | Currency amount debit | [ ] |  |  |
| `DIST_CODE` | `varchar2(10)` | Toewijzingssleutel | [ ] |  |  |
| `DOSS_DESC` | `varchar2(4)` | Note | [ ] |  |  |
| `DOSS_REF` | `varchar2(10)` | File reference | [ ] |  |  |
| `DR_AMT` | `int64` | Afschrijvingsbedrag | [ ] |  |  |
| `EFS_CHK` | `varchar2(25)` | Element of taxonomy to be checked | [ ] |  |  |
| `EFS_LEDG` | `varchar2(25)` | Element of accounting taxonomy | [ ] |  |  |
| `FA_ACCT` | `char` | Asset account | [ ] |  |  |
| `FA_SELL` | `char` | Asset sales account | [ ] |  |  |
| `INP_DATE` | `datetime` | Datum van inschrijving | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `JRNL_QTY` | `char` | Number of journal lines to check | [ ] |  |  |
| `LDG_STAT` | `varchar2(5)` | Account status | [ ] |  |  |
| `NORM_STAT` | `decimal` | Normal balance | [ ] |  |  |
| `NOT_DASH` | `char` | Exclude from dashboard charts | [ ] |  |  |
| `PART_MAND` | `decimal` | Partner required | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PC_CODE` | `varchar2(5)` | Kostensoortcode | [ ] |  |  |
| `PRE_COR` | `int64` | For prior-year items | [ ] |  |  |
| `PRE_CORC` | `int64` | For prior-year items credit | [ ] |  |  |
| `PRE_CORD` | `int64` | For prior-year items debit | [ ] |  |  |
| `PRO_ATTR` | `varchar2(4)` | Linked project dimensions | [ ] |  |  |
| `PROJ_EXP` | `char` | Billable project costs/revenues | [ ] |  |  |
| `PROJ_OBLI` | `char` | Project commitments | [ ] |  |  |
| `QTY_MAND` | `decimal` | Quantity required | [ ] |  |  |
| `REC_BLK` | `char` | Blocked | [ ] |  |  |
| `REC_SYS` | `char` | System record | [ ] |  |  |
| `REV_ACCT` | `char` | Revalue currency | [ ] |  |  |
| `RUBRIEKEN` | `varchar2(40)` | Categories | [ ] |  |  |
| `SL_CODE1` | `varchar2(10)` | Hulpboek 1 | [ ] |  |  |
| `SL_CODE2` | `varchar2(10)` | Hulpboek 2 | [ ] |  |  |
| `SL_CODE3` | `varchar2(10)` | Hulpboek 3 | [ ] |  |  |
| `SPLIT_PA` | `char` | Split per partner | [ ] |  |  |
| `STAT_ORIG` | `varchar2(5)` | Original account status | [ ] |  |  |
| `STAT_SELL` | `char` | Opbrengstenrekening | [ ] |  |  |
| `SUM_RPT` | `char` | Summarise on general ledger card report | [ ] |  |  |
| `TRANS_NR` | `int32` | Number of transactions | [ ] |  |  |
| `VAT_CODE` | `varchar2(2)` | BTW-code | [ ] |  |  |
| `VAT_MAND` | `char` | VAT code required | [ ] |  |  |
| `WF_ALLOW` | `char` | Account suitable for use in IFA | [ ] |  |  |
| `WGT_MAND` | `decimal` | Weight required | [ ] |  |  |
| `WKR_TRN` | `char` | Transaction charged to free allowance WKR | [ ] |  |  |
| `XBRL_SPEC` | `char` | XBRL specification | [ ] |  |  |
