invantive documentation
Invantive Support ForumsLog In / Sign Up

ItemById2: Minox Item by ID

read only per partition REST

  • Catalog: Minox
  • Schema: MasterDataItem
  • Label: Item by 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 `` The identity of an sales item

Table Columns

The columns of the table ItemById2 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:

Changes of This Table, 26.0 to 27.0

  • - administration_code
  • - administration_name

All changes of the driver, 26.0 to 27.0