Field

Description

True Cost

If the item is being purchased, this is the purchase cost

Base Cost

This is the cost that pricing is based off of

Average Cost

Average of true cost calculated over time based upon true cost at the time of receipt into inventory

Last Costs 1 & 2

The last two true costs of the item at the time of receipt

Total $ on Hand

Quantity on hand multiplied by average cost

Qty Last Received

Quantity last received or stocked

Date

Date of last receipt

On Invoice #

Invoice number for last receipt

Min

Minimum desired stocking level

Max

Maximum desired stocking level

Reorder Qty

Minimum reorder quantity

Department

Department where this part is used or sold from

Item Reference

Item can be marked as: Normal, Special Order, Superceded Part

Control Stock

As inventory is added or sold, maintain the available and on-hand quantity

Alternate Parts

Indicates whether alternate parts have been specified

Qty Pricing

Indicates whether quantity price breaks have been established

Track S/N

Indicates whether serial numbers are to be tracked for this item at the time of sale

EPS Update

Indicates whether this item can be updated when a price update file is processed

Omit from OS

Indicates whether this item is be omitted from Inventory Price Sheet report [M-L-F1-F1]

Tax Exempt

Is this item exempt from taxes?

Item is Active

Inactive will not appear on picklists

Discountable

Indicates whether an item may be discounted or not

Item is BOM

Indicates whether the item is a BOM; once the item has been created, it will be automatically marked to a BOM

Manuf Part #

PLC and Part # that are used by the manufacturer

Unit Weight

Weight of the part

Size

Box dimensions for shipping

List Price

List selling price

UPC Code

Universal product code as specified in the UPC barcode

Sell-Up

A reminder to the salesperson that will appear when creating a sales order with them item

Long Desc

A longer description of the part