Items
An item represents an end product, intermediate product or a raw material.
Fields
Field |
Type |
Description |
---|---|---|
name |
non-empty string |
Unique name of the item.
This is the key field and a required attribute.
|
description |
string |
Free format description. |
category |
string |
Free format category. |
subcategory |
string |
Free format subcategory. |
owner |
item |
Items are organized in a hierarchical tree.
This field defines the parent item.
|
members |
list of item |
Items are organized in a hierarchical tree.
This field defines a list of child items.
|
cost |
double |
Cost or price of the item.
Depending on the precise usage and business goal it should
be evaluated which cost to load into this field: purchase
cost, booking value, selling price…
For most applications the booking value is the appropriate
one.
The default value is 0.
|
global_purchase |
boolean |
When this item flag is set, it will a) prevent any new
purchase orders for the item to be generated until the total
inventory across all locations drops below the total safety
stock and b) sales orders pointing at a location that is
running out of stock will automatically be pointed to other
locations in the network which still carry sufficient stock.
This field is not available in the standard database schema.
You’ll need to add it as a custom attribute, or set this
field through a custom Python script.
|
buffers |
list of buffer |
Returns the list of buffers for this item. |
hidden |
boolean |
Marks entities that are considered hidden and are normally not shown to the end user. |
Extra fields added by “metrics” app
This addon app provides some basic metrics that allow easy filtering and sorting for items that have constrained open sales orders.
Field |
Type |
Description |
---|---|---|
latedemandcount |
Integer |
The number of open sales orders of this item that is planned to be delivered late. |
latedemandquantity |
Number |
Total quantity of open sales orders of this item that is planned to be delivered late. |
latedemandvalue |
Number |
Total value of open sales orders of this item that is planned to be delivered late. |
unplanneddemandcount |
Integer |
The number of unplanned open sales orders of this item. |
unplanneddemandquantity |
Number |
Total quantity of unplanned open sales orders of this item. |
unplanneddemandvalue |
Number |
Total value of unplanned open sales orders of this item. |
Extra fields added by “demand hits” app
This addon app provides some metrics on the historical demand of the item. This is useful in identifying fast-moving and slow-moving items and define an ABC classification for segmenting the inventory policies correctly.
Field |
Type |
Description |
---|---|---|
orders_6m |
Number |
The number of sales orders of this item during the last 6 months. |
sales_6m |
Number |
Total quantity of sales orders of this item during the last 6 months. |
salesvalue_6m |
Number |
Total value of sales orders of this item during the last 6 months. |
orders_12m |
Number |
The number of sales orders of this item during the last 12 months. |
sales_12m |
Number |
Total quantity of sales orders of this item during the last 12 months. |
salesvalue_12m |
Number |
Total value of sales orders of this item during the last 12 months. |
Extra fields added by “forecast” app
The forecast app enables the calculation of statistical forecasts based on the demand history. It also includes a categorization of demand patterns, as described on https://frepple.com/blog/demand-classification/
Field |
Type |
Description |
---|---|---|
demand_pattern |
String |
Demand pattern: “smooth”, “intermittent”, “erratic” or “lumpy”. |
adi |
Number |
Average demand interval.
It measures the demand regularity in time by computing
the average interval between two demands.
|
cv2 |
Number |
Square of the coefficient of variation.
It measures the variation in quantities.
|
Extra fields added by “inventory planning” app
This app enables the calculation of safety stocks and reorder quantities.
Field |
Type |
Description |
---|---|---|
successor |
Item |
Refers to another item that is replacing this item.
It is used to display a global overview of the inventory
status of an item - across all locations and across its
successor and predecessor items.
|