ItemPriceDeviantsByItemId: Minox Item Price Deviants by Item ID
read only per partition REST
- Catalog:
Minox - Schema:
MasterDataItem - Label: Item Price Deviants 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_ |
`` | Partition to retrieve data from. | ||
item_ |
`` | The identity of an sales item |
Table Columns
The columns of the table ItemPriceDeviantsByItemId 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_ |
char |
Amount Applicable | filters on the platform, writable, ::ancestor. |
||
blocked |
char |
Blocked | filters on the platform, writable, ::ancestor. |
Indicates if the account is blocked | |
content |
decimal |
Content | filters on the platform, writable, ::ancestor. |
||
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
||
discount_ |
int64 |
Discount Group ID | filters on the platform, writable, ::ancestor. |
||
discount_ |
varchar2 |
Discount Group Value | filters on the platform, writable, ::ancestor. |
||
extended_ |
varchar2 |
Extended Description | filters on the platform, writable, ::ancestor. |
||
g_ |
char |
G-Account | filters on the platform, writable, ::ancestor. |
||
id |
varchar2 |
ID | writable, id |
||
id_2 |
varchar2 |
itgen_minox_id_2 | filters on the platform, writable, ::ancestor. |
||
item_ |
int64 |
Item Group ID | filters on the platform, writable, ::ancestor. |
||
item_ |
varchar2 |
Item Group Value | filters on the platform, writable, ::ancestor. |
||
memo_ |
char |
Memo Active | filters on the platform, writable, ::ancestor. |
Whether the memo is shown in the UI when this account is used. | |
memo_ |
varchar2 |
Memo Text | filters on the platform, writable, ::ancestor. |
The content of the memo. | |
pack_ |
int64 |
Pack Quantity | filters on the platform, writable, ::ancestor. |
The amount of an item in one package | |
price |
decimal |
Price | filters on the platform, writable, ::ancestor. |
||
price_ |
int64 |
Price per Quantity | filters on the platform, writable, ::ancestor. |
||
price_ |
decimal |
Price Purchase | filters on the platform, writable, ::ancestor. |
||
price_ |
decimal |
Price Recommended | filters on the platform, writable, ::ancestor. |
||
statistics_ |
varchar2 |
Statistics per | filters on the platform, writable, ::ancestor. |
||
track_ |
char |
Track Sales History | filters on the platform, writable, ::ancestor. |
||
unit_ |
varchar2 |
Unit Packaging | filters on the platform, writable, ::ancestor. |
The measuring unit or packaging method of the items | |
value |
decimal |
Value | writable, value |
||
vat_ |
varchar2 |
VAT Description | filters on the platform, writable, ::ancestor. |
||
vat_id |
int64 |
VAT ID | filters on the platform, writable, ::ancestor. |
||
weight |
decimal |
Weight | filters on the platform, writable, ::ancestor. |
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