| Name | Description | Type | Additional information |
|---|---|---|---|
| id_item_sub | globally unique identifier |
None. |
|
| id_category | globally unique identifier |
None. |
|
| id_item | globally unique identifier |
None. |
|
| id_item_type | globally unique identifier |
None. |
|
| category_name | string |
None. |
|
| item_name | string |
None. |
|
| item_type_name | string |
None. |
|
| barcode | string |
None. |
|
| stock_ideal | decimal number |
None. |
|
| stock_min | decimal number |
None. |
|
| stock_max | decimal number |
None. |
|
| stock_real | decimal number |
None. |
|
| stock_last | decimal number |
None. |
|
| stock_in | decimal number |
None. |
|
| stock_out | decimal number |
None. |
|
| active | boolean |
None. |