Manual

INTELLITRACK CHECK IN-OUT V7.0
User Manual
374
Data Tables
This section contains information about the site, inventory, inventory by
location, bin location, tbl check, and upload tables.
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 12. Site Table
Field Name Req’d Data Type Field Size Description
SITE Yes Text 18 Site
TABLE 13. 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
2283.book Page 374 Thursday, July 9, 2009 11:26 AM