IntelliTrack Check In/Out - Manual (Page 428)

I NTELLI T RACK C HECK I N -O UT V 8.1
User Manual
398
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 11. Site Table
Field Name Req’d Data Type Field Size Description
SITE Yes Text 18 Site
TABLE 12. 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 398 Thursday, July 7, 2011 2:29 PM