Data tables, Site, Inventory table – IntelliTrack Check In/Out User Manual
Page 428: Data tables site inventory table
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