IntelliTrack Inventory Management - Manual (Page 152)

I NTELLI T RACK I NVENTORY V 8.1
User Manual
126
• Qty
• Description
• Unit Cost
• Category
• Minimum Qty
• Maximum Qty
• Reorder Qty
• Alt_No.
If the Item number already exists, it will be updated. After the data is
imported into the system, enter the site, location and inventory quantity
data manually.
TABLE 6. Import and Export Fields
Field
Order Field Name Required
Data
Type
Field
Size Description
1 ITEM# Yes Text 25 Item Number
2 QTY No Currency 8 Quantity on
Hand
(Total all sites)
3 DESC No Text 32 Description
4 UNIT
COST No Currency 8 Cost Per Unit
5 CATE-
GORY No Text 15 Category
6 MINIMUM
QTY No Currency 8 Minimum
Quantity on
Hand
7 MAXIMUM
QTY No Currency 8 Maximum
Quantity on
Hand
8 REORDER
QTY No Currency 8 Reorder Quan-
tity
9 ALT_NO No Text 25 Alternate Part
Number
2287.book Page 126 Thursday, July 7, 2011 4:45 PM