IntelliTrack Inventory Management User 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