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

# ItemCustomFieldsByItemId: Minox Item Custom Fields by Item ID

`read only` `per partition` `REST`

- Catalog: `Minox`
- Schema: `MasterDataItem`
- Label: Item Custom Fields by Item ID

Retrieve a sales item based on an item ID.

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

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `administration_code` | `` | [ ] |  | Partition to retrieve data from. |
| `item_id` | `` | [x] |  | The identity of an sales item |

## Table Columns

The columns of the table `ItemCustomFieldsByItemId` 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 |
|---|---|---|:---:|---|---|
| `amount_applicable` | `char` | Amount Applicable | [ ] | filters on the platform, writable, `::ancestor.amount_applicable` |  |
| `blocked` | `char` | Blocked | [ ] | filters on the platform, writable, `::ancestor.blocked` | Indicates if the account is blocked |
| `content` | `decimal` | Content | [ ] | filters on the platform, writable, `::ancestor.content` |  |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `::ancestor.description` |  |
| `discount_group_id` | `int64` | Discount Group ID | [ ] | filters on the platform, writable, `::ancestor.discount_group.id` |  |
| `discount_group_value` | `varchar2` | Discount Group Value | [ ] | filters on the platform, writable, `::ancestor.discount_group.value` |  |
| `extended_description` | `varchar2` | Extended Description | [ ] | filters on the platform, writable, `::ancestor.extended_description` |  |
| `g_rek_account` | `char` | G-Account | [ ] | filters on the platform, writable, `::ancestor.g_rek_account` |  |
| `id` | `varchar2` | ID | [ ] | writable, `id` |  |
| `id_2` | `varchar2` | itgen_minox_id_2 | [ ] | filters on the platform, writable, `::ancestor.id` |  |
| `item_group_id` | `int64` | Item Group ID | [ ] | filters on the platform, writable, `::ancestor.item_group.id` |  |
| `item_group_value` | `varchar2` | Item Group Value | [ ] | filters on the platform, writable, `::ancestor.item_group.value` |  |
| `memo_active` | `char` | Memo Active | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.memo.text` | The content of the memo. |
| `pack_quantity` | `int64` | Pack Quantity | [ ] | filters on the platform, writable, `::ancestor.pack_quantity` | The amount of an item in one package |
| `price` | `decimal` | Price | [ ] | filters on the platform, writable, `::ancestor.price` |  |
| `price_per_quantity` | `int64` | Price per Quantity | [ ] | filters on the platform, writable, `::ancestor.price_per_quantity` |  |
| `price_purchase` | `decimal` | Price Purchase | [ ] | filters on the platform, writable, `::ancestor.price_purchase` |  |
| `price_recommended` | `decimal` | Price Recommended | [ ] | filters on the platform, writable, `::ancestor.price_recommended` |  |
| `statistics_per` | `varchar2` | Statistics per | [ ] | filters on the platform, writable, `::ancestor.statistics_per` |  |
| `track_sales_history` | `char` | Track Sales History | [ ] | filters on the platform, writable, `::ancestor.track_sales_history` |  |
| `unit_packaging` | `varchar2` | Unit Packaging | [ ] | filters on the platform, writable, `::ancestor.unit_packaging` | The measuring unit or packaging method of the items |
| `value` | `varchar2` | Value | [ ] | writable, `value` |  |
| `vat_description` | `varchar2` | VAT Description | [ ] | filters on the platform, writable, `::ancestor.vat.description` |  |
| `vat_id` | `int64` | VAT ID | [ ] | filters on the platform, writable, `::ancestor.vat.id` |  |
| `weight` | `decimal` | Weight | [ ] | filters on the platform, writable, `::ancestor.weight` | The weight of the item |



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

