---
title: "SupplierById (Minox)"
description: "Supplier by ID"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/minox/Minox.MasterDataSupplier.SupplierById
original: https://documentation.invantive.eu/en/datamodels/minox/Minox.MasterDataSupplier.SupplierById
updated: 2026-11-01T16:19:41Z
license: https://documentation.invantive.eu/en/
---

# SupplierById: Minox Supplier by ID

`read only` `per partition` `REST`

- Catalog: `Minox`
- Schema: `MasterDataSupplier`
- Label: Supplier by ID

Get the supplier using its identity.

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

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `administration_code` | `` | [ ] |  | Partition to retrieve data from. |
| `supplier_id` | `` | [x] |  | The supplier to access. |

## Table Columns

The columns of the table `SupplierById` 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 |
|---|---|---|:---:|---|---|
| `aggregation_aggregation_level` | `int64` | Aggregation Level | [ ] | filters on the platform, writable, `aggregation.aggregation_level` | The level of the aggregation |
| `aggregation_description` | `varchar2` | Aggregation Description | [ ] | filters on the platform, writable, `aggregation.description` | The description of the aggregation. |
| `bank_bic` | `varchar2` | Bank BIC | [ ] | filters on the platform, writable, `bank.bic` | The Business Identifier Code (BIC).  Go to https://en.wikipedia.org/wiki/ISO_9362 for more information. |
| `bank_city` | `varchar2` | Bank City | [ ] | filters on the platform, writable, `bank.city` | The city the bank branch office is located in. |
| `bank_iban` | `varchar2` | Bank IBAN | [ ] | filters on the platform, writable, `bank.iban` | The International Bank Account Number. Go to https://en.wikipedia.org/wiki/International_Bank_Account_Number for more information. |
| `bank_name` | `varchar2` | Bank Name | [ ] | filters on the platform, writable, `bank.name` | The name of the bank. |
| `block_automatic_payments` | `char` | Block Automatic Payments | [ ] | filters on the platform, writable, `block_automatic_payments` |  |
| `blocked_active` | `char` | Blocked Active | [ ] | filters on the platform, writable, `blocked.active` | Indicates whether the supplier is blocked. |
| `blocked_reason` | `varchar2` | Blocked Reason | [ ] | filters on the platform, writable, `blocked.reason` | The reason the supplier is blocked. |
| `chamber_of_commerce` | `varchar2` | Chamber Of Commerce | [ ] | filters on the platform, writable, `chamber_of_commerce` | The chamber of commerce (Dutch: 'KvK') number.  This field is important when working with Scan & Herken, where based on this number,  it is decided on which supplier id the purchase invoice will be booked. In case this field is not provided, this will be marked as 'partially recognized'. |
| `currency_description` | `varchar2` | Currency Description | [ ] | filters on the platform, writable, `currency.description` |  |
| `currency_exchange_rate` | `decimal` | Currency Exchange Rate | [ ] | filters on the platform, writable, `currency.exchange_rate` |  |
| `currency_id` | `varchar2` | Currency ID | [ ] | filters on the platform, writable, `currency.id` |  |
| `default_payment_reference` | `varchar2` | Default Payment Reference | [ ] | filters on the platform, writable, `default_payment_reference` | A payment reference can be set in order to give the supplier information what this payment was meant for. |
| `externalid` | `varchar2` | External ID | [ ] | filters on the platform, writable, `externalid` | The external identification that has been linked to the supplier via third-party software. |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` | The identifying number for a supplier. Must fall within the range of one of the sales journals |
| `is_one_time` | `char` | Is One-Time | [ ] | filters on the platform, writable, `is_one_time` | Specifies if a supplier is used for one-time sales. |
| `language` | `varchar2` | Language | [ ] | filters on the platform, writable, `language` | The language of the supplier. Represented as an ISO-639-1 language code. |
| `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. |
| `payment_term_days` | `decimal` | Payment Term Days | [ ] | filters on the platform, writable, `payment_term.days` |  |
| `payment_term_description` | `varchar2` | Payment Term Description | [ ] | filters on the platform, writable, `payment_term.description` |  |
| `payment_term_id` | `int64` | Payment Term ID | [ ] | filters on the platform, writable, `payment_term.id` |  |
| `payment_term_mandate` | `varchar2` | Payment Term Mandate | [ ] | filters on the platform, writable, `payment_term.mandate` |  |
| `payment_term_start` | `varchar2` | Payment Term Start | [ ] | filters on the platform, writable, `payment_term.start` |  |
| `payment_term_terms_days` | `decimal` | Payment Term Terms Days | [ ] | filters on the platform, writable, `payment_term.terms.days` |  |
| `payment_term_terms_percentage` | `decimal` | Payment Term Terms Percentage | [ ] | filters on the platform, writable, `payment_term.terms.percentage` |  |
| `payment_term_terms_type` | `varchar2` | Payment Term Terms Type | [ ] | filters on the platform, writable, `payment_term.terms.type` |  |
| `vat_active` | `char` | VAT Active | [ ] | filters on the platform, writable, `vat.active` | Whether an automatic VAT proposition will be made for the supplier. |
| `vat_suggested_gl_account` | `int64` | VAT Suggested GL Account | [ ] | filters on the platform, writable, `vat.suggested_gl_account` | The suggested GL account (Dutch: 'tegenrekening') that will be used when an automatic VAT proposition will be made. |
| `vat_suggested_vat_id` | `int64` | VAT Suggested VAT ID | [ ] | filters on the platform, writable, `vat.suggested_vat_id` | The suggested VAT identification that will be used when an automatic VAT proposition will be made. |
| `vat_vat_registration_number` | `varchar2` | VAT Registration Number | [ ] | filters on the platform, writable, `vat.vat_registration_number` | The identifying number of a VAT registration. This number is also used for sales tax. |



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

