Site, Inventory table, Site inventory table – IntelliTrack Stockroom Inventory User Manual
Page 314
I
NTELLI
T
RACK
S
TOCKROOM
V
8.1
User Manual
286
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 Quan-
tity on Hand
MAXIMUM QTY
No
Currency
8
Maximum Quan-
tity on Hand
REORDER QTY
No
Currency
8
Reorder Quan-
tity
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
2289.book Page 286 Thursday, July 7, 2011 5:10 PM