---
title: "LedgerAccounts (Minox)"
description: "Ledger Accounts"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/minox/Minox.MasterDataLedger.LedgerAccounts
original: https://documentation.invantive.eu/en/datamodels/minox/Minox.MasterDataLedger.LedgerAccounts
updated: 2026-11-01T16:19:41Z
license: https://documentation.invantive.eu/en/
---

# LedgerAccounts: Minox Ledger Accounts

`read only` `per partition` `REST`

- Catalog: `Minox`
- Schema: `MasterDataLedger`
- Label: Ledger Accounts

Retrieves a ledger_account list.

The data in this table is partitioned per value of the `administration_code` column.

Can only retrieve data.

## API Source

- Endpoint: `/tenant/{tenant_id}/administration/{administration_id}/ledger_account`
- Operation: `get /tenant/{tenant_id}/administration/{administration_id}/ledger_account`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `administration_code` | `` | [ ] |  | Partition to retrieve data from. |
| `number_of_fiscal_years` | `` | [ ] |  | If number of fiscal years is 1: only retrieve the ledger accounts of the last fiscal year.  If number of fiscal years is 2 - 5: Receive additional ledger accounts from earlier fiscal years that do not exist anymore in the last fiscal year, indicated with a 'deleted'-tag. On default, three fiscal years will be checked. |
| `rgs_based_on` | `` | [ ] |  | Enum: minox_balance or account_total (Values: minox_balance, account_total) |
| `rgs_mapping_level` | `` | [ ] |  | \| Value  \| Description                      \| \|--------\|----------------------------------\| \| saved  \| Saved mappings on administration \| \| best   \| 100% Mappings on tenant or crowd \| \| guess  \| Partly matched mappings          \| \| report \| Full mappings (for reporting)    \| If rgs_mapping_level is set to 'report', then rgs_based_on also needs to be set.  (Values: saved, best, guess, report) |

## Table Columns

The columns of the table `LedgerAccounts` 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 |
|---|---|---|:---:|---|---|
| `aggregate_transactions` | `char` | Aggregate Transactions | [ ] | filters on the platform, writable, `aggregate_transactions` | Whether the ledgeraccount needs to be compressed, also known as 'verdichten'. |
| `aggregation_aggregation_level` | `int64` | Aggregation Level | [ ] | filters on the platform, writable, `aggregation.aggregation_level` | Between 1 and 5. |
| `aggregation_description` | `varchar2` | Aggregation Description | [ ] | filters on the platform, writable, `aggregation.description` |  |
| `allow_free_vat_input` | `char` | Allow Free VAT Input | [ ] | filters on the platform, writable, `allow_free_vat_input` |  |
| `balance_description` | `varchar2` | Balance Description | [ ] | filters on the platform, writable, `balance.description` |  |
| `balance_id` | `int64` | Balance ID | [ ] | filters on the platform, writable, `balance.id` |  |
| `balance_isGroup` | `char` | Balance Is Group | [ ] | filters on the platform, writable, `balance.isGroup` |  |
| `balance_type` | `varchar2` | Balance Type | [ ] | filters on the platform, writable, `balance.type` |  |
| `blocked_active` | `char` | Blocked Active | [ ] | filters on the platform, writable, `blocked.active` | Indicates if the account is blocked |
| `blocked_reason` | `varchar2` | Blocked Reason | [ ] | filters on the platform, writable, `blocked.reason` | The reason the account is blocked |
| `budget_division_description` | `varchar2` | Budget Division Description | [ ] | filters on the platform, writable, `budget_division.description` |  |
| `budget_division_id` | `int64` | Budget Division ID | [ ] | filters on the platform, writable, `budget_division.id` |  |
| `cost_type_description` | `varchar2` | Cost Type Description | [ ] | filters on the platform, writable, `cost_type.description` |  |
| `debit_credit_suggestion` | `varchar2` | Debit/Credit Suggestion | [ ] | filters on the platform, writable, `debit_credit_suggestion` |  |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `description` |  |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` |  |
| `isBalance` | `char` | Is Balance | [ ] | filters on the platform, writable, `isBalance` |  |
| `memo_active` | `char` | Memo Active | [ ] | filters on the platform, writable, `memo.active` | Whether the memo is shown in the UI when this account is used. |
| `memo_text` | `varchar2` | Memo Text | [ ] | filters on the platform, writable, `memo.text` | The content of the memo. |
| `quantity_applicable` | `char` | Quantity Applicable | [ ] | filters on the platform, writable, `quantity_applicable` |  |
| `referral_ledger_account_description` | `varchar2` | Referral Ledger Account Description | [ ] | filters on the platform, writable, `referral_ledger_account.description` |  |
| `referral_ledger_account_id` | `int64` | Referral Ledger Account ID | [ ] | filters on the platform, writable, `referral_ledger_account.id` |  |
| `vat_account_id` | `varchar2` | VAT Account ID | [ ] | filters on the platform, writable, `vat.account_id` |  |
| `vat_amount` | `decimal` | VAT Amount | [ ] | filters on the platform, writable, `vat.amount` |  |
| `vat_description` | `varchar2` | VAT Description | [ ] | filters on the platform, writable, `vat.description` |  |
| `vat_id` | `int64` | VAT ID | [ ] | filters on the platform, writable, `vat.id` |  |
| `vat_percentage` | `decimal` | VAT Percentage | [ ] | filters on the platform, writable, `vat.percentage` |  |
| `vat_type` | `varchar2` | VAT Type | [ ] | filters on the platform, writable, `vat.type` |  |
| `year_budget` | `decimal` | Year Budget | [ ] | filters on the platform, writable, `year_budget` |  |



## Release Notes

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

- [Minox](/en/release-notes/drivers?driver=minox)

### Changes of This Table, 26.0 to 27.0

<a id="MNX-27.0-D183"></a><a id="MNX-27.0-D184"></a>

- `-` `administration_code`
- `-` `administration_name`

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=minox&step=26.0-to-27.0#minox-26.0-to-27.0)

