Site, Inventory table, Site inventory table – IntelliTrack Inventory Management User Manual
Page 262
I
NTELLI
T
RACK
I
NVENTORY
V
8.1
User Manual
236
Site
The Sites Table is the main table where site definitions are stored.
Inventory Table
The Inventory Table is the main table where inventory item definitions,
and part numbers are stored.
TABLE 10.
Site Table
Field Name
Req’d
Data Type
Field Size
Description
SITE
Yes
Text
18
Site
TABLE 11.
Inventory Table
Field Name
Req’d
Data Type
Field Size
Description
ITEM#
Yes/PKey
Text
25
Item Number
QTY
No
Currency
8
Quantity on Hand (Total all
sites)
DESC
No
Text
35
Description
UNIT COST
No
Currency
8
Price Per Unit
CATEGORY
No
Text
15
Category
MINIMUM QTY
No
Currency
8
Minimum Quantity on Hand
MAXIMUM QTY
No
Currency
8
Maximum Quantity on Hand
REORDER QTY
No
Currency
8
Reorder Quantity
ALT_NO
No
Text
25
Alternate Part Number
Item Image
No
Text
255
Image Location for Item
MO_USG
No
Currency
8
Monthly Usage = History/
#Months
COMMENT
No
Memo
-
Comments
UNIT_OF_MEAS
URE
No
Text
15
Unit of Measure
CONVERSION
No
Currency
Conversion Factor
2287.book Page 236 Thursday, July 7, 2011 4:45 PM