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

# AdministrationBanks: Minox Administration Banks

`read only` `per partition` `REST`

- Catalog: `Minox`
- Schema: `MasterDataAdministration`
- Label: Administration Banks

Retrieves a single administration.

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}`
- Operation: `get /tenant/{tenant_id}/administration/{administration_id}`

## Table Columns

The columns of the table `AdministrationBanks` 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 |
|---|---|---|:---:|---|---|
| `bank_account` | `varchar2` | Bank Account | [ ] | filters on the platform, writable, `::ancestor.bank_account` |  |
| `bic` | `varchar2` | BIC | [ ] | writable, `bic` |  |
| `chamber_of_commerce_city` | `varchar2` | Chamber Of Commerce City | [ ] | filters on the platform, writable, `::ancestor.chamber_of_commerce.city` |  |
| `chamber_of_commerce_id` | `varchar2` | Chamber Of Commerce ID | [ ] | filters on the platform, writable, `::ancestor.chamber_of_commerce.id` |  |
| `city` | `varchar2` | City | [ ] | writable, `city` |  |
| `contact_email` | `varchar2` | Contact Email | [ ] | filters on the platform, writable, `::ancestor.contact.email` |  |
| `contact_name` | `varchar2` | Contact Name | [ ] | filters on the platform, writable, `::ancestor.contact.name` |  |
| `contact_salutation` | `varchar2` | Contact Salutation | [ ] | filters on the platform, writable, `::ancestor.contact.salutation` |  |
| `currency_description` | `varchar2` | Currency Description | [ ] | filters on the platform, writable, `::ancestor.currency.description` |  |
| `currency_exchange_rate` | `decimal` | Currency Exchange Rate | [ ] | filters on the platform, writable, `::ancestor.currency.exchange_rate` |  |
| `currency_id` | `varchar2` | Currency ID | [ ] | filters on the platform, writable, `::ancestor.currency.id` |  |
| `decimals_amount` | `int64` | Decimals Amount | [ ] | filters on the platform, writable, `::ancestor.decimals.amount` |  |
| `decimals_volume` | `int64` | Decimals Volume | [ ] | filters on the platform, writable, `::ancestor.decimals.volume` |  |
| `declaration_type` | `varchar2` | Declaration Type | [ ] | filters on the platform, writable, `::ancestor.declaration_type` |  |
| `follow_up_description_extra_description` | `varchar2` | Follow Up Description Extra Description | [ ] | filters on the platform, writable, `::ancestor.follow_up_description.extra_description` |  |
| `follow_up_description_invoice_texts` | `char` | Follow Up Description Invoice Texts | [ ] | filters on the platform, writable, `::ancestor.follow_up_description.invoice_texts` |  |
| `follow_up_description_manual_descriptions` | `char` | Follow Up Description Manual Descriptions | [ ] | filters on the platform, writable, `::ancestor.follow_up_description.manual_descriptions` |  |
| `follow_up_description_under_or_after` | `varchar2` | Follow Up Description Under or After | [ ] | filters on the platform, writable, `::ancestor.follow_up_description.under_or_after` |  |
| `g_rekening_iban` | `varchar2` | G-Account IBAN | [ ] | filters on the platform, writable, `::ancestor.g_rekening.iban` |  |
| `g_rekening_percentage` | `decimal` | G-Account Percentage | [ ] | filters on the platform, writable, `::ancestor.g_rekening.percentage` |  |
| `iban` | `varchar2` | IBAN | [ ] | writable, `iban` |  |
| `id` | `int64` | ID | [ ] | writable, `id` |  |
| `id_2` | `int64` | itgen_minox_id_2 | [ ] | filters on the platform, writable, `::ancestor.id` |  |
| `incasso_mandate_id` | `varchar2` | Incasso Mandate ID | [ ] | filters on the platform, writable, `::ancestor.incasso_mandate_id` |  |
| `include_invoice` | `varchar2` | Include Invoice | [ ] | filters on the platform, writable, `::ancestor.include_invoice` |  |
| `ledger_accounts_automatic_payments_description` | `varchar2` | Ledger Accounts Automatic Payments Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.automatic_payments.description` |  |
| `ledger_accounts_automatic_payments_id` | `varchar2` | Ledger Accounts Automatic Payment ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.automatic_payments.id` |  |
| `ledger_accounts_automatic_payments_scheme` | `varchar2` | Ledger Accounts Automatic Payment Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.automatic_payments.scheme` |  |
| `ledger_accounts_automatic_payments_type` | `varchar2` | Ledger Accounts Automatic Payment Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.automatic_payments.type` |  |
| `ledger_accounts_debt_collection_description` | `varchar2` | Ledger Accounts Debt Collection Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.debt_collection.description` |  |
| `ledger_accounts_debt_collection_id` | `varchar2` | Ledger Accounts Debt Collection ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.debt_collection.id` |  |
| `ledger_accounts_debt_collection_scheme` | `varchar2` | Ledger Accounts Debt Collection Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.debt_collection.scheme` |  |
| `ledger_accounts_debt_collection_type` | `varchar2` | Ledger Accounts Debt Collection Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.debt_collection.type` |  |
| `ledger_accounts_exchange_rate_description` | `varchar2` | Ledger Accounts Exchange Rate Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.exchange_rate.description` |  |
| `ledger_accounts_exchange_rate_id` | `varchar2` | Ledger Accounts Exchange Rate ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.exchange_rate.id` |  |
| `ledger_accounts_exchange_rate_scheme` | `varchar2` | Ledger Accounts Exchange Rate Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.exchange_rate.scheme` |  |
| `ledger_accounts_exchange_rate_type` | `varchar2` | Ledger Accounts Exchange Rate Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.exchange_rate.type` |  |
| `ledger_accounts_invoice_high_description` | `varchar2` | Ledger Accounts Invoice High Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_high.description` |  |
| `ledger_accounts_invoice_high_id` | `varchar2` | Ledger Accounts Invoice High ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_high.id` |  |
| `ledger_accounts_invoice_high_scheme` | `varchar2` | Ledger Accounts Invoice High Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_high.scheme` |  |
| `ledger_accounts_invoice_high_type` | `varchar2` | Ledger Accounts Invoice High Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_high.type` |  |
| `ledger_accounts_invoice_low_description` | `varchar2` | Ledger Accounts Invoice Low Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_low.description` |  |
| `ledger_accounts_invoice_low_id` | `varchar2` | Ledger Accounts Invoice Low ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_low.id` |  |
| `ledger_accounts_invoice_low_scheme` | `varchar2` | Ledger Accounts Invoice Low Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_low.scheme` |  |
| `ledger_accounts_invoice_low_type` | `varchar2` | Ledger Accounts Invoice Low Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_low.type` |  |
| `ledger_accounts_invoice_zero_description` | `varchar2` | Ledger Accounts Invoice Zero Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_zero.description` |  |
| `ledger_accounts_invoice_zero_id` | `varchar2` | Ledger Accounts Invoice Zero ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_zero.id` |  |
| `ledger_accounts_invoice_zero_scheme` | `varchar2` | Ledger Accounts Invoice Zero Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_zero.scheme` |  |
| `ledger_accounts_invoice_zero_type` | `varchar2` | Ledger Accounts Invoice Zero Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.invoice_zero.type` |  |
| `ledger_accounts_paid_received_vat_description` | `varchar2` | Ledger Accounts Paid Received VAT Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.paid_received_vat.description` |  |
| `ledger_accounts_paid_received_vat_id` | `varchar2` | Ledger Accounts Paid Received VAT ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.paid_received_vat.id` |  |
| `ledger_accounts_paid_received_vat_scheme` | `varchar2` | Ledger Accounts Paid Received VAT Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.paid_received_vat.scheme` |  |
| `ledger_accounts_paid_received_vat_type` | `varchar2` | Ledger Accounts Paid Received VAT Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.paid_received_vat.type` |  |
| `ledger_accounts_private_vat_description` | `varchar2` | Ledger Accounts Private VAT Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.private_vat.description` |  |
| `ledger_accounts_private_vat_id` | `varchar2` | Ledger Accounts Private VAT ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.private_vat.id` |  |
| `ledger_accounts_private_vat_scheme` | `varchar2` | Ledger Accounts Private VAT Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.private_vat.scheme` |  |
| `ledger_accounts_private_vat_type` | `varchar2` | Ledger Accounts Private VAT Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.private_vat.type` |  |
| `ledger_accounts_profit_loss_description` | `varchar2` | Ledger Accounts Profit Loss Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.profit_loss.description` |  |
| `ledger_accounts_profit_loss_id` | `varchar2` | Ledger Accounts Profit Loss ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.profit_loss.id` |  |
| `ledger_accounts_profit_loss_scheme` | `varchar2` | Ledger Accounts Profit Loss Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.profit_loss.scheme` |  |
| `ledger_accounts_profit_loss_type` | `varchar2` | Ledger Accounts Profit Loss Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.profit_loss.type` |  |
| `ledger_accounts_transaction_rounding_description` | `varchar2` | Ledger Accounts Transaction Rounding Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.transaction_rounding.description` |  |
| `ledger_accounts_transaction_rounding_id` | `varchar2` | Ledger Accounts Transaction Rounding ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.transaction_rounding.id` |  |
| `ledger_accounts_transaction_rounding_scheme` | `varchar2` | Ledger Accounts Transaction Rounding Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.transaction_rounding.scheme` |  |
| `ledger_accounts_transaction_rounding_type` | `varchar2` | Ledger Accounts Transaction Rounding Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.transaction_rounding.type` |  |
| `ledger_accounts_unknown_transactions_description` | `varchar2` | Ledger Accounts Unknown Transactions Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.unknown_transactions.description` |  |
| `ledger_accounts_unknown_transactions_id` | `varchar2` | Ledger Accounts Unknown Transactions ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.unknown_transactions.id` |  |
| `ledger_accounts_unknown_transactions_scheme` | `varchar2` | Ledger Accounts Unknown Transactions Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.unknown_transactions.scheme` |  |
| `ledger_accounts_unknown_transactions_type` | `varchar2` | Ledger Accounts Unknown Transactions Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.unknown_transactions.type` |  |
| `ledger_accounts_vat_in_europe_gl_account_description` | `varchar2` | Ledger Accounts VAT In Europe GL Account Description | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.vat_in_europe_gl_account.description` |  |
| `ledger_accounts_vat_in_europe_gl_account_id` | `varchar2` | Ledger Accounts VAT In Europe GL Account ID | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.vat_in_europe_gl_account.id` |  |
| `ledger_accounts_vat_in_europe_gl_account_scheme` | `varchar2` | Ledger Accounts VAT In Europe GL Account Scheme | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.vat_in_europe_gl_account.scheme` |  |
| `ledger_accounts_vat_in_europe_gl_account_type` | `varchar2` | Ledger Accounts VAT In Europe GL Account Type | [ ] | filters on the platform, writable, `::ancestor.ledger_accounts.vat_in_europe_gl_account.type` |  |
| `memo_action_text` | `varchar2` | Memo Action Text | [ ] | filters on the platform, writable, `::ancestor.memo_action.text` | Memo to note actions that must be undertaken |
| `memo_assignation_text` | `varchar2` | Memo Assignation Text | [ ] | filters on the platform, writable, `::ancestor.memo_assignation.text` | Memo to note permanent agreements |
| `memo_text` | `varchar2` | Memo Text | [ ] | filters on the platform, writable, `::ancestor.memo.text` | Deprecated / Not in use |
| `name` | `varchar2` | Name | [ ] | writable, `name` |  |
| `name_2` | `varchar2` | itgen_minox_name_2 | [ ] | filters on the platform, writable, `::ancestor.name` |  |
| `new_document` | `varchar2` | New Document | [ ] | filters on the platform, writable, `::ancestor.new_document` |  |
| `next_number_invoice_number` | `int64` | Next Number Invoice Number | [ ] | filters on the platform, writable, `::ancestor.next_number.invoice_number` |  |
| `next_number_order_number` | `int64` | Next Number Order Number | [ ] | filters on the platform, writable, `::ancestor.next_number.order_number` |  |
| `next_number_quotation_number` | `int64` | Next Number Quotation Number | [ ] | filters on the platform, writable, `::ancestor.next_number.quotation_number` |  |
| `next_number_subscription_number` | `int64` | Next Number Subscription Number | [ ] | filters on the platform, writable, `::ancestor.next_number.subscription_number` |  |
| `number_of_periods` | `int64` | Number of Periods | [ ] | filters on the platform, writable, `::ancestor.number_of_periods` |  |
| `order_collection_sorting` | `varchar2` | Order Collection Sorting | [ ] | filters on the platform, writable, `::ancestor.order_collection_sorting` |  |
| `share_id` | `varchar2` | Share ID | [ ] | filters on the platform, writable, `::ancestor.share_id` |  |
| `show_on_accountancy_dashboard` | `char` | Show On Accountancy Dashboard | [ ] | filters on the platform, writable, `::ancestor.show_on_accountancy_dashboard` |  |
| `tax_sourcing_method` | `varchar2` | Tax Sourcing Method | [ ] | filters on the platform, writable, `::ancestor.tax_sourcing.method` |  |
| `tax_sourcing_provided_by_becon_number` | `varchar2` | Tax Sourcing Provided by Becon Number | [ ] | filters on the platform, writable, `::ancestor.tax_sourcing.provided_by.becon_number` |  |
| `tax_sourcing_provided_by_contact` | `varchar2` | Tax Sourcing Provided by Contact | [ ] | filters on the platform, writable, `::ancestor.tax_sourcing.provided_by.contact` |  |
| `tax_sourcing_provided_by_phone_number` | `varchar2` | Tax Sourcing Provided by Phone Number | [ ] | filters on the platform, writable, `::ancestor.tax_sourcing.provided_by.phone_number` |  |
| `uuid` | `varchar2` | UUID | [ ] | filters on the platform, writable, `::ancestor.uuid` |  |
| `vat_codes_high_vat_id` | `int64` | VAT Codes High VAT ID | [ ] | filters on the platform, writable, `::ancestor.vat_codes.high_vat_id` |  |
| `vat_codes_low_vat_id` | `int64` | VAT Codes Low VAT ID | [ ] | filters on the platform, writable, `::ancestor.vat_codes.low_vat_id` |  |
| `vat_id` | `varchar2` | VAT ID | [ ] | filters on the platform, writable, `::ancestor.vat_id` |  |
| `vat_in_europe_threshold_active` | `char` | VAT in Europe Threshold Active | [ ] | filters on the platform, writable, `::ancestor.vat_in_europe_threshold_active` |  |
| `vat_number` | `varchar2` | VAT Number | [ ] | filters on the platform, writable, `::ancestor.vat_number` |  |
| `vat_on_sub` | `char` | VAT On Sub | [ ] | filters on the platform, writable, `::ancestor.vat_on_sub` |  |
| `write_off_vat_difference_until` | `decimal` | Write Off VAT Difference Until | [ ] | filters on the platform, writable, `::ancestor.write_off_vat_difference_until` |  |



## 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-D055"></a><a id="MNX-27.0-D056"></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)

