Item Header
Note that the information in the order header is read-only and cannot be modified. The information is added automatically.
Field |
Description |
Category |
The category of the item (imported with item import) |
Manufacturer |
The manufacturer of the item (imported with item import) |
Last delivery by |
The name of the supplier, which last delivered this item |
Supplier price (last delivery) (€) |
The price at which the item was last delivered (in currency) |
Net selling price (€) |
The net selling price for the item (imported with item import) |
VAT |
The VAT rate for the item (imported with item import), based on the country |
Gross selling price (€) |
The gross selling price for the item (imported with item import) |
General
Field |
Description |
Item name |
The name of the item (imported with item import) |
Item type |
The type of item |
Category |
The category of the item (imported with item import) |
Manufacturer |
The manufacturer of the item (imported with item import) |
Packing unit |
The number of items contained in one package |
Imputed supplier price |
Imputed supplier price is the supplier price with added cost of transportation, handling, etc. |
Item Description |
Description of the item, max. 4000 characters, not editable. Can only be imported from the shop with item import (BMEcat). Allows HTML code. |
STOCK INFORMATION | |
Location |
Name of the location |
Physical Q |
Physical quantity in stock |
Avail. Q |
Available quantity in stock (physical stock with subtracted open customer orders with statuses ANG, HAL and EIN) |
Avail. Q (Res.) |
Available quantity with reservations (physical stock with subtracted reservations in open customer orders (reservation module has to be enabled) - open customer orders are not subtracted from physical stock unless items are reserved) |
Reorder Level |
The quantity of an item in stock when the item should be ordered at supplier. Used for calculation of supplier order suggestions. |
Safety Stock |
The minimum quantity of an item that must be in stock |
Target Stock |
The quantity of item stock required to meet customer demand. Used for calculation of supplier order suggestions. |
Open C. Ord. |
Quantity of the item in open customer orders, listed separately for open orders (status ANG) and orders on hold (status HAL) |
Open S. Ord. |
Normal: Quantity of the item in open, normal supplier orders (supplier orders with status NEW, ORD and CON). Calculation: |
Demand |
Statistics of customer orders in all statuses except STO and NLB. This means that items in customer orders with status NEW, ANG, EIN or HAL are also treated as sold items (not only AUS) in last month (30 days), last four months (120 days) and last year (365 days) |
Return Rate (%) |
The percentage of returned items in the last year (365 days) |
ITEM CODES | |
Code |
Item number |
Code Type |
Item code type |
Scannable |
Defines whether a code can be scanned at Scan-In in pixi* Shipping. |
Supplier |
The name of the supplier, to which the item number belongs (applicable for supplier item number) |
Created By |
The name of the user, who created the item code, can also be the shop name if imported (system field, added automatically) |
Created |
Date on which the item code was created (system field, added automatically) |
Modified By |
The name of the user, who modified the item code, can also be the shop name if imported (system field, added automatically) |
Modified |
Date on which the item code was modified (system field, added automatically) |
TAGS | |
Tags |
Item tags can be added or removed for the item |
DIMENSIONS | |
Length (cm) |
Length in centimeters; only integers are allowed; value can also be entered in "mm" |
Width (cm) |
Width in centimeters; only integers are allowed; value can also be entered in "mm" |
Weight (g) |
Weight in grams; only integers are allowed; value can also be entered in "mg" |
Height (cm) |
Height in centimeters; only integers are allowed; value can also be entered in "mm" |
Volume (cm³) |
Volume of the item, calculated automatically; only integers are allowed; value can also be entered in "mm³" |
Bins
Field |
Description |
BINS WITH THIS ITEM | |
Location |
Bin's location |
Bin |
Bin's name |
Quantity |
Quantity of the item of the displayed storage bin |
Batch and Best Before
Field |
Description |
EAN |
Barcode EAN of the current supplier |
Quantity |
Quantity of the item of the displayed storage bin |
Bin Name |
Bin's name |
Batch Number |
Batch number assigned to the item |
Best Before Date |
Best before date assigned to the item |
Suppliers
Field |
Description |
Favourite |
The supplier marked as "favourite" is automatically provided with an |
Current Supplier |
The supplier specified in pixi as "current" is marked with an |
Supplier |
The name of the supplier |
Sup. ID |
The number of the supplier |
Sup. Item Nr. |
The item number, assigned to the item by the supplier |
Barcode |
The barcode, assigned to the item by the supplier |
Sup. Price (€) |
The item price in the currency at the supplier |
Min. Order Q |
Minimum quantity of the item that must be ordered at the supplier |
Item Delivery Time (d) |
Calculated average delivery time in days for the supplier |
Del. Time (d) |
Required days to deliver an order under normal circumstances (used to calculate estimated delivery date for supplier orders) |
Only PU |
Defines if packing unit must be applied when ordering the item at this supplier when generating supplier order suggestions |
SUPPLIER DETAIL | |
This information can be viewed from the Action menu > Open |
|
Barcode |
Item barcode, assigned to the item by the supplier |
Supplier item number |
The item number, assigned to the item by the supplier |
Supplier price (€) |
The item price in currency at the supplier |
Minimum order quantity |
Minimum quantity of the item that must be ordered at the supplier |
Item delivery time (d) |
Delivery time for this item on this supplier |
Only PU |
This option defines if packing unit must be applied when generating supplier order suggestions |
Block prices |
Item specific information on cost advantages based on the ordered amount |
Block prices are valid from - to |
The date range within which the block prices can be applied |
Bonus |
Item specific information on additional discounts available for long-term partnership, based on the target amount or quantity |
Bonus targets are valid from - to |
The date range within which the bonus targets can be applied |
Bundle
Field |
Description |
Item Name |
(details for bundle - list of bundled items) Descriptive name of items in a bundle |
Bundle Name |
(details for bundled item - list of bundles containing this item) Descriptive name of bundles that contain this item |
Quantity |
The quantity of item in the bundle (how many pieces of this item is included in a bundle) |
Physical Q |
Physical quantity in stock, actual physical stock for items, calculated physical stock for bundles |
Avail. Q |
Available quantity in stock (physical stock with subtracted open customer orders with statuses ANG, HAL and EIN), actual for items, calculated for bundles |
Avail. Q (Res.) |
Available quantity with reservations (physical stock with subtracted reservations in open customer orders (reservation module has to be enabled) - open customer orders are not subtracted from physical stock unless items are reserved), actual for items, calculated for bundles |
Supplier Price (Last Delivery) (€) |
The price at which the item was last delivered (in currency) |
Gross Selling Price (€) |
The gross selling price |
Net Selling Price (€) |
The net selling price |
Customer Order Lines
Field |
Description |
Status |
Status of the customer order line (HAL or ANG) |
Order Nr. |
pixi* order number |
Ext. Order Nr. |
Shop order number |
Location |
The location, from which the order should be shipped |
Customer |
Name of a person or company that ordered the item |
Quantity |
Number of ordered items |
Gross Price |
Gross price of the item, including discount (if exists) |
Net Price |
Net price of the item, including discount (if exists) |
Currency |
Currency the item was ordered in |
Payment Type |
Payment type of the order |
Order Date |
The date when the item was ordered |
Special Note |
Comment for the order line |
Picklist Qty. |
Number of items from the order line that are on a picklist |
Picklist Nr. |
The number of the picklist that the order line is on |
On Picklist |
Information if items from this order line are on picklist. Values displayed in this column are None (No items are on picklist), Partially (Not all items from the order line are on a picklist) or All (all items are on picklist). |
Item Prices
Field |
Description |
PRICES FOR THIS ITEM | |
Currency |
The currency the item was ordered in |
Gross Price |
Gross price of the item |
Net Price |
Net price of the item |
Modified |
Update date of this record. |